Datastage -Netezza Error : SQLCODE=HY000][Native=46] ERROR:

dgokulakrishnan · Post by **dgokulakrishnan** » Wed Oct 29, 2014 2:05 pm

Dear Team -

Designed a Parallel Job to invoke the Netezza Sequence by using "Netezza Connector" and this Parallel JOB has been executed with multiple instances but encountered with the following error.

; [SQLCODE=HY000][Native=46] ERROR: Deadlock detected. Resubmit your request.

I hope that due to concurrency issues the above error has been encountered.

At this moment, as an interim solution the autosys JILs are scheduled to run Sequentially instead of Parallel.

Is there any way to handle in Datastage level instead of Autosys JIL Level.

Thanks & Regards,
Gokul

ray.wurlod · Post by **ray.wurlod** » Thu Oct 30, 2014 12:40 am

Determine whether record-level or page-level deadlocks are occurring, with the help of your DBA. If it's record-level, you can change your job design so that the same key value cannot be processed on more than one partition.

dgokulakrishnan · Post by **dgokulakrishnan** » Thu Oct 30, 2014 8:07 am

Thanks Ray.

I noticed that we are using Netezza V7.X and Datastage V8.7 but the Netezza Connector has the variant 4.5

If I try to install the fix pack for the latest Netezza Connector Stage, would it help ?.

However, I shall check with my DBA to determine whether its a page-level or Record-Level deadlocks.

chulett · Post by **chulett** » Thu Oct 30, 2014 8:29 am

I doubt it would help in this circumstance but it's always good to be current on your fixpacks.