Settings for IBM Db2 for z/OS, IBM Db2 LUW, and Teradata

When you specify presets for IBM Db2 for z/OS, IBM Db2 LUW, or Teradata, you are prompted to select the following items:

Use server scoring adapter database or Use server scoring adapter shema. If selected, enables the Server scoring adapter database or Server scoring adapter schema option.

Server scoring adapter database or Server scoring adapter schema From the drop-down list, select the connection you require.

In addition, for Teradata, you can also set query banding details to provide additional metadata to assist with items such as workload management; collating, identifying, and resolving queries; and tracking database usage.

Spelling query banding. Choose if the query banding will be set once for the entire time you are working with a Teradata database connection (For Session), or if it will be set every time you run a stream (For Transaction).

Note: If you set query banding on a stream, the banding is lost if you copy that stream to another machine. To prevent this, you can use scripting to run your stream and use the key word querybanding in the script to apply the settings you require.

Required database permissions

For SPSS® Modeler database capabilities to function correctly, grant access to the following items to any user IDs used:

Db2 LUW
SYSIBM.SYSDUMMY1
SYSIBM.SYSFOREIGNKEYS
SYSIBM.SYSINDEXES
SYSIBM.SYSKEYCOLUSE
SYSIBM.SYSKEYS
SYSIBM.SYSPARMS
SYSIBM.SYSRELS
SYSIBM.SYSROUTINES
SYSIBM.SYSROUTINES_SRC
SYSIBM.SYSSYNONYMS
SYSIBM.SYSTABCONST
SYSIBM.SYSTABCONSTPKC
SYSIBM.SYSTABLES
SYSIBM.SYSTRIGGERS
SYSIBM.SYSVIEWDEP
SYSIBM.SYSVIEWS
SYSCAT.TABLESPACES
SYSCAT.SCHEMATA
Db2/z
SYSIBM.SYSDUMMY1
SYSIBM.SYSFOREIGNKEYS
SYSIBM.SYSINDEXES
SYSIBM.SYSKEYCOLUSE
SYSIBM.SYSKEYS
SYSIBM.SYSPARMS
SYSIBM.SYSRELS
SYSIBM.SYSROUTINES
SYSIBM.SYSROUTINES_SRC
SYSIBM.SYSSYNONYMS
SYSIBM.SYSTABCONST
SYSIBM.SYSTABLES
SYSIBM.SYSTRIGGERS
SYSIBM.SYSVIEWDEP
SYSIBM.SYSVIEWS
SYSIBM.SYSDUMMYU
SYSIBM.SYSPACKSTMT
Teradata
DBC.Functions
DBC.USERS