Index

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

Symbols

&ORAPREFD system symbol, 5.4.4

A

abends, 5.7.2

reporting the error, 10.6.4

abnormal termination, 5.7.2

accounting information, B

alert log

SYSPRINT DD and, 5.3.6

Alert Logs, OSDI, 11.1.1.5.2

ALERT_DSNAME parameter, 5.4.1

ALERT_MAX parameter, 5.4.2

ALERT_MIN parameter, 5.4.3

ALL_CATALOG view, C.1

ALL_COL_COMMENTS view, C.2

ALL_CON_COLUMNS view, C.3

ALL_CONSTRAINTS view, C.4

ALL_DB_LINKS data dictionary view, 8.1.6

ALL_IND_COLUMNS view, C.5

ALL_INDEXES view, C.6

ALL_OBJECTS view, C.7

ALL_SYNONYMS view, C.8

ALL_TAB_COLUMNS view, C.9

ALL_TAB_COMMENTS view, C.10

ALL_TABLES view, C.11

ALL_USERS view, C.12

ALL_VIEWS view, C.13

ALTER SERVICE, OSDI command, A.7.3

ALTER SERVICEGROUP, OSDI command, A.6.3

ALTER SESSION CLOSE DATABASE LINK statement, 8.1.3

ALTER, OSDI command, A.4

ANO, 1.1.1.3

application

migrating to OSDI, A.7.2

application server support, 1.1.1.3

applications, 1.1.4

architecture

gateway, 1.7, 1.7

array

processing, 9.2

size, 9.2

AS1

SYSPRINT DD statement and alert log, 5.3.6

ASO

checklist

for setting up ASO encryption, 6.7.1.1

for testing, 6.7.2.1

connect client and server, 6.7.2.2

encryption, 6.7

reset configuration parameters on server, 6.7.2.3

set parameters for client, 6.7.1.3

set parameters for server, 6.7.1.2

testing, 6.7.2

AUTHLOAD

library, 4.3.3, 4.3.4, 4.3.4

authorization

id, 7.4, 9.10.2, B.3.2

authorizing the load library, 4.3.3

Auto Registration, gateway features, 2.2.1

AVG

option, 9.8.2

Oracle database server function, 9.8.2

SQL function, 9.7

B

bind variables, 9.6.3, 9.6.5, 9.6.12, 9.9.2

known restrictions, 2.4

restrictions, 2.4, 2.4

BLOB data type, 2.2.3

BPXPRMxx member, 6.4.7

C

CAF

OPEN connection to DB2, 7.4

Call Attach Facility See CAF

calls

PL/SQL, 9.4.1

CANCEL THREAD command, 8.2.2

canceling threads, 8.2.2

catalog views for DB2, 9.10.1

CHAR FOR BIT DATA format, 9.6.12, 9.6.12

character

columns, 9.6.1, 9.6.4

converting a string, 9.6.2

string operations, 9.6.1

checklist

configuration, 5.5.1

post installation, 4.1.1

post-configuration, 5.5.2

post-installation, 4.1.2

setting up ASO, 6.7.1.1

testing ASO, 6.7.2.1

CHECKSUM command, 1.1.1.3

clauses

CONNECT BY, 9.8.1

CONNECT TO, 7.4, 8.1.1, 8.1.4

DELETE, 9.8.2, 9.8.2

FOR UPDATE, 9.8.1, 9.8.1, 9.8.2

INSERT, 9.8.2, 9.8.2

SELECT FOR INSERT, 9.8.2

SELECT FOR UPDATE, 9.8.2, 9.8.2

SQL

DELETE, 9.6.7

INSERT, 9.6.7

SELECT WHERE, 9.6.7

UPDATE, 9.6.7

TO_DATE, 9.6.7

USING, 8.1.1

WHERE, 9.8.1, 9.8.1, 9.8.1, 9.8.1

WHERE CURRENT OF CURSOR, 9.6.10

CLOB data type, 2.2.3

CMDLOAD

library, 5.7.1

CNV_LIT_FMT (sidENV variable), 5.4.37

collecting Oracle statistics, B

COLLID column, 9.4.2, 9.4.2, 9.4.2

COLUMN_PRIVILEGES view, C.14

columns

character, 9.6.1, 9.6.4

COLLID, 9.4.2, 9.4.2

date, 9.6.7

DB2 DATE, 9.6.4, 9.6.5

IBM DATE, 9.6.3

LONG, 8.10, 9.6

Oracle DATE, 9.6.5

Oracle ROWID, 9.6.10

RAW, 2.4

ROWID, 9.6.10

command

OSDI

ALTER, A.4

ALTER SERVICE, A.7.3

ALTER SERVICEGROUP, A.6.3

DEFINE, A.4

DEFINE SERVICE, A.7.1

DEFINE SERVICEGROUP, A.6.1

DISPLAY, 6.5, A.10.2

DISPLAY LONG, 6.5

DRAIN, 6.5, A.10.3

keyword abbreviations, A.11

list of commands, A.9

RESUME, 6.5, A.10.4

SHOW, A.4

SHOW SERVICE, A.7.5

SHOW SERVICEGROUP, A.6.5

START, 6.5, A.10.1

STOP, 6.5, A.10.6

start, 7.1

STOP, 7.1

z/OS System

MODIFY (F), 6.5

STOP (P), 6.5

commands

CANCEL THREAD, 8.2.2

CREATE MATERIALIZED VIEW, 8.10

CREATE TABLE, 8.10

DELETE, 9.9.1

EXECUTE, 1.1.3.1

INSERT, 8.10

MPM

DISPLAY EXIT, 7.6.1

