TROUBLESHOOTING
The two tools are:
Running the tool to export tables for support
Complete these steps to extract the files to send to Support. The Support organization can then use those files to determine the cause of the problem and to advise of a solution for resolving the problem.
1. Run the scripts to extract the data.
2. Zip or compress the extracted files and send the archive to Support.
Support can unzip or decompress the archive and then review the log that is produced during the extract operation to obtain information needed to reload the files. They can then run the reload script to access the data and analyze it.
Manually exporting tables for Support
You can perform this operation manually, but we recommend you run the scripts.
In this procedure, you export tables from a DB2-enabled Domino server. The Support organization can then create an identical configuration when they import the tables to a destination Domino server with DB2 enabled.
Exporting tables from the source server
1. Extract the data that belongs to the NSF database in question by exporting the DB2 tables that hold its data.
2. Open the Control Center in DB2. Choose Start - Programs - IBMDB2 - General Administration Tools - Control Center.
3. Select the DB2 database that contains the NSF database that you want to extract.
4. Open Tables and sort by SCHEMA.
5. Export the following tables (use IXF format and specify the message file, directory, and file name for the large objects (LOB)):
Note Assume that the NSF database requiring attention is contained in the DB2 database DOMINO, is named TEST.NSF and has a schema named TEST. The schema for the DOMINO DB2 database is named DSCHEMA.
Where nsfschema=TEST
Tables are created based on the NIFData table called 'ND' || timestamp, for example, ND0078A8F4852572A2.
Importing tables to a destination server
Import the tables to a Domino server with IBM® DB2 Universal Database™ Enterprise Server Edition enabled. Assume that there is no database named TEST on this destination server. The schema for the DB2 database named DOMINO is DSCHEMA, the schema for the NSF database to be imported is TEST and the tablespace is also named TEST. The metadata listed in the table is needed to create the configuration on the destination server.
1. Create a Tablespace using these settings: