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

Since you are not providing any details, I can only suggest you look in db2diag.log for a more detailed error message.

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

Such a DARI failure means that your code crashed. Did you write the wrapper yourself? If so, you should check your code.

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.

you mean you get
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.

That's exactly what it was thanks alot nick.ncs.