Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    8

    Unanswered: DB2 Query Patroler QPSETUP

    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...

  2. #2
    Join Date
    Mar 2006
    Posts
    8
    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 ?

  3. #3
    Join Date
    Aug 2003
    Posts
    5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •