Tablespace TSASNUOW Hits Max Allocated Size

muklee · #1 (**permalink**) 06-12-11, 00:48

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.

db2girl · #2 (**permalink**) 06-12-11, 12:06

What's the exact error message you're getting? Please include the output from "db2pd -d <database name> -tablespaces"

muklee · #3 (**permalink**) 06-13-11, 00:11

Hi BELLO4KA,

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

Quote:

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

db2girl · #4 (**permalink**) 06-13-11, 20:10

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.

vinubaby · #5 (**permalink**) 06-14-11, 01:55

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech