Hi,

I tried to setup QP for a db. I used instance ID to run the qpsetup but got DQP0019E SYSADM authority is required to issue "qpsetup" command.

Anything fishy ?

Please advise.

TIA...

I managed to run the qpsetup with pre-created tablespaces. Looks ok now. But when I issue qpstart...it hangs...


2006-08-14-11.50.08 Instance:test21 Database:db21 Node:TEST06
Process:602182 Thread:Query Controller ??? ??? ???
java.lang.NoSuchFieldError: com.ibm.xml.b2b.util.XMLString: field length not found
at com.ibm.db2.qp.xml.B2BHandler.parse(B2BHandler.jav a:73)
at com.ibm.db2.qp.qc.QCStartupCheck.check(QCStartupCh eck.java:134)
at com.ibm.db2.qp.qc.QCStartupCheck.<init>(QCStartupC heck.java:73)
at com.ibm.db2.qp.qc.QueryController.<init>(QueryCont roller.java:254)
at com.ibm.db2.qp.qc.QueryController.main(QueryContro ller.java:1503)

Any idea what's that ?

I thought the problem about prereq' qpsetting..
I requested your server machine' env.
You need to certain your enviroment...
--
ex) aix5L : run lslpp -la | grep -i xlc
Running - xlC.rte.5.0.
Sent customer prereqs for 8.1 FP6 AIX 5.1
Maintence Level 5 . Fixes for APAR's IY48735, IY49254, C++ Runtime level
of xlC.rte 6.0.0.
xlC.aix50.rte 6.0.0.5