Online Documentation for SQL Manager for DB2

Specifying additional parameters


At this step of the wizard additional CLP import data structure parameters can be specified.

 

CLP Import - Specifying additional parameters

 

 

Use the spinner controls to define the number of physical records to be imported | restart count | skip count | the number of warnings after which the import operation stops | the number of records to import before committing.

 

 

Access level

 

RadioButton Allow no access

Specifies that the CLP import utility locks the table exclusively.

 

RadioButton Allow write access

Specifies that the data in the table should still be accessible to readers and writers while the import is in progress.

 

 

Timeouts

 

RadioButton Don't use timeouts

Indicates that there is no timeout.

 

RadioButton Use timeout value from configuration

Indicates that the value of the locktimeout option from database properties is respected.

 

 

Click the Next button to proceed to the Importing data step of the wizard.