To Export Data from Repository tables, perform these steps:
Select Export data from repository tables from the first repository window, The Options for Import/Export window displays.
In the Options for Import/Export window, enter information in the following fields:
Directory for Export: enter the directory where the comma delimited file will be saved
Delimiter: enter a delimiter for the delimited file format (comma is the default)
Quote: enter the symbol that will contain string data (double quotes is the default)
IBM Tivoli Storage Resource Manager will export the data into the comma delimited file you specify, and place it in a file named <tablename>.txt.
Click Next. The Connection Properties window displays. In this step, IBM Tivoli Storage Resource Manager reads the config file and determines your current repository and the information for accessing the database.
The information detected in the config file is displayed in the Connection Properties window within the following fields: Database Types, User name, Password, Driver Class, Driver URL, Database, DB Creator, Classpath.
Note: If you want to export from a different database then the one listed in the config file, you can select the database from the Database Types drop-down list and manually enter the database information.
Click Finish. IBM Tivoli Storage Resource Manager will then connect to the database and display the database and connection information.
Click Run to begin the export process. A window displays containing the export progress log.
As you progress through the export, messages are written to this progress log, allowing you to keep track of the steps as they happen.
For more information, see Repository Copy Tool Help.