cancel
Showing results for 
Search instead for 
Did you mean: 

Looking for DB2 commands

Former Member
0 Kudos

Hi Team,

I'm newly  into DB2, So could you please share me useful DB2 Commands into Sap Basis.

Regards,

Vijay

Accepted Solutions (0)

Answers (1)

Answers (1)

abhijeet_singh2
Participant
0 Kudos

following 3 i frequently use hence sharing with you

a. Comand to know schema of ABAP Stack

db2 " select tabschema from syscat.tables where tabname = 'SVERS' "

b.  select and delete sap*

db2 "select bname ,mandt from sap<sid>.usr02 where bname='SAP*'"

db2 "delete from sapsol.usr02 where bname='SAP*'

c.  know the concept of DB manager or DBM and its difference with an DB instance. rest all is just like oracle.

d. reference