Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2017
    Posts
    3

    Unanswered: DB2 8 tablespace container sizing .....

    Hi.

    We have a DB2 8 install. I'm trying to find what system table contains container name/size info. I realize I could get that info a number of ways, but I'd like to do it as a select so it's easier to parse the output in a shell script. Can someone tell me what table the container name (physical path to the file that is) and size are contained in. It feels like I've looked in all of them. Thanks.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,140
    Provided Answers: 25
    Which platform? (Z/OS, i-series, LUW ?)
    If the platform is LUW, and if your fixpack level is at least 11 then the V8.x had version-specific views like SYSCATV82.SNAPCONT, SYSCATV82.SNAPTBSPACE, SYSCAT82.SNAPTBSPACECONT - so if these are present you can DESCRIBE them to work out the query. These SYSCATV82 views supposedly gave more accurate results than the equivalent SNAP_GET_CONTAINER, SNAP_GET_TBSPACE etc views which were being introduced in v9.1 around that time.

  3. #3
    Join Date
    Oct 2017
    Posts
    3
    Thanks for the reply.

    db2level shows:

    DB21085I Instance "ipshrdev" uses "32" bits and DB2 code release "SQL08026" with level identifier "03070106".
    Informational tokens are "DB2 v8.1.1.120", "s060801", "U808888", and FixPak "13".
    Product is installed at "/usr/opt/db2_08_01".

    So, at FP13 but I don't see any SYSCAT81 or SYSCAT82 views. Well, these don't work.

    select * from SYSCAT81.SNAPTBSPACECONT
    select * from SYSCAT82.SNAPTBSPACECONT

  4. #4
    Join Date
    Oct 2017
    Posts
    3
    We're running on LUW

  5. #5
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    282
    Provided Answers: 41
    Hi,

    You should have the same function in 8.2:
    https://www.ibm.com/support/knowledg.../r0007102.html
    Regards,
    Mark.

  6. #6
    Join Date
    Apr 2012
    Posts
    1,140
    Provided Answers: 25
    On my old V8.x databases (at fp18) I found 8 views in syscatv82 schema (including syscatv82.snapcont). I also find 25 routines like SNAPSHOT_%, and 8 routines like SNAP_GET_%.
    The v8.1 fp11 release notes documented the SYSCATV82 views and explained their usage. I also found that on old static databases in v8.x the container_name and usable_pages had same values from syscatv82.snapcont and view snap_get_container.
    Your mileage may vary.

  7. #7
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    282
    Provided Answers: 41
    It's good to show the following output:
    Code:
    select versionnumber, version_timestamp from sysibm.sysversions
    Regards,
    Mark.

Posting Permissions

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