Abstract: A single phase CHECK DATA operation for DB2 entails creating a special SORT record for each prinary key and each foreign key, collating the special SORT records in a particular way to group together the SORT records for each primary key, and performing diagnostic operations on the sorted records.

Abstract: A single-phase CHECK INDEX operation for DB2 entails creating a special SORT record for each data record and each index entry, collating the special SORT records in a particular way to group together the SORT records for each data record and any associated index entries, and performing diagnostic operations on the sorted records.

Abstract: The reorganization method of DB2 data files explores parallel processing, and asynchronous I/O to a great extent. It includes means to estimate an optimum configuration of system resources, such as storage devices (DASD devices), memory, and CPUs, etc, during reorganizations. The method mainly consists of four components, (1) concurrent indexing, (2) concurrent unloading of data file partitions, (3) efficient reloading of DB2 data pages and DB2 space maps, and (4) means to reduce access constraints to the DB2 recovery table.

Abstract: A method for forming a file of messages for a computer program including the steps of first forming a first file portion as a message word table having entries corresponding to the message words, said entries ordered in the table by their frequency of occurrence in the messages. Then forming a second portion as a message token string table containing a token string for each message where each token string includes several tokens, each representing a word or variable in the message. The tokens are located in the string according to the location of the corresponding words in the message. Each token has a value that represents the location of its corresponding word in the message word table. The third step includes forming a third file portion as a message look-up table that contains a unique identifier for each message and a corresponding pointer that indicates the address of a token in the token string table.