Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Glossary

Reset

Reset

You can reset a data set version to a target and override the source properties.
The reset command uses the following syntax:
ilmcmd [options] <-Reset | -r> <-DatasetVersionName | -dvn>
Data set version name
<-ResetFile | -rf>
File location
<-ResetIntegrationService | -ris>
Integration Service
[-Verbose | -v] [-Help | -h]
The following table describes the reset command options and arguments:
Option
Argument
Description
-Reset
-r
n/a
Required. The reset job that you create to reset a data set version.
-DatasetVersionName
-dvn
Data set version name
Required. The name of the data set version that you want to reset.
-ResetFile
-rf
File location
Required. The location of the file that contains the reset objects.
-ResetIntegrationService
-ris
Integration Service
Required. The name of the Integration Service that runs the reset workflow operation.
-Verbose
-v
n/a
Optional. Verbose output. Displays more than the minimum information about the object.
-Help
-h
n/a
Optional. Displays or prints the help options.

Reset Example

The following sample command resets a data set version:
ilmcmd –r –dvn “RESET Version1” –rf “C:\Documents\ResetObject.json” –ris PIS

Sample Reset File Properties

Use a sample reset file to configure the reset properties.
After you install TDM, you can find the
ResetObject.xml
file or the
ResetObject.json
file in the following location:
<Installation directory>/TDM/utilities/ilmcli/conf/
The following table describes the reset file properties and the description:
Property
Description
SOURCE_CONN_NAME
The name of the source connection.
TRUNCATE_TRGT_TABLES
The target tables that TDM truncates if you want to completely replace the target connection with data from the data set version. TDM deletes all data in the target, and copies the data set version to the target. TDM disables constraints and indexes when it performs this operation.
AUTOMATIC_DISABLE_CONSTRAINT
Disable the constraints automatically during the reset operation.
MANUAL_DISABLE_CONSTRAINT
Disable the constraints manually during the reset operation.
DISABLE_INDEXES
Disable indexes during the reset operation.
UPSERT_IN_TRANSACTIONAL_TABLES
Performs an upsert on transactional tables instead of an insert. If the parent records of records in the data set version have changed to point to a different parent in the target, the insert might fail. The reset operation fails if the insert fails.
ENABLE_RECOVERY
Enables the reset recovery options.
BACKUP_RECOVERY_PREFIX
A prefix for the backup schema. TDM creates a backup schema in the format prefix_tablename.
BACKUP_RECOVERY_USER_NAME
The name of the schema where you want to store the backup tables.
STOP_ON_ERROR
Indicates how many non fatal errors the PowerCenter Integration Service encounters before it stops the session. If you enter zero, the session does not stop for nonfatal errors. Default is zero.
ENABLE_HIGH_PRECISION
Processes the decimal data type to a precision of 28. Default is No.
MAX_TABLES_PER_MAPPING
Sets the number of tables to process in a workflow. Default is 10.
MAX_PARALLEL_SESSIONS
The maximum number of sessions that can run at the same time. Applicable if you disable indexes and constraints in the target.
LOCALE_CODE
Sets the locale code for data reset operations.
EMAIL_ADDRESS
An email address to send notifications to.
EMAIL_SUBJECT
The subject of the email that you enter.
EMAIL_TEXT
The content of the email that you enter.
TARGET_LOAD_TYPE
The target load type. You can choose Normal or Bulk.
If you select Normal, the PowerCenter Integration Service loads targets normally. Choose Normal mode if the mapping contains an Update Strategy transformation.
Choose Bulk to improve session performance. Bulk load limits the ability to recover because no database logging occurs.
Default is Normal.
ENABLE_SPECIAL_CHARACTERS_IN_METADATA
Enables the support for special characters in metadata.
TARGET_CONN_TYPE
The type of the target connection. You can select the relational connection types such as Oracle, Microsoft SQL Server, DB2, and Sybase.
TARGET_CONN_NAME
The name of the target connection.
TARGET_PREFIX_NAME
The name prefix of the target table. Specify the target schema name if the target is in a different schema.