Log Master Repository tables
The headings include the abbreviated name in parentheses (for example, ALPADRF). The actual names of the Repository tables in DB2 are determined when the product is installed. The default DB2 table names use this format:
In this format xxxxxxx represents the abbreviated name.
|Table name (short name)||Description|
|Automated drop recovery file table (ALPADRF)|
This table records the output files created as part of a drop recovery job step.
|Column list table (ALPCOLS)||This list corresponds to the Column Include/Exclude Definition (for more information, see LOGSCAN column include/exclude definition).|
|Command file pointer table (ALPCMDF)||This table contains a row for each command file generated.|
|DDL file pointer table (ALPDDLF)|
This table contains a row for each data definition language (DDL) file generated.
|Dropped objects table (ALPDRLN)|
This table contains a row for each database object that is the target of a drop recovery job step.
|Filter header table (ALPFLTH)|
This table contains a row for every filter defined. The row defines general information about the filter.
|Filter line table (ALPFLIN)|
This table contains rows that define the individual log selection criteria of a filter.
|Filter pointer table (ALPFLTP)|
This table contains rows that refer to (point to) the filters used with a work ID step.
|Load file pointer table (ALPLODF)|
This table contains one row for each load file generated by the product.
|Logical log file pointer table (ALPLOGF)|
This table contains one row for each logical log file generated by the product.
|Mark table (ALPMARK)|
This table contains one row for each log mark defined using the product.
|Old objects table (ALPOLDO)|
Log Master uses the information in this table to interpret and process log records that relate to database objects not currently defined in the DB2 catalog.
|Open unit of recovery table (ALPURID)|
This table contains information about the ongoing jobs run by the product.
|Report file pointer table (ALPRPTF)|
This table contains one row for each report file generated by a given log scan step.
|Report template table (ALPRTMPL)|
This table contains at least one row for each report template that the product stores in the Repository. When required, the product uses multiple rows to store templates.
|Security exception history table (ALPSECH)|
This table contains a row for each occasion when a Log Master job attempted to access DB2 data, but encountered security exceptions.
|SQL codes handler table (ALPSQLC)|
This table contains information that Log Master uses to respond to SQL codes as it executes generated SQL.
|SQL file pointer table (ALPSQLF)|
This table contains a row for each SQL file generated by the product.
|SQL index table (ALPIXSQ)||This table contains a row for each alternate index defined within a given work ID. The product uses alternate indexes as it generates SQL statements.|
|SQL name translation table (ALPSQLX)|
This table contains SQL translation (SQLXLAT) informat ion about database objects. The product uses this information as it generates SQL and during a drop recovery action.
Syscopy records table (ALPSYSCP)
Log Master uses the information in this table to plan for compression, completion, and version processing, including records for image copies and RID changing events that can no longer be found in the DB2catalog. For more information about using this table, see REPOS UPDATE in LOGSCAN statement.
|Work ID header table (ALPWHDR)|
This table contains a row for each defined work ID.
|Work ID history table (ALPWHIS)|
This table contains a row for each run of a work ID.
|Work ID input file definitions table (ALPIFIL)|
This table contains a row for each file defined as input to a work ID step.
|Work ID log scan history table (ALPWLSH)|
The product creates and maintains a row in this table each time it runs a log scan.
|Work ID output file definitions table (ALPOFIL)|
This table contains a row for each output file that the product produces as it processes a log scan step or SQL execution step.
|Work ID Step Table (ALPWSTP)|
This table contains a row for each step define d within each work ID.