Skip to Content
author's profile photo Former Member
Former Member

tp unlocksys during upgrade returns code 0232

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2010 at 03:56 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member PR SRINIVAS

      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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2010 at 02:44 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 31, 2010 at 02:39 PM

    Please try below command:

    cd /<upgrade directory>/bin

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

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2010 at 03:25 PM

    Hi Sunny,

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

    Thank you for your help.

    Regards

    Francisco

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2010 at 03:47 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.