ca.portal.admin

Fast Access Users

Discussion created by ca.portal.admin on Apr 5, 2006
Hello All:

I am planning to use Fast Access for an Unload and Reload.

I do not have much experience with this product for UPDATE jobs.

I ran a few test unloads and compared them to IDMSQSAM and PREFETCH and
Fast Access was the better of the three methods. We are running IDMS
Release 16.0 Service Pack Two and Fast Access Release 8.0.

Here is the performance information:

Fast Access, 5.28 Minutes Elapsed Time, 6,430 EXCP'S, MAXTRKS=600,
READTRKS=15,ADAPT=ON, DMCL BUFFER=400 Pages

IDMSQSAM, 9.10 Minutes Elapsed Time, 82,286 EXCP'S, IDMSQSAM=ON,
QSAMBUF#=250, DMCL BUFFER=400 Pages

PREFETCH, 9.67 Minutes Elapsed Time, 48,373 EXCP'S, PREFETCH=ON,
PREFETCH_BUF=100, DMCL BUFFER=400 Pages

Does anyone out there have samples of your parameters for a one step
reload that will improve performance of the update steps?

Bill Allen

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Fast Access Users
"Bill,
there are a few other parameters you might want to look at for
fastaccess updating:

wrttrks and writecpy (check the spelling)

also make sure you are on the most current release of fixes (8.0.1) -
it DOES matter

chris hoelscher

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Fast Access Users
"In Update mode FASTACCESS is limited to 5 tracks.

MAXTRACKS need not be so large for a reload, you will only be dealing
sequentially.

You might look at DBIM.

FASTACCESS is very intelligent software -- the default is ADAPT=ON -- he
will adjust very well with a minimum of overrides, but possibly for the
UNLOAD step you may benefit with a larger READTRKS & MAXTRKS specified
by File.

If you are processing many files, the ""CLOSE BUFFER"" parameter might be
useful (I don't have my manual handy).

I like to use FASTACCESS with all the defaults, then examine the
FIOSTATS to see if I actually DO need to fiddle with it. Understanding
the FIOSTATS is the key . . .

Good luck

dem

Outcomes