Go to main content
23/23
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Z
Symbols
&ORAPREFD system symbol,
5.4.4
A
abends,
5.7.2
reporting the error,
10.6.4
abnormal termination,
5.7.2
accounting information,
B
alert log
SYSPRINT DD and,
5.3.6
Alert Logs, OSDI,
11.1.1.5.2
ALERT_DSNAME parameter,
5.4.1
ALERT_MAX parameter,
5.4.2
ALERT_MIN parameter,
5.4.3
ALL_CATALOG view,
C.1
ALL_COL_COMMENTS view,
C.2
ALL_CON_COLUMNS view,
C.3
ALL_CONSTRAINTS view,
C.4
ALL_DB_LINKS data dictionary view,
8.1.6
ALL_IND_COLUMNS view,
C.5
ALL_INDEXES view,
C.6
ALL_OBJECTS view,
C.7
ALL_SYNONYMS view,
C.8
ALL_TAB_COLUMNS view,
C.9
ALL_TAB_COMMENTS view,
C.10
ALL_TABLES view,
C.11
ALL_USERS view,
C.12
ALL_VIEWS view,
C.13
ALTER SERVICE, OSDI command,
A.7.3
ALTER SERVICEGROUP, OSDI command,
A.6.3
ALTER SESSION CLOSE DATABASE LINK statement,
8.1.3
ALTER, OSDI command,
A.4
ANO,
1.1.1.3
application
migrating to OSDI,
A.7.2
application server support,
1.1.1.3
applications,
1.1.4
architecture
gateway,
1.7
,
1.7
array
processing,
9.2
size,
9.2
AS1
SYSPRINT DD statement and alert log,
5.3.6
ASO
checklist
for setting up ASO encryption,
6.7.1.1
for testing,
6.7.2.1
connect client and server,
6.7.2.2
encryption,
6.7
reset configuration parameters on server,
6.7.2.3
set parameters for client,
6.7.1.3
set parameters for server,
6.7.1.2
testing,
6.7.2
AUTHLOAD
library,
4.3.3
,
4.3.4
,
4.3.4
authorization
id,
7.4
,
9.10.2
,
B.3.2
authorizing the load library,
4.3.3
Auto Registration, gateway features,
2.2.1
AVG
option,
9.8.2
Oracle database server function,
9.8.2
SQL function,
9.7
B
bind variables,
9.6.3
,
9.6.5
,
9.6.12
,
9.9.2
known restrictions,
2.4
restrictions,
2.4
,
2.4
BLOB data type,
2.2.3
BPXPRMxx member,
6.4.7
C
CAF
OPEN connection to DB2,
7.4
Call Attach Facility See CAF
calls
PL/SQL,
9.4.1
CANCEL THREAD command,
8.2.2
canceling threads,
8.2.2
catalog views for DB2,
9.10.1
CHAR FOR BIT DATA format,
9.6.12
,
9.6.12
character
columns,
9.6.1
,
9.6.4
converting a string,
9.6.2
string operations,
9.6.1
checklist
configuration,
5.5.1
post installation,
4.1.1
post-configuration,
5.5.2
post-installation,
4.1.2
setting up ASO,
6.7.1.1
testing ASO,
6.7.2.1
CHECKSUM command,
1.1.1.3
clauses
CONNECT BY,
9.8.1
CONNECT TO,
7.4
,
8.1.1
,
8.1.4
DELETE,
9.8.2
,
9.8.2
FOR UPDATE,
9.8.1
,
9.8.1
,
9.8.2
INSERT,
9.8.2
,
9.8.2
SELECT FOR INSERT,
9.8.2
SELECT FOR UPDATE,
9.8.2
,
9.8.2
SQL
DELETE,
9.6.7
INSERT,
9.6.7
SELECT WHERE,
9.6.7
UPDATE,
9.6.7
TO_DATE,
9.6.7
USING,
8.1.1
WHERE,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.1
WHERE CURRENT OF CURSOR,
9.6.10
CLOB data type,
2.2.3
CMDLOAD
library,
5.7.1
CNV_LIT_FMT (sidENV variable),
5.4.37
collecting Oracle statistics,
B
COLLID column,
9.4.2
,
9.4.2
,
9.4.2
COLUMN_PRIVILEGES view,
C.14
columns
character,
9.6.1
,
9.6.4
COLLID,
9.4.2
,
9.4.2
date,
9.6.7
DB2 DATE,
9.6.4
,
9.6.5
IBM DATE,
9.6.3
LONG,
8.10
,
9.6
Oracle DATE,
9.6.5
Oracle ROWID,
9.6.10
RAW,
2.4
ROWID,
9.6.10
command
OSDI
ALTER,
A.4
ALTER SERVICE,
A.7.3
ALTER SERVICEGROUP,
A.6.3
DEFINE,
A.4
DEFINE SERVICE,
A.7.1
DEFINE SERVICEGROUP,
A.6.1
DISPLAY,
6.5
,
A.10.2
DISPLAY LONG,
6.5
DRAIN,
6.5
,
A.10.3
keyword abbreviations,
A.11
list of commands,
A.9
RESUME,
6.5
,
A.10.4
SHOW,
A.4
SHOW SERVICE,
A.7.5
SHOW SERVICEGROUP,
A.6.5
START,
6.5
,
A.10.1
STOP,
6.5
,
A.10.6
start,
7.1
STOP,
7.1
z/OS System
MODIFY (F),
6.5
STOP (P),
6.5
commands
CANCEL THREAD,
8.2.2
CREATE MATERIALIZED VIEW,
8.10
CREATE TABLE,
8.10
DELETE,
9.9.1
EXECUTE,
1.1.3.1
INSERT,
8.10
MPM
DISPLAY EXIT,
7.6.1
gateway operation,
7.1
SETPROG,
4.3.4
,
4.3.4
SETSSI,
4.3.4
SMF
SETSMF,
B.1.2
SQL,
8.1.2
SQL*Plus
COPY,
8.9
,
8.9.2
,
8.9.2
,
8.10
DELETE,
9.9.1
INSERT,
8.9.2
z/OS
DUMP,
10.7
SLIP,
10.6.5
commit confirm protocol,
1.2
compatible SQL functions,
9.7
compensated SQL functions,
9.7
CONCAT SQL function,
9.7
CONNECT BY clause,
9.8.1
connect exit, DB2,
2.2.3
CONNECT TO
clause,
7.4
,
8.1.1
,
8.1.4
statement,
8.1.4
userid,
8.1.4
converting a character string,
9.6.2
COPY command,
8.9.2
,
8.10
COPY SQL*Plus command,
8.9
copying data,
8.9
from the DB2 server,
8.10
from the Oracle database server,
8.9.2
COUNT(*) SQL function,
9.7
CPU requirements,
3.1.1
CREATE DATABASE LINK statement,
8.1.1
CREATE MATERIALIZED VIEW command,
8.10
CREATE TABLE
command,
8.10
statement,
1.1.2.3
CURRDEGREE (sidENV variable),
5.4.20
D
DASD
data set,
5.7.2
data control language See DCL
data definition language See DDL
data dictionary
SYSIBM.SYSPROCEDURES table,
9.4.2
table SYSIBM.SYSPROCEDURES,
9.4.2
using,
9.10.1
views,
8.1.6
,
9.10
,
C
ALL_CATALOG,
C.1
ALL_COL_COMMENTS,
C.2
ALL_CON_COLUMNS,
C.3
ALL_CONSTRAINTS,
C.4
ALL_DB_LINKS,
8.1.6
,
8.1.6
ALL_IND_COLUMNS,
C.5
ALL_INDEXES,
C.6
ALL_OBJECTS,
C.7
ALL_SYNONYMS,
C.8
ALL_TAB_COLUMNS,
C.9
ALL_TAB_COMMENTS,
C.10
ALL_TABLES,
C.11
ALL_USERS,
C.12
ALL_VIEWS,
C.13
COLUMN_PRIVILEGES,
C.14
DBA_DB_LINKS,
8.1.6
OTGREGISTER,
9.10.2
TABLE_PRIVILEGES,
C.16
USER_CATALOG,
C.17
USER_COL_COMMENTS,
C.18
USER_CONS_COLUMNS,
C.19
USER_CONSTRAINTS,
C.20
USER_DB_LINKS,
8.1.6
,
8.1.6
USER_INDEXES,
C.21
USER_OBJECTS,
C.22
USER_SYNONYMS,
C.23
USER_TAB_COLUMNS,
C.24
USER_TAB_COMMENTS,
C.25
USER_TABLES,
C.26
,
C.26
USER_USERS,
C.27
USER_VIEWS,
C.28
data set names
choosing data set name qualifiers,
F.1
data sets
DASD,
5.7.2
dump,
5.7.2
SYS1.DUMP,
10.7.1
SYSOUT,
5.7.2
system dump,
10.7.1
data types
character string,
9.6.1
DATE,
9.6.3
,
9.6.3
DB2
BLOB,
2.2.3
CHAR,
9.6.11
CLOB,
2.2.3
DBCLOB,
2.2.3
GRAPHIC,
9.6.11
ROWID,
2.2.3
TIMESTAMP,
2.2.3
VARCHAR,
9.6.2
,
9.6.2
,
9.6.11
IBM DATE,
9.6.3
LONG,
9.6.2
,
9.6.2
mapping,
9.6
numeric,
9.6.9
,
9.6.9
Oracle
database server,
9.6.3
DATE,
9.6.3
RAW,
9.6.12
restrictions,
9.6
TIME,
9.6.3
,
9.6.3
TIMESTAMP,
9.6.3
,
9.6.3
database
accounting information,
B
triggers,
1.1.1.2
database link,
8.1
accessing data,
8.1.4
behavior,
8.1
creating,
8.1.1
data dictionary views
ALL_DB_LINKS,
8.1.6
DBA_DB_LINKS,
8.1.6
USER_DB_LINKS,
8.1.6
dropping links,
8.1.5
examining,
8.1.6
guidelines,
8.1.3
limits,
8.1.7
using Oracle Net,
8.1.2
DATE
data type,
9.6.3
DB2 columns,
9.6.4
,
9.6.5
,
9.6.5
date
arithmetic,
9.6.8
,
9.6.8
columns,
9.6.7
considerations,
9.6.5
DATE data type,
9.6.3
,
9.6.3
DB2
DATE columns,
9.6.4
,
9.6.5
,
9.6.5
date exit,
2.2.3
,
7.7
local date exit,
9.6.4
,
9.6.5
INSERT
c,
9.6.7
LOCAL DB2 data format,
9.6.4
NLS_DATE_FORMAT parameter,
9.6.6
operations,
9.6.3
,
9.6.3
TIME data type,
9.6.3
TIMESTAMP data type,
9.6.3
TO_DATE function,
9.6.5
,
9.6.7
,
9.6.7
,
9.6.7
DB2
ASCII data to EBCDIC,
9.6.1
bind
JCL,
9.4.2
CAFOPEN connection,
7.4
catalog,
9.6.1
CHAR data type,
9.6.11
CICS,
9.4.2
collection id,
9.4.2
cursors,
8.4
data types
BLOB,
2.2.3
CHAR,
9.6.11
,
9.6.11
CLOB,
2.2.3
DBCLOB,
2.2.3
ROWID,
2.2.3
TIMESTAMP,
2.2.3
VARCHAR,
9.6.11
,
9.6.11
database
read,
9.1
write,
9.1
DATE columns,
9.6.4
,
9.6.4
,
9.6.4
,
9.6.5
date exit,
2.2.3
,
7.7
differences from Oracle database server,
9.9
DSN3@ATH exit,
2.2.3
GRAPHIC data types,
9.6.11
IMS,
9.4.2
known restrictions
for plan,
2.4
local date exit,
9.6.4
,
9.6.4
,
9.6.4
,
9.6.4
,
9.6.5
LOCAL date format,
9.6.4
native
SQL,
1.1.2.3
stored procedures,
1.1.3.2
PL/SQL,
9.4.2
security
profile,
7.5
server triggers,
8.9.1
sign-on exit,
2.2.3
special registers for authorization id,
9.10.2
,
C.15
SQL,
9.4.2
,
9.4.2
SQL statements,
9.5.1
,
9.6.5
statement CREATE TABLE,
1.1.2.3
stored procedures,
8.6
,
9.4
,
9.4.2
tables,
8.10
,
9.6.1
user-defined functions (UDFs),
2.2.3
VARCHAR data type,
9.6.2
,
9.6.2
,
9.6.11
DB2 gateway plan binding
binding the DB2 gateway plan,
5.6.7
DB2 package
binding of,
5.6.6
DB2 Server,
1.7
DB2 Universal Database (UDB),
1.7
DB2CAP (sidENV variable),
5.4.28
DB2DESCTAB (sidENV variable),
5.4.21
DB2I bind jpackage panel,
5.6.6
DB2IND sample DB2 stored procedure,
E.1
DB2LONGMSG (sidENV variable),
5.4.22
DB2PLAN (sidENV variable),
5.4.31
DB2READONLY
parameter,
8.6
,
8.6
DB2READONLY (sidENV variable),
5.4.25
DB2SSN (sidENV variable),
5.4.30
DB2STATS (sidENV variable),
5.4.24
DB2WARNING (sidENV variable),
5.4.23
DBA_DB_LINKS data dictionary view,
8.1.6
DBCLOB data type,
2.2.3
DBCS support,
9.6.11
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function,
9.5
,
9.5
,
9.5.1
,
9.5.1
DCL
DD basic tables, known restrictions,
2.4
DD statement
NET8LOG,
6.4.6
ORA$ENV,
5.3.1
ORA$FPS,
5.3.2
ORA$LIB,
5.3.3
SQLNET,
5.3.4
STEPLIB,
5.3.5
,
6.4.6
SYSPRINT,
5.3.6
DD statements
SYSMDUMP,
5.7.2
DDL statement,
9.5.1
default
record types for SMF,
B.1.2
DEFINE command
supported definition command,
A.4
DEFINE SERVICE, OSDI command,
A.7.1
DEFINE SERVICEGROUP, OSDI command,
A.6.1
definition commands,
A.4
DELETE
clause,
9.8.2
command,
9.9.1
SQL clause,
9.6.7
dictionary mapping,
1.1.1.4
disk
space requirements,
3.1.2
DISPLAY LONG, OSDI command,
6.5
DISPLAY, OSDI command
defined,
A.10.2
with Oracle Net service,
6.5
distributed
DB2 transactions,
8.7.3
queries,
8.7
,
8.7.1
,
8.7.1
,
8.7.2
documentation
errors,
10.6.1
DRAIN, OSDI command
defined,
A.10.3
preventing network connections,
6.5
DROP DATABASE LINK statement,
8.1.5
DSN_PREFIX_DB parameter,
5.4.4
DSN3@ATH exit,
2.2.3
DSNXVDTX executable
for DB2 date exit,
2.2.3
dump data sets,
5.7.2
E
empty parameter,
A.7.2
EMPTYSTR_TO_NULL_OFF (sidENV variable),
5.4.38
EMPTYSTR_TO_NULL_WHERE_OFF (sidENV variable),
5.4.39
enclave SRB
Oracle Net architecture,
6.2
encryption, ASO,
6.7
environment
heterogeneous,
8.8
operational,
10.4
security,
7.4
,
7.5
UNIX,
8.2.1
variables
DB2READONLY parameter,
8.6
environment variable assignment statements, ORA$ENV and,
5.3.1
EPLPA, moving modules into,
5.7.1
error
12660,
6.7
IEC130I,
5.3.2
,
5.3.3
message traffic to the console,
6.5
messages for network region JCL,
6.4.6
ORA-12660,
6.7.2.2
ORA-2063, example message,
10.1.2
errors
diagnosing,
10.1.5
,
10.5
,
10.6
incorrect output,
10.6.2
interpreting,
10.1.2
mapping,
10.1.1
messages,
10
,
10.1
reporting
abends,
10.6.4
documentation,
10.3
,
10.4
,
10.6.1
GTF,
10.8
incorrect output,
10.6.2
Oracle database server error messages,
10.6.3
performance,
10.6.6
program check,
10.6.4
program loop,
10.6.5
sending tapes,
10.3
system dump data sets,
10.7.1
system dumps,
10.7
stored procedure,
10.1.4
EXECUTE
command,
1.1.3.1
exits
DB2
connect,
2.2.3
date,
2.2.3
,
7.7
DSN3@ATH,
2.2.3
local date,
9.6.4
,
9.6.4
,
9.6.4
,
9.6.4
,
9.6.5
DSNXVDTX,
2.2.3
,
7.7
G4RRSAF,
2.2.3
,
5.4.9
,
7.4
,
7.6.1
,
7.7
G4SIGNON,
2.2.3
,
7.4
,
7.6.1
,
7.7
gateway local date,
9.6.6
logon security,
2.2.3
,
5.4.9
,
7.4
,
7.6.1
,
7.7
modules,
7.6
sample programs,
7.7
sign-on,
2.2.3
user,
7.6
extended pageable link pack area See EPLPA
F
FDS_CLASS_VERSION (sidENV variable),
5.4.26
features
10.1.0.2.0 gateway,
2.2.3
8.1.7 gateway,
2.2.1
9.0.1 gateway,
2.2
Oracle materialized views,
8.8.2
synonym,
8.5
fetch reblocking,
9.2.1
,
9.2.1
fields
SMFWCPU,
8.3
filenames
OSDI listener,
6.3
files
SPOOL,
5.7.2
SQLNET.ORA,
8.2.1
VSAM,
9.4.2
FLUSH_CACHE_ON_COMMIT (sidENV variable),
5.4.27
FOR BIT DATA option,
2.4
,
9.6.1
FOR UPDATE clause,
9.8.1
,
9.8.1
NOWAIT option,
9.8.2
FPS
ORA$FPS DD statement,
5.3.2
functions
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE,
9.5
,
9.5
,
9.5.1
,
9.5.1
KEEPALIVE,
8.2.1
MIN,
9.8.2
Oracle database server
AVG,
9.8.2
MAX,
9.8.2
MIN,
9.8.2
SUM,
9.8.2
TO_DATE,
9.8.2
ROWID,
9.6.10
SQL,
9.7
advanced,
9.7
AVG,
9.7
compatible,
9.7
compensated,
9.7
CONCAT,
9.7
COUNT(*),
9.7
MAX,
9.7
MIN,
9.7
SUM,
9.7
translated,
9.7
SUM,
9.8.2
TO_DATE,
9.6.5
,
9.6.6
,
9.6.7
,
9.6.7
,
9.6.7
G
G4RRSAF executable
for DB2 Gateway logon security exit,
2.2.3
,
5.4.9
,
7.4
,
7.6.1
,
7.7
G4SIGNON source code
for DB2 Gateway login exit,
2.2.3
gateway
advantages
migration and coexistence,
1.4
multisite transactions,
1.2
security,
1.5
site autonomy,
1.3
two-phase commit,
1.2
architecture,
1.7
components,
1.7
DB2 server,
1.7
Oracle database server,
1.7
configuring,
5
CPU time,
8.3
development applications,
9.1
dump data sets,
5.7.2
how it works,
1.8
local date exit,
9.6.6
messages,
10.1.3
MPM,
7.1
protection of current investment,
1.6
region parameters, defined,
5.4
security,
7.4
,
7.4
authorization id,
7.4
Oracle user exit facility,
7.6
SAF router,
7.5
sample exit programs,
7.7
secondary authorization id,
7.4
specifying an exit module,
7.6.1
gateway messages, format explained,
10.1.2
gateway service
opening a,
11.1.5
gateway service, configuring a,
11.1.3
GETHOSTBYNAME API, Oracle Net IBM TCP/IP HPNS,
6.4.7
Globalization Support
data objects, ORA$LIB DD statement,
5.3.3
GTF,
10.8
H
heterogeneous replication
STREAMS,
2.2.2
high-level qualifier,
4.3.3
choosing data set name qualifiers,
F.1
HPNS interface,
11.1.6.3
HS initialization parameters,
5.4.43
HS_OPEN_CURSORS
parameter,
8.4
HS_RPC_FETCH_REBLOCKING
parameter,
9.2.1
HS_RPC_FETCH_SIZE
initialization parameter,
3.1.3
parameter,
9.2.1
I
IBM DATE
column,
9.6.3
data type,
9.6.3
IBM LE/370 runtime library
gateway region JCL,
5.3.5
IBM maintenance,
3.2.3
,
3.2.4
IDLE_TIMEOUT parameter,
2.2.3
,
5.4.6
IEAAPFxx member,
4.3.3
IEASYSnn member,
4.3.3
IEBUPDTE utility,
4.3.3
IEC130I error,
5.3.2
,
5.3.3
IEFUSI exit,
5.3
incompatibilities, release,
11.2.1
incorrect output errors,
10.6.2
INIT_ADR_SPACES parameter,
5.4.7
INIT_STACK_SIZE parameter,
5.4.8
initialization
parameters
HS_RPC_FETCH_SIZE,
3.1.3
INSERT
clause,
9.8.2
,
9.8.2
command,
8.10
SQL clause,
9.6.7
statement,
10.1.5
,
10.1.5
installation
checking distribution kit,
3.5
checklists,
4.1
COPYPROC job,
4.2.2
installing gateway software,
4.2.2
moving modules to linklist library,
4.2.2
post installation steps,
5.7
post-installation steps,
4.3
pre-installation tasks,
4.2.1
program properties for,
4.3.2
required patches for,
4.3.1
INSTLIB library
contents,
5.6.1
creation,
5.6
location,
5.6.1
interface, Oracle array processing,
9.2
Internet support,
1.1.1.3
Intranet support,
1.1.1.3
IPLing z/OS,
4.3
isolation level,
5.6.7
ISPF
EDIT,
4.3.3
IXCF support,
11.1.6.4
J
JCL
DB2 bind,
9.4.2
define an ALIAS before loading the installation JCL,
F.1
MPM startup,
5.7.2
ORAFMT sample,
B.4
JCL, gateway instance,
11.1.3.2
JCL, network region,
6.4.6
JOBNAME parameter,
5.2.6
JOIN capability,
1.1.1.2
K
Katakana DB2 support,
9.6.11
KEEPALIVE
function,
8.2.1
,
8.2.1
Oracle Net,
8.2.1
keyword abbreviations, OSDI command,
A.11
known problems,
2.3
known restrictions,
2.4
binary literal notation,
2.4
DB2
plan,
2.4
DD basic tables and views,
2.4
literal values,
2.4
OCI,
2.4
Oracle database server SQL,
2.4
precompiling,
2.4
RAW data,
2.4
SQL,
2.4
L
Language Environment runtime library (LE)
Oracle Net,
6.4.7
LDAP.ORA file, sample,
6.4.8.3
libraries
AUTHLOAD,
4.3.3
,
4.3.4
,
4.3.4
authorized,
4.3.3
CMDLOAD,
5.7.1
load,
4.3.3
PARMLIB,
8.4
SYS1.PARMLIB,
4.3.3
,
4.3.4
LIKE_OFF (sidENV variable),
5.4.40
link pack area See LPA
linkage conventions
SIMPLE,
9.4.2
,
9.4.2
SIMPLE WITH NULLS,
9.4.2
,
9.4.2
,
9.4.2
linklist library, moving modules to,
4.2.2
listener
OSDI, See OSDI listener
listener architecture,
6.2
load library, authorizing,
4.3.3
LOCAL DB2 date format,
9.6.4
logon security exit,
2.2.3
,
5.4.9
,
7.4
,
7.6.1
,
7.7
LOGON_AUTH parameter,
5.4.9
LONG
column,
8.10
,
9.6
data type,
9.6.2
,
9.6.2
LPA, moving modules into,
5.7.1
M
MACRO API interface, with Oracle Net,
6.4.7
managing threads,
8.2
mapping error messages,
10.1.1
materialized view,
9.6.10
materialized views
complete refresh,
8.10
CREATE MATERIALIZED VIEW command,
8.10
Oracle materialized view feature,
8.8.2
MAX
option,
9.8.2
Oracle database server function,
9.8.2
SQL function,
9.7
MAX_SESSION_MEM parameter,
5.4.10
MAX_SESSIONS parameter,
5.4.11
MAXAS parameter
gateway region parameters,
5.4.7
gateway service definition,
5.2.5
MAXFILEPROC parameter,
6.4.7
MAXSOCKETS parameter,
6.4.7
member
BPXPRMxx,
6.4.7
members
IEAAPFxx,
4.3.3
IEASYSnn,
4.3.3
ORAFMTCL,
B.4
ORAFMTGO,
B.4
PARMLIB,
7.6.1
PROGxx,
4.3.3
sidENV,
8.4
SMFPRMxx,
B.1
message
IEC130I,
5.3.2
,
5.3.3
messages,
10.1
error,
10
format,
10.1.2
gateway,
10.1
generated by gateway,
10.1.3
mapped,
10.1
ORA-2025,
8.9.2
ORA-9100,
10.1
Oracle database server,
10.6.3
stored procedure,
10.1.4
migrating from MPM
cautions,
11.1.2
MIN
option,
9.8.2
Oracle database server function,
9.8.2
SQL function,
9.7
missing functionality,
10.6.7
Mobile Agents,
1.1.1.3
MODIFY (F), z/OS command
communicating with a running Oracle Net service,
6.5
MPM
operation,
7.1
startup JCL,
5.7.2
,
5.7.2
STEPLIB,
7.6
SYSABEND for startup,
5.7.2
SYSUDUMP for startup,
5.7.2
MPM commands
DISPLAY EXIT,
7.6.1
gateway operation,
7.1
MPM messages, obsolescence of,
11.1.1.4
MPM parameters
gateway subsystem,
7.1
MPM to OSDI migration,
11.2
MPM, compared to OSDI,
11.1
MPM/TNS coexistence,
11.2.4
,
11.2.5
multiple gateway services, configuring,
11.2.3
N
Net service
See OSDI listener
NET8LOG DD statement,
6.4.6
network service
configuring,
11.1.6.1
operating,
11.1.6.2
OSDI,
11.1.1.3
NLS_DATE_FORMAT
parameter,
9.6.6
NOWAIT option,
9.8.2
numeric data types,
9.6.9
NVL_TO_VALUE_OFF (sidENV variable),
5.4.41
O
OCI,
2.4
,
9.4.2
,
9.4.2
,
10.1.2
OPEN_LINKS parameter,
8.1.7
operator initiated dumps,
10.7.2
options
AVG,
9.8.2
FOR BIT DATA,
9.6.1
MAX,
9.8.2
MIN,
9.8.2
NOWAIT,
9.8.2
SUM,
9.8.2
TO_DATE,
9.8.2
ORA$ENV DD statement,
5.3.1
ORA$FPS DD statement
gateway region JCL,
5.3.2
ORA$LIB
DD statement, gateway region JCL,
5.3.3
ORA_MAX_DATE (sidENV variable),
5.4.33
ORA-12660 error,
6.7.2.2
ORA-2025 message,
8.9.2
ORA-2063, example error message,
10.1.2
ORA-9100 message,
10.1
Oracle Advanced Security Option
See ASO
Oracle Call Interface See OCI
Oracle database server
data type,
9.6.3
database triggers,
1.1.1.2
DATE columns,
9.6.5
distributed query optimization,
1.1.1.2
functions
AVG,
9.8.2
MAX,
9.8.2
MIN,
9.8.2
SUM,
9.8.2
TO_DATE,
9.8.2
stored procedures,
1.1.1.2
subsystem
accounting information,
B
error reporting,
10.6.3
resource usage,
B
statistics,
B
triggers,
8.9.1
two-phase commit protection,
1.1.1.2
user exit facility,
7.6
Oracle Developer,
1.1.4.1
Oracle Discoverer,
1.1.4.2
Oracle Net
IBM TCP/IP
requirements,
3.4.1
KEEPALIVE function,
8.2.1
OSDI listener,
6.1
overview,
6.1
Oracle net
requirements
resource,
3.1.3
Oracle Support Services,
10.2
ORACLE_TIMESTAMP (sidENV variable),
5.4.34
ORACLE2PC table,
2.4
,
8.7.2
,
8.7.2
,
8.7.3
ORAFMT program for SMF,
B.3
,
B.4
ORAFMTCL
member,
B.4
sample JCL,
B.4
ORAFMTGO
member,
B.4
sample JCL,
B.4
ORAIND sample DB2 stored procedure,
E.2
ORARECID (sidENV variable),
5.4.32
OS/390
operating system, supported versions,
3.1.1
OSDI
command
keyword abbreviations,
A.11
listener,
6.1
MESG data set, ORA$LIB DD statement,
5.3.3
subsystems,
11.1.1.1
upgrade or migration to,
11.2.2
OSDI command verbs,
7.2
OSDI commands
access to,
7.2
OSDI listener
configuration,
6.4
DEFINE parameters,
6.4.1
OSDI listener architecture,
6.2
OSDI network service,
11.1.1.3
OSDSI
differences from MPM,
11.1
OTGDB2.OTGREGISTER view,
C.15
OTGREGISTER view,
9.10.2
P
pageable link pack area See PLPA
parameter
encryption,
6.7.1.3
gateway region parameter
ALERT_DSNAME,
5.4.1
ALERT_MAX,
5.4.2
ALERT_MIN,
5.4.3
DSN_PREFIX_DB,
5.4.4
IDLE_TIMEOUT,
5.4.6
INIT_ADR_SPACES,
5.4.7
INIT_STACK_SIZE,
5.4.8
LOGON_AUTH,
5.4.9
MAX_SESSION_MEM,
5.4.10
MAX_SESSIONS,
5.4.11
PRIMARY_ASC_MODE,
5.4.12
REGION_MEM_RESERVE,
5.4.13
SERVER_LOADMOD,
5.4.15
SMF_STAT_RECNO,
5.4.16
TRACE_DSNAME,
5.4.17
JOBNAME,
5.2.6
MAXAS
gateway service parameter,
5.2.5
PARM,
5.3
REGION
gateway region JCL,
5.3
TYPE,
5.2.2
zero-length (empty),
A.7.2
parameters
ASO, setting for server,
6.7.1.2
configuration, resetting on server,
6.7.2.3
DB2READONLY,
8.6
,
8.6
encryption,
6.7.1.2
HS_OPEN_CURSORS,
8.4
HS_RPC_FETCH_REBLOCKING,
9.2.1
HS_RPC_FETCH_SIZE,
9.2.1
IDLE_TIMEOUT,
2.2.3
initialization
HS_RPC_FETCH_SIZE,
3.1.3
MAXFILEPROC,
6.4.7
MAXSOCKETS,
6.4.7
MPM
startup,
B.1
NLS_DATE_FORMAT,
9.6.6
OPEN_LINKS,
8.1.7
Oracle Net TNSNAMES SID,
2.2.2
,
2.2.2
,
2.2.2
READONLY,
8.6
setting, for client,
6.7.1.3
SQLNET.EXPIRE_TIME,
8.2.1
parametesr
REGION (network region JCL),
6.4.6
PARM parameter,
5.3
PARMLIB
library,
8.4
member,
7.6.1
PARMLIB library
contents,
5.6.1
creation,
5.6
location,
5.6.1
PARMLIB member
editing of,
5.6.9
passthrough,
1.1.2.3
,
8.6
,
9.5
,
9.5.1
,
9.5.2
,
9.5.2.1
result sets,
9.5
,
9.5.2
,
9.5.2.1
passthru See passthrough
patches, downloading required,
4.3.1
performance
issues,
10.6.6
PLPA,
5.7.1
PLPA, moving modules into
PL/SQL,
9.4.2
,
9.4.2
call,
9.4.1
DB2,
9.4.2
routine,
1.1.3.1
standard Oracle,
1.1.3.2
post-installation steps,
4.3
Precompiler limitations,
2.4
pre-installation tasks,
4.2.1
PRIMARY_ASC_MODE parameter,
5.4.12
procedures
error example for stored procedures,
10.1.4
native stored,
1.1.3.2
sample DB2 DB2IND,
E.1
sample for DB2 ORAIND,
E.2
stored,
1.1.1.2
,
1.1.3
,
8.6
,
9.4
processing SQL,
9.8
product set,
2.1
program loop,
10.6.5
program properties
adding for installation,
4.3.2
SCHEDxx member and,
4.3.2
PROGxx member,
4.3.3
protection of investment,
1.6
protocols
commit confirm,
1.2
Q
queries, distributed,
8.7
R
RACF
with network service,
6.4.7
RAW
columns, known restrictions,
2.4
data type,
9.6.12
data, known restrictions,
2.4
format,
9.6.12
recording SMF information,
B.1
Recoverable Resource Manager Services Attachment Facility (RRSAF),
2.2.3
reentrant modules, moving to EPLPA
REGION parameter,
5.3
,
6.4.6
REGION_MEM_RESERVE parameter,
5.4.13
replication,
8.8
requirements
CPU,
3.1.1
,
3.1.1
disk space,
3.1.2
Oracle Net,
3.1.3
,
3.4
virtual memory,
3.1.3
resource usage,
B
RESUME command
defined,
A.10.4
Oracle Net,
6.5
RMODE linkage,
5.7.1
routines
PL/SQL,
1.1.3.1
ROWID
column,
9.6.10
DELETE,
9.6.10
materialized views,
9.6.10
restrictions,
9.6.10
UPDATE,
9.6.10
WHERE CURRENT OF CURSOR clause,
9.6.10
function,
2.4
,
9.6.10
ROWID data type,
2.2.3
RRSAF (Recoverable Resource Manager Services Attachment Facility),
2.2.3
S
SAF
considerations,
7.4
router,
7.5
SCHEDxx member,
4.3.2
scripts
SQL DD,
2.4
secondary authorization id,
7.4
security
advanced,
1.1.1.3
ANO,
1.1.1.3
encryption,
1.1.1.3
for gateway,
7.4
,
7.4
SAF router considerations,
7.5
specifying an exit module,
7.6.1
user exit,
7.6
Security Authorization Facility See SAF
SELECT
statement,
8.6
,
9.2.1
,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.2
SELECT FOR DELETE clause,
9.8.2
SELECT FOR INSERT clause,
9.8.2
SELECT FOR UPDATE clause,
9.8.2
,
9.8.2
SELECT WHERE SQL clause,
9.6.7
SELECT_CONCAT_ON (sidENV variable),
5.4.42
SERVER_LOADMOD parameter,
5.4.15
service
definition commands,
A.7
service group
definition commands,
A.6
service name, for a gateway,
5.2.1
service group, definition of,
11.1.2
session connection,
8.1
SETPROG system command,
4.3.4
,
4.3.4
SETSSI system command,
4.3.4
setting of,
5.6.7
SHOW SERVICE, OSDI command,
A.7.5
SHOW SERVICEGROUP, OSDI command,
A.6.5
SHOW, OSDI command,
A.4
SID
defined
gateway service name,
5.2.1
sid
gateway instance,
11.1.3.1
sidENV
HS initialization parameters,
5.4.43
sidENV member,
8.4
sidENV parameters,
5.4.18
sign-on exit,
2.2.3
SIMPLE linkage convention,
9.4.2
,
9.4.2
SIMPLE WITH NULLS linkage convention,
9.4.2
,
9.4.2
,
9.4.2
,
E.1
SITEINFO file,
6.4.7
SLIP command,
10.6.5
SMF
abends,
B.2
abnormal terminations,
B.2
activating,
B.1
commands
SETSMF,
B.1.2
default record types,
B.1.2
interpreting records,
B.3
ORAFMT program,
B.3
,
B.4
record type, specifying,
B.1.1.1
recording
starting,
B.1.2
stopping,
B.1.3
records,
B
records, interpreting,
B.3
sample formatting program,
B.4
starting dynamically,
B.1.2
types of users,
B.1
user-defined data section,
B.4
when records are written,
B.2
SMF_STAT_RECNO parameter,
5.4.16
SMFAUTH authorization id,
B.3.2
,
B.4
SMFPRMxx member,
B.1
SMFWCPU field,
8.3
SNS/TCPaccess,
11.1.6.3
software requirements,
3.2
IBM maintenance,
3.2.3
,
3.2.4
z/OS operating system,
3.2.1
specifying
SMF record type,
B.1.1.1
SPOOL
file,
5.7.2
space,
5.7.2
SQL,
1.1.2
ANSI standard,
1.1.2
clauses
DELETE,
9.6.7
INSERT,
9.6.7
SELECT WHERE,
9.6.7
UPDATE,
9.6.7
commands,
8.1.2
constructs, Oracle-specific,
9.8
DB2,
9.4.2
,
9.4.2
DD script,
2.4
functions,
9.7
,
9.7
,
D
advanced,
9.7
AVG,
9.7
compatible,
9.7
compensated,
9.7
CONCAT,
9.7
COUNT(*),
9.7
MAX,
9.7
MIN,
9.7
SUM,
9.7
translated,
9.7
ISO standard,
1.1.2
limitations,
2.4
passthrough,
8.6
,
9.5
,
9.5.1
,
9.5.2
,
9.5.2.1
statements,
8.7.1
,
9.1
,
9.1
DB2,
9.5.1
,
9.6.5
passing through gateway,
9.5
SQL*Plus,
1.1.4.3
commands
COPY,
8.9
,
8.9.2
,
8.9.2
DELETE,
9.9.1
INSERT,
8.9.2
SQLNET DD statement,
5.3.4
SQLNET.EXPIRE_TIME parameter,
8.2.1
SQLNET.ORA file,
8.2.1
SRB (service request block)
Oracle Net architecture,
6.2
START
OSDI command
defined,
A.10.1
starting Oracle Net service,
6.5
START command,
7.1
statements
ALTER SESSION CLOSE DATABASE LINK,
8.1.3
CONNECT TO,
8.1.4
CREATE DATABASE LINK,
8.1.1
DB2 CREATE TABLE,
1.1.2.3
DDL,
9.5.1
DROP DATABASE LINK,
8.1.5
INSERT,
10.1.5
,
10.1.5
SELECT,
8.6
,
9.2.1
,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.2
SQL,
8.7.1
,
9.1
,
9.1
DB2,
9.5.1
,
9.6.5
passing through gateway,
9.5
SYSMDUMP DD,
5.7.2
,
5.7.2
STEPLIB DD statement
gateway region JCL,
5.3.5
Oracle Net region JCL,
6.4.6
STOP
OSDI command,
6.5
defined,
A.10.6
STOP (P) z/OS System command,
6.5
STOP command,
7.1
storage requirements,
3.1.3
stored procedures,
1.1.1.2
,
1.1.3
creating on DB2,
9.4.1
DB2,
8.6
,
9.4
,
9.4.2
using,
9.4
DB2IND,
E.1
error message,
10.1.4
native DB2,
1.1.3.2
Oracle,
1.1.3.1
Oracle database server
local instance,
9.3
PL/SQL,
9.3
remote instance,
9.3
using,
9.3
ORAIND,
E.2
SYSPROC qualifier,
9.4.1
two-phase commit processing,
9.3
stored procedures in DB2, gateway features,
2.2.1
Streams Heterogeneous Replication,
2.2.2
SUM
option,
9.8.2
Oracle database server function,
9.8.2
SQL function,
9.7
support
sending tapes,
10.3
synonym feature,
8.5
SYS1.PARMLIB
library,
4.3.3
,
4.3.4
SYS1.SCEERUN, LE/370 runtime library name,
5.3.5
SYSABEND for MPM startup,
5.7.2
SYSMDUMP DD statement,
5.7.2
,
5.7.2
SYSOUT
data set,
5.7.2
SYSPRINT DD statement,
5.3.6
system
dump data sets,
10.7.1
requirements
resource,
3.1
software,
3.2
SYSUDUMP for MPM startup JCL,
5.7.2
T
TABLE_PRIVILEGES view,
C.16
tables
DB2,
2.4
,
8.10
,
9.6
,
9.6.1
ORACLE2PC,
2.4
,
8.7.2
,
8.7.2
,
8.7.3
SYSIBM.SYSPROCEDURES DB2 data dictionary,
9.4.2
,
9.4.2
TARGET (sidENV variable),
5.4.29
TCP/IP
KEEPALIVE,
8.2.1
threads
canceling,
8.2.2
managing,
8.2
TIME data type,
9.6.3
time operations,
9.6.3
TIMESTAMP data type,
9.6.3
TIMESTAMP data type mapping,
2.2.3
TNS
connect descriptor,
8.1.2
TNS facility,
11.1.1.3
TNS messages, obsolescence of,
11.1.1.4
TNSNAMES SID
parameter,
2.2.2
,
2.2.2
,
2.2.2
,
2.2.2
,
2.2.2
,
2.2.2
TNSNAMES.ORA
connect descriptor,
8.1.1
TO_DATE
clause,
9.6.7
function,
9.6.4
,
9.6.5
,
9.6.6
,
9.6.7
,
9.6.7
option,
9.8.2
Oracle database server function,
9.8.2
TO_NUMBER_OFF (sidENV variable),
5.4.36
Trace Files
OSDI,
11.1.1.5.1
TRACE_DSNAME parameter,
5.4.17
TRACELEVEL (sidENV variable),
5.4.35
translated SQL function,
9.7
TRCASST, Oracle Net utility program,
6.6
triggers,
8.8.1
database,
1.1.1.2
DB2 server,
8.9.1
Oracle database server,
8.9.1
two-phase commit,
1.1.1.2
,
8.7.2
TYPE parameter,
5.2.2
U
UDF (user-defined functions),
2.2.3
UNION capability,
1.1.1.2
UNIX environment,
8.2.1
UPDATE SQL clause,
9.6.7
user
exit module,
7.6
record type,
B.1
USER_CATALOG view,
C.17
USER_COL_COMMENTS view,
C.18
USER_CONS_COLUMNS view,
C.19
USER_CONSTRAINTS view,
C.20
USER_DB_LINKS data dictionary view,
8.1.6
USER_INDEXES view,
C.21
USER_OBJECTS view,
C.22
USER_SYNONYMS view,
C.23
USER_TAB_COLUMNS view,
C.24
USER_TAB_COMMENTS view,
C.25
USER_VIEWS view,
C.28
user-defined functions (UDFs), DB2,
2.2.3
userids
CONNECT TO,
8.1.4
using
the data dictionary,
9.10.1
USING clause,
8.1.1
USS (z/OS UNIX System Services)
with network service,
6.4.7
utilities
IEBUPDTE,
4.3.3
V
views
catalog for DB2,
9.10.1
data dictionary,
9.10.1
ALL_CATALOG,
C.1
ALL_COL_COMMENTS,
C.2
ALL_CON_COLUMNS,
C.3
ALL_CONSTRAINTS,
C.4
ALL_DB_LINKS,
8.1.6
ALL_IND_COLUMNS,
C.5
ALL_INDEXES,
C.6
ALL_OBJECTS,
C.7
ALL_SYNONYMS,
C.8
ALL_TAB_COLUMNS,
C.9
ALL_TAB_COMMENTS,
C.10
ALL_TABLES,
C.11
ALL_USERS,
C.12
ALL_VIEWS,
C.13
COLUMN_PRIVILEGES,
C.14
DBA_DB_LINKS,
8.1.6
OTGDB2.OTGREGISTER,
C.15
OTGREGISTER,
9.10.2
TABLE_PRIVILEGES,
C.16
USER_CATALOG,
C.17
USER_COL_COMMENTS,
C.18
USER_CONS_COLUMNS,
C.19
USER_CONSTRAINTS,
C.20
USER_DB_LINKS,
8.1.6
USER_INDEXES,
C.21
USER_OBJECTS,
C.22
USER_SYNONYMS,
C.23
USER_TAB_COLUMNS,
C.24
USER_TAB_COMMENTS,
C.25
USER_VIEWS,
C.28
virtual memory requirements,
3.1.3
VSAM
file,
9.4.2
W
WHERE clause,
8.10
,
9.8.1
,
9.8.1
,
9.8.1
,
9.8.1
WHERE CURRENT OF CURSOR clause,
9.6.10
wireless communication,
1.1.1.3
Workload Manager (WLM)
Oracle Net for z/OS architecture,
6.2
Z
zero-length parameter,
A.7.2
z/OS
commands
DUMP,
10.7
SLIP,
10.6.5
link pack areas,
5.7.1
operating system, supported releases,
3.2.1
z/OS UNIX System Services (USS)
with network service,
6.4.7
Scripting on this page enhances content navigation, but does not change the content in any way.