Oracle9i Enterprise Edition System Administration Guide
Release 2 (9.2.0.1.0) for OS/390

Part Number A97313-01
Go To Table Of Contents
Contents

Go to previous page

Index

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


Symbols

&ORAPREFD system symbol, 3-10, 4-3, 4-4, 6-11, 6-12, C-2
&ORASESST system symbol, C-2
&ORASRVN system symbol, 4-3, 4-4, 6-11, C-2

A

abend
error reporting, 17-5
ORAP, 11-16, 11-31, 11-33
SMF records, 9-3
access
controlling access to OSDI services, 8-3
controlling access to OSDI subsystem commands, 8-2
controlling access to system privileges, 8-4
security, 1-7
SYSOPER and SYSDBA, 8-4
accounting information, 9-1
address spaces
AS1, the first address space, 1-8
auxiliary address spaces, 1-7
cross-memory, 16-8
multiple OS/390 address spaces, 1-2
OSDI subsystem startup, 1-3
when created for Oracle products, 1-4
ALTER DATABASE RENAME statement, 6-6
ALTER SERVICE, OSDI command, A-9
ALTER SERVICEGROUP, OSDI command, A-5
ALTER SESSION SQL command, 16-26
ALTER SYSTEM command, 16-36
ALTER, OSDI command, 1-5, A-3
ALTER, SQL statement, 4-8
AM4CAUTH, CICS startup, 11-14
AM4COID, CICS startup, 11-14
AMI-0108 message, on IMS MTO console, 12-31
AMI-0113 message, connection to target Oracle instance, 12-31
AMODE, storage requirements, 16-4
application
and active services, 1-5
and bind processing, 1-6
and managed connection bind, 1-7
client address spaces, 8-3
migrating to OSDI, A-8
normal and managed binds, 8-3
ARCH background process for backup and recovery, 6-3
architecture, OSDI, 1-3
archive log, 4-4
ARCHIVE LOG command, 6-3
ARCHIVELOG mode
backup and recovery, 6-2
operating a database, 4-4
Oracle RDBMS Parameter Considerations, 3-18
AS1
performance, dispatching priority, 16-23
performance, parallel execution, 16-32
SYSPRINT DD statement and alert log, 3-9
the first address space, defined, 1-8
ASO
checklist
for setting up ASO encryption, 10-11
for testing, 10-12
connect client and server, 10-12
encryption, 10-11
reset configuration parameters on server, 10-12
set parameters for client, 10-12
set parameters for server, 10-11
testing, 10-12
auditing database use, 9-12
authorization check
for command processing, 8-2
SYSOPER/SYSDBA, 1-7
AUTOEXTEND clause, 4-4
automatic initialization, setting up, 11-18

B

BACKGROUND_CORE_DUMP parameter, 3-16
BACKGROUND_DUMP_DEST parameter, 3-16
backup and recovery, database
overview, 6-2
with RMAN, 6-6
without RMAN, 6-4
backup, tablespace, 6-4
bind
authorization check, 8-3
defined, 1-6
blocksize, logical, 3-20
BPXPRMxx member, 10-7
buffer cache, adjusting for optimal performance, 16-15

C

catalog
retention, with tape backup, 6-13
caution
SETSSI ADD, OS/390 System command, 2-6
CEDA DEFINE TRANSACTION command, 11-17
CFUTIL (convert file utility)
CVTARCLOG, 18-39
CVTFORMPM, 18-37
CVTFOROSDI, 18-37
described, 18-35
parameter syntax for control files, 18-37
VSAM LDS, 18-36
checklist
configuring Oracle Access Manager for CICS, 11-4
configuring Oracle Access Manager for IMS TM, 12-14
setting up ASO, 10-11
testing ASO, 10-12
CICADPX load module, 11-14
CICS
Attach installation
copying LIBCLNTS, 11-14
copying ORACICSC, 11-14
defining transactions, 11-17
generating ORACSTUB stub, 11-16
setting up automatic initialization, 11-18
defining MESG library to, 11-13
DFHRPL library, 11-13
Oracle Access Manager for CICS
MPM restrictions, 11-2
profile for managed binds, 8-4
recovery procedures, 11-23
tables, 11-17
transaction
IAP, 11-17
ORAC, 11-17
CICS SYNCPOINT
choosing, 11-32
Oracle Access Manager for CICS, 11-24
CICS syncpoint, at startup, 11-14
client
special meaning defined, 1-5
command
ALTER SYSTEM, 16-36
COMMIT, 11-23
DISPLAY SUBSYSTEM, 12-32
IDCAMS
DELETE, 8-7
nlb2mvs, ".nlb" files for LXINST, D-11
OS/390 System
CANCEL, 6-7
DISPLAY SESSION, 5-6
DUMP SESSION, 5-6
MODIFY (F), 1-8, 10-9
MODIFY (or F), 5-5
REFRESH FPS, 5-7
SETSSI ACTIVATE, 1-4
SETSSI ADD, 1-4, 2-5, 2-6
SETSSI DEACTIVATE, 1-4
STOP (P), 1-8, 10-10
OSDI
table of command verbs, 8-2
ALTER, 1-5, A-3
ALTER SERVICE, A-9
ALTER SERVICEGROUP, A-5
DEFINE, 1-4, 2-4, A-3
DEFINE SERVICE, 2-4, 3-34, A-6
DEFINE SERVICEGROUP, 2-4, A-4
DISPLAY, 1-5, 10-10, A-13
DISPLAY LONG, 10-10
DISPLAY SESSION, 16-32
DRAIN, 10-10, A-13
keyword abbreviations, A-15
list of commands, A-11
RESUME, 10-10, A-14
SETSSI ADD, 2-6
SHOW, 2-6, A-3
SHOW SERVICE, A-11
SHOW SERVICEGROUP, A-5
START, 1-5, 1-7, 1-8, 2-4, 3-34, 10-9, A-12
STOP, 1-8, 10-10, A-14
RMAN ALLOCATE CHANNEL, 6-7
ROLLBACK, 11-23
SQL
ALTER SESSION, 16-26
START, 3-21
START SUBSYSTEM, 12-34
STARTUP MOUNT, 6-6
SYNCPOINT, 11-23
COMMIT
choosing for CICS, 11-32
command, 11-23
COMMIT_POINT_STRENGTH parameter, B-2
COMMIT/ROLLBACK
Oracle Access Manager for CICS, 11-24
COMPATIBLE parameter, 3-34
control file, 4-2
CONTROL_FILES parameter, 3-16
controlling operations
Intelligent Agent, 13-4
CREATE DATABASE statement
CONNECT command and, 3-22
supplies data set names of log files, 4-4
CREATE SQL statement, 4-8
Cross System Communication Facility (XCF), 14-5
cross-memory address spaces, 16-8
CSA storage, 16-7, 16-43
cursor close behavior, 12-10
cursor parsing, defined, 16-17
CURSOR_SHARING parameter, 16-13
CVTARCLOG option, 18-39
CVTFORMPM option, 18-37
CVTFOROSDI option, 18-37

