1. Index

Index

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

A

  • action items 2, 4, 6, 8, 10, 12
  • application
    • authenticating logons 15.2
  • AS/400
    • command DSPRDBDIRE 13.2
    • defining user ID 13.2
    • library name, HS_FDS_PACKAGE_COLLID C.33

B

  • Basic installation method
    • noninteractive installations A.4
  • BINDADD privilege
    • configuration worksheet D
    • DB2/OS390 13.1
    • DB2 UDB for Linux, UNIX, and Windows 13.3
  • BINDAGENT privilege
    • configuration worksheet D
    • DB2/OS390 13.1
  • binding the DRDA package
    • authority of user ID and password
      • DB2/OS390 13.1
      • DB2 UDB for iSeries 13.2
  • Bind Package Stored Procedure
    • DB2/OS390 13.1
    • DB2 UDB for iSeries 13.2
  • bind privilege
    • configuration worksheet D
    • DB2/OS390 13.1
    • DB2 UDB for iSeries 13.2
    • DB2 UDB for Linux, UNIX, and Windows 13.3

C

  • character sets
    • Heterogeneous Services C.13.1
  • checklist
    • DRDA server configuration 13
  • closing and opening again any session against db2 required with any change to
    • HS_FDS_PACKAGE_COLLID C.33
  • collection privilege - CREATE IN
    • configuration worksheet D
    • DB2/OS390 13.1
  • collection privilege - CREATETAB, DB2/OS390 13.1
  • Communication Database (CDB) tables, DDF 13.1
  • configuration assistants
    • troubleshooting B.4
  • configuration assistants, troubleshooting B.4
  • configuring
    • checklists for DRDA server 13
    • DB2/OS390 13.1
    • DB2 UDB for iSeries 13.2
    • DB2 UDB for Linux, UNIX, and Windows 13.3
    • list of parameters needed to configure the gateway D
  • Configuring
  • Configuring the gateway 3.1, 5.1, 7.1, 9.1, 14.1
  • connect_descriptor 3.3.2, 5.3.2, 7.3.2, 9.3.2, 11.3.2, 14.5.2
  • CONNECT authority
    • DB2 UDB for Linux, UNIX, and Windows 13.3
  • COPY
    • privilege
      • configuration worksheet D
      • DB2/OS390 13.1
  • CREATE IN privilege
    • configuration worksheet D
    • DB2/OS390 13.1
  • CREATEIN privilege, DB2 UDB for Linux, UNIX, and Windows 13.3
  • CREATETAB privilege
    • DB2/OS390 13.1
    • DB2 UDB for Linux, UNIX, and Windows 13.3
  • Creating
  • cursor
    • stability, HS_FDS_ISOLATION_LEVEL C.32

D

  • database
    • authorities - CONNECT, BINDADD, and CREATETAB 13.3
    • link
      • defining and controlling 15.3
    • native tool 14
  • Database Configuration Assistant (DBCA)
    • troubleshooting B.4
  • database link
  • Database link
  • data dictionary
    • support 14
  • DB2
    • Distributed Data Facility (DDF) 13.1
    • SPUFI utility 13.1
  • DB2/OS390
  • DB2 UDB for iSeries
    • configuring the DRDA server 13.2
    • defining user ID 13.2
    • HS_FDS_ISOLATION_LEVEL C.32
    • HS_FDS_PACKAGE_COLLID C.33
  • DB2 UDB for Linux, Unix, and Window
    • with SPUFI 14
  • DB2 UDB for Linux, Unix, and Windows
    • HS_FDS_ISOLATION_LEVEL C.32
  • DB2 UDB for Linux, UNIX, and Windows
    • configuring 13.3
    • configuring the DRDA server 13.3
  • DB2 UDB for z/OS
    • HS_FDS_ISOLATION_LEVEL C.32
  • describe cache high water mark
  • disk space
  • distributed
    • operations, DB2 13.1
    • transaction, HS_FDS_RECOVERY_ACCOUNT C.24
  • DRDA, Oracle Database Gateway 12.1.1
  • DRDA server
    • configuring
      • DB2/OS390 13.1
      • DB2 UDB for iSeries 13.2
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • Hostname or IP Address (configuring TCP/IP, worksheet) D
    • Service Port Number (configuring TCP/IP, worksheet) D
  • DRDA Server, Oracle Database Gateway 12.1.1
  • DSPRDBDIRE command 13.2

E

F

  • fatal errors B.4.2
  • fetch array size, with HS_FDS_FETCH_ROWS C.30
  • files
    • Oracle Universal Installer log files B.3

G

H

  • Heterogeneous Services
    • defining maximum number of open cursors C.15
    • initialization parameters 11.1.1
    • optimizing data transfer C.16
    • Oracle Database Gateway for ODBC
      • creating initialization file 11.1.1
    • setting global name C.11
    • specifying cache high water mark C.12
    • tuning internal data buffering C.17
    • tuning LONG data transfer C.14
  • HS_CALL_NAME initialization parameter C.8
  • HS_DB_NAME initialization parameter C.11
  • HS_DESCRIBE_CACHE_HWM initialization parameter C.12
  • HS_FDS_CONNECT_INFO C.22
  • HS_FDS_FETCH_ROWS parameter C.30
  • HS_FDS_ISOLATION_LEVEL parameter C.32
  • HS_FDS_PACKAGE_COLLID parameter
  • HS_FDS_PROC_IS_FUNC initialization parameter C.23
  • HS_FDS_RECOVERY_ACCOUNT parameter
    • DB2/OS390 13.1
    • DB2 UDB for iSeries 13.2
    • DB2 UDB for Linux, UNIX, and Windows 13.3
  • HS_FDS_RECOVERY_PWD initialization parameter C.29
  • HS_FDS_RECOVERY_PWD parameter
    • DB2/OS390 13.1, 13.2
    • DB2 UDB for Linux, UNIX, and Windows 13.3
  • HS_FDS_RESULTSET_SUPPORT initialization parameter C.26
  • HS_FDS_SHAREABLE_NAME initialization parameter C.18
  • HS_FDS_TRACE_LEVEL initialization parameter C.27
    • enabling agent tracing C.1
  • HS_FDS_TRANSACTION_LOG initialization parameter C.28
  • HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter C.42
  • HS_LANGUAGE initialization parameter C.13
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter C.14
  • HS_OPEN_CURSORS initialization parameter C.15
  • HS_RPC_FETCH_REBLOCKING initialization parameter C.16
  • HS_RPC_FETCH_SIZE initialization parameter C.17
  • HS_TIME_ZONE initialization parameter C.19
  • HS_TRANSACTION_LOG 3.5.2, 7.5.2, 9.5.2, 5.5.2
  • HS_TRANSACTION_LOG table
    • DB2 UDB for iSeries 13.2
    • DB2 UDB for Linux, UNIX, and Windows 13.3

I

  • IFILE initialization parameter C.21
  • Informix, Oracle Database Gateway 4.1.1
  • Informix Server, Oracle Database Gateway 4.1.1
  • Initialization parameter file
  • 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
  • installActions.log file B.3
  • installation
    • accessing installation software 1.5, 1.5.2
    • checklists
      • DRDA server 13
    • downloading software from Oracle Technology Network 1.5.1
    • errors
      • log session B.3
      • while configuration assistant runs B.4.2
    • log files B.3
    • noninteractive error handling B.5
    • procedure 1.6
    • response files B.5
    • reviewing a log of an installation session B.3
    • troubleshooting B, B.6
  • installations
  • installation software, accessing 1.5, 1.5.2
  • isolation level, HS_FDS_ISOLATION_LEVEL C.32

L

N

  • Net Configuration Assistant, troubleshooting B.4
  • noninteractive installation A.1
    • See also: noninteractive deinstallation, response files

O

P

  • package
    • collection id, HS_FDS_PACKAGE_COLLID C.33
    • privileges - BIND, COPY, and EXECUTE
      • configuration worksheet D
      • DB2/OS390 13.1
    • privileges - BIND and EXECUTE, DB2 UDB for Linux, UNIX, and Windows 13.3
  • parameter
    • list of parameters needed to configure the gateway D
    • obsolete since V4 gateway 16.3.2
  • 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/OS390 13.1
      • DB2 UDB for iSeries 13.2
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • HS_FDS_RECOVERY_PWD
      • DB2/OS390 13.1
      • DB2 UDB for iSeries 13.2
      • DB2 UDB for Linux, UNIX, and Windows 13.3
  • privileges
    • BIND
      • configuration worksheet D
      • DB2/OS390 13.1
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • BINDADD
      • configuration worksheet D
      • DB2/OS390 13.1
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • BINDAGENT
      • configuration worksheet D
      • DB2/OS390 13.1
    • CONNECT
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • COPY
      • configuration worksheet D
      • DB2/OS390 13.1
    • CREATEIN
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • CREATE IN
      • configuration worksheet D
      • DB2/OS390 13.1
    • CREATETAB
      • DB2/OS390 13.1
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • EXECUTE
      • configuration worksheet D
      • DB2/OS390 13.1
      • DB2 UDB for Linux, UNIX, and Windows 13.3

R

  • RECOVER user ID
    • DB2/OS390 13.1
    • DB2 UDB for iSeries 13.2
    • DB2 UDB for Linux, UNIX, and Windows 13.3
    • HS_FDS_RECOVERY_ACCOUNT C.24
  • RECOVERY_ACCOUNT
  • recovery user ID and password
    • DB2/OS390 13.1
    • DB2 UDB for iSeries 13.2
    • DB2 UDB for Linux, UNIX, and Windows 13.3
  • remote
    • database
      • configuration worksheet D
      • DB2/OS390 13.1
      • DB2 UDB for iSeries 13.2
      • DB2 UDB for Linux, UNIX, and Windows 13.3
    • DRDA database, HS_FDS_ISOLATION_LEVEL C.32
  • remote functions
    • referenced in SQL statements C.8
  • response files A.2
    • See also: noninteractive installation
    • creating A.4
    • customizing A.3
    • samples A.3
    • specifying during installation A.5

S

  • schema privileges - CREATEIN 13.3
  • security
  • SID 3.1.1, 5.1.1, 7.1.1, 9.1.1, 11.1.1
  • silent installation
    • See: noninteractive installation
  • SPUFI on DB2/OS390 14
  • SQL
    • statements, HS_FDS_ISOLATION_LEVEL C.32
  • SQL Server,Oracle Database Gateway 8.1.1
  • SQL Server, Oracle Database Gateway 8.1.1
  • stability, of cursor, HS_FDS_ISOLATION_LEVEL C.32
  • Sybase, Oracle Database Gateway 2.1.1
  • Sybase Server, Oracle Database Gateway 2.1.1
  • system privileges - BINDADD and BINDAGENT
    • configuration worksheet D
    • DB2/OS390 13.1

T