How to check status of tablespace and extend tablespace in DB2 with ERP 6 ?

[Former Member]

Dear all ?

My OS : RHEL 5.4 64bit

I have installed ERP 6.0 EHP4 with DB2 V9.1 FP7

But i also want to know status: Used space 100% in tab "Database and Tablespace" via tcode DB02. What happen with this status ? and I need to do to remedy this situation.

In process installation with sapinst. I choice two options below :

+ Create tablespace during installation process

+ Use Auto Storage Management for tablespace

I think that with these choice, Tablespace can be expanded automatically-> can not be filled !!!

Please guide me to know the exact status of the Tablespace -> full or not full ?

How to extend tablespace in DB2 when tablesapce become full.

I may not have experience in checking the status Tablespace !

[Former Member · Accepted solution]

Dear !

But i also want to know status: Used space 100% in tab "Database and Tablespace" via tcode DB02. But with Tode DB13 (Tcode DB13 -> Space menu -> Tablepsace : I saw status 98.65%). What happen with these status ? two status differ

i need to do any thing manually.I kept reading in the post saying we dont want to do any thing manullay as automatic storage is enabled.keeping automatic is best option? i am worried server will hang.so i understand that we dont want to monitor table spaces if automatci is enabled?

Please guide me to know the exact status of the Tablespace -> full or not full ?

Please guide me to know the exact Autoresize properties of tablespace -> tablespace with Autoresize or non-Autoresize ?

Thanks all

[paul_power · Accepted solution]

Hello,

The details for waht is enabled for each tablespace can be found by running the command:

db2 list tablespaces show detail

db2 get snapshot for tablespaces on <SID>

this will show you the tablespace, if they are SMS or DMS tablespaces, whether they are using aoutmatic storage and auto resize or not.

Please find information in:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.dbobj.do...

I would say there's a problem if the tablespace is not increased while

there's enough space available

Tablespace extension is controlled by Parameters INCREASESIZE ,

(also MAXSIZE but this is usually not used in SAP Environments ) .

Depending on Increasesize , the tablespace is increased using this

amount of storage .

If the tablespace reaches 100% filling grade , it is extended

automatically (therefor "Auto"-resize ) . You just need to monitor

freespace in the filesystems for the tablespaces to have enough space

for enlarging the containers available .

Please recheck for the tablespaces displayed with nearly 100% ,

whether there are still free pages using an tablespace snapshot

db2 get snapshot for tablespaces on <DBSID>

If you want to move some large tables to a new tablespace to free space,

please see the following SAP Notes

136702 DB6: Move tables to other DB2 tablespaces

362325 DB6: Table conversion using DB6CONV

543897 FAQ: DB2/UDB Tablespaces

and move the largest table[s] to an new Tablespace using DB6CONV .

Also consider using an larger Pagesize for the target tablespaces .

[Note : Then also the bufferpool needs to exits supporting this pagesz]

Please use the LATEST Version of DB6CONV tool .

Regards,

Paul

[sunny_pahuja2]

Hi,

Check below link for tablespace information in DB2:

http://help.sap.com/saphelp_470/helpdata/en/3d/da4d3c9bc34800e10000000a114084/content.htm

Thanks

Sunny