error while defining alternate index

pav001 · New User Joined: 02 Nov 2005 Posts: 24

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

dick scherrer · Posted: Fri Jul 20, 2007 2:30 am

Hello,

You might want to pay special attention to

expat · Posted: Fri Jul 20, 2007 2:37 am

Try defining the AIX without the second occurance of NONUNIQUEKEY

William Thompson · Posted: Fri Jul 20, 2007 3:08 am

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.....

enrico-sorichetti · Posted: Fri Jul 20, 2007 3:49 am

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

pav001 · New User Joined: 02 Nov 2005 Posts: 24

Thanks, worked fine without the REUSE option.

PAV!

mohanr · New User Joined: 27 Jun 2007 Posts: 2 Location: Hyderabad

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

mohanr · New User Joined: 27 Jun 2007 Posts: 2 Location: Hyderabad

Hi all ,

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

Thanks & regards,
Madan