Can someone point to me a script which lists all the tables present in a specific chunk

Appreciate your help

Hello,

I used the following script to find out I/O for tables. You can modify it according to your convenience.

select fname,
name,
dbsname,
tabname,
pagreads+pagwrites pagtots
from sysptprof,
syschunks,
sysdbspaces,
sysptnhdr where trunc(hex(sysptprof.partnum)/1048576) = chknum
and syschunks.dbsnum = sysdbspaces.dbsnum
and sysptprof.partnum = sysptnhdr.partnum
and (pagreads+pagwrites) != 0
order by 5 desc

Bye

You can also refer to oncheck -pe output