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
 

 

IMS database giving the same data after a replace call

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

New User


Joined: 24 Mar 2007
Posts: 35
Location: pune

PostPosted: Wed Mar 10, 2010 8:55 pm    Post subject: IMS database giving the same data after a replace call
Reply with quote

Hi,

I have an IMS Online Program PGMA which reads the message which comes through MQ.
PGMA processes the data by calling a program PGMB.
PGMB calls the program PGMC to retireve the sequence number from an IMS database.
PGM retrieves the sequence number segment (say it retrieved 309) and update the next sequence number segment back to IMS database with a REPL call (say qith the seq number as 310) .
PGMB a updates the sequence number reteived in the DB2 tabelw tih the records receievd throug the MQ and sends the databack to PGMA
PGMA sends the message back with a ISRT call.
PGMA again does an GU call to see for any other message to process.
In one of the scenario,
It gets data for the second time and the program PGMA calls PGMB for repeating the same process.
When Program PGMB calls PGMC for next sequence number ie 310. It retrieves a sequence number 309 instead.

1) Is it because after the end of the first message processing the sequence number update is not commited. If yes how to make a commit for the update?
2) When the PGMA issues a GU call after procesing the first record, how it is getting the next record to process from MQ as we are not giving GN call?
3) For a GU call will we ever face QC status code?
4) Is it the right way to end the trsanction after the first record process and start a fresh transaction for the next record, evenwhen the record is avaialble in the message queue for process?
Back to top
View user's profile Send private message

manikawnth

New User


Joined: 07 Feb 2007
Posts: 61
Location: Mumbai

PostPosted: Thu Mar 11, 2010 11:53 am    Post subject: @Naveen
Reply with quote

Your details are a bit confusing.
Is the sequence number a Key field to retrieve the segment?
If so, from your statement
Quote:
PGM retrieves the sequence number segment (say it retrieved 309) and update the next sequence number segment back to IMS database with a REPL call (say qith the seq number as 310) .

You are retrieving segment 309 and updating segment 310???
I dint understand this.
R u placing a GHU call for 309 and REPL call for 310?
Are u putting SSA for REPL call (which is optional)?

Kindly post the IMS I/O calls in each program along with the SSAs used for further analysis.

Thanks,
Manikanth
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 Mar 17, 2010 6:52 pm    Post subject:
Reply with quote

AND - please make sure that you check you status code on every IMS call you make - including the DC calls.
Back to top
View user's profile Send private message
naveengec

New User


Joined: 24 Mar 2007
Posts: 35
Location: pune

PostPosted: Sat Mar 20, 2010 5:21 pm    Post subject:
Reply with quote

The key field data for the segment is AUTOGEN. The sequence number is a filed in this segment. Wheich will updated as incremented value after the retrieval. Will the commit/syncpoint happens with next GU call to retrive the message queue?
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


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

PostPosted: Sat Mar 20, 2010 5:44 pm    Post subject:
Reply with quote

I am still not understanding your process. However, you know that you can never-ever replace a key field. So, if you are trying to replace a key field, you will fail and that should be reflected in your return status code.
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 Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts JES2 JEC: Use UNIX Pipes to Pass Data... Virendra Shambharkar JCL & VSAM 21 Tue Dec 20, 2016 6:55 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am


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