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