Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    13

    Unanswered: Tablespace TSASNUOW Hits Max Allocated Size

    Hi DB2 Experts,

    I am getting error regarding tablespace 'TSASNUOW' hits max allocated value. I only know this tablespace is related to DB2 replication process.

    My question is, what are the available options that I could do other than increasing the tablespace size?

    I am not a DB2 admin and struggling to solve this issue. Hope to get some answer here.


    Thank you.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What's the exact error message you're getting? Please include the output from "db2pd -d <database name> -tablespaces"

  3. #3
    Join Date
    Nov 2007
    Posts
    13
    Hi BELLO4KA,

    Sorry for the late reply. Below are the requested information.

    Database Partition 0 -- Database STUDENT -- Active -- Up 0 days 23:56:26 -- Date 06/13/2011 11:56:28

    Tablespace Configuration:
    Address Id Type Content PageSz ExtentSz Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
    0x07FEE570 7 DMS Any 4096 32 0 1 1 On 1 0 31 TSASNUOW

    Tablespace Statistics:
    Address Id TotPages UsablePgs UsedPgs PndFreePgs FreePgs HWM State MinRecTime NQuiescers
    0x07FEE570 7 57344 57312 57312 0 0 57312 0x00000000 1283589799 0

    Tablespace Autoresize Statistics:
    Address Id AS AR Auto InitSize IncSize IIP MaxSize LastResize LRF
    0x07FEE570 7 No No No 0 0 No 0 None No

    Containers:
    Address TspId ContainNum Type TotalPages UseablePgs StripeSet Container
    0x07FEEB70 7 0 File 57344 57312 0 C:\DB2\NODE0000\SQL00001\TSASNUOW

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Your options are: delete some old data from the table(s) stored in this tablespace, if you know what can be purged, or increase the tablespace size. This tablespace is small so why don't you just increase it for now. You can also enable autoresize for this tablespace so that db2 will automatically increase it when it's full.

  5. #5
    Join Date
    Jun 2011
    Posts
    4

    Wink

    DELETING THE DATA FROM THE TABLES IS NEVER A MEANINGFUL SOLUTION COZ DATA IN SOME TABLES SHOULD BE RETAINED FOR A LONGER PERIOD.

    THE ALTERNATE SOLUTION WOULD TO ENABLE THE TABLESPACES TO AUTOEXTEND, USE THE BELOW COMMAND TO EXTEND ALL THE DMS TABLESPACES TO AUTOEXTEND.

    db2 -tx "select 'alter tablespace '||TBSPACE||' autoresize yes increasesize 500m maxsize none;' from syscat.tablespaces where TBSPACETYPE='D'"> autoextend.sql

    Whenever a particular tablespace get full, automatically the Tablespace gets increased.

    The value 500M is the size we increase in our DB's, kindly set the size based on your requirement.

Posting Permissions

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