Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2010
    Posts
    10

    Unanswered: Regarding Tables info

    How to Calculate the following

    1. Collect the details of TOP Ten Tables based upon the Size.

    2. Collect the details of TOP Ten Tables based upon the Row Count.

    3. Collect the details of TOP Ten Tables based upon the Recent Usage.

    4. Collect the details of TOP Ten Tables based upon the Not Used Recently.

  2. #2
    Join Date
    Sep 2010
    Posts
    10

    reply

    Whether the data is available from db2pd or event monitor or snapshot tool

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    1 and 2 is available in sysstat.tables - based on last runstats

    what do you mean by 'top 10 based on recent usage' ? is the the most recent accessed tables ?
    If using 9.7 see if lastused column is what you are after. note, last used column is not current but is based on a recent update by db2.

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Sep 2010
    Posts
    10
    Thanks for Ur info.. Point 3 and 4 are recently used tables and unused tables...

    Since i am little new to DB2..May i Get the procedure to get the data for all points???

  5. #5
    Join Date
    Sep 2010
    Posts
    10
    In Our Database , they are nearly 20,000 tables are there at present. How to get top 10 tables and row count for tat tables???

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    OK, let me repeat

    1 and 2 is available in sysstat.tables , card column. This column is updated by the runstats command and therefore this value is correct at the time of collecting stats(runstats command)

    3 and 4 - if using 9.7, it is available in lastused column of syscat.tables.This time specified in the column is not guaranteed to be correct - the update to the column occurs later and not immediately following the event.If using earlier versions of db2, afaik, there is no place where last used is stored.

    I hope I have provided you with enough information to help you find the information you want.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Sep 2010
    Posts
    10
    Thanks a lot dude....


    I got all data with ur help........

  8. #8
    Join Date
    Sep 2010
    Posts
    10
    Hi Sathyaram,

    Can u help me in tis,

    1. Collect the details of Agent IDs by Top 10 CPU Usage
    2. Collect the Statements executed by those Agent IDs
    3. Collect the details of Top 10 Tablespace Containers based on Highest Read time.



    Thanks in advance

    Bala

Posting Permissions

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