Administrators use the utility AE DB Unload (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, 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 utility AE DB Load. For more information, see the INI file of the utility 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 utility AE DB Archive or with a deletion marker by using AE DB Reorg is deleted from the database. 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 utility AE DB Unload checks the Explorer's folder structure. It prints the message U0021148 to the log file if it finds corrupt folder connections. Call the utility with the start parameter -BREPAIR in such situations to have the folder structure automatically corrected.
See also: