Index

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

Symbols

&ORAPREFD system symbol, 3.4, 4.1.1, 4.1.2, 4.1.3, 6.4.3, 6.4.3, C.1

&ORASESST system symbol, C.1

&ORASRVN system symbol, 4.1.1, 4.1.2, 4.1.3, 6.4.3, C.1

A

abend

error reporting, 16.4.2.4

ORAP, 11.4.7, 11.13.1.6, 11.13.3.1

SMF records, 10.2

access

controlling access to OSDI services, 9.3

controlling access to OSDI subsystem commands, 9.2

controlling access to system privileges, 9.3

security, 2.5

SYSOPER and SYSDBA, 9.4

accounting information, 10

address spaces

AS1, the first address space, 2.6

auxiliary address spaces, 2.6

cross-memory, 15.2.1.1

OSDI subsystem startup, 2.2

when created for Oracle products, 2.2

alert log

closing and releasing, 5.3.1

managing, 5.3

switching, 5.3.1

SYSPRINT DD and, 3.3

ALERT_DSNAME parameter, 3.4

ALERT_MAX parameter, 3.4

ALERT_MIN parameter, 3.4

ALTER DATABASE RENAME statement, 6.3

ALTER SERVICE, OSDI command, A.7

ALTER SERVICEGROUP, OSDI command, A.6

ALTER SESSION SQL command, 15.3.3.4

ALTER, OSDI command, 2.3, A.4

ALTER, SQL statement, 4.4

AM4CAUTH, CICS startup, 11.4.5

AM4COID, CICS startup, 11.4.5

AMI-0108 message, on IMS MTO console, 12.6.9

AMI-0113 message, connection to target Oracle instance, 12.6.9

AMODE, storage requirements, 15.1

application

and active services, 2.3

and bind processing, 2.4

and managed connection bind, 2.5

client address spaces, 9.3

migrating to OSDI, A.7

normal and managed binds, 9.3

architecture, OSDI, 2.1

archive log, 4.1.4

ARCHIVELOG mode

backup and recovery, 6.2

operating a database, 4.1.4

Oracle RDBMS Parameter Considerations, 3.5

AS1

performance, dispatching priority, 15.3.1.1

SYSPRINT DD statement and alert log, 3.3

the first address space, defined, 2.6

ASM_DISKSTRING parameter, B.1

ASO

checklist

for setting up ASO encryption, 8.5.1.1

for testing, 8.5.2.1

connect client and server, 8.5.2.2

encryption, 8.5

reset configuration parameters on server, 8.5.2.3

set parameters for client, 8.5.1.3

set parameters for server, 8.5.1.2

testing, 8.5.2

AUDIT_FILE_DEST parameter, 3.5, 10.7.1, B.1

AUDIT_TRAIL parameter, 3.5, 10.7.1, B.1

auditing database use, 10.7

authorization check

for command processing, 9.2

SYSOPER/SYSDBA, 2.5

AUTOEXTEND clause, 4.2.1, 4.2.4

automatic initialization, setting up, 11.4.10

B

BACKGROUND_CORE_DUMP parameter, B.1

BACKGROUND_DUMP_DEST parameter, B.1, B.1

backup and recovery, database

overview, 6.1

with RMAN, 6.4

without RMAN, 6.3

backup, tablespace, 6.3

bigfile tablespaces, 4.2.5, 4.5.1

bind

authorization check, 9.3

defined, 2.4

BITMAP_MERGE_AREA_SIZE parameter, B.1

BPXPRMxx member, 8.2.7

BUFNO(nnn) keyword, ORA$FPS parameter file, 4.4.3

C

catalog

retention, with tape backup, 6.4.4

caution

SETSSI ADD, z/OS System command, 1.5

CEDA DEFINE TRANSACTION command, 11.4.8.2

CHARACTER SET parameter, B.3.1, B.3.2

checklist

configuring Oracle Access Manager for CICS, 11.3.1

configuring Oracle Access Manager for IMS TM, 12.5.1

setting up ASO, 8.5.1.1

testing ASO, 8.5.2.1

CICADPX load module, 11.4.4

CICS

Attach installation

copying LIBCLNTS, 11.4.4

copying ORACICSC, 11.4.4

defining transactions, 11.4.8.2

generating ORACSTUB stub, 11.4.7

setting up automatic initialization, 11.4.10

defining MESG library to, 11.4.3

DFHRPL library, 11.4.3, 11.4.3

Oracle Access Manager for CICS

MPM restrictions, 11.1

profile for managed binds, 9.3

recovery procedures, 11.7.1

tables, 11.4.8.2, 11.4.8.2

transaction

IAP, 11.4.8.2

ORAC, 11.4.8.2

CICS SYNCPOINT

choosing, 11.13.2.1

Oracle Access Manager for CICS, 11.8

CICS syncpoint, at startup, 11.4.5

client

special meaning defined, 2.4

CLUSTER_ENABLE parameter, 3.4

command

COMMIT, 11.7.2

DISPLAY SUBSYSTEM, 12.7

IDCAMS

DELETE, 9.6

OSDI

table of command verbs, 9.2

ALTER, 2.3, A.4

ALTER SERVICE, A.7

ALTER SERVICEGROUP, A.6

DEFINE, 1.4, 2.3, A.4

DEFINE SERVICE, 1.4, A.7

DEFINE SERVICEGROUP, 1.4, A.6

DISPLAY, 2.3, 8.3, A.10

DISPLAY LONG, 8.3

DRAIN, 8.3, A.10

keyword abbreviations, A.11

list of commands, A.9

RESUME, 8.3, A.10

SETSSI ADD, 1.6

