Page 1 of 1

VSAM Altenate index Build performance

PostPosted: Wed Dec 24, 2008 5:06 pm
by Ram
I am facing a performace issue while Building an Alternate index. It is taking a long time to build the Alternate Index. Could you please help me with the IDCAMS paramaters which will increase the Build performance of Alternate index.

Re: VSAM Altenate index Build performance

PostPosted: Thu Dec 25, 2008 8:54 am
by dick scherrer
Hello and welcome to the forum,

Could you please help me with the IDCAMS paramaters which will increase the Build performance of Alternate index.
Not from what you have posted. . . .

Posting "it doesn't work fast enough" will not get many/any usable replies.

How many records are there in the file? What do the define(s) for the file and the index entries look like (post them)? What is the difference in time required to load the file with and without this particular alternate index?

The better info you provide, the better suggestions we can make to help.

Re: VSAM Altenate index Build performance

PostPosted: Fri Dec 26, 2008 1:38 pm
by Ram
There are about 37491922 records in the base cluster. It took 7 minutes to load the base cluster but It is taking almost 40 mins to build the alternate index.

:::::::::::::Alternate index defination::::::::::
DEFINE AIX -
(NAME(xxxx.AIX) -
RELATE (xxxx.xxxx) -
KEYS(13 39) -
NONUNIQUEKEY -
RECORDSIZE(94 600000) -
VOLUMES(*) -
CYL(1000 100)) -
DATA -
(NAME(xxxx.AIX.DATA) -
CISZ(4096)) -
INDEX -
(NAME(xxxx.AIX.INDX) -
CISZ(1536))

::::: Base cluster Definition :::::::::
DEFINE CLUSTER -
(NAME(XXXX) -
VOLUMES(*) -
RECORDSIZE(156 156) -
KEYS(38 1) -
CYL(3000 300) -
DATACLAS(COMPACT) -
MGMTCLAS(MONTHNB) -
STORCLAS(STANDARD) -
SPEED -
IMBED -
REPLICATE -
SHAREOPTIONS(1,3)) -
DATA -
(NAME(XXXX.DATA) -
CISZ(4096)) -
INDEX -
(NAME(XXXX.INDX) -
CISZ(4096))