connector-troubleshoot-db2.md

title	Troubleshoot the DB2 connector
titleSuffix	Azure Data Factory & Azure Synapse
description	Learn how to troubleshoot issues with the DB2 connector in Azure Data Factory and Azure Synapse Analytics.
author	jianleishen
ms.subservice	data-movement
ms.topic	troubleshooting
ms.date	10/20/2023
ms.author	jianleishen
ms.custom	has-adal-ref, synapse

Troubleshoot the DB2 connector in Azure Data Factory and Azure Synapse

[!INCLUDEappliesto-adf-asa-md]

This article provides suggestions to troubleshoot common problems with the Azure Database for PostgreSQL connector in Azure Data Factory and Azure Synapse.

Error code: DB2DriverRunFailed

• Message: Error thrown from driver. Sql code: '%code;'

• Cause: If the error message contains the string "SQLSTATE=51002 SQLCODE=-805", follow the "Tip" in Copy data from DB2.

• Recommendation: Try to set "NULLID" in the packageCollection property.

Related content

For more troubleshooting help, try these resources:

• Connector troubleshooting guide
• Data Factory blog
• Data Factory feature requests
• Azure videos
• Microsoft Q&A page
• Stack Overflow forum for Data Factory
• X information about Data Factory