Index

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

A

action items, 2, 4, 6, 8, 10, 12

AIX

AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME, C.8.38

alias

DB2, C.8.30

application

authenticating logons, 15.2

AS/400

command DSPRDBDIRE, 13.2

defining user ID, 13.2

library name, DRDA_PACKAGE_COLLID, C.8.41

ASCII

codepage, E.3

US7ASCII, E.3.2.1

US7ASCII, Globalization Support, E.2

B

Basic installation method

noninteractive installations, A.4

Bind Package Stored Procedure

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

bind privilege

configuration worksheet, D

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDADD authority, binding packages on DB2/UDB, 14.3

BINDADD privilege

configuration worksheet, D

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDAGENT privilege

configuration worksheet, D

DB2/OS390, 13.1

binding the DRDA package

authority of user ID and password

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

C

CCSID

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

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

codepage mapping facility, E.4

DRDA server, Globalization Support, E.1

CHARACTER SET

clause, client/server configuration, E.2

parameter description, E.1

character sets

and codepage map facility, E.4

codepage, C.8.29

Heterogeneous Services, C.8.6.1

checklist

DRDA server configuration, 13

clauses

CHARACTER SET, client/server configuration, E.2

code tracing, C.8.57

codepage map facility

for data translation, E.4

collection privilege - CREATE IN

configuration worksheet, D

DB2/OS390, 13.1

collection privilege - CREATETAB, DB2/OS390, 13.1

Communication Database (CDB) tables, DDF, 13.1

configuration assistants

troubleshooting, B.4

configuration assistants, troubleshooting, B.4

Configuring

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

configuring

checklists for DRDA server, 13

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

list of parameters needed to configure the gateway, D

workstation for gateway, 14.1.2

Configuring the gateway, 3.1, 5.1, 7.1, 9.1, 14.1

CONNECT authority

binding packages on DB2/UDB, 14.3

DB2/UDB, 13.3

COPY

privilege

configuration worksheet, D

DB2/OS390, 13.1

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

CREATE IN privilege

configuration worksheet, D

DB2/OS390, 13.1

CREATE PUBLIC DATABASE LINK privilege

binding the DRDA gateway package, 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.45

stability, DRDA_ISOLATION_LEVEL, C.8.37

D

data dictionary

support, 14

database

authorities - CONNECT, BINDADD, and CREATETAB, 13.3

link

defining and controlling, 15.3

native tool, 14

Database Configuration Assistant (DBCA)

troubleshooting, B.4

Database link

behavior, 3.4, 11.4

database link

behavior, 5.4, 7.4, 9.4

dropping, when removing the gateway, 17

datatypes

RAW

DRDA_DEFAULT_CCSID, C.8.29

date formats

Heterogeneous Services, C.8.58

DB2

aliases, C.8.30

Distributed Data Facility (DDF), 13.1

DRDA_DESCRIBE_TABLE compatibility, C.8.30

SPUFI utility, 13.1

DB2/400

configuring the DRDA server, 13.2

defining user ID, 13.2

DRDA_DEFAULT_CCSID, C.8.29

DRDA_ISOLATION_LEVEL, C.8.37

DRDA_OPTIMIZE_QUERY, C.8.40

DRDA_PACKAGE_COLLID, C.8.41

user ID mapping, 15.4.1.2

DB2/OS390

configuring, 13.1

DRDA_ISOLATION_LEVEL, C.8.37

DRDA_OPTIMIZE_QUERY, C.8.40

user ID mapping, 15.4.1.1

with SPUFI, 14

DB2/UDB

configuring, 13.3

configuring the DRDA server, 13.3

DRDA_ISOLATION_LEVEL, C.8.37

DRDA_OPTIMIZE_QUERY, C.8.40

user ID mapping, 15.4.1.3

describe cache high water mark

definition, C.8.5

diagnostic parameter, C.8.55

disk space

checking, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

distributed

distributed query optimizer (DQO)

DRDA-specific parameters, C.8.40

operations, DB2, 13.1

transaction, DRDA_RECOVERY_USERID, C.8.48

double-byte support, E.5

DQO

DRDA-specific parameters, C.8.40

DRDA

session security options, 15.4.1.1

DRDA server

CCSID

character set to store data in DRDA database, E.1

gateway codepage map facility, E.4

parameters needed for Globalization Support, E.1

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 Server, Oracle Database Gateway, 12.1.1

DRDA, Oracle Database Gateway, 12.1.1

DRDA_CODEPAGE_MAP parameter, E.4

DRDA_COMM_BUFLEN parameter, C.8.27

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

DRDA_DEFAULT_CCSID parameter, C.8.29

