1. Index

Index

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

A

  • application
    • authenticating logons 1
  • AS/400
    • command, DSPRDBDIRE 1
    • library name, HS_FDS_PACKAGE_COLLID 1

B

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

C

  • character sets
    • Heterogeneous Services 1
  • closing and opening again any session against db2 required with any change to
    • HS_FDS_PACKAGE_COLLID 1
  • collection privilege - CREATE IN
    • DB2 UDB for z/OS 1
  • collection privilege - CREATETAB
    • DB2 UDB for z/OS 1
  • Communication Database (CDB) tables, DDF 1
  • concurrent connections
    • TCP/IP 1
  • configuration assistants
    • troubleshooting 1
  • configuring
    • DB2 UDB for iSeries 1, 2
    • DB2 UDB for z/OS 1
    • host workstation for gateway 1
  • Configuring
    • two-phase commit 1, 2, 3, 4
  • Configuring the gateway 1, 2, 3, 4
  • connect_descriptor 1, 2, 3, 4, 5, 6, 7
  • COPY privilege
    • DB2 UDB for z/OS 1
  • CREATE IN privilege
    • DB2 UDB for Linux, Unix, and Windows 1
    • DB2 UDB for z/OS 1
  • CREATETAB privilege
    • DB2 UDB for z/OS 1
  • Creating
    • transaction log table 1, 2, 3, 4
  • cursor
    • stability, HS_FDS_ISOLATION_LEVEL 1

D

  • database
    • link
      • defining and controlling 1
  • database link
  • Database link
    • behavior 1
  • data dictionary
    • support 1
  • DB2
    • Distributed Data Facility (DDF) 1
    • SPUFI utility 1
  • DB2 UDB for iSeries
    • configuring 1
    • HS_FDS_ISOLATION_LEVEL 1
    • HS_FDS_PACKAGE_COLLID 1
  • DB2 UDB for Linux, Unix, and Windows
    • configuring 1
    • HS_FDS_ISOLATION_LEVEL 1
  • DB2 UDB for z/OS
    • configuring 1
    • HS_FDS_ISOLATION_LEVEL 1
  • DDF
    • DB2 (Distributed Data Facility) 1
  • describe cache high water mark
    • definition 1
  • Destination Hostname or IP Address, same as DRDA server Hostname or IP Address (configuring TCP/IP, worksheet) 1
  • Destination Service Port Number, same as DRDA Server Service Port Number (configuring TCP/IP, worksheet) 1
  • distributed
    • data facility (DDF) 1
    • operations, DB2 1
    • transaction, HS_FDS_RECOVERY_ACCOUNT 1
  • DRDA server
    • configuring
      • DB2 UDB for iSeries 1
      • DB2 UDB for Linux, Unix, and Windows 1
      • DB2 UDB for z/OS 1
    • Hostname or IP Address (configuring TCP/IP, worksheet) 1
    • Service Port Number (configuring TCP/IP, worksheet) 1
  • DSPRDBDIRE command 1

E

  • Error messages
    • error tracing 1
  • errors
    • configuration assistants 1
    • installation 1, 2
    • non-interactive installation 1
    • silent mode 1
    • X windows 1
  • EXECUTE privilege
    • DB2 UDB for Linux, Unix, and Windows 1
    • DB2 UDB for z/OS 1

F

  • fatal errors 1
  • fetch array size, with HS_FDS_FETCH_ROWS 1
  • files
    • oraInst.loc 1
    • response 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

  • hardware requirements 1
  • 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_AUTHENTICATE_METHOD 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_RECOVER_ACCOUNT
    • if the user ID is not specified 1
  • HS_FDS_RECOVERY_ACCOUNT
    • DB2 UDB for iSeries 1
    • DB2 UDB for z/OS 1
  • HS_FDS_RECOVERY_ACCOUNT parameter
    • DB2 UDB for iSeries 1
    • DB2 UDB for z/OS 1
    • defining the recovery user ID 1
  • HS_FDS_RECOVERY_PWD initialization parameter 1
  • HS_FDS_RECOVERY_PWD parameter
    • DB2 UDB for iSeries 1
    • DB2 UDB for z/OS 1
    • defining the recovery user ID 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

I

  • IFILE initialization parameter 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
  • installation
    • errors 1, 2
      • silent mode 1
    • log files 1
    • non-interactive
      • error handling 1
      • oraInst.loc file 1
    • procedure 1
    • response files 1
      • preparing 1
      • silent mode 1
      • templates 1
    • silent mode 1, 2
  • isolation level, HS_FDS_ISOLATION_LEVEL 1

