Skip Headers
Oracle® Database Gateway Installation and Configuration Guide
11g Release 2 (11.2) for Microsoft Windows

Part Number E12061-06
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  N  O  P  R  S  T  U 

A

action items, 2, 4, 6, 8, 10, 12
application
authenticating logons, 15.2
AS/400
command DSPRDBDIRE, 13.2
defining user ID, 13.2
library name, HS_FDS_PACKAGE_COLLID, C.8.26

B

Basic installation method
noninteractive installations, A.4
Bind Package Stored Procedure
DB2 UDB for iSeries, 13.2
DB2/OS390, 13.1
bind privilege
configuration worksheet, D
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
BINDADD privilege
configuration worksheet, D
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
BINDAGENT privilege
configuration worksheet, D
DB2/OS390, 13.1
binding the DRDA package
authority of user ID and password
DB2 UDB for iSeries, 13.2
DB2/OS390, 13.1

C

character sets
Heterogeneous Services, C.8.6.1
checklist
DRDA server configuration, 13
closing and opening again any session against db2 required with any change to
HS_FDS_PACKAGE_COLLID, C.8.26
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 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
list of parameters needed to configure the gateway, D
Configuring the gateway, 3.1, 5.1, 7.1, 9.1, 14.1
CONNECT authority
DB2 UDB for Linux, UNIX, and Windows, 13.3
connect_descriptor, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
COPY
privilege
configuration worksheet, D
DB2/OS390, 13.1
CREATE IN privilege
configuration worksheet, D
DB2/OS390, 13.1
CREATEIN privilege, DB2 UDB for Linux, UNIX, and Windows, 13.3
CREATETAB privilege
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
Creating
transaction log table, 3.5.2, 5.5.2, 7.5.2, 9.5.2
cursor
stability, HS_FDS_ISOLATION_LEVEL, C.8.25

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
DB2
Distributed Data Facility (DDF), 13.1
SPUFI utility, 13.1
DB2 UDB for iSeries
configuring the DRDA server, 13.2
defining user ID, 13.2
HS_FDS_ISOLATION_LEVEL, C.8.25
HS_FDS_PACKAGE_COLLID, C.8.26
user ID mapping, 15.4.1.2
DB2 UDB for Linux, Unix, and Window
with SPUFI, 14
DB2 UDB for Linux, UNIX, and Windows
configuring, 13.3
configuring the DRDA server, 13.3
DB2 UDB for Linux, Unix, and Windows
HS_FDS_ISOLATION_LEVEL, C.8.25
user ID mapping, 15.4.1.3
DB2 UDB for z/OS
HS_FDS_ISOLATION_LEVEL, C.8.25
DB2/OS390
configuring, 13.1
user ID mapping, 15.4.1.1
describe cache high water mark
definition, C.8.5
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
operations, DB2, 13.1
transaction, HS_FDS_RECOVERY_ACCOUNT, C.8.17
DRDA
session security options, 15.4.1.1
DRDA server
configuring
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
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
DSPRDBDIRE command, 13.2

E

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
error
obsolete parameters, 16.3.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 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1

F

fatal errors, B.4.2
fetch array size, with HS_FDS_FETCH_ROWS, C.8.23
files
Oracle Universal Installer log files, B.3

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
Gateway Password Encryption Tool, 3.7, 5.6, 7.6, 9.7, 11.5
globalization support
Heterogeneous Services, C.8.6

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_ISOLATION_LEVEL parameter, C.8.25
HS_FDS_PACKAGE_COLLID parameter
defined, C.8.26
HS_FDS_PROC_IS_FUNC initialization parameter, C.8.16
HS_FDS_RECOVERY_ACCOUNT parameter
DB2 UDB for iSeries, 13.2, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
HS_FDS_RECOVERY_PWD initialization parameter, C.8.22
HS_FDS_RECOVERY_PWD parameter
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1, 13.2
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_KEEP_REMOTE_COLUMN_SIZE initialization parameter, C.8.33
HS_LANGUAGE initialization parameter, C.8.6
HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, C.8.7
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
HS_TRANSACTION_LOG table
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3

I

IFILE initialization parameter, C.8.13
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.ora file, 3.1.2, 5.1.2, 7.1.2, 9.1.2
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
isolation level, HS_FDS_ISOLATION_LEVEL, C.8.25

L

listener, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
listener.ora file, 3.8.2, 5.7.2, 7.7.2, 9.8.2, 11.6.2, 14.7.2
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

N

Net Configuration Assistant, troubleshooting, B.4
noninteractive installation
errors, B.5
Record mode, A.4
See also noninteractive deinstallation, response files, A.1

O

obsolete parameters since V4 gateway, 16.3.2
ODBC, Oracle Database Gateway, 10.1.1
option
DRDA session security, 15.4.1.1
security conduct, 15.4
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, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
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 (OUI)
log files, B.3
OTN. See Oracle Technology Network, 1.5.1

P

package
collection id, HS_FDS_PACKAGE_COLLID, C.8.26
privileges - BIND and EXECUTE, DB2 UDB for Linux, UNIX, and Windows, 13.3
privileges - BIND, COPY, and EXECUTE
configuration worksheet, D
DB2/OS390, 13.1
parameter
list of parameters needed to configure the gateway, D
obsolete since V4 gateway, 16.3.2
parameters
gateway initialization file
HS_FDS_CAPABILITY, C.8.24
HS_FDS_FETCH_ROWS, C.8.23
HS_FDS_ISOLATION_LEVEL, C.8.25
HS_FDS_PACKAGE_COLLID, C.8.26
HS_FDS_RECOVERY_ACCOUNT
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
HS_FDS_RECOVERY_PWD
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
privileges
BIND
configuration worksheet, D
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
BINDADD
configuration worksheet, D
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
BINDAGENT
configuration worksheet, D
DB2/OS390, 13.1
CONNECT
DB2 UDB for Linux, UNIX, and Windows, 13.3
COPY
configuration worksheet, D
DB2/OS390, 13.1
CREATE IN
configuration worksheet, D
DB2/OS390, 13.1
CREATEIN
DB2 UDB for Linux, UNIX, and Windows, 13.3
CREATETAB
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
EXECUTE
configuration worksheet, D
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1

R

RECOVER user ID
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
HS_FDS_RECOVERY_ACCOUNT, C.8.17
recovery user ID and password
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
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 UDB for iSeries, 13.2
DB2 UDB for Linux, UNIX, and Windows, 13.3
DB2/OS390, 13.1
DRDA database, HS_FDS_ISOLATION_LEVEL, C.8.25
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

schema privileges - CREATEIN, 13.3
security
overview, 15.1
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, HS_FDS_ISOLATION_LEVEL, C.8.25
SQL Server, Oracle Database Gateway, 8.1.1, 8.1.1
SQL Server,Oracle Database Gateway, 8.1.1
stability, of cursor, HS_FDS_ISOLATION_LEVEL, C.8.25
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

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, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
configuring, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
multiple listeners, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
Transaction log table
creating, 3.5.2, 5.5.2, 7.5.2, 9.5.2
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
HS_TRANSACTION_LOG table
DB2 UDB for iSeries, 13.2

U

user ID mapping
DB2 UDB for iSeries, 15.4.1.2
DB2/OS390, 15.4.1.1