Index

A B C D E F G H I L M N O P R S T U X

A

AIX

AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME, C.8.39

alias

DB2, C.8.31

application

authenticating logons, 15.2

AS/400

command, DSPRDBDIRE, 13.2

library name, DRDA_PACKAGE_COLLID, C.8.42

ASCII

code page, E.3

US7ASCII, E.3.2.1

US7ASCII as default, E.2

B

Bind Package Stored Procedure

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

BIND privilege

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDADD authority, 14.3

BINDADD privilege

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDAGENT privilege

DB2/OS390, 13.1

binding the DRDA package

configuring the gateway on DRDA server, 14.4

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

C

CCSID

65535 as the default for all tables created, C.8.30

codepage mapping facility, E.4

description, E.1

CCSID (coded character set identifiers), defined, E.5

CHARACTER SET

clause, client/server configuration, E.2

parameter, description, E.1

character sets

and codepage map facility, E.4

CCSID, E.1

codepage, C.8.30

Heterogeneous Services, C.8.6.1

clause

CHARACTER SET, client/server configuration, E.2

code tracing, C.8.58

codepage map facility

for data translation, E.4

collection privilege - CREATE IN

DB2/OS390, 13.1

collection privilege - CREATETAB

DB2/OS390, 13.1

Communication Database (CDB) tables, DDF, 13.1

concurrent connections

TCP/IP, 12.1.1

configuration assistants

troubleshooting, B.4, B.4

Configuring

two-phase commit, 3.5, 5.5, 7.5, 9.5

configuring

DB2/400, 13.2, 13.3

DB2/OS390, 13.1

host workstation for gateway, 14.1.2

Configuring the gateway, 3.1, 5.1, 7.1, 9.1

CONNECT authority

DB2/UDB, 14.3

CONNECT privilege

DB2/UDB, 13.3

COPY privilege

DB2/OS390, 13.1

CREATE DATABASE statement, client/server configuration, E.2

CREATE IN privilege

DB2/OS390, 13.1

CREATE PUBLIC DATABASE LINK privilege, 14.4.2

CREATEIN privilege

DB2/UDB, 13.3

CREATETAB authority, 14.3

CREATETAB privilege

DB2/OS390, 13.1

DB2/UDB, 13.3

Creating

transaction log table, 3.5.2, 5.5.2, 7.5.2, 9.5.2

cursor

number of cursors, DRDA_PACKAGE_SECTIONS, C.8.46

stability, DRDA_ISOLATION_LEVEL, C.8.38

D

data dictionary

support, 14

database

authorities - CONNECT, BINDADD, and CREATETAB, 13.3

link

binding the gateway package, 14.4.2

defining and controlling, 15.3

Database link

behavior, 11.4

database link

behavior, 3.4, 5.4, 7.4, 9.4, 14.8

dropping, when deinstalling the gateway, 17

datatypes

RAW

DRDA_DEFAULT_CCSID, C.8.30

date formats

Heterogeneous Services, C.8.59

DB2

aliases, C.8.31

Distributed Data Facility (DDF), 13.1

DRDA_DESCRIBE_TABLE compatibility, C.8.31

SPUFI utility, 13.1

DB2/400

configuring, 13.2

DRDA_DEFAULT_CCSID, C.8.30

DRDA_ISOLATION_LEVEL, C.8.38

DRDA_OPTIMIZE_QUERY, C.8.41

DRDA_PACKAGE_COLLID, C.8.42

user ID mapping, 15.4.1.2

DB2/OS390

configuring, 13.1

DRDA_ISOLATION_LEVEL, C.8.38

DRDA_OPTIMIZE_QUERY, C.8.41

user ID mapping, 15.4.1.1

DB2/UDB

configuring, 13.3, 13.3

DRDA_ISOLATION_LEVEL, C.8.38

DRDA_OPTIMIZE_QUERY, C.8.41

user ID mapping, 15.4.1.3

DDF

DB2 (Distributed Data Facility), 13.1

describe cache high water mark

definition, C.8.5

Destination Hostname or IP Address, same as DRDA server Hostname or IP Address (configuring TCP/IP, worksheet), D

Destination Service Port Number, same as DRDA Server Service Port Number (configuring TCP/IP, worksheet), D

