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
 

 

Drop building Alternate Index for a particular key

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
bhavin.mehta

New User


Joined: 25 Jun 2012
Posts: 32
Location: India

PostPosted: Mon Jul 04, 2016 3:47 pm    Post subject: Drop building Alternate Index for a particular key
Reply with quote

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.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Jul 04, 2016 4:30 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
bhavin.mehta

New User


Joined: 25 Jun 2012
Posts: 32
Location: India

PostPosted: Mon Jul 04, 2016 5:01 pm    Post subject:
Reply with quote

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
Code:
MSGLEVEL=1                 
BASE=USER.BASE.CLUSTER   
AIX=USER.BASE.AIX   
DROP=X'40404040404040'     



In this way we stop building AIX for fields like spaces or all zeros, etc. Can this type of filtering be achieved while the file is open in CICS?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Jul 04, 2016 5:11 pm    Post subject:
Reply with quote

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 ?
Back to top
View user's profile Send private message
bhavin.mehta

New User


Joined: 25 Jun 2012
Posts: 32
Location: India

PostPosted: Mon Jul 04, 2016 5:13 pm    Post subject:
Reply with quote

yes, I want to rebuild the AIX (drop those records) while the file is still open in CICS.
Back to top
View user's profile Send private message
bhavin.mehta

New User


Joined: 25 Jun 2012
Posts: 32
Location: India

PostPosted: Mon Jul 04, 2016 6:26 pm    Post subject:
Reply with quote

Or, can I delete particular records from AIX while the file is open in CICS?
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1737
Location: NY,USA

PostPosted: Tue Jul 05, 2016 10:15 pm    Post subject:
Reply with quote

Please ask CICS System Programmer at your shop if that is possible Or give a try and see what happens.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts Need help in building a logic Benchwarmer All Other Mainframe Topics 4 Wed Feb 22, 2017 2:49 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm


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