Topic
2 replies Latest Post - ‏2013-07-17T02:12:41Z by Julep
Julep
Julep
6 Posts
ACCEPTED ANSWER

Pinned topic DB2 Crashes

‏2013-07-16T11:02:00Z |

Hi All,

My colleague informed me to check on DB2 as he cannot perform query.

 

I did a check. DB2 process is not running. Try to start db2, encounters SQL1652N  File I/O error occurred.

 

Below are the msgs seen from db2diag log :

 

2013-07-16-15.01.37.099246+480 I5232255625A552    LEVEL: Error

PID     : 26804238             TID  : 1           PROC : db2vend (PD Vendor Process - 258

INSTANCE: bcuaix               NODE : 000

EDUID   : 1                    EDUNAME: db2vend (PD Vendor Process - 258

FUNCTION: DB2 UDB, oper system services, DB2VEND_main, probe:1040

MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"

          DIA8506C Unexpected end of file was reached.

DATA #1 : String, 63 bytes

Fenced vendor process pipe failure, terminating vendor process.

 

2013-07-16-15.01.37.123918+480 E5232260965A546    LEVEL: Severe

PID     : 10944634             TID  : 258         PROC : db2wdog 0

INSTANCE: bcuaix               NODE : 000

EDUID   : 258                  EDUNAME: db2wdog 0

FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20

MESSAGE : ADM0503C  An unexpected internal processing error has occurred. All

          DB2 processes associated with this instance have been shutdown.

          Diagnostic information has been recorded. Contact IBM Support for

          further assistance.

 

I try to reboot the server. But still cannot work.

Logs attached.

 

Platform AIX 7.1, DB2 9.7.6

 

Anyone please advise.

 

Thanks a lot.

 

Regards,

Julep

Attachments

  • nivanov1
    nivanov1
    231 Posts
    ACCEPTED ANSWER

    Re: DB2 Crashes

    ‏2013-07-16T17:14:25Z  in response to Julep
    2013-07-16-16.19.09.372070+480 I5232278292A1751   LEVEL: Error (OS)
    PID     : 8847488              TID  : 1           PROC : db2start
    INSTANCE: bcuaix               NODE : 000
    EDUID   : 1
    FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
    CALLED  : OS, -, chmod
    OSERR   : EPERM (1) "Not owner"
    DATA #1 : String, 133 bytes
    A total of 2 analysis will be performed :
     - User info
     - Path access permission
     
     Target file = /db2home/bcuaix/sqllib/db2nodes.cfg
    DATA #2 : String, 186 bytes
      Real user ID of current process       = 1202
      Effective user ID of current process  = 1202
      Real group ID of current process      = 989
      Effective group ID of current process = 989
    DATA #3 : String, 41 bytes
    current sbrk(0) value: 0x00000001101b1880
    DATA #4 : String, 254 bytes
    Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
       <UID>:<GID>:<permissions> (subdirectories)
     
       0:0:755 (db2home)
       1202:989:755 (bcuaix)
       1202:989:3775 (sqllib)
       209:989:644 (db2nodes.cfg)
     

    Change ownership of db2nodes.cfg back to the instance owner.

    • Julep
      Julep
      6 Posts
      ACCEPTED ANSWER

      Re: DB2 Crashes

      ‏2013-07-17T02:12:41Z  in response to nivanov1

      Thanks nivanov1. The problem was resolved.