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...