DB2 SQL Replication lessons learned PART 2

This is part two of lessons learned during a recent DB2 SQL Replication engagement. After registering a source table for replication and creating an Apply Control server, you need to create a new Subscription set under that Apply Control server.  This is on the...

DB2 SQL Replication lessons learned

Registering an existing DB2 source table for CCD (Consistent Changed Data) replication using the DB2 Replication Center: This blog entry is from lessons learned on a recent engagement in which the client wanted to replicate several large tables from a Linux system to...

Missing Settings From a Draft Blog Entry?

While enhancing our blogs portlet functionality, I came across what appeared to be a few interesting oversights while editing blogs. While editing and publishing (or submitting for publication) a blog entry worked entirely as expected, if one selected the “Save as...

ORACLE: Upgrade to 11gR2 – Migrate to ASM

11gR2 Upgrade: Recently, I had a customer who needed to upgrade their database to 11gR2 from 10.2.0.3.  The upgrade needed to move the database from a cooked file system to Oracle’s ASM. Additionally, the customer wanted to have Oracle Enterprise Manager...

BI Tool Selection Considerations

Which BI tool is right for us? Every organization faces this decision when they are looking to build a BI solution. We have had a lot of customers ask this to us. Without going into too much detail, I will outline the process I like to use. Price is almost always a...

CommVault: Agent Incorrectly Configured

Recently, I handled a client who is using CommVault for their backup and recovery application that was having issues with the agent installed on their DB2 database. My background as an Oracle DBA and a CommVault Certified Engineer allowed me to quickly identify the...
Oracle Data Pump: Interactive Mode – Attach/Detach

Oracle Data Pump: Interactive Mode – Attach/Detach

Recently, I had a customer who was importing a long running Data Pump import job.  The client needed to go home and still have a way to monitor the import job. Starting with Oracle 10g Data Pump there is a useful feature in situations in which you start a job at...