Communication link failure

[ThilSe]

Hi,

I need to delete 6million records from a MDC table in DB2. For this i have a job.I am using the MDC and the partition key for deletion in DB2 API stage.

I get the following error after executing for sometime.

DB2_AGI_UA_SITM_S_Del,7: ERROR during execution of DB2-CLI requests: SQL_ERROR; SQLSTATE = 40003; NativeErrorCode = -99999; Message = [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=4000. [db2driver_cli.C:814]

I get the same error when the DB2 Enterprise stage is used.

Please clarify.

Thanks
Senthil

[kduke]

Usually someone (maybe a DBA) has killed this session. I would bet you are running out of rollback space.