Index

Symbols

(HS=) (TNSNAMES parameter for Oracle Net) 5
- with TCP/IP protocol 5

A

action items
- for installing the gateway 4.6.6
ALTER USER command 8.3, 9.3
american_america_us7ascii 11.2.1
APPC 1.1
- conversation security option A.1, B.1
APPC/MVS
- configuring for the gateway 7.1
- installation verification 8.9.2.3
- verification of configuration 8.9.2.3
architecture
- components of the gateway 1.4
ASCII
- automatic conversion 1.2
authentication
- for operating system 10.2
- for Oracle 10.2
- types, security 10.2

B

backout possibilities during migration 11.1.3

C

CICS 1.8, 3.2.5
- ATTACHSEC parameter 6.2
- installation verification
  - on gateway using SNA 8.9.2.1
- security options not supported by the gateway 6.2
- transaction ID 8.9.2.1
- verifying configuration
  - on gateway using SNA 8.9.2.1
CICS Transaction Server for z/OS
- authentication mechanism
  - on all platforms 10.4.1.2
- configuring for the gateway 7.1
- OLTP
  - configuration verification 8.9.2.1
- TP name length A.1
command
- SET 8.7, 9.7
COMMIT A.2
COMMIT_CONFIRM A.1, A.2, B.1
- and PGA_CAPABILITY parameter A.2
- capability A.2
COMMIT/ROLLBACK 3.2.5
commit-confirm A.2
- configuring 8.8, 8.8.3
  - gateway initialization parameters 8.8.2
  - OLTP 8.8.3
  - Oracle database 8.8.1
- sample applications 8.9.3
- transaction log 8.9.3
communications
- between server, gateway, and remote host 1.6
- needed for Windows 3.2.2
configuration
- gateway directories 9.2
configuration verification
- OLTP
  - on gateway using SNA 8.9
  - on gateway using TCP/IP for IMS Connect 9.9, 9.9.2
configuring
- APPC/MVS 7.1
- CICS Transaction Server for z/OS 7.1
- commit-confirm 8.8, 8.8.3
- gateway
  - optional steps to allow multiple users using SNA 8.6
  - optional steps to allow multiple users using TCP/IP for IMS Connect 9.5
- gateway directories 8.2
- IMS/TM 7.1
- Oracle database 8.8.1
  - upgrading from previous releases 8.4
- Oracle database for gateway using TCP/IP for IMS Connect
  - pre-configuration steps 9.2
- TCP/IP for IMS Connect
  - on the gateway 9.6
- the gateway
  - for TCP/IP for IMS Connect 9
  - using SNA 8
- the OLTP 7
- your network
  - using SNA 5
configuring CICS OLTP for Transaction Server 7.1
configuring your network 5
CONNECT clause 10.4.1.2
- for database link security 10.3.2
- in TCP/IP security 10.5.1.2
connection
- definition
  - SNA Server 6.4.3
CPI-C 8.10.1
- creating profile in IBM Communications Server 6.6.13
creating
- public database link 8.3, 9.3

D

database link 1.6, A.2
- creating 8.3, 9.3
  - when configuring Oracle database 8.3, 9.3
- in configuring the network 5
- in verifying gateway installation
  - on gateway using SNA 8.9.1
  - on gateway using TCP/IP for IMS Connect 9.9.1
- public and private 10.3.1
- security, CONNECT clause 10.3.2
database link name
- modifying .sql files 8.9, 9.9
data dictionary
- See PG DD 1.3
data exchange
- PGAXFER function 1.7.1.2
datastores
- gateway access to 1.1
DBMS_OUTPUT packages 8.3, 9.3
DBMS_PIPE 8.3, 8.6, 9.3, 9.5
definition types
- in IBM Communications Server 6.5.2
dependent LU 7.1
- See also LUs 7.1
describe statement
- DBMS_OUTPUT 9.3
DESCRIBE statement
- DBMS_OUTPUT 8.3
- UTL_RAW 8.3, 9.3
dfhcsdup.jcl file 7.1
DFHRPL DD statement 7.1
DG4APPC
- known restrictions 2.3.1
- see gateway 2.3.1
dg4pwd utility
- definition C
- recommended security utility feature, on gateway using SNA C
directories
- for installing gateway and OIS files 8.2, 9.2
disk space requirements 3.1.4
DISPLAY datatypes 2.3.1

E

EBCDIC language 1.2
- gateway known restrictions pertaining to 2.3.1
- necessary to change to ASCII when using TCP/IP 9.9.2.1
enhancements
- using PGAU to automatically upgrade PG DD entries 8.6, 9.5
error
- during commit processing A.3
- obsolete parameters 11.1.5
- parameter name misspelled 8.7, 9.7
- treating incoming APPC CONFIRM requests as errors A.1, A.3

F

FDS_CLASS_VERSION
- parameter added 11.1.6
FDS_CLASS parameter 11.1.5
FDS_INSTANCE parameter 11.1.5
file
- dfhcsdup.jcl 7.1
- initPGA.ora 8.7, 9.7
- initPGAI.ora A.2
- initsid.ora 1.5, 8.7, 8.8.2, 9.7, 11.1.2, A, B.1, C
  - gateway parameters for gateway using SNA 8.7
  - gateway parameters for gateway using TCP/IP for IMS Connect 9.7
  - new parameters on gateway using SNA 11.1.5
  - new startup shell parameters 11.1.6
  - parameters changed since v4 11.1.5
- listener.ora 5, A.2
- oralu62.asm 7.1
- oraplu62.asm 7.1
- pgaccau.sql 8.8.1
- pgacclg.asm 8.9.3
- pgacics.sql 8.9.2.1
- pgaecho.sql 8.9, 9.9
- pgaflip.asm 7.1, 7.2
- pgaflip.jcl 7.1
- pgaidms.sql 8.9
- pgaim.sql 8.9.2.2, 9.9.2.1
- pgaims.sql 8.9, 9.9, 9.9.2.1
- pgamvs.sql 8.9
- PGAU control files 4.2.2
- pgddadev.sql 8.6, 9.5
- pgddapub.sql 8.6, 9.5
- prvtpgb.plb 8.4
- tnsnames.ora 5, 8.3, A.2
- utlpg.sql 8.4.1
- utlraw.sql 8.4.1
FLIP transaction
- OLTP configuration
  - and verification for APPC/MVS 8.9.2.3
  - and verification for CICS Transaction Server for z/OS 8.9.2.1
  - and verification for IMS/TM on gateway using SNA 7.1, 8.9.2.2
  - and verification for IMS/TM on gateway using TCP/IP 7.2, 9.9.2.1
function
- put_line 8.3, 9.3
functions
- See RPC (remote procedural call) 1.7
- See UTL_PG C
- see UTL_RAW C

G

gateway
- access to IBM datastores 1.1
- communication overview 1.6
- communications with all platforms 1.1
- compatibility with other SNA-enabled products 3.2.5
- components 1.4, 8
  - for SNA and TCP/IP for IMS Connect 1.5
- configuring 8
  - for multiple users, on gateway using TCP/IP for IMS Connect 9.5
  - for SNA 5
  - for TCP/IP for IMS Connect 9, 9.6
- configuring for multiple users
  - on gateway using SNA 8.6
- creating SNA definitions for, using SNA Server Manager 6.3.4
- directory locations for configuration 8.2, 9.2
- factors affecting memory requirements 3.1.2
- features
  - application transparency 1.2
  - code generator 1.2
  - fast interface 1.2
  - flexible interface 1.2
  - location transparency 1.2
  - Oracle database integration 1.2
  - performs automatic conversions 1.2
  - site autonomy and security 1.2
  - support for tools 1.2
- functions, using SNA 1.8
- initialization files C
- initialization parameters
  - also see PGA parameters A.1
  - described 8.7, 9.7
  - for gateway using SNA A
  - new and changed since Version 4 gateway 11.1.5
  - renamed since v4 11.1.5
  - SET 8.7, 9.7, A.1, B.1
- installation
  - first-time install, configuring the Oracle database 8.3, 9.3
  - preinstallation procedures 4.3
  - verification 8.9.1, 9.9.1
  - with Oracle Universal Installer action items 4.6.6
- installation steps 4.6
- installing 4
- known restrictions, when using SNA 2.3.1
- migrating to new release, using SNA 11.1
- network attachment requirements 3.1.3
- overview 1.1
- parameter files 8.7, 9.7
  - also see gateway initialization parameters, and PGA parameters 8.7
  - initPGA.ora 8.7, 9.7
- pre-installation steps for TPC/IP 4.3
- remote procedure, definition C
- remote transaction initiation
  - using SNA 1.7.1.1
  - using TCP/IP 1.7.1.1
- remote transaction termination
  - using SNA 1.7.1.3
  - using TCP/IP 1.7.1.3
- removing 4.7
- requirements
  - hardware 3.1
- restoring to previous releases 4.2.3
- security options and overview 10.1
  - also see, security 10.1
- server
  - restoring previous version 4.2.3
- setting up multiple gateway instances A.2
- SNA security validation 6.1, 10.4
- SNA Server function 10.4
- startup shell parameters
  - FDS_CLASS_VERSION 11.1.6
- steps to install, via Oracle Universal Installer 4.6.6
- upgrading
  - from previous release 4.2
  - preparing to upgrade 4.2.1
gateway initialization parameters
- for commit-confirm support 8.8.2
- new 11.1.5
gateway security requirements 10
gateway using TCP/IP for IMS Connect
- gateway initialization parameters needed B
- transaction types 1.9
gpglocal 8.3, 9.3
- needed to compile PGAU-generated TIP specifications 8.3, 9.3
gpglocal.pkb script 8.3, 9.3
gpglocal.pkh script 8.3, 9.3
gpglocal package 9.3
grant
- access 8.6, 9.5
- authorization 8.3, 9.3
- execute 8.3, 9.3
- explicit 8.6, 9.5
- private 8.6, 9.5
- public 8.6, 9.5

H

hardware requirements 3.1
Heterogeneous Services (HS) 11.1.5
- and Oracle Net considerations, on gateway using SNA 11.1.4
- catalogs
  - installing, on gateway using SNA 8.3
  - installing, on gateway using TCP/IP for IMS Connect 9.3
- parameters needed for gateway using TCP/IP 11.1.5
HS_COMMIT_STRENGTH_POINT parameter 11.1.5
HS_DB_DOMAIN parameter 11.1.5
HS_DB_INTERNAL_NAME parameter 11.1.5
HS_DB_NAME parameter 11.1.5
HS_DESCRIBE_CACHE_HWM parameter 11.1.5
HS_FDS_FETCH_ROWS parameter 11.1.5
HS_LANGUAGE parameter 11.1.5
HS_NLS_DATE_FORMAT parameter 11.1.5
HS_NLS_DATE_LANGUAGE parameter 11.1.5
HS_OPEN_CURSORS parameter 11.1.5
HS_ROWID_CACHE_SIZE parameter 11.1.5
HS parameters 11.1.5
- description 11.1, 11.1.5
- see also, (HS=) 11.1.5

I

IBM Communications Server
- configuring 6.5
- creating SNA definitions 6.6
- definition types 6.5.2
IBM mainframe requirements 3.2.5
implementation of the gateway
- for SNA and TCP/IP for IMS Connect 1.5
implied APPC A.3
IMS/TM
- configuring for the gateway
  - using SNA 7.1
- installation verification
  - on gateway using SNA 8.9.2.2
  - on gateway using TCP/IP for IMS Connect 9.9.2.1
- mainframe requirements for gateway using TCP/IP 3.2.5
- TP name length A.1
- verification of configuration
  - on gateway using SNA 8.9.2.2
  - on gateway using TCP/IP for IMS Connect 9.9.2.1
IMS Connect
- and security 10.5
- mainframe requirements, for gateway using TCP/IP 3.2.5
IMS FLIP transaction 7.1, 7.2
independent LU 7.1
initialization files
- See gateway initialization files, also see PGA parameters C
initiating remote transactions 1.7.1.1
initPGA.ora file 8.7, 9.7
initPGAI.ora file A.2
initsid.ora file 1.5, 8.7, 8.8.2, 9.7, 11.1.2, A, B.1, C
- gateway parameters on gateway using SNA 8.7
- gateway parameters on gateway using TCP/IP for IMS Connect 9.7
- HS parameter descriptions 11.1, 11.1.5
- new parameters, on gateway using SNA 11.1.5
- new startup shell parameters 11.1.6
- parameters changed since v4 11.1.5
installation
- steps 4.6
installation verification
- CICS on gateway using SNA 8.9.2.1
- gateway
  - with SNA 8.9.1
  - with TCP/IP for IMS Connect 9.9.1
- IMS/TM
  - on gateway using SNA 8.9.2.2
  - on gateway using TCP/IP for IMS Connect 9.9.2.1
- OLTP 8.9.2
installing
- and configuring the gateway 4
- preinstallation steps 4.3
- sample applications
  - on gateway for SNA protocol 8.10.1
  - on gateway with TCP/IP for IMS Connect 9.10.1
IPC
- key 5
- protocol 5

K

key
- IPC 5
known restrictions
- for DG4APPC 2.3.1
- for PGAU 2.3.2

L

link service definition 6.4.2
listener.ora file 5, A.2
- sample file for gateway using SNA A.4
- sample for gateway using TCP/IP B.2.1
LOG_DESTINATION parameter 11.1.5
- for gateway using SNA 11.1.2
- for gateway using TCP/IP B.1
logmode entry name 8.9.2.1
LU6.1 Adapter for LU6.2 applications 7.1
LU6.2
- and specifying SNA conversation security 10.4.1
LUs 6.1
- also see independent LU and dependent LU 6.1
- and gateway security 10.3.2
- dependent
  - for configuring LU6.2 for IMS/TM for the gateway 7.1
- independent
  - in configuring APPC/MVS on the gateway 7.1
  - in configuring CICS Transaction Server for z/OS 7.1
  - in configuring IMS/TM for the gateway 7.1
  - vs. dependent 6.3.1
- in SNA security validation 10.4

M

