Index

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

A

application
authenticating logons, 15.2
AS/400
command, DSPRDBDIRE, 13.2
library name, HS_FDS_PACKAGE_COLLID, C.8.27

B

BIND privilege
DB2 UDB for Linux, Unix, and Windows, 13.3
DB2 UDB for z/OS, 13.1
BINDADD authority
DB2 UDB for Linux, Unix, and Windows, 13.3
BINDADD privilege
DB2 UDB for z/OS, 13.1
BINDAGENT privilege
DB2 UDB for z/OS, 13.1

C

character sets
Heterogeneous Services, C.8.11.1
closing and opening again any session against db2 required with any change to
HS_FDS_PACKAGE_COLLID, C.8.27
collection privilege - CREATE IN
DB2 UDB for z/OS, 13.1
collection privilege - CREATETAB
DB2 UDB for z/OS, 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 UDB for iSeries, 13.2, 13.3
DB2 UDB for z/OS, 13.1
host workstation for gateway, 14.1.2
Configuring the gateway, 3.1, 5.1, 7.1, 9.1
CONNECT authority
DB2 UDB for Linux, Unix, and Windows, 13.3
connect_descriptor, 3.3.1, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
COPY privilege
DB2 UDB for z/OS, 13.1
CREATE IN privilege
DB2 UDB for Linux, Unix, and Windows, 13.3
DB2 UDB for z/OS, 13.1
CREATETAB authority
DB2 UDB for Linux, Unix, and Windows, 13.3
CREATETAB privilege
DB2 UDB for z/OS, 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.26

D

data dictionary
support, 14
database
link
defining and controlling, 15.3
Database link
behavior, 11.4
database link
behavior, 3.4, 5.4, 7.4, 9.4, 14.6
DB2
Distributed Data Facility (DDF), 13.1
SPUFI utility, 13.1
DB2 UDB for iSeries
configuring, 13.2
HS_FDS_ISOLATION_LEVEL, C.8.26
HS_FDS_PACKAGE_COLLID, C.8.27
user ID mapping, 15.4.1.2
DB2 UDB for Linux, Unix, and Windows
configuring, 13.3, 13.3
HS_FDS_ISOLATION_LEVEL, C.8.26
DB2 UDB for z/OS
configuring, 13.1
HS_FDS_ISOLATION_LEVEL, C.8.26
user ID mapping, 15.4.1.1
DDF
DB2 (Distributed Data Facility), 13.1
describe cache high water mark
definition, C.8.10
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
distributed
data facility (DDF), 13.1
operations, DB2, 13.1
transaction, HS_FDS_RECOVERY_ACCOUNT, C.8.20
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 UDB for z/OS, 13.1
Hostname or IP Address (configuring TCP/IP, worksheet), D
Service Port Number (configuring TCP/IP, worksheet), D
DSPRDBDIRE command, 13.2

E

Error messages
error tracing, C.8.22
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 UDB for Linux, Unix, and Windows, 13.3
DB2 UDB for z/OS, 13.1

F

fatal errors, B.4.2
fetch array size, with HS_FDS_FETCH_ROWS, C.8.24
files
oraInst.loc, A.2
response files, A.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.6, 3.7, 5.6, 7.6, 9.7
globalization support
Heterogeneous Services, C.8.11

H

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

I

IFILE initialization parameter, C.8.17
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
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
procedure, 1.6
response files, A.3
preparing, A.3
silent mode, B.5
templates, A.3
silent mode, A.3.2, A.4
IP name, 15.4.1.1
isolation level, HS_FDS_ISOLATION_LEVEL, C.8.26

L

listener, 3.3.1, 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.2, B.2
troubleshooting, B.3

M

mount point directories, 1.5.2.2

N

Net Configuration Assistant
troubleshooting, B.4
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

O

ODBC connectivity
specifying path to library, C.8.4
operating system
user ID for DB2 UDB for Linux, Unix, and Windows, 13.3
option
DRDA session security, 15.4.1.1
security conduct, 15.4
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, 3.3.1, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
starting, 3.2.2, 11.2.2

P

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

R

RECOVER user ID
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, Unix, and Windows, 13.3
DB2 UDB for z/OS, 13.1
HS_FDS_RECOVERY_ACCOUNT, C.8.20
recovery user ID and password
DB2 UDB for iSeries, 13.2
DB2 UDB for Linux, Unix, and Windows, 13.3
DB2 UDB for z/OS, 13.1
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 UDB for iSeries, 13.2
DB2 UDB for Linux, Unix, and Windows, 13.3
DB2 UDB for z/OS, 13.1
privileges of user/ ID, D
DRDA database, HS_FDS_ISOLATION_LEVEL, C.8.26
transaction program
hardware memory requirements, 12.1.1
remote functions
referenced in SQL statements, C.8.6
requirements
hardware, 12.1.1
software, 12.1.2

S

sample
SQL scripts, 14.4
schema privilege - CREATE IN
DB2 UDB for Linux, Unix, and Windows, 13.3
security
overview, 15.1
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, HS_FDS_ISOLATION_LEVEL, C.8.26
stability, of cursor, HS_FDS_ISOLATION_LEVEL, C.8.26
system privileges - BINDADD and BINDAGENT
DB2 UDB for z/OS, 13.1

T

TCP/IP
concurrent connections, 12.1.1
tnsnames.ora, 3.3.1, 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
configuring, 3.3.1, 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
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

U

user ID mapping
DB2 UDB for iSeries, 15.4.1.2
DB2 UDB for z/OS, 15.4.1.1

X

X windows
display errors, B.1