Index

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

---

A

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

---

B

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

---

C

• character sets
  • Heterogeneous Services C.18.1
• closing and opening again any session against db2 required with any change to
  • HS_FDS_PACKAGE_COLLID C.33
• 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
• configuring
  • DB2 UDB for iSeries 13.2, 13.3
  • DB2 UDB for z/OS 13.1
  • host workstation for gateway 14.1.2
• Configuring
  • two-phase commit 3.5, 5.5, 7.5, 9.5
• Configuring the gateway 3.1, 5.1, 7.1, 9.1
• 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 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.32

---

D

• database
  • link
    • defining and controlling 15.3
• database link
  • behavior 3.4, 5.4, 7.4, 9.4, 14.6
• Database link
  • behavior 11.4
• data dictionary
  • support 14
• DB2
  • Distributed Data Facility (DDF) 13.1
  • SPUFI utility 13.1
• DB2 UDB for iSeries
  • configuring 13.2
  • HS_FDS_ISOLATION_LEVEL C.32
  • HS_FDS_PACKAGE_COLLID C.33
• DB2 UDB for Linux, Unix, and Windows
  • configuring 13.3
  • HS_FDS_ISOLATION_LEVEL C.32
• DB2 UDB for z/OS
  • configuring 13.1
  • HS_FDS_ISOLATION_LEVEL C.32
• DDF
  • DB2 (Distributed Data Facility) 13.1
• describe cache high water mark
  • definition C.17
• 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.26
• 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.28
• 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.30
• files
  • oraInst.loc A.2
  • response files A.3

---

G

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

---

H

• hardware requirements 12.1.1
• Heterogeneous Services
  • defining maximum number of open cursors C.20
  • initialization parameters 11.1.1
  • optimizing data transfer C.21
  • Oracle Database Gateway for ODBC
    • creating initialization file 11.1.1
  • setting global name C.16
  • specifying cache high water mark C.17
  • tuning internal data buffering C.22
  • tuning LONG data transfer C.19
• HS_CALL_NAME initialization parameter C.13
• HS_DB_NAME initialization parameter C.16
• HS_DESCRIBE_CACHE_HWM initialization parameter C.17
• HS_FDS_AUTHENTICATE_METHOD C.48
• HS_FDS_CONNECT_INFO C.25
• HS_FDS_FETCH_ROWS parameter C.30
• HS_FDS_ISOLATION_LEVEL parameter C.32
• HS_FDS_PACKAGE_COLLID parameter
  • defined C.33
• HS_FDS_PROC_IS_FUNC initialization parameter C.9
• 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.12
• 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.10
• HS_FDS_SHAREABLE_NAME initialization parameter C.11
• HS_FDS_TRACE_LEVEL initialization parameter C.28
  • enabling agent tracing C.1
• HS_FDS_TRANSACTION_LOG initialization parameter C.29
• HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter C.42
• HS_LANGUAGE initialization parameter C.18
• HS_LONG_PIECE_TRANSFER_SIZE initialization parameter C.19
• HS_OPEN_CURSORS initialization parameter C.20
• HS_RPC_FETCH_REBLOCKING initialization parameter C.21
• HS_RPC_FETCH_SIZE initialization parameter C.22
• HS_TIME_ZONE initialization parameter C.8
• HS_TRANSACTION_LOG 3.5.2, 5.5.2, 7.5.2, 9.5.2

---

I

• IFILE initialization parameter C.24
• 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
  • 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
• isolation level, HS_FDS_ISOLATION_LEVEL C.32

---

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
• log files B.2
  • troubleshooting B.3

---

M

• mount point directories 1.5.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.11
• operating system
  • user ID for DB2 UDB for Linux, Unix, and Windows 13.3
• 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.33
  • privileges - BIND, COPY, and EXECUTE
    • DB2 UDB for z/OS 13.1
  • privileges - BIND and EXECUTE
    • DB2 UDB for Linux, Unix, and Windows 13.3
• parameters
  • gateway initialization file
    • HS_FDS_CAPABILITY C.31
    • HS_FDS_FETCH_ROWS C.30
    • HS_FDS_ISOLATION_LEVEL C.32
    • HS_FDS_PACKAGE_COLLID C.33
  • 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.26
• 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
• 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
• 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.32
  • transaction program
    • hardware memory requirements 12.1.1
• remote functions
  • referenced in SQL statements C.13
• requirements
  • hardware 12.1.1
  • software 12.1.3

---

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, 9.1.1, 7.1.1, 11.1.1
• silent mode installation A.3.2, A.4
• software requirements 12.1.3
• SPUFI, a database native tool 14
• SQL
  • statements, HS_FDS_ISOLATION_LEVEL C.32
• stability, of cursor, HS_FDS_ISOLATION_LEVEL C.32
• 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, 7.5, 5.5, 9.5
  • transaction log table 3.5.2, 5.5.2, 7.5.2, 9.5.2

---

X

• X windows
  • display errors B.1