Observation: TYPE 1 Index
The current index is defined as a TYPE 1 index. It must be converted to a TYPE 2 index prior to migration to Db2 version 6. Converting to a TYPE 2 index will reduce deadlock and time-out problems on the index, and provide the following functions not available with TYPE 1 indexes:
-
row locking on tablespace
-
UR Isolation for an access path
-
processing of queries by multiple parallel tasks
-
concurrent access to separate logical partition