You can use the utility AE DB UnloadUtility for unloading the Automation Engine database. (UCYBDBUN) in order to unload data from the AE databaseA database is an organized collection of data including relevant data structures.. Use the various options that are available
The tables of the AE database are listed in the left half of the window. You can unload particular ones or all of them. The utility generates a text file with the corresponding data. Define the output directory and file name with the entry OUTPUT= in the INI file. These files can then be loaded to the database of another AE system with the utility AE DB LoadThe utility DB Load can be used to load data into the Automation Engine database., for example.
Actions |
Description |
---|---|
Select all / Unselect all |
Selects or deselects the database tables that are listed in the left window. |
Export selected table |
Exports the selected database table(s). |
Export all data |
Exports all database tables. |
Reorganize database |
Removes all data that has been marked with a deletion marker using the utility AE DB ReorgData can be reorganized by using the utility DB Reorg. It marks data records with a deletion flag in accordance with the settings that have been specified.. |
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 |
Unloads the transport case of one or all clients. |
Unload all objects |
Unloads the objects of one or all clients. |
AE DB Unload can also be used to reorganize the database. Data that has previously been marked with an archive flag by the utility AE.DB Archive or with a deletion marker by AE.DB Reorg will then be deleted from the database. This is a system-wide process applying for all clients. You can accelerate the unloading process by avoiding the creation of REORG files with the parameter suppress_output=1 in the INI file.
Note that reorganizing the database also includes reorganizing the objects that are in the Explorer's Recycle Bin, statistical data and the corresponding reports.
Archive and reorg flags can also be reset AE system-wide and clientA closed environment within an Automation Engine system where you can create and run objects. A client name consists of a 4-digit number that must be indicated when a user logs on to the Automation Engine system. Users and their rights are also defined in clients. A particular Automation Engine object type.-wide.
You can also unload objects that have been put to the Transport Case. A dialog is displayed in which you can select whether the export refers to only one particular client or to all of them. If only one client is concerned, select it from the listShows entities in a grid view. Furthermore, you can also unload all objects (either from all clients or from a particular one) without moving them to the Transport Case before.
A statusThis represents the condition of a task (such as active, blocked, generating). line shows how the unloading process is proceeding. The remaining time as well as information about the data records is provided.
Format:
Number of the data records that have already been processed / total number of data records / (number of subordinate data records)
After the unloading process, you must restartA restart refers to the repetition of an object's execution. This action differs from a new start in some parts. the service program in order to facilitate further unloading processes.
The utility AE DB Unload checks the Explorer's folderTop level entities such as Environment, Deployment Target, Activity, … are stored in folders. The permissions a user has on an entity depend on the permissions that are set on the folder for the entities. 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 in order to have the folder structure automatically corrected.
See also:
Start Parameters
Structure of the INI file, AE DB Unload
Transport Case
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |