Skip Headers
Oracle® Database Gateway for APPC Installation and Configuration Guide
11g Release 2 (11.2) for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

Part Number E12078-01
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
PDF · Mobi · ePub

Index

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

Symbols

$ cd $ORACLE_HOME $ mkdir dg4appc, 11.2, 12.2
$ORACLE_HOME, 10.1.1, 10.1.3, 10.1.3, 11.7, 11.9.2.2, 11.9.2.3, 12.7
$ORACLE_HOME/bin/pg4asrv, 13.4.1.3
(HS=) (TNSNAMES parameter for Oracle Net), 5.1
with TCP/IP protocol, 5.1

A

action items
for installing the gateway, 4.5.1
activating and verifying SNA server profiles, 7.6
AIX
activating profiles, 7.6
configuring SNA, 5.1
creating mode profiles, 7.5.3
processing inbound connections, 7.1
SNA conversation security, 13.4.1
SNA security option SECURITY =SAME, 13.4.1.3
SNA security option SECURITY=NONE, 13.4.1.1
SNA security option SECURITY=PROGRAM, 13.4.1.2
SNA security validation, 13.4
System Management Interface Tool, 7.3
AIX-based communications package
SNA server, 7
ALTER USER command, 11.3, 12.3
american_america_us7ascii, 14.2.1
APPC, 1.1
conversation security option, A.1.1, B.1.1
APPC/MVS
installation verification, 11.9.2.3
verification of configuration, 11.9.2.3
architecture
components of the gateway, 1.4
ASCII
automatic conversion, 1.2
authentication
for operating system, 13.2
for Oracle, 13.2
types, security, 13.2

B

backout possibilities during migration, 14.1.3

C

choosing the device type
on Linux, 6.5.4
CICS, 1.8, 3.2.5
ATTACHSEC parameter
on HP-UX, 8.1
on Solaris, 9.1
installation verification
on gateway using SNA, 11.9.2.1
security options not supported by the gateway
on HP-UX, 8.1
on Solaris, 9.1
transaction ID, 11.9.2.1
verifying configuration
on gateway using SNA, 11.9.2.1
CICS Transaction Server for z/OS
authentication mechanism
on all platforms, 13.4.1.2
OLTP
configuration verification, 11.9.2.1
TP name length, A.1.1
command
SET, 11.7, 12.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, 11.8, 11.8.3
gateway initialization parameters, 11.8.2
OLTP, 11.8.3
Oracle database, 11.8.1
sample applications, 11.9.3
transaction log, 11.9.3
COMMIT/ROLLBACK, 3.2.5
communications
between server, gateway and remote host, 1.6
needed for HP-UX, 3.2.2
needed for Solaris, 3.2.2
configuration
gateway directories, 12.2
configuration verification
OLTP
on gateway using SNA, 11.9
on gateway using TCP/IP for IMS Connect, 12.9, 12.9.2
configuring
commit-confirm, 11.8, 11.8.3
gateway
optional steps to allow multiple users using SNA, 11.6
optional steps to allow multiple users using TCP/IP for IMS Connect, 12.5
gateway directories, 11.2
Oracle database, 11.8.1
upgrading from previous releases, 11.4, 12.4
Oracle database for gateway using TCP/IP for IMS Connect
pre-configuration steps, 12.2
SNAP-IX, 9.2
TCP/IP for IMS Connect
on the gateway, 12.6
the gateway
for TCP/IP for IMS Connect, 12
using SNA, 11
the OLTP, 10
your network
using SNA, 5.1
configuring a LAN device
on Linux, 6.5.5
Configuring APPC/MVS, 10.1.3, 10.1.3
Configuring CICS Transaction Server for z/OS, 10.1.1
configuring your network, 5.1
CONNECT clause, 13.4.1.2
for database link security, 13.3.2
in TCP/IP security, 13.5.1.2
CPI-C, 11.10.1
CPI-C profiles
creating
on HP-UX, 8.7
on Solaris, 9.2.8.6
creating, on Solaris, 9.2.8.5
creating
mode profiles, on AIX, 7.5.3
public database link, 11.3, 12.3
SNAPlus2 definitions, 8.5, 8.5
SNAPlus2 profiles, 8.3
creating devices
on Linux systems, 6.5.3
creating IBM communications server definitions for the gateway
on Linux, 6.5
creating local LUs
on Linux, 6.5.9
creating partner LUs
on Linux, 6.5.11
creating peer connections
on Linux, 6.5.6
creating the configuration
on Linux systems, 6.5.1
creating the CPI-C side information profile
on Linux, 6.5.13
creating the node
on Linux systems, 6.5.2

D

