Skip Headers
Oracle® Database Gateway for APPC Installation and Configuration Guide
11g Release 2 (11.2) for Microsoft Windows

Part Number E12079-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  K  L  M  N  O  P  R  S  T  U  V  W  Z 

Symbols

(HS=) (TNSNAMES parameter for Oracle Net), 5.1
with TCP/IP protocol, 5.1

A

action items
for installing the gateway, 4.5.6
ALTER USER command, 8.3, 9.3
american_america_us7ascii, 11.2.1, 11.2.1
APPC, 1.1
conversation security option, A.1.1, B.1.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.1
command
SET, 8.7, 9.7
COMMIT, A.1.2
COMMIT_CONFIRM, A.1.1, A.1.1, A.1.2, B.1.1
and PGA_CAPABILITY parameter, A.1.2
capability, A.1.2
commit-confirm, A.1.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
COMMIT/ROLLBACK, 3.2.5
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.1
configuring CICS OLTP for Transaction Server, 7.1
configuring your network, 5.1
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

data dictionary
See PG DD
data exchange
PGAXFER function, 1.7.1.2
database link, 1.6, A.1.2
creating, 8.3, 9.3
when configuring Oracle database, 8.3, 9.3
in configuring the network, 5.1
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
datastores
gateway access to, 1.1
DBMS_OUTPUT packages, 8.3, 8.3, 9.3, 9.3
DBMS_PIPE, 8.3, 8.3, 8.6, 8.6, 9.3, 9.3, 9.5, 9.5
definition types
in IBM Communications Server, 6.5.2
dependent LU, 7.1
See also LUs
DESCRIBE statement, 8.3, 9.3
DBMS_OUTPUT, 8.3, 8.3, 9.3
UTL_RAW, 8.3, 9.3
describe statement
DBMS_OUTPUT, 9.3
dfhcsdup.jcl file, 7.1, 7.1
DFHRPL DD statement, 7.1
DG4APPC
known restrictions, 2.3.1
see gateway
dg4pwd utility
definition, C.1
recommended security utility feature, on gateway using SNA, C.1
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.1.3
obsolete parameters, 11.1.5
parameter name misspelled, 8.7, 9.7
treating incoming APPC CONFIRM requests as errors, A.1.1, A.1.3

F

FDS_CLASS parameter, 11.1.5
FDS_CLASS_VERSION
parameter added, 11.1.6
FDS_INSTANCE parameter, 11.1.5
file
dfhcsdup.jcl, 7.1, 7.1
imsgen.asm, 7.1, 7.2
initPGAI.ora, A.1.2
initPGA.ora, 8.7, 8.7, 9.7, 9.7
initPGAU.ora, A.1.2
initsid.ora, 1.5, 8.7, 8.7, 8.8.2, 9.7, 11.1.2, A.1, A.1, B.1, B.1, C.1
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.1, 5.1, 5.1, 5.1, A.1.2, A.1.2
oralu62.asm, 7.1
oraplu62.asm, 7.1, 7.1, 7.1
pgaccau.sql, 8.8.1
pgacclg.asm, 8.9.3
pgacics.sql, 8.9, 8.9.2.1
pgadb2c.cob, 8.9.3
pgaecho.sql, 8.9, 9.9
pgaflip.asm, 7.1, 7.1, 7.1, 7.2
pgaflip.jcl, 7.1, 7.1, 7.1, 7.2
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, 8.9.2.3
pgareco.asm, 8.9.3
PGAU control files, 4.2.2
pgavsn.sql, 8.9, 9.9
pgddadev.sql, 8.6, 9.5
pgddapub.sql, 8.6, 9.5
prvtpgb.plb, 8.4
README.doc, 8.10.1, 9.10.1
tnsnames.ora, 5.1, 5.1, 5.1, 8.3, 9.3, A.1.2, A.1.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)
See UTL_PG
see UTL_RAW

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.1
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.1
initialization parameters
also see PGA parameters
described, 8.7, 9.7
for gateway using SNA, A, A.1
new and changed since Version 4 gateway, 11.1.5
renamed since v4, 11.1.5
SET, 8.7, 9.7, A.1.1, B.1.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.5.6
installation steps, 4.5
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
initPGA.ora, 8.7, 9.7
pre-installation steps for TPC/IP, 4.3
remote procedure, definition, C.1
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.6
requirements
hardware, 3.1
restoring to previous releases, 4.2.3
security options and overview, 10.1
also see, security
server
restoring previous version, 4.2.3
setting up multiple gateway instances, A.1.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.5.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 package, 9.3
gpglocal.pkb script, 8.3, 9.3, 9.3
gpglocal.pkh script, 8.3, 9.3, 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 parameters, 11.1.5
description, 11.1, 11.1.5
see also, (HS=)
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

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.1.3
IMS Connect
and security, 10.5
mainframe requirements, for gateway using TCP/IP, 3.2.5
IMS FLIP transaction, 7.1, 7.2
imsgen.asm file, 7.1, 7.2
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.1
verification of configuration
on gateway using SNA, 8.9.2.2
on gateway using TCP/IP for IMS Connect, 9.9.2.1
independent LU, 7.1, 7.1, 7.1
initialization files
See gateway initialization files, also see PGA parameters
initiating remote transactions, 1.7.1.1, 1.7.1.1
initPGAI.ora file, A.1.2
initPGA.ora file, 8.7, 8.7, 9.7, 9.7
initPGAU.ora file, A.1.2
initsid.ora file, 1.5, 8.7, 8.7, 8.8.2, 9.7, 11.1.2, A.1, A.1, B.1, B.1, C.1
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.5
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.1
protocol, 5.1
ivtno.ctl, 9.2, 9.2
ivtnod.sql, 9.2, 9.2
ivtnv.ctl, 9.2, 9.2
ivtnvd.sql, 9.2, 9.2

K

key
IPC, 5.1
known restrictions
for DG4APPC, 2.3.1
for PGAU, 2.3.2

L

link service definition, 6.4.2
listener.ora file, 5.1, 5.1, 5.1, 5.1, A.1.2, A.1.2
sample file for gateway using SNA, A.1.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.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
and gateway security, 10.3.2
dependent
for configuring LU6.2 for IMS/TM for the gateway, 7.1
in SNA security validation, 10.4
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

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
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 10.1.0.2.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.1
reconfiguring, 5.1
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.1.2, A.1.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
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
Oracle database, 1.7.1.2, 4.1, 4.3, 4.3.1, 5.1, 8.3, 8.3, 9.3, 9.3, 10.3.1, A.1.2, A.1.2, A.1.2, A.1.2, A.1.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, 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.1.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.1
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.6
see also gateway
Oracle Database Listener, 5.1
Oracle global transaction ID, 8.9.3, 8.9.3
Oracle Heterogeneous Services
See Heterogeneous Services
Oracle Net, 1.3, A.1.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.1
security considerations, 10.2
to start the gateway, 1.5
Oracle Net Listener, 5.1
Oracle Universal Installer
using, 4.5.6.1
to install gateway, 4.5.6
ORACLE_HOME, 7.1, 7.1, 7.1, 7.1, 8.7, 8.9.2.2, 8.9.2.3, 9.7
oralu62.asm file, 7.1
ORAPGA.APPCMVS.SAMPLIB, 7.1
oraplu62.asm file, 7.1, 7.1, 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, 8.6, 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
See PGA parameters
See RRM parameters
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
USING, 5.1
password
change using ALTER USER command, 8.3, 9.3
Oracle authentication, 10.2
Oracle password to be used by gateway, A.1.1
using TCP/IP, B.1.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
PG Data Dictionary
See PG DD
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
install script, 8.3, 9.3
installing for gateway configuration, 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
pg4tcpmap table, 11.2.1
see PGA_TCP_IMSC table
pg4tcpmap tool, 9.8, 10.5, 10.5.1.2, 11.2.1, B.1.1, B.1.1
definition, C.1
function, 1.2, 9.8
in remote transaction initiation, 1.7.1.1
on gateway using TCP/IP, 9.3, B.1.1
output sample, B.2
PGA
definition, C.1
initialization files
initPGAI.ora and initPGAU.ora, A.1.2
PGA parameters
described, 8.7, 9.7
list of, for gateway using TCP/IP, B.1.1
LOG_DESTINATION, A.1.1
on gateway using
SNA, A.1.1
TCP/IP, B.1.1
PGA_CAPABILITY, 8.7, 9.7, A.1.1, A.1.1, B.1.1
choosing settings, A.1.2
options for updating foreign databases, A.1.2
protections against data problems, A.1.2
PGA_CAPABILITY, for gateway using TCP/IP, B.1.1
PGA_CONFIRM, A.1.1, A.1.1
choosing settings, A.1.3
PGA_LOG_DB, A.1.1, A.1.1, B.1.1, B.1.1
PGA_LOG_PASS, A.1.1, A.1.1, B.1.1
on gateway using TCP/IP, B.1.1
PGA_LOG_USER, A.1.1, A.1.1, B.1.1, B.1.1
PGA_RECOVERY_PASS, A.1.1, A.1.1
PGA_RECOVERY_TPNAME, A.1.1, A.1.1
PGA_RECOVERY_USER, A.1.1, A.1.1
PGA_SECURITY_TYPE, 10.4.1.2, 10.5.1.2, A.1.1, B.1.1
PGA_SECURITY_TYPE=NONE, 10.4.1.1, 10.5.1.1
PGA_TCP_PASS
for gateway using TCP/IP, B.1.1
TRACE_LEVEL, A.1.1, A.1.1
on gateway using TCP/IP, B.1.1
PGA_CAPABILITY
See PGA parameters
PGA_CONFIRM
See PGA parameters for gateway using SNA or TCP/IP
PGA_SECURITY_TYPE
See PGA parameters
PGA_SECURITY_TYPE parameter
and TCP/IP security, 10.5.1
PGA_SECURITY_TYPE=NONE, 10.4.1.1, 10.5.1.1
PGA_TCP_DB
PGA parameter
for gateway using TCP/IP, B.1.1
PGA_TCP_DB parameter (TCP/IP only), 11.1.5
PGA_TCP_DB PGA parameter (TCP/IP only), B.1.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.1
PGA_TCP_USER parameter (TCP/IP only), 11.1.5, B.1.1
PGAADMIN, 8.3, 8.3, 8.9.1, 9.3, 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, 8.9.2.1
pgacr8au.sql script, 8.3, 9.3
pgadb2c.cob file, 8.9.3
pgaecho.sql file, 8.9, 8.9.1, 9.9, 9.9.1
pgaflip.asm file, 7.1, 7.1, 7.1, 7.2
pgaflip.jcl file, 7.1, 7.1, 7.1, 7.2
PGAI
setting up, A.1.2
pgaidms.sql file, 8.9
pgaimsc.sql, 9.3
pgaims.sql, 9.2, 9.2, 9.2, 9.2
pgaims.sql file, 8.9, 8.9.2.2, 8.9.2.2, 9.9
on gateway using TCP/IP, 9.9.2.1, 9.9.2.1
PGAINIT, 1.7.1.1
PGAINIT function, 1.7.1.1, 1.7.1.1, C.1
PGAINIT TIP, 9.8
pgamvs.sql file, 8.9, 8.9.2.3
pgareco.asm file, 8.9.3
PGATERM function, 1.7.1.1, C.1
pgatiptr.sql script, 8.3, 9.3
PGAU, 5.1
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.1
restoring previous versions, 4.2.3
setting up, A.1.2
upgrading existing PG DD entries, 8.6, 9.5
PGAU commands
DEFINE DATA
COBOL COPY REPLACE restrictions, 2.3.2
GENERATE, 8.6, 8.6, 9.5, 9.5
produces TIP in output files, 8.6, 9.5
to upgrade existing TIPs, 8.6, 9.5
pgavsn.sql file, 8.9, 8.9.1, 9.9, 9.9.1
PGAXFER function, 1.7.1.1, 1.7.1.2, C.1
PGDD
compatibility issues between new and older gateways, 8.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
pgddcr8r.sql script, 8.6, 9.5
pgddcr8.sql script, 8.3, 9.3
pgddcr8s.sql script, 8.6, 9.5
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.1
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.1
UTL_RAW function, C.1
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.1
developer access to, 8.6, 9.5
enabled, 8.3, 9.3
functions, 1.6
See TIP
PL/SQL stored procedure, 8.8.1
used for logging transactions, 8.8.1
PL/SQL stored procedure specification
also called "TIP"
See PL/SQL package
postinstallation steps for OLTP
on gateway using SNA, 8.10
on gateway using TCP/IP, 9.10
preinstallation steps
for SNA, 4.3
privileges
needed to create TIPs, 8.6, 8.6, 9.5, 9.5
Procedural Gateway Administration
See PGA
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.1
TCP, 5.1
prvtpgb.plb
file, 8.4
script, 8.3, 8.4, 9.3
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, 10.5.1.2, B.1.1
READ_ONLY
PGA_COMPATIBILITY setting, A.1.2
README.doc file, 8.10.1, 9.10.1
recompiling TIPs
See TIP
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
remote procedure
definition, C.1
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
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.6
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.1.2
RPC
definition, 1.3
function
PGAINIT, 1.7.1.1, 1.7.1.1, C.1
PGATERM, C.1
PGAXFER, 1.7.1.2, C.1
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.1.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, 9.3
gpglocal.pkh, 8.3, 9.3, 9.3
pgacr8au.sql, 8.3, 9.3
pgddadev.sql, 8.6, 9.5
pgddapub.sql, 8.6, 9.5
pgddcr8r.sql, 8.6, 9.5
pgddcr8.sql, 8.3, 9.3
pgddcr8s.sql, 8.6, 9.5
pgddupgr.sql, 8.4.2
prvtpgb.plb, 8.3, 8.4, 9.3
prvtrawb.plb, 8.3, 8.4, 9.3
utlpg.sql, 8.3, 8.4.1, 9.3
utlraw.sql, 8.3, 8.4.1, 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 validation, 10.4
SECURITY=NONE SNA security option, 10.4.1.1
SECURITY=NONE TCP/IP security option, 10.5.1.1
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.1.2
SNA
and gateway components, 1.4
implementation of the gateway, 1.5
location of gateway initialization parameters, A.1
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.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
SNA communication package, 8.9.2.1, 8.9.2.2, 8.9.2.3
configuration for the gateway, 5.1
SNA definitions
See SNA Server definitions
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, 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
SNACFG command, 6.3.4
snacfg.ctl file
sample server definitions, 6.3.2
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, 8.3, 9.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, 8.3
describe, 9.3
DFHRPL DD, 7.1
system identifier
choosing, 4.3
system requirements, 3

T

TCP protocol, 5.1
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
performing post-installation procedures, 9.10
persistent socket transaction type, 1.9
pg4tcpmap tool output sample, B.2
PGA parameters, 9.7, B.1.1
PGA_TCP_DB parameter, B.1.1
PGA_TCP_USER parameter, B.1.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.1
transaction types, 1.9
using pg4tcpmap tool, B.1.1
verifying
gateway installation, 9.9.1, 9.9.1
OLTP configuration, 9.9.2, 9.9.2.1
TCP/IP protocol adapter
for SNA, 5.1
terms, gateway terms defined, 1.3
TIP
Also called PL/SQL package
body output files, 8.6, 9.5
conversions, 1.2
converting PL/SQL datatypes to RAW, 1.7.1.2
definition, 1.3, 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, 1.7.1.1
specification output files, 8.6, 9.5
specifications, 8.3, 8.3, 8.6, 8.6, 8.6, 9.3, 9.3, 9.5, 9.5, 9.5
generated by PGAU, 1.6, 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.1, 5.1, 5.1, 8.3, 9.3, A.1.2, A.1.2
and Oracle Net considerations, 11.1.4
sample file for gateway using SNA, A.1.5
sample for gateway using TCP/IP, B.2.2
TP name, A.1.1
trace access, 8.3, 9.3
TRACE_LEVEL parameter, 11.1.5, A.1.1
on gateway using SNA, A.1.1
on gateway using TCP/IP for IMS Connect, B.1.1
Transaction Interface Package
See TIP
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.1
utility
dg4pwd, C.1
UTL_PG, 8.6, 9.5
installing, 8.3, 9.3
package, 8.6, 9.5
definition, C.1
invalidated or removed, 8.4.1
UTL_RAW, 8.3, 8.3, 8.3, 8.6, 9.3, 9.3, 9.3, 9.5
interface
PL/SQL package, 8.6, 9.5
package
invalidated or removed, 8.4.1
PL/SQL package
definition, C.1
utlpg.sql
file, 8.4.1
script, 8.3, 8.4.1, 9.3
utlraw.sql
file, 8.4.1
script, 8.3, 8.4.1, 9.3

V

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

W

Windows
and security, 10.4
communication protocol needed, 3.2.2
configuring SNA, 5.1
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, 7.1, 7.1