Results 1 to 7 of 7
  1. #1
    Join Date
    May 2006
    Posts
    5

    Unanswered: Error when trying to create wrapper.

    I'm getting the following error when trying to create a wrapper.

    [IBM][CLI Driver][DB2/AIX64] SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503

    This is on an AIX server with UNIX OS and DB2 level of v9.1.0.6.

    I've spent the weekend migrating two databases from a windows server to this AIX server and need to get these wrappers created ASAP. Thanks in advanced for your help.

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Since you are not providing any details, I can only suggest you look in db2diag.log for a more detailed error message.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    May 2006
    Posts
    5
    Here is what I see in db2diag.log

    2008-12-08-07.30.30.344175-300 I2179342A389 LEVEL: Severe
    PID : 1302680 TID : 1 PROC : db2fmp
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpThreadInit, probe:40
    MESSAGE : Failure during FMP thread initialization
    DATA #1 : Hexdump, 4 bytes
    0x0FFFFFFFFFFFF400 : 0000 003E ...>

    2008-12-08-07.30.30.344485-300 I2179732A340 LEVEL: Severe
    PID : 1302680 TID : 1 PROC : db2fmp
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpOneTimeInit, probe:100
    DATA #1 : Hexdump, 4 bytes
    0x0FFFFFFFFFFFF614 : FFFF FBEE ....

    2008-12-08-07.30.30.346138-300 I2180073A522 LEVEL: Severe
    PID : 544948 TID : 1 PROC : db2agent (SAADMIN) 0
    INSTANCE: db2inst1 NODE : 000 DB : SAADMIN
    APPHDL : 0-167 APPID: 172.30.23.90.64008.081208123028
    AUTHID : DB2ADMIN
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : failed to initiate comms layer with fenced routine process
    DATA #1 : Hexdump, 4 bytes
    0x0FFFFFFFFFFED9B0 : 0000 0036 ...6

    2008-12-08-07.30.30.346324-300 I2180596A398 LEVEL: Severe
    PID : 544948 TID : 1 PROC : db2agent (SAADMIN) 0
    INSTANCE: db2inst1 NODE : 000 DB : SAADMIN
    APPHDL : 0-167 APPID: 172.30.23.90.64008.081208123028
    AUTHID : DB2ADMIN
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerSendFmpStart, probe:10
    RETCODE : ZRC=0xFFFFFBEE=-1042

    2008-12-08-07.30.30.346130-300 E2180995A3013 LEVEL: Severe
    PID : 786438 TID : 1 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerReturnFmpToPool, probe:910
    DATA #1 : String, 47 bytes
    Marking fmp as unstable during db2sysc cleanup:

    Thanks

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Such a DARI failure means that your code crashed. Did you write the wrapper yourself? If so, you should check your code.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    May 2006
    Posts
    5
    I get the error as soon as I click on the Create New Wrapper in the Control Center. I had these set up before we applied fixpack 6. I've been digging on this all day and I keep seeing that I need to set FEDERATED to YES and it already is set to yes.

  6. #6
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    you mean you get
    Code:
    [IBM][CLI Driver][DB2/AIX64] SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503
    when you create a new wrapper???



    did you try db2iupdt command to update your instance?
    Also kindly specify which flavour and version of DB@ you are using.
    IBM Certified Database Associate, DB2 9 for LUW

  7. #7
    Join Date
    May 2006
    Posts
    5
    That's exactly what it was thanks alot nick.ncs.

Posting Permissions

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