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 | No Comments »
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 »