diagnostic parameter, C.8.56

distributed

data facility (DDF), 13.1

distributed query optimizer (DQO)

DRDA-specific parameters, C.8.41

operations, DB2, 13.1

transaction, DRDA_RECOVERY_USERID, C.8.49

double-byte support, E.5

DQO

DRDA-specific parameters, C.8.41

DRDA

session security options, 15.4.1.1

DRDA Server

languages and character sets in configuration, E.4

DRDA server

configuring

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

Hostname or IP Address (configuring TCP/IP, worksheet), D

Service Port Number (configuring TCP/IP, worksheet), D

DRDA_CODEPAGE_MAP parameter, E.4

DRDA_COMM_BUFLEN parameter, C.8.28

DRDA_CONNECT_PARM (TCP/IP format) parameter, C.8.29

DRDA_DEFAULT_CCSID parameter, C.8.30

DRDA_DESCRIBE_TABLE parameter

defined, C.8.31

DRDA_DISABLE_CALL parameter

defined, C.8.32

DRDA_FLUSH_CACHE parameter, C.8.33

DRDA_GRAPHIC_LIT_CHECK parameter, C.8.36

DRDA_GRAPHIC_PAD_SIZE parameter, C.8.35

DRDA_GRAPHIC_TO_MBCS parameter, C.8.37

DRDA_ISOLATION_LEVEL parameter, C.8.38

DRDA_LOCAL_NODE_NAME parameter, C.8.39

DRDA_MBCS_TO_GRAPHIC parameter, C.8.40

DRDA_OPTIMIZE_QUERY parameter

defined, C.8.41

DRDA_PACKAGE_COLLID parameter

defined, C.8.42

DRDA_PACKAGE_CONSTOKEN parameter, C.8.43

DRDA_PACKAGE_NAME parameter

defined, C.8.44

DRDA_PACKAGE_OWNER parameter, C.8.45

DRDA_PACKAGE_SECTIONS parameter

defined, C.8.46

DRDA_READ_ONLY parameter

defined, C.8.47

DRDA_RECOVER_USERID

DB2/400, 13.2

DB2/OS390, 13.1

if the user ID is not specified, 13.3

DRDA_RECOVERY_PASSWORD parameter

DB2/400, 13.2

DB2/OS390, 13.1

defined, C.8.48

defining the recovery user ID, 13.3

DRDA_RECOVERY_USERID parameter

DB2/400, 13.2

DB2/OS390, 13.1

defined, C.8.49

defining the recovery user ID, 13.3

DRDA_REMOTE_DB_NAME parameter, C.8.50

DSPRDBDIRE command, 13.2

E

EBCDIC

character set support, E.3.2.1

code page, E.3

DRDA Server CCSID, E.7

environment variable

NLS_LANG

client character set, E.2

description of use, E.1

ORA_NLS11, E.1

error

date, E.3.2.3

obsolete parameters, 16.3.2

while binding the gateway package, 14.4.2

Error messages

error tracing, C.8.20

errors

configuration assistants, B.4

installation, B.3, B.4.2

non-interactive installation, B.5

silent mode, B.5

X windows, B.1

EXECUTE privilege

DB2/OS390, 13.1

DB2/UDB, 13.3

F

fatal errors, B.4.2

FDS_CLASS parameter, C.8.51

fetch array size, with HS_FDS_FETCH_ROWS, C.8.24

fetched date, C.8.54

file

InstallActions.log, 17

listener.ora, 17

tnsnames.ora, 17

files

oraInst.loc, A.2

response files, A.3

FOR BIT DATA

DRDA_DEFAULT_CCSID, C.8.30

G

Gateway

default SID, 3.1.1, 5.1.1, 7.1.1, 9.1.1

system identifier (SID), 3.1.1, 5.1.1, 7.1.1, 9.1.1, 11.1.1

two-phase commit, 3.5, 5.5, 7.5, 9.5

gateway

authenticating logons, 15.2

binding DRDA packages, 14.4

logging, LOG_DESTINATION, C.8.53

supported languages, E.4

tracing

LOG_DESTINATION, C.8.53

gateway initialization file

if errors are reported, 14.4.2

