CONNECT TO
Use the CONNECT TO option to specify the database where the tables you want to unload reside.
- CONNECT TO
- Optim™ High Performance Unload establishes
a connection to the database specified by using the ID of the user
who is running Optim High Performance Unload.
Within a GLOBAL block, you can issue connect once.
- Syntax
- CONNECT TO database_name [ DBCCSID n | UTF8 ] [ URL "hostname" PORT "number" [ SSL YES | NO ] ]
- Variable
- database_name Name of the source database.
- Default
- db2dbdft
- Rules
- When considering a Db2® Warehouse database as a data source, there are several rules and prerequisites to be taken into account :
- The URL and PORT options must be specified.
- The SSL option is not mandatory, its default value is NO. It allows to specify if an SSL connection must be used or not. It must be specified and set to YES if the connection to be used is an SSL one.
- It is not possible to run Optim High Performance Unload in standalone mode, because Optim High Performance Unload needs to use the Db2 libraries to interface with the remote Db2 Warehouse server.
- The DB2 option must be set to FORCE for the execution concerned. If there is no DB2 option specified, the default value will be FORCE.
- It is not possible to use in the same Optim High Performance Unload execution the -r command line option and the --warehouse command line option, because they are antagonist ones, each permitting to refer to a data source of a specific type.
- In order to run Optim High Performance Unload to unload from a Db2 Warehouse database, it is mandatory that appropriate user credentials of ‘warehouse’ type be configured into the Optim High Performance Unload configuration file for credentials. The section name to be configured for the ‘warehouse’ credentials corresponds to the alias value to be specified as an argument of the --warehouse command line option.