DB2- Check Pending,Release Pending,Copy Pending

Three most popular pending states in DB2. As a developer you may scare some times seeing the error states.

# 1 point: First we have to make sure which pending state and need to select suitable corrective step.

Yes, I am giving here all 3 pending states and corrective steps.

Check Pending:This will occur when loading data into table-space, due to referential integrity constraints.

Corrective Step: Run REORG utility on the table space, then, run CHECK DATA utility.

Release Pending: When working with remote connections, the remote connection that is not going to be used will be kept in Release pending state

Corrective Step: Commit/Rollback will close all the Release-pend state connections.

Copy Pending: Check here for detailed description.

Corrective Step:  Click here


Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.

Comments are closed.