mainframe requirements 3.2.5
memory requirements 3.1.2
Microsoft Host Integration Server
- and LUs 6.3.1
- configuring 6.3
- creating SNA definitions on 6.4
- See SNA Server 3.2.2
Microsoft Windows
- configuring the SNA Server 6
migrating
- an existing gateway to use TCP/IP 11.2
- backout considerations when migrating to new release 11.1.3
- existing gateway instance to new release, using SNA 11.1
- to 12.2.0.1.0
  - special parameters 11.1.5
mode definition 6.4.5
multiconversational transaction type, for gateway using TCP/IP 1.8

N

network
- configuring
  - with SNA 5
- reconfiguring 5
networking products required 3.2.4
non-persistent socket transaction type for TCP/IP for IMS Connect 1.9

O

obsolete parameters, in gateway using SNA 11.1.5
OLTP 6.4.7, A.2
- and dependent LUs 6.3.1
- and SECURITY=PROGRAM option 10.4.1.2
- and SECURITY=PROGRAM option, on platforms using TCP/IP 10.5.1.2
- configuration 7
- configuration verification
  - APPC/MVS 8.9.2.3
  - CICS Transaction Server for z/OS 8.9.2.1
  - on gateway using SNA 8.9
  - on gateway using SNA IMS/TM 8.9.2.2
  - on gateway using TCP/IP for IMS Connect 9.9
- configuring
  - APPC/MVS for the gateway 7.1
  - CICS Transaction Server for z/OS for the gateway 7.1
  - for gateway using TCP/IP for IMS Connect 9.6
  - IMS/TM for the gateway 7.1
- currently supported types 7.1, 8.9.2
- definition 1.3
- for TCP/IP for IMS Connect 1.4
- in gateway architecture featuring SNA 1.4
- in gateway using TCP/IP 1.4
- installation verification 8.9.2, 9.9.2
- postinstallation steps
  - on gateway using SNA 8.10
- post-installation steps
  - on gateway using TCP/IP for IMS Connect 9.10
- remote 1
- requirements 3.2.5
- security and inbound APPC session requests 6.2
- security on the gateway 10.1
- SNA security option
  - on all platforms 10.4.1.2
- user ID mapping 10.3.2
- verifying configuration
  - on gateway using SNA 8.9.2
  - on gateway using TCP/IP for IMS Connect 9.9.2
OLTP for SNA
- mainframe requirements 3.2.5
OLTP for TCP/IP
- IBM mainframe requirements 3.2.5
one-shot transaction types, for gateway using SNA 1.8
online transaction processor
- See OLTP 1.4
ORACLE_HOME 7.1, 8.7, 8.9.2.2, 8.9.2.3, 9.7
Oracle database 1.7.1.2, 4.1, 4.3, 4.3.1, 5, 8.3, 9.3, 10.3.1, A.2
- and gateway security 10.3.2
- and TCP/IP for IMS Connect
  - pre-configuration steps 9.2
- component of the gateway 1.4
- configuring for commit-confirm 8.8.1
- definition 1.3
- enabling DBMS_OUTPUT PL/SQL package 8.3, 9.3
- logon authentication needed 10.2
- multiple servers on the gateway
  - using TPC/IP 1.4
- multiple servers on the gateway using SNA 1.4
- precompiles PL/SQL package 1.2
- READ_ONLY mode A.2
- role
  - in gateway communication 1.6
  - in logon security 10.3.2
  - in starting the gateway 1.5
- shipped with PL/SQL packages 8.6, 9.5
- stores PL/SQL C
- upgrading
  - from previous releases 8.4
- verifying
  - APPC/MVS configuration 8.9.2.3
  - gateway installation with SNA 8.9.1
  - gateway installation with TCP/IP for IMS Connect 9.9.1
  - IMS/TM, on gateway using SNA 8.9.2.2
  - IMS/TM, on gateway using TCP/IP for IMS Connect 9.9.2.1
- version requirements 3.2.3
Oracle Database 10g Server
- and networking products needed 3.2.4
Oracle Database Gateway for APPC
- development environment 1.2
- functions 1.8
- removing 4.7
- see also gateway 1.8
Oracle Database Listener 5
Oracle global transaction ID 8.9.3
Oracle Heterogeneous Services
- See Heterogeneous Services 11.1.5
Oracle Net 1.3, A.1
- considerations, when migrating gateway featuring SNA 11.1.4
- Heterogeneous services/tnsnames.ora considerations, on gateway using SNA 11.1.4
- on gateway using TCP/IP B.1
- security considerations 10.2
- to start the gateway 1.5
Oracle Net Listener 5
Oracle Universal Installer
- using 4.6.6.1
  - to install gateway 4.6.6
oralu62.asm file 7.1
ORAPGA.APPCMVS.SAMPLIB 7.1
oraplu62.asm file 7.1
override
- user ID and password 10.4.1.2, 10.5.1.2

