IBM Mainframe Forum

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.

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.

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