SHOW, 1.6, A.4

SHOW SERVICE, A.7

SHOW SERVICEGROUP, A.6

START, 1.4, 2.3, 2.6, 2.6, 2.7, 8.3, A.10

STOP, 2.6, 8.3, A.10

RMAN ALLOCATE CHANNEL, 6.4.1

ROLLBACK, 11.7.1, 11.7.2

SQL

ALTER SESSION, 15.3.3.4

START, 3.7

START SUBSYSTEM, 12.8

STARTUP MOUNT, 6.3

SYNCPOINT, 11.7.1, 11.7.2

z/OS System

DISPLAY SESSION, 5.4.1

DISPLAY VERSION, 5.4.2

DUMP SESSION, 5.4.3

KILL SESSION, 5.4.4

LOGSWITCH, 5.4.5

MODIFY (F), 2.6, 8.3

MODIFY (or F), 5.4

REFRESH FPS, 5.4.6

SETSSI ACTIVATE, 2.2

SETSSI ADD, 1.5, 1.5, 2.2

SETSSI DEACTIVATE, 2.2

STOP (P), 2.6, 8.3

COMMIT

choosing for CICS, 11.13.2.1

command, 11.7.2

COMMIT_POINT_STRENGTH parameter, B.1

COMMIT/ROLLBACK

Oracle Access Manager for CICS, 11.8

control file, 4.1.1

CONTROL_FILES parameter, 3.5, B.1

CORE_DUMP_DEST parameter, B.1

CPU_COUNT parameter, B.1

CREATE DATABASE statement

CONNECT command and, 3.9

supplies data set names of log files, 4.1.3

CREATE member, PARMLIB library, 3.9

CREATE SQL statement, 4.4

CREATE_BITMAP_AREA_SIZE parameter, B.1

CREATE_MODELDSN(dsn) keyword, ORA$FPS parameter file, 4.4.3

Cross System Communication Facility (XCF), 14.3

cross-memory address spaces, 15.2.1.1

CSA storage, 12.10.1, 15.2.1.1

cursor close behavior, 12.4.7

D

data sets

extended-format, 4.2.5

database

accounting information, 10

auditing use, 10.7

backup and recovery, 6

configuring, 3

file extension, 4.2.1

file size limit, B.2

initial, 3

limits, B.2

links, defined for security, 9.5

migration and upgrade, 17

pre-allocating files, 4.5

region parameters, defined, 3.4

service, OSDI architecture, 2.6

standby, 4.7

starting and stopping, 5.1

ultra large datafiles, 4.2.5, 4.5.1

DATACLAS(classname) keyword, ORA$FPS parameter file, 4.4.3

DATAFILE parameter, B.3.2

DB_BLOCK_BUFFERS parameter, B.1

DB_BLOCK_SIZE parameter, 3.5, B.1

DB_CREATE_FILE_DEST parameter, 3.5, B.1

DB_CREATE_ONLINE_LOG_DEST_n parameter, 3.5, B.1

DB_FILE_MULTIBLOCK_READ_COUNT parameter, B.1

DB_FILE_NAME_CONVERT parameter, 3.5, B.1

DB_FILES parameter, B.1

DB_KEEP_CACHE_SIZE parameter, B.1

DB_nK_CACHE_SIZE parameter, B.1

DB_RECYCLE_CACHE_SIZE parameter, B.1

DBAL file group, 4.4.1, 6.2

DBAT file group, 4.4.1

DBAU file group, 4.4.1

DBBA file group, 4.4.1

DBBI file group, 4.4.1

DBBK file group, 4.4.1

DBCH file group, 4.4.1

DBCP file group, 4.4.1

DBCTfile group, 4.4.1

DBDB file group, 4.4.1

DBDR file group, 4.4.1

DBOL file group, 4.4.1

DBOS file group, 4.4.1

DBPM file group, 4.4.1

DBSP file group, 4.4.1

DBST file group, 4.4.1

DBTR file group, 4.4.1

DBTS file group, 4.4.1

DBV (Database Verification Utility), 7.4

DBWR_IO_SLAVES parameter, B.1

DCB BUFNO JCL parameter, 15.3.3.2

DD statement

NET8LOG, 8.2.6

ORA$ENV, 3.3

ORA$FPS, 3.3

ORA$LIB, 3.3

ORAPASSW, 3.3

SNAPCF, 3.3

SQLBSQ, 3.3

SQLNET, 3.3

STEPLIB, 3.3, 8.2.6

SYSPRINT, 3.3

TNSNAMES, 3.3

default record number for SMF, 10.1.1

DEFAULT_SPACE(primary secondary) keyword, ORA$FPS parameter file, 4.4.3

DEFINE CLUSTER commands, 4.1

DEFINE command

defining services to the subsystem, 2.3

in the subsystem parameter file, 1.4

supported definition command, A.4

DEFINE SERVICE, OSDI command, 1.4, A.7

DEFINE SERVICEGROUP, OSDI command, 1.4, A.6

defining a service, 2.3

definition commands, A.4

DFHRPL library, 11.4.3, 11.4.3

DFLT file group, 4.4.1, 4.4.3

DFSMSrmm, tape management software, 6.4.4

DFSORT utility, performance tuning, 15.3.3.5

DG_BROKER_CONFIG_FILEn parameter, B.1

DISPATCHERS (SESSIONS, CONNECTIONS) parameter, B.1

DISPLAY LONG, OSDI command, 8.3

DISPLAY SESSION, z/OS command, 5.4.1

DISPLAY SUBSYSTEM command, 12.7

DISPLAY VERSION, z/OS command, 5.4.2

