Page 1 of 1

error while defining alternate index

PostPosted: Thu Jul 19, 2007 11:53 pm
by pav001
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


Thanks in advance! PAV

Re: error while defining alternate index

PostPosted: Fri Jul 20, 2007 2:59 am
by William Thompson
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.....

Re: error while defining alternate index

PostPosted: Mon Jul 30, 2007 5:18 pm
by marso
From DFSMS Access Method Services for Catalogs:

"When you create a reusable cluster, you cannot build an alternate index to support it."

In other words, the REUSE parameter in the DEFINE CLUSTER does not allow you to use an AIX for this cluster.
Try again after removing it.

Re: error while defining alternate index

PostPosted: Tue Jul 31, 2007 2:45 am
by CICS Guy
marso wrote:When you create a reusable cluster, you cannot build an alternate index to support it.
Good call.... :D

Re: error while defining alternate index

PostPosted: Wed Aug 01, 2007 9:33 am
by marso
I just found the link points to the table of contents. The REUSE option and the quoted sentence are in the "Optional Parameters" of the DEFINE CLUSTER chapter (here).