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

snapshot on all db partitions

P: n/a
Is there anyway to display the partition number while taking snapshot
on all the partitions (-2) using the snapshot function?

ex,

select TABLESPACE_NAME, TOTAL_PAGES from table(SNAPSHOT_TBS_CFG ( ' ',
-2 )) as snap.

Is there anyway, I can get the partition number for which the data is
being retrieved?.

ie, I would like to see something like,

select dbpartitionnum(), TABLESPACE_NAME, TOTAL_PAGES from
table(SNAPSHOT_TBS_CFG ( ' ', -2 )) as snap.

Note: Joining with other table functions are OK. I have other ways to
get the desired result(either I have to use db2_all or need to get
snapshot for each paritions, which involves sending more requests).

Thanks,
Prince.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
When you take a global snapshot, the data is aggregated together...(the
tablespace data for example is the aggregate for all nodes where that
tablespace exists)...

Prince Kumar wrote:
Is there anyway to display the partition number while taking snapshot
on all the partitions (-2) using the snapshot function?

ex,

select TABLESPACE_NAME, TOTAL_PAGES from table(SNAPSHOT_TBS_CFG ( ' ',
-2 )) as snap.

Is there anyway, I can get the partition number for which the data is
being retrieved?.

ie, I would like to see something like,

select dbpartitionnum(), TABLESPACE_NAME, TOTAL_PAGES from
table(SNAPSHOT_TBS_CFG ( ' ', -2 )) as snap.

Note: Joining with other table functions are OK. I have other ways to
get the desired result(either I have to use db2_all or need to get
snapshot for each paritions, which involves sending more requests).

Thanks,
Prince.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.