MVSFORUMS.com

chandhroo · Beginner Joined: 02 Dec 2002 Posts: 36 Topics: 13

Could anyone please tell me, is there any parameter to limit the number of duplicates in alternative index? Actually I'm getting error saying that duplicates exceeds the limit in alternative index. I don't know how to fix this error.

--Chandru

kolusu · Posted: Mon Dec 23, 2002 10:11 am Post subject:

Chandhroo,

I don't think there is a limit for the duplicates on the alternate index.The no: of duplcates on alternate index depends on how the alternate index is defined.The parameter Recordsize determines the no: od duplicates on the alternate index.

RECORDSIZE(average maximum):specifies the average and maximum length, in bytes, of an alternate index record.

For a KSDS

chandhroo · Beginner Joined: 02 Dec 2002 Posts: 36 Topics: 13

Kolusu,
It's very excellent to see your response. It's really very useful. However in my case record size is not used when defining AIX, BUFFERSPACE is used, could you please tell me how its releated to record size and duplicates. Please see my AIX define step.

Mike Tebb · Posted: Tue Dec 24, 2002 9:32 am Post subject:

Bufferspace is nothing to do with your recordsize.

As you have not specified a recordsize I believe you should get a default
maximum of 32600 (spanned) or 4089 (non-spanned). The default is spanned so you should get 32600 (display the attributes using FILEAID or IDCAMS to check this).

If your record size is 32600 then it would suggest that you have a lot of duplicate alternate indexes and maybe you should review the data used for that alternate key.
_________________
Cheers - Mike

chandhroo · Beginner Joined: 02 Dec 2002 Posts: 36 Topics: 13

Thanks Mike,
Could you please me is there any limitation in the record size parameter. Im getting error as below.
IGD17103I CATALOG ERROR WHILE DEFINING VSAM DATA SET BDV4LB.RAJ.VSAM.CAS.COA.NCHO.AIX1
RETURN CODE IS 96 REASON CODE IS 4 IGG0CLEQ
IGD17219I UNABLE TO CONTINUE DEFINE OF DATA SET BDV4LB.RAJ.VSAM.CAS.COA.NCHO.AIX1

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

See below the statement:

kolusu · Posted: Wed Jan 08, 2003 5:05 pm Post subject:

Chandroo,

can you post your cluseter definition also.

Thanks

Kolusu

Mike Tebb · Posted: Thu Jan 09, 2003 3:33 am Post subject:

Change your TRK parameter to CYL.
_________________
Cheers - Mike

chandhroo · Beginner Joined: 02 Dec 2002 Posts: 36 Topics: 13

Kolusu,
Please find cluster definition:
' DEFINE CLUSTER - ',
' (NAME(&VSAMOUT..C9999) - ',
' CYL(10 1) - ',
' FOR (9999) - ',
' RECSZ (80 80) - ',
' KEYS (47 0) - ',
' IMBED - ',
' FREESPACE (22 10) - ',
' REPLICATE - ',
' SPEED - ',
' BUFFERSPACE (87920) - ',
' SHAREOPTIONS (3 3)) - ',
' DATA - ',
' (NAME(&VSAMOUT..DATA) - ',
' CISZ(4096)) - ',
' INDEX - ',
' (NAME(&VSAMOUT..INDEX) - ',
' CISZ(2048)) ',
' REPRO INFILE(QSAMIN) - ',
' ODS(&VSAMOUT..C9999) ',

chandhroo · Beginner Joined: 02 Dec 2002 Posts: 36 Topics: 13

Could you please tell me is there any way to find out number of duplicates. For example in my case, i would to display some information if the number duplicates is greater than 1000. Thanks in advance.

Chandru