Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    237

    Unanswered: V8 Tablespace Utilization

    How does one get V8 Tablespace Utilization? Control center on V8FP3 DB does not give Size used, Allocated size,percentage used, maximum ever used as was given in V7 DB? Which system table has these values? Does anybody have an equivalent SQL?
    mota

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    If your tablespace is DMS, use this command "list tablespaces show detail", else, view the space in the folder in win.

    For explample:
    SMS:
    ------------------------------------------------
    db2 => list tablespaces show detail

    Tablespaces for Current Database

    Tablespace ID = 0
    Name = SYSCATSPACE
    Type = System managed space
    Contents = Any data
    State = 0x0000
    Detailed explanation:
    Normal
    Total pages = 11661
    Useable pages = 11661
    Used pages = 11661
    Free pages = Not applicable
    High water mark (pages) = Not applicable
    Page size (bytes) = 4096
    Extent size (pages) = 32
    Prefetch size (pages) = 16
    Number of containers = 1
    --------------------------------

    for DMS:
    ----------------------------------
    Tablespace ID = 5
    Name = TBATTRIB
    Type = Database managed space
    Contents = Any data
    State = 0x0000
    Detailed explanation:
    Normal
    Total pages = 7680000
    Useable pages = 7679920
    Used pages = 295248
    Free pages = 7384672
    High water mark (pages) = 6144016
    Page size (bytes) = 4096
    Extent size (pages) = 16
    Prefetch size (pages) = 8
    Number of containers = 5
    -----------------------------


    Abel.

Posting Permissions

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