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
 

 

Define AIX step failure

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

New User


Joined: 09 Oct 2006
Posts: 19
Location: Toronto

PostPosted: Sat May 14, 2011 6:11 pm    Post subject: Define AIX step failure
Reply with quote

Hi,

I have a space issue on AIX and I guess my job is testing the maximum AIX allocation.

My job fails on the DEFINE AIX step with the below error:
Code:

IDC1646I 15735 EXCESS PRIME KEY VALUES FOR AIX KEY 00002CF0F0F0F0F0F1F1
IDC1653I CIGL.COT.DGL.ELEC.ITEMS.AIX.MASTER BUILT WITH ERRORS
IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 4


DEFINE card:
Code:
***************************** Top of Data ******************************
 /* VGLT1004 */                                                         
 DEF AIX -                                                             
     (NAME(CIGL.COT.DGL.ELEC.ITEMS.AIX.MASTER)          -               
      RELATE(CIGL.COT.DGL.ELEC.ITEMS.MASTER)            -               
      MB(1000,500)                                         -           
      KEYS(15 47)  SPEED                                -               
      FREESPACE(2 2)                                    -               
      RECORDSIZE(9620 600000)                           -               
      NONUNIQUEKEY                                      -               
      UPGRADE                                           -               
      SHR(2 3))                                         -               
    DATA                                                -               
        (NAME(CIGL.COT.DGL.ELEC.ITEMS.AIX.DATA)         -               
         CISZ(22528))                                   -               
    INDEX                                               -               
        (NAME(CIGL.COT.DGL.ELEC.ITEMS.AIX.INDEX)        -               
         CISZ(2048))                                                   
**************************** Bottom of Data ****************************


In the past, whenever the job failed with the above error, we increased the maximum length on the RECORDSIZE parm, but when we tried that today, the job failed again.
But with a different error:
Code:

IDC3014I CATALOG ERROR                             
IDC3009I ** VSAM CATALOG RETURN CODE IS 96 - REASON

IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12


This is a failure in our production, so immediate assistance is really appreciated.

Thanks,
Sid.
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: Sat May 14, 2011 6:19 pm    Post subject:
Reply with quote

Quote:
This is a failure in our production, so immediate assistance is really appreciated.
This is a forum -- if you need kind of response, you need to pay someone for support.

As your first message set indicates, the alternate index was built. If you did not do a delete before you reran the build, the alternate index name is already in the catalog and cannot be cataloged again. Hence your second error message.

Also, WHY is the alternate index not getting built? Someone did not do a good job of analysis if you have to keep expanding the alternate index record length! And, sooner or later, you'll hit the maximum at which point someone will have to completely redesign the process since the limit on primary keys in an alternate index is an absolute limit and cannot be changed.
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 Restart=Step not working ALAK SAHA JCL & VSAM 6 Fri Jun 30, 2017 6:28 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts DB2 utilities, contention or failure? sheersh DB2 2 Fri Apr 21, 2017 6:18 pm
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am
No new posts Converting multiple VB files to FB fi... Viswanath Reddy JCL & VSAM 6 Mon Aug 08, 2016 11:49 pm


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