Index of Introductory Db2 Topics

Posted by

This blog entry is designed to serve as a roadmap for current blog entries directed at those newer to Db2. In my mind, this likely includes anyone who has been working with Db2 for less than 2 years. However, often there are areas we spend more time in than others, so I think of these topics also as “spackle” – to fill in gaps for the self-taught. Note that some of the topics below are not links. This is because they’re areas I plan to blog about in the future.

If anyone has suggestions for additions, I’d love to hear about them in the comments.

Updates to this blog entry are listed at the bottom rather than the top, as a large number are expected.

Introduction to DB2

Introduction to IBM Db2
The Role of Databases
The Role of the Db2 DBA
The Db2 Sample Database

Basics of How to Work with Db2

How to Get a List of Local Db2 Databases
How to Catalog a Db2 Database
Executing a Script of SQL
What you Need to Do to Support a Db2 Environment
Setting up a Command Line to Work with Db2
How to Connect to a Local Db2 Database
Tools for Working With Db2
How Working with Db2 on Windows is Different than Working with Db2 on UNIX/Linux

Architecture, Build, and Patching

BLU
File Systems for Db2 on Unix and Linux
Storage Groups
Patching Db2
Using FTPS to get a Fix Pack Directly to a Db2 Server
Users and Groups Needed to Install Db2
Overview of Full Version Upgrades
Compatibility with Other RDBMS syntax

Security

Security
Users, Authentication, and Authorization
Investigating Permissions in an Existing Database
Overview of Advanced Security Options

Configuration

Levels of Configuration
Backups of Data and Configuration

SQL

Executing a Script of SQL
Capitalization
Statement Terminators
Quotation Marks
SQL Analysis Overview
Navigating the Db2 System Views and Tables
Basics of Writing SQL (series?)

Db2 Documentation, Error Messages, and Troubleshooting

Error Messages
The Db2 Diagnostic Log
What File Systems does my Database Actively Use?
Navigating the IBM Db2 Knowledge Center
Knowledge Center Structure – System Monitor and Syntax
Knowledge Center Structure – Parameter and Message Reference and General Guidance

Locking and Isolation Levels

Isolation Levels and Concurrency Phenomena
Locking

Backup, Recovery, High Availability, and Disaster Recovery

High Availability Options for Db2 LUW
Backups of Data and Configuration
The History File
Transaction Logs
Managing Retention of Backup Images and Transaction Log Files
Concepts of Restore

Db2 Objects

Instances
Storage Groups
Tablespaces
Tables
Indexes
Stored Procedures, Functions, and Modules
Aliases
Triggers

Administrative Commands, Maintenance, and System Stored Procedures

Administrative Commands
db2look
db2top
MONREPORT
Runstats
Reorgs
db2diag
db2batch
db2pd

Basics of Performance

STMM
KPIs
SQL Analysis Overview

Data Movement

Exporting Data
Load, Import, Ingest
Load from Cursor
Database Conversion Workbench
Overview of Data Replication Options

Connectivity

What Port Number is Db2 Listening for Connections on?

Updates

  • 2018-03-23 Added placeholders for db2pd and compatibility options
  • 2018-04-29 Added connectivity section and link to article on what port Db2 is listening on
  • 2018-07-12 Added link for connecting to a database

Lead Db2 Database Engineer and Service Delivery Manager , XTIVIA
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 17 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science. Ember lives in Denver and work from home for XTIVIA, leading a team of Db2 DBAs.

3 comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.