P

package
- DBMS_OUTPUT 8.3, 9.3
- gpglocal 9.3
- UTL_PG 8.3, 9.3, 9.5
  - invalidated or removed 8.4.1
- UTL_RAW 8.3, 9.3
  - invalidated or removed 8.4.1
package specifications
- avoid reinstalling 8.4.1
- reinstalling 8.4.1
parameter files
- See gateway initialization files A, B.1
- See PGA parameters A, B.1
- See RRM parameters A, B.1
parameters
- changed since Release 4, on gateway using SNA or TCP/IP 11.1.5
- FDS_CLASS_VERSION 11.1.6
- gateway initialization parameter, described 8.7, 9.7
- needed for commit-confirm support 8.8.2
- new
  - FDS_CLASS (startup shell) 11.1.5
  - FDS_INSTANCE (startup shell) 11.1.5
- obsolete, in gateway using SNA 11.1.5
- PGA
  - described for SNA 8.7
  - described for TCP/IP 9.7
- renamed since version 4 (gateway initialization) 11.1.5
- see PGA parameters and gateway 9.7
- USING 5
password
- change using ALTER USER command 8.3, 9.3
- Oracle authentication 10.2
- Oracle password to be used by gateway A.1
  - using TCP/IP B.1
- overrides 10.4.1.2, 10.5.1.2
- with operating system authentication 10.2
PDS (partitioned dataset) 7.1
persistent socket transaction type
- for TCP/IP for IMS Connect 1.9
persistent transaction type, for gateway using SNA 1.8
pg4tcpmap table 11.2.1
- see PGA_TCP_IMSC table 9.8
pg4tcpmap tool 9.8, 10.5, 10.5.1.2, 11.2.1, B.1
- definition C
- function 1.2, 9.8
  - in remote transaction initiation 1.7.1.1
- on gateway using TCP/IP 9.3, B.1
- output sample B.2
PGA
- definition C
- initialization files
  - initPGAI.ora and initPGAU.ora A.2
PGA_CAPABILITY
- See PGA parameters A.2
PGA_CONFIRM
- See PGA parameters for gateway using SNA or TCP/IP A.3
PGA_SECURITY_TYPE
- See PGA parameters 10.4.1, 10.5.1.2
PGA_SECURITY_TYPE parameter
- and TCP/IP security 10.5.1
PGA_TCP_DB
- PGA parameter
  - for gateway using TCP/IP B.1
PGA_TCP_DB parameter (TCP/IP only) 11.1.5
PGA_TCP_DB PGA parameter (TCP/IP only) B.1
PGA_TCP_IMSC table 11.2.1
- for mapping SNA parameters to TCP/IP 9.8
- loading, on gateway using TCP/IP 9.8
PGA_TCP_PASS parameter (TCP/IP only) 11.1.5
PGA_TCP_PASS PGA parameter (TCP/IP only) B.1
PGA_TCP_USER parameter (TCP/IP only) 11.1.5, B.1
PGAADMIN 8.3, 8.9.1, 9.3, 9.9.1
- creating the gateway administrator user ID 8.3, 9.3
- granting access to additional users 8.6, 9.5
- granting execution privileges on DBMS_PIPE 8.3, 9.3
- initial password during creation 8.3, 9.3
pgaccau.sql file 8.8.1
pgacclg.asm file 8.9.3
pgacics.sql file 8.9.2.1
pgacr8au.sql script 8.3, 9.3
pgaecho.sql file 8.9, 9.9
pgaflip.asm file 7.1, 7.2
pgaflip.jcl file 7.1
PGAI
- setting up A.2
pgaidms.sql file 8.9
pgaims.sql 9.2
pgaims.sql file 8.9, 8.9.2.2, 9.9
- on gateway using TCP/IP 9.9.2.1
pgaimsc.sql 9.3
PGAINIT 1.7.1.1
PGAINIT function 1.7.1.1, C
PGAINIT TIP 9.8
pgamvs.sql file 8.9
PGA parameters
- described 8.7, 9.7
- list of, for gateway using TCP/IP B.1
- LOG_DESTINATION A.1
- on gateway using
  - SNA A.1
  - TCP/IP B.1
- PGA_CAPABILITY 8.7, 9.7, A.1, B.1
  - choosing settings A.2
  - options for updating foreign databases A.2
  - protections against data problems A.2
- PGA_CAPABILITY, for gateway using TCP/IP B.1
- PGA_CONFIRM A.1
  - choosing settings A.3
- PGA_LOG_DB A.1, B.1
- PGA_LOG_PASS A.1, B.1
  - on gateway using TCP/IP B.1