D

Data Gatherer for OS/390, 13-1
, 6-18
data structures
ORACA, 15-2
SQLCA, 15-2
SQLDA, 15-2
database
accounting information, 9-1
auditing use, 9-12
backup and recovery, 6-1
configuring, 3-1
file extension, 4-4
file size limit, B-2
initial, 3-1
limits, B-2
links, defined for security, 8-7
migration and upgrade, 18-1
region parameters, defined, 3-10
service, OSDI architecture, 1-7
starting and stopping, 5-2
DATAFILE parameter, B-3
DB_BLOCK_SIZE parameter, 3-16, B-2
DB_CACHE_SIZE parameter, 16-14
DB_CREATE_FILE_DEST parameter, 3-17
DB_CREATE_ONLINE_LOG_DEST_n parameter, 3-17
DB_FILE_MULTIBLOCK_READ_COUNT parameter, B-2
DB_FILE_NAME_CONVERT parameter, 3-17
DB_nK_CACHE_SIZE parameter, 16-14
DBAL file group, 6-3
DBV (Database Verification Utility), 7-7
DCB BUFNO JCL parameter, 16-25
DD statement
NET8LOG, 10-6
ORA$ENV, 3-6
ORA$FPS, 3-7
ORA$LIB, 3-7
ORAPASSW, 3-8
SNAPCF, 3-8
SQLBSQ, 3-8
SQLNET, 3-8
SQLNETG, 3-8
STEPLIB, 3-8, 10-6
SYSPRINT, 3-9
TNSNAMES, 3-9
default record number for SMF, 9-2
DEFINE CLUSTER commands, 4-2
DEFINE command
defining services to the subsystem, 1-4
in the subsystem parameter file, 2-4
supported definition command, A-3
DEFINE SERVICE, OSDI command, 2-4, A-6
DEFINE SERVICEGROUP, OSDI command, 2-4, A-4
defining a service, 1-5
definition commands, A-3
DFHRPL library, 11-13
DFSMSrmm, tape management software, 6-13
DFSORT utility, performance tuning, 16-26
DISPLAY LONG, OSDI command, 10-10
DISPLAY SESSION, command, 16-32
DISPLAY SESSION, OS/390 command, 5-6
DISPLAY SUBSYSTEM command, 12-32
DISPLAY, OSDI command
defined, A-13
display the state of a service, 1-5
with CICS, 11-27
with Oracle Net service, 10-10
distributed option, considerations, 12-6
documentation
errors, 17-4
product-specific, xiv
DRAIN, OSDI command
defined, A-13
preventing network connections, 10-10
DSN_PREFIX_DB parameter, 3-10
DUMP command (MVS), 17-9
DUMP keyword, Oracle Net, 10-5
DUMP SESSION, OS/390 command, 5-6

E

ECSA storage
Oracle Access Manager for IMS TM, 12-3, 16-43
EDM (External Data Mover), 6-7
empty parameter, A-7
Enabling CICS Attach adapter, 11-17
ENCLAVE keyword, Oracle Net, 10-5
CALL option and WLM, 16-26
SESS option and WLM, 16-26
enclave SRB, 18-4
network client requests, 16-3
Oracle Net architecture, 10-2
encryption, ASO, 10-11
entry sequenced data set (ESDS) files, 18-36
error
12660, 10-11
diagnosis
categories, 17-4
investigating a potential Oracle server error, 17-3
IEC130I, 3-7
message traffic to the console, 10-9
messages for network region JCL, 10-6
ORA-12660, 10-12
ORA-911, D-7
processing, Oracle Access Manager for IMS TM, 12-8
reporting
abend, 17-5
documentation, 17-2, 17-4
error categories, 17-4
GTF, 17-10
incorrect output errors, 17-5
Oracle error messages, 17-5
Oracle wait state, 17-7
program loop, 17-6
required documentation, 17-2
sending tapes, 17-2
SLIP, 17-10
system dump, 17-9
system dump data sets, 17-9
tape return, 17-2
TSO symptom dumps, 17-10
wait state, 17-7
written documentation, 17-2
ESAF, 12-2
ESQA storage, 16-9
EXEC SQL COMMIT statement, 11-23
EXEC SQL ROLLBACK statement, 11-23
Extended Pageable Link Pack Area (EPLPA), storage requirements, 16-4
extending database files, 4-4
External Data Mover (EDM), 6-7
external routines
configuring generic listener, 10-13
generic listener support, 10-2
modifying tnsnames.ora, 3-9
External Subsystem Attachment Facility, 12-2
external subsystems
IMS, 12-32
Oracle Access Manager for IMS TM, 12-32
external table feature, Oracle, 8-7

F

failure after initial connection, 12-11
FAST_START_IO_TARGET parameter, 16-16
FAST_START_MTTR_TARGET parameter, 16-16
file
entry sequenced data set (ESDS), 18-36
linear data set (LDS), 4-2, 4-15
OSDI subsystem parameter file, 2-2
size limit, database, B-2
valid file group names for an Oracle server, 4-9
FNA, 7-2
FORCE privileges for recovery processing, 11-15
FPS
ORA$FPS DD statement, 3-7
REFRESH FPS, OS/390 command, 5-7
sidFPS PARMLIB library member, 3-33

G

generic listener
architecture, 10-13
configuration steps, 10-14
for external routines, 10-13
for shared servers, 10-13
overview, 10-2
starting, 10-17
GETHOSTBYNAME API, Oracle Net IBM TCP/IP HPNS, 10-7
granting access for consoles and users, 8-2
GTF (OS/390 Generalized Trace Facility)
as a diagnostic tool, 17-10
GTF keyword, Oracle Net, 10-5

H

hard parse, two kinds of parse calls, 16-17
HASH_AREA_SIZE parameter, 16-7
high-level data set name qualifier, xv
hot backup, 6-4
HPNS keyword, Oracle Net, 10-5

I

IAP transaction, 11-17
IBM DFSMSdss, database backup and recovery, 6-4
IBM Language Environment (LE) interface, 11-2, 16-7
IBM LE/370 runtime library
database region JCL, 3-8
IDCAMS DELETE command, 8-7
IDCAMS utility
creating archive logs, 6-3
for security, 8-6
with Oracle database files, 4-2
IEC130I error, 3-7
IEFSSNxx member, 2-5
IEFSSREQ macro, 1-6
IMS
commands
DISPLAY SUBSYSTEM, 12-32
START SUBSYSTEM, 12-34
connection failure, 12-34
control region, 12-4, 12-32
dependent region, 12-4, 12-33
ESAF, 12-2
external subsystems, 12-32
integration with Oracle Access Manager for IMS TM, 12-2
Language Interface Token (LIT), 12-4
LTERM, 12-7
Master Terminal Operator, 12-33
PROCLIB, 12-4
profile for managed binds, 8-4
recovery, 12-34
recovery considerations, 12-9
REO, 12-8
RESLIB, 12-3
SSM member, 12-4
INCLUDE files, 15-2
incorrect output errors, 17-5
INIT record
example, 2-4
in the subsystem initialization file, 2-3
INIT_ADR_SPACES parameter
configuring a database service, 3-30
database region parameters, 3-10
performance tuning, 16-8
INIT_SESSIONS parameter, 3-11
INIT_STACK_SIZE
OSDI parameter
performance tuning, 16-7, 16-10
parameter
configuring a database service, 3-30
database region parameters, 3-11
initial connection failure, 12-11
initialization parameters, 3-15, B-2
See Also init.ora parameter file
initialization routine, ORASSINI, 2-5
init.ora parameter file
configuring for shared servers, 10-14
control files and, 4-3
migration and upgrade, 18-5, 18-12
optimizing Oracle performance, 16-13
INITORA parameters
See initialization parameters
Intelligent Agent, 13-1
internal dictionary structures in SYSTEM tablespace, 4-3
IPL
initializing subsystems automatically, 2-5
initializing the OSDI subsystem, 2-5
OSDI subsystem initialization, 1-3
reduced need, 1-3
required
after updating IEFSSNxx, 2-5
service definition persists, 1-5
starting services via the subsystem parameter file, 2-4

J

JAVA_POOL_SIZE parameter, 16-16
JAVA_STACK_SIZE parameter, 3-11
JCL, network region, 10-5
job
ORDJA01, 3-32
ORPIJG00, 2-5
sidJB00, 3-33
sidJC00, 3-33
sidJD00, 3-34
sidJD01, 3-35
sidJE00, 3-35
sidJF00, 3-35
sidJH00, 3-35
JOBNAME parameter, 3-5
, 8-7

K

keyword abbreviations, OSDI command, A-15

L

Language Environment runtime library (LE)
Oracle Net, 10-7
Language Interface Token, 12-4
LDAP.ORA file, sample, 10-9
LE (IBM Language Environment interface)
CICS transaction, 11-2
Oracle address spaces, 16-7
the PROCESSES parameter, 16-17
LIBCLNTS load module
copying to CICS libraries, 11-14
LPA considerations, 16-5
limits, database, B-2
linear data set (LDS) files, 4-2, 4-15
linklist library, initializing the subsystem, 2-5
listen operations, network service, 1-9
listener
generic, See generic listener
OSDI, See OSDI listener
listener.ora file
creating for external routines, 10-16
modifying for external routines, 10-16
modifying for shared servers, 10-17
LIT
AMILI macro, 12-15
Language Interface Token, 12-4
LOCK_SGA parameter, 3-18
log file group, 4-4
log files, redo, 4-3, B-2
LOG_ARCHIVE_ parameter, 3-18
LOG_ARCHIVE_DEST_n parameter, 3-18
LOG_ARCHIVE_START=TRUE, database backup and recovery, 6-3
LOG_BUFFER parameter, B-2
LOG_CHECKPOINT_ INTERVAL parameter, 16-16
LOG_FILE_NAME_CONVERT parameter, 3-17
LOGFILE parameter, B-3
logical blocksize, 3-20
logon exit
functions, 8-11
R15 return code, 8-11
LOGON_AUTH parameter, 3-11, 8-8
LPA storage, 16-7
LXEGEN, NLS calendar utility, D-12
LXINST, NLS customized character sets, D-10

