DEDB Area Analysis reports

The DEDB Area Analysis reports include the comprehensive analysis information of an area.

The DEDB Area Analysis reports include the following reports:

  • Freespace Analysis report
  • DB Record Profile Analysis report
  • DB Record Placement Analysis report
  • Segment Placement Analysis report
  • Segment I/O Analysis report
  • Synonym Chain Analysis report

This report is generated by the following commands:

  • ANALYZE with the REPORT subcommand and the PTRCHKLVL=FULL keyword
  • CHANGE with the REPORT subcommand and the PTRCHKLVL=FULL keyword
  • RELOAD with the REPORT subcommand and the PTRCHKLVL=FULL keyword
  • REORG with the REPORT subcommand and the PTRCHKLVL=FULL keyword
  • TUNE

The Freespace Analysis reports are also generated by the following commands:

  • ANALYZE with the REPORT subcommand and the PTRCHKLVL=QUICK keyword
  • CHANGE with the REPORT subcommand and the PTRCHKLVL=QUICK keyword
  • RELOAD with the REPORT subcommand and the PTRCHKLVL=QUICK keyword
  • REORG with the REPORT subcommand and the PTRCHKLVL=QUICK keyword
Notes:
  • The header of each report is DEDB AREA ANALYZIZ REPORTS.
  • In DEDB Area Analysis reports, when a value exceeds the number of digits available for a column, asterisks (*) are shown instead of the value.