Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Posts
    16

    Unanswered: Space calculation

    Hi there,

    I need to calculate space(together primary + secondary) with which TS was defined that also has 200+ partitions.

    No matter if it is a segmented/simple/partitioned. I just want total space together primary+secondary.

    Can somebody guide me where could I get this information from in catalog tables?

    I tried in SYSIBM.SYSTABLESPACE - COLUMN SPACE, that does not give accurate results.

    Steve Wawzynzak

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Try looking at the stospace utility.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2008
    Posts
    16
    Marcus,

    Thanks!

    These are the PROD tables I am talkin about... is there any other way out?

    Steve Wawzynzak

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't understand your concern. The DB2 STOSPACE utility determines the amount of space allocated for DB2 storage groups and their related table spaces and indexes. The utility updates DB2 system tables with the information it gathers.

    Output from this utility consists of DB2 updates to the following tables:

    SYSIBM.SYSINDEXES
    SYSIBM.SYSTABLESPACE
    SYSIBM.SYSSTOGROUP

    After STOSPACE execution is complete, use an SQL SELECT to view the tables that STOSPACE changed.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by deadmanthedba
    I need to calculate space(together primary + secondary) with which TS was defined
    DB2 for z/OS?
    If you say "with which it was defined", do you mean "how can I read from the catalog which were 'n' and 'm' ", in
    Code:
    CREATE TABLESPACE USING STOGROUP <name> PRIQTY 'n' SECQTY 'm'
    ?
    Have a look at the two columns PQTY and SQTY in sysibm.systablepart.
    Then multiply those numbers with 4 to obtain 'n' and 'm' respectively.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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