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

Help about access DB to unlock user SAP* in db2 client 000

Hi consultant,

I has a mistake, input wrong password many times and user SAP* & DDIC on client 000 was locked.

I try to unlock these user, but when i run a command on db2 (with Administrator permission) , it show me a error message:

"SQL1031N The database directory cannot be found on the indicated file system.

SQLSTATE=58031 "

I jus found this page: IBM SQL1031N when running DB2 command - United States

it show the direction - found the db2 instance, but i do not how to do 😔

could you please help me do it, i very need open these user to config the system for the SAP services consultants check our system.

Thanks you for your read !

Best Regards,

Hien Nguyen

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Apr 22, 2015 at 05:57 AM

    Hi,

    I think, you must use for connect to DB name and not to instance name.

    db2 connect to P01.

    B.R.
    Martin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 21, 2015 at 03:51 PM

    Hello Hien,

    With Any Database you first need to connect to it. Looks like you are executing the sql statement when you are not connected to the DB, hence you get an error.

    Please read the following document before proceeding to execute sql statements.

    DB2 Basics: Getting to know the DB2 UDB command line processor

    Regards,

    Siddhesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Hien,

      Can I also ask if everything is working at the moment ? Is SAP application up, it would be stupid of me to ask this after I have given you suggestions to check the DB is offline, but I thought i'll check.

      Since, If SAP is up and you are attempting to reset password at DB level, are you sure you are on the correct node ?

      Regards,

      Siddhesh

  • Posted on Apr 21, 2015 at 03:43 PM

    Hi Hien ,

    Have you logged on as db2<sid> user ? also log into the database server

    If not login as db2<sid> user /server and try once again

    also before executing any commands on the db , execute the following

    db2 connect to <SID >

    Thanks ,

    Manu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2015 at 03:20 AM

    Hello Hien,

    Could you please check the result of following command?
    >> db2 list db2 directory on /db2/P01/

    If it fails, then it might not be solved in a straight foward way.

    Kind regards
    Maria

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Hien,

      "db2 list db directory" gives the result, while "db2 list db directory on K:\db2\P01" returns same SQL1031N error. It seems to be some issues with database files under local database directory

      You have to firstly check where the database directory exactly resides. The first result gives "K:\db2\P01\sapdata4". Is it really there? Does it have subfolder like NODE0000\SQL00001?

      In any case, the repair is not straight forward, and may need to have SAP incident created.


      Kind regards
      Maria

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.