Authorizations

Authorizations concept in SNP OutBoard™ Housekeeping is based on authorization object /DVD/ERNA. It contains the following authorization fields:

• /DVD/FSGRPhousekeeping task group, validated with /DVD/FS_TASKGRP table
• /DVD/FSTSKname of housekeeping task, validated with /DVD/FS_TASK table
• /DVD/FSACTaction for authorization object, validated with TACT table

It enables to set up of permissions in detail for the activities for a specific task. How-to about setting the authorizations is in Appendix B.

SNP OutBoard™ Housekeeping Global Settings

The settings that control the broader part of SNP OutBoard™ Housekeeping's behavior, are collated within the SNP OutBoard™ Housekeeping global settings screen.

_{SNP OutBoard™ Housekeeping Settings}

SNP OutBoard™ Housekeeping global settings have several tabs: General Settings, System Specific, Task-Specific, User-Specific, and Settings Editor.

General Settings tab

_{SNP OutBoard™ Housekeeping Global Settings – screen}

"Central scheduler" allows (in Edit mode) the user to modify the Scheduler period and information about the next central scheduler run. If the user has the proper authorizations, they may start/stop the central scheduler run. When clicking on the Start button, the user can select if the central scheduler starts immediately or at a specific date/time in the future. If the scheduler is running, first this needs to be stopped to enable the Start button functionality.

_{SNP OutBoard™ Housekeeping Global Settings – central scheduler properties}

Optional "Scheduler user" can be entered to specify a username used for scheduling the tasks. If there is no username selected, the current user is used for background scheduling. Our recommendation is that the selected username is dedicated for scheduling, with an appropriate role /DVD/ERNA_USER (see details in SNP OutBoard™ Housekeeping User role chapter), validity period and it is not assigned to any person. Thus it is independent of any personal changes (company leaves, user locking).
Another parameter that can be changed on the General Settings tab under Advanced Settings, is RFC check timeout: it defines how long SNP OutBoard™ Housekeeping waits for remote systems to respond while checking the sanity of the system.

System Specific tab

_{SNP OutBoard™ Housekeeping Global Settings – System Specific tab}

In the system-specific settings, the user can select specific systems and change the data class where the RecycleBin cluster table is placed. Under the data class selection is possible to select custom data classes on the satellite systems via a list box.
Note: Before executing this action, the RecycleBin must be empty! When a tablespace is changed, Recycle bin table is dropped.

Task-Specific tab

_{SNP OutBoard™ Housekeeping Global Settings – Task Specific tab}

Based on the task type, the user can set up Prefixes for automated task settings generation. These are analysis tasks, that can prepare settings for follow-up tasks; giving the user option to define prefixes for settings IDs.

Archiving task deletion phase – the archiving process has at least two main phases (Write and Deletion phase) that are running independently. The user can specify for any archiving task whether the deletion phase will follow immediately after the execution of the write phase. When there is an archiving session that is incomplete, all subsequent executions of some of the archiving objects would fail. As a result, you now have the possibility to mark complete these previous incomplete sessions prior to the creation of a new session by using the 'Complete incomplete sessions' option.

The default value is 'X' for all tasks.

User Specific tab

_{SNP OutBoard™ Housekeeping Global Settings – User Specific tab}

"Activity profile" enables the user to select which profile will be active when SNP OutBoard™ Housekeeping starts.

Settings Editor tab

_{SNP OutBoard™ Housekeeping Global Settings – Settings Editor tab}

In the Settings Editor, the user can change the settings parameter values directly. After selecting the parameter, there is also an option to set to default value using the "Reset to defaults" button. Custom values are a different color (red) than the default color (black).
The following parameter values can be changed:

APPLOG_USE_COMMIT_WORK: Flag to commit work in application logs deletion after each package is processed; the default value is space.
CCPR_SETTINGS_CREATE_PREFIX: Can be changed also on the Task-Specific tab for task Cube Compression; the default value is "$CCPR".
CCPR_USE_TH: Flag for enabling Task handler functionality for task Cube Compression; the default value is "X".
CHLG_DEL_OPTIMIZATION: Optimized_deletion_flag for task Changelog Cleanup; the default value is "X".
CHLOG_USE_TH: Flag for enabling Task handler functionality for task Changelog Cleanup; the default value is "X"
DAEMON_PERIOD: Can also be changed in the General Settings tab as the Scheduler period parameter; the default value is 60.
DAEMON_USER: Scheduler user, see General Settings.
EDIT_DEFAULT_SETTINGS_IDS: Flag that enables editing default (starts with prefix _*) settings; the default value is space.
OBJ_SEL_SCREEN_TRESHOLD: Threshold for RecycleBin browser object selection, for actions like undoing, deleting, etc.; the default value is 30.
PSA_CHLOG_SEL_REQUESTS_LIMIT: Maximum number of requests in WHERE condition for tasks PSA Cleanup and Changelog Cleanup; the default value is 100.
PSA_CHLOG_TH_DATA_AMOUNT: Amount of data (row count) that can be processed in single Task handler job for tasks PSA Cleanup and Changelog Cleanup; the default value is 250 000.
PSA_DEL_OPTIMIZATION: Optimized_deletion flag for_PSA_Cleanup; default value is "X".
PSA_USE_TH: Flag for enabling Task handler functionality for task PSA Cleanup; the default value is "X".
RECBIN_BUFFER_SIZE: Buffer size of RecycleBin; the default value is 50,000 records
RECBIN_CLEANUP_JOBS: Number of jobs that can be used for the recycle bin deletion; the default value is 1.
RECBIN_DEL_D_MERGE_ENABLED: Flag for enabling the recycle bin functionality of delta merge; the default value is space.
RECBIN_DEL_D_MERGE_LIMIT: Recycle bin deletion phase limit for delta merge of Hana systems; the default value is 1,000,000 records.
RECBIN_PACKAGE_SIZE: Package size of the recycle bin; the default value is 50,000 records.
RECBIN_TABLE_DEL_REFR_TIME: Resource check refresh time (seconds); the default value is 0.100.
RECBIN_TABLE_DEL_WAIT_ATT: Maximum number of cycles to get a resource; the default value is 1440.
RECBIN_UNDO_D_MERGE_ENABLED: Flag for enabling the recycle bin reload functionality of delta merge; the default value is space.
RECBIN_UNDO_D_MERGE_LIMIT: Recycle bin reload limit for delta merge of Hana systems; the default value is 1,000,000 records.
RECBIN_UNDO_INSERT: Use INSERT for recycle bin reload functionality; the default value is "X".
RECBIN_UNDO_WP_MAX: Number of parallel jobs for recycle bin reload functionality; the default value is 5.
REPLICATE_SETTINGS_TO_VARIANT: Enable replication Settings ID to execution variants that are needed for external scheduler support; the default value is space.
RFC_CHECK_TIMEOUT_SECONDS: It can be changed also in the General Settings tab; the default value is 2.
SARA_DEL_PHASE_MAX_JOBS: Maximum number of the jobs for SARA tasks; the default value is 1.
SARA_DEL_PHASE_SESSIONS: Maximum number of sessions for SARA tasks; the default value is 10.
TEMSE_ADDITIONAL_LOGS: Activation of additional logs for task TemSe object cleanup; the default value is " ".
TEMSE_CLEANUP_SETTINGS_PREFIX: Can also be changed under the Task-Specific tab for task TemSe Objects Cleanup; the default value is "$TEMSE".
TEMSE_DO_NOT_USE_CURSOR: Execution of task TemSe object cleanup without using a cursor; the default value is "X".
VARSET_CUSTOM_NAME: Select your own variant name in SAP standard tasks settings by using the value "X"; the default value is " ".
USR_CALENDAR_PERIOD: Value of this variable will be changed automatically to the last selected one in the calendar; allowed values: “D” – day; “W”- week; “M” – Month.
USR_DATE_RANGE_SELECTION: Default filter value for Monitor and Recycle bin. The value of this variable will be changed automatically to the last selected one in the calendar; allowed values: “T“– day, „Y“– Yesterday and Today, „W“– One week ago, „M“– This month and last month

Workbench Logs

The Workbench logs button is found in both the SNP OutBoard™ Housekeeping System and the Activity view. This allows the user to check events that were launched from the SNP OutBoard™ Housekeeping cockpit (i.e. entering the RecycleBin screen, executing the task from the foreground, etc.).

_{Workbench Logs}

Housekeeping Report

One of the common services SNP OutBoard™ Housekeeping cockpit offers is the housekeeping report. It is accessible from the Goto  Show Report menu. It summarizes information about task runs – short task description, number of runs, and total volume savings for an individual system.

_{Housekeeping report}

History statistics analysis
SNP OutBoard™ Housekeeping is collecting statistics about saved space for each run ID, particularly table and system level. Now high-level information on how much data was cleaned/saved in total is provided for a user to analyze the history.

_{Show statistics in the system view}

From the context menu choose the landscape you want to show the statistics on. The higher the selection in the hierarchy is situated (i.e. landscapes), the more options are available during the selection in the statistics report.
The selection group can be specified by task, system, and date. Date selection allows displaying subtotals and filters statistics by specific period selection. This task can be organized by its group or name. Press Display after filling selections.
The task can be organized by its group or name. Press Display after filling selections.
Results can be organized hierarchically and exported into overviews.

_{Statistics report overview}

Table Browser

To view which tables are impacted by the SNP OutBoard™ Housekeeping's housekeeping tasks, the user could navigate to the Table Browser, which can be found under Goto.

_{Navigating to view table browser}

In the Table Browser the user can search via tasks or tables:

• Search Tables: The user should define the Task Group (Basis, BW, ERP, and CRM, etc.) and the SNP OutBoard™ Housekeeping task (activity), by doing so; the user will see which table(s) will be amended when the Housekeeping Task is performed. If the table exists in the Central system, by clicking the table content button, the user will be redirected to the SE16 transaction for the selected table.
• Search Tasks: The user should enter a table name, for the table to be amended by any of the SNP OutBoard™ Housekeeping Tasks (Activities), and the corresponding Housekeeping tasks will be displayed. By clicking on the Info button, the documentation regarding the selected task will be shown. In addition, by clicking the navigation button on the line for a selected task, the task browser screen will close, the cockpit switches to an activity view, the activity profile is switched to "ALL" and the task found in the task browser is focused.

             _{Table Browser view}

Support for External Scheduler

SNP OutBoard™ Housekeeping supports external schedulers as Redwood, UC/4, Batch man, etc. This is achieved through the envelope report mechanism and can be used to launch SNP OutBoard™ Housekeeping tasks with a selected variant.

Step list

As prerequisites, it is necessary for Global settings to set the value of variable REPLICATE_SETTINGS_TO_VARIANT to "X".
As the next step, go to the settings, which should be used by an external scheduler, and save them. Those settings will be automatically copied to the variant with the same name as Settings ID. That means if the external scheduler will be in use, none of the settings can have the same name. In case the variant already exists within the system with the same name, there will be a message shown.
Variants are created for program /DVD/FS_EXEC_TASK. Afterward, it is necessary to move the variant from the Central system to the target system and run the report /DVD/FS_EXEC_TASK with this variant.

Warning:
SNP OutBoard™ Housekeeping Central system and the external scheduler must be in the same system!