By Special request, a DB2 Tools Cheat Sheet. Not all-inclusive, but some of the ones you’re most likely to use in supporting e-commerce databases. Click on the command to get to the DB2 Info Center entry on each one. If you think I’ve missed something important, comment with it.
| Tool | Category | Purpose |
| Export | Data Movement | Pull data out of a table into ixf, csv(del), or other formats. |
| Import | Data Movement | Get data into a table from ixf, csv(del), or other formats – fully logged |
| Load | Data Movement | Get data into a table from ixf, csv(del), or other formats – optional logging and deferred constraint checking |
| db2move | Data Movement | Use export, import, or load with multiple tables at once – can be whole-database |
| db2relocatedb | Data Movement | Rename or move all or part of a database |
| db2look | Data Movement | Get all DDL, DCL, or statistical information in an executable format – great to have for backing out database structure changes |
| Get snapshot | Monitoring | Get detailed information about database activity |
| db2top | Monitoring | Real-time monitoring based on the snapshot monitors |
| db2pd | Monitoring | Get detailed information about database activity |
| Event monitors | Monitoring | Get line-item detailed information about various database activities – be careful of overhead |
| db2mtrk | Monitoring | Report memory allocated to db2 and various heaps |
| db2evmon | Monitoring | Parse db2 event monitors to a human-readable format |
| db2gov | Performance / Security | Work with db2 governor |
| db2exfmt | SQL Analysis | Parse explain data and generate explain plan |
| db2batch | SQL Analysis | Benchmark timing of SQL statements |
| db2advis | SQL Analysis | Use db2 design advisor to recommend indexes |
| db2audit | Security | Manage db2audit facility for auditing database activity |
| db2cfexp | Configuration | Export major configuration to a file to use as backup or to move between environments |
| db2cfimp | Configuration | Import major configuration from a file created by db2cfexp |
| Get dbm cfg / update dbm cfg | Configuration | Get or change the database manager configuration |
| Get db cfg / update db cfg | Configuration | Get or change the database configuration |
| Get cli cfg / update cli cfg | Configuration | Get or change the cli configuration |
| db2set | Configuration | Manage the db2 registry |
| db2ckbkp | Recovery | Check integrity of a backup image |
| db2dart | Data Integrity | Offline check of physical data |
| db2diag | Error Investigation | Parse the db2 diagnostic log |
| db2support | Error Investigation | Gather information to send to db2 support |
| db2trc | Error Investigation | Use db2 trace facility – usually at db2 support’s request |
| db2icrt | Build | Create db2 instance |
| db2idrop | Build | Drop db2 instance |
| db2sampl | Build | Create Sample database |
| db2iupdt | Instance management | Update db2 instance |
| db2ilist | Instance management | List db2 instances |
| db2level | Instance management | Display db2 version and fixpack |
| db2start | Instance Management | Start db2 instance |
| db2stop | Instance Management | Stop db2 instance |
| db2rbind | Package management | Rebind packages |
| Runstats | Performance | Collect optimizer statistics |
| Reorgchk | Performance | Check the need for reorgs on tables |
| Reorg | Performance | Reorganize tables/indexes on disk |
| Backup database | Recovery | Take a backup of the database |
| Restore database | Recovery | Restore a database from a backup image |
| Rollforward | Recovery | Play transactions from a backup through a specified point in time |
