DBRM and runjcl.



IBM's flagship relational database management system

DBRM and runjcl.

Postby Venkat Sri » Mon Oct 08, 2018 9:41 pm

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 Sri
 
Posts: 1
Joined: Mon Oct 08, 2018 2:28 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DBRM and runjcl.

 

Re: DBRM and runjcl.

Postby Jim Ruddy » Thu Dec 20, 2018 3:20 am

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
Jim Ruddy
 
Posts: 5
Joined: Tue Jan 16, 2018 11:45 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post