LHException when reading metadata from DB2

[Former Member]

Hi,

I am using MII Version 12.1.0 Build(201) and successfully connected to a DB2 9.5 UDB.

Configuration

JDBC (JARs from DB2 9.5)

+ db2jcc.jar --> type 4 (pure Java) JDBC 3.0 driver

+ db2jcc_license_cu.jar --> license for the driver

IDBC Connector

+ JDBCDriver = com.ibm.db2.jcc.DB2Driver

+ ServerURL = jdbc:db2://host:1234/dbname

+ Valid user name and password

+ ValidationQuery = SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1

I am able to execute my own fixed SQL queries in the workbench, but when it comes to reading the database metadata (e.g. the available table names in modus "TableList") then MII fails with this error.

com.sap.xmii.Illuminator.logging.LHException: 
SQL error has occurred on query 
[jcc][t4][10120][10898][3.53.95] 
Invalid operation: result set is closed. 
ERRORCODE=-4470, SQLSTATE=null

Information from DB2 Information Center

-4470 text-from-getMessage

Explanation: The requested operation cannot be performed because the target resource is closed.

User response: Call SQLException.getMessage to retrieve specific information about the problem.

I don't see a chance to solve this problem without deeper knowledge of the MII internals. Any ideas?

Best regards,

Martin

[Former Member]

Hi Martin,

I am on version 12.0.4 and was getting the same error. I took a look at ???, I don't remember, but it was a timeout. I guessed that the DB2 schema was too big to pull back in the time that MII has alotted to do that. I gave up as static queries work without getting the meta-data and I'm too busy to fix non-issues here so...

--Amy Smith

--Haworth

[Former Member]

Here is the thread I opened. It has more detail...

--Amy

[agentry_src]

Martin,

You should be working in the GA version of 12.1 (12.1.4). You are using a fairly outdated version of 12.1.

Regards,

Mike