Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    36

    Unanswered: DB2 XML Extender - Enable DB not working

    Hi,
    Whenever I am clicking on the Enable Database in the XML Extender administration wizard after entering the following details
    Address : jdbc:db2://176.16.136.161:50000/SAMPLE
    user : Administrator
    password : <password>
    JDBC Driver : com.ibm.db2.jcc.DB2Driver( changed from default
    COM.ibm.db2.jdbc.app.DB2Driver)


    I am getting the following exception
    Enable database "SAMPLE" failed. Exception :com.ibm.db2.jcc.a.SQLException:Routine "DXXENABLEDB"(Specific name "SQL021129161855540") is implemented with code in library or path "\DB2XML", function "DXXENABLEDB" which cannot be accessed. reason code: "6"

    The console shows the following detailed exception:

    Schema now = QDB2XML
    Trying schema = QDB2XML
    XXX ENABLE DB
    Name DBccc = "SAMPLE"
    Statement = "com.ibm.db2.jcc.a.cg@267649"
    com.ibm.db2.jcc.a.SQLException: Routine "DXXENABLEDB" (specific name "SQL0211291
    63308570") is implemented with code in library or path "\QDB2XML", function "DXX
    ENABLEDB" which cannot be accessed. Reason code: "4".
    at com.ibm.db2.jcc.a.ce.d(ce.java:937)
    at com.ibm.db2.jcc.c.bd.k(bd.java:312)
    .cg.execute(cg.java:110)
    at com.ibm.dxx.common.DatabaseObject.enableDatabase(D atabaseObject.java:
    382)
    SOME MORE...............

    at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:93)
    at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:84)
    mess = Routine "DXXENABLEDB" (specific name "SQL021129163308570") is implemented
    with code in library or path "\QDB2XML", function "DXXENABLEDB" which cannot be
    accessed. Reason code: "4".
    err = -444
    Schema now = db2xml
    Trying schema = db2xml
    XXX ENABLE DB
    Name DBccc = "SAMPLE"
    Statement = "com.ibm.db2.jcc.a.cg@1fe88d"
    com.ibm.db2.jcc.a.SQLException: Routine "DXXENABLEDB" (specific name "SQL0211291
    63308730") is implemented with code in library or path "\DB2XML", function "DXXE
    NABLEDB" which cannot be accessed. Reason code: "6".
    at com.ibm.db2.jcc.a.ce.d(ce.java:937)
    at com.ibm.db2.jcc.c.bd.k(bd.java:312)
    at com.ibm.db2.jcc.c.bd.e(bd.java:89)
    :915)
    at com.ibm.db2.jcc.a.cf.a(cf.java:1472)
    at com.ibm.dxx.common.DatabaseObject.enableDatabase(D atabaseObject.java:
    382)
    at com.ibm.dxx.common.DatabaseObject.databaseObjectCo mmand(DatabaseObjec
    t.java:894)
    at com.ibm.dxx.common.DatabaseObject.databaseObjectCo mmand(DatabaseObjec
    t.java:826)
    at com.ibm.dxx.a
    SOME MORE


    What could be reason for this exception???

    My classpath has both dxxadmin.jar and xml4j.jar as below.
    D:\PROGRA
    ~1\dxx\dxxadmin\dxxadmin.jar;D:\PROGRA~1\dxx\dxxad min\xml4j.jar"

  2. #2
    Join Date
    Jan 2003
    Posts
    24
    Hi.

    Have you bound the XML Extender stored procedures to the database? If not, you need to bind the file "dxxbind.lst" before you (or the admin gui) can use the stored procedure "enable_db".

    There is an example of how to do this in the samples directory (if you've installed the samples) called: "getstart_prep.cmd"

    Regards
    /Daniel

Posting Permissions

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