Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Static vs dynamic in cobol-db2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
hikaps14

Active User


Joined: 02 Sep 2005
Posts: 189
Location: Noida

PostPosted: Sat Jun 04, 2011 2:32 am    Post subject: Static vs dynamic in cobol-db2
Reply with quote

In past I have read some stuff on static vs dynamic in cobol. Its always been performance comparison in most of them.

One of my colleague asked few questions regarding the impact of both calls incase of Cobol-db2 programs. The programs are Cobol-DB2 and which call handles abends more efficiently when a roll back of the tables is neccessary.

Will it be a good idea to change from Static to Dynamic.

1. Would a Static call roll back all tables that were used in all called programs?
2. Would a 'Dynamic' roll back all tables that were used in all tables throughout all programs or because its a dynamic call the roll back would only occur in the one program where the abend occurred.

I tried searching for it though and couldn't find.

Finally, it could also be the case that db2 is completely independent of type of cobol calls. Could the experts provide your inputs please.
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: Sat Jun 04, 2011 3:20 am    Post subject:
Reply with quote

Hello,

Quote:
I tried searching for it though and couldn't find.
This is a database consideration, not "code-calling" concern.

Suggest you talk with your dba or a project senior about what is a "logical unit of work".

When a process has done some database inserts/updates/deletes, and a rollback is issued, everything since the last checkpoint/commit is rolled back - the processing between checkpoints is one logical unit of work.

When an abend occurs or a task issues a rollback, everything for the current logical unit of work is rolled back. This has nothing to do with how verious modules were called.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Sat Jun 04, 2011 3:22 am    Post subject: Reply to: Static vs dynamic in cobol-db2
Reply with quote

Statically CALLED sub-programs, raise the issue of non-reentrancy, a problem which will eventually cause grief in CICS, especially if you migrate to Threadsafe.

If you do pursue with a Statically CALLED sub-program, you must pass the Caller's Reentrant Working-Storage to the Statically CALLED sub-program for its usage.

Bill
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts REXX - Dynamic file Creation d_sarlie CLIST & REXX 7 Tue Jun 27, 2017 7:30 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us