AE DB Unload

Administrators use the AE DB Unload utility (ucybdbun) to unload data from the AE database. You can unload specific database tables or all tables, reorganize your database, reset archive or reorg flags. You can also unload the transport case, or even unload all objects of one or all your clients.

This page includes the following:

Overview

The utility lists the tables of the AE database in its left window half and shows the available actions in its right window half. During the unloading process, the utility generates a text file that includes all the relevant data. It is stored in the output folder that you define in the INI file entry OUTPUT=. You can use this file to load your data again with the AE DB Load utility. For more information, see Utility DB Unload.

Restart the utility after each unloading process if you want to start another unloading process.

Available Actions

Select all / Unselect all
Select or deselects the database tables that are listed in the left window half of the utility.

Export selected table
You can select one or more individual tables and export them.

Export all data
Exports all database tables

Reorganize database
Removes all data that has been marked either with an archive flag by using the AE DB Archive utility or with a deletion marker by using AE DB Reorg. This is a system-wide process that applies to all clients. For more information, see AE DB Archive and AE DB Reorg.

Database reorganization includes the objects that are in the Explorer's Recycle Bin, statistical data and the corresponding reports.

Reset archive flags
Resets the archive flags of one or all clients.

Reset reorg flags
Resets the reorg flags of one or all clients.

Unload transport container
You can unload objects that have been moved to the Transport Case (see Transport Case). A dialog opens in which you select whether the export refers to only one client or to all of them.

Unload all objects
Unloads the objects of one or all clients. In this case, you do not have to move them to the Transport Case before.

Possible Errors and Messages

The AE DB Unload utility checks the folder structure of the Explorer. It prints the message U0021148 to the log file if it finds corrupt folder connections. Call the utility with the -BREPAIR start parameter in such situations to have the folder structure automatically corrected.