by XTIVIA | Nov 27, 2012 | Blog, Databases
Hi. I recently finished a project for a client who needed Update-Anywhere Repliction on one table between 4 DB2 version 9.1 databases at different locations. I thought I would share a high-level overview of the process I used, starting with 2-way...
by XTIVIA | Sep 26, 2012 | Blog, Databases
One way to make your DB2 database use less storage and speed up Inserts and Updates is to drop the indexes that are never used. As the application changes and the database workload changes, you may find many indexes are no longer needed. Dropping these...
by XTIVIA | Aug 2, 2012 | Blog, Databases
Hello again, I wanted to follow up on my last blog entry about speeding up the DB2 database restore on an AIX machine. We did some more testing last night by enabling the jfs2 logging back to how it should be. The restore took only 5 minutes when it used...
by XTIVIA | Jul 31, 2012 | Blog, Databases
Hello, I wanted to share some lessons learned with AIX kernel parameters and DB2 database restore performance. We have a client with a 21 GB database on AIX version 6.1 and DB2 9.7 fixpack 6. The server has 8 quad-core CPU and 32 GB of memory. This is a...
by XTIVIA | May 3, 2012 | Blog, Databases
This is a short video on how you can use an open source tool called Pentaho Data Integration to migrate data between tables in DB2 and SQL Server. This video is on youtube and walks through downloading the open source code, setting up database connectivity,...
by XTIVIA | Apr 9, 2012 | Blog, Databases
Well, I’m in the final 4 and I made my last presentation on the DB2Night Show’s “DB2’s Got Talent Contest 2012” last week. I wanted to make it a fun and ‘edutaining’ presentation so I chose to do a parody of the American...