Produmex offers the option to manually archive data from closed documents in order to decrease database size and improve system performance.

The archiving process moves the selected data from closed documents into other tables in the same database or into a separate database, based on the configuration Archive databases and tables can be distinguished by the ‘_AR’ suffix in their name.

It is recommended to make a backup of the DB before doing the Archiving.

Adjust the settings of the archiving process in the Archive Controller (Please see Extension Parameters / Archiving Controller).

To execute the archiving process, go the Archiving tab in the Organizational Structure on the company level.

The Archive database field is prefilled based on the Use separate database setting in the Archiving Controller. When there is an _AR suffix at the end of the database name, the archiving is executed to a separate database.

The Days to keep live field is prefilled based on the Days to keep data in live database before moving to archive setting in the Archiving Controller. This number can be modified before executing the archiving.

Click on the Execute button to initiate the archiving process.

When executing the archiving the first time, the archiving database (if configured) and the archive tables will be created first.
Changing the Use separate database setting after the first archiving is not supported as it can cause issues.

Before creating the database and the tables, the system will ask for confirmation. Click on ‘Yes’ to proceed with the archiving.

After creating the archive tables, the system will ask for confirmation whether to continue with the archiving. Click Yes.

The system creates the following archive tables:

• PMX_AR_COHE
• PMX_AR_COLI
• PMX_AR_DLPL
• PMX_AR_DSST
• PMX_AR_IMHE
• PMX_AR_IMLI
• PMX_AR_INVD
• PMX_AR_LPLM
• PMX_AR_MOHE
• PMX_AR_MOLI
• PMX_AR_MVHE
• PMX_AR_MVLI
• PMX_AR_PIOP
• PMX_AR_PLHE
• PMX_AR_PLLI
• PMX_AR_PLLO
• PMX_AR_PLPH
• PMX_AR_PLPL
• PMX_AR_RTHE
• PMX_AR_RTLI
• PMX_AR_SSHH
• PMX_AR_SSHL
• PMX_AR_WAVE
• PMX_AR_WDET

After clicking the Execute button, the system starts the archiving. During the process, the system displays the following information:

• The time of the archiving
• The tables where the archiving was conducted
• The number of the archived documents
• The number of the live and archived picklists before and after the archiving, and the difference between them (the number of the newly archived picklists).

Since during the archiving process only closed documents are archived, there are cases when an archiving with a longer history to keep than the previous one is desired. A confirmation window will pop up if the system finds that the new changeover date is prior to the previous one. Click OK to proceed.

Archived PDMX documents (move documents, picklists and picklist proposals) can be distinguished by the added ‘archived’ text in their title.
SAP navigation buttons are disabled in archived document screens.

Move screen

Pick list screen

Pick list proposal screen