Recommended DBPARM attributes for Best Database Performance with CA 7.

Document ID : KB000024470
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

This Knowledge Document contains the recommended DBPARM attributes for Best Database Performance with CA 7.

Instructions: 

IBM VSAM access may require more buffer space, thus you may require a larger region size (if not using REGION=0M).

You can make the following modifications:

  1. Change region size to REGION=0M in programs that use DBPARMS (e.g., CA7ONL, SASSBK00) if needed In DBPARMS
  2. Change SASIDS to STRINGS(10)

    BUFNI(15)
    BUFND(15)
  3. Change SASDS to STRINGS(10,10,3,3,10,10,3,3,3,3,5,5)

    BUFNI(73)
    BUFND(73)
  4. Change SASJOB to STRINGS(10,10)

    BUFNI(25)
    BUFND(25)

After changes, an ERST restart of CA 7 is recommended.

Additional Information:

As always, please contact CA Technologies support for CA 7 if you have further questions.