Bulk loading data to IBM Db2 databases

The following points may help you to configure for bulk loading from IBM® SPSS® Modeler to an IBM Db2 database using the External Loader option in the DB Export Advanced Options dialog box.

Ensure that the Db2 command line processor (CLP) utility is installed

The script db2_loader.py invokes the Db2 LOAD command. Ensure that the command line processor (db2 on UNIX, db2cmd on Windows) is installed on the server on which db2_loader.py is to be executed (typically, the host running IBM SPSS Modeler Server).

Check whether the local database alias name is the same as the actual database name

The Db2 local database alias is the name used by Db2 client software to refer to a database in a local or remote Db2 instance. If the local database alias is different from the name of the remote database, supply the extra loader option:

-alias <local_database_alias>

For example, the remote database is named STARS on host GALAXY but the Db2 local database alias on the host running IBM SPSS Modeler Server is STARS_GALAXY. Use the extra loader option

-alias STARS_GALAXY

Non-ASCII character data encoding

If you are bulk loading data that is not in ASCII format, you should ensure that the codepage variable in the configuration section of db2_loader.py is correctly set up on your system.

Blank strings

Blank strings are exported to the database as NULL values.