Skip Headers
Oracle® Database Gateway Installation and Configuration Guide
11g Release 1 (11.1) for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

B31042-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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