DB2 Tablespace Management

[Former Member]

HI All

Can anyone pls let us know how to perform Tablespace Management in DB2,like increasing tablespace and adding datafile..etc.

Can it be done in SAP through DB02 Tcode if so how to do it,???

also how to do it through DB2 from OS level.

Thanks in Advance

Infinite Team

[Former Member]

Hi All

We noticed that BTABD was hundred percent and now database is not coming up and from operating system level if we login and try to increase the tablespace through sql command it says:

"DB21034E The command was processed as an SQL statement because it was not a

valid Command Line Processor command. During SQL processing it returned:

SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030"

Not only that any command we execute it gives same error message and if we start sap it says Activate Database Failed, R3trans Connect Failed, Database start up failed

Pls help.

Thanks in Advance

Infinite Team

[Former Member]

you can't run sql query if database is not up. however, are you sure that database is down only because of that full tablespace ? check the logs to find the reason first

[Former Member]

Hi

Refer to http://help.sap.com/saphelp_nw04/helpdata/en/3d/da4d3c9bc34800e10000000a114084/frameset.htm

Rohit

[Former Member]

Hi

Refer to http://sapbasis-security.blogspot.com/2008/06/sap-on-db2-for-linux-unix-and-windows.html

This may be helpful

Rohit

[Former Member]

Hi Rohit

Thanks for the answer but want to know how to resize the tablespace how to do that.

Thanks in Advance

Infinite Team

[Former Member]

Hi

Refer to http://help.sap.com/saphelp_nw04/helpdata/en/3d/da4d3c9bc34800e10000000a114084/frameset.htm

Rohit

[Former Member]

you can do this from OS level, and always extend all the containers, see example 5 in Alter tablespace

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

[Former Member]

There are two ways to do it.

1. At OS level using DB2 parameters

2. You can also use DBA cockpit

Thanks!