- PGA_LOG_USER A.1, B.1
- PGA_RECOVERY_PASS A.1
- PGA_RECOVERY_TPNAME A.1
- PGA_RECOVERY_USER A.1
- PGA_SECURITY_TYPE 10.4.1, 10.4.1.2, 10.5.1.2, A.1, B.1
- PGA_TCP_PASS
  - for gateway using TCP/IP B.1
- TRACE_LEVEL A.1
  - on gateway using TCP/IP B.1
PGATERM function 1.7.1.1, C
pgatiptr.sql script 9.3
PGAU 5
- accesses definitions in PG DD 1.3
- control files 4.2.2
- definition
  - used to generate TIP specifications 1.3
- -generated TIP specifications 1.6
- -generated TIP specifications use UTL_PG 8.3, 9.3
- -generated TIP specifications use UTL_RAW 8.3, 9.3
- known restrictions in this release 2.3.2
- purpose of PGDL C
- restoring previous versions 4.2.3
- setting up A.2
- upgrading existing PG DD entries 8.6, 9.5
PGAU commands
- DEFINE DATA
  - COBOL COPY REPLACE restrictions 2.3.2
- GENERATE 8.6, 9.5
  - produces TIP in output files 8.6, 9.5
  - to upgrade existing TIPs 8.6, 9.5
PGAXFER function 1.7.1.1, 1.7.1.2, C
PG Data Dictionary
- See PG DD 1.3
PGDD
- compatibility issues between new and older gateways 8.5
PG DD
- after upgrade 4.2.2
- allowing multiple users 8.6, 9.5
- creating public synonyms for multiple users 8.6, 9.5
- definition 1.3
- installing for gateway configuration 8.3, 9.3
- install script 8.3, 9.3
- no access from earlier PGAU versions 4.2.2
- restoring previous version 4.2.3
- tables 8.6, 9.5
- upgrade when upgrading gateway 8.4.2
- using PGAU to upgrade existing entries 8.6, 9.5
pgddadev.sql
- file 8.6, 9.5
- script 8.6, 9.5
pgddapub.sql
- file 8.6, 9.5
- script 8.6, 9.5
pgddcr8.sql script 8.3, 9.3
pgddcr8r.sql script 8.6
PGDDDEF role 8.6, 9.5
PGDDGEN role 8.6, 9.5
- adding a privilege for upgrading PG DD entries 8.6, 9.5
pgddupgr.sql script 8.4.2
PGDL (Procedural Gateway Definition Language)
- definition C
PL/SQL 1.3
- code generator 1.2
- datatypes
  - converted to RAW 1.7.1.2
- function in the gateway 1.1, 1.6
- running pgatiptr.sql script to create routines 8.3, 9.3
- UTL_PG package function C
- UTL_RAW function C
- UTL_RAW package installation
  - on gateway using SNA 8.3
  - on gateway using TCP/IP for IMS Connect 9.3
PL/SQL package
- definition 1.3, C
- developer access to 8.6, 9.5
- enabled 8.3, 9.3
- functions 1.6
- See TIP 1.6
PL/SQL stored procedure 8.8.1
- used for logging transactions 8.8.1
PL/SQL stored procedure specification
- also called "TIP" 1.2
- See PL/SQL package C
postinstallation steps for OLTP
- on gateway using SNA 8.10
post-installation steps for OLTP
- on gateway using TCP/IP 9.10
preinstallation steps
- for SNA 4.3
privileges
- needed to create TIPs 8.6, 9.5
Procedural Gateway Administration
- See PGA C
Procedural Gateway Administration Utility
- See PGAU 1.6
processor OLTP
- configuring, for commit-confirm 8.8.3
processor requirements 3.1.1
protocol
- IPC 5
- TCP 5
prvtpgb.plb
- file 8.4
- script 8.3, 8.4
prvtrawb.plb script 8.3, 8.4, 9.3
public synonyms for multiple PG DD users 8.6, 9.5
put_line function 8.3, 9.3

R

RACF 10.5.1.2, B.1
READ_ONLY
- PGA_COMPATIBILITY setting A.2
recompiling TIPs
- See TIP 8.4.1
reinstallation of package specifications 8.4.1
release-specific information
- restrictions 2.3.1
remote host transactions (RHT)
- types 1.8
remote procedural call
- See RPC 1.1
remote procedure
- definition C
remote transaction initiation
- on gateway using SNA 1.7.1.1
- on gateway using TC/IP 1.7.1.1
remote transaction program
- See RTP 1.1
remote transaction termination
- on gateway using SNA 1.7.1.3
- on gateway using TCP/IP for IMS Connect 1.7.1.3
removing
- the gateway 4.7
requirements
- hardware 3.1
- network attachments 3.1.3
- software 3.2
- system 3
restoring a previous release of the gateway 4.2.3
restrictions
- on gateway using SNA 2.3.1
role
- PGDDDEF 8.6, 9.5
- PGDDGEN 8.6, 9.5
ROLLBACK 3.2.5, A.2
RPC
- definition 1.3
- function
  - PGAINIT 1.7.1.1, C
  - PGATERM C
  - PGAXFER 1.7.1.2, C
  - within the gateway 1.1, 1.7