data dictionary
See PG DD
data exchange
PGAXFER function, 1.7.1.2
database link, 1.6, A.1.2
creating, 11.3, 12.3
when configuring Oracle database, 11.3, 12.3
in configuring the network, 5.1
in verifying gateway installation
on gateway using SNA, 11.9.1
on gateway using TCP/IP for IMS Connect, 12.9.1
public and private, 13.3.1
security, CONNECT clause, 13.3.2
database link name
modifying .sql files, 11.9, 12.9
datastores
gateway access to, 1.1
DBMS_OUTPUT packages, 11.3, 11.3, 12.3, 12.3
DBMS_PIPE, 11.3, 11.3, 11.6, 11.6, 12.3, 12.3, 12.5, 12.5
DEFINE TRANSACTION statement, 8.4.1
defining local LUs
on Linux, 6.5.10
defining partner LUs
on Linux, 6.5.12
defining the adjacent node
on Linux, 6.5.8
defining the link station
on Linux, 6.5.7
de-installing
the gateway, 4.6
dependent LU
and OLTP, on HP-UX, 8.4
on AIX, 7.2
on HP-UX, 8.4
on Solaris, 9.2.4
DESCRIBE statement, 11.3, 12.3
DBMS_OUTPUT, 11.3, 11.3, 12.3
UTL_RAW, 11.3, 12.3
describe statement
DBMS_OUTPUT, 12.3
dfhcsdup.jcl file, 10.1.1, 10.1.1
DFHRPL DD statement, 10.1.1
DG4APPC
known restrictions, 2.3.1
see gateway
dg4pwd, C.1
dg4pwd utility
definition, C.1
recommended security utility feature, on gateway using SNA, C.1
directories
for installing gateway and OIS files, 11.2, 12.2
DISPLAY datatypes, 2.3.1

E

EBCDIC language, 1.2
gateway know restrictions pertaining to, 2.3.1
necessary to change to ASCII when using TCP/IP, 12.9.2.1
enhancements
using PGAU to automatically upgrade PG DD entries, 11.6, 12.5
error
during commit processing, A.1.3
obsolete parameters, 14.1.5
parameter name misspelled, 11.7, 12.7
treating incoming APPC CONFIRM requests as errors, A.1.1, A.1.3

F

FDS_CLASS parameter, 14.1.5
FDS_CLASS_VERSION
parameter added, 14.1.6
FDS_INSTANCE parameter, 14.1.5
file
dfhcsdup.jcl, 10.1.1, 10.1.1
imsgen.asm, 10.2
initPGAI.ora, A.1.2
initPGA.ora, 11.7, 11.7, 12.7, 12.7
initPGAU.ora, A.1.2
initsid.ora, 1.5, 11.7, 11.7, 11.7, 11.7, 11.7, 11.8.2, 12.7, 14.1.2, A.1, A.1, B.1, B.1, C.1
gateway parameters for gateway using SNA, 11.7
gateway parameters for gateway using TCP/IP for IMS Connect, 12.7
new parameters on gateway using SNA, 14.1.5
new startup shell parameters, 14.1.6
parameters changed since V4, 14.1.5
listener.ora, 5.1, 5.1, 5.1, 5.1, A.1.2, A.1.2
oraplu62.asm, 10.1.1, 10.1.3
pgaccau.sql, 11.8.1
pgacclg.asm, 11.9.3
pgacics.sql, 11.9, 11.9.2.1
pgadb2c.cob, 11.9.3
pgaecho.sql, 11.9, 12.9
pgaflip.asm, 10.1.1, 10.1.1, 10.2
pgaflip.jcl, 10.1.1, 10.1.1, 10.2
pgaidms.sql, 11.9
pgaim.sql, 11.9.2.2, 12.9.2.1
pgaims.sql, 11.9, 12.9, 12.9.2.1
pgamvs.sql, 11.9, 11.9.2.3
pgareco.asm, 11.9.3
pgasna.export, 7.3, 7.5.2
PGAU control files, 4.2.2
pgavsn.sql, 11.9, 12.9
pgddadev.sql, 11.6, 12.5
pgddapub.sql, 11.6, 12.5
prvtpgb.plb, 11.4, 12.4
tnsnames.ora, 5.1, 5.1, 5.1, 11.3, 12.3, A.1.2, A.1.2
utlpg.sql, 11.4.1, 12.4.1
utlraw.sql, 11.4.1, 12.4.1
FLIP transaction
OLTP configuration
and verification for APPC/MVS, 11.9.2.3
and verification for CICS Transaction Server for z/OS, 11.9.2.1
and verification for IMS/TM on gateway using SNA, 11.9.2.2
and verification for IMS/TM on gateway using TCP/IP, 10.2, 12.9.2.1
function
put_line, 11.3, 12.3
functions
see RPC (remote procedural call)
See UTL_PG
see UTL_RAW

G

gateway
access to IBM datastores, 1.1
and SNAPlus2 on HP-UX, 8
communication overview, 1.6
communications with all platforms, 1.1
compatibility with other SNA-enabled products, 3.2.5
components, 1.4, 11
for SNA and TCP/IP for IMS Connect, 1.5
configuring, 11
for multiple users, on gateway using TCP/IP for IMS Connect, 12.5
for SNA, 5.1
for TCP/IP for IMS Connect, 12, 12.6
configuring for multiple users
on gateway using SNA, 11.6
creating
SNA server profiles for, 7.3
SNAP-IX definitions for, 9.2.5
SNAP-IX profiles for, 9.2.3
SNAPlus2 definitions for, 8.5
SNAPlus2 profiles on HP-UX, 8.3
de-installing, 4.6
directory locations for configuration, 11.2, 12.2
factors affecting memory requirements, 3.1
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, 11.7, 12.7
for gateway using SNA, A, A.1
new and changed since Version 4 gateway, 14.1.5
renamed since V4, 14.1.5
SET, 11.7, 12.7, A.1.1, B.1.1
installation
first-time install, configuring the Oracle database, 11.3, 12.3
pre-installation procedures, 4.3
steps, 4.5
verification, 11.9.1, 12.9.1
with Oracle Universal Installer action items, 4.5.1
installing, 4
known restrictions, when using SNA, 2.3.1
migrating to new release, using SNA, 14.1
network attachment requirements, 3.1.1
overview, 1.1
parameter files, 11.7, 12.7
also see gateway initialization parameters, and PGA parameters
initPGA.ora, 11.7, 12.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
requirements
hardware, 3.1
restoring to previous releases, 4.2.3
security options and overview, 13.1
also see, security
server
restoring previous version, 4.2.3
setting up multiple gateway instances, A.1.2
SNA
SNAP-IX configuration on Solaris, 9, 13.4
SNA security validation, 13.4
startup shell parameters
FDS_CLASS_VERSION, 14.1.6
steps to install, via Oracle Universal Installer, 4.5.1
upgrading
from previous release, 4.2
preparing to upgrade, 4.2.1
gateway initialization parameters
for commit-confirm support, 11.8.2
new, 14.1.5
gateway security requirements, 13
gateway using TCP/IP for IMS Connect
gateway initialization parameters needed, B
transaction types, 1.9
gpglocal, 11.3, 12.3
needed to compile PGAU-generated TIP specifications, 11.3, 12.3
gpglocal package, 12.3
gpglocal.pkb script, 11.3, 12.3, 12.3
gpglocal.pkh script, 11.3, 12.3, 12.3
grant
access, 11.6, 12.5
authorization, 11.3, 12.3
execute, 11.3, 12.3
explicit, 11.6, 12.5
private, 11.6, 12.5
public, 11.6, 12.5

H

hardware requirements, 3.1
Heterogeneous Services (HS), 14.1.5
and Oracle Net considerations, on gateway using SNA, 14.1.4
catalogs
installing, on gateway using SNA, 11.3
installing, on gateway using TCP/IP for IMS Connect, 12.3
parameters needed for gateway using TCP/IP, 14.1.5
HP-UX
and security, 13.4
and xsnapadmin, 8.2
APPC communication support provided by SNAPlus2, 8
communication protocol needed, 3.2.2
configuring SNA, 5.1
creating SNAPlus2 definitions for the gateway, 8.5
dependent LUs, 8.4
in gateway architecture, 1.4
in verifying CICs, 11.9.2.1
operating system, 1.4
processing inbound connections, 8.1
SNA conversation security, 13.4.1
SNA security option SECURITY =SAME, 13.4.1.3
SNA security option SECURITY=NONE, 13.4.1.1
SNA security option SECURITY=PROGRAM, 13.4.1.2
SNA security validation, 13.4
HS parameters, 14.1.5
description, 14.1, 14.1.5
see also, (HS=)
HS_COMMIT_STRENGTH_POINT parameter, 14.1.5
HS_DB_DOMAIN parameter, 14.1.5
HS_DB_INTERNAL_NAME parameter, 14.1.5
HS_DB_NAME parameter, 14.1.5
HS_DESCRIBE_CACHE_HWM parameter, 14.1.5
HS_FDS_FETCH_ROWS parameter, 14.1.5
HS_LANGUAGE parameter, 14.1.5
HS_NLS_DATE_FORMAT parameter, 14.1.5
HS_NLS_DATE_LANGUAGE parameter, 14.1.5
HS_OPEN_CURSORS parameter, 14.1.5
HS_ROWID_CACHE_SIZE parameter, 14.1.5

I

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, 13.5
mainframe requirements, for gateway using TCP/IP, 3.2.5
IMS FLIP transaction, 10.2
imsgen.asm file, 10.2
IMS/TM
installation verification
on gateway using SNA, 11.9.2.2
on gateway using TCP/IP for IMS Connect, 12.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, 11.9.2.2
on gateway using TCP/IP for IMS Connect, 12.9.2.1
independent LU, 10.1.1, 10.1.3
vs. dependent LU, on HP-UX, 8.4
independent LU, on AIX, 7.2
independent versus dependent LUs
on Linux, 6.3
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, 11.7, 11.7, 12.7, 12.7
initPGAU.ora file, A.1.2
initsid.ora file, 1.5, 11.7, 11.7, 11.7, 11.7, 11.7, 11.8.2, 12.7, 14.1.2, A.1, A.1, B.1, B.1, C.1
gateway parameters on gateway using SNA, 11.7
gateway parameters on gateway using TCP/IP for IMS Connect, 12.7
HS parameter descriptions, 14.1, 14.1.5
new parameters, on gateway using SNA, 14.1.5
new startup shell parameters, 14.1.6
parameters changed since V4, 14.1.5
installation
steps, 4.5
installation verification
CICS on gateway using SNA, 11.9.2.1
gateway
with SNA, 11.9.1
with TCP/IP for IMS Connect, 12.9.1
IMS/TM
on gateway using SNA, 11.9.2.2
on gateway using TCP/IP for IMS Connect, 12.9.2.1
OLTP, 11.9.2
installing
and configuring the gateway, 4
preinstallation steps, 4.3
sample applications
on gateway for SNA protocol, 11.10.1
on gateway with TCP/IP for IMS Connect, 12.10.1
IPC
key, 5.1
protocol, 5.1
ivtno.ctl, 12.2, 12.2
ivtnod.sql, 12.2, 12.2
ivtnv.ctl, 12.2, 12.2
ivtnvd.sql, 12.2, 12.2

