Hi every body,

SQL1646N:A routine failed because the fenced user ID cannot access required files in the sqllib directory or other instance or database directories.

this the error i am receiving when i am trying to run a procedure or a declare statement.

Please guys if any one has face this kind of issue or solved it previously help me out.

In the diaglog this is what i found :




2013-09-27-16.31.02.791606+330 I61581195A669 LEVEL: Severe
PID : 30006 TID : 2199354599760 PROC : db2sysc 0
INSTANCE: xxxxxxxxxxx NODE : 000 DB : MBCPROD
APPHDL : 0-31 APPID: *LOCAL.dbdiphx.130927110105
AUTHID : xxxx HOSTNAME: xxxxxx
EDUID : 37 EDUNAME: db2agent (MBCPROD) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFmpThread, probe:20
RETCODE : ZRC=0xFFFFF992=-1646
SQL1646N A routine failed because the fenced user ID cannot access
required files in the sqllib directory or other instance or database
directories.


2013-09-27-16.31.02.791819+330 E61581865A3550 LEVEL: Error
PID : 30006 TID : 2199354599760 PROC : db2sysc 0
INSTANCE: xxxxx NODE : 000 DB : MBCPROD
APPHDL : 0-31 APPID: *LOCAL.dbdiphx.130927110105
AUTHID : xxxx HOSTNAME: xxxxxx
EDUID : 37 EDUNAME: db2agent (MBCPROD) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRemoveAllIPCforRow, probe:10
DATA #1 : String, 32 bytes
Freeing IPC resource explicitly:
DATA #2 : sqlerFmpRow, PD_SQLER_TYPE_FMP_ROW, 544 bytes
fmpPid: 1453
fmpPoolList Ptr: 0x0000000000000000 fmpForcedList Ptr: 0x0000000000000000
nextFmpCB Ptr: 0x0000000101af9640 prevFmpCB Ptr: 0x0000000000000000
fmpIPCList Ptr: 0x0000000101afab00
stateFlags: 0x00000152 numFmp32Attaches: 0
numActiveThreads: 0 numPoolThreads: 0
fmpCodePage: 0 fmpRowUseCount: 0
active: 0x01 rowLoaderValidate: 0x00
ipcLatch:
0x0000000101AFA8C4 : 003C 0000 .<..
rowLatch:
0x0000000101AFA8C8 : 01BB 0001 ....
fmpAgentList:
0x0000000101AFA8D0 : 0008 0007 3433 0000 0000 0000 0000 0000 ....43..........
0x0000000101AFA8E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA8F0 : 0000 0000 0000 0000 0000 0000 2A00 0000 ............*...
0x0000000101AFA900 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA910 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA920 : 0000 0000 2A00 0000 0000 0000 0000 0000 ....*...........
0x0000000101AFA930 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA940 : 0000 0000 0000 0000 0000 0000 2A00 0000 ............*...
0x0000000101AFA950 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA960 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA970 : 0000 0000 2A00 0000 0000 0000 0000 0000 ....*...........
0x0000000101AFA980 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA990 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA9A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA9B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA9C0 : 0000 0000 5345 4D41 5048 4F52 4520 5741 ....SEMAPHORE WA
0x0000000101AFA9D0 : 4954 0000 0000 0000 0000 0000 0000 0000 IT..............
0x0000000101AFA9E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFA9F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0000000101AFAA70 : 0000 0001 01AF A8C0 0000 0001 01AF D120 ...............
0x0000000101AFAA80 : 0000 0001 0457 B9C0 0000 0000 0000 0000 .....W..........
0x0000000101AFAA90 : 0000 0000 0000 0000 0000 0001 0000 0000 ................
DATA #3 : Hexdump, 8 bytes
0x0000000101AFAB00 : 0000 0000 0000 0000 ........

2013-09-27-16.31.02.792093+330 E61585416A743 LEVEL: Error
PID : 30006 TID : 2199354599760 PROC : db2sysc 0
INSTANCE: xxxx NODE : 000 DB : MBCPROD
APPHDL : 0-31 APPID: *LOCAL.dbdiphx.130927110105
AUTHID : xxxxx HOSTNAME: xxxxx
EDUID : 37 EDUNAME: db2agent (MBCPROD) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRemoveAllIPCforRow, probe:20
DATA #1 : String, 22 bytes
IPC resources Address:
DATA #2 : Pointer, 8 bytes
0x0000000110050080
DATA #3 : String, 25 bytes
FMP Shared Memory Offset:
DATA #4 : unsigned integer, 4 bytes
327808
DATA #5 : String, 30 bytes
32 Bit FMP in 64 Bit Instance:
DATA #6 : Boolean, 1 bytes
false

2013-09-27-16.31.02.792259+330 E61586160A2415 LEVEL: Error
PID : 30006 TID : 2199354599760 PROC : db2sysc 0
INSTANCE: xxxxxxxxxxxxxx NODE : 000 DB : MBCPROD
APPHDL : 0-31 APPID: *LOCAL.dbdiphx.130927110105
AUTHID : xxxxxxxxxx HOSTNAME: xxxxxxxxxxx
EDUID : 37 EDUNAME: db2agent (MBCPROD) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerRemoveAllIPCforRow, probe:30
DATA #1 : String, 29 bytes
Number of IPC resource found:
DATA #2 : signed integer, 4 bytes
1
DATA #3 : String, 29 bytes
Number of IPC resource freed:
DATA #4 : signed integer, 4 bytes
1
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0000020001CCC6D0 _Z23sqlerRemoveAllIPCforRowP11sqlerFmpRowb + 0x560
[1] 0x0000020001CD1AF4 /db2/dbusers/dbdiphx/sqllib/lib64/libdb2e.so.1 + 0x1CC0AF4
[2] 0x0000020001CD1BDE _Z23sqlerRemoveFmpFromTableP11sqlerFmpRowb + 0x4E
[3] 0x0000020001CD1FE4 /db2/dbusers/dbdiphx/sqllib/lib64/libdb2e.so.1 + 0x1CC0FE4
[4] 0x0000020001CDAAAC _Z19sqlerGetFmpFromPoolP14sqlerFmpHandleP13sqlerFm pParms + 0xE50
[5] 0x0000020001CDB8C4 _Z24sqlerInvokeFencedRoutineP13sqlerFmpParms + 0x5BC
[6] 0x000002000411F5B2 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0x1392
[7] 0x0000020004121AA0 _Z9sqlricallP8sqlrr_cb + 0x1EC
[8] 0x0000020003FABE4E _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x7C2
[9] 0x0000020003AFD8D4 _Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x237C
[10] 0x0000020003AD0F2C _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x244
[11] 0x0000020001EE882E _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDM Object + 0x5E6
[12] 0x0000020001EB42F2 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDD MObjectP14db2UCinterface + 0x306
[13] 0x0000020001EB5012 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8s qeAgentb + 0x322
[14] 0x0000020001EA9CA8 /db2/dbusers/dbdiphx/sqllib/lib64/libdb2e.so.1 + 0x1E98CA8
[15] 0x0000020001EADD70 /db2/dbusers/dbdiphx/sqllib/lib64/libdb2e.so.1 + 0x1E9CD70
[16] 0x0000020001EAE4CE _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x14E
[17] 0x0000020001B06534 _ZN8sqeAgent6RunEDUEv + 0x548
[18] 0x0000020004D0D986 _ZN9sqzEDUObj9EDUDriverEv + 0x222
[19] 0x000002000360E62E sqloEDUEntry + 0x2BE
[20] 0x0000004E1CE0CD86 /lib64/libpthread.so.0 + 0x7D86
[21] 0x0000004E1CD6C98E /lib64/libc.so.6 + 0xF398E