Category: Uncategorized

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

Abhik 2

DB2 Workload Manager (WLM) as a Monitoring Solution– Analyzing WLM Information (Part 3 of 3)

This is part three of a three part series. The full series includes: DB2 Workload Manager (WLM) as a Monitoring Solution – Understanding WLM (Part1 of 3) DB2 Workload Manager (WLM) as a Monitoring Solution– How to Set up WLM (Part 2 of 3) DB2 Workload Manager (WLM) as a Monitoring Solution– Analyzing WLM Information (Part 3 of 3) The...

0

LBAC – Label Based Access Control

To go with my recent article on RCAC/FGAC, I thought I would do some similar work using LBAC and see what I could learn about it and the differences between the two. What is LBAC Label Based Access Control essentially adds a column to a table that labels each row (think confidential, secret, top secret), and then grants uses of...

5

Options to Encrypt Data at Rest in DB2

I thought it would be relatively easy to investigate encryption for our environment. I was wrong, was just plain confusing. This was not because encryption is complicated per se, but that a DBA really needs to have a good understanding of business needs. If you don’t have this understanding, you can get lost in an array of options. Are you...

13

Quick Hit Tips – CPUSPEED, RESTRICTIVE, and DB2_WORKLOAD

Today we are going to talk about some random DB2 features that can’t stand in a blog of their own, but are worth discussing nonetheless. These are tidbits I had discovered during “DB2’s Got Talent” presentations, IDUG conferences, or “Hey, look what I discovered” moments. CPUSPEED (Database Management Configuration) You blow past this setting every time you execute “db2 get...

1

Informational Constraints – Benefits and Drawbacks

One of the most frustrating things a DBA can experience is troubleshooting due to bad data. The client is upset because rows are missing or incorrect data is returned.  The client facing web front end could be displaying gobilty-gook because the data retrieved makes no sense. Resources and energy are burned because of an issue is easily solved with the...

1

Performance Tuning LOBs in a Transaction Processing Environment

Each Monday, I post a technical blog on DB2Commerce.com referencing my “DB2’s Got Talent” presentation from the previous week. However, my topic for Episode 131 “Sit. Stay. Good LOB. Domesticating your LOBs” was based off my first developerWorks article which was published on the same day. Instead of reinventing the wheel with an abbreviated article, I would like to point...