Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Access difference primary/secondary IMS DB

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

New User


Joined: 22 Jan 2010
Posts: 4
Location: Bhubaneswar

PostPosted: Fri Mar 23, 2012 2:13 pm    Post subject: Access difference primary/secondary IMS DB
Reply with quote

Hi All,

This is a peculiar issue we are facing while accessing IMS DB in production region.

We have an online IMS-DC screen that picks up the data from Secondary index database. When we are trying to fetch the same data from the same segment of primary database (for which this secondary index defined) through a batch BMP job, we are getting GE status code.

We used a GN with a qualified call to read the segments from primary database.

Need help/pointers and possilble scenarios where these issues can happen.

Thanks,
Sai kumar.
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 Mar 29, 2012 1:55 am    Post subject:
Reply with quote

We don't have enough info to help. Is this an addition to an existing process? Was this put into a PRODUCTION environment without testing?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Thu Mar 29, 2012 2:20 am    Post subject:
Reply with quote

Quote:
Was this put into a PRODUCTION environment without testing?

No!
that's how we test..... in production
Back to top
View user's profile Send private message
sai1621

New User


Joined: 22 Jan 2010
Posts: 4
Location: Bhubaneswar

PostPosted: Thu Mar 29, 2012 10:58 am    Post subject: Hi
Reply with quote

Hi,

Thanks for your prompt response !

The primary and secondary index database are in production environment since 1990's.

We are facing an issue with the access of data.

An online screen picks up data from secondary index whereas when we try accessing the same data from the primary database using a batch BMP program, it is not picked up.

Instead we tried to extract all the occurences of that particular segment type but the data is not present in the extract file.

Secondary index might not reflect the entire data from the primary database (concept of Sparse indexing) using EXIT ROUTINES, but just wanted to know is the other way round is possible or not.

Thanks,
Sai Kumar.
Back to top
View user's profile Send private message
sai1621

New User


Joined: 22 Jan 2010
Posts: 4
Location: Bhubaneswar

PostPosted: Tue Apr 10, 2012 3:24 pm    Post subject: Issue resolved
Reply with quote

All,

The issue is with the DBRC setup for the secondary index.

Its been setup for a incorrect VSAM dataset. Identified this from spool logs in the master IMS* environment job.

Altered the DBRC to point to the correct VSAM dataset, followed by re-build of secondary index.

This resolved the issue.

Thanks
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Tue Apr 10, 2012 8:34 pm    Post subject:
Reply with quote

That's been that way since the 1990's???
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 ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm
No new posts Finding difference between two PS fil... Vignesh Sid SYNCSORT 5 Mon Oct 30, 2017 1:13 pm
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us