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
 

 

Records getting lost while reading from IMS HIDAM database

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

New User


Joined: 31 Jan 2007
Posts: 3
Location: india

PostPosted: Wed Jan 31, 2007 8:47 pm    Post subject: Records getting lost while reading from IMS HIDAM database
Reply with quote

While reading from an IMS HIDAM database using Get Next call, Some of the records are getting lost.

The program is running as BMP. PROCOPT used in PSB is 'GOT'. Database is brought up with an Access Mode of 'RO'. The problem usually occurs after a huge insert/update to database. Database is kept up through the week days and it will be brought down on weekends while reorganization is done. The records those are getting missed in one run of the program seems to get read in the subsequent runs. There are no other programs which updates this database during the same window.

If we run the same program on the copy of the database in test region, None of the records are getting missed.

The program is written in such a way to handle all status code other than Spaces and GB.

seeking suggestions .....
Back to top
View user's profile Send private message

Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Jan 31, 2007 10:30 pm    Post subject:
Reply with quote

Any locks during buildup? Command code Q without DEQ?
Back to top
View user's profile Send private message
shijug2000

New User


Joined: 31 Jan 2007
Posts: 3
Location: india

PostPosted: Sun Feb 04, 2007 12:39 pm    Post subject: Re: Records getting lost while reading from IMS HIDAM datab
Reply with quote

George,

Thanks for your quick response.

The database is brought up by a JCL which is scheduled weekly.

The JCL is having only "/sta DB Database-Name,access=RO", in it.
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: Sun Feb 04, 2007 10:48 pm    Post subject:
Reply with quote

Hello,

Might it be possible that the "test" is "complete" as it was loaded en-mass as opposed to production only being able to see what has been written to disk?

In some environments, online updates are "buffered" and are available to online processes, but batch processes will not see them until they are written to disk.
Back to top
View user's profile Send private message
shijug2000

New User


Joined: 31 Jan 2007
Posts: 3
Location: india

PostPosted: Mon Feb 05, 2007 10:29 am    Post subject: Re: Records getting lost while reading from IMS HIDAM datab
Reply with quote

Inserts/Updates to the concerned database is done through a Batch process, Not online (To elaborate, The changes entered thru online will be stored in a change database and This will be updated/added into the actual database by a batch job, depending on the effective date given).

After the Inserts/Update, an image copy will be created, on which I had done the testing.

A few hours after this, The extract Job will run, in which, some of the records will be getting lost.

This is not a one time issue. this occurs whenever we have large Number of inserts/Updates to database.

I have a question... Is there any option/setting in IMS that will suppress the Status Code 'GG'?

Thanks for the help...
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Mon Feb 05, 2007 3:17 pm    Post subject:
Reply with quote

From the good manual following the link in my signature:

Quote:
GG
Explanation:
DL/I returns this status code if the segment being retrieved contains an invalid pointer and the application program has a processing option of GOT or GON. (Processing options are explained under PROCOPT in the discussion of program specification block generation in IMS Version 9: Utilities Reference: System.) This can occur when update activity in the database is going on concurrently with your program's processing.

DFSVSMxx option PPUR=Y can be used to prevent this status if it was received when running a PROCOPT=GOx transaction accessing HALDB partitions and a partition is found to be unavailable due to a database command in progress.

For call-level programs:

The PCB key feedback length and area will be based on the last segment that satisfied the call. Your position is at the beginning of the database.

For command-level programs:

If your request specified KEYFEEDBACK, the DIBKFBL will contain the length of the key of the last segment that satisfied the command. Your position is at the beginning of the database.

Rather than having an abnormal termination occur, this status code is returned to the application program that issued the EXEC DLI command.

Programmer response:
Continue processing with another segment or terminate the program. The request that resulted in the GG status code might be successful if you issue it again.

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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


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