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
 

 

Accessing a record before issuing Check point

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
nbalajibe
Warnings : 1

New User


Joined: 28 Nov 2006
Posts: 75
Location: India

PostPosted: Tue Jul 08, 2008 8:07 am    Post subject: Accessing a record before issuing Check point
Reply with quote

Hi,

In one of our applications we are loading a DB from a flat file using COBOL program. As per the design one of the fields of a record is updated depending upon the value of the other, for example if the contents of the input file are


Code:
111 ABC N N
222 CDE N N
333 ABC Y N


As per the design while inserting the third record the first record should be updated as below

Code:
111 ABC N Y


But we are giving checkpoints for every 1000 records. Our doubt is whether we would be able to update the first record if the checkpoint is not issued (i.e. if it lies within the 1000 records)



Thanks in advance,
Balaji
Back to top
View user's profile Send private message

Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Jul 08, 2008 7:15 pm    Post subject:
Reply with quote

How long have you estimated your "load" process will run? If this is truly a load process, then perhaps you should consider loading with the databases offline - not as a BMP.
Back to top
View user's profile Send private message
Mahendran3784

New User


Joined: 04 May 2007
Posts: 20
Location: INDIA

PostPosted: Wed Jul 09, 2008 4:09 pm    Post subject:
Reply with quote

Sandy- how does this helps in his case? actually his requirement is to update the uncommitted record.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Jul 10, 2008 8:39 pm    Post subject:
Reply with quote

Quite some time ago we spent quite a lot of time trying to help someone with a problem only to find out that we misunderstood the problem. Please read the following link and provide us with more info on the problem.

http://ibmmainframes.com/viewtopic.php?t=26538
Back to top
View user's profile Send private message
nbalajibe
Warnings : 1

New User


Joined: 28 Nov 2006
Posts: 75
Location: India

PostPosted: Sun Jul 13, 2008 3:57 pm    Post subject:
Reply with quote

Approximately the load process is expected to run for around 3 hours. As Mahendran has said my question is regarding reading uncommitted data.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Mon Jul 14, 2008 11:54 pm    Post subject:
Reply with quote

Let's take a step back - to the beginning of your posts. You are reading an IMS database - I think - not a DB2 table. In IMS, before you "update" - which is what I THINK you are doing - you must get and hold the record before issuing the REPL command. If the database is in existence, then you are not LOADING it - you are either insterting (ISRT) - if the segment on your flat file does not exist - or if it does exist, you are updating it. So, what is your definition of "uncommitted data"?
Back to top
View user's profile Send private message
nbalajibe
Warnings : 1

New User


Joined: 28 Nov 2006
Posts: 75
Location: India

PostPosted: Wed Jul 16, 2008 1:35 pm    Post subject:
Reply with quote

Yes Sandy, it is a IMS database. We are inserting records and giving a checkpoint after 1000 records.
As you have said for updating a record we have to hold it. My doubt is whether we can hold a record (for updating) if no checkpoint was given after the insert call (this insert call is also given from the same job).
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Jul 16, 2008 3:43 pm    Post subject:
Reply with quote

As I understand it, you are concerned that you get-hold a segment - add to your checkpoint counter - then issue your checkpoint before you update the segment? You could adjust your logic to NEVER issue a checkpoint until AFTER your update.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Accessing first bit of PD value rajatbagga DFSORT/ICETOOL 11 Wed May 03, 2017 6:03 am


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