Gateway Password Encryption Tool, 3.6, 3.7, 5.6, 7.6, 9.7

Globalization Support

DRDA Server character sets, E.4

initsid.ora parameters, E.3.2

overview, E

parameters

configuration on client and Oracle databases, E.2

globalization support

Heterogeneous Services, C.8.6

date format, C.8.59

languages in character date values, C.8.60

GTW$_BIND_PKG

stored procedure, 14.4.2

H

hardware requirements, 12.1.1

Heterogeneous Services

defining maximum number of open cursors, C.8.8

initialization parameters, 11.1.1

optimizing data transfer, C.8.9

Oracle Database Gateway for ODBC

creating initialization file, 11.1.1

setting global name, C.8.4

specifying cache high water mark, C.8.5

tuning internal data buffering, C.8.10

tuning LONG data transfer, C.8.7

HS_CALL_NAME initialization parameter, C.8.1

HS_DB_NAME initialization parameter, C.8.4

HS_DESCRIBE_CACHE_HWM initialization parameter, C.8.5

HS_FDS_CONNECT_INFO, C.8.14

HS_FDS_CONNECT_INFO initialization parameter

specifying connection information, 11.1.2

HS_FDS_DEFAULT_OWNER initialization parameter, C.8.15

HS_FDS_FETCH_ROWS parameter, C.8.24

HS_FDS_PROC_IS_FUNC initialization parameter, C.8.16

HS_FDS_RECOVERY_PWD initialization parameter, C.8.23

HS_FDS_RESULTSET_SUPPORT initialization parameter, C.8.19

HS_FDS_SHAREABLE_NAME initialization parameter, C.8.22

HS_FDS_TRACE_LEVEL initialization parameter, C.8.20

enabling agent tracing, C.1

HS_FDS_TRANSACTION_LOG initialization parameter, C.8.21

HS_LANGUAGE initialization parameter, C.8.6

HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, C.8.7

HS_NLS_DATE_FORMAT

for dates used by the DRDA Server, E.3.2.3

HS_NLS_DATE_FORMAT initialization parameter, C.8.59

HS_NLS_DATE_LANGUAGE, E.3.2.4

HS_NLS_DATE_LANGUAGE initialization parameter, C.8.60

HS_NLS_NCHAR

character set to interchange GRAPHIC data, E.3.2.2

defined, C.8.52

HS_NLS_NUMERIC_CHARACTER initialization parameter, C.8.61

HS_OPEN_CURSORS initialization parameter, C.8.8

HS_RPC_FETCH_REBLOCKING initialization parameter, C.8.9

HS_RPC_FETCH_SIZE initialization parameter, C.8.10

HS_TIME_ZONE initialization parameter, C.8.11

HS_TRANSACTION_LOG, 3.5.2, 5.5.2, 7.5.2, 9.5.2

I

IFILE initialization parameter, C.8.13

IN and OUT columns, multi-byte support, E.5

inbound connections

processing, 15.4

Initialization parameter file

customizing, 3.1.2, 5.1.2, 7.1.2, 9.1.2, C

initialization parameters

Heterogeneous Services (HS), 11.1.1

initialization parameters (HS)

Oracle Database Gateway for ODBC, 11.1.1

initsid.ora file, 3.1.2, 5.1.2, 7.1.2, 9.1.2

Globalization Support parameters, E.3.2

InstallActions.log file, 17

installation

errors, B.3, B.4.2

silent mode, B.5

log files, B.2, B.2

non-interactive

error handling, B.5

oraInst.loc file, A.2

response files, A.3

preparing, A.3

silent mode, B.5

templates, A.3

silent mode, A.3.2, A.4

internal tracing, C.8.57

IP name, 15.4.1.1

isolation level, DRDA_ISOLATION_LEVEL, C.8.38

L

LANGUAGE parameter, E.3.2.1

listener.ora file, 3.8.2, 5.7.2, 7.7.2, 9.8.2, 11.6.2, 14.9.2, 17

example, 3.2.1.1, 5.2.1.1, 7.2.1.1, 9.2.1.1, 11.2.1.1, 14.2.1.1

location, 3.2.1, 5.2.1, 7.2.1, 9.2.1, 11.2.1, 14.2.1

