databasejournal.com databasejournal.com

DB2 Migration to Version 8 - Part 2 - Page 3

Type 2 Indexs Version 8 introduced Type 2 indexes as a new standard index type, replacing the V7 Type 1 indexes. Both indexes currently coexist, however, Type 1 indexes will be de-supported in the future. The type 2 index is replacement for the old Type 1 index, which has suffered from: concurrency issues during inserts and next key locks performance issues due to physically removing a key from a leaf page during update...

databasejournal.com databasejournal.com

DB2 Migration to Version 8

A long line of applying database FixPaks has ended with number 11, the last FixPak V7, and a brand new line has begun with DB2 V8. Currently, a total of six FixPaks have been released for DB2 V8. Consequently, support for DB2 V7 has come to an end. This event triggered many DBAs to begin the process of database migration to DB2 V8. IBM promotional brochures stressed V8 superiority, with its brand new self-managing and resource tuning...

databasejournal.com databasejournal.com

The DB2 Configuration Files Revealed - Page 3

node_num.env - DB2 instance node level profile registry File Name Default Location "node_num".env $HOME/sqllib/nodes An SDP configured database system, with the DB2 database divided across different physical database partitions, has a node_num.env registry file on every database partition. My demo DB2 database ARTIST was running on only one physical machine and did not have...

databasejournal.com databasejournal.com

The DB2 Configuration Files Revealed - Page 2

The DB2 Instance Configuration Files In contrast to the operating system configuration files, a DB2 database instance has numerous configuration points. Under normal conditions, a DBA does not need to intervene and update any of them manually. The next picture displays the DB2 instance configuration files related to a single machine running different DB2 database software installations, (DB2 version 7.1 and version 8.1),...

databasejournal.com databasejournal.com

DB2's Virtual Time

The time problem occupied my attention, during a recent recovery situation. On the SUN Solaris machine, the system time jumped forward unexpectedly. This situation raised questions about system and database time interaction, the time drift influence on the backup and recovery and many others. For example, what happens in complex multi-partition DB2 database environments with millions of transactions when the time goes wild? This...

databasejournal.com databasejournal.com

DB2's Virtual Time - Page 2

Virtual Database Time Each database partition holds a virtual time clock, which it advances after each successful commit. The virtual database time is calculated internally by the DB2 engine at commit time and is used as the main "magic" number in the database. To better understand the virtual time concept, I made one graphical representation for the DB2 EEE transaction. Click for larger image Picture 2: DB2 EEE...

databasejournal.com databasejournal.com

DB2 Database and Tivoli Storage Manager

My first DB2 article, "Who needs incremental delta backup" published on January 29, 2003 was an introduction to the DB2 backup and recovery technology on the SUN Solaris platform. Since then, I have been asked many times to write on some very interesting topics that are not covered in detail in the existing IBM documentation. All requests from the readers have been collected, resulting in this new series of DB2 articles. This...

databasejournal.com databasejournal.com

DB2 Database and Tivoli Storage Manager - Page 2

TSM Server Configuration For demonstration purposes, I have created one multimode DB2 database named ARTIST, belonging to the TSM API configuration on the ARTIST_DB2 server machine, running on a SUN Solaris operating system. The TSM administrators are responsible for the TSM server organization and configuration , however, they need clear, technical input from the DB2 administrators. The allied forces of the DB2 and TSM...