Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2008
    Posts
    9

    Unanswered: SQL1042C An unexpected system error occurred. SQLSTATE=58004

    Hi All,

    When i'm running the db2start i'm getting following error message. But when i ran it for second time m able to start successfully.
    Can you please tell me what could be the issue for the first run. This is happening everytime when i start database manager. Please let me know if i'm missing something.

    $ ./db2 db2start
    SQL1042C An unexpected system error occurred. SQLSTATE=58004
    $ ./db2 db2start
    DB20000I The DB2START command completed successfully.

    --
    Thanks & Regards,
    Mallik
    post reply

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    db2start is not a CLP command; it is a program. You will probably find more information about the error in db2diag.log.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2008
    Posts
    9
    Hi,

    Thanks for your reply. I'm getting the same issue when i ran from db2 prompt ie below.

    =>START DATABASE MANAGER

    Also the below log shows the snapshot of db2diag.log. I have seen some fix to do a ipclean when we run the command. But, for that every time i need to run the command before starting database manager. Please let me know what can i do to resolve this issue.

    FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
    MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
    CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
    DATA #1 : String, 32 bytes
    Unable to connect socket on path
    DATA #2 : socket, 4 bytes
    6
    DATA #3 : sockaddr, 36 bytes
    0x00000000431198C0 : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
    0x00000000431198D0 : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
    0x00000000431198E0 : 7069 7065 pipe
    DATA #4 : File name, 34 bytes
    /home/dasusr1/das/tmp/dasnamedpipe

    2008-10-24-18.07.59.864223-300 E260605E813 LEVEL: Error (OS)
    PID : 6969 TID : 1125267792 PROC : db2acd
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
    MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
    CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
    DATA #1 : String, 32 bytes
    Unable to connect socket on path
    DATA #2 : socket, 4 bytes
    6
    DATA #3 : sockaddr, 36 bytes
    0x00000000431198C0 : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
    0x00000000431198D0 : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
    0x00000000431198E0 : 7069 7065 pipe
    DATA #4 : File name, 34 bytes
    /home/dasusr1/das/tmp/dasnamedpipe

    2008-10-24-18.09.59.915438-300 E261419E813 LEVEL: Error (OS)
    PID : 6969 TID : 1125267792 PROC : db2acd
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloPdbConnectSocket, probe:20
    MESSAGE : ZRC=0x810F0019=-2129723367=SQLO_CONN_REFUSED "Connection refused"
    CALLED : OS, -, connect OSERR: ECONNREFUSED (111)
    DATA #1 : String, 32 bytes
    Unable to connect socket on path
    DATA #2 : socket, 4 bytes
    6
    DATA #3 : sockaddr, 36 bytes
    0x00000000431198C0 : 0100 2F68 6F6D 652F 6461 7375 7372 312F ../home/dasusr1/
    0x00000000431198D0 : 6461 732F 746D 702F 6461 736E 616D 6564 das/tmp/dasnamed
    0x00000000431198E0 : 7069 7065 pipe
    DATA #4 : File name, 34 bytes

    --
    Thanks & Regards,
    Mallik

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    If you have to run ipclean every time, it probably means that you are not shutting down DB2 properly. And I don't think the log entries you've shown are related to db2start.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •