Command Reference

RECONCILE

Validates the references to files for the DATALINK data of a table. The rows for which the references to files cannot be established are modified in the input table.

Authorization

One of the following:

sysadm

sysctrl

sysmaint

dbadm

CONTROL privilege on the table.

Required Connection

Database

Command Syntax

>>-RECONCILE--+-tablename--------+--DLREPORT--filename----------> '-schema.tablename-' >-----+------------------------+--------------------------------> '-DLFM SERVER--hostname--' >-----+--------------------------------------+----------------->< '-FOR EXCEPTION--+-tablename--------+--' '-schema.tablename-'

Command Parameters

RECONCILE tablename

The table on which reconciliation is to be performed. The fully qualified name in the form: schema.tablename, or an alias, must be used. The schema is the user name under which the table was created.

DLREPORT filename

Specifies the file that will contain information about the files that are unlinked during reconciliation. The default name is Reconcile_TableName_yymmdd.

DLFM SERVER hostname

Specifies the DLFM server that was pre-configured for use with this database. Reconciliation will only be performed on the server specified. All other servers encountered in the table data will be ignored. Therefore, this option can be used to run RECONCILE on a particular server. The default behavior is to perform reconciliation on all servers in the table data.

FOR EXCEPTION tablename

This parameter is not currently used.

Example

   db2 reconcile manager dlfm server narang.almaden.ibm.com

Usage Notes

During reconciliation, attempts are made to link files which exist according to the table data, but which do not exist according to the DLFM metadata, if no other conflict exists.

When the reconcile utility is invoked without specifying a DLFM server name, reconciliation is performed with respect to all DATALINK data in the table. If file references cannot be established, the violating rows are not deleted from the input table, but to ensure DATALINK file reference integrity, the offending DATALINK values are NULLed. If the column is defined as not NULLable, the URL part of the DATALINK value is replaced by a zero length URL (the comment part is untouched). At the end of processing, the table is taken out of Datalink_Reconcile_Pending state.

If a DLFM server is specified, reconciliation is done only with respect to this server. In this case, other servers are not contacted, even if they are present in the DATALINK data. At the end of reconciliation, the table is taken out of Datalink_Reconcile_Pending state only if the table data has no reference to other DLFM servers. If, after performing reconciliation with respect to one or more DLFM servers for a table, the integrity of DATALINK data in the table is certain, the table can be taken out of check pending state by issuing the SET CONSTRAINTS ... IMMEDIATE UNCHECKED statement.

[ DB2 List of Books | Search the DB2 Books ]