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 Record Not found in AlX but record re... mukun264 COBOL Programming 4 Fri Mar 24, 2017 9:28 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 6 Wed Feb 22, 2017 8:49 am


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