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

    Unanswered: Pages without use in tablaspaces

    Anyone can explain to me the way to know the fact sheet for use in an tablespaces in db2 v8?

    How to translate this?
    Thank you

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Your question is not clear. Please try asking it again. Do you need to know how to identify if there are any free pages in the tablespace?

  3. #3
    Join Date
    Aug 2011
    Posts
    45
    If I got ur question right, You can try below:
    db2 list tablespaces show detail:


    Tablespace ID = 19
    Name =TBSP
    Type = System managed space
    Contents = Any data
    State = 0x0000
    Detailed explanation:
    Normal
    Total pages = 11625201
    Useable pages = 11625201
    Used pages = 11625201
    Free pages = Not applicable
    High water mark (pages) = Not applicable
    Page size (bytes) = 8192
    Extent size (pages) = 32
    Prefetch size (pages) = 32
    Number of containers = 1
    Minimum recovery time = 2009-02-17-18.34.51.000000

    Then look for used pages and usable pages, the difference is the no. of free pages in tablespaces...

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Type = System managed space
    Used pages = 11625201
    Free pages = Not applicable
    I don't see any free pages ?? sms !!
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Aug 2011
    Posts
    45
    There wont be any free pages in SMS table spaces, as pages are allocated by DBM as per the requirements. In this case Usable Pages= Used Pages.
    If you elaborate the requirement for the same. May be someone can help the cause.

    Regards,
    Harsh V

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    can you indicate the problem / message as I don't see any question ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Nov 2011
    Posts
    2

    DB2 help

    I have some questions about tablespace and Buffepool.

Posting Permissions

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