Clarification required about Secondary indexing PCB's

rocksolid · New User Joined: 29 Aug 2006 Posts: 21 Location: India

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,

PascalQ · New User Joined: 12 May 2006 Posts: 20

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.

rocksolid · New User Joined: 29 Aug 2006 Posts: 21 Location: India

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,