(SP39) Writer Settings

Writer settings are incorporated into OutBoard settings, which can be accessed via OutBoard Cockpit. It can be started using transaction /DVD/OUTBOARD.

_{OutBoard Cockpit with the settings button}

_{OutBoard settings in OutBoard NLS with Storage Management}

Switch Check for Full Load On/Off

Parameter WRITER_CHECK_FULL_LOAD is used for InfoCube load and DSO Request activation. If this parameter has 'X', then all full loads are processed, i.e. writer functionality is off. However, there is an exception table '/DVD/NLS_W2_LOAD'. In the field 'DATA_LOAD' can be stored the technical names of DTPs or InfoPackages, which will be processed by Writer.

Switching on/off NLS Writer

NLS Writer can be switched on/off for specific InfoProvider types via the OutBoard settings. Parameters for customizing are WRITER_ENABLED_FOR_CUBE and WRITER_ENABLED_FOR_ODSO. When a user disables the NLS Writer, SAP functionality works as standard.
Maximum number of buffered packages
Parameter WRITER_MAX_BUFFERED_PACKAGES is relevant only for the DSO activation process. This parameter regulates the maximum number of buffered packages in memory. If the number is set to a "very high" figure, depending on hardware performance, this may cause a "MEMORY_LOW" short dump. Packages are kept in memory because of performance reasons, it is recommended that one package should be approx. 100MB, i.e. 10 packages will use 1GB of memory.

Maximum number of records in the package for inserted data (DSO Activation)

Parameter WRITER_ODSO_MAX_PACK_ROWS is used for DSO Request activation. This parameter sets the maximum number of rows, which can be inserted into an archiving package. This setting is taken into account only when new data should be inserted in the archive.

Max. Number of Jobs for repair functionality

Parameter WRITER_ODSO_MAX_REP_JOBS is connected with report '/DVD/NLS_W2_CHECK_DSO'. This parameter sets the maximum number of background jobs that will be used for moving locked data from an active table to the archive. Note: The minimum number of jobs is two.

Max. Number of records processed by Writer (DSO Activation)

Parameter WRITER_ODSO_MAX_RECORDS is used for DSO Request activation. This parameter sets the maximum number of locked records, which will be processed using the writer. For cases where more records should be processed, writer processing will be skipped, and a warning will appear. If this happens the user should increase the maximum number of records. However, this may affect the performance of the system.

Rebuild OutBoard Aggregates if data in the archive was updated

Parameter WRITER_REBUILD_AGGREGATES is used for InfoCube load and ODS Request activation. If the parameter is set to 'X', then the Writer will rebuild all OutBoard Aggregates, which are connected to the affected InfoProvider (DTP).

Select data from transparent storage with statement FOR ALL ENTRIES

Parameter WRITER_SYB_FOR_ALL_ENTRIES is used for ODS Request activation. If the parameter is set to 'X', then for any transparent storage the Writer will select data from the NLS archive directly from the transparent storage table with the statement SELECT… FOR ALL ENTRIES.

Insert data into SAP Sybase IQ directly

Parameter WRITER_SYB_UPDATE_DIRECTLY is used with transparent Sybase IQ storage for direct storage access row-by-row in inserting/updating/deleting from archive resulting in shorter processing times.

InfoPackage Template

Parameter WRITER_3X_GEN_REP_TEMPLATE stores the template which is used to generate transfer rule with writer functionality, to load data into InfoCubes. There are following options for this parameter: /DVD/NLS_W2_3XTMPL_701_0014, /DVD/NLS_W2_3XTMPL_730_0008, /DVD/NLS_W2_3XTMPL_740_0010 and /DVD/NLS_W2_3XTMPL_750_0009.

Backup of currently processed package

Parameter WRITER_BACKUP_PACKAGE (default set to 'X') is relevant for transparent storage processing. This functionality is present to secure transactional processing, where NLS WRITER executes the update as a standalone delete/insert statement. Would processing be terminated exactly between these two actions, a possibility of uncommitted data could lead to data loss. Therefore all packages are backed up prior to processing and dropped right afterward if the execution went without error or interruption.

NLS Writer verification phase

Parameter WRITER_VERIFICATION (default set to '' (space)) provides an additional check on the processing of data. If set to 'C', NLS Writer recounts records written into the database after every package. If numbers are not equal, NLS Writer produces an exception, and the user is notified of an error in processing.

_{Accessing Writer Settings}

InfoProvider must be set as Default to access the Writer Settings in OutBoard NLS.

_{Writer setting in OutBoard NLS}

Automatic request reload

Parameter WRITER_AUTO_RELOAD_EMPTY_REQ (default set to 'X') enables automatic reload functionality. At the beginning of a DTP load to cube / DSO activation, empty archiving requests are reloaded. Data, therefore, stays in the active table, in the post-processing, new archiving requests are created with the same archiving condition. InfoCube has to have an archiving of non-compressed data allowed during DAP creation. Empty requests to be reloaded have to be in state 70. If any of the archiving requests is in a lower state, automatic reload functionality is unavailable. Automatic request reload – Maximum number of rows

Automatic request reload - Maximum number of rows

Parameter WRITER_AUTO_RELOAD_THRESHOLD (default set to '0') sets the maximum number of rows for creating a new archiving request in post-processing. In the case of an archiving request having more rows than the set value, a new archiving request has to be created manually. (default set to '0') sets the maximum number of rows for creating a new archiving request in post-processing. In the case of an archiving request having more rows than the set value, a new archiving request has to be created manually.