gateway operation, 7.1

SETPROG, 4.3.4, 4.3.4

SETSSI, 4.3.4

SMF

SETSMF, B.1.2

SQL, 8.1.2

SQL*Plus

COPY, 8.9, 8.9.2, 8.9.2, 8.10

DELETE, 9.9.1

INSERT, 8.9.2

z/OS

DUMP, 10.7

SLIP, 10.6.5

commit confirm protocol, 1.2

compatible SQL functions, 9.7

compensated SQL functions, 9.7

CONCAT SQL function, 9.7

CONNECT BY clause, 9.8.1

connect exit, DB2, 2.2.3

CONNECT TO

clause, 7.4, 8.1.1, 8.1.4

statement, 8.1.4

userid, 8.1.4

converting a character string, 9.6.2

COPY command, 8.9.2, 8.10

COPY SQL*Plus command, 8.9

copying data, 8.9

from the DB2 server, 8.10

from the Oracle database server, 8.9.2

COUNT(*) SQL function, 9.7

CPU requirements, 3.1.1

CREATE DATABASE LINK statement, 8.1.1

CREATE MATERIALIZED VIEW command, 8.10

CREATE TABLE

command, 8.10

statement, 1.1.2.3

CURRDEGREE (sidENV variable), 5.4.20

D

DASD

data set, 5.7.2

data control language See DCL

data definition language See DDL

data dictionary

SYSIBM.SYSPROCEDURES table, 9.4.2

table SYSIBM.SYSPROCEDURES, 9.4.2

using, 9.10.1

views, 8.1.6, 9.10, C

ALL_CATALOG, C.1

ALL_COL_COMMENTS, C.2

ALL_CON_COLUMNS, C.3

ALL_CONSTRAINTS, C.4

ALL_DB_LINKS, 8.1.6, 8.1.6

ALL_IND_COLUMNS, C.5

ALL_INDEXES, C.6

ALL_OBJECTS, C.7

ALL_SYNONYMS, C.8

ALL_TAB_COLUMNS, C.9

ALL_TAB_COMMENTS, C.10

ALL_TABLES, C.11

ALL_USERS, C.12

ALL_VIEWS, C.13

COLUMN_PRIVILEGES, C.14

DBA_DB_LINKS, 8.1.6

OTGREGISTER, 9.10.2

TABLE_PRIVILEGES, C.16

USER_CATALOG, C.17

USER_COL_COMMENTS, C.18

USER_CONS_COLUMNS, C.19

USER_CONSTRAINTS, C.20

USER_DB_LINKS, 8.1.6, 8.1.6

USER_INDEXES, C.21

USER_OBJECTS, C.22

USER_SYNONYMS, C.23

USER_TAB_COLUMNS, C.24

USER_TAB_COMMENTS, C.25

USER_TABLES, C.26, C.26

USER_USERS, C.27

USER_VIEWS, C.28

data set names

choosing data set name qualifiers, F.1

data sets

DASD, 5.7.2

dump, 5.7.2

SYS1.DUMP, 10.7.1

SYSOUT, 5.7.2

system dump, 10.7.1

data types

character string, 9.6.1

DATE, 9.6.3, 9.6.3

DB2

BLOB, 2.2.3

CHAR, 9.6.11

CLOB, 2.2.3

DBCLOB, 2.2.3

GRAPHIC, 9.6.11

ROWID, 2.2.3

TIMESTAMP, 2.2.3

VARCHAR, 9.6.2, 9.6.2, 9.6.11

IBM DATE, 9.6.3

LONG, 9.6.2, 9.6.2

mapping, 9.6

numeric, 9.6.9, 9.6.9

Oracle

database server, 9.6.3

DATE, 9.6.3

RAW, 9.6.12

restrictions, 9.6

TIME, 9.6.3, 9.6.3

TIMESTAMP, 9.6.3, 9.6.3

database

accounting information, B

triggers, 1.1.1.2

database link, 8.1

accessing data, 8.1.4

behavior, 8.1

creating, 8.1.1

data dictionary views

ALL_DB_LINKS, 8.1.6

DBA_DB_LINKS, 8.1.6

USER_DB_LINKS, 8.1.6

dropping links, 8.1.5

examining, 8.1.6

guidelines, 8.1.3

limits, 8.1.7

using Oracle Net, 8.1.2

DATE

data type, 9.6.3

DB2 columns, 9.6.4, 9.6.5, 9.6.5

date

arithmetic, 9.6.8, 9.6.8

columns, 9.6.7

considerations, 9.6.5

DATE data type, 9.6.3, 9.6.3

DB2

DATE columns, 9.6.4, 9.6.5, 9.6.5

date exit, 2.2.3, 7.7

local date exit, 9.6.4, 9.6.5

INSERT

c, 9.6.7

LOCAL DB2 data format, 9.6.4

NLS_DATE_FORMAT parameter, 9.6.6

operations, 9.6.3, 9.6.3

TIME data type, 9.6.3

TIMESTAMP data type, 9.6.3

TO_DATE function, 9.6.5, 9.6.7, 9.6.7, 9.6.7

DB2

ASCII data to EBCDIC, 9.6.1

bind

JCL, 9.4.2

CAFOPEN connection, 7.4

catalog, 9.6.1

CHAR data type, 9.6.11

CICS, 9.4.2

collection id, 9.4.2

cursors, 8.4

data types

BLOB, 2.2.3

CHAR, 9.6.11, 9.6.11

CLOB, 2.2.3

DBCLOB, 2.2.3

ROWID, 2.2.3

TIMESTAMP, 2.2.3

