VSAM Altenate index Build performance



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

VSAM Altenate index Build performance

Postby Ram » Wed Dec 24, 2008 5:06 pm

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.
Ram
 
Posts: 2
Joined: Wed Dec 24, 2008 4:19 pm
Has thanked: 0 time
Been thanked: 0 time

Re: VSAM Altenate index Build performance

Postby dick scherrer » Thu Dec 25, 2008 8:54 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: VSAM Altenate index Build performance

Postby Ram » Fri Dec 26, 2008 1:38 pm

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))
Ram
 
Posts: 2
Joined: Wed Dec 24, 2008 4:19 pm
Has thanked: 0 time
Been thanked: 0 time


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post