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
 
Clarification required about Secondary indexing PCB's

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

New User


Joined: 29 Aug 2006
Posts: 21
Location: India

PostPosted: Mon Oct 09, 2006 5:50 pm    Post subject: Clarification required about Secondary indexing PCB's
Reply with quote

Friends,

I need some clarification about secondary indexing DB PCB.

What I have an idea is, For secondary indexing DB, there won't be any explicit PCB statement in our program's PSB.

Instead PROCSEQ parameter names the secondary indexing DB and NAME parameter tells the main Db(primary DB).

But I found explicit PCB statement for Sec Ind DB in my production followed by another PCB statement contains NAME as primary DB and PROCSEQ = SI DB

Could some one please clarify this concept for me?

I have made some change to my PSB to include 2 secondary indexing PCB's . I am getting some AIB error.

Help required.

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

PascalQ

New User


Joined: 12 May 2006
Posts: 20

PostPosted: Tue Oct 10, 2006 10:11 pm    Post subject:
Reply with quote

Some applications sometimes want to just read the secondary index (without the DB the index belongs to). In this case it is usually faster if you have a PCB referring directly to the secondary index. This is why you will sometimes find a PCB representing a secondary index.

However, when an application needs to access the data from the main database, but wants to use the secondary index for searching purpose, you code the PROCSEQ=secindex.


I guess that's clear, but just to make sure: Whenever you update your main database, the indexes will be updates automatically. There's no need to specify the secondary indexes in the PCB in this case.
I think IMS would allow you to perform updates on a secondary index. I believe this is usually a bad idea.
Back to top
View user's profile Send private message
rocksolid

New User


Joined: 29 Aug 2006
Posts: 21
Location: India

PostPosted: Wed Oct 11, 2006 3:10 pm    Post subject:
Reply with quote

Thanks PascalQ,

I got the concept now....

But I am still having PCB issues...

I will let u all know in next post

Thank you,
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 SFTP to primary and secondary servers mallik4u JCL & VSAM 4 Tue Jun 07, 2016 12:52 pm
No new posts FTP help required amitc23 All Other Mainframe Topics 3 Thu Apr 28, 2016 12:02 pm
No new posts Why Newcopy is required when we have ... DIXINSH CICS 5 Thu Apr 28, 2016 9:47 am
No new posts SUM file with secondary sorted file cdelaf32 SYNCSORT 9 Mon Apr 25, 2016 10:20 pm
No new posts Need clarification of VSAM FCT and DF... pkmurali CICS 15 Sun Apr 10, 2016 1:06 am

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