Archive for the ‘db tuning’ Category

DB2 V9.1 on AIX: tips on drop instance, de_install, re_install, re-create instance

Thursday, June 14th, 2007

Like the Nissan Pathfinder's ad: "not that you would, but you could". In certain performance test conditions, you may have to drop the current DB2 V8 instance, install V9.1, and re-create a instance. Here is a short list of helpful commands - run as root unless specifically sudo'ed: 1. Drop ...