Database Gateway Installation and Configuration Guide
ContentsOpens a new window
Opens a new window
Page 35 of 35

Index

AOpens a new window  BOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  FOpens a new window  GOpens a new window  HOpens a new window  IOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  ROpens a new window  SOpens a new window  TOpens a new window  UOpens a new window  XOpens a new window 

A

APOpens a new window  ASOpens a new window 
application
authenticating logons, 15.2Opens a new window
AS/400
command, DSPRDBDIRE, 13.2Opens a new window
library name, HS_FDS_PACKAGE_COLLID, C.8.26Opens a new window

B

BIOpens a new window 
BIND privilege
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
BINDADD authority
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
BINDADD privilege
DB2 UDB for z/OS, 13.1Opens a new window
BINDAGENT privilege
DB2 UDB for z/OS, 13.1Opens a new window

C

CHOpens a new window  CLOpens a new window  COOpens a new window  CROpens a new window  CUOpens a new window 
character sets
Heterogeneous Services, C.8.11.1Opens a new window
closing and opening again any session against db2 required with any change to
HS_FDS_PACKAGE_COLLID, C.8.26Opens a new window
collection privilege - CREATE IN
DB2 UDB for z/OS, 13.1Opens a new window
collection privilege - CREATETAB
DB2 UDB for z/OS, 13.1Opens a new window
Communication Database (CDB) tables, DDF, 13.1Opens a new window
concurrent connections
TCP/IP, 12.1.1Opens a new window
configuration assistants
troubleshooting, B.4Opens a new window, B.4Opens a new window
configuring
DB2 UDB for iSeries, 13.2Opens a new window, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
host workstation for gateway, 14.1.2Opens a new window
Configuring
two-phase commit, 3.5Opens a new window, 5.5Opens a new window, 7.5Opens a new window, 9.5Opens a new window
Configuring the gateway, 3.1Opens a new window, 5.1Opens a new window, 7.1Opens a new window, 9.1Opens a new window
CONNECT authority
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
connect_descriptor, 3.3.1Opens a new window, 3.3.2Opens a new window, 5.3.2Opens a new window, 7.3.2Opens a new window, 9.3.2Opens a new window, 11.3.2Opens a new window, 14.5.2Opens a new window
COPY privilege
DB2 UDB for z/OS, 13.1Opens a new window
CREATE IN privilege
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
CREATETAB authority
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
CREATETAB privilege
DB2 UDB for z/OS, 13.1Opens a new window
Creating
transaction log table, 3.5.2Opens a new window, 5.5.2Opens a new window, 7.5.2Opens a new window, 9.5.2Opens a new window
cursor
stability, HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window

D

DAOpens a new window  DBOpens a new window  DDOpens a new window  DEOpens a new window  DIOpens a new window  DROpens a new window  DSOpens a new window 
data dictionary
support, 14Opens a new window
database
link
defining and controlling, 15.3Opens a new window
database link
behavior, 3.4Opens a new window, 5.4Opens a new window, 7.4Opens a new window, 9.4Opens a new window, 14.6Opens a new window
Database link
behavior, 11.4Opens a new window
DB2
Distributed Data Facility (DDF), 13.1Opens a new window
SPUFI utility, 13.1Opens a new window
DB2 UDB for iSeries
configuring, 13.2Opens a new window
HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window
HS_FDS_PACKAGE_COLLID, C.8.26Opens a new window
user ID mapping, 15.4.1.2Opens a new window
DB2 UDB for Linux, Unix, and Windows
configuring, 13.3Opens a new window, 13.3Opens a new window
HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window
DB2 UDB for z/OS
configuring, 13.1Opens a new window
HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window
user ID mapping, 15.4.1.1Opens a new window
DDF
DB2 (Distributed Data Facility), 13.1Opens a new window
describe cache high water mark
definition, C.8.10Opens a new window
Destination Hostname or IP Address, same as DRDA server Hostname or IP Address (configuring TCP/IP, worksheet), DOpens a new window
Destination Service Port Number, same as DRDA Server Service Port Number (configuring TCP/IP, worksheet), DOpens a new window
distributed
data facility (DDF), 13.1Opens a new window
operations, DB2, 13.1Opens a new window
transaction, HS_FDS_RECOVERY_ACCOUNT, C.8.19Opens a new window
DRDA
session security options, 15.4.1.1Opens a new window
DRDA server
configuring
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
Hostname or IP Address (configuring TCP/IP, worksheet), DOpens a new window
Service Port Number (configuring TCP/IP, worksheet), DOpens a new window
DSPRDBDIRE command, 13.2Opens a new window

E

EROpens a new window  EXOpens a new window 
Error messages
error tracing, C.8.21Opens a new window
errors
configuration assistants, B.4Opens a new window
installation, B.3Opens a new window, B.4.2Opens a new window
non-interactive installation, B.5Opens a new window
silent mode, B.5Opens a new window
X windows, B.1Opens a new window
EXECUTE privilege
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window

F

FAOpens a new window  FEOpens a new window  FIOpens a new window 
fatal errors, B.4.2Opens a new window
fetch array size, with HS_FDS_FETCH_ROWS, C.8.23Opens a new window
files
oraInst.loc, A.2Opens a new window
response files, A.3Opens a new window

G

GAOpens a new window  GLOpens a new window 
gateway
authenticating logons, 15.2Opens a new window
Gateway
default SID, 3.1.1Opens a new window, 5.1.1Opens a new window, 7.1.1Opens a new window, 9.1.1Opens a new window
system identifier (SID), 3.1.1Opens a new window, 5.1.1Opens a new window, 7.1.1Opens a new window, 9.1.1Opens a new window, 11.1.1Opens a new window
two-phase commit, 3.5Opens a new window, 5.5Opens a new window, 7.5Opens a new window, 9.5Opens a new window
Gateway Password Encryption Tool, 3.6Opens a new window, 3.7Opens a new window, 5.6Opens a new window, 7.6Opens a new window, 9.7Opens a new window
globalization support
Heterogeneous Services, C.8.11Opens a new window

H

HAOpens a new window  HEOpens a new window  HSOpens a new window 
hardware requirements, 12.1.1Opens a new window
Heterogeneous Services
defining maximum number of open cursors, C.8.13Opens a new window
initialization parameters, 11.1.1Opens a new window
optimizing data transfer, C.8.14Opens a new window
Oracle Database Gateway for ODBC
creating initialization file, 11.1.1Opens a new window
setting global name, C.8.9Opens a new window
specifying cache high water mark, C.8.10Opens a new window
tuning internal data buffering, C.8.15Opens a new window
tuning LONG data transfer, C.8.12Opens a new window
HS_CALL_NAME initialization parameter, C.8.6Opens a new window
HS_DB_NAME initialization parameter, C.8.9Opens a new window
HS_DESCRIBE_CACHE_HWM initialization parameter, C.8.10Opens a new window
HS_FDS_AUTHENTICATE_METHOD, C.8.41Opens a new window
HS_FDS_CONNECT_INFO, C.8.18Opens a new window
HS_FDS_CONNECT_INFO initialization parameter
specifying connection information, 11.1.2Opens a new window
HS_FDS_FETCH_ROWS parameter, C.8.23Opens a new window
HS_FDS_ISOLATION_LEVEL parameter, C.8.25Opens a new window
HS_FDS_PACKAGE_COLLID parameter
defined, C.8.26Opens a new window
HS_FDS_PROC_IS_FUNC initialization parameter, C.8.2Opens a new window
HS_FDS_RECOVER_ACCOUNT
if the user ID is not specified, 13.3Opens a new window
HS_FDS_RECOVERY_ACCOUNT
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
HS_FDS_RECOVERY_ACCOUNT parameter
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
defining the recovery user ID, 13.3Opens a new window
HS_FDS_RECOVERY_PWD initialization parameter, C.8.5Opens a new window
HS_FDS_RECOVERY_PWD parameter
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
defining the recovery user ID, 13.3Opens a new window
HS_FDS_RESULTSET_SUPPORT initialization parameter, C.8.3Opens a new window
HS_FDS_SHAREABLE_NAME initialization parameter, C.8.4Opens a new window
HS_FDS_TRACE_LEVEL initialization parameter, C.8.21Opens a new window
enabling agent tracing, C.1Opens a new window
HS_FDS_TRANSACTION_LOG initialization parameter, C.8.22Opens a new window
HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter, C.8.35Opens a new window
HS_LANGUAGE initialization parameter, C.8.11Opens a new window
HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, C.8.12Opens a new window
HS_OPEN_CURSORS initialization parameter, C.8.13Opens a new window
HS_RPC_FETCH_REBLOCKING initialization parameter, C.8.14Opens a new window
HS_RPC_FETCH_SIZE initialization parameter, C.8.15Opens a new window
HS_TIME_ZONE initialization parameter, C.8.1Opens a new window
HS_TRANSACTION_LOG, 3.5.2Opens a new window, 5.5.2Opens a new window, 7.5.2Opens a new window, 9.5.2Opens a new window

I

IFOpens a new window  INOpens a new window  IPOpens a new window  ISOpens a new window 
IFILE initialization parameter, C.8.17Opens a new window
inbound connections
processing, 15.4Opens a new window
Initialization parameter file
customizing, 3.1.2Opens a new window, 5.1.2Opens a new window, 7.1.2Opens a new window, 9.1.2Opens a new window, COpens a new window
initialization parameters
Heterogeneous Services (HS), 11.1.1Opens a new window
initialization parameters (HS)
Oracle Database Gateway for ODBC, 11.1.1Opens a new window
initsid.ora file, 3.1.2Opens a new window, 5.1.2Opens a new window, 7.1.2Opens a new window, 9.1.2Opens a new window
installation
errors, B.3Opens a new window, B.4.2Opens a new window
silent mode, B.5Opens a new window
log files, B.2Opens a new window, B.2Opens a new window
non-interactive
error handling, B.5Opens a new window
oraInst.loc file, A.2Opens a new window
procedure, 1.6Opens a new window
response files, A.3Opens a new window
preparing, A.3Opens a new window
silent mode, B.5Opens a new window
templates, A.3Opens a new window
silent mode, A.3.2Opens a new window, A.4Opens a new window
IP name, 15.4.1.1Opens a new window
isolation level, HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window

L

LIOpens a new window  LOOpens a new window 
listener, 3.3.1Opens a new window, 3.3.2Opens a new window, 5.3.2Opens a new window, 7.3.2Opens a new window, 9.3.2Opens a new window, 11.3.2Opens a new window, 14.5.2Opens a new window
listener.ora file, 3.8.2Opens a new window, 5.7.2Opens a new window, 7.7.2Opens a new window, 9.8.2Opens a new window, 11.6.2Opens a new window, 14.7.2Opens a new window
example, 3.2.1.1Opens a new window, 5.2.1.1Opens a new window, 7.2.1.1Opens a new window, 9.2.1.1Opens a new window, 11.2.1.1Opens a new window, 14.2.1.1Opens a new window
location, 3.2.1Opens a new window, 5.2.1Opens a new window, 7.2.1Opens a new window, 9.2.1Opens a new window, 11.2.1Opens a new window, 14.2.1Opens a new window
log files, B.2Opens a new window, B.2Opens a new window
troubleshooting, B.3Opens a new window

M

MOOpens a new window 
mount point directories, 1.5.2Opens a new window

N

NEOpens a new window  NOOpens a new window 
Net Configuration Assistant
troubleshooting, B.4Opens a new window
non-interactive installation
oraInst.loc file, A.2Opens a new window
response files
preparing, A.3Opens a new window
templates, A.3Opens a new window
silent mode, A.3.2Opens a new window, A.4Opens a new window
errors, B.5Opens a new window
non-interactive installations
running
Oracle Universal Installer, A.4Opens a new window

O

ODOpens a new window  OPOpens a new window  OROpens a new window 
ODBC connectivity
specifying path to library, C.8.4Opens a new window
operating system
user ID for DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
option
DRDA session security, 15.4.1.1Opens a new window
security conduct, 15.4Opens a new window
Oracle Database Gateway for ODBC
creating initialization file, 11.1.1Opens a new window
Oracle Net
configuring, 3.2Opens a new window, 5.2Opens a new window, 7.2Opens a new window, 9.2Opens a new window, 11.2Opens a new window, 14.2Opens a new window
operating system authentication, 15.2Opens a new window
Oracle Net Listener, 3.3.1Opens a new window, 3.3.2Opens a new window, 5.3.2Opens a new window, 7.3.2Opens a new window, 9.3.2Opens a new window, 11.3.2Opens a new window, 14.5.2Opens a new window
starting, 3.2.2Opens a new window, 11.2.2Opens a new window

P

PAOpens a new window  PROpens a new window 
package
collection id, HS_FDS_PACKAGE_COLLID, C.8.26Opens a new window
privileges - BIND and EXECUTE
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
privileges - BIND, COPY, and EXECUTE
DB2 UDB for z/OS, 13.1Opens a new window
parameters
gateway initialization file
HS_FDS_CAPABILITY, C.8.24Opens a new window
HS_FDS_FETCH_ROWS, C.8.23Opens a new window
HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window
HS_FDS_PACKAGE_COLLID, C.8.26Opens a new window
HS_FDS_RECOVERY_ACCOUNT
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
HS_FDS_RECOVERY_PWD
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
privileges
BIND
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
BINDADD
DB2 UDB for z/OS, 13.1Opens a new window
BINDAGENT
DB2 UDB for z/OS, 13.1Opens a new window
COPY
DB2 UDB for z/OS, 13.1Opens a new window
CREATE IN
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
CREATETAB
DB2 UDB for z/OS, 13.1Opens a new window
EXECUTE
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window

R

REOpens a new window 
RECOVER user ID
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
HS_FDS_RECOVERY_ACCOUNT, C.8.19Opens a new window
recovery user ID and password
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
RECOVERY_ACCOUNT
account username, 3.5.1Opens a new window, 5.5.1Opens a new window, 7.5.1Opens a new window, 9.5.1Opens a new window
creating a recovery account, 3.5.1Opens a new window, 5.5.1Opens a new window, 7.5.1Opens a new window, 9.5.1Opens a new window
remote
database
DB2 UDB for iSeries, 13.2Opens a new window
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
DB2 UDB for z/OS, 13.1Opens a new window
privileges of user/ ID, DOpens a new window
DRDA database, HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window
transaction program
hardware memory requirements, 12.1.1Opens a new window
remote functions
referenced in SQL statements, C.8.6Opens a new window
requirements
hardware, 12.1.1Opens a new window
software, 12.1.2Opens a new window

S

SAOpens a new window  SCOpens a new window  SEOpens a new window  SIOpens a new window  SOOpens a new window  SPOpens a new window  SQOpens a new window  STOpens a new window  SYOpens a new window 
sample
SQL scripts, 14.4Opens a new window
schema privilege - CREATE IN
DB2 UDB for Linux, Unix, and Windows, 13.3Opens a new window
security
overview, 15.1Opens a new window
SID, 3.1.1Opens a new window, 5.1.1Opens a new window, 7.1.1Opens a new window, 9.1.1Opens a new window, 11.1.1Opens a new window
silent mode installation, A.3.2Opens a new window, A.4Opens a new window
software requirements, 12.1.2Opens a new window
SPUFI, a database native tool, 14Opens a new window
SQL
statements, HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window
stability, of cursor, HS_FDS_ISOLATION_LEVEL, C.8.25Opens a new window
system privileges - BINDADD and BINDAGENT
DB2 UDB for z/OS, 13.1Opens a new window

T

TCOpens a new window  TNOpens a new window  TROpens a new window  TWOpens a new window 
TCP/IP
concurrent connections, 12.1.1Opens a new window
tnsnames.ora, 3.3.1Opens a new window, 3.3.2Opens a new window, 5.3.2Opens a new window, 7.3.2Opens a new window, 9.3.2Opens a new window, 11.3.2Opens a new window, 14.5.2Opens a new window
configuring, 3.3.1Opens a new window, 3.3.2Opens a new window, 5.3.2Opens a new window, 7.3.2Opens a new window, 9.3.2Opens a new window, 11.3.2Opens a new window, 14.5.2Opens a new window
multiple listeners, 3.3.2Opens a new window, 5.3.2Opens a new window, 7.3.2Opens a new window, 9.3.2Opens a new window, 11.3.2Opens a new window, 14.5.2Opens a new window
Transaction log table
creating, 3.5.2Opens a new window, 5.5.2Opens a new window, 7.5.2Opens a new window, 9.5.2Opens a new window
troubleshooting, BOpens a new window
fatal errors, B.4.2Opens a new window
Two-phase commit
configuration, 3.5Opens a new window, 5.5Opens a new window, 7.5Opens a new window, 9.5Opens a new window
transaction log table, 3.5.2Opens a new window, 5.5.2Opens a new window, 7.5.2Opens a new window, 9.5.2Opens a new window

U

USOpens a new window 
user ID mapping
DB2 UDB for iSeries, 15.4.1.2Opens a new window
DB2 UDB for z/OS, 15.4.1.1Opens a new window

X

X windows
display errors, B.1Opens a new window
Previous PageOpens a new window
Page 35 of 35
Next Page