Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2008
    Location
    India
    Posts
    40

    Unanswered: To find the database size of an application

    There is a requirement of finding the database size for an application.
    We can assume that the appln is identified by the high level qualifier in the table name and there are so many applications.

    How to find the database(Db2) size occupied by a particular application?
    Is it possible through any query?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You will need to be more specific. I am assuming that you mean the data generated by the application, not the application itself. There needs to be some record as to which application owns each piece of data. Without that, it would be impossible.

    Andy

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by Neena John View Post
    How to find the database(Db2) size occupied by a particular application?
    Do you need storage space used per schema in a database? Do you know if objects belonging to a particular application use their own tablespaces? If they do, then you can check tablespace usage. If not, you can query sysibm.systables / sysibm.sysindexes. You can also use "reorgchk ... on schema <schema name>". reorgchk with "update statistics" will update statistics prior to returning the results.

  4. #4
    Join Date
    Oct 2008
    Location
    India
    Posts
    40
    How to check the tablespace usage ?

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by Neena John View Post
    How to check the tablespace usage ?
    sysibmadm.snaptbsp_part on recent versions

    db2 list tablespaces show detail

    on any version
    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
  •