Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    207

    Unanswered: DB2 z/OS Query to SYSIBM Catalog to get an overview of all tablespaces and free size

    Dear folks,

    I want to have a query on my db2 z/os system which asks the SYSIBM catalog about all its partitioned tablespaces and its available space on it.

    I found that I could use the sysibm.systablepart table but i dont get along with building the final statement.

    Can you help me through it ? thank you for your support in advance.

    Best regards,

    DB_N00B

  2. #2
    Join Date
    Jan 2010
    Posts
    207
    Maybe the table SYSIBM.SYSTABLESPACESTATS is the better choice for this requirement here ....

Posting Permissions

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