Category: Posts-By-Category

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

Screenshot_060816_111344_AM 1

The New IBM DB2 Knowledge Center

A new IBM DB2 Knowledge Center has been released, and search is actually better than before. Though there are still problems. There are some resources and things you can do to customize and make your IBM DB2 Knowledge Center experience better. And always remeber the local copy with really good search is an option, and a good one for those...

***UNDER STRICT EMBARGO UNTIL 00.01 ON 11 DECEMBER, 2013 GMT***DOCTOR WHO XMAS SPECIAL 2013 0

Deprecated, Discontinued, and Changed Defined for DB2

With each new release of DB2, there is a list of three different categories of old functionality that is somehow different in the new version. The use of these terms can be confusing if you don’t look at them every day. Discontinued Discontinued means that a feature or function is no longer available. If you try to use it, it...

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