IBM Mainframe Forum Index
Log In
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register

Explain db2 precompiler process

IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message

Active User

Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Sun Jun 06, 2004 3:37 pm
Reply with quote


if my interviewer asks explain db2 precompiler process.
whatz the answer? Can anyone explain in detail,
explain each process (bind, package, collection)


karthi G.
Back to top
View user's profile Send private message


Joined: 28 Jan 2004
Posts: 37
Location: Trivandrum

PostPosted: Mon Jun 07, 2004 2:17 pm
Reply with quote

Hello friend,

Here am trying to explain the DB2 - cobol process. The first stage is the precompilation step where the cobol program with the embedded SQL will be modified to form the modified source code and also the DBRM. The DBRM contains the sql statements. The timestamp is also alloted here, the information remains with both DBRM and the modified source code. In the modified source code the sql statemements will be replaced by call to DSNHLI statements with some 5 parameters. These are

1. The DBRM name.
2. SQL statement numbers.
3. The timestamp information.
4. Address info of SQLCA
5. Address info of host variables.

The DBRM undergoes the bind process and package is created. The package is not an executable so we make use of plan. The plan contains pointers to packages.

The modified source code is compiled , link edited to form load module. Then the timestamp is matched with the info in package. If mismatch is there we get timestamp mismatch error and rebind has to be done with proper DBRM.

here i have given just a rough idea abt the process. Pls do read some books for better clarity.

corrections are welcome


Back to top
View user's profile Send private message

New User

Joined: 27 Feb 2004
Posts: 18

PostPosted: Mon Jun 07, 2004 7:36 pm
Reply with quote

Hi Hari

If we are changing the modified source program and we are not binding it what will happen? And in a case i m not changing the progm and again binding what will happen? Here in which case the timestand mismach will occur?

Can pls explain?

Back to top
View user's profile Send private message

Active User

Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Tue Jun 08, 2004 9:01 pm
Reply with quote

hello nandini,

if you are modifying the program and if you are not binding it, you will get a timestamp mismatch error.

Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2


Similar Topics
Topic Forum Replies
No new posts DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts process statement for SUPREC, CMPCOLM... TSO/ISPF 4
No new posts How to process dependent file based o... JCL & VSAM 8
No new posts Bind process DB2 4
This topic is locked: you cannot edit posts or make replies. How to process gdg in rexx program wh... CLIST & REXX 12
Search our Forums:

Back to Top