- processing 1
RTP
- definition 1.3
- executing 1.3
- function in the gateway 1.1
- PGA_CAPABILITY settings for read-only RTPs A.2

S

sample applications
- included 8.10.1, 9.10.1
- installing 8.10.1, 9.10.1
script
- gpglocal.pkb 8.3, 9.3
- gpglocal.pkh 8.3, 9.3
- pgacr8au.sql 8.3, 9.3
- pgddadev.sql 8.6, 9.5
- pgddapub.sql 8.6, 9.5
- pgddcr8.sql 8.3, 9.3
- pgddcr8r.sql 8.6
- pgddupgr.sql 8.4.2
- prvtpgb.plb 8.3, 8.4
- prvtrawb.plb 8.3, 8.4, 9.3
- utlpg.sql 9.3
- utlraw.sql 8.3, 9.3
security
- and database links 10.3
- and SNA validation 10.4
- authenticating application logons 10.2
- authentication mechanisms
  - in SNA security 10.4.1.2
- for TCP/IP for IMS Connect 10.5
- link accessibility for public and private databases 10.3.1
- links and CONNECT clauses 10.3.2
- overview of gateway security requirements 10.1
- processing inbound connections 6.2
- specifying SNA conversation security 10.4.1
SECURITY=NONE SNA security option 10.4.1.1
SECURITY=NONE TCP/IP security option 10.5.1.1
security validation 10.4
SET
- gateway initialization parameter 8.7, 9.7
SET command 8.7, 9.7
shells
- see Bourne, Korn, and C shells 4
Side Information
- aka CPI-C symbolic destination names 6.4.7
side profile name 8.9.2.1
SINGLE_SITE
- and PGA_CAPABILITY parameter A.2
SNA
- and gateway components 1.4
- implementation of the gateway 1.5
- migrating existing gateway to the new release 11.1
- new gateway initialization parameters 11.1.5
- parameters 1.7.1.1
- PGA parameters A.1
- preinstallation procedures 4.3
- remote transaction initiation 1.7.1.1
- remote transaction termination on the gateway 1.7.1.3
- security validation 6.1, 10.4
- transaction types 1.8
- using SNA Node Configuration menu 6.5.2
SNA APPC
- function in the gateway 1.1
- see also APPC 1.1
snacfg.ctl file
- sample server definitions 6.3.2
SNACFG command 6.3.4
SNA communication package 8.9.2.1, 8.9.2.2, 8.9.2.3
- configuration for the gateway 5
SNA definitions
- See SNA Server definitions 6.3.3
SNA Node Configuration
- using, to configure IBM Communications Server 6.5.2
SNA profiles 10.4
SNA protocol
- gateway initialization parameters A
SNA security options
- SECURITY=NONE 10.4.1.1
- SECURITY=PROGRAM 10.4.1.2
SNA Server
- and SNA security validation 10.4
- configuring an IBM Communications Server 6.5
- configuring on Windows 6
- connection definition 6.4.3
- CPI-C symbolic destination names 6.4.7
- definition types 6.3.3
- dependent LUs 6.3.1
- function in gateway communication 10.4
- independent LUs 6.3.1
- link service definition 6.4.2
- mode definition 6.4.5
- remote LU definition 6.4.6
- required for Microsoft Windows 3.2.2
SNA Server definition
- creating, using MS Host Integration Server 6.4
SNA Server Manager 6.4
- creating SNA definitions, using MS Host Integration Server 6.4
- using, to create SNA definitions for the gateway 6.3.4
SNA Server selection 6.4.1
socket file descriptor
- returned by TCP/IP network to PGAINIT 1.7.1.1
software requirements 3.2
SQL*Plus
- sample, used when gateway and Oracle database share computer 8.3
- sample, used when gateway and Oracle database share machine 9.3
- to configure Oracle database 8.3, 9.3
- use in configuring Oracle database for Commit-Confirm 8.8.1
- using to connect to Oracle database 8.3, 9.3
statement
- describe 9.3
- DESCRIBE 8.3
- DFHRPL DD 7.1
system identifier
- choosing 4.3
system requirements 3

T

TCP/IP
- specifying conversation security 10.5.1
TCP/IP for IMS Connect
- and Remote Transaction Initiation 1.7.1.1
- configuring
  - for the gateway 9.6
  - gateway to permit multiple users 9.5