VARCHAR, 9.6.11, 9.6.11

database

read, 9.1

write, 9.1

DATE columns, 9.6.4, 9.6.4, 9.6.4, 9.6.5

date exit, 2.2.3, 7.7

differences from Oracle database server, 9.9

DSN3@ATH exit, 2.2.3

GRAPHIC data types, 9.6.11

IMS, 9.4.2

known restrictions

for plan, 2.4

local date exit, 9.6.4, 9.6.4, 9.6.4, 9.6.4, 9.6.5

LOCAL date format, 9.6.4

native

SQL, 1.1.2.3

stored procedures, 1.1.3.2

PL/SQL, 9.4.2

security

profile, 7.5

server triggers, 8.9.1

sign-on exit, 2.2.3

special registers for authorization id, 9.10.2, C.15

SQL, 9.4.2, 9.4.2

SQL statements, 9.5.1, 9.6.5

statement CREATE TABLE, 1.1.2.3

stored procedures, 8.6, 9.4, 9.4.2

tables, 8.10, 9.6.1

user-defined functions (UDFs), 2.2.3

VARCHAR data type, 9.6.2, 9.6.2, 9.6.11

DB2 gateway plan binding

binding the DB2 gateway plan, 5.6.7

DB2 package

binding of, 5.6.6

DB2 Server, 1.7

DB2 Universal Database (UDB), 1.7

DB2CAP (sidENV variable), 5.4.28

DB2DESCTAB (sidENV variable), 5.4.21

DB2I bind jpackage panel, 5.6.6

DB2IND sample DB2 stored procedure, E.1

DB2LONGMSG (sidENV variable), 5.4.22

DB2PLAN (sidENV variable), 5.4.31

DB2READONLY

parameter, 8.6, 8.6

DB2READONLY (sidENV variable), 5.4.25

DB2SSN (sidENV variable), 5.4.30

DB2STATS (sidENV variable), 5.4.24

DB2WARNING (sidENV variable), 5.4.23

DBA_DB_LINKS data dictionary view, 8.1.6

DBCLOB data type, 2.2.3

DBCS support, 9.6.11

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 9.5, 9.5, 9.5.1, 9.5.1

DCL

DD basic tables, known restrictions, 2.4

DD statement

NET8LOG, 6.4.6

ORA$ENV, 5.3.1

ORA$FPS, 5.3.2

ORA$LIB, 5.3.3

SQLNET, 5.3.4

STEPLIB, 5.3.5, 6.4.6

SYSPRINT, 5.3.6

DD statements

SYSMDUMP, 5.7.2

DDL statement, 9.5.1

default

record types for SMF, B.1.2

DEFINE command

supported definition command, A.4

DEFINE SERVICE, OSDI command, A.7.1

DEFINE SERVICEGROUP, OSDI command, A.6.1

definition commands, A.4

DELETE

clause, 9.8.2

command, 9.9.1

SQL clause, 9.6.7

dictionary mapping, 1.1.1.4

disk

space requirements, 3.1.2

DISPLAY LONG, OSDI command, 6.5

DISPLAY, OSDI command

defined, A.10.2

with Oracle Net service, 6.5

distributed

DB2 transactions, 8.7.3

queries, 8.7, 8.7.1, 8.7.1, 8.7.2

documentation

errors, 10.6.1

DRAIN, OSDI command

defined, A.10.3

preventing network connections, 6.5

DROP DATABASE LINK statement, 8.1.5

DSN_PREFIX_DB parameter, 5.4.4

DSN3@ATH exit, 2.2.3

DSNXVDTX executable

for DB2 date exit, 2.2.3

dump data sets, 5.7.2

E

empty parameter, A.7.2

EMPTYSTR_TO_NULL_OFF (sidENV variable), 5.4.38

EMPTYSTR_TO_NULL_WHERE_OFF (sidENV variable), 5.4.39

enclave SRB

Oracle Net architecture, 6.2

encryption, ASO, 6.7

environment

heterogeneous, 8.8

operational, 10.4

security, 7.4, 7.5

UNIX, 8.2.1

variables

DB2READONLY parameter, 8.6

environment variable assignment statements, ORA$ENV and, 5.3.1

EPLPA, moving modules into, 5.7.1

error

12660, 6.7

IEC130I, 5.3.2, 5.3.3

message traffic to the console, 6.5

messages for network region JCL, 6.4.6

ORA-12660, 6.7.2.2

ORA-2063, example message, 10.1.2

errors

diagnosing, 10.1.5, 10.5, 10.6

incorrect output, 10.6.2

interpreting, 10.1.2

mapping, 10.1.1

messages, 10, 10.1

reporting

abends, 10.6.4

documentation, 10.3, 10.4, 10.6.1

GTF, 10.8

incorrect output, 10.6.2

Oracle database server error messages, 10.6.3

performance, 10.6.6

program check, 10.6.4

program loop, 10.6.5

sending tapes, 10.3

system dump data sets, 10.7.1

system dumps, 10.7

stored procedure, 10.1.4

EXECUTE

command, 1.1.3.1

exits

DB2

connect, 2.2.3

date, 2.2.3, 7.7

DSN3@ATH, 2.2.3

local date, 9.6.4, 9.6.4, 9.6.4, 9.6.4, 9.6.5

DSNXVDTX, 2.2.3, 7.7

G4RRSAF, 2.2.3, 5.4.9, 7.4, 7.6.1, 7.7

G4SIGNON, 2.2.3, 7.4, 7.6.1, 7.7

gateway local date, 9.6.6

logon security, 2.2.3, 5.4.9, 7.4, 7.6.1, 7.7

