ABAP Database User

[Former Member]

Hi

Can somebody help me to over come below issue.

Source system : HOP

Target System : HOQ

Both the systems are running in sap landscape and did data refresh by restoring the HOP db using HP Data protector. The restore was completed and roll forward also completed.

When I try to connect QA system or R3trans getting following message:

hoqadm 22> R3trans -d

This is R3trans version 6.19 (release 720 - 06.04.10 - 16:31:00 with UA1430.1 /

prepared for CSN 1287305).

unicode enabled version

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DB

DFT = 'HOQ'"

R3trans finished (0012).

hoqadm23>

below message from trans.log

4 ETW000  [dev trc     ,00000]  DB2 library has been loaded.                                           22133  0.025880

4 ETW000  [dev trc     ,00000]  Info: successfully loaded DB2 library '/usr/sap/HOQ/SYS/global/db6/HPIA64/db6_clidriver/lib/libdb2.so'

4 ETW000                                                                                                  58  0.025938

4 ETW000  [dev trc     ,00000]  Running with UTF-8 Unicode                                                27  0.025965

4 ETW000  [dev trc     ,00000]  Running with CLI driver.                                                5439  0.031404

4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1729] CON = 0 (BEGIN)                782433  0.813837

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N  Security processing failed with reason "24" ("USERNAME

4 ETW000                                                                                                  61  0.813898

4 ETW000  [dev trc     ,00000]  &+     AND/OR PASSWORD INVALID").  SQLSTATE=08001                                                                       

4 ETW000                                                                                                  42  0.813940

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                                                  41  0.813981

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                                                  92  0.814073

4 ETW000  [dev trc     ,00000]  &+                                                                                                                      

4 ETW000                                                                                                  41  0.814114

4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1729] (END)                              30  0.814144

4 ETW000  [dbdb6.c     ,00000]  *** ERROR => DbSlConnect to 'HOQ' as 'saphoq' failed                     204  0.814348

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'HOQ'"

I understand that the above error was due to ABAP database user connection / password.

The source system has saphop user id inside the database , however target installation has saphoq during existing installation.

Can you help me to insert saphoq into database to solve this issue. I referred similar notes in the forum and getting little confuse.

Regards,

Bharathi

[Frank-Martin · Accepted solution]

Hi,

what is the setting of the following environment variables ?

dbs_db6_user

dbs_db6_schema

During the system copy the schema of your database objects will stay the same but the connect user may change.

Regards

              Frank

[Former Member · Accepted solution]

Hi Frank

I could find below values in env.

dbms_type=db6

dbs_db6_schema=saphoq

Should I change to dbs_db6_schema=saphop?

I could not find the env  dbs_db6_user.

Please advise.

Regards,

Bharathi

[Frank-Martin · Accepted solution]

Hi ,

if dbs_db6_user is not set, it defaults to dbs_db6_schema.

dbs_db6_schema=saphoq

is wrong since your source system has been HOP and your database objects will still be in schema saphop .

I do not know how your system copy has been done, since I do not know the HP tool. If using SAPINST for the copy, SAPINST would have asked you for the source schema in the dialog phase.

You can now try to change dbs_db6_schema in your environment and all login scripts. After this you need to regenerate your password file using dscdb6up. Also user saphop needs to exist on your target box.

Regards

              Frank

[Former Member · Accepted solution]

Thanks Frank for your support. I have changed accordingly as per your instruction and it is OK and working fine.

Note: Password of sap(source system id) should not contain special characters.

Regards,

Bharathi

[Frank-Martin · Accepted solution]

Hi Bharathi,

good to hear that the manual repair worked.

The DB2 CLI client used to have some restrictions on special chars in passwords up to and including DB2 V9.7 . The rules have been relaxed in V10.1 clients. Now mainly the char ";" should not be used in passwords of connect users. See:

http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.install.doc/doc/...

Regards

                Frank