IBM DB2 LUW — Administration on RHEL 9
Companion skill to rhel-server-admin and rhel-databases. For Python DB2 connectivity see python-enterprise-connectors.
Reference Files
Detailed code examples, patterns, and configuration are in the reference files below. Read the relevant file when working on that area.
| File |
Covers |
| install-admin.md |
DB2 installation on RHEL, instance management, and database administration (tablespaces, buffer pools, schemas, tables) |
| performance-monitoring-rhel.md |
performance tuning (db2advis, db2pd, MON functions), monitoring, maintenance, RHEL-specific configuration, and DB2 pureScale |
| security-backup-recovery.md |
DB2 security (authentication, authorization, roles, audit), backup strategies, and HADR recovery |
Anti-Patterns
| Anti-Pattern |
Why It Fails |
Correct Approach |
| Running DB2 with default buffer pool sizes |
Default 1000 pages is far too small for production; excessive disk I/O, poor query performance |
Size buffer pools based on workload: OLTP needs 60-80% of data in memory; run db2pd -bufferpools to monitor hit ratio |
| Skipping RUNSTATS after bulk data loads |
Optimizer uses stale cardinality estimates; queries that were fast become full table scans |
Run RUNSTATS WITH DISTRIBUTION on tables and indexes after every significant data change |
| Using HADR without automatic client reroute |
Failover happens but applications cannot find the new primary; manual intervention required |
Configure ALTERNATE SERVER in database directory and enable ACR in application connection strings |
| Not setting LOGFILSIZ and LOGPRIMARY appropriately |
Default log sizes cause log-full conditions during batch loads; transactions roll back and retry endlessly |
Size transaction logs based on largest expected transaction; monitor with db2pd -logs; set LOGSECOND as overflow |
| Running backup without testing restore |
Backup jobs succeed but restore fails due to missing log files, wrong paths, or version mismatch |
Test restore to a different instance quarterly; validate with RESTORE DB ... WITHOUT ROLLING FORWARD |
Related Skills
| Workload |
Skill |
| Core RHEL admin (dnf, SELinux, firewalld, LVM) |
rhel-server-admin |
| PostgreSQL, MySQL, Redis on RHEL |
rhel-databases |
| Python DB2/Oracle/SQL Server connectors |
python-enterprise-connectors |
| Web servers (Nginx, Apache, Caddy) |
rhel-web-servers |
| Docker / Podman containers |
rhel-docker-host |
| Monitoring (Prometheus, Grafana, PCP) |
rhel-monitoring |
