Set a generic system name – ‘db2system value’ Details The db2system parameter specifies the DB2 system name that is used by users and database administrators to identify the...
Set administrative notification level – ‘notifylevel = 3 or 4’ Details NOTE : Update DB2_VERSION to the appropriate value for your local environment. Supportive Information The following resource is also...
Set archive log failover retry limit – ‘numarchretry <= 5' Details NOTE : Update DB2_VERSION to the appropriate value for your local environment. Supportive Information The following resource is also...
Set diagnostic logging to capture errors and warnings – ‘diaglevel = 3 or 4’ Details The diaglevel parameter specifies the type of diagnostic errors that will be recorded in the db2diag.log file. Supportive Information...
Set failed archive retry delay – ‘archretrydelay <= 20' Details The archretrydelay parameter specifies the wait time (in seconds) to retry to archive the log file after a failure....
Set maximum connection limits – ‘maxappls <= 99' Details The max_connections parameter indicates the maximum number of client connections allowed per database partition. Supportive Information The following resource...
Set maximum connection limits – ‘max_connections <= 100' Details The max_connections parameter indicates the maximum number of client connections allowed per database partition. Supportive Information The following resource...
Set maximum connection limits – ‘max_coordagents <= 100' Details The max_connections parameter indicates the maximum number of client connections allowed per database partition. Supportive Information The following resource...
Start and Stop DB2 Administrator Server Details The DB2 administration server responds to remote requests from administration tools and client utilities. It is recommended that administrators...