SQL to find list of the tables in a particular chunk

Question

SQL to find list of the tables in a particular chunk

Answer

To obtain a list of the tables in a particular chunk, below sql can be used:
select dbinfo( "DBSPACE" , pe_partnum ) dbspace,

dbsname[1,12],

tabname,

pe_chunk,

pe_offset start,

pe_size size

from sysptnext, outer systabnames

where pe_partnum = partnum

and pe_chunk = <chunk number>

order by start, dbsname, tabname;

Replace chunk number with the number of the chunk for which you want to list the table names.

http://www-01.ibm.com/support/docview.wss?uid=swg21661265&myns=swgimgmt&mynp=OCSSGU8G&mync=E