IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Dynamic linking
IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
rakesh_mishra18

New User


Joined: 15 May 2006
Posts: 23
Location: Jamshedpur
PostPosted: Mon Mar 02, 2009 2:15 am
 Reply with quote
Hi,

If program A call a subprogram B which again call a subprogram C having a DB2 cursor CUR1.

1. Now if program A call the subprogram C directly (this may be by other job or transaction). Is there any issue in terms of sharing the cursor data if both the instances are trying to use the same cursor. I am sure there is no issue in case of read but not sure of updates.

2. Second scenario, instead of A, if program D calls C and try to access same cursor, will there be any issue?

I hope static link will not cause any issue but assume all the calling as dynamic what could be complications in terms of data integrity.

Regards,
Rakesh
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
PostPosted: Mon Mar 02, 2009 3:11 am
 Reply with quote
Hello,

Quote:
Is there any issue in terms of sharing the cursor data if both the instances are trying to use the same cursor. I am sure there is no issue in case of read but not sure of updates.
This is not an issue of called modules but is an issue of data availability. Using the same cursor definition should cause no problems - using the same data rows may. Something that may happen when data is locked for too long by any modules in an inconsistent manner is timeouts and/or deadlocks. You probably should talk with your dba about your data access intents.

Quote:
I hope static link will not cause any issue
Possibly static call? The link/call has to do with the executable code rather than database activity.

Quote:
what could be complications in terms of data integrity.
There should be no intrgrity issue. Locked rows will be locked form other attempts to use them. This will be true regardless if the lock is issued in a higher or lower level module.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> COBOL Programming

 

Similar Topics
Topic Forum Replies
No new posts Using Dynamic file handler in the Fil... COBOL Programming 2
No new posts JCL Dynamic System Symbols JCL & VSAM 3
No new posts Synctool-dynamic split job for varyin... JCL & VSAM 7
No new posts Dynamic file allocation using JCL JCL & VSAM 8
No new posts Dynamic Sortin DD cards SYNCSORT 8
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us