IBM Mainframe Forum

Hi,

I have two basic questions.

When we compile and link edit a cobol-db2 program, same timestamp goes to both load module and DBRM. DBRM contains all the sql statements, and when it go through bind process, a package or plan will be created with same timestamp.

After bind, does all SQL statements are in package or plan?

Does DBRM still needed when running the program and once bind is done, it is not required anymore?

Thanks.

Venkat,

Once the bind is completed, the contents of the DBRM are now stored in the DB2 catalog and the DBRM is not required to run your program. Do you need to keep it? Not really but occasionally an error (usual human) occurs and the package will get freed. If you retain your DBRMs, then it is a simple matter of redoing the BIND to match your program. The alternative to that is a pre-compile/compile and all the other pieces. Often this upsets production management staff.

Jim