M

MACRO API interface, with Oracle Net, 10-7
macro, IEFSSREQ, 1-6
MAX_DUMP_FILE_SIZE parameter, 3-19
MAX_SESSION_MEM parameter, 16-11
database region parameters, 3-12
MAX_SESSIONS parameter, 16-11, 16-16
configuring a database service, 3-30
database region parameters, 3-13
MAXAS parameter
configuring a database service, 3-30
database region parameters, 3-11
database service definition, 3-4
performance tuning, 16-8
MAXDATAFILES parameter, B-3
MAXFILEPROC parameter, 10-7
MAXINSTANCES parameter, B-3
MAXLOGFILES parameter, B-3
MAXLOGHISTORY parameter, B-3
MAXLOGMEMBERS parameter, B-3
MAXSOCKETS parameter, 10-7
Media Manager, I/O operations, 16-20
member
BPXPRMxx, 10-7
IEFSSNxx, 2-5
ORACAC, 15-2
ORACACOB, 15-2
ORACAFOR, 15-2
SQLCAC, 15-2
SQLCACOB, 15-2
SQLCAFOR, 15-2
SQLDAC, 15-2
SSP01, 2-5
MESG library, 11-13
message
AMI-0108, IMS MTO console, 12-31
AMI-0113, connection to target Oracle instance, 12-31
IEC130I, 3-7
MIR0110W, security fault, 8-7
MIG (migrate) utility, 18-22, 18-23, 18-24, 18-26, 18-29
migration and upgrade
CFUTIL reference, 18-35
coexistence and compatibility, 18-19
from MPM/TNS to OSDI, 18-8
migration vs. upgrade, 18-22
MPM/TNS vs. OSDI, 18-3
OSDI changes, 18-7
overview, 18-2
MIR0110W message, security fault, 8-7
mode
ARCHIVELOG, 6-2
NOARCHIVELOG, 6-2
MODIFY (F), OS/390 command
communicating with a running Oracle Net service, 10-9
operator interaction with a running database service, 1-8, 5-5
MPM/TNS, migrating to OSDI from, 18-8
MVS Workload Manager
See Workload Manager

N

National Language Support
calendar utility, D-12
character sets, D-4
client-side, D-8
customized character sets, D-10
default character set changed, D-6
message availability, D-10
server-side, D-4
supported languages, D-2
National Language Support (NLS), D-1
Net service
See OSDI listener
NET8LOG DD statement, 10-6
Network Information Vector (NIV)
security, 9-8
network service, OSDI architecture, 1-8
NIV
See Network Information Vector
nlb2mvs command, ".nlb" files for LXINST, D-11
NLS
character set support, D-4
client-side, D-8
data objects, ORA$LIB DD statement, 3-7
default character set changed, D-6
message availability, D-10
server-side, D-4
supported languages, D-2
NLS (National Language Support), D-1
NLS_LANG environment variable, D-4
NLS_LANGUAGE parameter, B-2
NLS_TERRITORY parameter, B-2
NOARCHIVELOG mode, 6-2
NOMOUNT option, 3-23

O

