AE DB Client Copy

The utility AE DB Client Copy (ucybdbcc) can be used to copy clients to the same or a different database, or to delete existing clients. All the source client's objects, messages, statistics, reports and version management objects can be included. For security reasons, you need to log on to system client 0000. To do so, make sure that the password is exactly the same in the source and target AEsystem. The login window opens automatically when the program starts.

This page includes the following:

Copy Clients

You can select one or several options from the Settings section in the utility's user interface:

Copy objects
All objects that are not marked with a deletion flag are copied. If the host definitions are not available in the destination client, they are logged in the log file. Objects are only copied when the client is copied for the first time.
Copy messages
All messages that are not marked with a deletion flag are copied.
In subsequent copying processes, the utility copies all messages that are available in the source client when the process starts.
Reset password
All user passwords are reset to "pass".
Copy statistics/report
All statistics and reports that are not marked with a deletion flag are copied.
In subsequent copying processes, the utility only copies the statistics and reports of objects that were already considered in the first copying process. It copies all the relevant data records that are available in the source client when the process starts.
Copy VC Objects
Version management objects are copied. This is only possible when the client is copied for the first time. For more information, see Version Management Page.

The destination client automatically stops while the utility AE.DB Client Copy is copying data even if only copies the statistics and report data.

To copy a client for the first time:

Start the utility AE.DB ClientCopy.
Select the client that should be copied in the source database.
Select an unused client number (green hand symbol) in the destination database.
Decide whether messages, statistics and so on should also be copied.
Click Copy client to start the process.

To copy messages and statistics subsequently:

Start the utility AE.DB ClientCopy.
Select the client that you have already copied and the corresponding destination client.
Select the messages, statistics, or reports that should be copied subsequently. The utility will skip data that is already available in the destination client.
Click Copy client to start the process.

Delete Clients

To Delete a Client

Start the utility AE.DB ClientCopy.
Switch to the Delete client tab
(Optional) In the Settings section, select whether you want to delete a client in the source or destination database.
Select the client that should be deleted in the database list.
Click Delete client to start the deletion process

Important!

Unload all reorganized data before you start deleting a client. This reduces the time the database is blocked.
When you delete an existing client, the contents of all its AE database tables are deleted.
You cannot restore a deleted client.

Specific Settings

In the utility's INI file (see Utility DB Client Copy), you can specify database connections to a different database server. For example, you can copy a client from an MS-SQL Server to an Oracle or DB2 database. Ensure that both AE databases are of the same version.

Only one log file is used for this process. It contains the message "U0036000 database change to source" or "U0036000 database change to destination" so that entries can be distinguished. Note that the value of the database trace must be set to at least 1 as otherwise, this message won't be inserted.

In the utility's INI file (see Utility DB Client Copy, you can define the parameter WorkTablePath=. In this case, the utility will create work files in XML format for messages, statistics and reports. In doing so, you can copy them subsequently. The name of these work files is composed of the client numbers of the source and destination client separated by an underscore. For example: If you copy from client 0003 to 0333, the resulting file name is 0003_0333.xml. If the folder you define does not exist, the utility does not create work files.

In the variable UC_CLIENT_SETTINGS, you may use the key PWD_DEFAULT to set a client-wide default password for new User objects which are created without an individual password. When you use the client copy utility, all User objects that are included in the copied client will be set to the default password that you defined in that key. For more information, see PASSWORD Parameters and UC_CLIENT_SETTINGS - Various Client Settings.

If no password is defined there, the default system password pass will be set at the copying process. Users will have to change their password in both cases when they log in to the system the next time.

The Protocol tab supplies detailed information during the copying and deletion process, as well as the log file that is automatically created.