ODBC Sparce error

deployDS · Post by **deployDS** » Fri Dec 01, 2006 10:26 am

We have a job that involves sparce lookup. We have executed it for multiple cyccles in the past 2 months but never had any problem. But yesterday it was suddenly aborted with the following error:

Fatal Error: Could not connect to datasource[DataDirect][ODBC DB2 Wire Protocol driver]Abnormal end unit of work condition occurred.

We checked with the DBA that there are no deadlocks. Did anyone encounter this error before? What could be the possible reasons?

Thanks!

ray.wurlod · Post by **ray.wurlod** » Fri Dec 01, 2006 2:55 pm

Is it repeatable, or did it happen just once? If just once, it may have been a glitch in the network.

deployDS · Post by **deployDS** » Mon Dec 04, 2006 10:16 am

It is repeating. We are unable to get it working how many ever times we run it.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 04, 2006 5:09 pm

I wonder if it's an issue with the Data Direct ODBC licence? According to the Parallel Job Developer's Guide manual and IBM's training classes, sparse lookup is only supported for DB2/UDB and Oracle Enterprise stages. So you may have exhausted the grace period on the licence for your ODBC driver.