OEM Intelligent Agent and Data Gatherer for OS/390, 13-1
Offline Database Verification Utility (DBV) on OS/390, 7-7
OMF
See Oracle Managed Files
operating states of services, 1-5
operator initiated dumps, 17-9
option
CVTARCLOG, 18-39
CVTFORMPM, 18-37
CVTFOROSDI, 18-37
OR@INST panel, 3-28
OR@PRIM panel, 3-28
ORA$ENV DD statement, 3-6
ORA$FPS DD statement
database region JCL, 3-7
file management parameters, 4-8
REFRESH FPS, 5-7
ORA$FPS parameter file, 6-3
ORA$LIB
DD statement, database region JCL, 3-7
defined, 7-3
ORA@ENV DD statement, D-4
ORA-12660 error, 10-12
ORA-911 error, D-7
ORAC transaction, 11-17
ORACA data structure, 15-2
ORACAC member, 15-2
ORACACOB member, 15-2
ORACAFOR member, 15-2
ORACICN load module, 11-22
ORACICS load module, 11-14, 11-22
ORACICS macro, 11-18
ORACICSC load module, 11-14
Oracle Access Manager for CICS
adapter storage requirements, 16-42
applications, 11-2
AUTH parameter, 16-40
base code storage requirements, 16-42
CICS SYNCPOINT, 11-24
commands
DISPLAY, 11-27
START, 11-31
STOP, 11-33
syntax, 11-27
usage, 11-27
COMMIT/ROLLBACK, 11-24
configuration checklist, 11-4
connected thread storage requirements, 16-43
defining MESG library to, 11-13
MPM restrictions, 11-2
multiple versions coexisting, 11-22
performance, 16-38
recovery procedures, 11-23
restarting, 11-25
shutdown with force, 11-26
SMF recording, 9-3
subtask sharing, 16-39
thread authorization, 16-40
thread pool storage requirements, 16-42
thread protection, 16-41
thread sharing, 16-39
transaction ID, 11-27
Oracle Access Manager for IMS TM
31-bit addressing, 12-3
AMIENV macro, 12-27
AMIRT macro, 12-19
AMISESS macro, 12-25
AMITRANS macro, 12-23
authentication, 12-7
configuration
AMILS, 12-3
checklist, 12-14
IMS RESLIB, 12-3
overview, 12-3
steps, 12-14
control region, 12-32
CREATE SESSION, 12-17
CSA storage, 16-43
define an MVS subsystem, 12-15
dependent region, 12-3, 12-4, 12-33
ECSA storage, 16-43
environment variables, 12-12
error processing, 12-8
ESCA storage, 12-3
External Subsystem Attachment Facility (ESAF), 12-2
external subsystems, 12-32
failure, 12-34
FORCE ANY TRANSACTION, 12-17
IMS
connection failure, 12-34
control region, 12-3, 12-4, 12-32, 12-33
dependent region, 12-3, 12-4
DISPLAY SUBSYSTEM command, 12-32
ESAF, 12-2
integration with, 12-2
Language Interface Token (LIT), 12-4
LTERM, 12-7
Master Terminal Operator, 12-33
PROCLIB, 12-4
recovery, 12-34
recovery considerations, 12-9
REO, 12-8
RESLIB, 12-4
SSM member, 12-4
in-doubt processing, 12-34
integration with IMS, 12-2
linking stub, AMILS, 12-3
LIT, AMILI macro, 12-15
Master Terminal Operator, 12-33
object privileges
SELECT ON SYS.PENDING_SESSIONS$, 12-17
SELECT ON SYS.PENDING_TRANS$, 12-17
parent database id, 12-34
performance, 16-43
profiles, IDLE_TIME, 12-17
recovery, 12-34
recovery considerations, 12-9
control region, 12-9
ESAF, 12-9
REO character values, 12-8
RTT, 12-4
AMIENV macro, 12-18, 12-27
AMIRT macro, 12-18, 12-19
AMISESS macro, 12-18, 12-25
AMITRANS macro, 12-18, 12-22
sample SQL statements, 12-18
security, 12-6
SELECT ON SYS.PENDING_SESSIONS$, 12-17
SELECT ON SYS.PENDING_TRANS$, 12-17
session authentication, EXTERNAL, 12-7
SSM member, 12-4
starting and stopping, 12-33
statements
ALTER USER, 12-8
CREATE USER, 12-8
GRANT SELECT, 12-18
NO_LIMIT, 12-18
storage requirements
adapter, 16-44
base code, 16-43
system authentication password, 12-7
system privileges
CREATE SESSION, 12-17
FORCE ANY TRANSACTION, 12-17
Oracle Access Manager, products, with multiple database connections, 1-8
Oracle Advanced Security Option
See ASO
Oracle Enterprise Manager Intelligent Agent and Data Gatherer for OS/390, 13-1
Oracle external table feature, 8-7
Oracle listener
See Generic Listener
Oracle Managed Files (OMF), 4-2, 4-15
Oracle Net
configuring generic listener, 10-14
configuring OSDI listener, 10-4
generic listener, 10-2
Network Information Vector (NIV)
security, 9-8
OSDI listener, 10-2
overview, 10-2
starting network service, 1-8
Oracle Password Utility (ORAPWD) on OS/390, 7-6
Oracle precompilers, recovery under Oracle Access Manager for CICS, 11-23
Oracle Programmatic Interfaces
See Oracle Programmer
Oracle Programmer
APF authorization, 15-4
ASID considerations, 15-2
break processing, 15-3
cross memory mode, 15-4
description, 15-1
INCLUDE files, 15-2
NOSTAX keyword, 15-3
PSW protect key, 15-3
PSW state, 15-3
task considerations, 15-2
use of ATTN key, 15-3
Oracle startup request, issuing, 1-8
Oracle subsystem
accounting information, 9-1
error reporting, 17-5
resource usage, 9-1
statistics, 9-1
Oracle Support Services
documentation requirements, 17-2
sending tapes, 17-2
tape return, 17-2
working with them, 17-2
Oracle System Global Area (SGA), 16-9
Oracle unavailable situations, 12-10
Oracle user record type, 9-2
ORACLE_HOME environment variable, 3-7
ORACLE_TRACE_ parameter, 3-19
Data Guard, 6-18
JVM, 8-7
Real Application Clusters, 14-1
ORACSTUB stub, 11-3, 11-16, 11-22
ORAEDM program, 6-7
ORAFMT program for SMF, 9-4, 9-10
ORAFMTCL sample JCL, 9-10
ORAFMTGO sample JCL, 9-10
ORAH transaction, 11-17
ORAN.ORAV, xv
ORAP application abend, 11-16, 11-31, 11-33
ORAPASSW DD statement, 3-8
ORAPWD
defined, 7-6
utility, with ORAPASSW DD statement, 3-8
ORASSI subsystem code module, 16-5
ORASSINI initialization routine, 2-5
ORDBIP10 panel, 3-29, 3-31, 3-33
ORDBIP15 panel, 3-30
ORDBIP20 panel, 3-30
ORDBIP25 panel, 3-30
ORDBIP30 panel, 3-30
ORDBIP35 panel, 3-31
ORDBIP40 panel, 3-31
ORDBIP50 panel, 3-32
ORDBIP90 panel, 3-32
ORDJA01 job, 3-32
ORNEWDB panel, 3-29
ORPIJG00 job, 2-5
OS_AUTHENT_PREFIX initora parameter, 11-14
OS/390
CANCEL command, 6-7
documentation, xiv
OS/390 Unix System Services (USS)
CFUTIL, 18-37
customizing a character set (LXINST), D-11
external routines, 10-13
normal application bind, 1-6
OEM Intelligent Agent and Data Gatherer, 13-2
security, 8-7
Server Manager on OS/390, 7-4
with network service, 10-7
OS/390 Workload Manager
See Workload Manager
OSDI
architecture
connections, 1-5
database service, 1-7
general description, 1-3
network service, 1-8
security, 1-6
services, 1-4
subsystem, 1-3
command
examples to define service group and services, 2-6
keyword abbreviations, A-15
SHUTDOWN, 6-2
DEFINE SERVICE command, 3-34
listener, 10-2
MESG data set, ORA$LIB DD statement, 3-7
migration to, 18-8
performance tuning, 16-7
START command, 3-34
subsystem initialization, 1-5
subsystem is present in the OS/390 system until the next IPL, 1-4
OSDI listener
architecture, 10-2
ASO encryption, 10-11
client-server access, 10-8
configuring, 10-4
filenames, 10-3
initialization parameters, 10-4
JCL procedure, 10-5
operating, 10-9
TCP/IP, 10-7
trace files, 10-10

P

panel
OR@INST, 3-28
OR@PRIM, 3-28
ORDBIP10, 3-29, 3-31, 3-33
ORDBIP15, 3-30
ORDBIP20, 3-30
ORDBIP25, 3-30
ORDBIP30, 3-30
ORDBIP35, 3-31
ORDBIP40, 3-31
ORDBIP50, 3-32
ORDBIP90, 3-32
ORNEWDB, 3-29
parameter
ASO, setting for server, 10-11
BACKGROUND_CORE_DUMP, 3-16
BACKGROUND_DUMP_DEST, 3-16
COMMIT_POINT_STRENGTH, B-2
COMPATIBLE, 3-34
configuration, resetting on server, 10-12
CONTROL_FILES, 3-16
CURSOR_SHARING, 16-13
database region parameter
DSN_PREFIX_DB, 3-10
INIT_ADR_SPACES, 3-10, 3-30
INIT_SESSIONS, 3-11
INIT_STACK_SIZE, 3-11, 3-30
JAVA_STACK_SIZE, 3-11
LOGON_AUTH, 3-11, 8-8
MAX_SESSION_MEM, 3-12
MAX_SESSIONS, 3-13, 3-30
MAXAS, 3-30
REGION_MEM_RESERVE, 3-13
SERVER_LOADMOD, 3-14
SMF_STAT_RECNO, 3-14
TRACE_DSNAME, 3-14
DATAFILE, B-3
DB_BLOCK_SIZE, 3-16, B-2
DB_CACHE_SIZE, 16-14
DB_CREATE_FILE_DEST, 3-17
DB_CREATE_ONLINE_LOG_DEST_n, 3-17
DB_FILE_MULTIBLOCK_READ_COUNT, B-2
DB_FILE_NAME_CONVERT, 3-17
DB_nK_CACHE_SIZE, 16-14
DCB BUFNO JCL, 16-25
encryption, 10-11, 10-12
FAST_START_IO_TARGET, 16-16
FAST_START_MTTR_TARGET, 16-16
HASH_AREA_SIZE, 16-7
INIT_ADR_SPACES, 16-8
INIT_STACK_SIZE, 16-7, 16-10
initialization, 3-15, B-2
init.ora file, 4-3, 10-14, 16-13, 18-5
JAVA_POOL_SIZE, 16-16
JOBNAME, 3-5
LOCK_SGA, 3-18
LOG_ARCHIVE_, 3-18
LOG_ARCHIVE_DEST_n, 3-18
LOG_BUFFER, B-2
LOG_CHECKPOINT_ INTERVAL, 16-16
LOG_FILE_NAME_CONVERT, 3-17
LOGFILE, B-3
MAX_DUMP_FILE_SIZE, 3-19
MAX_SESSION_MEM, 16-11
MAX_SESSIONS, 16-11, 16-16
MAXAS
database service parameter, 3-4
performance tuning, 16-8
MAXDATAFILES, B-3
MAXFILEPROC, 10-7
MAXINSTANCES, B-3
MAXLOGFILES, B-3
MAXLOGHISTORY, B-3
MAXLOGMEMBERS, B-3
MAXSOCKETS, 10-7
NLS_LANGUAGE, B-2
NLS_TERRITORY, B-2
ORACLE_TRACE_, 3-19
OS_AUTHENT_PREFIX initora, 11-14
PARM, 3-6
PROCESS, B-2
PROCESSES, 16-16
REGION
database region JCL, 3-6
network region JCL, 10-6
REGION=0M, 16-13
REGION_MEM_RESERVE, 16-12
SESSION_CACHED_CURSORS, 16-17
SESSIONS, 16-18
setting, for client, 10-12
SGA_MAX_SIZE, 16-9
SHADOW_CORE_DUMP, 3-19
SHARED_POOL_SIZE, 16-18
SID, 1-9
SMF_STAT_RECNO parameter, 9-2
SORT_AREA_RETAINED_SIZE, 16-19
SORT_AREA_SIZE, 16-7, 16-19, 16-26, B-2
SPFILE
defined, 3-19
STARTUP statement, 3-16
SQL language, B-3
STANDBY_ARCHIVE_DEST, 3-19
storage, B-4
TRANSACTIONS, 16-20
TRANSACTIONS_PER_ROLLBACK_SEGMENT, B-2
TYPE, 3-4
USER_DUMP_DEST, 3-20
zero-length (empty), A-7
PARM parameter, 3-6
PARM string, OSDI listener, 10-4
performance
CICS subtask sharing, 16-39
CICS thread sharing, 16-39
Oracle Access Manager for CICS
AUTH parameter, 16-40
PROTECT parameter, 16-41
PFILE
in CREATE SPFILE statement, 3-19
in STARTUP statement, 3-15
PMON process, 16-17
PORT keyword, Oracle Net, 10-5
PROC parameter of DEFINE SERVICE, 5-2
PROCESS parameter, B-2
PROCESSES parameter, 16-16
product-specific documentation, xiv
PROFILE WTPMSG, 17-10
program loop, reporting the error, 17-6
program, ORAEDM, 6-7
programmatic interfaces
See Oracle Programmer

Q

qualifiers, data set name, xv

R

R15 return code from logon exit, 8-11
RACF
authorization control, 1-7
IBM's OS/390 Security Server, 1-6
SAF-compliant security server, 8-3
with network service, 10-7
RACROUTE interface, 1-6
READ authorization, controlling access to services, 8-3
, 14-1
recording SMF information, 9-2
recover.bsq script, needed by RMAN, 7-4
recovery
catalog, 6-6
CICS SYNCPOINT, 11-32
COMMIT/ROLLBACK, 11-32
defined (database backup and recovery), 6-2
manual, Access Manager for CICS, 11-26
Recovery Manager (RMAN)
backup and recovery with, 6-6
backup and recovery without, 6-4
invoking, 7-4
on OS/390, 7-4
redo log files, 4-3, B-2
REFRESH FPS, OS/390 command, 5-7
region error option (REO), 12-8
REGION parameter, 3-6, 10-6
REGION=0M keyword parameter, 16-12
REGION_MEM_RESERVE parameter, 16-12
database region parameters, 3-13
REO, character values, 12-8
Resource Translation Table, 12-4
resource usage, 9-1
restart, Oracle Access Manager for CICS, 11-25
RESUME command
defined, A-14
Oracle Net, 10-10
retention policy, with tape backup, 6-13
RMAN ALLOCATE CHANNEL command, 6-7
RMODE, storage requirements, 16-4
ROLLBACK command, 11-23
RTT
macro parameters, 12-18
resource translation table, 12-4

S

SAF
access provided by RACROUTE interface, 1-6
authorization control, 1-7
controlling access privileges, 8-5
controlling access to system privileges, 8-4
SAF-compliant security server, 8-3
subsystem parameter file, 2-3
samples
Oracle Access Manager for IMS TM
SQL statements, 12-18
SBT_TAPE, RMAN channel type NOT supported on OS/390, 6-7
script,TCL, 13-5
second-level data set name qualifier, xv
security
Oracle Access Manager for IMS TM, 12-6
OSDI architecture, 1-6
SELECT privileges for recovery processing, 11-15
sending tapes to Oracle, 17-2
Server Manager, 7-4
Server Manager (SVRMGRL), 7-2
SERVER_LOADMOD parameter, 3-14
service
controlling access to OSDI services, 8-3
definition commands, A-6
where to place them, 1-5
OSDI service defined, 1-4
service group
defined, 1-3
definition commands, A-4
service name, for a database, 3-3
service class
See Workload Manager
service name, OSDI database, 1-5
SESSION_CACHED_CURSORS parameter, 16-17
SESSIONS parameter, 16-18
SETSSI ACTIVATE command, 1-4
SETSSI ADD command, 1-4, 2-5, 2-6
SETSSI DEACTIVATE command, 1-4
SGA (System Global Area), Oracle, 16-9
SGA_MAX_SIZE parameter, 16-9
SHADOW_CORE_DUMP parameter, 3-19
shared servers
configuring for, 3-22
configuring generic listener, 10-13
generic listener support, 10-2
modifying tnsnames.ora, 3-9
SHARED_POOL_SIZE parameter, 16-18
SHOW SERVICE, OSDI command, A-11
SHOW SERVICEGROUP, OSDI command, A-5
SHOW, OSDI command, 2-6, A-3
SHUTDOWN ABORT command, not recommended, 5-5
SHUTDOWN command, 6-2
shutdown, Oracle Access Manager for CICS, 11-26
SID
defined
database service name, 3-3
parameter
specifying a target OS/390 server, 1-9
sidJB00 job, 3-33
sidJC00 job, 3-33
sidJD00 job, 3-34
sidJD01 job, 3-35
sidJE00 job, 3-35
sidJF00 job, 3-35
sidJH00 job, 3-35
SITEINFO file, 10-7
SLIP, 17-10
SMF
abnormal terminations, 9-3
activating, 9-2
default record number, 9-2
interpreting records, 9-4
ORAFMT program, 9-4, 9-10, 9-11
record, with NIV, 9-8
recording
starting, 9-2, 9-12
stopping, 9-3
records, 9-1, 9-4
sample formatting program, 9-10
types of users, 9-2
user-defined data section, 9-10
when records are written, 9-3
with Oracle Access Manager for CICS, 9-3
SMF_STAT_RECNO parameter
database region parameters, 3-14
SMF_STAT_RECNO, OSDI service parameter, 9-2
SMFPRMxx member, 9-2
SNAPCF DD statement, 3-8
soft parse, two kinds of parse calls, 16-17
SORT_AREA_RETAINED_SIZE parameter, 16-19
SORT_AREA_SIZE parameter, 16-7, 16-19, 16-26, B-2
SPFILE parameter
defined, 3-19
STARTUP statement, 3-16
SQA storage, 16-7, 16-8, 16-9, 16-10, 16-20
SQL ALTER TABLESPACE statement, 6-4
SQL parameters, B-3
SQL statement
ALTER, 4-8
CREATE, 4-8
EXEC SQL COMMIT, 11-23
EXEC SQL ROLLBACK, 11-23
SQLBSQ DD statement, 3-8
SQLCA data structure, 15-2
SQLCAC member, 15-2
SQLCACOB member, 15-2
SQLCAFOR member, 15-2
SQLDA data structure, 15-2
SQLDAC member, 15-2
SQLNET DD statement, 3-8
SQLNETLG DD statement, 3-8
SQLPLUS module, LPA considerations, 16-6
SRB (service request block)
enhanced client workload management, 1-3
Oracle Net architecture, 10-2
preemptable enclave SRB, 16-3, 18-4
preemptable SRB, 16-3
SSP01 member, 2-5
standby database, 6-18
STANDBY_ARCHIVE_DEST parameter, 3-19
START
command, 3-21, 11-31
OSDI command
database service, 1-7
defined, A-12
in the subsystem parameter file, 2-4
manually starting auxiliary address spaces, 1-7
Oracle Net network service, 1-8
running a service, 1-5
starting Oracle Net service, 10-9
SUBSYSTEM command, 12-34
started task (STC) address space, 1-7
starting and stopping the database, 5-2
STARTUP command, 3-15, 3-22
STARTUP FORCE command, not recommended, 5-5
STARTUP MOUNT command, 6-6
statement
ALTER USER, 12-8
CREATE USER, 12-8
GRANT SELECT, 12-18
NO_LIMIT, 12-18
SQL, 12-18
ALTER, 4-8
CREATE, 4-8
static-fixed memory allocations, defined, 16-6
STEPLIB DD statement
database region JCL, 3-8
defined, 7-3
Oracle Net region JCL, 10-6
STOP
command, 11-33
OSDI command, 1-8, 10-10
defined, A-14
STOP (P) OS/390 System command, 1-8, 10-10
storage
measurements, xvi
parameters, B-4
stored PL/SQL procedures in SYSTEM tablespace, 4-3
subsystem, OSDI
address space, 1-3
functions, 1-5
initialization file example, 2-6
initialization, OSDI, 1-5
OSDI architecture, 1-3
parameter file, 2-2
primary role, 1-4
security, 1-6
subsystem interface (SSI), 1-4
SYNCPOINT command, 11-23
SYNCSORT utility, performance tuning, 16-26
SYS1.DUMP data set, 17-9
SYS1.SCEERUN, LE/370 runtime library name, 3-8
SYSDBA, privileges, 8-4
SYSERR, defined, 7-3
SYSIN, defined, 7-3
SYSOPER, privileges, 8-4
SYSOPER/SYSDBA authorization check, 1-7
SYSOUT, defined, 7-3
SYSPRINT DD statement, 3-9
System Authorization Facility (SAF)
authorization control, 1-7
controlling access privileges, 8-5
controlling access to system privileges, 8-4
SAF-compliant security server, 8-3
system crashes, SMF, 9-3
system dump
data sets, 17-9
failure documentation, 17-9
System Global Area (SGA), Oracle, 16-9
system log, example, 2-6
system privileges
SYSDBA, 8-4
SYSOPER, 8-4
system symbols
&ORAPREFD, C-2
&ORASESST, C-2
&ORASRVN, C-2
for OS/390, C-2
SYSTEM tablespace, 6-5

