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
 

 

error while defining alternate index

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

New User


Joined: 02 Nov 2005
Posts: 24

PostPosted: Fri Jul 20, 2007 2:23 am    Post subject: error while defining alternate index
Reply with quote

Hi all,

I am trying to define an alternate index for a vsam (after defining the cluster) but the IDCAMS step is giving an error, i have pasted all the messages below.

IDCAMS SYSTEM SERVICES TIME: 12:45:47 07/19/07 PAGE 1

DELETE TP.PROD.LAC9.PP
IDC3012I ENTRY TP.PROD.LAC9.PP NOT FOUND
IDC3009I ** VSAM CATALOG RETURN CODE IS 8 - REASON CODE IS IGG0CLEG-42
IDC0551I ** ENTRY TP.PROD.LAC9.PP NOT DELETED
IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 8

SET MAXCC = 0

DEFINE CLUSTER -
(NAME(TP.PROD.LAC9.PP) -
RECORDSIZE(26 26) -
VOLUMES(SYSP36) -
KEYS (26 0) -
INDEXED -
NOWRITECHECK -
REUSE -
SPEED -
SHAREOPTIONS(3)) -
DATA (NAME(TP.PROD.LAC9.PP.DATA) -
CYLINDERS(120,10) CISZ(4096)) -
INDEX (NAME(TP.PROD.LAC9.PP.INDEX) -
CYLINDERS(1,1))
IDC0508I DATA ALLOCATION STATUS FOR VOLUME SYSP23 IS 0
IDC0509I INDEX ALLOCATION STATUS FOR VOLUME SYSP23 IS 0
IDC0001I FUNCTION COMPLETED, HIGHEST CONDITION CODE WAS 0

DEFINE AIX (NAME(TP.PROD.LAC9.A.PP) -
RELATE(TP.PROD.LAC9.PP) -
VOLUMES(SYSP65) -
KEY(4 0) -
NONUNIQUEKEY -
UPGRADE -
REUSE -
CYLINDERS(60 5)) -
DATA (NAME(TP.PROD.LAC9.A.PP.DATA) -
NONUNIQUEKEY) -
INDEX (NAME(TP.PROD.LAC9.A.PP.INDEX))
IDC3022I INVALID RELATED OBJECT
IDC3007I ** VSAM CATALOG RETURN CODE IS 80
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12

DEFINE PATH (NAME(TP.PROD.LAC9.PATH.PP) -
IDCAMS SYSTEM SERVICES TIME: 12:45:47 07/19/07 PAGE 2
PATHENTRY(TP.PROD.LAC9.A.PP))
IDC3022I INVALID RELATED OBJECT
IDC3009I ** VSAM CATALOG RETURN CODE IS 80 - REASON CODE IS IGG0CLAT-4
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12


TIA! PAV
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 Jul 20, 2007 2:30 am    Post subject:
Reply with quote

Hello,

You might want to pay special attention to
Quote:
IDC3012I ENTRY TP.PROD.LAC9.PP NOT FOUND


If you do a listcat right now, what does it show?
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: Fri Jul 20, 2007 2:37 am    Post subject:
Reply with quote

Try defining the AIX without the second occurance of NONUNIQUEKEY
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Jul 20, 2007 3:08 am    Post subject:
Reply with quote

My, you do get around.....grin.....

Just a SWAG, without actually looking it up, but I don't recall specifying the index of the base cluster in defining an AIX....
the Fine Manuel:
IDC3022I INVALID RELATED OBJECT
Explanation: The object specified in the RELATE parameter of a DEFINE command does not exist or is improper for the type of object being defined. See the associated second-level message for the specific catalog management error code values.
You might want to re-visit the manual for the exact syntax of the DEFINE AIX.....
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Fri Jul 20, 2007 3:49 am    Post subject: Re: error while defining alternate index
Reply with quote

the issue has already been discussed a few times; You cannot define an AIX for a "REUSABLE" object.

the messages and codes manual is clear about it.

regards

e.s
Back to top
View user's profile Send private message
pav001

New User


Joined: 02 Nov 2005
Posts: 24

PostPosted: Fri Jul 20, 2007 6:25 am    Post subject:
Reply with quote

Thanks, worked fine without the REUSE option.

PAV!
Back to top
View user's profile Send private message
mohanr

New User


Joined: 27 Jun 2007
Posts: 2
Location: Hyderabad

PostPosted: Fri Jul 20, 2007 10:38 am    Post subject: Re: error while defining alternate index
Reply with quote

Hi PAV,

I think, you need to mention the same VOLUME for alternate index cluster also, which you have mentioned for base cluster i.e give VOLUMES(SYSP36) instead of VOLUMES(SYSP65) while creating alternate index. Since it is not the same volume unable to find the base cluster.

Please correct me If am wrong.

Thanks & regards,
Madan
Back to top
View user's profile Send private message
mohanr

New User


Joined: 27 Jun 2007
Posts: 2
Location: Hyderabad

PostPosted: Fri Jul 20, 2007 10:53 am    Post subject:
Reply with quote

Hi all ,

Sorry I haven't seen enrico-sorichetti solution , please for give me.

Thanks & regards,
Madan
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 Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am


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