DRDA_DESCRIBE_TABLE parameter

defined, C.8.30

DRDA_DISABLE_CALL parameter

defined, C.8.31

DRDA_FLUSH_CACHE parameter, C.8.32

DRDA_GRAPHIC_LIT_CHECK parameter, C.8.35

DRDA_GRAPHIC_PAD_SIZE parameter, C.8.34

DRDA_GRAPHIC_TO_MBCS parameter, C.8.36

DRDA_ISOLATION_LEVEL parameter, C.8.37

DRDA_LOCAL_NODE_NAME parameter, C.8.38

DRDA_MBCS_TO_GRAPHIC parameter, C.8.39

DRDA_OPTIMIZE_QUERY parameter

defined, C.8.40

DRDA_PACKAGE_COLLID parameter

defined, C.8.41

DRDA_PACKAGE_CONSTOKEN parameter, C.8.42

DRDA_PACKAGE_NAME parameter

defined, C.8.43

DRDA_PACKAGE_OWNER parameter, C.8.44

DRDA_PACKAGE_SECTIONS parameter

defined, C.8.45

DRDA_READ_ONLY parameter

defined, C.8.46

DRDA_RECOVER_USERID parameter

DB2/400, 13.2

DB2/OS390, 13.1

DRDA_RECOVERY_PASSWORD parameter

DB2/OS390, 13.1, 13.2

DB2/UDB, 13.3

defined, C.8.47

DRDA_RECOVERY_USERID parameter

DB2/400, 13.2

DB2/UDB, 13.3

defined, C.8.48

DRDA_REMOTE_DB_NAME parameter, C.8.49

DSPRDBDIRE command, 13.2

E

EBCDIC

character set support, E.3.2.1

codepage, E.3

DRDA server CCSID, E.7

environment

variable, NLS_LANG, E.2

environment variables

TEMP and TMP, hardware requirements, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

environmental variable

NLS_LANG, E.1

ORA_NLS33, 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

noninteractive installation, B.5

EXECUTE privilege

configuration worksheet, D

DB2/OS390, 13.1

DB2/UDB, 13.3

F

fatal errors, B.4.2

FDS_CLASS parameter, C.8.50

fetch array size, with HS_FDS_FETCH_ROWS, C.8.23

fetched date, C.8.53

file

InstallActions.log, 17

listener.ora, 17

tnsnames.ora, 17

files

Oracle Universal Installer log files, B.3

FOR BIT DATA

DRDA_DEFAULT_CCSID, C.8.29

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

logging, LOG_DESTINATION, C.8.52

supported languages

CCSID, E.1

codepage map facility, E.4

tracing

LOG_DESTINATION, C.8.52

gateway initialization file

parameter

reported errors, 14.4.2

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

Globalization Support

DRDA server character sets

codepage map facility, E.4

parameters needed for Globalization Support processing, E.1

initsid.ora parameters, E.3.2

overview, E

globalization support

Heterogeneous Services, C.8.6

date format, C.8.58

languages in character date values, C.8.59

Globalization Support parameters, configuration on client and Oracle databases, E.2

GTW$_BIND_PKG

configuring the host, 14.4.2

H

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.23

HS_FDS_PROC_IS_FUNC initialization parameter, C.8.16

HS_FDS_RECOVERY_PWD initialization parameter, C.8.22

HS_FDS_RESULTSET_SUPPORT initialization parameter, C.8.19

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

Globalization Support parameters for initsid.ora file, E.3.2.3

HS_NLS_DATE_FORMAT initialization parameter, C.8.58

HS_NLS_DATE_LANGUAGE, E.3.2.4

HS_NLS_DATE_LANGUAGE initialization parameter, C.8.59

HS_NLS_NCHAR

defined, C.8.51

parameters in the gateway initialization file, E.3.2.2

HS_NLS_NUMERIC_CHARACTER initialization parameter, C.8.60

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

Informix Server, Oracle Database Gateway, 4.1.1

Informix, Oracle Database Gateway, 4.1.1

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.gtw file

sample, 14.1.2

initsid.gtwboot

parameters moved to initsid.ora, 14.1.2

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

containing initsid.gwtboot parameters, 14.1.2

Globalization Support parameters, E.3.2

sample, 14.1.2

simplified syntax, see Appendix C, 14.1.2

tailoring, 14.1.2

InstallActions.log file, 17

installActions.log file, B.3

installation

accessing installation software, 1.5, 1.5.2

checklists

DRDA server, 13

downloading software from Oracle Technology Network, 1.5.1

errors

log session, B.3

while configuration assistant runs, B.4.2

log files, B.3

noninteractive error handling, B.5

procedure, 1.6

