I have a server W2k running DB2 8.1.6. We have two databases one DBDC
that holds our user base and QUALITY with all our application data. I
have about 8 tables federated on QUALITY looking at the table on DBDC.
The traffic should be minimal the call to the remote tables is just for
user log in. It appears that the db2syscs.exe process grows quite a
bit 1,518,538 K. There is some issue with the connection to the
federated tables. below is the information from the diaglog. If
anyone sees anything that tells them what is going on I would
appreciate any guesses or help.
2005-01-19-16.19.03.687000 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:2392 Appid:*LOCAL.PROD.050119185349
drda wrapper get_error_info Probe:1 Database:QUALITY
DRDA Server:
0x77587FC0 : 4442 4443 5F47 4C4F 4241 4C DBDC_GLOBAL
2005-01-19-16.19.03.687001 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:168 Appid:GA1FA4F5.KC06.015949183815
drda wrapper get_error_info Probe:1 Database:QUALITY
DRDA Server:
0x71817F90 : 4442 4443 5F47 4C4F 4241 4C DBDC_GLOBAL
2005-01-19-16.19.03.687002 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:3072 Appid:*LOCAL.PROD.050119192052
drda wrapper get_error_info Probe:1 Database:QUALITY
DRDA Server:
0x714CFF00 : 4442 4443 5F47 4C4F 4241 4C DBDC_GLOBAL
2005-01-19-16.19.03.687003 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:2392 Appid:*LOCAL.PROD.050119185349
drda wrapper get_error_info Probe:2 Database:QUALITY
Function name:
0x6C5A85C4 : 5351 4C44 6973 636F 6E6E 6563 74 SQLDisconnect
2005-01-19-16.19.03.687004 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:168 Appid:GA1FA4F5.KC06.015949183815
drda wrapper get_error_info Probe:2 Database:QUALITY
Function name:
0x6C5A85C4 : 5351 4C44 6973 636F 6E6E 6563 74 SQLDisconnect
2005-01-19-16.19.03.703000 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:3072 Appid:*LOCAL.PROD.050119192052
drda wrapper get_error_info Probe:2 Database:QUALITY
Function name:
0x6C5A85C4 : 5351 4C44 6973 636F 6E6E 6563 74 SQLDisconnect
2005-01-19-16.19.03.703001 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:2392 Appid:*LOCAL.PROD.050119185349
drda wrapper get_error_info Probe:3 Database:QUALITY
ODBC native err:
0x7AF8A81C : 2D39 3939 3939 -99999
2005-01-19-16.19.03.703002 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:168 Appid:GA1FA4F5.KC06.015949183815
drda wrapper get_error_info Probe:3 Database:QUALITY
ODBC native err:
0x7B0FA61C : 2D39 3939 3939 -99999
2005-01-19-16.19.03.703003 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:3072 Appid:*LOCAL.PROD.050119192052
drda wrapper get_error_info Probe:3 Database:QUALITY
ODBC native err:
0x77DEBC1C : 2D39 3939 3939 -99999
2005-01-19-16.19.03.703004 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:2392 Appid:*LOCAL.PROD.050119185349
drda wrapper get_error_info Probe:4 Database:QUALITY
ODBC sqlstate:
0x7AF8A80D : 3031 3030 3200 01002.
2005-01-19-16.19.03.718000 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:168 Appid:GA1FA4F5.KC06.015949183815
drda wrapper get_error_info Probe:4 Database:QUALITY
ODBC sqlstate:
0x7B0FA60D : 3031 3030 3200 01002.
2005-01-19-16.19.03.718001 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:3072 Appid:*LOCAL.PROD.050119192052
drda wrapper get_error_info Probe:4 Database:QUALITY
ODBC sqlstate:
0x77DEBC0D : 3031 3030 3200 01002.
2005-01-19-16.19.03.718002 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:2392 Appid:*LOCAL.PROD.050119185349
drda wrapper get_error_info Probe:5 Database:QUALITY
ODBC error txt:
0x7AF8A40C : 5B49 424D 5D5B 434C 4920 4472 6976 6572 [IBM][CLI
Driver
0x7AF8A41C : 5D20 434C 4930 3030 3157 2020 4469 7363 ] CLI0001W
Disc
0x7AF8A42C : 6F6E 6E65 6374 2065 7272 6F72 2E20 5351 onnect error.
SQ
0x7AF8A43C : 4C53 5441 5445 3D30 3130 3032 LSTATE=01002
2005-01-19-16.19.03.718003 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:168 Appid:GA1FA4F5.KC06.015949183815
drda wrapper get_error_info Probe:5 Database:QUALITY
ODBC error txt:
0x7B0FA20C : 5B49 424D 5D5B 434C 4920 4472 6976 6572 [IBM][CLI
Driver
0x7B0FA21C : 5D20 434C 4930 3030 3157 2020 4469 7363 ] CLI0001W
Disc
0x7B0FA22C : 6F6E 6E65 6374 2065 7272 6F72 2E20 5351 onnect error.
SQ
0x7B0FA23C : 4C53 5441 5445 3D30 3130 3032 LSTATE=01002
2005-01-19-16.19.03.718004 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:3072 Appid:*LOCAL.PROD.050119192052
drda wrapper get_error_info Probe:5 Database:QUALITY
ODBC error txt:
0x77DEB80C : 5B49 424D 5D5B 434C 4920 4472 6976 6572 [IBM][CLI
Driver
0x77DEB81C : 5D20 434C 4930 3030 3157 2020 4469 7363 ] CLI0001W
Disc
0x77DEB82C : 6F6E 6E65 6374 2065 7272 6F72 2E20 5351 onnect error.
SQ
0x77DEB83C : 4C53 5441 5445 3D30 3130 3032 LSTATE=01002
2005-01-19-16.19.06.390000 Instance:PROD Node:000
PID:1152(db2syscs.exe) TID:2188 Appid:none
data protection sqlpghck Probe:1390