Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2014
    Posts
    3

    Unanswered: [DB2] sometimes replication db is dead

    Hi Experts,

    I am using..
    Informational tokens are "DB2 v9.1" , Fix Pack "2" on AIX box
    and it is 3node system A-A-S
    Node 1 has 2 dbms = db2 replication db(db2 -> Orcle / SQL replication) , Oralcle 9i db
    Node 2 = db2 9.1 db

    The problem is sometimes db2 replication db is dead without clear reason
    Of course i have seen db2 diag log to find reason but i coundn't understand the meaning of text
    I know it too long to see.. i don't know whether you need or not
    "attach file db2diag.log" is full text


    Pls. anyone can help me in this to overcome such issues.

    summary db2diag.log======================================= ======================================

    2014-09-13-12.08.18.900244+540 E62649A679 LEVEL: Error (OS)
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-428 APPID: *LOCAL.amesins.141108234855
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:130
    CALLED : OS, -, dlopen
    OSERR : ENOEXEC (8) "Exec format error"
    MESSAGE : Attempt to load specified library failed.
    DATA #1 : Library name or path, 45 bytes
    /wfdev/db2/amesins/sqllib/lib64/libdb2net8U.a
    DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
    2
    DATA #3 : String, 16 bytes
    Not enough space

    2014-09-13-12.08.18.908493+540 E63329A1066 LEVEL: Error (OS)
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-428 APPID: *LOCAL.amesins.141108234855
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:140
    CALLED : OS, -, dlopen
    OSERR : ENOEXEC (8) "Exec format error"
    MESSAGE : Attempt to load specified library augmented with object name failed.
    DATA #1 : Library name or path, 55 bytes
    /wfdev/db2/amesins/sqllib/lib64/libdb2net8U.a(shr_64.o)
    DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
    262146
    DATA #3 : String, 360 bytes
    0509-026 ...... ....: ...... ...... .... .... ...... ...... .. .........
    0509-022 /wfdev/db2/amesins/sqllib/lib64/libdb2net8U.a(shr_64.o) ...... ...... .. .........
    0509-153 /wfdev/db2/amesins/sqllib/lib64/libdb2net8U.a ...... ........ ...... ........
    ...... .... .. .........
    0509-026 ...... ....: ...... ...... .... .... ...... ...... .. .........

    2014-09-13-12.08.18.908874+540 I64396A1337 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-428 APPID: *LOCAL.amesins.141108234855
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, Common Trace API, sqlqg_call_sqloLoadModule, probe:50
    MESSAGE : ZRC=0x850F007E=-2062614402=SQLO_LM_MEM "No mem for DosLoadMod"
    DATA #1 : Hexdump, 13 bytes
    0x0FFFFFFFFFFF0F24 : 6C69 6264 6232 6E65 7438 552E 61 libdb2net8U.a
    CALLSTCK:
    [0] 0x09000000046DAE28 sqlqg_call_sqloLoadModule__FP16sqloModuleHandlePUc ib + 0x234
    [1] 0x09000000075B76C0 CommonWrapperLoad__FbT1P12Wrapper_Info + 0x268
    [2] 0x09000000075B7E6C UnfencedWrapper_Hook + 0x48
    [3] 0x09000000023A4A34 sqlqgFindWrapper__FPUc12Sqlqg_OpTypePP15UnfencedWr apperUiP12Wrapper_Info + 0x8B0
    [4] 0x0900000002B5F0C0 sqlqgFindServer__FPUc12Sqlqg_OpTypePP14UnfencedSer verUi + 0x670
    [5] 0x09000000046C7788 sqlqgOpenIUD__FP10sqlri_riud + 0x698
    [6] 0x0900000002AB1254 sqlriDjxIns__FP8sqlrr_cb + 0xFFFFFFFFFFFFFD00
    [7] 0x09000000032BE9B8 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x14
    [8] 0x09000000032B9320 sqlrr_process_execute_request__FP8sqlrr_cbi + 0x27C
    [9] 0x09000000032A920C sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0xFFFFFFFFFFFFFEFC

    2014-09-13-12.08.18.909446+540 I65734A586 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-428 APPID: *LOCAL.amesins.141108234855
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, Query Gateway, CommonWrapperLoad, probe:20
    MESSAGE : ZRC=0x850F007E=-2062614402=SQLO_LM_MEM "No mem for DosLoadMod"
    DATA #1 : String, 26 bytes
    Unable to load the library
    DATA #2 : Hexdump, 13 bytes
    0x0FFFFFFFFFFF0F24 : 6C69 6264 6232 6E65 7438 552E 61 libdb2net8U.a

    2014-09-13-12.08.18.909780+540 I66321A398 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-428 APPID: *LOCAL.amesins.141108234855
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, Query Gateway, sqlqgFindWrapper, probe:120
    MESSAGE : sqlqgFindWrapper: No wrapper entry

    2014-09-13-12.10.05.483926+540 I66720A514 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-373 APPID: *LOCAL.amesins.141108235146
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
    MESSAGE : Error in agent servicing application with coor_node:
    DATA #1 : Hexdump, 2 bytes
    0x0FFFFFFFFFFEF230 : 0000 ..

    2014-09-13-12.10.05.484244+540 I67235A521 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-373 APPID: *LOCAL.amesins.141108235146
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:2
    MESSAGE : Error in agent servicing application with coor_agent_index:
    DATA #1 : Hexdump, 2 bytes
    0x0FFFFFFFFFFEF232 : 0175 .u

    2014-09-13-12.10.05.484463+540 I67757A520 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-373 APPID: *LOCAL.amesins.141108235146
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3
    MESSAGE : Error in agent servicing application with CLIENT PID:
    DATA #1 : Hexdump, 7 bytes
    0x0FFFFFFFFFFEF248 : 3330 3535 3733 32 3055732

    2014-09-13-12.10.05.484680+540 I68278A618 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-373 APPID: *LOCAL.amesins.141108235146
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:4
    MESSAGE : Error in agent servicing application with INBOUND APPLICATION ID:
    DATA #1 : Hexdump, 27 bytes
    0x000000011135533B : 2A4C 4F43 414C 2E61 6D65 7369 6E73 2E31 *LOCAL.amesins.1
    0x000000011135534B : 3431 3130 3832 3335 3134 36 41108235146

    2014-09-13-12.10.05.484901+540 I68897A528 LEVEL: Error
    PID : 2854922 TID : 1 PROC : db2agent (DB2IIDB) 0
    INSTANCE: amesins NODE : 000 DB : DB2IIDB
    APPHDL : 0-373 APPID: *LOCAL.amesins.141108235146
    AUTHID : AMESINS
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:5
    MESSAGE : Error in agent servicing application with INBOUND SEQUENCE NUMBER:
    DATA #1 : Hexdump, 2 bytes
    0x000000011135537C : 0002 ..


    ================================================== ===========================
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Did you notice this section from your DIAGLOG?

    UNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
    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.
    Dave

  3. #3
    Join Date
    Sep 2014
    Posts
    3

    all right!

    Quote Originally Posted by dav1mo View Post
    Did you notice this section from your DIAGLOG?
    Of course i saw that and searching same case on google or ibm support

    but most reply was just open pmr to ibm...

    my db2 version is 9.1 so that's impossible

    that's why i wrote question..

  4. #4
    Join Date
    Sep 2014
    Posts
    3

    test

    Quote Originally Posted by dav1mo View Post
    Did you notice this section from your DIAGLOG?
    Of course i saw that and searching same case on google or ibm support

    but most reply was just open pmr to ibm...

    my db2 version is 9.1 so that's impossible

    that's why i wrote question..

  5. #5
    Join Date
    Sep 2014
    Posts
    1

    Cool here's some answer

    Quote Originally Posted by spinits View Post
    Of course i saw that and searching same case on google or ibm support

    but most reply was just open pmr to ibm...

    my db2 version is 9.1 so that's impossible

    that's why i wrote question..

    In my experience,

    that message has variety case, so the best way is

    sending PMR to IBM support

    if this equipment end of services, you will not use PMR.

    I think you had better recognized a bug and restart your Database as soon as

Tags for this Thread

Posting Permissions

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