Query and Transaction parameters: Maintain Timeout and other settings centrally

Use the following Winshuttle parameters to maintain some features of Query and Transaction centrally.

• F4NSP_TIMEOUT: Value in seconds timeout for F4, number of entries, preview, search from Windows Query application. Example: 300 for 5 min. If the seconds value is empty or 0, there is no central timeout control for F4, number of entries, preview, and search.
• QUERY_TIMEOUT: Value in seconds timeout query execution from Windows Query application. Example: 300 for 5 min. If the seconds value is empty or 0, there is no central timeout control.
• TIME_SYNC_FREQ: KILLTIMEOUT will be checked every TIME_SYNC_FREQ; default value is 5 seconds if not maintained.

  This is the least frequency in seconds used to sync with the current server time during processing.

• CHUNK_FACTOR: Default value is 15 if not maintained.

  (It is twice the maximum average number of users that may use the Query client application for multiple-table queries.)

  This value in no way restricts or limits the users.

  The value is used only to compute the internal parallel data compression capacity for intermediate processing results in multiple-table queries that are run in Adaptive Query Throttling mode.

  This chunk factor is used internally to increase the data processing capacity by 10 times on average.

• CHUNK_DEL_SIZE: While monitoring, ideal size of the data which is required to be deleted; default value = 50 MB
• DAYS_OLD_CHUNKS: Default value is 10 (days) if not maintained.

  The value defines the number of days until the orphaned Winshuttle Query buffer chunks will be removed. Normally the chunk buffer is cleared as soon as the query runs. In extreme cases, these buffer chunks still exist and will be cleared after this cut-off duration.

• OLDCHUNKS: Default value is blank (or not maintained).

  (For Winshuttle internal use only, related to orphaned chunks.)

  If a record exists with value X then exit, else check older chunks (prior to version 10.2).

• FREQCHUNKMON: Default value is 60 (seconds) and minimum value is also 60. The value is maintained in seconds. The monitoring is done at this frequency for orphaned chunks.
• AQT_ENFORCE: Default value is blank, or empty, which means that the AQT setting that is saved with the Query script is respected.

  If the value is X, AQT is enforced regardless of the setting that is saved with the Query script.

• CUSTOMAUTHPRG: This functionality allows a Winshuttle Query user to build custom authorization check logic. The custom logic decides whether access to a table is allowed or not for the logged-on SAP user.

  The custom authorization check will work in addition to the security table entries that are defined.

  This feature is optional. You are not required to create this in your SAP system.