K

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

L

Link Station
creating, 8.7
Link Station profiles
on AIX, 7.5.2
using smit to start, on AIX, 7.6
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
Local LUs
creating
on AIX, 7.5.4
on HP-UX, 8.7
on Solaris, 9.2.8.4
LOG_DESTINATION parameter, 14.1.5
for gateway using SNA, 14.1.2, 14.1.2
for gateway using TCP/IP, B.1.1
logmode entry name, 11.9.2.1
LU name
assigning to the gateway, on AIX, 7.5.4
LU6.2
and specifying SNA conversation security, 13.4.1
LUs
(Logical Units), 7.5.4
alias identified by side information profile, on AIX, 7.5.7
and gateway security, 13.3.2
and Side Information Profiles, 8.3
in SNA security validation, 13.4
independent
in configuring APPC/MVS on the gateway, 10.1.3
in configuring CICS Transaction Server for z/OS, 10.1.1
vs. dependent, on AIX, 7.2
vs. dependent, on HP-UX, 8.4
vs. dependent, on Solaris, 9.2.4
local
profile, on AIX, 7.5.4
on AIX, 7.2
Partner
location profile, on AIX, 7.5.6
on AIX, 7.5.5
on HP-UX, 8.4
on Solaris, 9.2.8.5
profile, 7.5.5
Partner LU name
assigning alias, on AIX, 7.5.5
recommended for the gateway, on HP-UX, 8.4

M

mainframe requirements, 3.2.5
migrating
an existing gateway to use TCP/IP, 14.2
backout considerations when migrating to new release, 14.1.3
existing gateway instance to new release, using SNA, 14.1
to 10.1.0.2.0
special parameters, 14.1.5
Mode
and Side Information Profiles, 8.3
mode definitions
creating
on HP-UX, 8.7
on Solaris, 9.2.8.6
mode profiles
creating on AIX server, 7.5.3
creating on Solaris, 9.2.8.5
multi-conversational 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
node profile, on AIX, 7.5.1
non-persistent socket transaction type for TCP/IP for IMS Connect, 1.9

O

obsolete parameters, in gateway using SNA, 14.1.5
OLTP, 5.1, A.1.2, A.1.2
and dependent LUs
on AIX, 7.2
on HP-UX, 8.4
on Solaris, 9.2.8.3
and SECURITY=PROGRAM option, on all platforms, 13.4.1.2
and SECURITY=PROGRAM option, on all platforms using TCP/IP, 13.5.1.2
and SNA SECURITY=SAME option, on all platforms, 13.4.1.3
configuration, 10
configuration verification
APPC/MVS, 11.9.2.3
CICS Transaction Server for z/OS, 11.9.2.1
on gateway using SNA, 11.9
on gateway using SNA IMS/TM, 11.9.2.2
on gateway using TCP/IP for IMS Connect, 12.9
configuring
for gateway using TCP/IP for IMS Connect, 12.6
currently supported types, 10.1, 11.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, 11.9.2, 12.9.2
mode name specification, on AIX, 7.5.3
post-installation steps
on gateway using SNA, 11.10
on gateway using TCP/IP for IMS Connect, 12.10
remote, 1
requirements, 3.2.5
security and inbound APPC session requests
on HP-UX, 8.1
on Solaris, 9.1
security on the gateway, 13.1
SNA security option
on all platforms, 13.4.1.2
user ID mapping, 13.3.2
verifying configuration
on gateway using SNA, 11.9.2
on gateway using TCP/IP for IMS Connect, 12.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, 11.3, 11.3, 12.3, 12.3, 13.3.1, A.1.2, A.1.2, A.1.2, A.1.2, A.1.2
and gateway security, 13.3.2
and TCP/IP for IMS Connect
pre-configuration steps, 12.2
component of the gateway, 1.4
configuring for commit-confirm, 11.8.1
definition, 1.3, 1.3
enabling DBMS_OUTPUT PL/SQL package, 11.3, 12.3
logon authentication needed, 13.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, 13.3.2
in starting the gateway, 1.5
shipped with PL/SQL packages, 11.6, 12.5
stores PL/SQL, C.1
upgrading
from previous releases, 11.4, 12.4
verifying
APPC/MVS configuration, 11.9.2.3
gateway installation with SNA, 11.9.1
gateway installation with TCP/IP for IMS Connect, 12.9.1
IMS/TM, on gateway using SNA, 11.9.2.2
IMS/TM, on gateway using TCP/IP for IMS Connect, 12.9.2.1
version requirements, 3.2.3
Oracle Database Gateway for APPC
also see gateway
de-installing, 4.6
development environment, 1.2
functions, 1.8
Oracle Database Listener, 5.1
Oracle global transaction ID, 11.9.3, 11.9.3
Oracle Heterogeneous Services
See Heterogeneous Services
Oracle Net, 1.3, A.1.1
considerations, when migrating gateway featuring SNA, 14.1.4
Heterogeneous services/tnsnames.ora considerations, on gateway using SNA, 14.1.4
on gateway using TCP/IP, B.1.1
security considerations, 13.2
to start the gateway, 1.5
Oracle Net Listener, 5.1
Oracle Universal Installer
using, 4.5.1.1
to install gateway, 4.5.1
Oracle10g Database
and networking products needed, 3.2.4
ORAPGA.APPCMVS.SAMPLIB, 10.1.3
oraplu62.asm file, 10.1.1, 10.1.3
override
user ID and password, 13.4.1.2, 13.5.1.2

