Bmc Software, Inc.

International Business Machines Corporation

Thomas E Hintz

Kerry Charles Tenberg

William R Cunningham

Hugh H Arnold

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.

Check data operation for DB2

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.

Method of checking index integrity in a DB2 database

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.

Databases system for permitting concurrent indexing and reloading of

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. Also disclosed is a method of retrieving a message having a unique identifier that includes the step of first locating the identifier in a message look-up table portion of a message file and then retrieving a pointer that corresponds to the identifier. The pointer is used to locate the first token of a token string that represents the words and variables of a message. Each of the tokens is then used to access the message word table or is decoded to represent the variables, the words and variables are assembled in a buffer in the order of occurrence in the message token string to form an assembled or formatted message.

Growing community of inventors

Austin, TX, United States of America

Thomas E Hintz