T

tablespace point-in-time recovery, 6-16
tablespaces
backing up, 6-4
enlarging, 4-4
tapes
format, 17-2
sending to Oracle, 17-2
target instance, defined, for database backup and recovery, 6-6
TCB, multiple executions under, 15-3
TCL script, 13-5
thread pool, storage requirements, 16-42
thread table, Oracle Access Manager for CICS, 11-2
thread, storage requirements, 16-43
TNSNAMES DD statement, 3-9
tnsnames.ora file
modifying for external routines, 10-15
modifying for shared servers, 10-15
Tool Command Language (TCL), 13-5
TRACE_DSNAME parameter, 3-14
TRANSACTIONS parameter, 16-20
TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, B-2
TRCASST, Oracle Net utility program, 10-10
TSO
profile for application binds, 8-3
symptom dumps, 17-10
TYPE parameter, 3-4

U

user stack, 16-10
USER_DUMP_DEST parameter, 3-20
USING clause, with TNSNAMES DD statement, 3-9
USS (OS/390 Unix System Services)
CFUTIL, 18-37
customizing a character set (LXINST), D-11
external routines, 10-13
OEM Intelligent Agent and Data Gatherer, 13-2
security, 8-7
Server Manager on OS/390, 7-4
with network service, 10-7
UTL_FILE PL/SQL package, 8-7
UTL_HTTP PL/SQL package, 8-7

V

virtual storage constraint relief, 1-2
VSAM entry sequenced data set (ESDS) files, 18-36
VSAM linear data set (LDS) files, 4-2, 4-15

W

wait state, reporting the error, 17-7
WLM
See Workload Manager
Workload Manager (WLM)
attributes and values for classification, 16-27
classification rules, 16-28
enhanced client workload management with OSDI, 1-3
goal mode, 16-26, 16-27, 16-28
Oracle Net client processing, 16-3
Oracle Net for OS/390 architecture, 10-2
OS/390 tuning, 16-21
overview, 16-21
policy definition, 16-27
response time goals, 16-27
service class, 16-22, 16-28
velocity goals, 16-26
workload classification, 16-26

X

XCF (Cross System Communication Facility), 14-5

Z

zero-length parameter, A-7
z/OS Workload Manager
See Workload Manager

Go to previous page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents