Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    27

    Unanswered: Tablespace space problem

    If there are any view or tools to check how many space(MB) left at the tablespace???
    thx very much

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Tablespace space problem

    Depends on what platform you are on ...

    On Unix and Windows,

    db2 list tablespaces show detail

    will give you the result


    Originally posted by chansteve1234
    If there are any view or tools to check how many space(MB) left at the tablespace???
    thx very much
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15

    Re: Tablespace space problem

    Originally posted by sathyaram_s
    Depends on what platform you are on ...

    On Unix and Windows,

    db2 list tablespaces show detail

    will give you the result
    On a host under OS/390 check the VSAM-dataset the tablespace is stored in.

    Under ISPF 3.4 look for the dataset and write a lct before it.
    thean you see the extents.

    Alternative you can do a query on sysibm.systablepart, there you got the information.

Posting Permissions

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