I have the following query I do not get back all containers from all
partitions. I did not get any containers back from part one, two or three,
but I got containers back from partition 0 and 99. I have 99,0,1
partitions all on same box where has part two and three are on separate
box. In manual it indicates the -2 should bring back all parts. Thanks in
advance for any help.

select substr(tablespace_name,1,16)as tbspace_name, container_id,
substr(contain
er_name,1,30) as container_name, stripe_set from
table(sysproc.snapshot_contain
er('dssdev01',-2)) as container_info order by 1;

Thanks
Steve Morrison


-----------------------------------------
The information in this message may be proprietary and/or confidential,
and protected from disclosure. If the reader of this message is not
the intended recipient, or an employee or agent responsible for
delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify First Data immediately by
replying to this message and deleting it from your computer.


DB2 & UDB email list listserv db2-l LazyDBA home page