on 08-26-2015 4:05 PM
Hi Team,
I'm newly into DB2, So could you please share me useful DB2 Commands into Sap Basis.
Regards,
Vijay
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.