跳转至

Set up and configure housekeeping jobs(设置与配置维护作业(housekeeping jobs))

Housekeeping jobs are used to delete log table data that was created before a specified point in time and to close unconfirmed requests and drop subscriptions that are not in use for a certain period of time.

To open the housekeeping settings, use transaction code /n/PALANTIR/COCKPIT_03.

Deleting Log Tables

The Deleting Log Tables checkbox should be left checked by default to prevent log tables from growing indefinitely and potentially filling all available disk space.

When enabled, the program will delete records from tables /PALANTIR/LOG_02 and /PALANTIR/PAG_02. The program also deletes records from the /PALANTIR/LOG_01 table but does not delete initialization requests in this table. For more, see Deleting LOG_01 Table with INIT Requests below.

  • Logs created older than (days) and Data interval (days): These settings should be used together to define a rolling time window for deleting log records. The default settings are 30 days and 10 days, respectively, meaning that when the job runs, any records between 30 days and 40 (= 30 + 10) days old will be deleted.
  • Only if Data is in Foundry: This indicates that only page files that are confirmed to have been transferred to Foundry will be deleted.

Closing SLT Request for Cancelled SLT Syncs

The Close SLT Requests checkbox should be unchecked by default. Palantir Support may ask for it to be checked to address a known SLT issue that can cause the system to hang due to too many requests in the ODQDATA table.

When enabled, the program finds the SLT subscription requests that were created in the given date range and uses SLT close functionality to change the ODQMON status of the request to Completed. When a request is set to Completed in ODQMON, it can be deleted by the delta queue cleaning job of ODQMON.

  • Date range for SLT requests: SLT delta requests created in this date interval will be set to Completed in ODQMON.

Resetting SLT Pointer for Unused Subscription

The Drop SLT Subscriptions checkbox should be unchecked by default. Palantir Support may ask for it to be checked to address a known SLT issue that can cause the system to hang due to too many requests in the ODQDATA table.

When enabled, the program will drop historical ODQMON subscriptions.

  • Last request older than (days): Indicates that subscriptions older than this number of days will be dropped.

Deleting LOG_01 Table with INIT Requests

The Delete LOG_01 INIT Requests checkbox should be unchecked by default. Palantir Support may ask for it to be checked to address rare cases when the /PALANTIR/LOG_01 table grows too large.

When enabled, this program deletes the /PALANTIR/LOG_01 table data, including initialization requests.

  • Logs created older than (days): Indicates that records older than this number of days will be deleted. The default value is 30 days, which means that all data created more than 30 days ago will be deleted from /PALANTIR/LOG_01.

中文翻译

设置与配置维护作业(housekeeping jobs)

维护作业用于删除指定时间点之前创建的日志表数据,以及关闭未确认的请求并删除长时间未使用的订阅。

要打开维护设置,请使用事务代码 /n/PALANTIR/COCKPIT_03

删除日志表(Deleting Log Tables)

删除日志表(Deleting Log Tables) 复选框默认应保持选中状态,以防止日志表无限增长并可能占满所有可用磁盘空间。

启用后,程序将删除表 /PALANTIR/LOG_02/PALANTIR/PAG_02 中的记录。该程序还会删除 /PALANTIR/LOG_01 表中的记录,但不会删除该表中的初始化请求。更多信息,请参见下文删除包含INIT请求的LOG_01表

  • 日志创建时间超过(天数)数据间隔(天数): 这两个设置应配合使用,以定义删除日志记录的滚动时间窗口。默认设置分别为30天和10天,这意味着当作业运行时,将删除创建时间在30天到40(= 30 + 10)天之间的所有记录。
  • 仅当数据在Foundry中时(Only if Data is in Foundry): 表示仅删除已确认传输到Foundry的页面文件。

关闭已取消SLT同步的SLT请求(Closing SLT Request for Cancelled SLT Syncs)

关闭SLT请求(Close SLT Requests) 复选框默认应保持未选中状态。Palantir支持人员可能会要求选中此复选框,以解决已知的SLT问题,该问题可能导致系统因ODQDATA表中请求过多而挂起。

启用后,程序会查找在指定日期范围内创建的SLT订阅请求,并使用SLT关闭功能将ODQMON中该请求的状态更改为已完成(Completed)。当请求在ODQMON中被设置为已完成(Completed)后,即可由ODQMON的增量队列清理作业删除。

  • SLT请求的日期范围(Date range for SLT requests): 在此日期区间内创建的SLT增量请求将在ODQMON中被设置为已完成(Completed)

重置未使用订阅的SLT指针(Resetting SLT Pointer for Unused Subscription)

删除SLT订阅(Drop SLT Subscriptions) 复选框默认应保持未选中状态。Palantir支持人员可能会要求选中此复选框,以解决已知的SLT问题,该问题可能导致系统因ODQDATA表中请求过多而挂起。

启用后,程序将删除历史ODQMON订阅。

  • 上次请求超过(天数)(Last request older than (days)): 表示将删除超过此天数的订阅。

删除包含INIT请求的LOG_01表(Deleting LOG_01 Table with INIT Requests)

删除LOG_01 INIT请求(Delete LOG_01 INIT Requests) 复选框默认应保持未选中状态。Palantir支持人员可能会要求选中此复选框,以解决/PALANTIR/LOG_01表增长过大的罕见情况。

启用后,此程序将删除/PALANTIR/LOG_01表数据,包括初始化请求。

  • 日志创建时间超过(天数)(Logs created older than (days)): 表示将删除超过此天数的记录。默认值为30天,这意味着所有创建时间超过30天的数据都将从/PALANTIR/LOG_01中删除。