snapshot on all db partitions

[Prince Kumar]

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.

[Sean McKeough]

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.