SAP DB2 DEVELOPMENT HOMOGENOUS RESTORATION ERROR

[Former Member]

Hi,

I tried to restore production offline backup to development with homogenous restore procedure. After restoration R3 trans is not getting up. the error while running R3trans -D is

MCLKERPD:db2mcd 54> R3trans -d

This is R3trans version 6.14 (release 701 - 03.06.11 - 17:57:00).

unicode enabled version

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

R3trans finished (0012)

Trans log is as follows.

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Sat Aug 17 11:03:07 2013                                                  69  0.000069

4 ETW000  [     dev trc,00000]  db_con_init called                                                        18  0.000087

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 26  0.000113

4 ETW000  [     dev trc,00000]  Loading DB library '/usr/sap/MCD/SYS/exe/run/dbdb6slib.so' ...            31  0.000144

4 ETW000  [     dev trc,00000]  DlLoadLib() success: dlopen("/usr/sap/MCD/SYS/exe/run/dbdb6slib.so"), hdl 0

4 ETW000                                                                                                 252  0.000396

4 ETW000  [     dev trc,00000]  Library '/usr/sap/MCD/SYS/exe/run/dbdb6slib.so' loaded                    15  0.000411

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library /usr/sap/MCD/SYS/exe/run/dbdb6slib.so

4 ETW000                                                                                                  24  0.000435

4 ETW000  [     dev trc,00000]  Version of '/usr/sap/MCD/SYS/exe/run/dbdb6slib.so' is "700.08", patchlevel (0.143)

4 ETW000                                                                                                  83  0.000518

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library /usr/sap/MCD/SYS/exe/run/dbdb6slib.so

4 ETW000                                                                                                  20  0.000538

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library /usr/sap/MCD/SYS/exe/run/dbdb6slib.so

4 ETW000                                                                                                  24  0.000562

4 ETW000  [     dev trc,00000]  New connection 0 created                                                  17  0.000579

4 ETW000  [     dev trc,00000]  000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  36  0.000615

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             17  0.000632

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection for reuse:                13  0.000645

4 ETW000  [     dev trc,00000]  000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000                             reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000                                                                                                  30  0.000675

4 ETW000  [     dev trc,00000]  *** ERROR in DbSlConnectDB6[dbsldb6.c, 1280] CON = 0 (BEGIN)             197  0.000872

4 ETW000  [     dev trc,00000]  &+     DbSlConnectDB6: unable to open file: '/usr/sap/MCD/SYS/global/dscdb6.conf'

4 ETW000                                                                                                  30  0.000902

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  22  0.000924

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  24  0.000948

4 ETW000  [     dev trc,00000]  &+

4 ETW000                                                                                                  25  0.000973

4 ETW000  [     dev trc,00000]  *** ERROR in DbSlConnectDB6[dbsldb6.c, 1280] (END)                        15  0.000988

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

Kindly share your valuable suggestions and guidelines

Thanks in advance

Sajith V S

08129788066

[Former Member]

Dear All Thanks for the replay

it helped a lot and the problem solved.

[hugo_amo]

Hi Sajith,

The file may have become corrupt and need to be recreated. Do the following

:

- save and remove/delete the old dscdb6.conf file
- create the dscdb6.conf file
  => dscdb6up -create <connect_user_password> <sidadm_password>
     example: dscdb6up -create sap sap
     (to set connect_user and <sid>adm password to sap)
- now set these passwords on OS level
  => dscdb6up sap<sid> <password>
  => dscdb6up <sid>adm <password>

Then run R3trans -d again and let us know the outcome.

Regards,

Hugo

[Manas_Vincit]

Hi Sajith ,

Seems you are trying to execute command from db2<sid>user and user have not access on file dscdb6.conf file under global file system . Could you try to execute command from <sid>adm and check return code .

or

provide access to file db2<sid> user .

unable to open file: '/usr/sap/MCD/SYS/global/dscdb6.conf'

Hope this helps .

Thanks

Manas Behra

[Former Member]

given access to this folder and resolved the issue. Thanks for the support

[Manas_Vincit]

Hi Sajith ,

Good to know , issue is resolved . You can close this thread by marking correct/helful answer , which will helpful to others in future .

Thanks

Manas Behra