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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm


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