DISPLAY, OSDI command

defined, A.10

display the state of a service, 2.3

with CICS, 11.13.1

with Oracle Net service, 8.3

distributed option, considerations, 12.4.3

documentation

errors, 16.4.2.1

DRAIN, OSDI command

defined, A.10

preventing network connections, 8.3

DSN_PREFIX_DB parameter, 3.4

DSS_COMPRESS( YES | NO ) keyword, ORA$FPS parameter file, 4.4.3

DUMP command (MVS), 16.5.2

DUMP keyword, Oracle Net, 8.2.5

DUMP SESSION, z/OS command, 5.4.3

E

ECSA storage

Oracle Access Manager for IMS TM, 12.3.1, 12.10.1

EDM (External Data Mover), 6.4.1

EDM_TAPEDSN(dsname) keyword, ORA$FPS parameter file, 4.4.3

empty parameter, A.7

Enabling CICS Attach adapter, 11.4.9

ENCLAVE keyword, Oracle Net, 8.2.5

CALL option and WLM, 15.3.4

SESS option and WLM, 15.3.4

encryption, ASO, 8.5

environment variable assignment statements, ORA$ENV and, 3.3

error

12660, 8.5

diagnosis

categories, 16.4.2

investigating a potential Oracle server error, 16.4

IEC130I, 3.3, 3.3

message traffic to the console, 8.3

messages for network region JCL, 8.2.6

ORA-12660, 8.5.2.2

processing, Oracle Access Manager for IMS TM, 12.4.5

reporting

abend, 16.4.2.4

documentation, 16.2, 16.4.2.1

error categories, 16.4.2

GTF, 16.6

incorrect output errors, 16.4.2.2

Oracle error messages, 16.4.2.3

Oracle wait state, 16.4.2.8

program loop, 16.4.2.5

required documentation, 16.3

sending tapes, 16.2

SLIP, 16.5.3

system dump, 16.5

system dump data sets, 16.5.1

TSO symptom dumps, 16.5.4

wait state, 16.4.2.8

ESAF, 12.3

ESQA storage, 15.2.1.2

Euro Support, NLS, D.4

EXEC SQL COMMIT statement, 11.7.2

EXEC SQL ROLLBACK statement, 11.7.2

EXPIRATION_DATE( yyyyddd | yyddd ) keyword, ORA$FPS parameter file, 4.4.3

Extended Pageable Link Pack Area (EPLPA), storage requirements, 15.1

extended-format data sets, 4.2.5

extending database files, 4.2.1

External Data Mover (EDM), 6.4.1

external procedures

overview, 8.6.2

external routines

generic listener support, 8.1

modifying tnsnames.ora, 3.3

External Subsystem Attachment Facility, 12.3

external subsystems

IMS, 12.7

Oracle Access Manager for IMS TM, 12.7

external table feature, Oracle, 9.5

F

failure after initial connection, 12.4.8.2

file

copying and moving, 4.7

linear data set (LDS), 4.1, 4.5.2

OSDI subsystem parameter file, 1.3

pre-allocating, 4.5

size limit, database, B.2

ultra large datafiles, 4.2.5, 4.5.1

file group definitions, 4.4.3

file group names, 4.4.1

file management parameters

example, 6.4.11

External Data Mover and, 4.4.2

keyword list, 4.4.3

FILE_GROUP(name) keyword, ORA$FPS parameter file, 4.4.3

FORCE privileges for recovery processing, 11.4.5

FPS

ORA$FPS DD statement, 3.3

REFRESH FPS, z/OS command, 5.4.6

G

generic listener

configuring for external procedures, 8.8

configuring for SSL, 8.7

introduction, 8.6

overview, 8.1

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

Global Environment Variable File, 7.1

granting access for consoles and users, 9.2

GTF (z/OS Generalized Trace Facility)

as a diagnostic tool, 16.6

GTF keyword, Oracle Net, 8.2.5

H

HASH_AREA_SIZE parameter, 15.2.1.1, B.1

hot backup, 6.3

HPNS keyword, Oracle Net, 8.2.5

I

IAP transaction, 11.4.8.2

IBM DFSMSdss, database backup and recovery, 6.3

IBM Language Environment (LE) interface, 11.1, 15.2.1.1

IBM LE/370 runtime library

database region JCL, 3.3

IDCAMS DELETE command, 9.6

IDCAMS utility

creating archive logs, 6.2

for security, 9.5

with Oracle database files, 4.1

IDLE_TIMEOUT parameter, 3.4

IEC130I error, 3.3, 3.3

IEFSSNxx member, 1.5

IEFSSREQ macro, 2.4

IEFUSI exit, 3.3

IMS

commands

DISPLAY SUBSYSTEM, 12.7

START SUBSYSTEM, 12.8

connection failure, 12.8

control region, 12.4.1, 12.7

dependent region, 12.4.1, 12.8

ESAF, 12.3

external subsystems, 12.7

integration with Oracle Access Manager for IMS TM, 12.3

Language Interface Token (LIT), 12.4

LTERM, 12.4.4.1

Master Terminal Operator, 12.7

PROCLIB, 12.4.1

profile for managed binds, 9.3

recovery, 12.9

recovery considerations, 12.4.6

REO, 12.4.5

RESLIB, 12.4

SSM member, 12.4.1

incorrect output errors, 16.4.2.2

INIT record

example, 1.3

in the subsystem initialization file, 1.3

INIT_ADR_SPACES parameter, 3.4

performance tuning, 15.2.1.1

INIT_STACK_SIZE

OSDI parameter

performance tuning, 15.2.1.1, 15.2.1.3

INIT_STACK_SIZE parameter, 3.4