P

package
DBMS_OUTPUT, 11.3, 12.3
gpglocal, 12.3
UTL_PG, 11.3, 11.6, 12.3, 12.5
invalidated or deinstalled, 11.4.1, 12.4.1
UTL_RAW, 11.3, 12.3
invalidated or deinstalled, 11.4.1, 12.4.1
package specifications
avoid reinstalling, 11.4.1, 12.4.1
reinstalling, 11.4.1, 12.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, 14.1.5
FDS_CLASS_VERSION, 14.1.6
gateway initialization parameter, described, 11.7, 12.7
needed for commit-confirm support, 11.8.2
new
FDS_CLASS (startup shell), 14.1.5
FDS_INSTANCE (startup shell), 14.1.5
obsolete, in gateway using SNA, 14.1.5
PGA
described for SNA, 11.7
described for TCP/IP, 12.7
renamed since version 4 (gateway initialization), 14.1.5
see PGA parameters and gateway
USING, 5.1
Partner LU
locations profile, on AIX, 7.5.6
on HP-UX, 8.4, 8.7
on Solaris, 9.2.8.5
profile, 7.5.5
see also LUs
Partner
password
change using ALTER USER command, 11.3, 12.3
Oracle authentication, 13.2
Oracle password to be used by gateway, A.1.1
using TCP/IP, B.1.1
overrides, 13.4.1.2, 13.5.1.2
with operating system authentication, 13.2
PDS (partitioned dataset), 10.1.3
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, 11.6, 12.5
creating public synonyms for multiple users, 11.6, 12.5
definition, 1.3
install script, 11.3, 12.3
installing for gateway configuration, 11.3, 12.3
no access from earlier PGAU versions, 4.2.2
restoring previous version, 4.2.3
tables, 11.6, 12.5
upgrade when upgrading gateway, 11.4.2, 12.4.2
using PGAU to upgrade existing entries, 11.6, 12.5
pg4tcpmap table, 14.2.1
see PGA_TCP_IMSC table
pg4tcpmap tool, 12.8, 13.5, 13.5.1.2, 14.2.1, B.1.1, B.1.1
definition, C.1
function, 1.2, 12.8
in remote transaction initiation, 1.7.1.1
on gateway using TCP/IP, 12.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, 11.7, 12.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, 11.7, 12.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, 13.4.1.2, 13.5.1.2, A.1.1, B.1.1
PGA_SECURITY_TYPE=NONE, on all platforms, 13.4.1.1, 13.5.1.1
PGA_SECURITY_TYPE=SAME, on all platforms, 13.4.1.3
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, 13.5.1
PGA_SECURITY_TYPE=NONE, on all platforms, 13.4.1.1, 13.5.1.1
PGA_SECURITY_TYPE=SAME, on all platforms, 13.4.1.3
PGA_TCP_DB
PGA parameter
for gateway using TCP/IP, B.1.1
PGA_TCP_DB parameter (TCP/IP only), 14.1.5
PGA_TCP_DB PGA parameter (TCP/IP only), B.1.1
PGA_TCP_IMSC table, 14.2.1
for mapping SNA parameters to TCP/IP, 12.8
loading, on gateway using TCP/IP, 12.8
PGA_TCP_PASS parameter (TCP/IP only), 14.1.5
PGA_TCP_PASS PGA parameter (TCP/IP only), B.1.1
PGA_TCP_USER parameter (TCP/IP only), 14.1.5, B.1.1
PGAADMIN, 11.3, 11.3, 11.9.1, 12.3, 12.3, 12.9.1
creating the gateway administrator user ID, 11.3, 12.3
granting access to additional users, 11.6, 12.5
granting execution privileges on DBMS_PIPE, 11.3, 12.3
initial password during creation, 11.3, 12.3
pgaccau.sql file, 11.8.1
pgacclg.asm file, 11.9.3
pgacics.sql file, 11.9, 11.9.2.1
pgacr8au.sql script, 11.3, 12.3
pgadb2c.cob file, 11.9.3
pgaecho.sql file, 11.9, 11.9.1, 12.9, 12.9.1
pgaflip.asm file, 10.1.1, 10.1.1, 10.2
pgaflip.jcl file, 10.1.1, 10.1.1, 10.2
PGAI
setting up, A.1.2
pgaidms.sql file, 11.9
pgaimsc.sql, 12.3
pgaims.sql, 12.2, 12.2, 12.2, 12.2
pgaims.sql file, 11.9, 11.9.2.2, 11.9.2.2, 12.9
on gateway using TCP/IP, 12.9.2.1, 12.9.2.1
PGAINIT, 1.7.1.1
PGAINIT function, 1.7.1.1, 1.7.1.1, C.1
PGAINIT TIP, 12.8
pgamvs.sql file, 11.9, 11.9.2.3
pgareco.asm file, 11.9.3
pgasna.export file, 7.3, 7.5.2
PGATERM function, C.1
pgatiptr.sql script, 11.3, 12.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, 11.3, 12.3
-generated TIP specifications use UTL_RAW, 11.3, 12.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, 11.6, 12.5
PGAU commands
DEFINE DATA
COBOL COPY REPLACE restrictions, 2.3.2
GENERATE, 11.6, 11.6, 12.5, 12.5
produces TIP in output files, 11.6, 12.5
to upgrade existing TIPs, 11.6, 12.5
pgavsn.sql file, 11.9, 11.9.1, 12.9, 12.9.1
PGAXFER function, 1.7.1.2, C.1
PGDD
compatibility issues between new and older gateways, 11.5
pgddadev.sql
file, 11.6, 12.5
script, 11.6, 12.5
pgddapub.sql
file, 11.6, 12.5
script, 11.6, 12.5
pgddcr8r.sql script, 11.6, 12.5
pgddcr8.sql script, 11.3, 12.3
pgddcr8s.sql script, 11.6, 12.5
PGDDDEF role, 11.6, 12.5
PGDDGEN role, 11.6, 12.5
adding a privilege for upgrading PG DD entries, 11.6, 12.5
pgddupgr.sql script, 11.4.2, 12.4.2
PGDL (Procedural Gateway Definition Language)
definition, C.1
PL/SQL, 1.3
code generator, 1.2
datatypes, 1.6
converted to RAW, 1.7.1.2
function in the gateway, 1.1, 1.6
running pgatiptr.sql script to create routines, 11.3, 12.3
UTL_PG package function, C.1
UTL_RAW function, C.1
UTL_RAW package installation
on gateway using SNA, 11.3
on gateway using TCP/IP for IMS Connect, 12.3
PL/SQL package
definition, 1.3, C.1
developer access to, 11.6, 12.5
enabled, 11.3, 12.3
functions, 1.6
See TIP
PL/SQL stored procedure, 11.8.1
used for logging transactions, 11.8.1
PL/SQL stored procedure specification
also called "TIP"
See PL/SQL package
post-installation steps for OLTP
on gateway using SNA, 11.10
on gateway using TCP/IP, 12.10
pre-installation steps
for SNA, 4.3
privileges
needed to create TIPs, 11.6, 11.6
Procedural Gateway Administration
See PGA
Procedural Gateway Administration Utility
see PGAU, 1.6
processing inbound connections
Linux, 6.2
processor OLTP
configuring, for commit-confirm, 11.8.3
profiles
see SNA server profiles
protocol
IPC, 5.1
TCP, 5.1
prvtpgb.plb
file, 11.4, 12.4
script, 11.3, 11.4, 12.3, 12.4
prvtrawb.plb script, 11.3, 11.4, 12.3, 12.4
public synonyms for multiple PG DD users, 11.6, 12.5
put_line function, 11.3, 12.3

