The two tools are:

• EXTRACT.BAT -- Use this tool to extract the tables (files) to send to Support.
• RELOAD.BAT -- Support uses this tool to reload the files. The files can then be reviewed and the cause of the problem determined.

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.

• DB2MAP
• NIFCTL
• NIFDATA
• NSFNOTE
• NSFOBJECT
• NSFOBJNAM
• NSFSLOT
• PROPERTIES

• CATALOG

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:

Setting	Enter
Name	TEST
Type	Regular
Space management	System
Page size	32Kb
Buffer pool	DOMINO
Dropped table recovery	Enable
Add container in this directory	Add a container in directory <Drive>:\<Domino server data directory> called TEST.DB2

2. Import these tables:

Note LOB refers to large objects.
• DB2 => Import from F:\TEST\DB2MAP.IXF of IXF LOBS from F:\TEST MESSAGES F:\TEST\DB2MAP.MSG REPLACE_CREATE into TEST.DB2MAP in TEST
• DB2 => Import from F:\TEST\NIFCTL.IXF of IXF LOBS from F:\TEST MESSAGES F:\TEST\NIFCTL.MSG REPLACE_CREATE into TEST.NIFCTL in TEST
• db2 => Import from F:\TEST\NIFDATA.IXF OF IXF LOBS from F:\TEST MESSAGES F:\TEST\NIFDATA.MSG REPLACE_CREATE into TEST.NIFDATA in TEST
• db2 => Import from F:\TEST\NSFNOTE.IXF of IXF LOBS from F:\TEST MESSAGES F:\TEST\NSFNOTE.MSG REPLACE_CREATE into TEST.NSFNOTE in TEST
• db2 => Import from F:\TEST\NSFOBJECT.IXF of IXF LOBS from F:\TEST MESSAGES F:\TEST\NSFOBJECT.MSG REPLACE_CREATE into TEST.NSFOBJECT in TEST
• db2 => Import from F:\TEST\NSFOBJNAM.IXF of IXF LOBS from F:\TEST MESSAGES F:\TEST\NSFOBJNAM.MSG REPLACE_CREATE into TEST.NSFOBJNAM in TEST
• db2 => Import from F:\TEST\NSFSLOT.IXF of IXF LOBS from F:\TEST MESSAGES F:\TEST\NSFSLOT.MSG REPLACE_CREATE into TEST.NSFSLOT in TEST
• db2 => Import from F:\TEST\PROPERTIES.IXF of IXF LOBS from F:\TEST MESSAGES F:\TEST\PROPERTIES.MSG REPLACE_CREATE INTO TEST.PROPERTIES in TEST

• db2 => Import from F:\TEST\CATALOG.IXF OF IXF LOBS from F:\TEST MESSAGES F:\TEST\CATALOG.MSG INSERT INTO DSCHEMA.CATALOG

Replace into DSCHEMA.Catalog in Domino

Glossary