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.

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.