initial connection failure, 12.4.8.1

initialization parameters, 3.5, B.1

J

JAVA_POOL_SIZE parameter, B.1

JCL, network region, 8.2.6

JOBNAME parameter, 3.2

JVM, Oracle9i, 9.5

K

keyword abbreviations, OSDI command, A.11

KILL SESSION, z/OS command, 5.4.4

L

Language Environment runtime library (LE)

Oracle Net, 8.2.7

Language Interface Token, 12.4

LARGE_POOL_SIZE parameter, B.1

LE (IBM Language Environment interface)

CICS transaction, 11.1

Oracle address spaces, 15.2.1.1

LIBCLNTS load module

copying to CICS libraries, 11.4.4

LPA considerations, 15.1.2

limits, database, B.2

linear data set (LDS) files, 4.1, 4.5.2

linklist library, initializing the subsystem, 1.5

listen operations, network service, 2.7

listener

generic, See generic listener

OSDI, See OSDI listener

LIT

AMILI macro, 12.6.2

Language Interface Token, 12.4

LOCK_SGA parameter, 3.5, B.1

log file group, 4.1.3

log files, redo, 4.1.3, B.2

LOG_ARCHIVE_ parameter, 3.5

LOG_ARCHIVE_DEST parameter, B.1

LOG_ARCHIVE_DEST_n parameter, 3.5

LOG_ARCHIVE_FORMAT parameter, B.1

LOG_BUFFER parameter, B.1

LOG_FILE_NAME_CONVERT parameter, 3.5, B.1

LOGFILE parameter, B.3.2

logon exit

functions, 9.9

R15 return code, 9.9

LOGON_AUTH parameter, 3.4, 9.9, 9.9

LOGSWITCH, z/OS command, 5.4.5

LPA storage, 15.2.1.1

LXEGEN, NLS calendar utility, D.6

M

macro, IEFSSREQ, 2.4

Management Agent, Oracle Enterprise Manager, 13

MAX_DISPATCHERS parameter, B.1

MAX_DUMP_FILE_SIZE parameter, B.1

MAX_SESSION_MEM parameter, 3.4, 15.2.3

MAX_SESSIONS parameter, 3.4, 15.2.2

MAX_SHARED_SERVERS parameter, B.1

MAXAS parameter

database region parameters, 3.4

database service definition, 3.2

performance tuning, 15.2.1.1

MAXDATAFILES parameter, B.3.1, B.3.2

MAXFILEPROC parameter, 8.2.7

MAXINSTANCES parameter, B.3.1, B.3.2

MAXLOGFILES parameter, B.3.1, B.3.2

MAXLOGHISTORY parameter, B.3.1, B.3.2

MAXLOGMEMBERS parameter, B.3.1, B.3.2

MAXSOCKETS parameter, 8.2.7

member

BPXPRMxx, 8.2.7

IEFSSNxx, 1.5

SSP01, 1.5

MESG library, 11.4.3

message

AMI-0108, IMS MTO console, 12.6.9

AMI-0113, connection to target Oracle instance, 12.6.9

IEC130I, 3.3, 3.3

MIR0110W, security fault, 9.5

MGMTCLAS(classname) keyword, ORA$FPS parameter file, 4.4.3

migration

See upgrade

MIR0110W message, security fault, 9.5

mode

ARCHIVELOG, 6.2

NOARCHIVELOG, 6.2

MODIFY (F), z/OS command

communicating with a running Oracle Net service, 8.3

operator interaction with a running database service, 2.6, 5.4

MVS Workload Manager

See Workload Manager

N

National Language Support (NLS), D

calendar utility, D.6

character set support, D.3

character sets, D.3

client-side, D.5

data objects, ORA$LIB DD statement, 3.3

Euro support, D.4

server-side, D.4

supported languages, D.2

Net service

See OSDI listener

NET8LOG DD statement, 8.2.6

Network Information Vector (NIV)

security, 10.5

network service, OSDI architecture, 2.7

NIV

See Network Information Vector

NLS

See National Language Support (NLS)

NLS_LANG environment variable, D.3

NLS_LANGUAGE parameter, B.1

NLS_TERRITORY parameter, B.1

NOARCHIVELOG mode, 6.2

NTPM file group, 4.4.1

NTTR file group, 4.4.1

O

OBJECT_CACHE_MAX_SIZE_PERCENT parameter, B.1

OBJECT_CACHE_OPTIMAL_SIZE parameter, B.1

Offline Database Verification Utility (DBV) on z/OS, 7.4

OMF

See Oracle Managed Files

OPEN_CURSORS parameter, B.1, B.1

operating states of services, 2.3

operator initiated dumps, 16.5.2

ORA$ENV DD statement, 3.3

ORA$FPS DD statement

database region JCL, 3.3

file management parameters, 4.4, 4.4.3

REFRESH FPS, 5.4.6

ORA$FPS parameter file, 4.4.3, 6.2

ORA$LIB

DD statement, database region JCL, 3.3

ORA@ENV DD statement, D.3

ORA-12660 error, 8.5.2.2

ORAC transaction, 11.4.8.2

ORACICS load module, 11.4.4, 11.6

ORACICSC load module, 11.4.4

Oracle Access Manager for CICS

adapter storage requirements, 11.14.2

applications, 11.2

base code storage requirements, 11.14.1

CICS SYNCPOINT, 11.8

commands

DISPLAY, 11.13.1

START, 11.13.2

STOP, 11.13.3

syntax, 11.13

usage, 11.13

COMMIT/ROLLBACK, 11.8

connected thread storage requirements, 11.14.4

defining MESG library to, 11.4.3

