Skip Headers

Oracle® Database System Administration Guide
10g Release 1 (10.1) for IBM z/OS (OS/390)
Part No. B13526-01
  Go To Table Of Contents
Contents

Previous  

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, 1.5
SYSOPER and SYSDBA, 9.4
accounting information, 10
address spaces
AS1, the first address space, 1.6
auxiliary address spaces, 1.6
cross-memory, 15.2.1.1
OSDI subsystem startup, 1.2
when created for Oracle products, 1.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, 1.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, 1.3
and bind processing, 1.4
and managed connection bind, 1.5
client address spaces, 9.3
migrating to OSDI, A.7
normal and managed binds, 9.3
architecture, OSDI, 1.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, 1.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, 10.7.1, B.1
auditing database use, 10.7
authorization check
for command processing, 9.2
SYSOPER/SYSDBA, 1.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, 1.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, 2.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, 1.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, 1.3, A.4
ALTER SERVICE, A.7
ALTER SERVICEGROUP, A.6
DEFINE, 1.3, 2.4, A.4
DEFINE SERVICE, 2.4, A.7
DEFINE SERVICEGROUP, 2.4, A.6
DISPLAY, 1.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, 2.6
SHOW, 2.6, A.4
SHOW SERVICE, A.7
SHOW SERVICEGROUP, A.6
START, 1.3, 1.6, 1.6, 1.7, 2.4, 8.3, A.10
STOP, 1.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), 1.6, 8.3
MODIFY (or F), 5.4
REFRESH FPS, 5.4.6
SETSSI ACTIVATE, 1.2
SETSSI ADD, 1.2, 2.5, 2.5
SETSSI DEACTIVATE, 1.2
STOP (P), 1.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, 1.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, 1.3
in the subsystem parameter file, 2.4
supported definition command, A.4
DEFINE SERVICE, OSDI command, 2.4, A.7
DEFINE SERVICEGROUP, OSDI command, 2.4, A.6
defining a service, 1.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, 1.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, 2.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, 2.5
IEFSSREQ macro, 1.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, 2.3
in the subsystem initialization file, 2.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
See Also init.ora parameter file
initialization routine, ORASSINI, 2.5
init.ora parameter file
control files and, 4.1.1
INITORA parameters
See initialization parameters
INSTANCE_NUMBER parameter, B.1
INSTLIB library
contents, 3.10
creation, 3.10
location, 3.10
internal dictionary structures in SYSTEM tablespace, 4.1.2
IPL
initializing subsystems automatically, 2.5
initializing the OSDI subsystem, 2.5
OSDI subsystem initialization, 1.2
required
after updating IEFSSNxx, 2.5
service definition persists, 1.3
starting services via the subsystem parameter file, 2.4

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, 2.5
listen operations, network service, 1.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, 1.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, 2.5
SSP01, 2.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, 1.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, 1.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, 1.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
ORACICS macro, 11.4.10
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, 1.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, 1.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, 1.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, 2.5
OS_AUTHENT_PREFIX initora parameter, 11.4.5
OS_AUTHENT_PREFIX parameter, B.1
OSDI
architecture
connections, 1.4
database service, 1.6
general description, 1.1
network service, 1.7
security, 1.5
services, 1.3
subsystem, 1.2
command
examples to define service group and services, 2.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, 1.3
subsystem is present in the OS/390 system until the next IPL, 1.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, 1.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, 1.5
IBM's z/OS Security Server, 1.5
SAF-compliant security server, 9.3
with network service, 8.2.7
RACROUTE interface, 1.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, 1.5
authorization control, 1.5
controlling access privileges, 9.4
controlling access to system privileges, 9.3
SAF-compliant security server, 9.3
subsystem parameter file, 2.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, 1.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, 1.3
OSDI service defined, 1.3
service group
defined, 1.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, 1.2
SETSSI ADD command, 1.2, 2.5, 2.5, 2.6
SETSSI DEACTIVATE command, 1.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, 2.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, 1.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, 2.5
standby database, 4.7
STANDBY_ARCHIVE_DEST parameter, B.1
START
command, 3.7, 11.13.2
OSDI command
database service, 1.6
defined, A.10
in the subsystem parameter file, 2.4
manually starting auxiliary address spaces, 1.6
Oracle Net network service, 1.7
running a service, 1.3
starting Oracle Net service, 8.3
SUBSYSTEM command, 12.8
started task (STC) address space, 1.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, 1.6, 8.3
defined, A.10
STOP (P) z/OS System command, 1.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, 1.2
functions, 1.4
initialization file example, 2.6
initialization, OSDI, 1.3
OSDI architecture, 1.2
parameter file, 2.3
primary role, 1.3
security, 1.5
subsystem interface (SSI), 1.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, 1.5
SYSPRINT DD statement, 3.3
System Authorization Facility (SAF)
authorization control, 1.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, 2.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, 1.4
security, 9.5
with network service, 8.2.7
z/OS Workload Manager
See Workload Manager