Batch
Control
|
Description
|
K1-CNVLD
|
Conversion
- Load Data using SQL Loader.
This process facilitates the
legacy data extract upload using SQL Loader. The input data files
are expected to be uploaded to a file storage location. See Input and Output File Location for more information about file storage locations.
One run
uploads the data into a single target Table or Maintenance Object.
The process is multi-threaded.
This process is discussed
in more details in the Data Load Batch chapter
|
K1-CNVDS
|
Conversion
- Disable Conversion
This process resets the environment indicators
and prevents further conversion activities. Once conversion is disabled,
the following actions are blocked:
-
Switching between Conversion and Production
-
Table truncation
-
Disable Indexes and Rebuilding the Statistics
-
Data insertion into Production
-
Data upload into staging
Note: The process should be executed only once and only after
all of the conversion activities are completed and the application
is ready for the real production use.
|
K1-CNVEN
|
Conversion
- Enable Conversion
This process resets the environment indicators
and enables it for conversion activities. It should be executed at
the start of the Conversion project.
|
K1-DRPIN
|
Conversion
- Disable Indexes on Production Tables
This process can be
used in two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object. Limitation: the indexes on the batch run history and other batch operation-related tables can not be disabled
-
If no specific target is populated, the process disables indexes
on all converted tables in Production schema
|
K1-SDSIN
|
Conversion
- Disable Indexes on Staging Tables
This process can be used
in two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object. Limitation: the indexes on the batch run history and other batch operation-related tables can not be disabled
-
If no specific target is populated, the process disables indexes
on all converted tables in Staging schema
|
K1-DRICMS
|
Conversion
- Disable Customer Modification Indexes
This process can be used
in two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object
-
If no specific target is populated, the process disables indexes
on all conversion-eligible tables in Customer Modification schema
|
K1-RIUSP
|
Conversion
- Rebuild Indexes and Update Statistics in Production
This process
can be used in two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object
-
If no specific target is populated, the process rebuilds indexes
and updates statistics on all converted tables in Production schema
- Specify the sampling size (percentage) for statistics gathering.
If not specified, the system will use default dbms_stats.auto_sample_size.
-
Specify whether you wish to rebuild indexes, to gather table
statistics or both.
It is recommended to rebuild the indexes and update statistics
right after the data upload.
|
K1-RIUSS
|
Conversion
- Rebuild Indexes and Update Statistics in Staging
This process
can be used in two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object
-
If no specific target is populated, the process rebuilds indexes
and updates statistics on all converted tables in Staging schema
- Specify the sampling size (percentage) for statistics gathering.
If not specified, the system will use default dbms_stats.auto_sample_size
-
Specify whether you wish to rebuild indexes, to gather table
statistics or both
It is recommended to rebuild the indexes and update statistics
right after the data upload.
|
K1-RUSCM
|
Conversion
- Update Customer Modification Statistics
This process
can be used in two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object
-
If no specific target is populated, the process rebuilds indexes
and updates statistics on all conversion-eligible tables in Customer Modification schema
- Specify the sampling size (percentage) for statistics gathering.
If not specified, the system will use default dbms_stats.auto_sample_size
-
Specify whether you wish to rebuild indexes, to gather table
statistics or both
It is recommended to rebuild the indexes and update statistics
right after the data upload.
|
K1-CLNTB
|
Conversion
- Truncate Tables in Production
This process can be used in
two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object. Limitation: the sequences, the batch run history and other batch operation-related tables can not be truncated
-
If no specific target is populated, the truncates all converted
tables in Production schema
|
K1-SCLTB
|
Conversion
- Truncate Tables in Staging
This process can be used in two
modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object. Limitation: the sequences, the batch run history and other batch operation-related tables can not be truncated
-
If no specific target is populated, the truncates all converted
tables in Staging schema
|
K1-CLNCM
|
Conversion
- Truncate Customer Modification Tables
This process can be used in
two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object
-
If no specific target is populated, the truncates all conversion-eligible tables in Customer Modification schema
|
K1-CLNRT |
Conversion — Truncate XML Resolution TablesThis process
is allowed to run only in the Staging schema and may be used in two
modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object
-
If no specific target is populated, the truncates all XML
Resolution tables in Staging schema
|
K1-CLNKY
|
Conversion
- Truncate Key Reference Tables
This process is allowed to
run only in the Staging schema and may be used in two modes:
-
Populate Table or Maintenance Object batch parameter to process
specific object
-
If no specific target is populated, the truncates all Key
Reference tables in Staging schema
|