Index

A

action items 1, 2, 3, 4, 5, 6
application
- authenticating logons 1
AS/400
- command DSPRDBDIRE 1
- defining user ID 1
- library name, HS_FDS_PACKAGE_COLLID 1

B

Basic installation method
- noninteractive installations 1
BINDADD privilege
- configuration worksheet 1
- DB2/OS390 1
- DB2 UDB for Linux, UNIX, and Windows 1
BINDAGENT privilege
- configuration worksheet 1
- DB2/OS390 1
binding the DRDA package
- authority of user ID and password
  - DB2/OS390 1
  - DB2 UDB for iSeries 1
Bind Package Stored Procedure
- DB2/OS390 1
- DB2 UDB for iSeries 1
bind privilege
- configuration worksheet 1
- DB2/OS390 1
- DB2 UDB for iSeries 1
- DB2 UDB for Linux, UNIX, and Windows 1

C

character sets
- Heterogeneous Services 1
checklist
- DRDA server configuration 1
closing and opening again any session against db2 required with any change to
- HS_FDS_PACKAGE_COLLID 1
collection privilege - CREATE IN
- configuration worksheet 1
- DB2/OS390 1
collection privilege - CREATETAB, DB2/OS390 1
Communication Database (CDB) tables, DDF 1
configuration assistants
- troubleshooting 1
configuration assistants, troubleshooting 1
configuring
- checklists for DRDA server 1
- DB2/OS390 1
- DB2 UDB for iSeries 1
- DB2 UDB for Linux, UNIX, and Windows 1
- list of parameters needed to configure the gateway 1
Configuring
- two-phase commit 1, 2, 3, 4
Configuring the gateway 1, 2, 3, 4, 5
connect_descriptor 1, 2, 3, 4, 5, 6
CONNECT authority
- DB2 UDB for Linux, UNIX, and Windows 1
COPY
- privilege
  - configuration worksheet 1
  - DB2/OS390 1
CREATE IN privilege
- configuration worksheet 1
- DB2/OS390 1
CREATEIN privilege, DB2 UDB for Linux, UNIX, and Windows 1
CREATETAB privilege
- DB2/OS390 1
- DB2 UDB for Linux, UNIX, and Windows 1
Creating
- transaction log table 1, 2, 3, 4
cursor
- stability, HS_FDS_ISOLATION_LEVEL 1

D

database
- authorities - CONNECT, BINDADD, and CREATETAB 1
- link
  - defining and controlling 1
- native tool 1
Database Configuration Assistant (DBCA)
- troubleshooting 1
database link
- behavior 1, 2, 3
Database link
- behavior 1, 2
data dictionary
- support 1
DB2
- Distributed Data Facility (DDF) 1
- SPUFI utility 1
DB2/OS390
- configuring 1
DB2 UDB for iSeries
- configuring the DRDA server 1
- defining user ID 1
- HS_FDS_ISOLATION_LEVEL 1
- HS_FDS_PACKAGE_COLLID 1
DB2 UDB for Linux, Unix, and Window
- with SPUFI 1
DB2 UDB for Linux, Unix, and Windows
- HS_FDS_ISOLATION_LEVEL 1
DB2 UDB for Linux, UNIX, and Windows
- configuring 1
- configuring the DRDA server 1
DB2 UDB for z/OS
- HS_FDS_ISOLATION_LEVEL 1
describe cache high water mark
- definition 1
disk space
- checking 1, 2, 3, 4, 5, 6
distributed
- operations, DB2 1
- transaction, HS_FDS_RECOVERY_ACCOUNT 1
DRDA, Oracle Database Gateway 1
DRDA server
- configuring
  - DB2/OS390 1
  - DB2 UDB for iSeries 1
  - DB2 UDB for Linux, UNIX, and Windows 1
- Hostname or IP Address (configuring TCP/IP, worksheet) 1
- Service Port Number (configuring TCP/IP, worksheet) 1
DRDA Server, Oracle Database Gateway 1
DSPRDBDIRE command 1

E

environment variables
- TEMP and TMP, hardware requirements 1, 2, 3, 4, 5, 6
error
- obsolete parameters 1
Error messages
- error tracing 1
errors
- configuration assistants 1
- installation 1, 2
- noninteractive installation 1
EXECUTE privilege
- configuration worksheet 1
- DB2/OS390 1
- DB2 UDB for Linux, UNIX, and Windows 1

F

fatal errors 1
fetch array size, with HS_FDS_FETCH_ROWS 1
files
- Oracle Universal Installer log files 1

G

gateway
- authenticating logons 1
Gateway
- default SID 1, 2, 3, 4
- system identifier (SID) 1, 2, 3, 4, 5
- two-phase commit 1, 2, 3, 4
Gateway Password Encryption Tool 1, 2, 3, 4, 5
globalization support
- Heterogeneous Services 1

H

Heterogeneous Services
- defining maximum number of open cursors 1
- initialization parameters 1
- optimizing data transfer 1
- Oracle Database Gateway for ODBC
  - creating initialization file 1
- setting global name 1
- specifying cache high water mark 1
- tuning internal data buffering 1
- tuning LONG data transfer 1
HS_CALL_NAME initialization parameter 1
HS_DB_NAME initialization parameter 1
HS_DESCRIBE_CACHE_HWM initialization parameter 1
HS_FDS_CONNECT_INFO 1
HS_FDS_FETCH_ROWS parameter 1
HS_FDS_ISOLATION_LEVEL parameter 1
HS_FDS_PACKAGE_COLLID parameter
- defined 1
HS_FDS_PROC_IS_FUNC initialization parameter 1
HS_FDS_RECOVERY_ACCOUNT parameter
- DB2/OS390 1
- DB2 UDB for iSeries 1
- DB2 UDB for Linux, UNIX, and Windows 1
HS_FDS_RECOVERY_PWD initialization parameter 1
HS_FDS_RECOVERY_PWD parameter
- DB2/OS390 1, 2
- DB2 UDB for Linux, UNIX, and Windows 1
HS_FDS_RESULTSET_SUPPORT initialization parameter 1
HS_FDS_SHAREABLE_NAME initialization parameter 1
HS_FDS_TRACE_LEVEL initialization parameter 1
- enabling agent tracing 1
HS_FDS_TRANSACTION_LOG initialization parameter 1
HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter 1
HS_LANGUAGE initialization parameter 1
HS_LONG_PIECE_TRANSFER_SIZE initialization parameter 1
HS_OPEN_CURSORS initialization parameter 1
HS_RPC_FETCH_REBLOCKING initialization parameter 1
HS_RPC_FETCH_SIZE initialization parameter 1
HS_TIME_ZONE initialization parameter 1
HS_TRANSACTION_LOG 1, 2, 3, 4
HS_TRANSACTION_LOG table
- DB2 UDB for iSeries 1
- DB2 UDB for Linux, UNIX, and Windows 1

I

IFILE initialization parameter 1
Informix, Oracle Database Gateway 1
Informix Server, Oracle Database Gateway 1
Initialization parameter file
- customizing 1, 2, 3, 4, 5
initialization parameters
- Heterogeneous Services (HS) 1
initialization parameters (HS)
- Oracle Database Gateway for ODBC 1
initsid.ora file 1, 2, 3, 4
installActions.log file 1
installation
- accessing installation software 1, 2
- checklists
  - DRDA server 1
- downloading software from Oracle Technology Network 1
- errors
  - log session 1
  - while configuration assistant runs 1
- log files 1
- noninteractive error handling 1
- procedure 1
- response files 1
- reviewing a log of an installation session 1
- troubleshooting 1, 2
installations
- log file 1
installation software, accessing 1, 2
isolation level, HS_FDS_ISOLATION_LEVEL 1

L

listener 1, 2, 3, 4, 5, 6
listener.ora file 1, 2, 3, 4, 5, 6
log files 1
- reviewing an installation session 1
- troubleshooting 1

N

Net Configuration Assistant, troubleshooting 1
noninteractive installation 1
- See also: noninteractive deinstallation, response files
- errors 1
- Record mode 1

O

obsolete parameters since V4 gateway 1
ODBC, Oracle Database Gateway 1
ODBC connectivity
- specifying path to library 1
Oracle Database Gateway
- DRDA 1
- DRDA Server 1
- Informix 1
- Informix Server 1
- ODBC 1
- SQL Server 1
- Sybase 1
- Sybase Server 1
- Teradata Server 1
Oracle Database Gateway for ODBC
- creating initialization file 1
Oracle Net
- configuring 1, 2, 3, 4, 5
- operating system authentication 1
Oracle Net Listener 1, 2, 3, 4, 5, 6
- starting 1, 2, 3, 4, 5, 6
Oracle Technology Network (OTN)
- accessing 1
- downloading software from 1
Oracle Universal Installer (OUI)
- log files 1
OTN
- See: Oracle Technology Network

P

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

R

RECOVER user ID
- DB2/OS390 1
- DB2 UDB for iSeries 1
- DB2 UDB for Linux, UNIX, and Windows 1
- HS_FDS_RECOVERY_ACCOUNT 1
RECOVERY_ACCOUNT
- account user name 1, 2, 3, 4
- creating a recovery account 1, 2, 3, 4
recovery user ID and password
- DB2/OS390 1
- DB2 UDB for iSeries 1
- DB2 UDB for Linux, UNIX, and Windows 1
remote
- database
  - configuration worksheet 1
  - DB2/OS390 1
  - DB2 UDB for iSeries 1
  - DB2 UDB for Linux, UNIX, and Windows 1
- DRDA database, HS_FDS_ISOLATION_LEVEL 1
remote functions
- referenced in SQL statements 1
response files 1
- See also: noninteractive installation
- creating 1
- customizing 1
- samples 1
- specifying during installation 1

S

schema privileges - CREATEIN 1
security
- overview 1
SID 1, 2, 3, 4, 5
silent installation
- See: noninteractive installation
SPUFI on DB2/OS390 1
SQL
- statements, HS_FDS_ISOLATION_LEVEL 1
SQL Server,Oracle Database Gateway 1
SQL Server, Oracle Database Gateway 1
stability, of cursor, HS_FDS_ISOLATION_LEVEL 1
Sybase, Oracle Database Gateway 1
Sybase Server, Oracle Database Gateway 1
system privileges - BINDADD and BINDAGENT
- configuration worksheet 1
- DB2/OS390 1

T

TEMP
- environment variable, hardware requirements 1, 2, 3, 4, 5, 6
temporary directory 1, 2, 3, 4, 5, 6
temporary disk space
- checking 1, 2, 3, 4, 5, 6
- freeing 1, 2, 3, 4, 5, 6
Teradata Server, Oracle Database Gateway 1
tmp directory
- checking space in 1, 2, 3, 4, 5, 6
- freeing space in 1, 2, 3, 4, 5, 6
TMP environment variable, hardware requirements 1, 2, 3, 4, 5, 6
tnsnames.ora 1, 2, 3, 4, 5, 6
- configuring 1, 2, 3, 4, 5, 6
- multiple listeners 1, 2, 3, 4, 5, 6
Transaction log table
- creating 1, 2, 3, 4
troubleshooting 1, 2
- fatal errors 1
- Inventory log files 1
two-phase commit
- HS_TRANSACTION_LOG table
  - DB2 UDB for iSeries 1
Two-phase commit
- configuration 1, 2, 3, 4
- transaction log table 1, 2, 3, 4