Reorganization take a lot of time on u_fmsb50 file

Document ID : KB000086156
Last Modified Date : 25/05/2018
Show Technical Document Details
Issue:
Affects Release version(s): 5

Error Message :
N/A

Patch level detected:Dollar Universe 5.6
Product Version: Dollar.Universe 5.6.0 FX25010

Description :The size of u_fmsb50.dta file is important and it cause a long reorganization time.
Environment:
OS: All
Cause:
Cause type:
Defect
Root Cause: Some SBSESS records are not purged from u_fmsb50.dta.
Resolution:
The FX25028 is a hotfix which require the FX25010 cumulative patch.
It deliver the uxpursbsess maintenance utility that can be used to purge SBSESS records in the u_fmsb50 file.

Please note that this maintenance utility is not audit-trailed and that DUAS security does not apply to it. It is recommended to reserve its usage to DUAS administrators.
This utility will purge SBSESS records in the u_fmsb50 file based on a date criteria; every record which was lastly modified at a date anterior to the criteria will be purged, providing the corresponding session header launch record is no more present in the u_fmsb50 file (session header corresponding to the SBSESS record, correspondance being given by session number).

A FORCE mode can be used optionnally to purge only based on the date criteria (i.e. check on the matching session header will not be performed).
Please note that by default the utility only lists the records that will be purged if the PURGE option was used when launching the utility with the same options.

The uxpursbsess syntax is:

uxpursbsess X|A|I|S YYYYMMDD (PURGE) (FORCE) (DEBUG)
where:
COMPANY is the company name of the node to target (mandatory)
X|A|I|S is the area to target (mandatory)
NODENAME is the node name of the node to target (mandatory)
YYYYMMDD is the date criteria (format must be respected) (mandatory)
PURGE sets the utility in PURGE mode instead of LIST mode (optional)
FORCE sets the purge criteria to only be on the date (optional)
DEBUG sets the utility in DEBUG mode (optional)

Fix Status: Released

Fix Version(s):
Component: Application.Server
Version: Dollar.Universe 5.6.0 FX25028