response files, B.5

reviewing a log of an installation session, B.3

troubleshooting, B, B.6

installation software, accessing, 1.5, 1.5.2

installations

log file, B.3

internal tracing, C.8.56

isolation level, DRDA_ISOLATION_LEVEL, C.8.37

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.3

reviewing an installation session, B.3

troubleshooting, B.3

LOG_DESTINATION parameter

defined, C.8.52

with ORACLE_DRDA_TRACE, C.8.56

logging, LOG_DESTINATION, C.8.52

M

multi-byte support, E.5

N

Net Configuration Assistant, troubleshooting, B.4

NLS

also see Globalization Support, E

NLS_LANG

environment variable

client-server configuration, E.2

parameters needed for Globalization Support processing, E.1

server-side parameter, E.1

noninteractive installation

errors, B.5

Record mode, A.4

See also noninteractive deinstallation, response files, A.1

number of cursors, DRDA_PACKAGE_SECTIONS, C.8.45

O

obsolete parameters since V4 gateway, 16.3.2

ODBC, Oracle Database Gateway, 10.1.1

option

binding packages, 14.3

DRDA session security, 15.4.1.1

security conduct, 15.4

service port number, DRDA_CONNECT_PARM, C.8.28

ORA_MAX_DATE parameter, C.8.53

ORA_NLS33 parameter, C.8.54

needed in system environment, E.1

Oracle

RAW datatype, C.8.29

Oracle Database Gateway

DRDA, 12.1.1

DRDA Server, 12.1.1

Informix, 4.1.1

Informix Server, 4.1.1

ODBC, 10.1.1

SQL Server, 8.1.1, 8.1.1, 8.1.1

Sybase, 2.1.1

Sybase Server, 2.1.1

Teradata Server, 6.1.1

Oracle Database Gateway for ODBC

creating initialization file, 11.1.1

Oracle Net

configuring, 3.2, 5.2, 7.2, 9.2, 11.2

operating system authentication, 15.2

Oracle Net Listener

starting, 3.2.2, 5.2.2, 7.2.2, 9.2.2, 11.2.2, 14.2.2

Oracle Technology Network (OTN)

accessing, 1.5.1

downloading software from, 1.5.1

Oracle Universal Installer

using

to remove the gateway, 17

Oracle Universal Installer (OUI)

log files, B.3

ORACLE_DRDA_TCTL parameter

defined, C.8.55

ORACLE_DRDA_TRACE parameter, defined, C.8.56

ORACLE2PC table

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

DRDA_PACKAGE_OWNER, C.8.44

ORARECOV user ID

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

DRDA_RECOVERY_USERID, C.8.48

OTN. See Oracle Technology Network, 1.5.1

P

package

collection id, DRDA_PACKAGE_COLLID, C.8.41

consistency token, DRDA_PACKAGE_CONSTOKEN, C.8.42

privileges - BIND and EXECUTE, DB2/UDB, 13.3

privileges - BIND, COPY, and EXECUTE

configuration worksheet, D

DB2/OS390, 13.1

parameter

diagnostic, C.8.55

list of parameters needed to configure the gateway, D

obsolete since V4 gateway, 16.3.2

parameters

DRDA_CODEPAGE_MAP

defined, C.8.26

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.50

gateway initialization file

DRDA_CACHE_TABLE_DESC, C.8.24

DRDA_CAPABILITY, C.8.25

DRDA_CODEPAGE_MAP, C.8.26

DRDA_COMM_BUFLEN, C.8.27

DRDA_CONNECT_PARM (TCP/IP format), C.8.28

DRDA_DEFAULT_CCSID, C.8.29

DRDA_DESCRIBE_TABLE, C.8.30

DRDA_DISABLE_CALL, C.8.31

DRDA_FLUSH_CACHE, C.8.32

DRDA_GRAPHIC_LIT_CHECK, C.8.35

DRDA_GRAPHIC_PAD_SIZE, C.8.34

DRDA_GRAPHIC_TO_MBCS, C.8.36

DRDA_ISOLATION_LEVEL, C.8.37

DRDA_LOCAL_NODE_NAME, C.8.38

DRDA_MBCS_TO_GRAPHIC, C.8.39

DRDA_OPTIMIZE_QUERY, C.8.40

DRDA_PACKAGE_COLLID, C.8.41

DRDA_PACKAGE_CONSTOKEN, C.8.42

DRDA_PACKAGE_NAME, C.8.43

DRDA_PACKAGE_OWNER, C.8.44

DRDA_PACKAGE_SECTIONS, C.8.45

DRDA_READ_ONLY, C.8.46

DRDA_RECOVERY_PASSWORD, C.8.47

