Hi Im trying to import data from a CSV file to Db2. I have installed the jar files, and the Connection to db2 Works. But when I run the jobb I get an error bellow. Any tips on troubleshoting this? Im running DB2 10.5 FP4 on REHL 7 Br Petter
failed to close the connection in tDB2Output_1 : java.sql.Connection.close() requested while a transaction is in progress on the connection.
The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
Hi, Can you show the job screenshot, it seems that the job is trying to close the connection before the completion of your data read-write operations. Do you have a connection close component, if it is there, move it to tPostJob-->tconnectionClose Vaibhav