Set Maximum Connection Limits (MAX_CONNECTIONS and MAX_COORDAGENTS)

Cómo se verifica

Método de auditoría: Comando de shell

out=$(db2 get dbm cfg 2>/dev/null) || exit 1; printf '%s\n' "$out" | awk '{ if (match($0, /\([A-Z0-9_]+\) *=/)) { k = substr($0, RSTART + 1, RLENGTH); sub(/\).*/, "", k); v = $0; sub(/^[^=]*=/, "", v); gsub(/[ \t]/, "", v); c[k] = v } } END { if (("MAX_CONNECTIONS" in c) && index(c["MAX_CONNECTIONS"], "AUTOMATIC") == 0 && index(c["MAX_COORDAGENTS"], "AUTOMATIC") == 0) print "compliant"; else print "noncompliant: " "MAX_CONNECTIONS=" c["MAX_CONNECTIONS"] " MAX_COORDAGENTS=" c["MAX_COORDAGENTS"] }'

Salida esperada

compliant

Cómo se corrige

Método de corrección: Guía o parche de infraestructura

The default value for MAX_COORDAGENTS is AUTOMATIC(200). Allowable range is 1 to 64,000. The recommended value is 200, without the AUTOMATIC setting. The value of 200 is used as an example and is dependent on workload as discussed in the Description. The default value for MAX_CONNECTIONS is set to AUTOMATIC(-1). Allowable range is 1 to 64,000, or -1 for matching the value of MAX_COORDAGENTS. The recommended value is -1 without AUTOMATIC. It is also acceptable to have a value for MAX_CONNECTIONS that is greater than MAX_COORDAGENTS, such as 300, in order to turn on the Concentrator feature. Generally, both MAX_COORDAGENTS and MAX_CONNECTIONS should be configured within the same statement, otherwise the error SQL6112N may be encountered. The following command will set the MAX_COORDAGENTS to 200, as well as set the MAX_CONNECTIONS to -1. 1. Attach to the Db2 instance db2 => attach to ...

Verificar este host

Ejecute esto en un equipo que tenga permiso para auditar. El escaneo es de solo lectura.

tmaegis scan --target db2