Skip to content

Tag Archives: db2

A NetBackup for DB2 Cheat Sheet

25-Mar-09

This post is a cheat sheet for most of what I think the DB2 database administrator needs to know about Symantec NetBackup as a DB2 backup, recovery and log archival utility. My notes make version and platform assumptions of Unix DB2 version 9 and above, and NetBackup 6.0.

I wrote this because you don’t need to know that much to get NetBackup working for DB2, and the Symantec docs are very unclear and not well written. With that being said, if you get into a jam you will need to read the Symantec docs, and probably call their support. As I discovered, not everything is documented. But NetBackup DB2 Agent version 6.0 seems to work quite well most of the time.

A Simple DB2 Audit System

10-Mar-09

I just wrote a small Unix script-based db2audit capture system for one of my version 9 DB2 databases. Includes full script and DDL to assemble your own system.