modules, 7.6

sample programs, 7.7

sign-on, 2.2.3

user, 7.6

extended pageable link pack area See EPLPA

F

FDS_CLASS_VERSION (sidENV variable), 5.4.26

features

10.1.0.2.0 gateway, 2.2.3

8.1.7 gateway, 2.2.1

9.0.1 gateway, 2.2

Oracle materialized views, 8.8.2

synonym, 8.5

fetch reblocking, 9.2.1, 9.2.1

fields

SMFWCPU, 8.3

filenames

OSDI listener, 6.3

files

SPOOL, 5.7.2

SQLNET.ORA, 8.2.1

VSAM, 9.4.2

FLUSH_CACHE_ON_COMMIT (sidENV variable), 5.4.27

FOR BIT DATA option, 2.4, 9.6.1

FOR UPDATE clause, 9.8.1, 9.8.1

NOWAIT option, 9.8.2

FPS

ORA$FPS DD statement, 5.3.2

functions

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 9.5, 9.5, 9.5.1, 9.5.1

KEEPALIVE, 8.2.1

MIN, 9.8.2

Oracle database server

AVG, 9.8.2

MAX, 9.8.2

MIN, 9.8.2

SUM, 9.8.2

TO_DATE, 9.8.2

ROWID, 9.6.10

SQL, 9.7

advanced, 9.7

AVG, 9.7

compatible, 9.7

compensated, 9.7

CONCAT, 9.7

COUNT(*), 9.7

MAX, 9.7

MIN, 9.7

SUM, 9.7

translated, 9.7

SUM, 9.8.2

TO_DATE, 9.6.5, 9.6.6, 9.6.7, 9.6.7, 9.6.7

G

G4RRSAF executable

for DB2 Gateway logon security exit, 2.2.3, 5.4.9, 7.4, 7.6.1, 7.7

G4SIGNON source code

for DB2 Gateway login exit, 2.2.3

gateway

advantages

migration and coexistence, 1.4

multisite transactions, 1.2

security, 1.5

site autonomy, 1.3

two-phase commit, 1.2

architecture, 1.7

components, 1.7

DB2 server, 1.7

Oracle database server, 1.7

configuring, 5

CPU time, 8.3

development applications, 9.1

dump data sets, 5.7.2

how it works, 1.8

local date exit, 9.6.6

messages, 10.1.3

MPM, 7.1

protection of current investment, 1.6

region parameters, defined, 5.4

security, 7.4, 7.4

authorization id, 7.4

Oracle user exit facility, 7.6

SAF router, 7.5

sample exit programs, 7.7

secondary authorization id, 7.4

specifying an exit module, 7.6.1

gateway messages, format explained, 10.1.2

gateway service

opening a, 11.1.5

gateway service, configuring a, 11.1.3

GETHOSTBYNAME API, Oracle Net IBM TCP/IP HPNS, 6.4.7

Globalization Support

data objects, ORA$LIB DD statement, 5.3.3

GTF, 10.8

H

heterogeneous replication

STREAMS, 2.2.2

high-level qualifier, 4.3.3

choosing data set name qualifiers, F.1

HPNS interface, 11.1.6.3

HS initialization parameters, 5.4.43

HS_OPEN_CURSORS

parameter, 8.4

HS_RPC_FETCH_REBLOCKING

parameter, 9.2.1

HS_RPC_FETCH_SIZE

initialization parameter, 3.1.3

parameter, 9.2.1

I

IBM DATE

column, 9.6.3

data type, 9.6.3

IBM LE/370 runtime library

gateway region JCL, 5.3.5

IBM maintenance, 3.2.3, 3.2.4

IDLE_TIMEOUT parameter, 2.2.3, 5.4.6

IEAAPFxx member, 4.3.3

IEASYSnn member, 4.3.3

IEBUPDTE utility, 4.3.3

IEC130I error, 5.3.2, 5.3.3

IEFUSI exit, 5.3

incompatibilities, release, 11.2.1

incorrect output errors, 10.6.2

INIT_ADR_SPACES parameter, 5.4.7

INIT_STACK_SIZE parameter, 5.4.8

initialization

parameters

HS_RPC_FETCH_SIZE, 3.1.3

INSERT

clause, 9.8.2, 9.8.2

command, 8.10

SQL clause, 9.6.7

statement, 10.1.5, 10.1.5

installation

checking distribution kit, 3.5

checklists, 4.1

COPYPROC job, 4.2.2

installing gateway software, 4.2.2

moving modules to linklist library, 4.2.2

post installation steps, 5.7

post-installation steps, 4.3

pre-installation tasks, 4.2.1

program properties for, 4.3.2

required patches for, 4.3.1

INSTLIB library

contents, 5.6.1

creation, 5.6

location, 5.6.1

interface, Oracle array processing, 9.2

Internet support, 1.1.1.3

Intranet support, 1.1.1.3

IPLing z/OS, 4.3

isolation level, 5.6.7

ISPF

EDIT, 4.3.3

IXCF support, 11.1.6.4

J

JCL

DB2 bind, 9.4.2

define an ALIAS before loading the installation JCL, F.1

MPM startup, 5.7.2

ORAFMT sample, B.4

JCL, gateway instance, 11.1.3.2

JCL, network region, 6.4.6

JOBNAME parameter, 5.2.6

JOIN capability, 1.1.1.2

K

Katakana DB2 support, 9.6.11

KEEPALIVE

function, 8.2.1, 8.2.1

Oracle Net, 8.2.1

keyword abbreviations, OSDI command, A.11

known problems, 2.3

known restrictions, 2.4

