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
 

 

Alternate Index is not getting created...

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

New User


Joined: 03 Aug 2009
Posts: 25
Location: Singapore

PostPosted: Fri Aug 12, 2011 10:43 am    Post subject: Alternate Index is not getting created...
Reply with quote

Hi all
We are converting our KSDS file to IAM file and getting the below error message while running test programs to create Alternate Index:
XXXX.YYYY.ZZZ.ABCD.KSDS is a IAM file.

Code:
 DEFINE AIX                                         
       (NAME(XXXX.YYYY.ZZZ.ABCD.KSDS.A1)             
        RELATE(XXXX.YYYY.ZZZ.ABCD.KSDS)               
        OWNER($IAM)                                 
        KEYS(17,31)                                 
        NOREUSE                                     
        UPGRADE                                     
        RECORDSIZE(53,32600)                       
        SHAREOPTIONS(2,3)                           
        NONUNIQUEKEY                               
        VOLUME(*))                                 
   DATA                                             
       (NAME(XXXX.YYYY.ZZZ.ABCD.KSDS.A1.D)           
        CYLINDERS(25 25))                           
   INDEX                                           
       (NAME(XXXX.YYYY.ZZZ.ABCD.KSDS.A1.I)           
        CYLINDERS(2 2))                             
IGD17103I CATALOG ERROR WHILE DEFINING VSAM DATA SET
XXXX.YYYY.ZZZ.ABCD.KSDS.A1                           
RETURN CODE IS 22 REASON CODE IS 12 IGG0CLIM       
RETURN CODE IS 22 REASON CODE IS 12 IGG0CLIM                           
IGD306I UNEXPECTED ERROR DURING IGG0CLIM PROCESSING                   
RETURN CODE 22 REASON CODE 12                                         
THE MODULE THAT DETECTED THE ERROR IS IGDVTSCU                         
SMS MODULE TRACE BACK - VTSCU VTSCT VTSCH VTSCG VTSCD VTSCC VTSCR SSIRT
SYMPTOM RECORD CREATED, PROBLEM ID IS IGD00042                         
IGD17219I UNABLE TO CONTINUE DEFINE OF DATA SET                       
XXXX.YYYY.ZZZ.ABCD.KSDS.A1                                               
IDC3014I CATALOG ERROR                                                 
IDC3009I ** VSAM CATALOG RETURN CODE IS 22 - REASON CODE IS IGG0CLIM-12
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12                     

and below error message for PATH:

 DEFINE PATH                                                    -     
       (NAME(XXXX.YYYY.ZZZ.ABCD.KSDS.P1)                          -     
        PATHENTRY(XXXX.YYYY.ZZZ.ABCD.KSDS.A1)                     -     
IDCAMS  SYSTEM SERVICES                                           
        UPDATE)                                                       
IDC3022I INVALID RELATED OBJECT                                       
IDC3009I ** VSAM CATALOG RETURN CODE IS 80 - REASON CODE IS IGG0CLAT-4
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12                     

Request you to help to solve this problem.


Regards,
Samim


Edited to add BBCode tags, Thanks...Anuj.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 12, 2011 12:21 pm    Post subject:
Reply with quote

Hello,

How is XXXX.YYYY.ZZZ.ABCD.KSDS defined?

Typo corrected. . .
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Aug 12, 2011 12:31 pm    Post subject:
Reply with quote

I think IAM files do not have a index...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 12, 2011 1:02 pm    Post subject:
Reply with quote

Hello,

Why would you believe that IAM does not support Alternate Indexes. . .
Back to top
View user's profile Send private message
samimaktar

New User


Joined: 03 Aug 2009
Posts: 25
Location: Singapore

PostPosted: Fri Aug 12, 2011 2:46 pm    Post subject: Reply to: Alternate Index is not getting created...
Reply with quote

Hi
XXXX.YYYY.ZZZ.ABCD.KSDS is defined as KSDS file.

Regards,
Samim
Back to top
View user's profile Send private message
samimaktar

New User


Joined: 03 Aug 2009
Posts: 25
Location: Singapore

PostPosted: Fri Aug 12, 2011 2:51 pm    Post subject: Reply to: Alternate Index is not getting created...
Reply with quote

