By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

Query regarding Snapshot API

P: n/a
Hi,

I have gone through the snapshot API. I need to use it for finding
location of database files, tablespace containers etc on a remote
machine. These parameters are present in the response. However, for
getting only some paramters, I get a huge response, with many
parameters that I do not need (mostly many are performance parameters).
How long can the snapshot response be, and can it considerably affect
performance?

Thanks in Advance,
Tejas

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Tejas wrote:
Hi,

I have gone through the snapshot API. I need to use it for finding
location of database files, tablespace containers etc on a remote
machine. These parameters are present in the response. However, for
getting only some paramters, I get a huge response, with many
parameters that I do not need (mostly many are performance parameters).
How long can the snapshot response be, and can it considerably affect
performance?


You could use the snapshat table functions and query those with SQL. That
allows you to filter out only those information you are really interested
in.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2

P: n/a
Knut,

Thanks a lot dor the reply. I can use these tables, but sadly there are
only available after version 8.1. For earlier versions, I need to use
the API's. I just wanted to know what is the average size of snapshot
data returned( is it in order of KB's or MB's ?)

Thanks,
Tejas

Nov 12 '05 #3

P: n/a
That all depends on the size of your system and the limiting parameters
you pass to the snapshot API (ie, for only this
application/database/etc). There is no way to answer this question, as
it is totally dependant on your system and intended monitor query.

The snapshot APIs do include a sizing function (GetSnapshotSz, or
something like that) that you call exactly how you'd call the snapshot
API, but it will return the estimated size of memory required for the
snapshot in question. Please read the monitor documentation for more
details.

Tejas wrote:
Knut,

Thanks a lot dor the reply. I can use these tables, but sadly there are
only available after version 8.1. For earlier versions, I need to use
the API's. I just wanted to know what is the average size of snapshot
data returned( is it in order of KB's or MB's ?)

Thanks,
Tejas

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.