MPM restrictions, 11.1

multiple versions coexisting, 11.6

recovery procedures, 11.7.1

restarting, 11.8.2.1

shutdown with force, 11.9

SMF recording, 10.3, 10.3

thread pool storage requirements, 11.14.3

transaction ID, 11.13

Oracle Access Manager for IMS TM

31-bit addressing, 12.3.1

AMIENV macro, 12.6.5.4

AMIRT macro, 12.6.5.1

AMISESS macro, 12.6.5.3

AMITRANS macro, 12.6.5.2

authentication, 12.4.4.2

configuration

AMILS, 12.4

checklist, 12.5

IMS RESLIB, 12.4

overview, 12.4

control region, 12.7

CREATE SESSION, 12.6.3

CSA storage, 12.10.1

define an MVS subsystem, 12.6.1

dependent region, 12.3, 12.4.1, 12.8

ECSA storage, 12.10.1

environment variables, 12.4.9

error processing, 12.4.5

ESCA storage, 12.3.1

External Subsystem Attachment Facility (ESAF), 12.3

external subsystems, 12.7

failure, 12.9

FORCE ANY TRANSACTION, 12.6.3

IMS

connection failure, 12.8

control region, 12.3, 12.4.1, 12.7, 12.8

dependent region, 12.3, 12.4.1

DISPLAY SUBSYSTEM command, 12.7

ESAF, 12.3

integration with, 12.3

Language Interface Token (LIT), 12.4

LTERM, 12.4.4.1

Master Terminal Operator, 12.7

PROCLIB, 12.4.1

recovery, 12.9

recovery considerations, 12.4.6

REO, 12.4.5

RESLIB, 12.4

SSM member, 12.4.1

in-doubt processing, 12.9

integration with IMS, 12.3

linking stub, AMILS, 12.4

LIT, AMILI macro, 12.6.2

Master Terminal Operator, 12.7

object privileges

SELECT ON SYS.PENDING_SESSIONS$, 12.6.3

SELECT ON SYS.PENDING_TRANS$, 12.6.3

parent database id, 12.9

performance, 12.10

profiles, IDLE_TIME, 12.6.3

recovery, 12.9

recovery considerations, 12.4.6

control region, 12.4.6

ESAF, 12.4.6

REO character values, 12.4.5

RTT, 12.4.2

AMIENV macro, 12.6.5, 12.6.5.4

AMIRT macro, 12.6.5, 12.6.5.1

AMISESS macro, 12.6.5, 12.6.5.3

AMITRANS macro, 12.6.5, 12.6.5.2

sample SQL statements, 12.6.3

security, 12.4.4

SELECT ON SYS.PENDING_SESSIONS$, 12.6.3

SELECT ON SYS.PENDING_TRANS$, 12.6.3

session authentication, EXTERNAL, 12.4.4.2

SSM member, 12.4.1

starting and stopping, 12.8

statements

ALTER USER, 12.4.4.2

CREATE USER, 12.4.4.2

GRANT SELECT, 12.6.3

NO_LIMIT, 12.6.3

system authentication password, 12.4.4.2

system privileges

CREATE SESSION, 12.6.3

FORCE ANY TRANSACTION, 12.6.3

Oracle Access Manager, products, with multiple database connections, 2.6

Oracle Advanced Security Option

See ASO

Oracle Enterprise Manager Management Agent, 13

Oracle external table feature, 9.5

Oracle listener

See Generic Listener

Oracle Managed Files (OMF), 4.1, 4.6

Oracle Net

configuring OSDI listener, 8.2

generic listener, 8.1

Network Information Vector (NIV)

security, 10.5

OSDI listener, 8.1

overview, 8.1

starting network service, 2.7

Oracle Password Utility (ORAPWD) on z/OS, 7.3

Oracle precompilers, recovery under Oracle Access Manager for CICS, 11.7.1

Oracle startup request, issuing, 2.6

Oracle subsystem

accounting information, 10

error reporting, 16.4.2.3

resource usage, 10

statistics, 10

Oracle Support Services

documentation requirements, 16.1

using FTP (File Transfer Protocol), 16.2

working with them, 16.1

Oracle unavailable situations, 12.4.8

Oracle user record type, 10.1

ORACLE_HOME environment variable, 3.3

Oracle9i JVM, 9.5

Oracle9i Real Application Clusters, 14

ORACSTUB stub, 11.3, 11.4.7, 11.6

ORAEDM program, 6.4.1

ORAFMT program for SMF, 10.4

ORAFMTCL sample JCL, 10.6

ORAFMTGO sample JCL, 10.6, 10.6

ORAFMTO sample program, 10.6

ORAH transaction, 11.4.8.2

ORAP application abend, 11.4.7, 11.13.1.6, 11.13.3.1

ORAPASSW DD statement, 3.3

ORAPWD

defined, 7.3

utility, with ORAPASSW DD statement, 3.3

ORASSI subsystem code module, 15.1.1

ORASSINI initialization routine, 1.5

OS_AUTHENT_PREFIX initora parameter, 11.4.5

OS_AUTHENT_PREFIX parameter, B.1

OSDI

architecture

connections, 2.4

database service, 2.6

general description, 2.1

network service, 2.7

security, 2.5

services, 2.3

subsystem, 2.2

command

examples to define service group and services, 1.6

keyword abbreviations, A.11

listener, 8.1

MESG data set, ORA$LIB DD statement, 3.3

performance tuning, 15.2.1.1

subsystem initialization, 2.3

subsystem is present in the OS/390 system until the next IPL, 2.2

OSDI listener

ASO encryption, 8.5

configuring, 8.2

