SQL1086C An operating system error "" occurred on databasemetadata.getcolumns()

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jairam Panickssery

    SQL1086C An operating system error "" occurred on databasemetadata.getcolumns()

    I have a simple JDBC 2.0(app driver) code snippet like:
    ############### ############
    cSQL = DriverManager.g etConnection(sD BURL, sDBUser, sDBPasswd);
    DatabaseMetaDat a dmd = cSQL.getMetaDat a();
    //rs = dmd.getColumns( null, null, tableName.toUpp erCase(), null );
    rs = dmd.getColumns( null, "DB2INST1", tableName.toUpp erCase(), null
    );
    ############### ############

    When I run this against my db2 database:
    ############### ############### #
    Database Name DB2/6000
    Database version :07.02.0006
    Driver Major Version :7
    Driver Minor Version :1
    ############### ############### #

    I get this stack trace:
    ############### ############### ##############
    COM.ibm.db2.jdb c.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL1086C
    An operating system error "" occurred.
    at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExceptionG enerator.java:2 73)
    at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExceptionG enerator.java:2 10)
    at COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.ch eck_return_code (SQLExceptionGe nerator.java:46 1)
    at COM.ibm.db2.jdb c.app.DB2Databa seMetaData.getC olumns(DB2Datab aseMetaData.jav a:1950)
    at connectDB2.main (connectDB2.jav a:47)
    ############### ############### ##############

    Has anyone seen this before ?

    Thanks in advance,
    Jairam
Working...