DB2 New Cobol Program, Views, DCLGENs, and PLAN - 818 error 1

[wellster34]

Hi,

I'm having the 818 problem with the timestamp issue. I have a new DB2 Cobol program that references 2 new DB2 views. I have created the 2 views successfully in DB2 but I'm having problems trying to create the DCLGENs. When I try to create the DCLGENs, it fails with the 818 error and I have no idea why? How can the timestamp be different when I have not even compiled the program yet?

I thought the process for a new DB2 Cobol Program is to create the DCLGENs, then your PLAN, and finally Compile your COBOL program.

Is that right? Any Suggestions?

Thanks for your time.

 

[MarcLodge]

Hi Wellster,
How are you trying to create the DCLGEN, what version of DB2 are you running , and where?
Marc

 

[wellster34]

Hi,

On a Mainframe and version 4 of DB2.

I choose the following option of the Mainframe Main Menu:
9 DB2I Perform DB2 interactive functions

Then I choose Option 2 for the DCLGEN:
2 DCLGEN (Generate SQL and source language declarations)

I enter in my information and I get the following error:

DSNT408I SQLCODE = -818, ERROR: THE PRECOMPILER-GENERATED TIMESTAMP
15BDFA130FB6F184 IN THE LOAD MODULE IS DIFFERENT FROM THE BIND
TIMESTAMP 154475D01F032E28 BUILT FROM THE DBRM DSNECP68
DSNT418I SQLSTATE = 51003 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -200 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF38' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

 

[MarcLodge]

Wellster,
You've got problems and you need to talk to your sysprogs or DBAs! What you are doing is the correct way to do things, but the error you are getting is in the system setup. When you go to generate a DCLGEN, it calls an installed DB2 program. The load module needs to match up with the plan in all DB2 accessing programs, and system utilities like these are no exception. It seems that the load module you are picking up does not match the DBRM found in DB2. Normally the allocation of the steplib where the program is to be found is done/setup by the sys progs or DBAs, although that might be different at your site.

It may be that you have had a new version of DB2 installed recently (although if you are using v4, that's probably unlikely), or that the CLIST or REXX that does the allocate is out of step. I'd suggest you have a word with whoever supports this area.

Hope this helps.
Marc