Terminating Db2 Backups to a Vendor Media Server

Terminating Db2 Backups to a Vendor Media Server

Sometimes, while running a database backup or restore, you may encounter a situation where you need to terminate the backup or restore operation. If the backup is writing to disk, this is quite easy: You can generally type Ctrl-C, and the Db2 Command Line Processor...
Investigating TSAMP Details in Already Setup Environment

Investigating TSAMP Details in Already Setup Environment

There are several scenarios where you might need details to re-build TSAMP. If TSAMP did not start properly after an upgrade or even while troubleshooting, the option to open a case with IBM and get root cause analyzed takes time. In many of these scenarios,...
Three Text Highlighting Tricks with PuTTY

Three Text Highlighting Tricks with PuTTY

PuTTY is a free, cross-platform terminal program that supports SSH, telnet, and raw socket connections. For authentication it supports public key and kerberos single-sign-on. This application, is one of the oldest clients for Microsoft Windows, released by Simon...
Db2 System Authorities

Db2 System Authorities

How do I grant a user SYSADM, SYSCTRL, SYSMAINT, or SYSMON privileges in Db2? As a newbie to the database administration world, I was tasked with giving a pretend user the ability to create databases in a virtual environment setup for learning. I easily found that the...