Tag Newbie

Posts relevant to those new to DB2 administration

Establishing a DB2 JDBC Connection

Recently I was forced outside my comfort zone and asked to vet various open source BI tools. I was a report developer in a past life, a database administrator supporting datamarts at various employers, and even supported Cognos backend databases.…

Db2 Basics: Levels of Configuration

Updated 11/22/2017: instructions on how to run the SQL statement There are a number of places where we can store and change configuration for a Db2 server. I wanted to walk through the main areas and a few details about…

DB2 Basics: The DB2 LUW Sample Database

I find the DB2 sample database useful for trying new things and proving to myself how things work. Why Use the Sample Database? The DB2 sample database is useful for a variety of reasons. Testing Connectivity Sometimes when building a…

Playing With CLPPLUS

I’ve played with the clpplus at least once before, but have generally thought of it as a tool created to satisfy those coming from Oracle and looking for Oracle-like features. One of the features I actually liked about Oracle in…