Federated Table Errors

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • stevenkblack@gmail.com
    #1

    Federated Table Errors

    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(db2sys cs.exe) TID:2392 Appid:*LOCAL.PR OD.050119185349
    drda wrapper get_error_info Probe:1 Database:QUALIT Y

    DRDA Server:
    0x77587FC0 : 4442 4443 5F47 4C4F 4241 4C DBDC_GLOBAL

    2005-01-19-16.19.03.687001 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:168 Appid:GA1FA4F5. KC06.0159491838 15
    drda wrapper get_error_info Probe:1 Database:QUALIT Y

    DRDA Server:
    0x71817F90 : 4442 4443 5F47 4C4F 4241 4C DBDC_GLOBAL

    2005-01-19-16.19.03.687002 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:3072 Appid:*LOCAL.PR OD.050119192052
    drda wrapper get_error_info Probe:1 Database:QUALIT Y

    DRDA Server:
    0x714CFF00 : 4442 4443 5F47 4C4F 4241 4C DBDC_GLOBAL

    2005-01-19-16.19.03.687003 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:2392 Appid:*LOCAL.PR OD.050119185349
    drda wrapper get_error_info Probe:2 Database:QUALIT Y

    Function name:
    0x6C5A85C4 : 5351 4C44 6973 636F 6E6E 6563 74 SQLDisconnect

    2005-01-19-16.19.03.687004 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:168 Appid:GA1FA4F5. KC06.0159491838 15
    drda wrapper get_error_info Probe:2 Database:QUALIT Y

    Function name:
    0x6C5A85C4 : 5351 4C44 6973 636F 6E6E 6563 74 SQLDisconnect

    2005-01-19-16.19.03.703000 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:3072 Appid:*LOCAL.PR OD.050119192052
    drda wrapper get_error_info Probe:2 Database:QUALIT Y

    Function name:
    0x6C5A85C4 : 5351 4C44 6973 636F 6E6E 6563 74 SQLDisconnect

    2005-01-19-16.19.03.703001 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:2392 Appid:*LOCAL.PR OD.050119185349
    drda wrapper get_error_info Probe:3 Database:QUALIT Y

    ODBC native err:
    0x7AF8A81C : 2D39 3939 3939 -99999

    2005-01-19-16.19.03.703002 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:168 Appid:GA1FA4F5. KC06.0159491838 15
    drda wrapper get_error_info Probe:3 Database:QUALIT Y

    ODBC native err:
    0x7B0FA61C : 2D39 3939 3939 -99999

    2005-01-19-16.19.03.703003 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:3072 Appid:*LOCAL.PR OD.050119192052
    drda wrapper get_error_info Probe:3 Database:QUALIT Y

    ODBC native err:
    0x77DEBC1C : 2D39 3939 3939 -99999

    2005-01-19-16.19.03.703004 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:2392 Appid:*LOCAL.PR OD.050119185349
    drda wrapper get_error_info Probe:4 Database:QUALIT Y

    ODBC sqlstate:
    0x7AF8A80D : 3031 3030 3200 01002.

    2005-01-19-16.19.03.718000 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:168 Appid:GA1FA4F5. KC06.0159491838 15
    drda wrapper get_error_info Probe:4 Database:QUALIT Y

    ODBC sqlstate:
    0x7B0FA60D : 3031 3030 3200 01002.

    2005-01-19-16.19.03.718001 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:3072 Appid:*LOCAL.PR OD.050119192052
    drda wrapper get_error_info Probe:4 Database:QUALIT Y

    ODBC sqlstate:
    0x77DEBC0D : 3031 3030 3200 01002.

    2005-01-19-16.19.03.718002 Instance:PROD Node:000
    PID:1152(db2sys cs.exe) TID:2392 Appid:*LOCAL.PR OD.050119185349
    drda wrapper get_error_info Probe:5 Database:QUALIT Y

    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(db2sys cs.exe) TID:168 Appid:GA1FA4F5. KC06.0159491838 15
    drda wrapper get_error_info Probe:5 Database:QUALIT Y

    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(db2sys cs.exe) TID:3072 Appid:*LOCAL.PR OD.050119192052
    drda wrapper get_error_info Probe:5 Database:QUALIT Y

    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(db2sys cs.exe) TID:2188 Appid:none
    data protection sqlpghck Probe:1390

    Tags: None
    Previous template Next
    Working...