DB2 Table space

[Former Member]

Hi,

Database is db2 9.1 LUW on a windows 2008.

In db02 i can see table spaces are 99.72 % used.

1.When sap installed,automatic storage table spaces enabled.I have enough space in file system.so when the table spaces will be increased automatically?..after 100%? or do 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?iam worried server will hang.so i understand that we dont want to monitor table spaces if automatci is enabled?

2.In oracle mainly PSAPSR3 and PSAPSR3700 will be used mainly.ie if we want to to client copy etc..we increase these two tbale spaces mostly.like this in DB2 which table space is used mostly.

Thanks

[former_member524429]

Hi,

1. When sap installed,automatic storage table spaces enabled.
I have enough space in file system. So when the table spaces will be increased automatically?
..after 100%? or do i need to do any thing manually.

The Table space with "AUTORESIZE Enabled" and "AutoStorage" option will grow automatically based on the Available Space on the File System. No need to Extend Tablespace manually, as the table space expands automatically by extending or acquiring containers, as needed, to increase the table space size until the file systems are full.

You can refer this useful document "[Database Administration Guide SAP on IBM DB2 for Linux, UNIX, and Windows|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f03d5fb8-b619-2b10-c383-c6d56872829e&overridelayout=true]" to get more information regarding the DB2 Administration.

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?

Yes.

i am worried server will hang.so i understand that 
we dont want to monitor table spaces if automatci is enabled?

It comes under daily routines of BASIS Admin or DBA to administrate the DB Space weather the TSpace is with AutoStorage/Autoresize or not. With AutoStorage and AutoResie enabled feature the administration efforts are minimized.

2.In oracle mainly PSAPSR3 and PSAPSR3700 will be used mainly.ie if we want to to client copy etc..
we increase these two tbale spaces mostly.like this in DB2 which table space is used mostly.

In DB2

For BASIS ABAP Schema

<SAPSID>#ES<REL> (Dev. Environment Sources)

<SAPSID>#EL<REL> (Dev. Environment Loads)

<SAPSID>#STAB (Master data)

<SAPSID>#BTAB (Transaction data)

For BI ABAP Schema

<SAPSID>#ODS (ODS, PSA tables)

<SAPSID>#DIM (Dimension tables)

<SAPSID>#FACT (InfoCube and Aggregate fact tables)

For BASIS Java Schema

<SAPSID>#DB (Tablespaces for Java Stack)

You can refer this useful document "[DB2 Database Layout and Configuration for SAP NetWeaver based Systems|http://www.evermeet.cx/public/presentations/SAP_DB2_Storage_Layout.pdf]" to get more information.

Regards,

Bhavik G. Shroff