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