Hi,
We are having DB2-V7.2 DB on AIX 5.2 machine. Recently we upgraded our
system to fixpack 13 and activated activate AIX asynchronous IO
function.
Our DB is going to crash recovery with this error 0xFFFFF707.
I have attached the related details. Any suggestions is much
appreciated.
Thanks,
GN.
2005-03-24-09.43.16.134762 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with coor_node:0000
..
2005-03-24-09.43.16.269681 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with coor_agent_index:00a2
.¢
2005-03-24-09.43.16.372071 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with CLIENT PID:3231 3234
2124
2005-03-24-09.43.16.461758 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with INBOUND APPLICATION ID:4330
4138 3031 3136 2e30 4537 452e 3035 C0A80116.0E7E.05
3033 3234 3039 3336 3231 0324093621
2005-03-24-09.43.16.607165 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with INBOUND SEQUENCE NUMBER:3030
3031 0001
2005-03-24-09.43.16.707761 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with OUTBOUND APPLICATION ID:
2005-03-24-09.43.16.779667 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:
2005-03-24-09.43.16.851812 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with AUTHORIZATION ID:4144 4f47
414e 2020 0000 0000 0000 0000 ADOGAN ........
0000 0000 0000 0000 0000 0000 0000 00 ...............
2005-03-24-09.43.16.959822 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with PRODUCT SIGNATURE:5351 4c30
3730 3236 SQL07026
2005-03-24-09.43.17.056515 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
Error in agent servicing application with APPLICATION NAME:6462 7669
732e 6578 65 dbvis.exe
2005-03-24-09.43.17.146338 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:1 Database:GFX_PROD
value of ptr to db2ra_as_cb200b 8038
..8
2005-03-24-09.43.17.236566 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:2 Database:GFX_PROD
contents of db2ra_as_cb2ff1 d800 2002 6ba0 0000 0000 0000 0000
/ñØ. .k*........
200d 7048 200b 8138 0000 0000 0000 0000 .pH ..8........
0000 0000 0000 0000 200c 8038 0000 0000 ........ ..8....
0000 0000 200b 8070 0000 0000 0000 0000 .... ..p........
5351 4c44 4232 5241 0200 0b00 0000 0000 SQLDB2RA........
0000 1000 0001 0000 5351 4c44 4232 5241 ........SQLDB2RA
0100 0300 0501 0a23 0000 0000 0000 0016 .......#........
0000 0002 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0140 0000 0000 1307 0105 .......@........
230a 0105 0000 0105 0000 0000 0000 0000 #...............
0000 0000 0000 0000 0000 04b8 0000 0000 ...........¸....
db2diag.log (99%)
2005-03-24-09.43.18.011768 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:7 Database:GFX_PROD
contents of comm_handle buffer
2005-03-24-09.43.18.088621 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:10 Database:GFX_PROD
size of receive request area0000 0140
...@
2005-03-24-09.43.18.178819 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
base_sys_utilities sqleagnt_sigsegvh Probe:11 Database:GFX_PROD
contents of receive request area00c4 0000 4001 0000 b800 0000 5351
4c44 .Ä..@...¸...SQLD
4232 5241 0000 00e0 0105 0002 000b 000a B2RA...à........
0000 0088 8000 0009 2ff1 d8e0 0000 0000 ......../ñØà....
4000 0004 0000 0000 0000 000c 4000 0004 @...........@...
200c 80d0 0000 0002 4000 0003 200c 80dc ..Ð....@... ..Ü
0000 0008 4000 0001 200c 80e0 0000 0008 ....@... ..à....
4000 0001 200c 80e8 0000 0008 4000 0001 @... ..è....@...
200c 80f0 0000 0000 0000 0000 0000 0000 ..ð............
0000 0000 c000 0005 0000 0000 0000 0002 ....À...........
4000 0004 200c 80f8 0000 0000 0000 0000 @... ..ø........
0000 0000 0000 4c4c 5351 4c4c 4630 3030 ......LLSQLLF000
4e55 4c4c 4944 2020 6841 4463 5161 4450 NULLID hADcQaDP
0000 0100 01c5 0003 200c 812c 200c 8128 .....Å.. .., ..(
000d 4445 5354 5f53 544e 5f43 4f44 4500 ..DEST_STN_CODE.
0000 0000 0000 0000 0000 0000 0000 0000 ................
2005-03-24-09.43.18.636207 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
oper_system_services sqloEDUCodeTrapHandler Probe:10
Database:GFX_PROD
************************************************** ******************
* *
* DB2 USERS : *
* ----------- *
* An internal processing error occurred on this DB2 instance. *
* *
* A stack trace-back for the process in which the error was *
* detected may be written to a trap file in the directory *
* containing this log. The name of the file will be 'tppppp.nnn' *
* where ppppp is the process id, and nnn is the node number. *
* *
* *
* ALL DB2 PROCESSES ASSOCIATED WITH *
* THIS INSTANCE HAVE BEEN SHUTDOWN. *
* *
* Contact your technical service representative with the *
* information from this log and from the auxiliary trace and dump *
* files in the same directory. *
************************************************** ******************
2005-03-24-09.43.18.724863 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
oper_system_services sqloEDUCodeTrapHandler Probe:20
Database:GFX_PROD
Signal number received
0000 000b ....
2005-03-24-09.43.18.814942 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
oper_system_services sqloEDUCodeTrapHandler Probe:25
Database:GFX_PROD
2005-03-24-09.43.18.965375 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
relation_data_serv sqlrr_signal_handler Probe:10
Database:GFX_PROD
DIA7107I Execution of a component signal handling function has begun.
2005-03-24-09.43.19.019074 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:GFX_PROD
DIA3816C A severe internal processing error has occurred.
2005-03-24-09.43.19.036891 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:GFX_PROD
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF707".
Data Title:* NOTE: NULL sqlca PID:61834 Node:000
2a *
Dump File:/home/gfxprod1/sqllib/db2dump/61834.000 Data:RDS AGENT CB
Dump File:/home/gfxprod1/sqllib/db2dump/61834.000 Data:RDS APPL CB
2005-03-24-09.43.19.169071 Instance:gfxprod1 Node:000
PID:61834(db2agent (GFX_PROD)) Appid:C0A80116.0C92.050324091020
relation_data_serv sqlrr_signal_handler Probe:20
Database:GFX_PROD
DIA7108I Execution of a component signal handling function is
complete.
2005-03-24-09.45.17.725586 Instance:gfxprod1 Node:000
PID:85792(db2tcpcm) Appid:none
oper_system_services sqloEDUSIGCHLDHandler Probe:20
PID of abnormally terminated child process:
0000 f18a ..ñ.
2005
2005-03-24-09.57.21.447118 Instance:gfxprod1 Node:000
PID:78510(db2agent (GFX_PROD)) Appid:0A0A1401.91BD.050324094124
base_sys_utilities sqledint Probe:0 Database:GFX_PROD
Crash Recovery is needed.
2005-03-24-09.57.40.405658 Instance:gfxprod1 Node:000
PID:78510(db2agent (GFX_PROD)) Appid:0A0A1401.91BD.050324094124
recovery_manager sqlpresr Probe:1 Database:GFX_PROD
DIA3908W Crash recovery has been initiated. Lowtran LSN is
"014E76E7F3F5",