Start of change

BND019E Deletion of source statements has invalidated the DBRM—add comment lines to correct // BND019E Old stmt nbr=xxxx (hex), New stmt nbr=yyyy (hex)

Explanation

Statements were deleted from a large source module.

With the Db2 precompiler, when a COBOL program grows so that at least one SQL statement has a relative line number greater than 9999, the internal format of the DBRM changes. This changed internal format can later cause a compatibility problem if lines are subsequently deleted so that all SQL statements again have line numbers less than 10,000. This sequence of events creates a condition that Bind Manager cannot handle. Therefore, a bind cannot be avoided.

The situation does not arise in DB2® UDB for z/OS® 8 new-function mode or later.

xxxx and yyyy
The statement numbers from the DBRM records in which the condition was detected
Module: ADBBMAV

System action

Processing continues.

User response

If the SQL structure was not changed, you can circumvent this situation by taking the following steps:
  1. Restore the old DBRM (the version that was saved in the job step before the precompiler step).
  2. Rather than deleting source statements, comment them out. This action leaves the relative line numbers unchanged.
  3. Rerun the compile job.
End of change