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
 

 

Dynamic linking

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
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    Post subject: Dynamic linking
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

Site Director


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

PostPosted: Mon Mar 02, 2009 3:11 am    Post subject:
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    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 REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm
No new posts Creating a dynamic sort card in JCL u... ChitraChhabra DFSORT/ICETOOL 4 Wed Aug 03, 2016 6:15 pm
No new posts Need help on SQL Dynamic WHERE Clause subratarec DB2 12 Sat Jul 16, 2016 3:11 pm
No new posts Need to create file with Dynamic Name... kapil27 JCL & VSAM 4 Wed May 25, 2016 9:45 am
No new posts DB2 Stored Procedure - Dynamic SQL - ... GuyC DB2 2 Wed Feb 17, 2016 5:10 pm


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