CLI0611E incorrect column name

Help
2011-05-26
2013-05-29
  • jean pierre
    jean pierre
    2011-05-26

    Hi,

    I try to retrieve the metadata of a schema in a db2zos database from my windows client. the connection is to my database is ok but i have an error after => CLI0611E .  Can you help me ?

    I have tried also to retrieve metadata from a db2 aix database and there was no problem.

    this is the log for the db2zos database :

    C:\Produits\IBM\SQLLIB\bnd>java -jar "C:\produits\graphviz2.28\SchemaSpy\schemaS
    py_5.0.0.jar" -t db2zos -host vipav012  -port 8080 -u xxxxxx -p yyyyyy -db dsnd
    b2uv -o "C:\tmp" -dp "C:\Program files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar"
    -s TEST2P -loglevel finest
    11:58:58.551 INFO:    SchemaAnalyzer.analyze - Starting schema analysis
    11:58:58.723 CONFIG:  ConnectionURLBuilder.<init> - connectionURL: jdbc:db2:dsnd
    b2uv
    11:58:58.723 INFO:    SchemaAnalyzer.getConnection - Using database properties:
    11:58:58.723 INFO:    SchemaAnalyzer.getConnection -   [C:\produits\graphviz2.28
    \SchemaSpy\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/db2zos.propert
    ies
    11:59:00.019 INFO:    SchemaAnalyzer.analyze - Connected to DB2 - 08.01.0005
    11:59:00.019 INFO:    SchemaAnalyzer.analyze - Gathering schema details
    COM.ibm.db2.jdbc.DB2Exception:  CLI0611E Nom de colonne incorr
    ect. SQLSTATE=S0022
            at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.rsException(Unknown Source
    )
            at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn(Unknown Source)
            at COM.ibm.db2.jdbc.app.DB2ResultSet.getString(Unknown Source)
            at net.sourceforge.schemaspy.model.Database.getBasicTableMeta(Database.j
    ava:389)
            at net.sourceforge.schemaspy.model.Database.initTables(Database.java:232
    )
            at net.sourceforge.schemaspy.model.Database.<init>(Database.java:71)
            at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:
    211)
            at net.sourceforge.schemaspy.Main.main(Main.java:42)

    thanks

     
  • jean pierre
    jean pierre
    2011-07-06

    For your information
    I have finally succeed to retrieve the metadata for a DB2 ZOS database.
    I have to change the ZPARM with DESCSTAT=YES and bind again all the package of the DSNASPCC collection.
    all is ok now.

     
  • John Currier
    John Currier
    2011-07-06

    Thanks for the update.  That'll help subsequent users that run into the same issue.

    John