R

RACF, 13.5.1.2, 13.5.1.2, B.1.1
READ_ONLY
PGA_COMPATIBILITY setting, A.1.2
recompiling TIPs
See TIP
reinstallation of package specifications, 11.4.1, 12.4.1
release-specific information
restrictions, 2.3.1
remote host transactions (RHT)
types, 1.8
Remote Node definition
creating, 8.7
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
requirements
hardware, 3.1
network attachments, 3.1.1
software, 3.2
system, 3
restoring a previous release of the gateway, 4.2.3
restrictions
on gateway using SNA, 2.3.1
resume configuration of the gateway
on Linux, 6.7
role
PGDDDEF, 11.6, 12.5
PGDDGEN, 11.6, 12.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
and Side Information Profiles, 8.3
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, 11.10.1, 12.10.1
installing, 11.10.1, 12.10.1
script
gpglocal.pkb, 11.3, 12.3, 12.3
gpglocal.pkh, 11.3, 12.3, 12.3
pgacr8au.sql, 11.3, 12.3
pgddadev.sql, 11.6, 12.5
pgddapub.sql, 11.6, 12.5
pgddcr8r.sql, 11.6, 12.5
pgddcr8.sql, 11.3, 12.3
pgddcr8s.sql, 11.6, 12.5
pgddupgr.sql, 11.4.2, 12.4.2
prvtpgb.plb, 11.3, 11.4, 12.3, 12.4
prvtrawb.plb, 11.3, 11.4, 12.3, 12.4
utlpg.sql, 11.3, 11.4.1, 12.3, 12.4.1
utlraw.sql, 11.3, 11.4.1, 12.3, 12.4.1
security
and database links, 13.3
and SNA validation, 13.4
authenticating application logons, 13.2
authentication mechanisms
in SNA security, 13.4.1.2
for TCP/IP for IMS Connect, 13.5
link accessibility for public and private databases, 13.3.1
links and CONNECT clauses, 13.3.2
overview of gateway security requirements, 13.1
processing inbound connections
on AIX, 7.1
on HP-UX, 8.1
on Solaris, 9.1
specifying SNA conversation security, on all platforms, 13.4.1
SECURITY=NONE SNA security option, on all platforms, 13.4.1.1
SECURITY=NONE TCP/IP security option, 13.5.1.1
SECURITY=PROGRAM SNA security option, on all platforms, 13.4.1.3
SECURITY=SAME SNA security option, on all platforms, 13.4.1.3, 13.4.1.3
SET
gateway initialization parameter, 11.7, 12.7
SET command, 11.7, 12.7
shells
see Bourne, Korn, and C shells, 4
side information
and Sym Dest Name option, on HP-UX, 8.4.1
Side Information Profiles, 7.5.3, 8.4, 8.7
description, 8.3
function, on AIX, 7.5.7
function, on HP-UX, 8.3
function, on Solaris, 9.2.3
Side Profile Name, 11.9.2.1
SINGLE_SITE
and PGA_CAPABILITY parameter, A.1.2
smit, 7.3
System Management Interface Tool for AIX, 7.3
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, 14.1
new gateway initialization parameters, 14.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
required for HP-UX, 3.2.2
required for Solaris, 3.2.2
transaction types, 1.8
SNA APPC
also see APPC
function in the gateway, 1.1
SNA communication package, 11.9.2.1, 11.9.2.2, 11.9.2.3, 13.4.1.3
and SNA security option, on all platforms, 13.4.1.3
and SNA security validation, all platforms, 13.4
configuration for the gateway, 5.1
SNA definitions
creating SNAP-IX definitions, 9.2.5
SNA node
and Link Station, 8.7
profile, on AIX, 7.5.1
SNA profiles, 13.4
See SNA server profiles
SNA protocol
gateway initialization parameters, A
SNA security options
SECURITY=NONE, on all platforms, 13.4.1.1
SECURITY=PROGRAM, on all platforms, 13.4.1.2
SECURITY=SAME, on all platforms, 13.4.1.3
SNA server, 7
dependent LUs, 7.2
independent LUs, on AIX, 7.2
profiles, 7.5, 7.5.7
activating and verifying, 7.6, 7.6
creating, on AIX, 7.3
definition, 7
for non APPN-capable nodes, on AIX, 7.5.6
Link Station, 7.5.2, 7.5.2
local LU profile, 7.5.4, 7.5.4
mode profile, 7.5.3, 7.5.3
Partner LU, 7.5.6
Partner LU location profile, 7.5.5, 7.5.5, 7.5.6
Side Information Profiles, 7.5.7, 7.5.7
SNA node profile, 7.5.1, 7.5.1
types, on AIX, 7.4
verify and activate profiles, on AIX, 7.6
SNAP-IX
communication support for Solaris, 9, 13.4
configuring, 9.2, 9.2.7
definitions stored, 9.2.5
function in gateway communication, 9, 13.4
profiles creating, 9.2.3
SNAPlus2
and LUs, 8.4
APPC menu
Sym Dest Names option, 8.4.1
configuring, 8.7
creating definitions for the gateway, on HP-UX, 8.5
creating profiles for the gateway, 8.3
function, 8
testing the connection, 8.8
using xsnapadmin to configure, 8.2
socket file descriptor
returned by TCP/IP network to PGAINIT, 1.7.1.1
software requirements, 3.2
Solaris
APPC support provided by SNAP-IX, 9
communication protocol needed, 3.2.2
configuring SNA, 5.1
configuring SNAP-IX, 9.2, 9.2.7
LU types, 9.2.4
SNA conversation security, 13.4.1
SNA security option SECURITY =SAME, 13.4.1.3
SNA security option SECURITY=NONE, 13.4.1.1
SNA security option SECURITY=PROGRAM, 13.4.1.2
SNA security validation, 13.4
storing SNAP-IX SNA definitions, 9.2.5
specifying LUs
on Solaris, 9.2.8.6
SQL*Plus
sample, used when gateway and Oracle database share machine, 11.3, 12.3
to configure Oracle database, 11.3, 11.3, 12.3, 12.3
use in configuring Oracle database for Commit-Confirm, 11.8.1
using to connect to Oracle database, 11.3, 12.3
statement
DESCRIBE, 11.3
describe, 12.3
DFHRPL DD, 10.1.1
Sym Dest Name
symbolic destination name, on HP-UX, 8.4.1
system identifier
choosing, 4.3
system requirements, 3

