REPOS DELETE statement
REPOS DELETE directs BMC AMI Log Master to delete rows from one or more of the following tables within the Repository:
- Old Objects Table (ALPOLDO, used for overtime processing)
- Open Unit of Recovery table (ALPURID, used for ongoing processing)
- SYSCOPY record table (ALPSYSCP, used for completion processing)
- HISTORY work file tables (ALPSQLF, ALPRPTF, ALPLODF, ALPDDLF, ALPCMDF, ALPADRF, ALPLOGF, ALPWHIS, ALPWLSH)
Depending on your environment and the settings that you use to update the Repository, the size of the tables can increase more rapidly than the other tables. Use REPOS DELETE to reduce the size of only these tables.
Be aware of the following points about the REPOS DELETE keyword:
- When you specify REPOS DELETE, the scan range definition of the LOGSCAN statement is not required because BMC AMI Log Master does not read the Db2 log to delete Repository rows.
- You can specify one or more of the following keywords in the same log scan and specify multiple repository delete objects:
- OVERTIME
- ONGOING
- SYSCOPY
- HISTORY
You can generate JCL to delete rows from selected Repository tables by using the Generate REPOS DELETE JCL option on the Main Menu of the
- BMC AMI Log Master online interface.
- You can also delete or display information from ALPOLDO and ALPURID Repository tables directly through the BMC AMI Log Master online interface, without using JCL. Use the Delete/Display Repository Tables option on the Main Menu.
- Work ID specification is required for ONGOING or HISTORY repository deletion.
- Either DBNAME or TSNAME specification is required for SYSCOPY repository deletion.
- DBNAME, TSNAME, or TBNAME specification is required for OVERTIME repository deletion.
Select from the following values:
Option | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
REPORT ONLY | Directs BMC AMI Log Master to report only the number of the qualified rows for each specified repository table. No records are deleted. | ||||||||
OVERTIME | (default) Directs BMC AMI Log Master to delete rows from the Old Objects Table of the Repository (ALPOLDO) BMC AMI Log Master uses this table during overtime processing. Rows in this table represent either compression dictionaries or instances of objects that might have been dropped or dropped and re-created. This is the default value. | ||||||||
ONGOING | Directs BMC AMI Log Master to delete rows from the Open Unit of Recovery table of the Repository (ALPURID) BMC AMI Log Master uses this table for ongoing processing. Rows in this table contain information about transactions (units of recovery) that were open at the end of a previous ongoing log scan and that BMC AMI Log Master stored for later processing. | ||||||||
HISTORY | Directs BMC AMI Log Master to delete rows from work output or file pointer tables BMC AMI Log Master saves the results of a work ID in the Repository. The results include both the final status of the work ID and pointers to the various files generated as the work ID runs. These files include logical log files, SQL files, load files, report files, DDL files, command files, and drop recovery files. | ||||||||
SYSCOPY | Directs BMC AMI Log Master to delete rows from the SYSCOPY Repository table (ALPSYSCP) | ||||||||
WORKID | Directs BMC AMI Log Master to delete only the ALPURID or HISTORY table rows that relate to a work ID (or set of work IDs) that you specify To specify a set of work IDs, use wildcard characters to define a string pattern for either the userID, the workID, or both parts of the work ID name. BMC AMI Log Master deletes rows in the Repository table or tables that contain work IDs that match your string pattern. Use the same wildcard characters that you use when selecting log records. For more information, see WORKID-statement. To specify multiple sets of work IDs, include an additional log scan in your job or job step (with an additional REPOS DELETE keyword). The WORKID option is required for ONGOING and HISTORY tables. | ||||||||
DBNAME | Directs BMC AMI Log Master to delete OVERTIME, SYSCOPY or both kind of rows related to the database or databases. To specify a set of databases, use wildcard characters to define a string pattern for database names. You can specify the DBNAME clause only once. The DBNAME, TSNAME, and TBNAME options are mutually exclusive The DBNAME option is valid only for OVERTIME and SYSCOPY tables. | ||||||||
TSNAME | Directs BMC AMI Log Master to delete OVERTIME, SYSCOPY or both kind of rows related to the table space or spaces. TSNAME consists of databaseName.tablespaceName. The default database name is DSNDB04. To specify a set of table spaces, use wildcard characters to define a string pattern for the database name, table space name, or both parts of the clause. You can specify the TSNAME clause only once. The DBNAME, TSNAME, and TBNAME options are mutually exclusive The TSNAME option is valid only for OVERTIME and SYSCOPY tables. | ||||||||
TBNAME | Directs BMC AMI Log Master to delete OVERTIME rows related to the table. TBNAME consists of tableOwner.tableName. The default table owner is the user ID who runs the job. To specify a set of tables, use wildcard characters to define a string pattern for either database name, table space name, or both parts of TBNAME. You can use the IN databaseName.tablespaceName option to identify the database and table space in which the table is located. You can specify the TBNAME clause only once. The DBNAME, TSNAME, and TBNAME options are mutually exclusive The TBNAME option is valid only for OVERTIME tables. | ||||||||
RECORD TYPE | Directs BMC AMI Log Master to delete OVERTIME rows based on the Db2 object types. The following values are valid:
| ||||||||
ALL | Directs BMC AMI Log Master to delete all rows from the Repository tables that you specify | ||||||||
AGE (numOfDays) | Directs BMC AMI Log Master to delete rows from your specified Repository tables that are older than a specified number of days Enter a number of days between 1 and 32,767. | ||||||||
RBA | LRSN X 'byteString' | Directs BMC AMI Log Master to delete rows from your specified Repository tables that were created before a specific RBA/LRSN The byte string can be up to 12 characters long. For extended RBAs/LRSNs, it can be up to 20 characters long. Use the following format: RBA X'nnnnnnnnnnnn'. | ||||||||
DATE (MM/DD/YY) | Directs BMC AMI Log Master to delete rows from your specified Repository tables that were created before a specified date Enter a date using one of the available formats, including:
| ||||||||
BEFORE OLDEST ARCHIVE | Directs BMC AMI Log Master to delete rows from your specified Repository tables that were created before the starting timestamp value of the oldest archive log file defined in the bootstrap data set (BSDS) of the current Db2 subsystem |
You must specify a value for the row deletion criteria (ALL, AGE, RBA | LRSN, DATE, or BEFORE OLDEST ARCHIVE).