Drop building Alternate Index for a particular key

bhavin.mehta · New User Joined: 25 Jun 2012 Posts: 34 Location: India

i have unique case where we drop building AIX for a particular key in batch. I want this to happen during online as well. Is this possible?

e.g. I have an AIX for phone number, I don't want to build AIX if its zeros.

expat · Posted: Mon Jul 04, 2016 4:30 pm

What do you mean by "I want this to happen during online as well. Is this possible?"
The cluster either has an AIX or it doesn't.

"e.g. I have an AIX for phone number, I don't want to build AIX if its zeros."
AFAIK,You can't build an AIX for selected records only.
The cluster either has an AIX or it doesn't.

bhavin.mehta · New User Joined: 25 Jun 2012 Posts: 34 Location: India

In batch, we use GVBLDIX (CA Faver product) to build the AIX, there we use DROP statement for the keys we don't want the AIX.

sample code below

expat · Posted: Mon Jul 04, 2016 5:11 pm

OK, so you drop records from an AIX under conditions - never had to do that before.

Once the AIX is built, it is built and associated with the base cluster, containing the data that it contains.

Do you mean - can you rebuild the AIX while the file is open and allocated to CICS ?

bhavin.mehta · New User Joined: 25 Jun 2012 Posts: 34 Location: India

yes, I want to rebuild the AIX (drop those records) while the file is still open in CICS.

bhavin.mehta · New User Joined: 25 Jun 2012 Posts: 34 Location: India

Or, can I delete particular records from AIX while the file is open in CICS?

Rohit Umarjikar · Posted: Tue Jul 05, 2016 10:15 pm

Please ask CICS System Programmer at your shop if that is possible Or give a try and see what happens.