Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    123

    Unanswered: Unable to up the db2 Instance

    Hi All,
    i am using db2 v 9.5 (aix).
    Initially i observed that instance is in down state. i started instance but immediately instance went down.same thing is repeating for every time. In diaglog i found following information.

    2014-12-07-08.54.18.847430+330 I179194137A398 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
    DATA #1 : String, 29 bytes
    Deactivate phase is bypassed.
    DATA #2 : Hexdump, 4 bytes
    0x0FFFFFFFFFFFCB70 : 0000 0001 ....

    2014-12-07-08.54.18.847517+330 I179194536A418 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
    DATA #1 : String, 49 bytes
    Deactivate phase is completed, preparing to stop.
    DATA #2 : Hexdump, 4 bytes
    0x0FFFFFFFFFFFCB70 : 0000 0001 ....

    2014-12-07-08.54.18.847603+330 I179194955A299 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
    DATA #1 : String, 26 bytes
    Stop phase is in progress.

    2014-12-07-08.54.18.847694+330 I179195255A314 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
    DATA #1 : String, 41 bytes
    Requesting system controller termination.

    2014-12-07-08.54.18.954192+330 I179195570A316 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
    DATA #1 : String, 43 bytes
    System controller termination is completed.

    2014-12-07-08.54.18.954348+330 I179195887A337 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:270
    DATA #1 : String, 26 bytes
    Active EDUs to be waited :
    DATA #2 : unsigned integer, 4 bytes
    1

    2014-12-07-08.54.18.962950+330 I179196225A453 LEVEL: Warning
    PID : 13697228 TID : 258 PROC : db2wdog 0
    INSTANCE: db2admin NODE : 000
    EDUID : 258 EDUNAME: db2wdog 0
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
    MESSAGE : Bringing down all db2fmp processes as part of db2stop
    DATA #1 : Hexdump, 4 bytes
    0x07000000003FDE30 : 0000 0000 ....

    2014-12-07-08.54.18.964535+330 I179196679A335 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
    DATA #1 : String, 24 bytes
    There is no active EDUs.
    DATA #2 : unsigned integer, 4 bytes
    0

    2014-12-07-08.54.19.525125+330 E179197015A313 LEVEL: Event
    PID : 8585346 TID : 1 PROC : db2stop2
    INSTANCE: db2admin NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
    MESSAGE : ADM7514W Database manager has stopped.
    STOP : DB2 DBM

    i tried to update instance , i got following warning.

    db2iupdt db2admin
    An error occurred while updating the services file on the system for the service name "DB2_db2admin" with port "50000".
    DBI1070I Program db2iupdt completed successfully.


    can any one tell me , what is wrong with instance.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Need earlier db2diag.log entries.
    Which fixpack are you on?
    Try this, after becoming the db2 instance owner (db2admin):
    db2diag -A
    db2start
    - now attach the new smaller db2diag.log to this thread, so we can see what's the error

Posting Permissions

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