Did you already know?

The database should be reorganized regularly to ensure smooth operation of the DCW software. In the past, we have repeatedly found that customers do not carry out the reorganization, which then makes it more difficult to provide support, for example.

What does the reorganization do?

DCW works according to the principle of asynchronous processing, i.e. all transactions that you carry out (postings, master data changes, etc.) are written to so-called log files, then processed by the asynchronous jobs one after the other and finally marked as “processed” or as “incorrect”, which you will then find in the “File”. Reorganization deletes the successfully processed records in the log files in order to reduce the data volume. In addition, the files that assign document and other numbers are cleaned up.  

What must be taken into account during reorganization?

In order for the log files to be reorganized, the asynchronous jobs must be terminated. This means that no one should be working in DCW during the reorganization.

How often should the reorganization run?

We recommend performing the reorganization weekly as part of the overall backup.

What should the routine for the backup and reorganization look like?

We recommend a CL program with the following steps:

CALL ZASPENDA	Terminates all asynchronous jobs
ENDSBS SBS(DCWASP) DELAY(10)	Terminates the DCWASP subsystem after 10 seconds
SAVLIB LIB(DCWD DCWP…	Securing the DCW libraries
RGZDCWDB DTALIB(DCWD)   ASYNSTR(*YES or *NO)	Reorganization with or without subsequent start of the asynchronous jobs
CALL ZASPAUTO	Starts the asynchronous jobs

What else is there to know about this topic?

In addition to the log files, there is a second group of files that should be cleaned up regularly: The interface files. These are used to transfer data from external systems to DCW, e.g. bookings or master data. As these files are generally the responsibility of the customer, they are also responsible for the reorganization. However, the DCW team is happy to provide advice and assistance.

Please do not hesitate to contact us regarding the reorganization of your DCW database.