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...
SQL0443N After Db2 Fixpack Upgrade

SQL0443N After Db2 Fixpack Upgrade

After applying a Db2 fixpack, you can get SQL0443N when calling the get_dbsize_info() stored procedure. Cause and resolving the problem: get_dbsize_info() uses the system catalogs internally which do not get updated as part of a fix pack update, and should be updated...
Seven SQL Performance-Killers to Avoid in Db2

Seven SQL Performance-Killers to Avoid in Db2

How Db2 Handles SQL SQL is a powerful language in the hands of the right RDBMS. One of SQL’s strengths is that you specify what data you want returned without specifying what file, disk, san, or sector that data is stored on. Because we describe the result set...