- function in the gateway 1.1
- gateway initialization parameters, list B
- gateway preinstallation procedures 4.3
- gateway support for, description 1.2
- Heterogeneous Services parameters needed 11.1.5
- HS parameter descriptions 11.1, 11.1.5
- implementation of the gateway 1.5
- IMS Connect release required on IBM mainframe 3.2.5
- installing sample applications 9.10.1
- loading the PGA_TCP_IMSC table 9.8
- mapping SNA parameters to 9.8
- migrating existing gateway using SNA to TCP/IP 11.2
- necessary to recompile TIPs when changing communication protocol 9.9.2.1
- new gateway initialization parameters 11.1.5
- non-persistent socket transaction type 1.9
- OLTP in gateway architecture 1.4
- parameter files
  - also see gateway initialization parameters, and PGA parameters 9.7
- performing post-installation procedures 9.10
- persistent socket transaction type 1.9
- pg4tcpmap tool output sample B.2
- PGA_TCP_DB parameter B.1
- PGA_TCP_USER parameter B.1
- PGA parameters 9.7, B.1
- remote transaction initiation 1.7.1.1
- remote transaction termination 1.7.1.3
- security 10.5
- security options
  - SECURITY=NONE 10.5.1.1
  - SECURITY=NONE, on all platforms 10.5.1.1
  - SECURITY=PROGRAM 10.5.1.2
- TIP recompile needed on upgrade 4.2.2, 9.9.2.1
- TRACE_LEVEL parameter B.1
- transaction types 1.9
- using pg4tcpmap tool B.1
- verifying
  - gateway installation 9.9.1
  - OLTP configuration 9.9.2, 9.9.2.1
TCP/IP protocol adapter
- for SNA 5
TCP protocol 5
terms, gateway terms defined 1.3
TIP
- Also called PL/SQL package 1.6
- body output files 8.6, 9.5
- conversions 1.2
- converting PL/SQL datatypes to RAW 1.7.1.2
- definition 1.3
- developer access to PL/SQL packages 8.6, 9.5
- developer authorization on gpglocal 8.3, 9.3
- functions 1.6
  - in Oracle database 1.7.1.2
- invalidated if package specifications reinstalled 8.4.1
- override 10.4.1.2
- override, in security for TCP/IP 10.5.1.2
- recompile
  - after reinstalling package specifications 8.4.1
  - on upgrade from release 4.0.1 4.2.2
- recompile upon upgrade from SNA to TCP/IP 4.2.2, 9.9.2.1
- recompiling when changing from SNA to TCP/IP 9.9.2.1
- regenerate to upgrade function and maintenance 8.6, 9.5
- remote transaction initiation (PGAINIT) 1.7.1.1
- specification output files 8.6, 9.5
- specifications 8.3, 8.6, 9.3, 9.5
  - generated by PGAU 1.6
  - use UTL_PG 8.3, 9.3
  - use UTL_RAW 8.3, 9.3
- specifying LUs 6.3.1
- trace access PL/SQL routines 8.3, 9.3
- upgrade considerations from previous versions 4.2.2
tnsnames.ora file 5, 8.3, A.2
- and Oracle Net considerations 11.1.4
- sample file for gateway using SNA A.5
- sample for gateway using TCP/IP B.2.2
TP name A.1
TRACE_LEVEL parameter 11.1.5, A.1
- on gateway using SNA A.1
- on gateway using TCP/IP for IMS Connect B.1
trace access 8.3, 9.3
Transaction Interface Package
- See TIP 1.3
transaction socket
- transaction type for TCP/IP 1.9
transaction types
- for TCP/IP for IMS/Connect 1.9
- one-shot, persistent and multi-conversational, for SNA 1.8
transferring
- initsid.ora gateway initialization file parameters 11.1.2
transparency
- (application) 1.2
- (location), on gateway using SNA 1.2

U

upgrading
- considerations 4.2.2
- existing TIP specifications 8.6, 9.5
user ID
- as security authentication 10.2
user ID mapping
- OLTP 10.3.2
USING parameter 5
utility
- dg4pwd C
UTL_PG 8.6, 9.5
- installing 8.3, 9.3
- package 9.5
  - definition C
  - invalidated or removed 8.4.1
UTL_RAW 8.3, 8.6, 9.3, 9.5
- interface
  - PL/SQL package 9.5
- package
  - invalidated or removed 8.4.1
- PL/SQL package
  - definition C
utlpg.sql
- file 8.4.1
- script 9.3
utlraw.sql
- file 8.4.1
- script 8.3, 9.3

V

VTAM 7.1
- configuring for connection to the gateway 7.1
VTAM logmode table 7.1

W

Windows
- and security 10.4
- communication protocol needed 3.2.2
- configuring SNA 5
- operating system 1.4
- processing inbound connections 6.2
- SNA conversation security 10.4.1

Z

z/OS 1.2, 1.3, 3.2.5, 7.1