ca.portal.admin

Update on Local Mode Update Job

Discussion created by ca.portal.admin on Feb 7, 2008
Hello All:

ARCH has drastically reduced the run time of this job by executing this
program with our BATSTAT Utility to pinpoint the exact DML Verbs that
were
taking the most amount of time to execute. Then we simply replaced the
one
15,000 page buffer @ 32K per page (This took 487 Megabytes) with
individual
buffers for the key areas that this program accesses.

We created individual buffers for the CAS-PEG-AREA, CAS-MRP-AREA,
CAS-ORD-BUFFER, and one DEFAULT_BUFFER for everything else (This took
254
Megabytes).

As far as the program efficiency, Dan is somewhat correct, this program
was
written by CULLINET, this program is an MRP Program that is part of CAS.
Additionally it is a CAS 1.0 Program, so not only is the program
inefficient
but so is the Data Base Structure that it navigates. For example most of
the
sets such as MRP-ACTIVITY, PART-REQUIREMENT and PART-PLT-REPLEN are all
sorted chained sets.

So not only did we reduce the memory requirements (By 233 Megabytes) of
the
DMCL in a test run we processed 10 Times the amount of records in less
time.

The real Production run will run this Saturday.

Now, this user intends to be off of IDMS & CAS by July fourth 2008
(Independence Day) so there is no urgency to make ANY changes to the
program
or the Data Base Structure. So this is the reason that we are NOT
looking at
the program first and are researching solutions that don't require
""Exotic""
programming techniques

However, I did recommend that the above three sets be changed to an
Index
set to further improve the run times.

It was my customer that posted to the lists regarding a local mode
update
using fast access because they had only ever used Fast Access for
retrieval
and he wanted to make sure that there were no issues using the older
release
7.0 with updates.

We also have another test going today using Fast Access with a very
large
MAXTRKS value, this may further improve the run time?

Bill Allen
ARCH Consulting Associates, Ltd.

Outcomes