CLI0611E incorrect column name

  • jean pierre

    jean pierre - 2011-05-26


    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
    11:58:58.723 INFO:    SchemaAnalyzer.getConnection - Using database properties:
    11:58:58.723 INFO:    SchemaAnalyzer.getConnection -   [C:\produits\graphviz2.28
    11:59:00.019 INFO:    SchemaAnalyzer.analyze - Connected to DB2 - 08.01.0005
    11:59:00.019 INFO:    SchemaAnalyzer.analyze - Gathering schema details  CLI0611E Nom de colonne incorr
    ect. SQLSTATE=S0022
            at Source
            at Source)
            at Source)
            at net.sourceforge.schemaspy.model.Database.getBasicTableMeta(Database.j
            at net.sourceforge.schemaspy.model.Database.initTables(
            at net.sourceforge.schemaspy.model.Database.<init>(
            at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(
            at net.sourceforge.schemaspy.Main.main(


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



Log in to post a comment.