Hi,
I suddenly loose connectivity to the database from ArcIMS. This is causing a lot of trouble for the running services.
This is a part of the db2diag.log. Any help on why the connectivity is suddenly broken? Please let me know if i need to attach more details.
Thanks,
Annie

2004-05-20-08.30.00.394002 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
base_sys_utilities sqleagnt_sigsegvh Probe:11 Database:PKILC

contents of receive request area5351 4c44 4232 5241 0000 00e0 0105 0002 SQLDB2RA.......
0009 000a 0000 0088 8000 0009 2ff1 e930 ............/0
0000 0000 4000 0004 0000 0000 0000 000b ....@...........
4000 0004 2023 e364 0000 0002 4000 0003 @... #d....@...
2023 e370 0000 0008 4000 0001 2023 e374 #p....@... #t
0000 0008 4000 0001 2023 e37c 0000 0008 ....@... #|....
4000 0001 2023 e384 0000 0000 0000 0000 @... #.........
0000 0000 0000 2be4 c000 0006 20be b0b8 ......+...
0000 0025 4000 0001 2023 e39c 0000 0000 ...%@... #.....
0000 0000 0000 0000 0107 0000 5351 4c4c ............SQLL
4430 3030 4e55 4c4c 4944 2020 6a41 7863 D000NULLID jAxc
5161 4450 5351 4c44 4120 2020 0000 2be4 QaDPSQLDA ..+
00ff 0000 5345 4c45 4354 202a 2046 524f ...SELECT * FRO
4d20 504b 494c 432e 4749 532e 4149 5250 M PKILC.GIS.AIRP
4f52 5453 5f50 4f4c 594c 6179 6572 7320 ORTS_POLYLayers
5748 4552 4520 7461 626c 655f 6e61 6d65 WHERE table_name
203d 2027 4341 5049 5441 4c43 4954 4945 = 'CAPITALCITIE
5327 2041 4e44 206f 776e 6572 203d 2027 S' AND owner = '
4749 5327 2041 4e44 2073 7061 7469 616c GIS' AND spatial
5f63 6f6c 756d 6e20 3d20 2753 4841 5045 _column = 'SHAPE
2741 4c00 4150 4527 5045 2700 7965 725f 'AL.APE'PE'.yer_
636f 6e66 6967 2c20 6f70 7469 6d61 6c5f config, optimal_
6172 7261 795f 7369 7a65 2c20 7374 6174 array_size, stat
735f 6461 s_da


2004-05-20-08.30.00.846945 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
oper_system_services sqloEDUCodeTrapHandler Probe:10 Database:PKILC

************************************************** ******************
* *
* 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. *
************************************************** ******************


2004-05-20-08.30.00.907690 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
oper_system_services sqloEDUCodeTrapHandler Probe:20 Database:PKILC

Signal number received
0000 0006 ....


2004-05-20-08.30.01.003676 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
relation_data_serv sqlrr_signal_handler Probe:10 Database:PKILC
DIA7107I Execution of a component signal handling function has begun.

2004-05-20-08.30.01.021271 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:PKILC
DIA3816C A severe internal processing error has occurred.

2004-05-20-08.30.01.039249 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
relation_data_serv sqlrr_dump_ffdc Probe:17 Database:PKILC
DIA9999E An internal error occurred. Report the following error code :
"0xFFFFF707".

Data TitleQLCA PID:40414 Node:000
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL07020
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000B3B
(4) 0x000006C6 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000

Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLCA
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataB2RA

Data Title:CREATOR PID:40414 Node:000
4e55 4c4c 4944 2020 NULLID


Data Title:PACKAGE PID:40414 Node:000
5351 4c4c 4430 3030 SQLLD000

Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:CREATOR
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:PACKAGE
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:REQUEST TYPE
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:Recursive dump_sect
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:PACKAGE ENTRY
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:USED_IN_UOW BIT VECTOR
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataECTION NUMBER
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataECTION DIR ENTRY
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:cursor name
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:cache cb

Data Title:section stmt PID:40414 Node:000
5345 4c45 4354 202a 2046 524f 4d20 504b SELECT * FROM PK
494c 432e 4749 532e 4149 5250 4f52 5453 ILC.GIS.AIRPORTS
5f50 4f4c 59 _POLY

Dump File:/home/db2inst2/sqllib/db2dump/40414.000 Data:section stmt

2004-05-20-08.30.01.487374 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:PKILC
DIA3816C A severe internal processing error has occurred.

ZRC=FFFFF707

2004-05-20-08.30.01.541079 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
relation_data_serv sqlrr_dump_ffdc Probe:902 Database:PKILC


Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLE_DBCB
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLD_DBCB
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLD_AGENT_CB
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLD_TRAN_CB

Data TitleQLD_AGENT_CB Pointer: PID:40414 Node:000
2026 22d8 &"


Data TitleQLD_AGENT_CB PID:40414 Node:000
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 1000 204f 1598 ............ O..
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 8000 2026 e2d8 ............ &
0000 1000 2027 62e8 0000 0000 0000 0000 .... 'b........


Data TitleQLD_TRAN_CB Pointer PID:40414 Node:000
2025 e378 %x

String Title:>> Begin CURSOR dump: PID:40414 Node:000
OPEN PERM CURSORS: >>

String Title:<< End CURSOR dump: PID:40414 Node:000
OPEN PERM CURSORS: <<


String Title:>> Begin CURSOR dump: PID:40414 Node:000
OPEN TEMP CURSORS: >>

String Title:<< End CURSOR dump: PID:40414 Node:000
OPEN TEMP CURSORS: <<


String Title:>> Begin CURSOR dump: PID:40414 Node:000
CLOSED CURSORS: >>

String TitleQLD_CCB: PID:40414 Node:000
pool(TID)=0, obj(FID)=33, indexid(IID)=0, class=0
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLD_CCB

String TitleQLD_CCB: PID:40414 Node:000
pool(TID)=2, obj(FID)=5, indexid(IID)=0, class=0
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLD_CCB

String TitleQLD_CCB: PID:40414 Node:000
pool(TID)=2, obj(FID)=4, indexid(IID)=0, class=0
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLD_CCB

String Title:<< End CURSOR dump: PID:40414 Node:000
CLOSED CURSORS: <<

Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLI_CB
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLE_ACB
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLP_ACB
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLP_DBCB
Dump File:/home/db2inst2/sqllib/db2dump/40414.000 DataQLP_TRTBL

String Title:locklist PID:40414 Node:000
Check /home/db2inst2/sqllib/db2dump/l29526.000 for additional data.

2004-05-20-08.30.02.616212 Instance:db2inst2 Node:000
PID:40414(db2agent (PKILC)) Appid:*LOCAL.db2inst2.040520132955
relation_data_serv sqlrr_signal_handler Probe:20 Database:PKILC
DIA7108I Execution of a component signal handling function is complete.