System parameters

This section lists the system parameters tables in the performance database.

The Performance Database tables for Db2 system parameters are as follows:

  • System parameters from IFCID 106
  • System facility parameters from IFCID 106
  • Alter buffer pool records from IFCID 201
  • Buffer pool attributes from IFCID 202
  • Group buffer pool attributes from IFCID 230
  • Alter group buffer pool records from IFCID 256

To create system parameter data for the Performance Database, use the SYSPARMS command with the FILE subcommand to produce a data set that is suitable for loading into DB2 tables.