Hi all,
I just get this problem out of nowhere. When I try to run some query, it gave me error "SQL29007N Unable to communicate with the Query Controller." Then I restarted the query controller by "qpstart SAMPLE". Its same. Then I rebooted the server, no use.
In the db2diag, it shows the following messages. what should I do to fix it?
Thanks a lot!
------------------------------------------
2010-07-02-11.54.52.226245-600 E42416773E7359 LEVEL: Error (OS)
PID : 5743 TID : 47810946787648P ROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-17 APPID: *LOCAL.db2inst1 .100702215348
AUTHID : DB2INST1
EDUID : 31 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Query Patroller Server, qcConnection, probe:20
CALLED : DB2 UDB, Query Patroller Common, SocketConnectio n::openConnecti on OSERR: EADDRNOTAVAIL (99)
MESSAGE : QP attempt at new connection failed (99); read params from config
file and retry...
DATA #1 : Hexdump, 1316 bytes
0x00002B7BE3192 940 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x00002B7BE3192 950 : 716C 6C69 622F 6374 726C 2F71 702F 5349 qllib/ctrl/qp/SAM
0x00002B7BE3192 960 : 5445 2E63 6667 0000 0000 0000 0000 0000 PLE.cfg........ ..
2010-07-02-11.54.55.259852-600 E42424133E618 LEVEL: Error (OS)
PID : 5743 TID : 47810946787648P ROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-17 APPID: *LOCAL.db2inst1 .100702215348
AUTHID : DB2INST1
EDUID : 31 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Query Patroller Server, qcConnection, probe:50
CALLED : DB2 UDB, Query Patroller Common, connectToQC OSERR: EADDRNOTAVAIL (99)
MESSAGE : QP alternate attempt at connection failed (99)
DATA #1 : File name, 38 bytes
/home/db2inst1/sqllib/ctrl/qp/SAMPLE.cfg
2010-07-02-11.54.55.260012-600 E42424752E538 LEVEL: Error (OS)
PID : 5743 TID : 47810946787648P ROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-17 APPID: *LOCAL.db2inst1 .100702215348
AUTHID : DB2INST1
EDUID : 31 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Query Patroller Server, QPInitiateQuery , probe:40
CALLED : DB2 UDB, Query Patroller Server, qcConnection OSERR: EADDRNOTAVAIL (99)
MESSAGE : QP connection last TCP/IP error
------------------------------------------
I just get this problem out of nowhere. When I try to run some query, it gave me error "SQL29007N Unable to communicate with the Query Controller." Then I restarted the query controller by "qpstart SAMPLE". Its same. Then I rebooted the server, no use.
In the db2diag, it shows the following messages. what should I do to fix it?
Thanks a lot!
------------------------------------------
2010-07-02-11.54.52.226245-600 E42416773E7359 LEVEL: Error (OS)
PID : 5743 TID : 47810946787648P ROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-17 APPID: *LOCAL.db2inst1 .100702215348
AUTHID : DB2INST1
EDUID : 31 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Query Patroller Server, qcConnection, probe:20
CALLED : DB2 UDB, Query Patroller Common, SocketConnectio n::openConnecti on OSERR: EADDRNOTAVAIL (99)
MESSAGE : QP attempt at new connection failed (99); read params from config
file and retry...
DATA #1 : Hexdump, 1316 bytes
0x00002B7BE3192 940 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x00002B7BE3192 950 : 716C 6C69 622F 6374 726C 2F71 702F 5349 qllib/ctrl/qp/SAM
0x00002B7BE3192 960 : 5445 2E63 6667 0000 0000 0000 0000 0000 PLE.cfg........ ..
2010-07-02-11.54.55.259852-600 E42424133E618 LEVEL: Error (OS)
PID : 5743 TID : 47810946787648P ROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-17 APPID: *LOCAL.db2inst1 .100702215348
AUTHID : DB2INST1
EDUID : 31 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Query Patroller Server, qcConnection, probe:50
CALLED : DB2 UDB, Query Patroller Common, connectToQC OSERR: EADDRNOTAVAIL (99)
MESSAGE : QP alternate attempt at connection failed (99)
DATA #1 : File name, 38 bytes
/home/db2inst1/sqllib/ctrl/qp/SAMPLE.cfg
2010-07-02-11.54.55.260012-600 E42424752E538 LEVEL: Error (OS)
PID : 5743 TID : 47810946787648P ROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-17 APPID: *LOCAL.db2inst1 .100702215348
AUTHID : DB2INST1
EDUID : 31 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Query Patroller Server, QPInitiateQuery , probe:40
CALLED : DB2 UDB, Query Patroller Server, qcConnection OSERR: EADDRNOTAVAIL (99)
MESSAGE : QP connection last TCP/IP error
------------------------------------------
Comment