binary literal notation, 2.4

DB2

plan, 2.4

DD basic tables and views, 2.4

literal values, 2.4

OCI, 2.4

Oracle database server SQL, 2.4

precompiling, 2.4

RAW data, 2.4

SQL, 2.4

L

Language Environment runtime library (LE)

Oracle Net, 6.4.7

LDAP.ORA file, sample, 6.4.8.3

libraries

AUTHLOAD, 4.3.3, 4.3.4, 4.3.4

authorized, 4.3.3

CMDLOAD, 5.7.1

load, 4.3.3

PARMLIB, 8.4

SYS1.PARMLIB, 4.3.3, 4.3.4

LIKE_OFF (sidENV variable), 5.4.40

link pack area See LPA

linkage conventions

SIMPLE, 9.4.2, 9.4.2

SIMPLE WITH NULLS, 9.4.2, 9.4.2, 9.4.2

linklist library, moving modules to, 4.2.2

listener

OSDI, See OSDI listener

listener architecture, 6.2

load library, authorizing, 4.3.3

LOCAL DB2 date format, 9.6.4

logon security exit, 2.2.3, 5.4.9, 7.4, 7.6.1, 7.7

LOGON_AUTH parameter, 5.4.9

LONG

column, 8.10, 9.6

data type, 9.6.2, 9.6.2

LPA, moving modules into, 5.7.1

M

MACRO API interface, with Oracle Net, 6.4.7

managing threads, 8.2

mapping error messages, 10.1.1

materialized view, 9.6.10

materialized views

complete refresh, 8.10

CREATE MATERIALIZED VIEW command, 8.10

Oracle materialized view feature, 8.8.2

MAX

option, 9.8.2

Oracle database server function, 9.8.2

SQL function, 9.7

MAX_SESSION_MEM parameter, 5.4.10

MAX_SESSIONS parameter, 5.4.11

MAXAS parameter

gateway region parameters, 5.4.7

gateway service definition, 5.2.5

MAXFILEPROC parameter, 6.4.7

MAXSOCKETS parameter, 6.4.7

member

BPXPRMxx, 6.4.7

members

IEAAPFxx, 4.3.3

IEASYSnn, 4.3.3

ORAFMTCL, B.4

ORAFMTGO, B.4

PARMLIB, 7.6.1

PROGxx, 4.3.3

sidENV, 8.4

SMFPRMxx, B.1

message

IEC130I, 5.3.2, 5.3.3

messages, 10.1

error, 10

format, 10.1.2

gateway, 10.1

generated by gateway, 10.1.3

mapped, 10.1

ORA-2025, 8.9.2

ORA-9100, 10.1

Oracle database server, 10.6.3

stored procedure, 10.1.4

migrating from MPM

cautions, 11.1.2

MIN

option, 9.8.2

Oracle database server function, 9.8.2

SQL function, 9.7

missing functionality, 10.6.7

Mobile Agents, 1.1.1.3

MODIFY (F), z/OS command

communicating with a running Oracle Net service, 6.5

MPM

operation, 7.1

startup JCL, 5.7.2, 5.7.2

STEPLIB, 7.6

SYSABEND for startup, 5.7.2

SYSUDUMP for startup, 5.7.2

MPM commands

DISPLAY EXIT, 7.6.1

gateway operation, 7.1

MPM messages, obsolescence of, 11.1.1.4

MPM parameters

gateway subsystem, 7.1

MPM to OSDI migration, 11.2

MPM, compared to OSDI, 11.1

MPM/TNS coexistence, 11.2.4, 11.2.5

multiple gateway services, configuring, 11.2.3

N

Net service

See OSDI listener

NET8LOG DD statement, 6.4.6

network service

configuring, 11.1.6.1

operating, 11.1.6.2

OSDI, 11.1.1.3

NLS_DATE_FORMAT

parameter, 9.6.6

NOWAIT option, 9.8.2

numeric data types, 9.6.9

NVL_TO_VALUE_OFF (sidENV variable), 5.4.41

O

OCI, 2.4, 9.4.2, 9.4.2, 10.1.2

OPEN_LINKS parameter, 8.1.7

operator initiated dumps, 10.7.2

options

AVG, 9.8.2

FOR BIT DATA, 9.6.1

MAX, 9.8.2

MIN, 9.8.2

NOWAIT, 9.8.2

SUM, 9.8.2

TO_DATE, 9.8.2

ORA$ENV DD statement, 5.3.1

ORA$FPS DD statement

gateway region JCL, 5.3.2

ORA$LIB

DD statement, gateway region JCL, 5.3.3

ORA_MAX_DATE (sidENV variable), 5.4.33

ORA-12660 error, 6.7.2.2

ORA-2025 message, 8.9.2

ORA-2063, example error message, 10.1.2

ORA-9100 message, 10.1

Oracle Advanced Security Option

See ASO

Oracle Call Interface See OCI

Oracle database server

data type, 9.6.3

database triggers, 1.1.1.2

DATE columns, 9.6.5

distributed query optimization, 1.1.1.2

functions

AVG, 9.8.2

MAX, 9.8.2

MIN, 9.8.2

SUM, 9.8.2

TO_DATE, 9.8.2

stored procedures, 1.1.1.2

subsystem

accounting information, B

error reporting, 10.6.3

resource usage, B

statistics, B

triggers, 8.9.1

two-phase commit protection, 1.1.1.2

user exit facility, 7.6

Oracle Developer, 1.1.4.1

Oracle Discoverer, 1.1.4.2

Oracle Net

IBM TCP/IP

requirements, 3.4.1

KEEPALIVE function, 8.2.1

