Category: DB2 Basics

Basic but comprehensive introductory coverage on core DB2 topics

file0001484079306 1

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 them. Db2 Registry The Db2 registry actually has a number of levels within itself. It is accessed using the db2set...

6

DB2 Basics: Statement Terminators

The default statement terminator for DB2 on Linux, UNIX, and Windows platforms is the semi-colon (;). If you are executing a script of SQL using the -tf options, and do not specify an alternate terminator, DB2 will assume you are using the semi-colon. There are some statements that require semi-colons within the statements, though. For these kinds of statements, the...

When you need to find root cause quickly. 0

Troubleshooting with Mickey Mouse, Snow White, and Cinderella

It’s that magical time of year again. DBAs excitedly pack their bags for a week-long trip. On-call rotation is hurriedly passed to the next poor soul on the rotation list. Ember dons her trademark pigtails. Melanie Stopfer crams another 20 slides into and already packed presentation. It’s time for the IDUG North American Technical Conference in Anaheim, California. All your...

DSCF3217 1

The Role of a DB2 DBA and of the DB2 Consultant

This blog post was inspired by a DM on Twitter. A follower asked me for ideas on how to best interact with developers and how much expertise to give away. This is a big question with a vast array of correct answers. It is also a subject on which I have a lot of opinions that are wholly mine and...

f8259cc09326948fe0d3a93567a9fcc2 0

DB2 Basics: The Role of Databases

This blog article should appeal to a wide audience. This article is not specific to DB2, but speaks to the larger role of the database in the IT organization. What is a Database? At the most basic level, a database is an organized collection of information. Technically, you could consider a filing cabinet a database. Even an MS Excel Spreadsheet...

DSC04677 4

DB2 Basics: Patching DB2

Like any software, DB2 requires frequent patching. A database should be one of the most secure parts of any enterprise, and keeping it secure means keeping up with the fixes that are delivered in fix packs. Fix Packs DB2 delivers many things through fixpacks, including: Security Fixes Bug Fixes New Functionality – though IBM goes back and forth on this...

PA281185 1

DB2 Basics: Stored Procedures, Functions, Modules, Oh My!

DB2 has a number of objects where that use procedural SQL. IBM calls this SQL PL, not to be confused with PL/SQL or TSQL, both similar concepts. Much PL/SQL also works in DB2, if you have the Oracle compatibility vector enabled. The various types of objects have different places and purposes, and it can be useful to understand the use...

IsolationLevels 1

DB2 Basics: Isolation Levels and Concurrency Phenomena

Isolation levels are such a critical concept to maximizing concurrency for transaction processing databases where ACID is so critical. What is ACID? ACID stands for Atomicity, Consistency, Isolation, Durability. This is a set of concepts that applies to any transaction processing system, whether it is a Relational Database Management System (like DB2) or not. ACID is one of the big...

f8259cc09326948fe0d3a93567a9fcc2 5

How to Get a List of Local DB2 Databases

The database directory is something many of us use every day. It includes informaiton for connecting to databases, both local and remote, as well as additional information like alternate servers and filesystems where database directories reside. Getting just the local database names out of it may take a bit of practice. Please use the code here cautiously, after thorough testing,...