DB2 Data Links Manager Quick Beginnings

Running RECONCILE after restoring a file system

The db2_recon_aid utility provides a mechanism for checking and running RECONCILE on tables that are potentially inconsistent with the DATALINK file data on the file server, after a disk failure on the file server.

On AIX, the db2_recon_aid utility is located in the INSTHOME/sqllib/adm directory, where INSTHOME is the home directory of the instance owner.

On Windows NT, the db2_recon_aid utility is located in x:\sqllib\bin directory, where x: is the drive where you installed DB2 Data Links Manager.

To run RECONCILE, use the following syntax:

   db2_recon_aid -check -db database_name==>
     [-server_name fileserver_name] [-reportdir report_directory]

where:

• check lists the tables that may need reconciliation. No reconcile operation will be performed.
• database_name is the name of the database for which the reconcile operation needs to be performed.
• fileserver_name is the name of the DLFM server for which the reconcile operation is to be performed. If no name is provided, all the file servers will be reconciled.
• report_directory is the directory containing a report for each of the reconcile operations. For each table on which reconcile was performed, files of the following format will be created where:
  • <tbschema> is the schema of the table.
  • <tbname> is the table name.
  • <ext> is .ulk or .exp. The .ulk file contains a list of files that were unlinked on the file server, and the .exp file contains a list of files that were in exception on the file server.

For more information, see refer to the RECONCILE command in the Command Reference.