T

TCP protocol, 5.1
TCP/IP
specifying conversation security, 13.5.1
TCP/IP for IMS Connect
and Remote Transaction Initiation, 1.7.1.1
configuring
for the gateway, 12.6
gateway to permit multiple users, 12.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, 14.1.5
HS parameter descriptions, 14.1, 14.1.5
implementation of the gateway, 1.5
IMS Connect release required on IBM mainframe, 3.2.5
installing sample applications, 12.10.1
loading the PGA_TCP_IMSC table, 12.8
mapping SNA parameters to, 12.8
migrating existing gateway using SNA to TCP/IP, 14.2
necessary to recompile TIPs when changing communication protocol, 12.9.2.1
new gateway initialization parameters, 14.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, 12.10
persistent socket transaction type, 1.9
pg4tcpmap tool output sample, B.2
PGA parameters, 12.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, 13.5
security options
SECURITY=NONE, 13.5.1.1
SECURITY=NONE, on all platforms, 13.5.1.1
SECURITY=PROGRAM, on all platforms, 13.5.1.2
TIP recompile needed on upgrade, 4.2.2, 12.9.2.1
TRACE_LEVEL parameter, B.1.1
transaction types, 1.9
using pg4tcpmap tool, B.1.1
verifying
gateway installation, 12.9.1, 12.9.1
OLTP configuration, 12.9.2, 12.9.2.1
TCP/IP protocol adapter
for SNA, 5.1
terms, gateway terms defined, 1.3
testing the connection
on Linux, 6.6
testing the SNAplus2 connection, 8.8
TIP
Also called PL/SQL package
body output files, 11.6, 12.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, 11.6, 12.5
developer authorization on gpglocal, 11.3, 12.3
functions, 1.6
in Oracle database, 1.7.1.2
invalidated if package specifications reinstalled, 11.4.1, 12.4.1
override, on all platforms, 13.4.1.2
override, on all platforms, in security for TCP/IP, 13.5.1.2
recompile
after reinstalling package specifications, 11.4.1, 12.4.1
on upgrade from Release 4.0.1, 4.2.2
recompile upon upgrade from SNA to TCP/IP, 4.2.2, 12.9.2.1
recompiling when changing from SNA to TCP/IP, 12.9.2.1
regenerate to upgrade function and maintenance, 11.6, 12.5
remote transaction initiation (PGAINIT), 1.7.1.1, 1.7.1.1
specification output files, 11.6, 12.5
specifications, 11.3, 11.3, 11.6, 11.6, 11.6, 12.3, 12.3, 12.5, 12.5, 12.5
generated by PGAU, 1.6, 1.6
use UTL_PG, 11.3, 12.3
use UTL_RAW, 11.3, 12.3
specifying LUs
on HP-UX, 8.4
trace access PL/SQL routines, 11.3, 12.3
upgrade considerations from previous versions, 4.2.2
tnsnames.ora file, 5.1, 5.1, 5.1, 11.3, 12.3, A.1.2, A.1.2
and Oracle Net considerations, 14.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, 11.3, 12.3
TRACE_LEVEL parameter, 14.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, 14.1.2
transparency
(application), 1.2
(location), on gateway using SNA, 1.2

