Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2012
    Posts
    3

    Red face Unanswered: Informix federation DB2 Crash

    Hi, I have db2 V9.5 FP 8 on Windows 2003 server 32 bits. I install a database and everything works fine, but when I use informix federation server detects it fine, but when I try to detect the nicknames the database goes down.
    Anyone know what could it be?

    grateful,

    ORLANDO
    Last edited by orbcali; 01-10-12 at 16:17.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What do you mean by "database goes down"? Which database? What's in db2diag.log?

  3. #3
    Join Date
    Jan 2012
    Posts
    3
    the database is stopped.

    db2diag.log

    2012-01-10-09.29.55.299000-300 I90180H528 LEVEL: Event
    PID : 2512 TID : 244 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : OASIS_DB
    APPHDL : 0-45 APPID: *LOCAL.DB2.120110142950
    AUTHID : ADMINISTRADOR
    EDUID : 244 EDUNAME: db2agent (OASIS_DB) 0
    FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:10
    START : Invoking C:\IBM\dwe\SQLLIB\bin\db2cos_trap.bat from oper system services sqloEDUExceptionFilter

    2012-01-10-09.30.09.795000-300 I90710H557 LEVEL: Warning
    PID : 2512 TID : 244 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : OASIS_DB
    APPHDL : 0-45 APPID: *LOCAL.DB2.120110142950
    AUTHID : ADMINISTRADOR
    EDUID : 244 EDUNAME: db2agent (OASIS_DB) 0
    FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:110
    MESSAGE : Detected end of execution of call-out script
    DATA #1 : Process ID, 4 bytes
    2340
    DATA #2 : unsigned integer, 4 bytes
    3

    2012-01-10-09.30.09.795000-300 I91269H489 LEVEL: Event
    PID : 2512 TID : 244 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : OASIS_DB
    APPHDL : 0-45 APPID: *LOCAL.DB2.120110142950
    AUTHID : ADMINISTRADOR
    EDUID : 244 EDUNAME: db2agent (OASIS_DB) 0
    FUNCTION: DB2 UDB, trace services, pdInvokeCalloutScript, probe:20
    STOP : Completed invoking C:\IBM\dwe\SQLLIB\bin\db2cos_trap.bat

    2012-01-10-09.30.09.795000-300 I91760H572 LEVEL: Error
    PID : 2512 TID : 244 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : OASIS_DB
    APPHDL : 0-45 APPID: *LOCAL.DB2.120110142950
    AUTHID : ADMINISTRADOR
    EDUID : 244 EDUNAME: db2agent (OASIS_DB) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:1
    MESSAGE : Error in agent servicing application with coor_node:
    DATA #1 : Hexdump, 2 bytes
    0x073B5DF2 : 0000 ..

    2012-01-10-09.30.09.795000-300 I92334H579 LEVEL: Error
    PID : 2512 TID : 244 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : OASIS_DB
    APPHDL : 0-45 APPID: *LOCAL.DB2.120110142950
    AUTHID : ADMINISTRADOR
    EDUID : 244 EDUNAME: db2agent (OASIS_DB) 0
    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
    0x073B5DF0 : 2D00 -.

    2012-01-10-09.30.09.795000-300 I92915H574 LEVEL: Error
    PID : 2512 TID : 244 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : OASIS_DB
    APPHDL : 0-45 APPID: *LOCAL.DB2.120110142950
    AUTHID : ADMINISTRADOR
    EDUID : 244 EDUNAME: db2agent (OASIS_DB) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3
    MESSAGE : Error in agent servicing application with CLIENT PID:
    DATA #1 : Hexdump, 3 bytes
    0x073B5DD0 : 3934 34 944

    and continue..

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by orbcali View Post
    the database is stopped.
    A database is just a bunch of files; how can it "be stopped"? You obviously mean something else, so you'd be better off using standard DB2 terminology. How do you discover that "the database is stopped"? Any error messages?

    Also, you have omitted the most important parts of db2diag.log that go before and after the fragment that you have posted.

  5. #5
    Join Date
    Jan 2012
    Posts
    3
    Ok, sorry, the instance stop, i need to run db2start again. this happens every time I try to create a nickname.
    Attached Files Attached Files

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Looks like a DB2 bug; you should contact DB2 support.

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
  •