Patent ID: 6108653
Filing Date: 2000-08-22
Classification: G06F,Y10S

Abstract:
A method of determining a condition of a database, comprising the steps of:identifying a database table;determining elements corresponding to the condition of the database table based on data contained in the database table; andproviding said elements to one of a display for viewing by a user, a storage location, and a mechanism for using said elements;wherein said elements include at least one of number of simple rows, number of migrated rows, number of deleted rows, number of blocks initialized but empty, average free space in a block unused, average free released free space, average row length of migrated rows, average row length of chained rows, number of blocks to be read for normal, chained, and migrated rows, measure of density of blocks used, number of blocks exceeding a percentage used threshold, number of blocks less a percentage free threshold, number of chained rows spanning data files, and min max average of chained rows spanning blocks.