DB2 Administration Available

Basic Administration Manual: Blocking, Performance, and Basic Configuration in DB2

Ready-to-run MON_GET_* scripts to review lockwaits, high-consumption SQL, and validate STMM and instance parameters.

DB2 11.5+
Language
Spanish
Last updated
2026-07-28
Level
Intermediate
USD 13

100% digital delivery. The manual and files are sent by email after payment is confirmed.

Summary

Problem it solves

Have a set of proven scripts on hand for the daily check of blocking, performance, and configuration in DB2, without having to rebuild them every time.

Who it is for

DBAs or system administrators who operate DB2 LUW in production and need a repeatable technical checklist.

Who it is not for

Anyone who needs advanced HADR diagnostics (see the dedicated DB2 HADR guide in the catalog).

What's included

  1. Reviewing blocking: MON_GET_APPL_LOCKWAIT and MON_GET_LOCKS
  2. Details of the blocking application
  3. Forcing an application (last resort)
  4. Reviewing performance: MON_GET_PKG_CACHE_STMT
  5. I/O consumption and buffer pool hit ratio
  6. Top-consuming sessions and agents
  7. Basic configuration: Self-Tuning Memory Manager (STMM)
  8. Critical DBM CFG parameters
  9. Bufferpools and logging
  10. Basic instance configuration checklist
  11. Consolidated daily health-check script

Technical information

Engines
DB2 11.5+
Operating systems
To be defined
Tools
To be defined
Level
Intermediate
Estimated duration
30-45 minutos
Prerequisites
SQLADM or DATAACCESS authority for monitoring functions, SYSADM or SYSCTRL for configuration changes

Included files

  • PDF manual with the diagnostic scripts included in the text

Lab evidence

Lab evidence: in preparation

This guide has no public evidence yet. Once published, it will include anonymized screenshots of the real execution, with no hostnames, private IPs, usernames or client data.

Licenses

Version history

  • 1.0 — 2026-07-28: First published edition.

Other guides for DB2

READY FOR THIS GUIDE?

Basic Administration Manual: Blocking, Performance, and Basic Configuration in DB2

USD 13