SAP* in DB2 Databse & os400

[Former Member]

Hi,

Can any one help me, how to rest sap* user in Table USR02 in DB2 UDB database & AS400 operating system. At pesent i am stuck up in this stage & can not login in 000 client. Its very urgent. Plz help me to solve this issue.

I tried to reset sap* user with delete statement i.e:

delete from SAP* where BNAME="SAP*" & MANDT="000";

its giving me error.is this a right queryor not.

Regards,

Jesal

[bernd_kohler]

Hi,

this is a topic that should not be discussed in a public forum. I recommend to open a customer message to resolve the issue.

Best Regards,

Bernd.

[dorothea_stein]

Hi Bernd,

The SAP* handling is safe, it is officially documented in SAP note 4326.

Best regards,

Dorothea

[Former Member]

Hi,

if you are able to login into other application client in your system then write one zreport with following query.

delete from usr02 CLIENT SPECIFIED where bname = 'SAP*' and mandt = 'XXX'.

replace XXX with 000 .

after execute the report in application client , login with SAP* and password 'pass' in 000

make sure login/no_automatic_user_sapstar parameter have value 0 in your instance profile check with

RZ10.

if not create/change the parameter and restart the sap system.

if you want to execute this query direct to AS400 you need i series navigator.

but query syntax is different.

connect to sap host with i series navigator now expand database and right click on database and click RUN SQl scripts.

now enter following query

DELETE FROM R3<SID>DATA.USR02 WHERE BNAME = 'SAP*' AND MANDT = 000;

where SID is your sap system id

regards,

kaushal

Edited by: kaushal malavia on Feb 25, 2008 5:10 PM