db2 tablespace

[Former Member]

hi

i hope i put the doubt in right db6 forum this time..im new to db2 im monitoring db2 daily on sap, but daily i see tablespaces 99% in db02 tcode. i have to increase tablespace, pls help me

[Former Member · Accepted solution]

but daily i see tablespaces 99% in db02 tcode. i have to increase tablespace, pls help me

Hello,

Did you try to browse through the documentation (SAP/IBM DB2 UDB) to check how to extend the tablespaces in DB2 ?

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdo...

http://www.performancewiki.com/extend-db-tablespace.html

But once check if the tablespaces are already autoextend enabled. Are only one or two tablespaces full or almost all shown there in DB02 ? In case these are of type automatic storage then no need to extend the tablespace and we just have to extend the file system if no space is there at OS level.

Thanks

[former_member182505 · Accepted solution]

Hi

please check you data file ..filesystem if there is enough space extent it.

if auto extent mode is enable you don't have to worry.

i suggest go throug the doc and do proper anlysis.

thanks

sadiq

[Former Member · Accepted solution]

hi

how i know tablespaces in autoextend, pls help me

[Former Member · Accepted solution]

hi

i see container column, this is data files ? pls help me

[Former Member · Accepted solution]

Hello,

Do you monitor the DB using DB02 ? If yes, you must be able to see whether the tablespaces are in autostorage or not.

We go to DB02 --> Tablespaces --> There we can see two tabs - 1. Automatic Storage 2. DMS/SMS tablespaces

Tablespaces under automatic storage are autextend enabled. Are these the ones which are 99% ?

For your data files query -

datafile concept doesn't exist in DB2. But yes, you should monitor the sapdata folders i.e. file systems /db2/SID/sapdata* which contain physical containers. Please read -

http://www.ibm.com/developerworks/data/library/techarticle/0212wieser/

Thanks

[former_member182505 · Accepted solution]

hi

i will add some point for your understanding

DB02 --> Tablespaces --> There we can see two tabs - 1. Automatic Storage 2. DMS/SMS tablespaces

click on change

here in technical settings you can find the AUTORESIZE Enable ... check this whether its enable or not.

thanks

sadiq

[Former Member · Accepted solution]

hi

i check /db2/PRD/sapdata1, /db2/PRD/sapdata2, /db2/PRD/sapdata3 are 20, 18, 25 gb free, yes you right tablespaces are under automatic storage i check it. pls tell me sapdata are ok ? pls help me

[Former Member · Accepted solution]

Hello,

The free space is OK but not quite enough for Production, but depends on total size etc. If possible, please keep more space in sapdata* file systems. What's the total size of DB, how much % these file systems are free, if you can paste the total size of filesystem as well.

Thanks

[former_member182505 · Accepted solution]

hi

i think its enough

please monitor you DB growth if its not much then ok...

whenever it will reach more than 90% you need to take care and extend the file system

thanks

sadiq