initialization parameters, 8.2.5

JCL procedure, 8.2.6

operating, 8.3

TCP/IP, 8.2.7

trace files, 8.4

OSUSER keyword, Oracle Net, 8.2.5

P

PARALLEL_THREADS_PER_CPU parameter, B.1

parameter

ASM_DISKSTRING, B.1

ASO, setting for server, 8.5.1.2

AUDIT_FILE_DEST, 3.5, 10.7.1, B.1

AUDIT_TRAIL, 10.7.1, B.1

BACKGROUND_CORE_DUMP, B.1

BACKGROUND_DUMP_DEST, B.1

BITMAP_MERGE_AREA_SIZE, B.1

CHARACTER SET, B.3.1, B.3.2

COMMIT_POINT_STRENGTH, B.1

configuration, resetting on server, 8.5.2.3

CONTROL_FILES, 3.5, B.1

CORE_DUMP_DEST, B.1

CPU_COUNT, B.1

CREATE_BITMAP_AREA_SIZE, B.1

database region parameter

ALERT_DSNAME, 3.4

ALERT_MAX, 3.4

ALERT_MIN, 3.4

CLUSTER_ENABLE, 3.4

DSN_PREFIX_DB, 3.4

IDLE_TIMEOUT, 3.4

INIT_ADR_SPACES, 3.4

INIT_STACK_SIZE, 3.4

LOGON_AUTH, 3.4, 9.9

MAX_SESSION_MEM, 3.4

MAX_SESSIONS, 3.4

REGION_MEM_RESERVE, 3.4

SERVER_LOADMOD, 3.4

SMF_STAT_RECNO, 3.4

TRACE_DSNAME, 3.4

DATAFILE, B.3.2

DB_BLOCK_BUFFERS, B.1

DB_BLOCK_SIZE, 3.5, B.1

DB_CREATE_FILE_DEST, 3.5, B.1

DB_CREATE_ONLINE_LOG_DEST_n, 3.5, B.1

DB_FILE_MULTIBLOCK_READ_COUNT, B.1

DB_FILE_NAME_CONVERT, 3.5, B.1

DB_FILES, B.1

DB_KEEP_CACHE_SIZE, B.1

DB_nK_CACHE_SIZE, B.1

DB_RECYCLE_CACHE_SIZE, B.1

DBWR_IO_SLAVES, B.1

DCB BUFNO JCL, 15.3.3.2

DG_BROKER_CONFIG_FILEn, B.1

DISPATCHERS (SESSIONS, CONNECTIONS), B.1

encryption, 8.5.1.2, 8.5.1.3

HASH_AREA_SIZE, 15.2.1.1, B.1

INIT_ADR_SPACES, 15.2.1.1

INIT_STACK_SIZE, 15.2.1.1, 15.2.1.3

initialization, 3.5, B.1

init.ora file, 4.1.1

INSTANCE_NUMBER, B.1

JAVA_POOL_SIZE, B.1

JOBNAME, 3.2

LARGE_POOL_SIZE, B.1

LOCK_SGA, 3.5, B.1

LOG_ARCHIVE_, 3.5

LOG_ARCHIVE_DEST, B.1

LOG_ARCHIVE_DEST_n, 3.5

LOG_ARCHIVE_FORMAT, B.1

LOG_BUFFER, B.1

LOG_FILE_NAME_CONVERT, 3.5, B.1

LOGFILE, B.3.2

MAX_DISPATCHERS, B.1

MAX_DUMP_FILE_SIZE, B.1

MAX_SESSION_MEM, 15.2.3

MAX_SESSIONS, 15.2.2

MAX_SHARED_SERVERS, B.1

MAXAS

database service parameter, 3.2

performance tuning, 15.2.1.1

MAXDATAFILES, B.3.1, B.3.2

MAXFILEPROC, 8.2.7

MAXINSTANCES, B.3.1, B.3.2

MAXLOGFILES, B.3.1, B.3.2

MAXLOGHISTORY, B.3.1, B.3.2

MAXLOGMEMBERS, B.3.1, B.3.2

MAXSOCKETS, 8.2.7

NLS_LANGUAGE, B.1

NLS_TERRITORY, B.1

OBJECT_CACHE_MAX_SIZE_PERCENT, B.1

OBJECT_CACHE_OPTIMAL_SIZE, B.1

OPEN_CURSORS, B.1

OS_AUTHENT_PREFIX, B.1

OS_AUTHENT_PREFIX initora, 11.4.5

PARALLEL_EXECUTION_MESSAGE_SIZE, B.1

PARALLEL_THREADS_PER_CPU, B.1

PARM, 3.3

PROCESS, B.1

RECOVERY_PARALLELISM, B.1

REGION

database region JCL, 3.3

network region JCL, 8.2.6

REGION=0M, 15.2.5

REGION_MEM_RESERVE, 15.2.3

SESSION_CACHED_CURSORS, B.1

SESSION_MAX_OPEN_FILES, B.1

setting, for client, 8.5.1.3

SGA_MAX_SIZE, 3.5, 15.2.1.2, B.1

SGA_TARGET, B.1

SHADOW_CORE_DUMP, B.1

SHARED_POOL_SIZE, B.1

SID, 2.7

SMF_STAT_RECNO parameter, 10.1.1

SORT_AREA_SIZE, 15.2.1.1, 15.3.3.4, B.1

SPFILE, B.1

defined, 3.5

STARTUP statement, 3.5

SQL language, B.3

STANDBY_ARCHIVE_DEST, 3.5, B.1

storage, B.4

STREAMS_POOL_SIZE, B.1

TIMED_OS_STATISTICS, B.1

