Use the following overrides to control how the Search and
Restore Process restores data to your database.
Search and Restore processing uses the Restore
Selection mode and Insert or Load Request information from the model
Restore Request and unless you override Insert or Load parameters,
Insert or Load Requests are matched with Archive files in the normal
way. Overrides, however, apply to all processing. You cannot provide
separate overrides for each Archive File as in the [AFn]
overrides for a Restore Process.
Insert or Load
- CFFILE
- Override for the Control File name in the Insert or Load Request.
- confilename.cf
- The name of the Control File. Provide the full path if the file
is not in the default Data Directory.
- TMNAME
- Override for the local or named Table Map referenced in the Insert
or Load Request selected at run time.
- identifier.name
- Two-part name of an existing Table Map.
- COLMAPID
- Override for default identifier for Column Maps referenced in
the Table Map.
- identifier
- One- to eight-character identifier.
- COLMAP
- Override for Column Map designation for a destination table referenced
in the Table Map.
- [ [ dbalias. ] cid.
]tablename
- One, two, or three-part table name. If tablename is
not fully qualified, the default qualifier is used.
- [ identifier. ] name
- One or two-part Column Map name. If name is
not fully qualified, the Column Map ID is used.
- DESTQUAL
- Override for Qualifier in the Table Map.
- dbalias. [ cid]
- One or two-part default qualifier for destination tables referenced
in Table Map.
- DESTTABNAME
- Override for source to destination mapping in the Table Map.
- [ [ dbalias. ] cid.
] srctablename
- One, two, or three-part name of a table in the Source File. If tablename is
not fully qualified, the default Qualifier applies.
- [ [ dbalias. ] cid.
] desttablename
- One, two, or three-part destination table name. If tablename is
not fully qualified, the default Qualifier applies.
Insert
When
the model Restore Request Process mode is Insert, the following overrides
can be used, and pertain to the Insert Process for all Archive Files
identified for Search and Restore processing.
- COMMFREQ
- Override for Commit Frequency setting.
- n
- Specify any number between 1 and the maximum set
in Product Options.
- PROCTYPE
- Override for Process Option.
- INS
- Insert data.
- UPDINS
- Update and insert data.
- UPDATE/INSERT
- Update and insert data.
- UPDATE ONLY
- Update data only. Do not insert.
- LOCKTABS
- Override for Lock Tables setting.
- Y
- Lock tables during insert processing.
- N
- Do not lock tables.
- DISROWLIM
- Override for Discard Row Limit setting in the Insert
Request.
- n
- 0 (to impose no limit) or a number from 1 to 99999999
to stop processing after the specified number of rows are discarded
and all rows in the array processed. You can Restart or Retry a process
that stops because the limit is reached.
Load
When the
model Restore Request Process mode is Load, the following overrides
can be used, and pertain to the Load Process for all Archive Files
identified for Search and Restore processing.
- MODE
- Loader processing mode for the database.
- dbalias
- The DBAlias for the database.
- INSERT
- Insert rows into empty destination tables.
- REPLACE
- Delete all rows from destination before loading.
- APPEND
- Load rows into destination, discarding duplicate
rows or inserting them into exception tables. (Oracle only.)
- TRUNCATE
- Delete all rows from destination before loading.
(RI constraints must be disabled. Oracle only.)
- PERFLOAD
- Override for Perform Load setting in Load Request.
- dbalias
- The DBAlias for the database.
- Y
- Run the loader immediately after file conversion.
- N
- Do not run the loader.
- DELONSUCCESS
- Override for delete files option when the Load Process
completes successfully.
- dbalias
- The DBAlias for the database.
- Y
- Delete files for the database referenced by dbalias.
- N
- Do not delete files.
- DELONFAILURE
- Override for delete files option when the Load Process
fails.
- dbalias
- The DBAlias for the database.
- Y
- Delete files for the database referenced by dbalias.
- N
- Do not delete files.
- WORKPATH
- Override for temporary loader files directory path.
- dbalias
- The DBAlias for the database.
- path
- Path to location for files. Drive must be accessible
to DBMS server and client, workstation and network server.
- SERVPATH
- Override for temporary loader files Server path.
(DB2® UDB only.)
- dbalias
- The DBAlias for the database.
- path
- Path to location for files. drive must be accessible
to DBMS server and client, workstation and network server.
- END
- End of Search and Restore Process.