Method for analyzing status of specialized tank files which store and handle large objects
View Patent ↗A data management system is provided with a database which has internal tanks for storing large object data according to the size of the data involved. An analysis method and system is provided which will search out and calculate the space of each of the tank files involved and will report on how the space of each tank file is being used in terms of existing large objects, in terms of unused and available space, and in terms of deleted large object spaces.
1. In a Database Management System wherein a server means manages the operation of specialized data files in a database holding Large Objects (LOBs) in separate Tank files which are organized to hold small-sized LOBs, of 6 KB or less, medium-sized LOBs, of size 6 KB to 60 KB, and large-sized LOBs, of sizes greater than 60 KB, and wherein each Tank holds a dataset which provides information on each item in Tank storage, a system for analyzing the status of space usage in each of said Tank files comprising: (a) first program means (DMUTILITY) for managing said database and for invoking a second program means (LOBUTILITY); (b) said second program means (LOBUTILITY) for scanning each dataset in each Tank file and including: (b1) means to calculate various capacity status information regarding each Tank file wherein said means (b1) to calculate includes: (b1a) means to calculate a total number of large objects (LOBs) being used and stored in each Tank file; (b1b) means to calculate a percentage of available space in each Tank file, involving a number of deleted large objects (LOBs); (b1c) means to calculate, for each Tank file, the number of deleted large objects (LOBs); (b1d) means to calculate, for each Tank file, the number of deleted large objects (LOBs) which reside adjacent to each other in a Tank file; (b1e) means to calculate, for each Tank file, a total number of kilobytes available for storage; (b1f) means to calculate a percentage of spaces, in each Tank file, which is available for re-use; and (b1g) means to calculate a total amount of used space, the total amount of used space being calculated by multiplying a last key number in each Tank file with a record size of each record in the Tank file.
2. The system of claim 1 which further includes: (c) means to provide a visual report on a metrics involved showing a capacity status for each Tank file.