| Topic | Detail | Date |
| Foreign key | A foreign key identifies a related row in another table and establishes a logical relationship between rows in the two tables. | |
| Dsntiar | This is the IBM supplied program which formats the SQL error codes in text message. It is commonly used in error processing routines | |
| RCT | Entry defined in CICS which ties the CICS transaction to the DB2 plan | Wednesday, January 18, 2006, 15:45 +05:30 |
| Runstats | The RUNSTATS utility collects statistics about DB2 objects. These statistics can be stored in the DB2 catalog, and are used during the bind process to choose the path in accessing data. If you never use RUNSTATS and subsequently rebind your packages or plans, DB2 will not have the information it needs to choose the most efficient access path. This can result in unnecessary I/O operations and excessive processor consumption | Wednesday, January 18, 2006, 15:45 +05:30 |
| Cardinality | This is the number of unique values for a columns. Columns with low cardinality are not good candidates for indexing. Sometimes columns are concatenated together to use as indexes because used alone the optimizer would not elect to use the index | Wednesday, January 18, 2006, 15:46 +05:30 |
| SPUFI | Sequential Processing Using File Input | Wednesday, January 18, 2006, 15:47 +05:30 |