tp unlocksys during upgrade returns code 0232

[Former Member]

Hi all,

I'm upgrading a system from 4.5B to ECC 6.0. I need to unlock the system in order to log in with a user different from DDIC.

SAPup is now in phase PARCONV_UPG (387/505). The shadow instance is not available any more, so SAPup is working only in the real instance.

When I try to execute

tp unlocksys TEC pf=/usr/sap/trans/bin/TP_DOMAIN_TEC.PFL

an error occurs ( see below )

I have also tried with

tp unlocksys TEC pf=<dir_trans>//DEFAULT.TPP

with the same results. Any ideas?

Thank you very much in advance.

Best Regards

TRACE-INFO: 16: *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("libdb2.a(shr_64.o)") FAILED 1935 0.006630

TRACE-INFO: 17: " 0509-022 Cannot load module shr_64.o.

TRACE-INFO: 18: 0509-026 System error: A file or directory in the path name does not exist." (errno=2,No such file or directory)

TRACE-INFO: 19: Could not load DB2 library libdb2.a(shr_64.o). No database connection possible.

TRACE-INFO: 20: 77 0.006707

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0232

tp finished with return code: 232

Edited by: Francisco José Martínez Carretero on Aug 31, 2010 3:50 PM

[Former Member · Accepted solution]

Hi Francisco,

The correct command to unlock the instance at phase PARCONV_UPG is:

tp unlocksys pf=(DIR_PUT)/bin/DEFAULT.TPP

Did you get following error with this command?

TRACE-INFO: 16: http://dlux.c ,00000 *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("libdb2.a(shr_64.o)") FAILED 1935 0.006630

TRACE-INFO: 17: " 0509-022 Cannot load module shr_64.o.

TRACE-INFO: 18: 0509-026 System error: A file or directory in the path name does not exist." (errno=2,No such file or directory)

TRACE-INFO: 19: dev trc ,00000 Could not load DB2 library libdb2.a(shr_64.o). No database connection possible.

TRACE-INFO: 20: 77 0.006707

It seems there is problem with DB2 Connect, and therefore tp cannot connect to database and failed.

Please check if library libdb2.a exists in the directory

/usr/sap/<SID>/SYS/global/db2/<platform>/db2_clidriver/lib

Regards, Sammi

[pr_srinivas · Accepted solution]

HI...

we are upgrading SCM 7.02 System SP0 to SP7 using SUM on AIX [ SUM 1.0 SP7 P2]

We were in phase just to start Downtime Phase.

We completed backup and immediately Business Users requested to post pone the Downtime Phase to evening .

& When users were trying to login they are getting message

"Upgrade still running : Logon Not possible"

We unlocked it as below

------------------------------------------------------------------------------------------------

host.domain.com:sidadm> pwd

/<SUM>/abap/var

host.domain.com:sidadm> tp unlocksys <SID> pf=/<SUM>/abap/var/DEFAULT.TPP

This is tp version 380.03.82 (release 720, unicode enabled)

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 18).

Warning: unknown parameter DYNAMIC_PARAMETERS in parameter file (line 18).

Warning: Parameter DBCONFPATH is no longer used.

tp finished with return code: 0

meaning:

  Everything OK

host.domain.com:sidadm>

*** Finally is is just rewrite of same but specifying that when using SUM where DEFAULT.TPP is existing on AIX ***

[Former Member · Accepted solution]

Hi

If you are in EHP upgrade and in Execution phase where the system is locked and no other users are allowed to login except DDIC then use the following command to unlock your system

tp unlocksys <SID> pf=<DIR_PUT>/var/DEFAULT.TPP

you can find DIR_PUT value in your DEFAULT.PFL file in profile folder

This is basically your SUM/abap folder.

Make sure to lock the system after your task is done in other client before proceeding to upgrade again.

Thanks

Rabi

[Former Member]

Hello,

Finally we gave up. We solved the problem by executing SQL sentences directly in DB2 for Z/OS.

The phase PARCONV_UPG has finished and now the next one is running.

Thank you for your help.

Best Regards

[Former Member]

Hi Sunny,

Yes, I tried also that command with DEFAULT.TPP, with no results.

Thank you for your help.

Regards

Francisco

[Former Member]

Hi Sunny,

Thank you for your answer. Unfortunately the problem is which tpparam file to use.

I have already tested tp unlocksys with different files and it always return the same error.

Regards

Francisco

[sunny_pahuja2]

Hi,

Have you used the above command ? you should use transport parameter file.

And in which phase you are currently ?

Thanks

Sunny

[Former Member]

Hi Sunny,

As I wrote above the upgrade is running phase PARCONV_UPG (which is number 387 of 505).

Yes, I have already executed the command. What I asked was which transport parameter file should I use. As you know, during the upgrade there is one in the <dir_trans>, another one for the shadow instance (which is pointless to use know, as the shadow instance is not used anymore), and another one in the <dir_upg>/bin directory.

I have tried all of them but the execution was unsuccessful .

[sunny_pahuja2]

Hi,

Have you tried with DEFAULT.TPP

cd /usr/sap/<SID>/upg/abap/bin

../exe/tp unlocksys <SAPSID> pf=/usr/sap/<SID>/upg/abap/bin/DEFAULT.TPP

../exe/tp unlock_eu <SAPSID> pf=/usr/sap/<SID>/upg/abap/bin/DEFAULT.TPP

Thanks

Sunny

[sunny_pahuja2]

Hi,

Also try below command:

./SAPehpi unlockshd <SID>

Thanks

Sunny

[sunny_pahuja2]

Please try below command:

cd /<upgrade directory>/bin

../exe/tp unlocksys <SAPSID> pf=<transport profile>

Thanks

Sunny