U

upgrading
considerations, 4.2.2
existing TIP specifications, 11.6, 12.5
user ID
as security authentication, 13.2
uppercase translation, OLTP and SNA communications packages, on all platforms, 13.4.1.3
user ID mapping
OLTP, 13.3.2
USING parameter, 5.1
using SNA security validation
Linux, 6.1
utility
dg4pwd, C.1
UTL_PG, 11.6, 12.5
installing, 11.3, 12.3
package, 11.6, 12.5
definition, C.1
invalidated or deinstalled, 11.4.1, 12.4.1
UTL_RAW, 11.3, 11.3, 11.3, 11.6, 12.3, 12.3, 12.3, 12.5
interface
PL/SQL package, 11.6, 12.5
package
invalidated or deinstalled, 11.4.1, 12.4.1
PL/SQL package
definition, C.1
utlpg.sql
file, 11.4.1, 12.4.1
script, 11.3, 11.4.1, 12.3, 12.4.1
utlraw.sql
file, 11.4.1, 12.4.1
script, 11.3, 11.4.1, 12.3, 12.4.1

V

VTAM, 10.1.3
and Side Information Profiles, 8.3
configuring for connection to the gateway, 10.1.1
VTAM logmode table, 10.1.1, 10.1.3

X

xsnaadmin, 9.2.5
invoking on Solaris, 9.2.8
with SNAP-IX, 9.2.6
xsnapadmin, 8.7
invoking, 8.7
to configure SNAPlus2, 8.2
to create SNA definitions, on HP-UX, 8.5

Z

z/OS, 1.2, 1.3, 3.2.5, 10.1, 10.1.1