Unable to call db2 procedures with XMETA user
Posted: Wed Nov 07, 2012 12:41 pm
DataStage 8.5 running in AIX 5.3 OS. We are unable to run any procedures related to db2 with xmeta, db2inst1 and db2fenc1 users.
To know the size of xmeta DB I called procedure [call get_dbsize_info(?,?,?,0)] it is throwing error message
SQL1042C An unexpected system error occurred. SQLSTATE=58004
I tried with all users xmeta, db2inst1, dasusr1 and db2fenc1 every time it is giving same error message.
db2diag.log file is not giving me any proper error message (below is contents from log file).
2012-11-07-10.05.38.350482-480 E15248850A1385 LEVEL: Error
PID : 2338924 TID : 7751 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : XMETA
APPHDL : 0-4405 APPID: *LOCAL.db2inst1.121107180543
AUTHID : DB2INST1
EDUID : 7751 EDUNAME: db2agent (XMETA) 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:
[0] 0x09000000147801F4 pdLog + 0xFC
[1] 0x0900000012C7337C sqlerRemoveAllIPCforRow__FP11sqlerFmpRowb + 0x600
[2] 0x0900000012C72C38 @136@sqlerRemoveFmpFromTable__FP11sqlerFmpRowPP11sqlerFmpRowT2bT4Ci + 0x2D8
[3] 0x0900000012C72908 sqlerRemoveFmpFromTable__FP11sqlerFmpRowb + 0x30
[4] 0x0900000012C7279C @136@sqlerShutdownFMP__FP11sqlerFmpRowP14sqlerFmpHandleP13sqlerFmpTableP8sqeAgentbT5 + 0x754
[5] 0x090000001063413C sqlerGetFmpFromPool__FP14sqlerFmpHandleP13sqlerFmpParms + 0x174
[6] 0x09000000115D3BC0 sqlerInvokeFencedRoutine__FP13sqlerFmpParms + 0xAC
[7] 0x090000001477E7CC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x4B4
[8] 0x090000001477F37C sqlricall__FP8sqlrr_cb + 0x120
[9] 0x09000000147FD308 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5AC
$
I am struggling with this for past one week. Can some one please help me if you have any clue how to fix this? Our DataStage 8.5 repository is running in db2. I new to DataStage any help is greatly appreciated.
To know the size of xmeta DB I called procedure [call get_dbsize_info(?,?,?,0)] it is throwing error message
SQL1042C An unexpected system error occurred. SQLSTATE=58004
I tried with all users xmeta, db2inst1, dasusr1 and db2fenc1 every time it is giving same error message.
db2diag.log file is not giving me any proper error message (below is contents from log file).
2012-11-07-10.05.38.350482-480 E15248850A1385 LEVEL: Error
PID : 2338924 TID : 7751 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : XMETA
APPHDL : 0-4405 APPID: *LOCAL.db2inst1.121107180543
AUTHID : DB2INST1
EDUID : 7751 EDUNAME: db2agent (XMETA) 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:
[0] 0x09000000147801F4 pdLog + 0xFC
[1] 0x0900000012C7337C sqlerRemoveAllIPCforRow__FP11sqlerFmpRowb + 0x600
[2] 0x0900000012C72C38 @136@sqlerRemoveFmpFromTable__FP11sqlerFmpRowPP11sqlerFmpRowT2bT4Ci + 0x2D8
[3] 0x0900000012C72908 sqlerRemoveFmpFromTable__FP11sqlerFmpRowb + 0x30
[4] 0x0900000012C7279C @136@sqlerShutdownFMP__FP11sqlerFmpRowP14sqlerFmpHandleP13sqlerFmpTableP8sqeAgentbT5 + 0x754
[5] 0x090000001063413C sqlerGetFmpFromPool__FP14sqlerFmpHandleP13sqlerFmpParms + 0x174
[6] 0x09000000115D3BC0 sqlerInvokeFencedRoutine__FP13sqlerFmpParms + 0xAC
[7] 0x090000001477E7CC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x4B4
[8] 0x090000001477F37C sqlricall__FP8sqlrr_cb + 0x120
[9] 0x09000000147FD308 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5AC
$
I am struggling with this for past one week. Can some one please help me if you have any clue how to fix this? Our DataStage 8.5 repository is running in db2. I new to DataStage any help is greatly appreciated.