Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: db2pd - tablespaces

    Hi all,

    Version : DB2 10.1 on RHEL

    Can any body suggest what the Column "Auto" is describing in below output.


    db2pd -d dbmstc -tablespaces

    Tablespace Configuration:
    Address Id Type Content PageSz ExtentSz Auto
    0x575265A0 0 SMS Regular 4096 32 Yes
    0x5752ED00 1 SMS SysTmp 4096 32 Yes
    0x57539480 2 SMS Regular 4096 32 Yes
    0x57543C00 3 SMS Regular 4096 32 Yes
    0x5754E900 4 SMS SysTmp 4096 32 No
    0x57559650 5 SMS Regular 32768 32 Yes
    0x57564D40 6 DMS Large 32768 32 Yes
    0x5756D4A0 7 SMS UsrTmp 4096 4 No
    ACE


    thanks and regards
    sumit
    ssumit

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Automatic storage characteristic of tablespace

  3. #3
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Sorry db2mor, but its not that. Automatic storage is indicated by column "AS" as below:

    Tablespace Autoresize Statistics:
    Address Id AS AR InitSize IncSize
    0x575265A0 0 No No 0 0
    0x5752ED00 1 No No 0 0
    0x57539480 2 No No 0 0
    0x57543C00 3 No No 0 0
    0x5754E900 4 No No 0 0
    0x57559650 5 No No 0 0
    0x57564D40 6 No Yes 0 -1
    0x5756D4A0 7 No No 0 0

    please suggest

    sumit
    ssumit

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    No, it's about AUTOMATIC prefetch size (yes or no).

    See the description of:
    db2pd -tablespaces
    Regards,
    Mark.

  5. #5
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    thanks Marv
    ssumit

Posting Permissions

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