SAP* Missing after installation in EHP5

[former_member1334776]

Hi,

I just completed installing ECC6.0 with EHP5 , NetWeaver7.0 on suse linux 11 SP2and DB2 9.7. However I am trying to logon to system using sap* on client 000 I can not. I logged in with DDic user and when looking for SAP* user in su01, User sap* dose not exist. Can you tell me if I should copy the DDIC to SAP*? or any note that can help me resolve this issue.

As new to DB2 can you provide commands.

Regards,

Thamu

[premsukh_bishnoi · Accepted solution]

Hi Thamu,

Please do copy of DDIC user to SAP*. Usually it must exist after installation with sap* and standard password. But seems that some how it is missing in your case.

Please read below SCN thread:

http://scn.sap.com/thread/1561227

Best Regards, Premsukh Bishnoi

[former_member1334776 · Accepted solution]

Dear  Premsukh Bishnol,

Thanks for your reply.

I tried in that way but kernel is hard-coded with kernel if i deleted from OS level in DB.It automatically creates with standard password.

can i get command in DB2.

Waiting for your reply.

Thanks,

Thamu

[premsukh_bishnoi · Accepted solution]

Hi Thamu,

DB6 (DB2 UDB for Unix/Linux/Windows)

• Logon to database server
  
       1. switch to db2<sid> user (e.g. db2qnn) under UNIX
  
       or
  
       2. logon as <sidadm> under Unix/Windows
• Start the SQL mode with command:
  
       db2 (Unix)
  
       db2cmd (Windows)
  
       Now you're able to execute SQL statements (on Windows: db2 in
       front of the SQL statement):
• to view the entries of the
       "sap*" user type in following command:
  
       select * from
       <db_schema>.usr02 where mandt = '000' and bname = 'SAP*' (maybe
       you have to change "mandt" to your client)
• to delete the "sap*"
       user type in the following commands:
  
       delete from
       <db_schema>.usr02 where mandt = '000' and bname = 'SAP*' (maybe
       you have to change "mandt" to your client)
  
       commit;
• quit
  
       Find out existing schemas: select
       * from syscat.dbauth
  
       Now you can logon to the system as user "sap*" with standard SAP
       password 'pass'

I hope this hepls.

Regards, Premsukh Bishnoi