log files, B.2, B.2

troubleshooting, B.3

LOG_DESTINATION parameter

defined, C.8.53

with ORACLE_DRDA_TRACE, C.8.57

logging, LOG_DESTINATION, C.8.53

M

mount point directories, 1.5.2.2

multi-byte support, E.5

N

Net Configuration Assistant

troubleshooting, B.4

NLS_LANG

environmental variable, E.1

server-side parameter, E.1

NLS_LANG environment variable, E.2

non-interactive installation

oraInst.loc file, A.2

response files

preparing, A.3

templates, A.3

silent mode, A.3.2, A.4

errors, B.5

non-interactive installations

running

Oracle Universal Installer, A.4

number of cursors, DRDA_PACKAGE_SECTIONS, C.8.46

O

obsolete parameters since V4 gateway, 16.3.2

ODBC connectivity

specifying path to library, C.8.22

operating system

user ID for DB2/UDB, 13.3

option

binding packages, 14.3

DRDA session security, 15.4.1.1

security conduct, 15.4

service port number, DRDA_CONNECT_PARM, C.8.29

ORA_MAX_DATE parameter, C.8.54

ORA_NLS11 parameter, C.8.55

description, E.1

Oracle

RAW datatype, C.8.30

Oracle Database Gateway for ODBC

creating initialization file, 11.1.1

Oracle Net

configuring, 3.2, 5.2, 7.2, 9.2, 11.2, 14.2

operating system authentication, 15.2

Oracle Net Listener

starting, 3.2.2, 11.2.2

Oracle Universal Installer

using

to de-install the gateway, 17

ORACLE_DRDA_TCTL parameter

defined, C.8.56

ORACLE_DRDA_TRACE parameter, defined, C.8.57

ORACLE2PC table

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3, 13.3

DRDA_PACKAGE_OWNER, C.8.45

ORARECOV user ID

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

DRDA_RECOVERY_USERID, C.8.49

P

package

collection id, DRDA_PACKAGE_COLLID, C.8.42

consistency token, DRDA_PACKAGE_CONSTOKEN, C.8.43

privileges - BIND and EXECUTE, DB2/UDB, 13.3

privileges - BIND, COPY, and EXECUTE

DB2/OS390, 13.1

parameter

diagnostic, C.8.56

obsolete since V4 gateway, 16.3.2

parameter file

tailoring to configure the host, 14.1.2

parameters

DRDA_CODEPAGE_MAP

defined, C.8.27

mapping IBM CCSID, E.4

DRDA_RECOVERY_PASSWORD

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

DRDA_RECOVERY_USERID

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

FDS_CLASS, C.8.51

gateway initialization file

DRDA_CACHE_TABLE_DESC, C.8.25

DRDA_CAPABILITY, C.8.26

DRDA_CODEPAGE_MAP, C.8.27

DRDA_COMM_BUFLEN, C.8.28

DRDA_CONNECT_PARM (TCP/IP format), C.8.29

DRDA_DEFAULT_CCSID, C.8.30

DRDA_DESCRIBE_TABLE, C.8.31

DRDA_DISABLE_CALL, C.8.32

DRDA_FLUSH_CACHE, C.8.33

DRDA_GRAPHIC_LIT_CHECK, C.8.36

DRDA_GRAPHIC_PAD_SIZE, C.8.35

DRDA_GRAPHIC_TO_MBCS, C.8.37

DRDA_ISOLATION_LEVEL, C.8.38

DRDA_LOCAL_NODE_NAME, C.8.39

DRDA_MBCS_TO_GRAPHIC, C.8.40

DRDA_OPTIMIZE_QUERY, C.8.41

DRDA_PACKAGE_COLLID, C.8.42

DRDA_PACKAGE_CONSTOKEN, C.8.43

DRDA_PACKAGE_NAME, C.8.44

DRDA_PACKAGE_OWNER, C.8.45

DRDA_PACKAGE_SECTIONS, C.8.46

DRDA_READ_ONLY, C.8.47

DRDA_RECOVERY_PASSWORD, C.8.48

DRDA_RECOVERY_USERID, C.8.49

DRDA_REMOTE_DB_NAME, C.8.50

HS_FDS_FETCH_ROWS, C.8.24

