Query Patroller

Haldur Johansen

Query Patroller

I am on DB2 8.1.16 on Windows and have problems with Query Patroller.

I created ts like this:
db2 create tablespace qpc managed by system using ('r:\FBK\FBDWxxdp\qpc')
db2 create tablespace qpr managed by system using ('r:\FBK\FBDWxxdp\qpr')

and run qpsetup like this:
qpsetup db fbdwxxdp control_tablespace qpc
control_path 'r:/fbk/fbdwxxdp/qpc' result_tablespace qpr
result_path 'r:/fbk/fbdwxxdp/qpr' replace

But when I do:
qpstart fbdwxxdp

I get this:

C:\>qpstart fbdwxxdp
IBM DB2 Query Patroller Version 8, (c) Copyright IBM Corp. 1998 - 2004. All righ
ts reserved.
DQP0432E Unable to communicate with the DB2 Query Patroller Java process.

and my qpdiag.log says:

2008-11-21-10.40.00 Instance:FBK Database:fbdwxxdp Node
PID:2700(qplaunch.exe) Query Patroller Server unknown
qpLauncher.C: line 383

QueryController or Terminator java process has terminated or failed.

Can anyone help me?

Best Regards,
Haldur Johansen
Systems Programmer DB2


* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *

The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms