Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557

    Unanswered: What feeds get_dbsize_info

    Morning,

    I have been trying to find how get_dbsize_info function calculates db size. Does it read the catalog table and in this case how does it deal with the tables that haven't had runstats collected on? Or does it read file system?

    Thank you.

    8.2 aix 5.1
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Seems it takes information from the TABLESPACE details. Like the USEDPAGES/PAGESIZE.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    IIRC, it takes information from some SYSPROC table functions/Procedures ...

    What I would suggest is to create a event monitor - write to table and capture the SQL Stmts and package sections when you execute your dbsize_info procedure ... If there are static SQLs in the event monirot output, join the table with SYSCAT.STATEMENTS table to find the statements ..

    Apart from the SQL statements, there could be more processing done in the Stored Proc 'ouside SQL'

    Cheers
    Sathyaram

    Quote Originally Posted by Cougar8000
    Morning,

    I have been trying to find how get_dbsize_info function calculates db size. Does it read the catalog table and in this case how does it deal with the tables that haven't had runstats collected on? Or does it read file system?

    Thank you.

    8.2 aix 5.1
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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