TROUBLESHOOTING


Running the Extract and Reload NSFDB2 Tool
Use the Extract/Reload Tools when IBM® Lotus® Domino® is unable to recognize IBM® DB2 Universal Database™ Enterprise Server Edition databases. For example, run the extract tool when DB2 database corruption causes a server crash, the Domino server does not recognize the DB2 databases and you want to determine the cause of the problem. After using the extract tool to extract files, you can send the files to the Support organization to determine the cause of the problem.

The two tools are:

The tool is distributed by support on an as-needed basis.

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 schema=TEST Where schema= 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:
SettingEnter
NameTEST
TypeRegular
Space managementSystem
Page size32Kb
Buffer poolDOMINO
Dropped table recoveryEnable
Add container in this directoryAdd a container in directory <Drive>:\<Domino server data directory> called TEST.DB2
2. Import these tables:

3. Import a row for the new database in Domino's catalog: