Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53

    Unanswered: Script to find all the tables in a specific chunk

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

    Appreciate your help

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    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

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    You can also refer to oncheck -pe output

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •