Test Data Management 9.7.1
- Test Data Management 9.7.1
- All Products
ilmcmd [options] <-Reset | -r> <-DatasetVersionName | -dvn>Data set version name<-ResetFile | -rf>File location<-ResetIntegrationService | -ris>Integration Service[-Verbose | -v] [-Help | -h]
Required. The reset job that you create to reset a data set version.
Data set version name
Required. The name of the data set version that you want to reset.
Required. The location of the file that contains the reset objects.
Required. The name of the Integration Service that runs the reset workflow operation.
Optional. Verbose output. Displays more than the minimum information about the object.
Optional. Displays or prints the help options.
ilmcmd –r –dvn “RESET Version1” –rf “C:\Documents\ResetObject.json” –ris PIS
The name of the source connection.
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.
Disable the constraints automatically during the reset operation.
Disable the constraints manually during the reset operation.
Disable indexes during the reset operation.
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.
Enables the reset recovery options.
A prefix for the backup schema. TDM creates a backup schema in the format prefix_tablename.
The name of the schema where you want to store the backup tables.
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.
Processes the decimal data type to a precision of 28. Default is No.
Sets the number of tables to process in a workflow. Default is 10.
The maximum number of sessions that can run at the same time. Applicable if you disable indexes and constraints in the target.
Sets the locale code for data reset operations.
An email address to send notifications to.
The subject of the email that you enter.
The content of the email that you enter.
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.
Enables the support for special characters in metadata.
The type of the target connection. You can select the relational connection types such as Oracle, Microsoft SQL Server, DB2, and Sybase.
The name of the target connection.
The name prefix of the target table. Specify the target schema name if the target is in a different schema.