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...
by XTIVIA | Mar 29, 2012 | Blog, Databases
Hello everyone, Today is the last chance to vote me into the top 3 of this DB2 presentation contest. If you could take 10 seconds and go to this link and vote, I’d really appreciate it. It has to happen today!! You don’t need to...
by XTIVIA | Mar 16, 2012 | Blog, Databases
I gave my third presentation today for the finals of the DB2’s Got Talent contest given by the good folks at the DB2Night Show. I found out that I’ve made it to the final round! Thanks to everyone that voted for me! (I’ll have to...
by XTIVIA | Mar 5, 2012 | Blog, Databases
Hello again, I presented on DB2 Table Reorg on Friday, March 2 for the DB2Night show’s 4th annual DB2’s Got Talent contest. I’m one of 10 finalists from around the world and Friday was the first of 3 rounds to choose a winner. The...
by XTIVIA | Feb 16, 2012 | Blog, Databases
Importing data in DB2 HADR takes some extra considerations. For one, non-logged activity is not replicated to the Standby database. So if you use the LOAD command to import data into a table on the Primary database, the same table on the Standby database...
by XTIVIA | Sep 2, 2011 | Blog, Databases
Please check out this video on how to set up replication using IBM DB2 Replication Center. Be sure and contact me if you have any questions. Thanks for...