L

  • listener 1, 2, 3, 4, 5, 6, 7
  • listener.ora file 1, 2, 3, 4, 5, 6
  • log files 1
    • troubleshooting 1

M

  • mount point directories 1

N

  • Net Configuration Assistant
    • troubleshooting 1
  • non-interactive installation
    • oraInst.loc file 1
    • response files
      • preparing 1
      • templates 1
    • silent mode 1, 2
      • errors 1
  • non-interactive installations
    • running
      • Oracle Universal Installer 1

O

  • ODBC connectivity
    • specifying path to library 1
  • operating system
    • user ID for DB2 UDB for Linux, Unix, and Windows 1
  • Oracle Database Gateway for ODBC
    • creating initialization file 1
  • Oracle Net
    • configuring 1, 2, 3, 4, 5, 6
    • operating system authentication 1
  • Oracle Net Listener 1, 2, 3, 4, 5, 6, 7
    • starting 1, 2

P

  • package
    • collection id, HS_FDS_PACKAGE_COLLID 1
    • privileges - BIND, COPY, and EXECUTE
      • DB2 UDB for z/OS 1
    • privileges - BIND and EXECUTE
      • DB2 UDB for Linux, Unix, and Windows 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 UDB for iSeries 1
      • DB2 UDB for Linux, Unix, and Windows 1
      • DB2 UDB for z/OS 1
    • HS_FDS_RECOVERY_PWD
      • DB2 UDB for iSeries 1
      • DB2 UDB for Linux, Unix, and Windows 1
      • DB2 UDB for z/OS 1
  • privileges
    • BIND
      • DB2 UDB for Linux, Unix, and Windows 1
      • DB2 UDB for z/OS 1
    • BINDADD
      • DB2 UDB for z/OS 1
    • BINDAGENT
      • DB2 UDB for z/OS 1
    • COPY
      • DB2 UDB for z/OS 1
    • CREATE IN
      • DB2 UDB for Linux, Unix, and Windows 1
      • DB2 UDB for z/OS 1
    • CREATETAB
      • DB2 UDB for z/OS 1
    • EXECUTE
      • DB2 UDB for Linux, Unix, and Windows 1
      • DB2 UDB for z/OS 1

R

  • RECOVER user ID
    • DB2 UDB for iSeries 1
    • DB2 UDB for Linux, Unix, and Windows 1
    • DB2 UDB for z/OS 1
    • HS_FDS_RECOVERY_ACCOUNT 1
  • RECOVERY_ACCOUNT
    • account username 1, 2, 3, 4
    • creating a recovery account 1, 2, 3, 4
  • recovery user ID and password
    • DB2 UDB for iSeries 1
    • DB2 UDB for Linux, Unix, and Windows 1
    • DB2 UDB for z/OS 1
  • remote
    • database
      • DB2 UDB for iSeries 1
      • DB2 UDB for Linux, Unix, and Windows 1
      • DB2 UDB for z/OS 1
      • privileges of user/ ID 1
    • DRDA database, HS_FDS_ISOLATION_LEVEL 1
    • transaction program
      • hardware memory requirements 1
  • remote functions
    • referenced in SQL statements 1
  • requirements
    • hardware 1
    • software 1

S

  • sample
    • SQL scripts 1
  • schema privilege - CREATE IN
    • DB2 UDB for Linux, Unix, and Windows 1
  • security
    • overview 1
  • SID 1, 2, 3, 4, 5
  • silent mode installation 1, 2
  • software requirements 1
  • SPUFI, a database native tool 1
  • SQL
    • statements, HS_FDS_ISOLATION_LEVEL 1
  • stability, of cursor, HS_FDS_ISOLATION_LEVEL 1
  • system privileges - BINDADD and BINDAGENT
    • DB2 UDB for z/OS 1

T

  • TCP/IP
    • concurrent connections 1
  • tnsnames.ora 1, 2, 3, 4, 5, 6, 7
    • configuring 1, 2, 3, 4, 5, 6, 7
    • multiple listeners 1, 2, 3, 4, 5, 6
  • Transaction log table
    • creating 1, 2, 3, 4
  • troubleshooting 1
    • fatal errors 1
  • Two-phase commit
    • configuration 1, 2, 3, 4
    • transaction log table 1, 2, 3, 4

X

  • X windows
    • display errors 1