Category: Scripting

IanB 3

Determining Log Span

Some time ago, I wrote a post that suggested using the NUM_LOG_SPAN database configuration parameter to prevent long-running transactions from filling your transaction log. Using NUM_LOG_SPAN will indeed prevent the problem of long running transcations causing log file saturation, but what if you just want to find applications could become a problem, before the problem happens? Understanding LSNs Most DBAs...

f8259cc09326948fe0d3a93567a9fcc2 3

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

file0001207444674 2

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

shell1 5

PowerShell for DB2 DBAs – Part 1

Any DBAs faced with having to administer and maintain a large number of instances and databases will quickly find themselves swamped with work unless they learn to script most of their workload.  Of course, the benefits of scripting do not end there.  This post is intended to be the first of a planned series with a goal to show how PowerShell...