hi can any one help out with the useful db2 commands useful for sap

[sreekanth_sunkara]

hi

Can i know the different types of tools used in db2 for database administration

can i know the useful commmands used for database administration in SAP

particularly on AIX

for tunning buffers

creating table space

increasing table space

altering

backup and recovery

deleting table space

any help would be a great to me

Thanks,

sree

[Former Member · Accepted solution]

Hi Sree

for database administration you can use

CLP(Command Line Processor)

CCMS

Control Center .

see

<a href="ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/letter/en_US/db2s2e90.pdf">DB2 Version 9 for Linux, UNIX, and Windows : SQL Reference Vol. 2</a>

for all the

create|alter|drop  tablespace|bufferpool

statements

and

<a href="ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/letter/en_US/db2n0e90.pdf">DB2 Version 9 for Linux, UNIX, and Windows : Command Reference</a>

as well as

<a href="ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/letter/en_US/db2hae90.pdf">DB2 Version 9 for Linux, UNIX, and Windows : Data Recovery and High Availability Guide and Reference</a>

for backup and recovery .

Furthermore you should take a look into the SAP Database Administration Guide for DB6 [available from SAP Service Marketplace ] .

and the following IBM Redbook

<a href="http://publib-b.boulder.ibm.com/abstracts/sg246765.html?Open">SAP Solutions on IBM DB2 UDB V8.2.2 Handbook</a>

regards dirk