TMAegis
More rules for db2

TMA-DB2-3.2.2

Turn Off Remote Command Legacy Mode (DB2RCMD_LEGACY_MODE)

MediumLevel 1Automateddb2

Description

The DB2RCMD_LEGACY_MODE registry variable determines whether the Db2 Remote Command Service runs with enhanced security or not. It is recommended that legacy mode not be enabled. This registry variable only applies to Db2 Servers running on Windows. Unset or OFF passes. Default: The default value of DB2RCMD_LEGACY_MODE is OFF. Run as the instance owner (or with sqllib/db2profile sourced) so the db2 CLP reads this instance's configuration.

How it is checked

Audit method: Shell command

shell
out=$(db2set -all 2>/dev/null) || exit 1; printf '%s\n' "$out" | awk '/^\[[a-zA-Z]\]/ { l = $0; sub(/^\[[a-zA-Z]\] */, "", l); k = l; sub(/=.*/, "", k); v = l; sub(/^[^=]*=/, "", v); gsub(/[ \t]/, "", v); if (!(k in r)) r[k] = v } END { if (!("DB2RCMD_LEGACY_MODE" in r) || toupper(r["DB2RCMD_LEGACY_MODE"]) == "OFF") print "compliant"; else print "noncompliant: " r["DB2RCMD_LEGACY_MODE"] }'
Expected output
compliant

How it is fixed

Fix method: Guidance or infrastructure patch

Run the following command to set the DB2RCMD_LEGACY_MODE registry variable to OFF: db2set DB2RCMD_LEGACY_MODE=OFF

Properties

Operating systems
Any
Tags
db2databaseregistry
Reference
CIS IBM Db2 12.1 Benchmark v1.0.0 - 3.2.2 Turn Off Remote Command Legacy Mode (DB2RCMD_LEGACY_MODE)

Check this host

Run this on a machine you are allowed to audit. The scan is read-only.

shell
tmaegis scan --target db2