StartUp parameters
The [StartUp] (SU) parameters specify initialization options for the High-speed Apply Engine. The parameters that you specify vary depending on the DBMS and operating system platform where you run High-speed Apply Engine.
Parameter | Reference |
|---|---|
BindQualifier | |
ConnectionVersion | |
Database | |
DateFormat | |
DBMSType | |
DefaultOpts (DOPT) | |
DistributionType | |
FileName (IFN) | |
InputMediaType | |
InputType (IT) | |
LargeStatementSupport | |
Login | |
Password | |
PlanName (PLAN) | |
PublicPlan | |
SQLTerminator | |
SSID | |
TimestampFormat | |
TimestampTzFormat | |
UserID | |
zIIP |
For Db2 targets on a mainframe, the following figure shows an example of the [StartUp] parameters. The [StartUp] section is required. You must specify the FileName, SSID, and PlanName parameters.
FileName=USER14.MIGRATE.SQL
InputType=SQL
SSID=DBAM
PlanName=APTSMDB2
For Db2 LUW, the following figure shows an example of the [StartUp] parameters. The [Startup] section is required for Db2 LUW targets. You must specify the FileName, Database, and DbmsType parameters.
FileName=/home/operations/migrate.sql
Database=ACCT
DbmsType=DB2
For Oracle, the following figure shows an example of the [StartUp] parameters. If the target database is configured for automated login, and the input file name is the default name, the [Startup] section is not required. If you do not use automated login, you must include the Login parameter.
FileName=User14.Migrate.SQL
Login=user14/******@Ora10
Related topics