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: 1610
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 Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm
No new posts Rebuilding IMS secondary index withou... Hooman24 IMS DB/DC 6 Tue Mar 29, 2016 12:22 pm
No new posts How to find Table-space and Index-spa... venksiv DB2 5 Wed Feb 03, 2016 6:16 pm
No new posts Retrieve records in the order of alte... jacobdng Compuware & Other Tools 8 Fri Jul 31, 2015 8:16 am


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