DRDA_RECOVERY_USERID, C.8.48

DRDA_REMOTE_DB_NAME, C.8.49

HS_FDS_FETCH_ROWS, C.8.23

HS_NLS_NCHAR, C.8.51

LOG_DESTINATION, C.8.52

ORA_MAX_DATE, C.8.53

ORA_NLS33, C.8.54

ORACLE_DRDA_TCTL, C.8.55

ORACLE_DRDA_TRACE, C.8.56

TRACE_LEVEL, C.8.57

LOG_DESTINATION, C.8.56

privileges

BIND

configuration worksheet, D

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDADD

configuration worksheet, D

DB2/OS390, 13.1

DB2/UDB, 13.3

BINDAGENT

configuration worksheet, D

DB2/OS390, 13.1

CONNECT

DB2/UDB, 13.3

COPY

configuration worksheet, D

DB2/OS390, 13.1

CREATE IN

configuration worksheet, D

DB2/OS390, 13.1

CREATE PUBLIC DATABASE LINK

binding the DRDA gateway package, 14.4.2

CREATEIN

DB2/UDB, 13.3

CREATETAB

DB2/OS390, 13.1

DB2/UDB, 13.3

EXECUTE

configuration worksheet, D

DB2/OS390, 13.1

DB2/UDB, 13.3

R

RAW datatype

caution with DRDA_DEFAULT_CCSID, C.8.29

read-only gateway option

set with DRDA_READ_ONLY, C.8.46

rebind required with any change to

DRDA_DISABLE_CALL, C.8.31

DRDA_ISOLATION_LEVEL, C.8.37

DRDA_PACKAGE_COLLID, C.8.41

DRDA_PACKAGE_CONSTOKEN, C.8.42

DRDA_PACKAGE_NAME, C.8.43

DRDA_PACKAGE_OWNER, C.8.44

DRDA_PACKAGE_SECTIONS, C.8.45

recovery user ID and password

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

RECOVERY_ACCOUNT

account user name, 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

configuration worksheet, D

DB2/400, 13.2

DB2/OS390, 13.1

DB2/UDB, 13.3

DRDA_PACKAGE_SECTIONS, C.8.45

DRDA database, DRDA_ISOLATION_LEVEL, C.8.37

remote functions

referenced in SQL statements, C.8.1

response files

creating, A.4

customizing, A.3

samples, A.3

specifying during installation, A.5

See also noninteractive installation, A.2

S

sample

files

initsid.gtw, 14.1.2

initsid.ora, 14.1.2

schema privileges - CREATEIN, 13.3

security

overview, 15.1

service port number, DRDA_CONNECT_PARM, C.8.28

shift attribute, multi-byte support, E.5

SID, 3.1.1, 5.1.1, 7.1.1, 9.1.1, 11.1.1

silent installation. See noninteractive installation, A.1

SPUFI on DB2/OS390, 14

SQL

statements, DRDA_ISOLATION_LEVEL, C.8.37

SQL Server, Oracle Database Gateway, 8.1.1, 8.1.1

SQL Server,Oracle Database Gateway, 8.1.1

stability, of cursor, DRDA_ISOLATION_LEVEL, C.8.37

statements

CREATE DATABASE, client/server configuration, E.2

stored procedure

GTW$_BIND_PKG, 14.4.2

usage, C.8.31

Sybase Server, Oracle Database Gateway, 2.1.1

Sybase, Oracle Database Gateway, 2.1.1

system privileges - BINDADD and BINDAGENT

configuration worksheet, D

DB2/OS390, 13.1

T

TCP/IP

DRDA_CONNECT_PARM, C.8.28

TEMP

environment variable, hardware requirements, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

temporary directory, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

temporary disk space

checking, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

freeing, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

Teradata Server, Oracle Database Gateway, 6.1.1

tmp directory

checking space in, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

freeing space in, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

TMP environment variable, hardware requirements, 2.1.1.1, 4.1.1.1, 6.1.1.1, 8.1.1.1, 10.1.1.1, 12.1.1.1

tnsnames.ora file, 17

token, package consistency, DRDA_PACKAGE_CONSTOKEN, C.8.42

trace control, C.8.55

TRACE_LEVEL parameter

defined, C.8.57

tracing

code, C.8.57

LOG_DESTINATION, C.8.52

ORACLE_DRDA_TRACE, C.8.56

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.46

transform

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

not required for DRDA server, E.5

troubleshooting, B, B.6

fatal errors, B.4.2

Inventory log files, B.3

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/OS390, 13.1

DB2/UDB, 13.3

U

user ID mapping

DB2/400, 15.4.1.2

DB2/OS390, 15.4.1.1