Program running in loop.



IBM's flagship relational database management system

Program running in loop.

Postby XY09 » Fri Jul 16, 2010 9:15 am

Hi All,

I have wrriten a cobol + Db2 program precompiled & Bind & run. i got desired output.
Next, I have compiled same module without any chnage in the source code, i forgot to bind and when i try to run the job it is going to infinite loop insted of issuing SQLCODE = -805. What was the problem.

Please help..
XY09
 
Posts: 25
Joined: Mon Apr 26, 2010 9:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: Program running in loop.

 

Re: Program running in loop.

Postby dick scherrer » Fri Jul 16, 2010 9:52 am

Hello,

That you were able to compile and not bind implies that you are not using standard compile jcl. The standard jcl should include the bind.

If you have created your own compile process, the results may be unpredictable. Developers should use only the standard compile process for the system they are working on.

Suggest you re-compile with the standard and then see if there are any problems.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Program running in loop.

Postby maxcc » Mon Jul 19, 2010 6:59 pm

isn't it because the timestamp mismatch between the program and dbrm(which was not binded)..
maxcc
 
Posts: 28
Joined: Fri Apr 30, 2010 12:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Program running in loop.

Postby maxcc » Mon Jul 19, 2010 7:03 pm

The plan name used in the JCL and the plan used for bind
should be same...
maxcc
 
Posts: 28
Joined: Fri Apr 30, 2010 12:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Program running in loop.

Postby dick scherrer » Mon Jul 19, 2010 11:27 pm

Hello,

Regardless, there should be no valid compile process that would allow one to "forget to bind". . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post