TRACEFILE_IDENTIFIER, 3.5, B.1

TRANSACTIONS_PER_ROLLBACK_SEGMENT, B.1

TYPE, 3.2

USER_DUMP_DEST, B.1

zero-length (empty), A.7

PARM parameter, 3.3

PARM string, OSDI listener, 8.2.5

PARMLIB library

contents, 3.10

CREATE member, 3.9

creation, 3.10

location, 3.10

PFILE

in CREATE SPFILE statement, 3.5

in STARTUP statement, 3.5

Pnnn file group, 4.4.1

PORT keyword, Oracle Net, 8.2.5

pre-allocating database files, 4.5

PROC parameter of DEFINE SERVICE, 5.1

PROCESS parameter, B.1

PROFILE WTPMSG, 16.5.4

program loop, reporting the error, 16.4.2.5

program, ORAEDM, 6.4.1

proxy backup, 4.4.3, 4.4.3, 6.4.11, 6.4.11

identification, 6.4.5

restore, 6.4.5.2

restrictions, 6.4.5.1

R

R15 return code from logon exit, 9.9

RACF

authorization control, 2.5

IBM's z/OS Security Server, 2.5

SAF-compliant security server, 9.3

with network service, 8.2.7

RACROUTE interface, 2.5

READ authorization, controlling access to services, 9.3

Real Application Clusters, 14

RECALL( ALL | NONE ) keyword, ORA$FPS parameter file, 4.4.3

recording SMF information, 10.1

recover.bsq script, needed by RMAN, 7.2

recovery

CICS SYNCPOINT, 11.13.2.1

COMMIT/ROLLBACK, 11.13.2.1

defined (database backup and recovery), 6.2

manual, Access Manager for CICS, 11.8.2.3

Recovery Manager (RMAN)

backup and recovery with, 6.4

backup and recovery without, 6.3

invoking, 7.2

on z/OS, 7.2

RECOVERY_PARALLELISM parameter, B.1

redo log files, 4.1.3, B.2

REFRESH FPS, z/OS command, 5.4.6

region error option (REO), 12.4.5, 12.4.5

REGION parameter, 3.3, 8.2.6

REGION=0M keyword parameter, 15.2.5

REGION_MEM_RESERVE parameter, 3.4, 15.2.3

REO, character values, 12.4.5

Resource Translation Table, 12.4.2

resource usage, 10

restart, Oracle Access Manager for CICS, 11.8.2.1

RESUME command

defined, A.10

Oracle Net, 8.3

retention policy, with tape backup, 6.4.4

RMAN ALLOCATE CHANNEL command, 6.4.1

RMODE, storage requirements, 15.1

ROLLBACK command, 11.7.1, 11.7.2

RTT

macro parameters, 12.6.5

resource translation table, 12.4.2

S

SAF

access provided by RACROUTE interface, 2.5

authorization control, 2.5

controlling access privileges, 9.4

controlling access to system privileges, 9.3

SAF-compliant security server, 9.3

subsystem parameter file, 1.3

samples

Oracle Access Manager for IMS TM

SQL statements, 12.6.3

Secure Socket Layer (SSL), 8.6

security

Oracle Access Manager for IMS TM, 12.4.4

OSDI architecture, 2.5

SELECT privileges for recovery processing, 11.4.5

sending tapes to Oracle, 16.2

SERVER_LOADMOD parameter, 3.4

service

controlling access to OSDI services, 9.3

definition commands, A.7

where to place them, 2.3

OSDI service defined, 2.3

service group

defined, 2.2

definition commands, A.6

service name, for a database, 3.2

service class

See Workload Manager

SESSION_CACHED_CURSORS parameter, B.1

SETSSI ACTIVATE command, 2.2

SETSSI ADD command, 1.5, 1.5, 1.6, 2.2

SETSSI DEACTIVATE command, 2.2

SGA (System Global Area) on z/OS, 15.2.1.2

SGA_MAX_SIZE parameter, 3.5, 15.2.1.2, B.1, B.1

SGA_TARGET parameter, B.1

SHADOW_CORE_DUMP parameter, B.1

shared servers

configuring for, 3.8

generic listener support, 8.1

modifying tnsnames.ora, 3.3

overview, 8.6.1

restrictions on z/OS, 8.6.1

SHARED_POOL_SIZE parameter, B.1

SHAREOPTION( n ) keyword, ORA$FPS parameter file, 4.4.3

SHOW SERVICE, OSDI command, A.7

SHOW SERVICEGROUP, OSDI command, A.6

SHOW, OSDI command, 1.6, A.4

SHUTDOWN ABORT command, not recommended, 5.2

shutdown, Oracle Access Manager for CICS, 11.9

SID

defined

database service name, 3.2

parameter

specifying a target z/OS server, 2.7

SITEINFO file, 8.2.7

SLIP, 16.5.3

SMF

abnormal terminations, 10.2

activating, 10.1

default record number, 10.1.1

interpreting records, 10.4

ORAFMT program, 10.4

ORAFMTO sample program, 10.6

record, with NIV, 10.5

recording

starting, 10.1.2

stopping, 10.1.3

records, 10, 10.4

sample formatting program, 10.6

types of users, 10.1

user-defined data section, 10.6

when records are written, 10.2

with Oracle Access Manager for CICS, 10.3

SMF_STAT_RECNO parameter, 3.4

SMF_STAT_RECNO, OSDI service parameter, 10.1.1

SMFPRMxx member, 10.1

SNAPCF DD statement, 3.3

SORT_AREA_SIZE parameter, 15.2.1.1, 15.3.3.4, B.1

SPFILE parameter, B.1

