Recommended DBPARM attributes for Best Database Performance with CA 7 Release 11.3 only

Products

• CA 7 Workload Automation

Issue/Introduction

What is the recommended DBPARM attributes for Best Database Performance with CA 7?

 

Environment

Release 11.3 only

Resolution

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.