what things are done for compile and promote

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

I am not very clear about what things are done when the PLI with DB2 code are compiled, and what things are done when the compiled code is promoted, could someone explain it, thx!

dick scherrer · Posted: Sat Mar 14, 2009 6:46 am

Hello,

Compilation and promotion are not unique for pli or pli/db2.

Compile takes source code as input and generates an executable load module as output.

Promotion involves elevating components to the next "higher" operational level. In a simpler environment ror example, when developers are done testing an applicaton or changes to one, the code is promoted to production.

In more complex environment, promotion may be from development to a formal test environment. From there to a User Acceptance Test environment (that is virtually a mirror of production) where final user sign-off is made) and then to Production.

The promotion process is entirely organization specific. Depending on the size of IT, there may be different promotion processes due to incomplete evolution.

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

I know how to deal with the C code containing ESQL.As Iknow, the source code should be prepared in DB2 server. Two things would be done, one is it would update the source code where ESQL statement would be commented out , and reaplce with c sql function call statement, and add timestamp; other thing is to make package or plan; after that, developer could copy the updated source code back and compile and link using compiler, then it could run.
And I found there are some differences for PL1DB2 code process. Till now, I just find pl1 code would be compiled and splitted to two part, one is lbt for pl1, other is dbr for ESQL, and do the binding in promot process, coud you explain detail the process, especially the deep side, thx!

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

And what's the DBR?

dick scherrer · Posted: Sat Mar 14, 2009 7:30 am

Hello,

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

I did not find dbrm after compile the plidb2 code, where can I find it?

dick scherrer · Posted: Sat Mar 14, 2009 7:50 am

Hello,

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

In our company, we just compile the code in changeman, and then promot with DBP file, will it go through the process: precompile code to two part, one is for PLI withough SQL, other is DBRM containing SQL, and then compile the PL1 part code, then bind the DBRM to plan or package, right

dick scherrer · Posted: Sat Mar 14, 2009 9:48 am

Hello,

Probably. . .

Exactly what is done is known by those who support your environment. No one here at the forum is familiar with your particular configuration.

People here are willing to help, but we do not have site-specific info for most organizations.

Is there some reason you are unwilling to communicate with them and get the correct answers for your system? I would very much encourage getting to know the senior/support people as they can be invaluable.

Anuj Dhawan · Posted: Sat Mar 14, 2009 10:37 am

Hi,

seman18 · New User Joined: 08 Feb 2009 Posts: 67 Location: hz

because I don't how to find them, we are offsite:)

Anuj Dhawan · Posted: Sat Mar 14, 2009 12:58 pm

Hi,

I'm also working from offhosre (offsite) it should not be a hurdle. There must be one "onsite" counter part with you at your shop - if not how have you been doing all other promotions to production so far..leave this DB2 thing for a moment. . .

enrico-sorichetti · Posted: Sat Mar 14, 2009 1:44 pm

You are mixing two different processes...

lets start with a vanilla environment

for the building process pl/i or cobol have the same logic
( no integrated preprocessor )