OSDI listener, 6.1

overview, 6.1

Oracle net

requirements

resource, 3.1.3

Oracle Support Services, 10.2

ORACLE_TIMESTAMP (sidENV variable), 5.4.34

ORACLE2PC table, 2.4, 8.7.2, 8.7.2, 8.7.3

ORAFMT program for SMF, B.3, B.4

ORAFMTCL

member, B.4

sample JCL, B.4

ORAFMTGO

member, B.4

sample JCL, B.4

ORAIND sample DB2 stored procedure, E.2

ORARECID (sidENV variable), 5.4.32

OS/390

operating system, supported versions, 3.1.1

OSDI

command

keyword abbreviations, A.11

listener, 6.1

MESG data set, ORA$LIB DD statement, 5.3.3

subsystems, 11.1.1.1

upgrade or migration to, 11.2.2

OSDI command verbs, 7.2

OSDI commands

access to, 7.2

OSDI listener

configuration, 6.4

DEFINE parameters, 6.4.1

OSDI listener architecture, 6.2

OSDI network service, 11.1.1.3

OSDSI

differences from MPM, 11.1

OTGDB2.OTGREGISTER view, C.15

OTGREGISTER view, 9.10.2

P

pageable link pack area See PLPA

parameter

encryption, 6.7.1.3

gateway region parameter

ALERT_DSNAME, 5.4.1

ALERT_MAX, 5.4.2

ALERT_MIN, 5.4.3

DSN_PREFIX_DB, 5.4.4

IDLE_TIMEOUT, 5.4.6

INIT_ADR_SPACES, 5.4.7

INIT_STACK_SIZE, 5.4.8

LOGON_AUTH, 5.4.9

MAX_SESSION_MEM, 5.4.10

MAX_SESSIONS, 5.4.11

PRIMARY_ASC_MODE, 5.4.12

REGION_MEM_RESERVE, 5.4.13

SERVER_LOADMOD, 5.4.15

SMF_STAT_RECNO, 5.4.16

TRACE_DSNAME, 5.4.17

JOBNAME, 5.2.6

MAXAS

gateway service parameter, 5.2.5

PARM, 5.3

REGION

gateway region JCL, 5.3

TYPE, 5.2.2

zero-length (empty), A.7.2

parameters

ASO, setting for server, 6.7.1.2

configuration, resetting on server, 6.7.2.3

DB2READONLY, 8.6, 8.6

encryption, 6.7.1.2

HS_OPEN_CURSORS, 8.4

HS_RPC_FETCH_REBLOCKING, 9.2.1

HS_RPC_FETCH_SIZE, 9.2.1

IDLE_TIMEOUT, 2.2.3

initialization

HS_RPC_FETCH_SIZE, 3.1.3

MAXFILEPROC, 6.4.7

MAXSOCKETS, 6.4.7

MPM

startup, B.1

NLS_DATE_FORMAT, 9.6.6

OPEN_LINKS, 8.1.7

Oracle Net TNSNAMES SID, 2.2.2, 2.2.2, 2.2.2

READONLY, 8.6

setting, for client, 6.7.1.3

SQLNET.EXPIRE_TIME, 8.2.1

parametesr

REGION (network region JCL), 6.4.6

PARM parameter, 5.3

PARMLIB

library, 8.4

member, 7.6.1

PARMLIB library

contents, 5.6.1

creation, 5.6

location, 5.6.1

PARMLIB member

editing of, 5.6.9

passthrough, 1.1.2.3, 8.6, 9.5, 9.5.1, 9.5.2, 9.5.2.1

result sets, 9.5, 9.5.2, 9.5.2.1

passthru See passthrough

patches, downloading required, 4.3.1

performance

issues, 10.6.6

PLPA, 5.7.1

PLPA, moving modules into

PL/SQL, 9.4.2, 9.4.2

call, 9.4.1

DB2, 9.4.2

routine, 1.1.3.1

standard Oracle, 1.1.3.2

post-installation steps, 4.3

Precompiler limitations, 2.4

pre-installation tasks, 4.2.1

PRIMARY_ASC_MODE parameter, 5.4.12

procedures

error example for stored procedures, 10.1.4

native stored, 1.1.3.2

sample DB2 DB2IND, E.1

sample for DB2 ORAIND, E.2

stored, 1.1.1.2, 1.1.3, 8.6, 9.4

processing SQL, 9.8

product set, 2.1

program loop, 10.6.5

program properties

adding for installation, 4.3.2

SCHEDxx member and, 4.3.2

PROGxx member, 4.3.3

protection of investment, 1.6

protocols

commit confirm, 1.2

Q

queries, distributed, 8.7

R

RACF

with network service, 6.4.7

RAW

columns, known restrictions, 2.4

data type, 9.6.12

data, known restrictions, 2.4

format, 9.6.12

recording SMF information, B.1

Recoverable Resource Manager Services Attachment Facility (RRSAF), 2.2.3

reentrant modules, moving to EPLPA

REGION parameter, 5.3, 6.4.6

REGION_MEM_RESERVE parameter, 5.4.13

replication, 8.8

requirements

CPU, 3.1.1, 3.1.1

disk space, 3.1.2

Oracle Net, 3.1.3, 3.4

virtual memory, 3.1.3

resource usage, B

RESUME command

defined, A.10.4

Oracle Net, 6.5

RMODE linkage, 5.7.1

routines

PL/SQL, 1.1.3.1

ROWID

column, 9.6.10

DELETE, 9.6.10

materialized views, 9.6.10

restrictions, 9.6.10

UPDATE, 9.6.10

