Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
non db2 to db2 program change BIND considerations

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Thu Oct 30, 2008 12:46 am    Post subject: non db2 to db2 program change BIND considerations
Reply with quote

We have a calling program that was non DB2 till now tht calls a DB2 program.Hence in the current JCL we have:

PL(plan name) PR(program name)-->here the main program currently is non DB2 but it calls a program tht has queries hence the plan name.

Now for some performance issues we are adding a COMMIT statement to the main program.We would hence be recompiling it as DB2.

Would a plan be created for including SQLCA and a COMMIT statement or does it need queries with table names to create the plan.

We use endevor for all version control.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Oct 30, 2008 12:53 am    Post subject:
Reply with quote

Hello,

What performance problem(s) do you intend to deal with by placing COMMITs in a non-db2 program?
Back to top
View user's profile Send private message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Thu Oct 30, 2008 1:24 am    Post subject: Reply to: non db2 to db2 program change BIND considerations
Reply with quote

The called DB2 program is currently being executed 1 time for each record of the Driver file read sequentially in the non DB2 program.We had a DB2 upgrade after which the EDM pool does not get freed during selects.If the EDM is not freed up then for each incremental call to the DB2 program the size increases and causes abends.When we do a COMMIT after the call to the DB2 program in the non db2 program it frees up the EDM space.

This is the issue we are trying to address.

In the current JCL we have a plan name(for the Db2) program.Since we use endevor my assumption is tht when i recompile the non Db2 program it need not necessarily bind to the same plan since the programs belong to diff applications here.

In case a BIND plan does not happen for just SQLCA and 1 COMMIT I could make the code changes and test but in case it does then i might have to also check tht the calling program binds to the same plan name.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Oct 30, 2008 2:42 am    Post subject:
Reply with quote

Hello,

Quote:
We had a DB2 upgrade after which the EDM pool does not get freed during selects.
Is this not something that needs to be corrected?

I'd suggest you try by using the same plan in the calling program as the called module - if your system will permit this.

If you introduce these commits, restart/recovery processing needs to be considered also.

I believe the problem should be corrected outside the application rather than needing to introduce restart complexity - fwiw.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm
No new posts change string before sertan string anatol DFSORT/ICETOOL 8 Tue Aug 15, 2017 5:43 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us