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

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

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

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

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