Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    9

    Unanswered: Flummoxed - Tablespace autoresize

    I specified this when creating some tablespaces;

    Does anybody know where autoresize, increasesize, and maxsize it is stored, Id' imagine in the catalog but where.

    - John H

    db2 udb fp11 on aix

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Methinks it is in /home/db2inst1/db2inst1/NODE0000/SQL00001/SQLSPCS.1 (and .2)
    mota

  3. #3
    Join Date
    Mar 2003
    Posts
    343
    try a db2look for tablespaces ( I think it's the -l option)> Do post and let us know if this worked.

    I haven't seen this in the table function snapshot_tbs_cfg.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    $ db2 get snapshot for tablespaces on test
    ...
    Tablespace name                            = TEST
    
    ...
      Using automatic storage                  = Yes
      Auto-resize enabled                      = Yes
    ...
      Initial tablespace size (bytes)          = 10485760
      Current tablespace size (bytes)          = 10485760
      Maximum tablespace size (bytes)          = 104857600
      Increase size (percent)                  = 10

Posting Permissions

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