by XTIVIA | Jul 18, 2011 | Blog, Databases
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...
by XTIVIA | Jul 12, 2011 | Blog, Databases
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...
by XTIVIA | Jun 10, 2011 | Blog, Databases
I’m posting some useful DB2 SQL replication troubleshooting utilities and how to use them. These will work with any version 9 replication environment. ASNANALYZE Use the asnanalyze command to generate reports about the state of the...
by XTIVIA | Jun 7, 2011 | Blog, Databases
Today, 2011 Jun 07, RSA admitted that a hacker was able to break into a Lockheed Martin computer system because of a data breach at RSA. This is a huge problem for RSA, since their business model is pretty much defined by preventing exactly this situation. ...
by XTIVIA | Jun 4, 2011 | Blog, Databases
Is your company considering using CommVault’s Simpana Backup software to backup your database’s and other applications? I am a certified CommVault Software Engineer and also an Oracle Certified (OCP) 10g Database Administrator. Having previously worked for...
by XTIVIA | Jun 1, 2011 | Blog, Databases
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...
by XTIVIA | May 12, 2011 | Blog, Databases
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...
by XTIVIA | May 9, 2011 | Blog, Databases
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...
by Dennis Robinson | Apr 27, 2011 | Blog, Databases
The following are observations and recommendations from one of our clients experiencing issues with Informix Database Replication. 1.) The session thread was doing quite a bit of sleeping. This normally occurs when control is handed off to another thread. The...
by Vivek Agarwal | Mar 1, 2011 | Blog, Databases, Enterprise Java
We recently switched one of our client’s WebSphere Application Server and WebSphere Portal based infrastructure to a new physical environment. During our testing we found that we were getting stale connection exceptions in SystemOut.log and in the application...