Hi All
I can see one more message in sysout: IAMW55 IAM NOT LICENSED FOR AIX OR RRDS SUPPORT
Is the license causing this error?


Regards,
Samim
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Aug 12, 2011 5:11 pm    Post subject:
Reply with quote

dick scherrer wrote:
Hello,

Why would you believe that IAM does not support Alternate Indexes. . .


I verified and checked that alternate index can be created for a IAM file...

refer --> http://www.innovationdp.fdr.com/products/iam/share04IAMs8422.pdf

Also I tried creating an IAM file but was not successful... Getting an error.
Code:


0IAMW57 IAM ALLOCATION FAILED  COMP=0080 CODE=0012      CLUSTER=HLQ.MODE.IAM.AIX2                                 
1IDCAMS  SYSTEM SERVICES                                           TIME: 07:05:29        08/12/11     PAGE      1
0                                                                                                                 
  DEFINE    AIX      (NAME (HLQ.MODE.IAM.AIX2)                 -                                                 
                      RELATE (HLQ.MODE.IAM)                    -                                                 
                      RECORDSIZE (512 512)                     -                                                 
                      TRACKS (10 5)                            -                                                 
                      KEYS (12 68)                             -                                                 
                      UPGRADE)                                                                                   
0IGD17103I CATALOG ERROR WHILE DEFINING VSAM DATA SET                                                             
 HLQ.MODE.IAM.AIX2                                                                                               
 RETURN CODE IS 80 REASON CODE IS 12 IGG0CLIM                                                                     
 IGD306I UNEXPECTED ERROR DURING IGG0CLIM PROCESSING                                                             
 RETURN CODE 80 REASON CODE 12                                                                                   
 THE MODULE THAT DETECTED THE ERROR IS IGDVTSCU                                                                   
 SMS MODULE TRACE BACK - VTSCU VTSCT VTSCH VTSCG VTSCD VTSCC N/A SSIRT                                           
 SYMPTOM RECORD CREATED, PROBLEM ID IS IGD00037                                                                   
 IGD17219I UNABLE TO CONTINUE DEFINE OF DATA SET                                                                 
 HLQ.MODE.IAM.AIX2                                                                                               
0IDC3022I INVALID RELATED OBJECT                                                                                 
 IDC3009I ** VSAM CATALOG RETURN CODE IS 80 - REASON CODE IS IGG0CLIM-12                                         
0IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12                                                               
0                                                                                                                 
0IDC0002I IDCAMS PROCESSING COMPLETE. MAXIMUM CONDITION CODE WAS 12                                               


I checked the error also..
Code:

+------------------------------------------------------------------------+
¦ RETURN CODE 80                                                         ¦
¦                                                                        ¦
¦ Explanation: Incorrect related object. The object specified in the     ¦
¦ RELATE parameter of a DEFINE command does not exist or is improper for ¦
¦ the type of object being defined.                                      ¦
+------------------------------------------------------------------------+
 12                  Explanation: An alternate index is not to be built       
                     over a base cluster, or the related path object is not   
                     a cluster or an alternate index.                         
                                                                               
                     Programmer Response: Correct the DEFINE command so       
                     that the entry named in the RELATE parameter is proper   
                     for the type of object being defined.                     




Not sure how to create alternate index... Is there any special parameter that needs to be defined?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8120
Location: East Dubuque, Illinois, USA

PostPosted: Fri Aug 12, 2011 5:17 pm    Post subject:
Reply with quote

So, you are trying to create an alternate index for an IAM file and get the message that your site is not licensed to use alternate indexes with your IAM product, and you want to know if the license is causing the error?

No, the software is causing the error. The software is causing the error because you are not allowed under the terms of your site's license to do what you are trying to do, period. Either your site needs to license the alternate index component of IAM, or you need to stop trying to do things that the software will not allow you to do.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 12, 2011 8:10 pm    Post subject:
Reply with quote

Hello,

Quote:
I think IAM files do not have a index...

Quote:
I verified and checked that alternate index can be created for a IAM file...


@gylbharat
Please do not post what you "think". It is often wrong. . .

Verifying via manual or testing before posting will keep down the misinformation and clutter. . .
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 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
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm


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