HS_NLS_NCHAR, C.8.52

LOG_DESTINATION, C.8.53

ORA_MAX_DATE, C.8.54

ORA_NLS11, C.8.55

ORACLE_DRDA_TCTL, C.8.56

ORACLE_DRDA_TRACE, C.8.57

TRACE_LEVEL, C.8.58

LOG_DESTINATION, C.8.57

privileges

BIND

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDADD

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDAGENT

DB2/OS390, 13.1

CONNECT

DB2/UDB, 13.3

COPY

DB2/OS390, 13.1

CREATE IN

DB2/OS390, 13.1

CREATE PUBLIC DATABASE LINK, 14.4.2

CREATEIN

DB2/UDB, 13.3

CREATETAB

DB2/OS390, 13.1

DB2/UDB, 13.3

EXECUTE

DB2/OS390, 13.1

DB2/UDB, 13.3

R

RAW datatype

caution with DRDA_DEFAULT_CCSID, C.8.30

read-only gateway option

set with DRDA_READ_ONLY, C.8.47

rebind required with any change to

DRDA_DISABLE_CALL, C.8.32

DRDA_ISOLATION_LEVEL, C.8.38

DRDA_PACKAGE_COLLID, C.8.42

DRDA_PACKAGE_CONSTOKEN, C.8.43

DRDA_PACKAGE_NAME, C.8.44

DRDA_PACKAGE_OWNER, C.8.45

DRDA_PACKAGE_SECTIONS, C.8.46

recovery user ID and password

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

RECOVERY_ACCOUNT

account username, 3.5.1, 5.5.1, 7.5.1, 9.5.1

creating a recovery account, 3.5.1, 5.5.1, 7.5.1, 9.5.1

remote

database

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

DRDA_PACKAGE_SECTIONS, C.8.46

privileges of user/ID, D

DRDA database, DRDA_ISOLATION_LEVEL, C.8.38

transaction program

hardware memory requirements, 12.1.1

remote functions

referenced in SQL statements, C.8.1

requirements

hardware, 12.1.1

software, 12.1.2

S

sample

SQL scripts, 14.5

schema privileges - CREATEIN, 13.3

security

overview, 15.1

service port number, DRDA_CONNECT_PARM, C.8.29

shift attribute, multi-byte support, E.5

SID, 3.1.1, 5.1.1, 7.1.1, 9.1.1, 11.1.1

silent mode installation, A.3.2, A.4

software requirements, 12.1.2

SPUFI, a database native tool, 14

SQL

statements, DRDA_ISOLATION_LEVEL, C.8.38

stability, of cursor, DRDA_ISOLATION_LEVEL, C.8.38

Startup Shell Script

parameter, tailoring to configure the host, 14.1.2

statement

CREATE DATABASE, client/server configuration, E.2

stored procedure

usage, C.8.32

stored procedures

GTW$_BIND_PKG, 14.4.2

system privileges - BINDADD and BINDAGENT

DB2/OS390, 13.1

T

TCP/IP

concurrent connections, 12.1.1

DRDA_CONNECT_PARM, C.8.29

tnsnames.ora file, 17

token, package consistency, DRDA_PACKAGE_CONSTOKEN, C.8.43

trace control, C.8.56

TRACE_LEVEL parameter

defined, C.8.58

tracing

code, C.8.58

LOG_DESTINATION, C.8.53

ORACLE_DRDA_TRACE, C.8.57

Transaction log table

creating, 3.5.2, 5.5.2, 7.5.2, 9.5.2

transaction mode, read-only, DRDA_READ_ONLY, C.8.47

transform, character set transforms with multi-byte support, E.5

transform, not required for DRDA Server, E.5

troubleshooting, B

fatal errors, B.4.2

Two-phase commit

configuration, 3.5, 5.5, 7.5, 9.5

transaction log table, 3.5.2, 5.5.2, 7.5.2, 9.5.2

two-phase commit

ORACLE2PC table

DB2/400, 13.2

DB2/UDB, 13.3

ORACLE2PC table, DB2/OS390, 13.1

U

user ID mapping

DB2/400, 15.4.1.2

DB2/OS390, 15.4.1.1

X

X windows

display errors, B.1