User's Guide and Reference

Running the geocoder in batch mode

This section gives an overview of the steps to run a geocoder in batch mode from the Control Center. The overview is followed by details of how to complete each step.

To find out what authorization you need to run a geocoder in batch mode, see Authorization.

Overview of steps to run a geocoder in batch mode:

1. Open the Run Geocoder window.
2. Indicate which geocoder you want to use.
3. Disable objects that could impede the performance of the geocoder.
4. Specify how many records to geocode before DB2 issues a commit.
5. Indicate how you want the geocoder to operate.
6. Tell DB2 Spatial Extender to run the geocoder.

Detailed steps to run a geocoder in batch mode:

1. Open the Run Geocoder window.
   1. From the Control Center window, expand the object tree until you find the Tables folder in your spatially-enabled database.
   2. Click the Tables folder. The tables are displayed in the contents pane on the right side of the window.
   3. Right-click the table that you want in the contents pane and click Spatial layers in the pop-up menu. The Spatial Layers window opens.
   4. From the Spatial Layers window:
      1. Select the layer that is defined on the column that you want to populate.
      2. Click the Run Geocoder push button. The Run Geocoder window opens.
2. If you want to use the default geocoder, leave the Name box, which displays the name of this default, as is. Otherwise, use the box to select the geocoder that you want.
3. Disable objects that could impede the performance of the geocoder:
   • If the column that you want to populate has an index, select the Temporarily disable spatial indexes during geocoding process check box.
   • If triggers have been set to activate incremental geocoding for this column, select the Temporarily disable spatial triggers during geocoding process check box.

     The index and triggers will be re-enabled automatically when you click OK on the Run Geocoder window.

4. Use the Commit scope spin button to specify how many records to geocode before DB2 issues a commit. For example, if you want DB2 to commit 100 geocoded records at a time, specify the number, 100.

   Tip:	If you want DB2 to issue a commit only after all records are processed, specify zero.

5. Use the fields in the Geocoder parameters group box to indicate how you want the geocoder to operate:
   • Use the Precision level spin button to specify, in terms of a percentage, how accurate the match between source records and their reference data counterparts should be. For more information about precision, see About geocoding.
   • If you are using a vendor-supplied geocoder, and want to use properties that it supports, use the Properties box to set these properties.
   • If you want to geocode only a subset of rows in the table that you selected, use the WHERE clause box to code a SELECT WHERE clause that will specify the criteria for the rows that you want. This clause can reference any columns in the table.

     Type the criteria only. Omit the keyword WHERE. For example, if the table has a STATE column, and you want to geocode only those rows that contain the value MA in this column, type:

     STATE='MA'
     

6. Click OK to run the geocoder.