Collection Services data files: QAPMPOOLT

This database file includes main storage pool file entries and lists the tuning information for the storage pools.

Field Name Description Attribute
INTNUM Interval number: The nth sample database interval based on the start time specified in the Create Performance Data (CRTPFRDTA) command. PD (5,0)
DTETIM Interval date (yymmdd) and time (hhmmss): The date and time of the sample interval. C (12)
INTSEC Elapsed interval seconds: The number of seconds since the last sample interval. PD (7,0)
DTECEN Century digit. C (1)
PONBR Pool number: Specifies the unique identifier of this pool. The value is from 1 to 64. C (3)
PTTYPE Type of tuning: The method used by the system to tune the storage pool:
  • 0 -- No tuning
  • 1 -- Static tuning
  • 2 -- Dynamic tuning of transfers into main storage
  • 3 -- Dynamic tuning of transfers into main storage and to auxiliary storage.
 C (1)
PTPAGE Change page handling. The method used by the system to determine when to write changed pages to auxiliary storage:
  • 0 -- Use the system default
  • 1 -- Periodically transfer changed pages to auxiliary storage.
 C (1)
PTNDBF Non-database blocking factor. The amount of data (in KB) that should be brought into main storage when a request is made to read non-database objects from auxiliary storage. PD (3,0)
PTDBF1 Database blocking factor (class 1.) The amount of data (in KB) that should be brought into main storage when a request is made to read database objects from auxiliary storage. PD (3,0)
PTDEX1 Database exchange operation type (class 1.) The exchange operation used to reduce the working set size.
  • 0 -- Use the system default
  • 1 -- Allow exchange operations
  • 2 -- Disable exchange operations
  • 3 -- Disable exchange operations.

The data that already exists in main storage should be a good candidate to be replaced when additional storage is needed in the storage pool.

 C (1)
PTDTS1 Database type of transfer to auxiliary storage (class 1.) The method the system uses to process a request to write an object to auxiliary storage.
  • 0 -- Use the system default
  • 1 -- Purge object from main storage
  • 2 -- Write object to auxiliary storage
  • 3 -- Indicate object is a good candidate for replacement
  • 4 -- Use the system page replacement algorithm.
 C (1)
PTDBF2 Database blocking factor (class 2.) See PTDBF1. PD (3,0)
PTDEX2 Database allow exchange operations (class 2.) See PTDEX1. C (1)
PTDTS2 Database type of transfer to auxiliary storage (class 2.) See PTDTS1. C (1)
PTDBF3 Database blocking factor (class 3.) See PTDBF1. PD (3,0)
PTDEX3 Database allow exchange operations (class 3.) See PTDEX1. C (1)
PTDTS3 Database type of transfer to auxiliary storage (class 3.) See PTDTS1. C (1)
PTDBF4 Database blocking factor (class 4.) See PTDBF1. PD (3,0)
PTDEX4 Database allow exchange operations (class 4.) See PTDEX1. C (1)
PTDTS4 Database type of transfer to auxiliary storage (class 4.) See PTDTS1. C (1)