DB2 Cheat Sheet (Instances)

Managing DB2 instances is a substantial portion of a DB2 DBA’s daily workload. Here’s a simple cheat sheet I’ve designed to define a DB2 instance and outline the basics of an instance’s memory model, process model, and file structure. I’ve also listed a few commands that are specific to instance management (creating, dropping, starting, stopping, etc).




DB2 Cheat Sheet (Commands)

While preparing for a DB2 interview, I compiled a list of DB2 commands and grouped them by purpose. FYI, notice how DB2 system commands are essentially binaries (db2start, db2licm, db2ilist) and as a result are path dependent. On the other hand, Command Line Processor (CLP) commands are executed directly from a DB2 prompt or from the command line using db2 “execute some command”.