Examples for the Analyze function

Review examples and learn techniques for analyzing DEDB areas.

In these examples, the following DEDB is assumed:

DEDB DEDBJN22 has four areas:
  • Area name: DB22AR0 (area number is 1 and has three ADSs)
    • ADS DD name: DB22AR01, DS name: HPFP.DB22AR0.ADS1
    • ADS DD name: DB22AR02, DS name: HPFP.DB22AR0.ADS2
    • ADS DD name: DB22AR03, DS name: HPFP.DB22AR0.ADS3
  • Area name: DB22AR1 (area number is 2 and has two ADSs)
    • ADS DD name: DB22AR11, DS name: HPFP.DB22AR1.ADS1
    • ADS DD name: DB22AR12, DS name: HPFP.DB22AR1.ADS2
  • Area name: DB22AR2 (area number is 3 and has two ADSs)
    • ADS DD name: DB22AR21, DS name: HPFP.DB22AR2.ADS1
    • ADS DD name: DB22AR22, DS name: HPFP.DB22AR2.ADS2
  • Area name: DB22AR3 (area number is 4 and has one ADS)
    • ADS DD name: DB22AR31, DS name: HPFP.DB22AR3.ADS1

In DBRC, all ADSs are in AVAILABLE status.

In the examples that use secondary index databases, the following secondary index databases are assumed:

  • Secondary index database name: INDEX1
    • Primary DBDS DD name: INDEXK1, DS name: HPFP.INDEXK1
  • Secondary index database name: INDEX2
    • Primary DBDS DD name: INDEXK2, DS name: HPFP.INDEXK2
    • Overflow DBDS DD name: INDEXE2, DS name: HPFP.INDEXE2

You can find additional JCL examples that help you to monitor and tune DEDB areas in FPA Analyze JCL examples for monitoring and tuning DEDBs.