defined, 3.5

STARTUP statement, 3.5

SQA storage, 15.2.1.1, 15.2.1.1, 15.2.1.2, 15.2.1.2

SQL ALTER TABLESPACE statement, 6.3

SQL parameters, B.3

SQL statement

ALTER, 4.4

CREATE, 4.4

EXEC SQL COMMIT, 11.7.2

EXEC SQL ROLLBACK, 11.7.2

SQLBSQ DD statement, 3.3

SQLNET DD statement, 3.3

SQLPLUS module, LPA considerations, 15.1.2

SSL (Secure Socket Layer), 8.6

SSP01 member, 1.5

standby database, 4.7

STANDBY_ARCHIVE_DEST parameter, B.1

START

command, 3.7, 11.13.2

OSDI command

database service, 2.6

defined, A.10

in the subsystem parameter file, 1.4

manually starting auxiliary address spaces, 2.6

Oracle Net network service, 2.7

running a service, 2.3

starting Oracle Net service, 8.3

SUBSYSTEM command, 12.8

started task (STC) address space, 2.6

starting and stopping the database, 5.1

STARTUP command, 3.5, 3.9

STARTUP FORCE command, not recommended, 5.2

STARTUP MOUNT command, 6.3

statement

ALTER USER, 12.4.4.2

CREATE USER, 12.4.4.2

GRANT SELECT, 12.6.3

NO_LIMIT, 12.6.3

SQL, 12.6.3

ALTER, 4.4

CREATE, 4.4

static-fixed memory allocations, defined, 15.2

STEPLIB DD statement

database region JCL, 3.3

Oracle Net region JCL, 8.2.6

STOP

command, 11.13.3

OSDI command, 2.6, 8.3

defined, A.10

STOP (P) z/OS System command, 2.6, 8.3

storage

parameters, B.4

STORCLAS(classname) keyword, ORA$FPS parameter file, 4.4.3

stored PL/SQL procedures in SYSTEM tablespace, 4.1.2

STREAMS_POOL_SIZE parameter, B.1

subsystem, OSDI

address space, 2.2

functions, 2.4

initialization file example, 1.6

initialization, OSDI, 2.3

OSDI architecture, 2.2

parameter file, 1.3

primary role, 2.3

security, 2.5

subsystem interface (SSI), 2.2

SYNCPOINT command, 11.7.1, 11.7.2

SYNCSORT utility, performance tuning, 15.3.3.5

SYS1.DUMP data set, 16.5.1

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

SYSOPER/SYSDBA authorization check, 2.5

SYSPRINT DD statement, 3.3

System Authorization Facility (SAF)

authorization control, 2.5

controlling access privileges, 9.4

controlling access to system privileges, 9.3

SAF-compliant security server, 9.3

system crashes, SMF, 10.2

system dump

data sets, 16.5.1

failure documentation, 16.5

System Global Area (SGA) on z/OS, 15.2.1.2

system log, example, 1.6

system privileges

SYSDBA, 9.3

SYSOPER, 9.3

system symbols, C.1

&ORAPREFD, C.1

&ORASESST, C.1

&ORASRVN, C.1

SYSTEM tablespace, 6.3

T

tablespaces

backing up, 6.3

bigfile, 4.2.5, 4.5.1

enlarging, 4.2.1

size limits, B.2

tapes

sending to Oracle, 16.2

thread pool, storage requirements, 11.14.3

thread table, Oracle Access Manager for CICS, 11.1

thread, storage requirements, 11.14.4

TIMED_OS_STATISTICS parameter, B.1

TNSNAMES DD statement, 3.3

TRACE_DSNAME parameter, 3.4

TRACEFILE_IDENTIFIER parameter, 3.5, B.1

TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, B.1

TRCASST, Oracle Net utility program, 8.4

TSO

profile for application binds, 9.3

symptom dumps, 16.5.4

TYPE parameter, 3.2

U

UGA (User Global Area), 8.6.1

ultra large datafiles, 4.2.5, 4.5.1

UNIT(unitname) keyword, ORA$FPS parameter file, 4.4.3

upgrade

eligibility, 17.2

OSDI changes, 17.5

preparing, 17.3

requirements, 17.1

upgrading the database, 17.4

User Global Area (UGA), 8.6.1

user stack, 15.2.1.3

USER_DUMP_DEST parameter, B.1

USING clause, with TNSNAMES DD statement, 3.3

USS ( z/OS Unix System Services)

customizing a character set (LXINST), D.6

security, 9.5

with network service, 8.2.7

UTL_FILE PL/SQL package, 9.5

UTL_HTTP PL/SQL package, 9.5

V

VOLUME_COUNT(nnn) keyword, ORA$FPS parameter file, 4.4.3

VOLUMES(volser) keyword, ORA$FPS parameter file, 4.4.3

VSAM allocation rounding, 4.2.2

VSAM linear data set (LDS) files, 4.1, 4.5.2

W

wait state, reporting the error, 16.4.2.8

WLM

See Workload Manager

Workload Manager (WLM)

attributes and values for classification, 15.3.4

classification rules, 15.3.4

goal mode, 15.3.4, 15.3.4

overview, 15.3

response time goals, 15.3.4

service class, 15.3.1, 15.3.4

velocity goals, 15.3.4, 15.3.4

workload classification, 15.3.4

z/OS tuning, 15.3

X

XCF (Cross System Communication Facility), 14.3

Z

zero-length parameter, A.7

z/OS Unix System Services (USS)

customizing a character set (LXINST), D.6

normal application bind, 2.4

security, 9.5

with network service, 8.2.7

z/OS Workload Manager

See Workload Manager