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
 

 

Creation of AIX

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

New User


Joined: 07 Aug 2007
Posts: 22
Location: Chennai

PostPosted: Tue Sep 25, 2007 5:14 pm    Post subject: Creation of AIX
Reply with quote

I have a base cluster containing thousands of records. I want to create an AIX containing certain fields only. Supose, the field positions of the record in the base cluster is like this:

1-9, 10-12, 13-20, 21-31, 32-36, 37-44, 45-52, etc.

Now, AIX has to be created for the fields positioned - 1-9, 21-31, 37-44, etc. Could anyone let me know as how this can be created using IDCAMS?
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Sep 25, 2007 5:33 pm    Post subject:
Reply with quote

Is that three AIXs?
Or one AIX with a three part non-contigous key?
Back to top
View user's profile Send private message
Priya_Shankar

New User


Joined: 07 Aug 2007
Posts: 22
Location: Chennai

PostPosted: Tue Sep 25, 2007 5:38 pm    Post subject: Reply to: Creation of AIX
Reply with quote

If it is going to be a single AIX, how we can do it and if it is going to be 3 AIX, then how it is for that? Could you please let me know in performance wise which one would be better?
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Sep 25, 2007 5:50 pm    Post subject:
Reply with quote

I think you will find that the key must be contiguous......
Once you decide what your requirements are, then the key structure can be decided upon....
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 ISPF Tables Creation newsysprg TSO/ISPF 6 Wed Jul 13, 2016 2:21 pm
No new posts How to detect file creation event? vasanthz All Other Mainframe Topics 5 Fri May 20, 2016 1:33 am
No new posts New DB2 tables creation kishpra DB2 3 Tue Feb 02, 2016 7:00 pm
No new posts Creation of TPX screen GAURAVPAUL Java & MQSeries 2 Wed Dec 31, 2014 12:58 am
No new posts Rexx tool based on ISPF Table creation sakrat TSO/ISPF 1 Wed May 07, 2014 12:25 pm


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