error while defining alternate index



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

error while defining alternate index

Postby pav001 » Thu Jul 19, 2007 11:53 pm

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
pav001
 
Posts: 1
Joined: Thu Jul 19, 2007 11:43 pm
Has thanked: 0 time
Been thanked: 0 time

Re: error while defining alternate index

Postby William Thompson » Fri Jul 20, 2007 2:59 am

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.....
William Thompson
 
Posts: 81
Joined: Sat Jun 09, 2007 4:24 am
Location: Tucson AZ
Has thanked: 0 time
Been thanked: 1 time

Re: error while defining alternate index

Postby marso » Mon Jul 30, 2007 5:18 pm

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.
User avatar
marso
 
Posts: 12
Joined: Mon Jul 30, 2007 5:04 pm
Has thanked: 0 time
Been thanked: 0 time

Re: error while defining alternate index

Postby CICS Guy » Tue Jul 31, 2007 2:45 am

marso wrote:When you create a reusable cluster, you cannot build an alternate index to support it.
Good call.... :D
CICS Guy
 
Posts: 246
Joined: Wed Jun 20, 2007 4:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: error while defining alternate index

Postby marso » Wed Aug 01, 2007 9:33 am

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).
User avatar
marso
 
Posts: 12
Joined: Mon Jul 30, 2007 5:04 pm
Has thanked: 0 time
Been thanked: 0 time


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post