Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: list space free in tablespaces.

    Hi Gurus,

    I am using DB2 9.5 on AIX 6.1 and i want to know in tablespaces what is the spaces free?

    Thank you for advanced.

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    db2 list tablespaces show detail

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Hi,

    Thank you for you answer, when i execute db2 list tablespaces show detail, in free pages show me not applicable. ¿What mean this?

    Páginas totales = 895
    Páginas utilizables = 895
    Páginas utilizadas = 895
    Páginas libres = No aplicable

    The objetive of this thread is to do a script for know the space free in all tablespaces of database.

    greetings.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    System-managed tablespaces (SMS) do not preallocate space - they can grow as large as the filesystem allows, so "free space" really depends on how much space is available on disk. Use OS utilities (e.g. df) to obtain this information.

    You could also use the administrative views SYSIBMADM.SNAPCONTAINER and SYSIBMADM.CONTAINER_UTILIZATION

Posting Permissions

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