ANR1878E
A database manager configuration parameter cannot be updated. The value of the DIAGSIZE parameter is greater than the amount of free space available in the database manager's diagnostic data directory.

Explanation

The error occurred because the current value of the DIAGSIZE database manager configuration parameter is greater than the amount of free space in the drive or the file system that contains the diagnostic data directory.

System action

The operation fails. Depending on the configuration parameter that is being updated, the server might stop.

User response

Complete one of the following options:
  • Specify a smaller value for DIAGSIZE.
  • Change the location of the diagnostic data directory to a drive or file system that has more free space.
  • Increase the amount of free space on the drive or file system containing the diagnostic data directory.

To check the current setting of the DIAGSIZE configuration parameter, issue the following database command:

db2 get dbm cfg

and search for "DIAGSIZE".

To change the value of the DIAGSIZE configuration parameter, issue the following command:

db2 update dbm cfg using DIAGSIZE new_size

new_size is the value, in megabytes, of the DIAGSIZE configuration parameter. The value must be 2 or greater.

For more information, see "Locating DB2® diagnostic log files" in the appropriate version of the product information.