Category: Posts-By-Category

Three-Tier 0

DB2 Basics: Security

This post is not meant to be a comprehensive coverage of security, but an overview such that those newer to DB2 know what areas they may want to research further. Users, Authentication, and Authorization I’ve already covered this in some detail in DB2 Basics: Users, Authentication, and Authorization. In general, keep the permissions that you allow any user or group...

file0001207444674 1

Using DB2’s ADMIN_MOVE_TABLE to Move Tables from One Tablespace to Another

What is ADMIN_MOVE_TABLE ADMIN_MOVE_TABLE is an administrative stored procedure introduced in DB2 9.7. The intent is to provide a tool that can be used to perform an online move of a table, while transactions are still occurring against the table. Moves can be used to change what tablespace a table is in, convert a table to MDC, change the table...

0

Calculating Row Width and Choosing a Page Size in DB2

A DB2 DBA must be able to calculate the row width. The row width can be used to estimate table size, and also to pick a tablespace with the correct page size. DB2 is more strict about a row fitting on a page. For general purposes, a DB2 table must be in a tablespace where any row, minus LOBs fits...

LovePark 3

Participating in the DB2 Community

One of the questions I ask in every interview these days is “How do you participate in the DB2 community and keep up to date on new features in DB2?” If I am hiring for a more junior position, this might morph into “What sources do you use to learn about DB2?”. I sometimes worry that this is or will...

log-file-saturation 6

Preventing Log Saturation

A few days ago, I was involved in a conversation on Twitter with Ember and Erwin Hattingh, a DB2 DBA from the Netherlands whom I met at IDUG in Dublin last November. Ember expressed her surprise at how well DB2 handled a nasty situation: It's not every day #DB2 blows your mind with the ability to stay up in a...

2

TSAMP Issue on Fixpack

As always, when I feel pain, I share the knowledge that pain gained me with my blog readers. Man, that was a painful fixpack. I was upgrading an AIX HADR pair from 10.5 fixpack 3 to 10.5 fixpack 5. My experience has generally been that TSA is painful when patching DB2. Problem Description In this case, I was not patching...