1.进入db2
su - devadm
db2
===============================================================
select * from sapcpc.usr02;
select * from sapcpc.usr02 where BNAME= 'SAP*';
select * from sapcpc.usr02 where BNAME= 'SAP*' and MANDT='000';
delete from sapprd.usr02 where BNAME= 'SAP*' and MANDT='000';
SQL> delete from sapcpc.usr02 where BNAME= 'SAP*' and MANDT='000';
1 row deleted.
SQL> commit;
Commit complete.
重启系统后的登录名和密码为:
sap* / pass
注:开发机用户在表sapdev.usr02中,生产机在sapcpc.usr02中
==============================================================
sap系统关停:
su - devadm
关闭系统: sapstop
启动系统: sapstart
su - devadm
db2
===============================================================
select * from sapcpc.usr02;
select * from sapcpc.usr02 where BNAME= 'SAP*';
select * from sapcpc.usr02 where BNAME= 'SAP*' and MANDT='000';
delete from sapprd.usr02 where BNAME= 'SAP*' and MANDT='000';
SQL> delete from sapcpc.usr02 where BNAME= 'SAP*' and MANDT='000';
1 row deleted.
SQL> commit;
Commit complete.
重启系统后的登录名和密码为:
sap* / pass
注:开发机用户在表sapdev.usr02中,生产机在sapcpc.usr02中
==============================================================
sap系统关停:
su - devadm
关闭系统: sapstop
启动系统: sapstart