WHERE CURRENT OF CURSOR clause, 9.6.10

function, 2.4, 9.6.10

ROWID data type, 2.2.3

RRSAF (Recoverable Resource Manager Services Attachment Facility), 2.2.3

S

SAF

considerations, 7.4

router, 7.5

SCHEDxx member, 4.3.2

scripts

SQL DD, 2.4

secondary authorization id, 7.4

security

advanced, 1.1.1.3

ANO, 1.1.1.3

encryption, 1.1.1.3

for gateway, 7.4, 7.4

SAF router considerations, 7.5

specifying an exit module, 7.6.1

user exit, 7.6

Security Authorization Facility See SAF

SELECT

statement, 8.6, 9.2.1, 9.8.1, 9.8.1, 9.8.1, 9.8.1, 9.8.1, 9.8.2

SELECT FOR DELETE clause, 9.8.2

SELECT FOR INSERT clause, 9.8.2

SELECT FOR UPDATE clause, 9.8.2, 9.8.2

SELECT WHERE SQL clause, 9.6.7

SELECT_CONCAT_ON (sidENV variable), 5.4.42

SERVER_LOADMOD parameter, 5.4.15

service

definition commands, A.7

service group

definition commands, A.6

service name, for a gateway, 5.2.1

service group, definition of, 11.1.2

session connection, 8.1

SETPROG system command, 4.3.4, 4.3.4

SETSSI system command, 4.3.4

setting of, 5.6.7

SHOW SERVICE, OSDI command, A.7.5

SHOW SERVICEGROUP, OSDI command, A.6.5

SHOW, OSDI command, A.4

SID

defined

gateway service name, 5.2.1

sid

gateway instance, 11.1.3.1

sidENV

HS initialization parameters, 5.4.43

sidENV member, 8.4

sidENV parameters, 5.4.18

sign-on exit, 2.2.3

SIMPLE linkage convention, 9.4.2, 9.4.2

SIMPLE WITH NULLS linkage convention, 9.4.2, 9.4.2, 9.4.2, E.1

SITEINFO file, 6.4.7

SLIP command, 10.6.5

SMF

abends, B.2

abnormal terminations, B.2

activating, B.1

commands

SETSMF, B.1.2

default record types, B.1.2

interpreting records, B.3

ORAFMT program, B.3, B.4

record type, specifying, B.1.1.1

recording

starting, B.1.2

stopping, B.1.3

records, B

records, interpreting, B.3

sample formatting program, B.4

starting dynamically, B.1.2

types of users, B.1

user-defined data section, B.4

when records are written, B.2

SMF_STAT_RECNO parameter, 5.4.16

SMFAUTH authorization id, B.3.2, B.4

SMFPRMxx member, B.1

SMFWCPU field, 8.3

SNS/TCPaccess, 11.1.6.3

software requirements, 3.2

IBM maintenance, 3.2.3, 3.2.4

z/OS operating system, 3.2.1

specifying

SMF record type, B.1.1.1

SPOOL

file, 5.7.2

space, 5.7.2

SQL, 1.1.2

ANSI standard, 1.1.2

clauses

DELETE, 9.6.7

INSERT, 9.6.7

SELECT WHERE, 9.6.7

UPDATE, 9.6.7

commands, 8.1.2

constructs, Oracle-specific, 9.8

DB2, 9.4.2, 9.4.2

DD script, 2.4

functions, 9.7, 9.7, D

advanced, 9.7

AVG, 9.7

compatible, 9.7

compensated, 9.7

CONCAT, 9.7

COUNT(*), 9.7

MAX, 9.7

MIN, 9.7

SUM, 9.7

translated, 9.7

ISO standard, 1.1.2

limitations, 2.4

passthrough, 8.6, 9.5, 9.5.1, 9.5.2, 9.5.2.1

statements, 8.7.1, 9.1, 9.1

DB2, 9.5.1, 9.6.5

passing through gateway, 9.5

SQL*Plus, 1.1.4.3

commands

COPY, 8.9, 8.9.2, 8.9.2

DELETE, 9.9.1

INSERT, 8.9.2

SQLNET DD statement, 5.3.4

SQLNET.EXPIRE_TIME parameter, 8.2.1

SQLNET.ORA file, 8.2.1

SRB (service request block)

Oracle Net architecture, 6.2

START

OSDI command

defined, A.10.1

starting Oracle Net service, 6.5

START command, 7.1

statements

ALTER SESSION CLOSE DATABASE LINK, 8.1.3

CONNECT TO, 8.1.4

CREATE DATABASE LINK, 8.1.1

DB2 CREATE TABLE, 1.1.2.3

DDL, 9.5.1

DROP DATABASE LINK, 8.1.5

INSERT, 10.1.5, 10.1.5

SELECT, 8.6, 9.2.1, 9.8.1, 9.8.1, 9.8.1, 9.8.1, 9.8.1, 9.8.2

SQL, 8.7.1, 9.1, 9.1

DB2, 9.5.1, 9.6.5

passing through gateway, 9.5

SYSMDUMP DD, 5.7.2, 5.7.2

STEPLIB DD statement

gateway region JCL, 5.3.5

Oracle Net region JCL, 6.4.6

STOP

OSDI command, 6.5

defined, A.10.6

STOP (P) z/OS System command, 6.5

STOP command, 7.1

storage requirements, 3.1.3

stored procedures, 1.1.1.2, 1.1.3

creating on DB2, 9.4.1

DB2, 8.6, 9.4, 9.4.2

using, 9.4

DB2IND, E.1

error message, 10.1.4

native DB2, 1.1.3.2

Oracle, 1.1.3.1

