Archive for the ‘ibm db2’ Category
Tuesday, March 31st, 2009
some tips on dealing with DB2 XML column and data:
1) create an index of a xml path for search
If in a XMl column, you want to search, you can create a xml index and convert it into VARCHAR
so the values in the index will be used rather than scanning the ...
Posted in ibm db2 | No Comments »
Tuesday, January 22nd, 2008
I/O stack components Overview
Typically the stack consists of the following
• Database
• Character or block device driver
• Multipathing driver
• SCSI driver
• HBA
• System Bus
• Switch/iSCSI routers
• Storage Array
• Disks
Example of vendors:
ASM-Database IBM Oracle
Character or block device driver
Multipathing driver – PowerPath, Windows MPIO
SCSI driver
HBA – Host Bus Adapter, Qlogic (IBM), Emulex
System Bus ...
Posted in hardware setup, oracle, ibm db2, Back-of-the-Envelope, Database, Storage, Design, Fibre Channel, Capacity planning | 1 Comment »
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 ...
Posted in db tuning, automation, system admin, aix, ibm db2 | No Comments »