Oracle database server

local instance, 9.3

PL/SQL, 9.3

remote instance, 9.3

using, 9.3

ORAIND, E.2

SYSPROC qualifier, 9.4.1

two-phase commit processing, 9.3

stored procedures in DB2, gateway features, 2.2.1

Streams Heterogeneous Replication, 2.2.2

SUM

option, 9.8.2

Oracle database server function, 9.8.2

SQL function, 9.7

support

sending tapes, 10.3

synonym feature, 8.5

SYS1.PARMLIB

library, 4.3.3, 4.3.4

SYS1.SCEERUN, LE/370 runtime library name, 5.3.5

SYSABEND for MPM startup, 5.7.2

SYSMDUMP DD statement, 5.7.2, 5.7.2

SYSOUT

data set, 5.7.2

SYSPRINT DD statement, 5.3.6

system

dump data sets, 10.7.1

requirements

resource, 3.1

software, 3.2

SYSUDUMP for MPM startup JCL, 5.7.2

T

TABLE_PRIVILEGES view, C.16

tables

DB2, 2.4, 8.10, 9.6, 9.6.1

ORACLE2PC, 2.4, 8.7.2, 8.7.2, 8.7.3

SYSIBM.SYSPROCEDURES DB2 data dictionary, 9.4.2, 9.4.2

TARGET (sidENV variable), 5.4.29

TCP/IP

KEEPALIVE, 8.2.1

threads

canceling, 8.2.2

managing, 8.2

TIME data type, 9.6.3

time operations, 9.6.3

TIMESTAMP data type, 9.6.3

TIMESTAMP data type mapping, 2.2.3

TNS

connect descriptor, 8.1.2

TNS facility, 11.1.1.3

TNS messages, obsolescence of, 11.1.1.4

TNSNAMES SID

parameter, 2.2.2, 2.2.2, 2.2.2, 2.2.2, 2.2.2, 2.2.2

TNSNAMES.ORA

connect descriptor, 8.1.1

TO_DATE

clause, 9.6.7

function, 9.6.4, 9.6.5, 9.6.6, 9.6.7, 9.6.7

option, 9.8.2

Oracle database server function, 9.8.2

TO_NUMBER_OFF (sidENV variable), 5.4.36

Trace Files

OSDI, 11.1.1.5.1

TRACE_DSNAME parameter, 5.4.17

TRACELEVEL (sidENV variable), 5.4.35

translated SQL function, 9.7

TRCASST, Oracle Net utility program, 6.6

triggers, 8.8.1

database, 1.1.1.2

DB2 server, 8.9.1

Oracle database server, 8.9.1

two-phase commit, 1.1.1.2, 8.7.2

TYPE parameter, 5.2.2

U

UDF (user-defined functions), 2.2.3

UNION capability, 1.1.1.2

UNIX environment, 8.2.1

UPDATE SQL clause, 9.6.7

user

exit module, 7.6

record type, B.1

USER_CATALOG view, C.17

USER_COL_COMMENTS view, C.18

USER_CONS_COLUMNS view, C.19

USER_CONSTRAINTS view, C.20

USER_DB_LINKS data dictionary view, 8.1.6

USER_INDEXES view, C.21

USER_OBJECTS view, C.22

USER_SYNONYMS view, C.23

USER_TAB_COLUMNS view, C.24

USER_TAB_COMMENTS view, C.25

USER_VIEWS view, C.28

user-defined functions (UDFs), DB2, 2.2.3

userids

CONNECT TO, 8.1.4

using

the data dictionary, 9.10.1

USING clause, 8.1.1

USS (z/OS UNIX System Services)

with network service, 6.4.7

utilities

IEBUPDTE, 4.3.3

V

views

catalog for DB2, 9.10.1

data dictionary, 9.10.1

ALL_CATALOG, C.1

ALL_COL_COMMENTS, C.2

ALL_CON_COLUMNS, C.3

ALL_CONSTRAINTS, C.4

ALL_DB_LINKS, 8.1.6

ALL_IND_COLUMNS, C.5

ALL_INDEXES, C.6

ALL_OBJECTS, C.7

ALL_SYNONYMS, C.8

ALL_TAB_COLUMNS, C.9

ALL_TAB_COMMENTS, C.10

ALL_TABLES, C.11

ALL_USERS, C.12

ALL_VIEWS, C.13

COLUMN_PRIVILEGES, C.14

DBA_DB_LINKS, 8.1.6

OTGDB2.OTGREGISTER, C.15

OTGREGISTER, 9.10.2

TABLE_PRIVILEGES, C.16

USER_CATALOG, C.17

USER_COL_COMMENTS, C.18

USER_CONS_COLUMNS, C.19

USER_CONSTRAINTS, C.20

USER_DB_LINKS, 8.1.6

USER_INDEXES, C.21

USER_OBJECTS, C.22

USER_SYNONYMS, C.23

USER_TAB_COLUMNS, C.24

USER_TAB_COMMENTS, C.25

USER_VIEWS, C.28

virtual memory requirements, 3.1.3

VSAM

file, 9.4.2

W

WHERE clause, 8.10, 9.8.1, 9.8.1, 9.8.1, 9.8.1

WHERE CURRENT OF CURSOR clause, 9.6.10

wireless communication, 1.1.1.3

Workload Manager (WLM)

Oracle Net for z/OS architecture, 6.2

Z

zero-length parameter, A.7.2

z/OS

commands

DUMP, 10.7

SLIP, 10.6.5

link pack areas, 5.7.1

operating system, supported releases, 3.2.1

z/OS UNIX System Services (USS)

with network service, 6.4.7