Skip Headers

Oracle Transparent Gateway for DB2 Installation and User's Guide
Release 9.2.0.1.1 for OS/390

Part Number A95217-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 


A

abends, 5-37
reporting the error, 10-8
abnormal termination, 5-37
ABS SQL function, F-1
accounting information, D-1
ACOS SQL function, F-1
ADD_MONTHS SQL function, F-1
additional software requirements
IBM DB2, 3-4
ISPF, 3-4
REXX, 3-4
Alert Logs, OSDI, 11-3
ALL_CATALOG view, E-2
ALL_COL_COMMENTS view, E-2
ALL_CON_COLUMNS view, E-3
ALL_CONSTRAINTS view, E-3
ALL_DB_LINKS data dictionary view, 8-3
ALL_IND_COLUMNS view, E-4
ALL_INDEXES view, E-4
ALL_OBJECTS view, E-5
ALL_SYNONYMS view, E-6
ALL_TAB_COLUMNS view, E-6
ALL_TAB_COMMENTS view, E-7
ALL_TABLES view, E-7
ALL_USERS view, E-8
ALL_VIEWS view, E-9
ALTER SERVICE, OSDI command, B-8
ALTER SERVICEGROUP, OSDI command, B-4
ALTER SESSION CLOSE DATABASE LINK statement, 8-3
ALTER, OSDI command, B-3
ANO, 1-4
APARs, 3-3
application
migrating to OSDI, B-7
application server support, 1-4
applications, 1-6
architecture
gateway, 1-8
array
processing, 9-2
size, 9-3
ASCII
SQL function, F-1
tables, known restrictions, 2-4
ASIN SQL function, F-1
ASO
checklist
for setting up ASO encryption, 6-13
for testing, 6-13
connect client and server, 6-14
encryption, 6-12
reset configuration parameters on server, 6-14
set parameters for client, 6-13
set parameters for server, 6-13
testing, 6-13
ATAN SQL function, F-1
ATAN2 SQL function, F-1
AUTHID column, 9-5
AUTHLOAD
library, 4-22, 4-23
AUTHLOAD library
job ORIJC00, 4-14
authorization
id, 7-5, 9-22, D-6
authorizing the load library, 4-22
Auto Registration, gateway features, 2-2
AVG
option, 9-20
Oracle database server function, 9-20
SQL function, 9-18

B

before starting the gateway, 4-22
bind variables, 9-13, 9-15, 9-18, 9-21
known restrictions, 2-4
restrictions, 2-5
BPXPRMxx member, 6-8

C

CAF
CONNECT call, 7-8
OPEN call, 7-8, 7-9
OPEN connection to DB2, 7-5
Call Attach Facility See CAF
calls
CAF CONNECT, 7-8
CAF OPEN, 7-8, 7-9
PL/SQL, 9-4
CANCEL THREAD command, 8-5
canceling threads, 8-5
catalog views for DB2, 9-22
CCSID
with NLS, C-4
CEIL SQL function, F-1
CHAR FOR BIT DATA format, 9-18
CHAR_TO_ROWID SQL function, F-1
character
columns, 9-11, 9-13
converting a string, 9-12
sets
ASCII, 2-4
compatibility, C-2
EBCDIC, 2-4
string operations, 9-11
character set name, 5-5
checklist
configuration, 5-2
post installation, 4-2
post-configuration, 5-3
post-installation, 4-2
setting up ASO, 6-13
setup and initialization, 4-2
testing ASO, 6-13
CHECKSUM command, 1-4
CHR SQL function, F-1
clauses
CONNECT BY, 9-20
CONNECT TO, 7-4, 8-2, 8-3
DELETE, 9-20
FOR UPDATE, 9-19, 9-20
INSERT, 9-20
SELECT FOR INSERT, 9-20
SELECT FOR UPDATE, 9-20
SQL
DELETE, 9-16
INSERT, 9-16
SELECT WHERE, 9-16
UPDATE, 9-16
TO_DATE, 9-16
USING, 8-2
VALUES, 9-16
WHERE, 9-19, 9-20
WHERE CURRENT OF CURSOR, 9-17
CMDLOAD
library, 5-37
CNV_LIT_FMT (sidENV variable), 5-27
collecting Oracle statistics, D-1
COLLID column, 9-7
COLUMN_PRIVILEGES view, E-9
columns
AUTHID, 9-5
character, 9-11, 9-13
COLLID, 9-7
date, 9-16
DB2 DATE, 9-13, 9-14
IBM DATE, 9-13
LONG, 8-16, 9-11
LUNAME, 9-5
Oracle DATE, 9-14
Oracle ROWID, 9-17
PROCEDURE, 9-5
RAW, 2-4
result for SELECT, 9-20
ROWID, 9-17
command
OS/390 System
MODIFY (F), 6-11
STOP (P), 6-11
OSDI
ALTER, B-3
ALTER SERVICE, B-8
ALTER SERVICEGROUP, B-4
DEFINE, B-3
DEFINE SERVICE, 5-10, B-5
DEFINE SERVICEGROUP, B-3
DISPLAY, 6-12, B-12
DISPLAY LONG, 6-12
DRAIN, 6-12, B-13
keyword abbreviations, B-15
list of commands, B-11
RESUME, 6-12, B-13
SHOW, B-3
SHOW SERVICE, B-10
SHOW SERVICEGROUP, B-5
START, 5-10, 6-10, B-11
STOP, 6-11, B-14
OSDI DEFINE SERVICE, 5-30
start, 7-2
STOP, 7-2
commands
CANCEL THREAD, 8-5
CREATE SNAPSHOT, 8-15
CREATE TABLE, 8-14
DELETE, 9-21
EXECUTE, 1-6
INSERT, 8-15
MPM
DISPLAY EXIT, 7-6
gateway operation, 7-2
OS/390
DUMP, 10-10
SLIP, 10-9
SETPROG, 4-22, 4-23
SETSSI, 4-22, 4-23
SMF
SETSMF, D-3
SQL, 8-2
SQL*Plus
COPY, 8-9, 8-10, 8-15
DELETE, 9-21
INSERT, 8-9
commit confirm protocol, 1-7
compatible SQL functions, 9-18
compensated SQL functions, 9-19
CONCAT SQL function, 9-18
configuration jobs
sidJC01 and sidJC02, 5-11
configuration steps, 5-3
CONNECT BY clause, 9-20
CONNECT TO
clause, 7-4, 8-2, 8-3
statement, 8-3
userid, 8-3
CONVERT SQL function, F-1
converting a character string, 9-12
COPY command, 8-9, 8-15
COPY SQL*Plus command, 8-9
copying data, 8-9
from the DB2 server, 8-14
from the Oracle database server, 8-9
COS SQL function, F-1
COSH SQL function, F-1
COUNT
options, 9-21
COUNT(*) SQL function, 9-18
COUNT(DISTINCT expression) SQL function, 9-18
CPU requirements, 3-2
CREATE DATABASE LINK statement, 8-2
CREATE SNAPSHOT command, 8-15
CREATE TABLE
command, 8-14
statement, 1-5
creating the ISPF libraries, 4-4
CSECT for entry point, 5-8
CSV210I message, job ORIJC00, 4-14
CURRDEGREE (sidENV variable), 5-23

D

DASD
data set, 5-37
data control language See DCL
data definition language See DDL
data dictionary, 5-7
SYSIBM.SYSPROCEDURES table, 9-7
table SYSIBM.SYSPROCEDURES, 9-7
using, 9-22
views, 8-3, 9-22, E-1
ALL_CATALOG, E-2
ALL_COL_COMMENTS, E-2
ALL_CON_COLUMNS, E-3
ALL_CONSTRAINTS, E-3
ALL_DB_LINKS, 8-3
ALL_IND_COLUMNS, E-4
ALL_INDEXES, E-4
ALL_OBJECTS, E-5
ALL_SYNONYMS, E-6
ALL_TAB_COLUMNS, E-6
ALL_TAB_COMMENTS, E-7
ALL_TABLES, E-7
ALL_USERS, E-8
ALL_VIEWS, E-9
COLUMN_PRIVILEGES, E-9
DBA_DB_LINKS, 8-3
OTGREGISTER, 9-22
TABLE_PRIVILEGES, E-10
USER_CATALOG, E-10
USER_COL_COMMENTS, E-11
USER_CONS_COLUMNS, E-11
USER_CONSTRAINTS, E-11
USER_DB_LINKS, 8-3
USER_INDEXES, E-12
USER_OBJECTS, E-13
USER_SYNONYMS, E-13
USER_TAB_COLUMNS, E-14
USER_TAB_COMMENTS, E-14
USER_TABLES, E-15
USER_USERS, E-16
USER_VIEWS, E-16
data set names
choosing data set name qualifiers, H-2
on distribution media, 3-5
data sets
DASD, 5-37
distribution media, 3-5
dump, 5-37
names, 3-5
partitioned, A-2
SYS1.DUMP, 10-10
SYSOUT, 5-37
system dump, 10-10
data types
character string, 9-11
DATE, 9-12
DB2
CHAR, 9-18
GRAPHIC, 9-18
VARCHAR, 9-12, 9-18
IBM DATE, 9-13
LONG, 9-12
mapping, 9-10
numeric, 9-17
Oracle
database server, 9-13
DATE, 9-12
RAW, 9-18
restrictions, 9-10
TIME, 9-12, 9-13
TIMESTAMP, 9-12, 9-13
database
accounting information, D-1
triggers, 1-4
database link, 8-2
accessing data, 8-3
behavior, 8-1
creating, 8-2
data dictionary views
ALL_DB_LINKS, 8-3
DBA_DB_LINKS, 8-3
USER_DB_LINKS, 8-3
dropping links, 8-3
examining, 8-3
guidelines, 8-3
limits, 8-4
using Oracle Net, 8-2
DATE
data type, 9-12
DB2 columns, 9-13, 9-15
date
arithmetic, 9-16
columns, 9-16
considerations, 9-14
DATE data type, 9-12, 9-13
DB2
DATE columns, 9-13, 9-15
local date exit, 9-13, 9-15
INSERT
c, 9-16
LOCAL DB2 data format, 9-14
NLS_DATE_FORMAT parameter, 9-15
operations, 9-12
TIME data type, 9-12
TIMESTAMP data type, 9-12
TO_DATE function, 9-15, 9-16
DB2
ASCII data to EBCDIC, 9-11
bind
JCL, 9-7
CAFOPEN connection, 7-5
catalog, 9-12
CHAR data type, 9-18
CICS, 9-6
collection id, 9-7
connection exit, 7-8
CURRENT SERVER value, 9-5
cursors, 8-5
data types
CHAR, 9-18
VARCHAR, 9-18
database
read, 9-2
write, 9-2
DATE columns, 9-13, 9-14
differences from Oracle database server, 9-21
GRAPHIC data types, 9-18
IMS, 9-6
known restrictions
for plan, 2-4
load library, 5-6
local date exit, 9-13, 9-14, 9-15
LOCAL date format, 9-14
native
SQL, 1-5
stored procedures, 1-6
optional security class, 5-7
plan name, 5-6
PL/SQL, 9-7
PROC1, 9-5
security
checking, 7-9
profile, 7-5
server triggers, 8-9
special registers for authorization id, 9-22, E-9
SQL, 9-7
SQL statements, 9-8, 9-15
statement CREATE TABLE, 1-5
stored procedures, 8-6, 9-4, 9-7
subsystem name, 5-6
tables, 8-16, 9-12
VARCHAR data type, 9-12, 9-18
DB2 gateway plan binding
binding the DB2 gateway plan, 5-15
DB2 package
binding of, 5-12
DB2 Server, 1-8
DB2 Universal Database (UDB), 1-8
DB2AUTH, 5-8
exit, 7-9
for DB2 connection exit, 5-8
member, 7-9
security considerations, 7-5
DB2CAP (sidENV variable), 5-25
DB2DESCTAB (sidENV variable), 5-23
DB2I bind jpackage panel, 5-13
DB2IND sample DB2 stored procedure, G-1
DB2LONGMSG (sidENV variable), 5-23
DB2PLAN (sidENV variable), 5-25
DB2READONLY
parameter, 8-6
DB2READONLY (sidENV variable), 5-24
DB2SSN (sidENV variable), 5-25
DB2STATS (sidENV variable), 5-24
DB2WARNING (sidENV variable), 5-24
DBA_DB_LINKS data dictionary view, 8-3
DBCS support, 9-18
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 9-8
DCL
DD basic tables, known restrictions, 2-4
DD statement
NET8LOG, 6-7
STEPLIB, 6-7
DD statements, 5-32
ORA$ENV, C-3
SYSMDUMP, 5-37
DDL statement, 9-8
debugging messages, 5-7
DECODE SQL function, F-1
DEDICATED_TCB, 5-18
DEDTCB, 5-18
default
record types for SMF, D-3
DEFINE command
supported definition command, B-3
DEFINE SERVICE, OSDI command, B-5
DEFINE SERVICEGROUP, OSDI command, B-3
definition
gateway service, 5-30
definition commands, B-3
DELETE
clause, 9-20
command, 9-21
SQL clause, 9-16
DFLTLIST member, A-2
dictionary mapping, 1-4
disk
space requirements, 3-2
disk unit specification, 4-7
DISPLAY LONG, OSDI command, 6-12
DISPLAY, OSDI command
defined, B-12
with Oracle Net service, 6-12
distributed
DB2 transactions, 8-8
queries, 8-7, 8-8
distribution
media
data set names, 3-5
tape, 3-5
documentation
errors, 10-7
DRAIN, OSDI command
defined, B-13
preventing network connections, 6-12
DROP DATABASE LINK statement, 8-3
DSN0, default DB2 subsystem name, 5-6
DSN3@ATH exit, 5-8
DSN510 high-level qualifier for DB2 load libraries, 5-6
DSNEXIT load library, 5-6
DSNR security class, 5-7
DSNXVDTX, 5-8
DSNXVDTX DB2 date exit information, 5-8
DSPRT library, A-2
dump data sets, 5-37
DUMP SQL functions, F-1

E

EBCDIC tables, known restrictions, 2-4
EMPTYSTR_TO_NULL_OFF (sidENV variable), 5-28
enclave SRB
Oracle Net architecture, 6-3
encryption, ASO, 6-12
environment
heterogeneous, 8-8
operational, 10-6
security, 7-5
UNIX, 8-4
variables
DB2READONLY parameter, 8-6
EPLPA, moving modules into, 5-36
error
12660, 6-12
JCL error associated with missing libraries, 4-14
message traffic to the console, 6-11
messages for network region JCL, 6-7
ORA-12660, 6-14
ORA-2063, example message, 10-3
errors
diagnosing, 10-5, 10-7
incorrect output, 10-8
interpreting, 10-3
mapping, 10-2
messages, 10-1, 10-2
reporting
abends, 10-8
documentation, 10-5, 10-6, 10-7
GTF, 10-11
incorrect output, 10-8
Oracle database server error messages, 10-8
performance, 10-9
program check, 10-8
program loop, 10-9
sending tapes, 10-5
system dump data sets, 10-10
system dumps, 10-10
stored procedure, 10-4
EXECUTE
command, 1-6
exits
DB2
connection, 7-8
local date, 9-13, 9-14, 9-15
DB2AUTH, 7-9
G4AUTH, 7-9
gateway local date, 9-16
modules, 7-6
sample programs, 7-9
user, 7-5
EXP SQL function, F-1
extended pageable link pack area See EPLPA

F

FDS_CLASS_VERSION (sidENV variable), 5-24
features
9.0.1 gateway, 2-2
Oracle snapshot, 8-8
synonym, 8-6
fetch reblocking, 9-3
fields
PARMLIST, 9-6
SMFWCPU, 8-5
filenames
OSDI listener, 6-3
files
SPOOL, 5-37
SQLNET.ORA, 8-5
VSAM, 9-7
FLOOR SQL function, F-2
FLUSH_CACHE_ON_COMMIT (sidENV variable), 5-25
FOR BIT DATA option, 2-4, 9-12
FOR UPDATE clause, 9-19, 9-20
NOWAIT option, 9-20
FPS
sidFPS PARMLIB library member, 5-10
functions
COUNT, 9-21
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 9-8
KEEPALIVE, 8-4
MIN, 9-20
Oracle database server
AVG, 9-20
MAX, 9-20
MIN, 9-20
SUM, 9-20
TO_DATE, 9-20
ROWID, 9-17
SQL, 9-18
ABS, F-1
ACOS, F-1
ADD_MONTHS, F-1
advanced, 9-19
ASCII, F-1
ASIN, F-1
ATAN, F-1
ATAN2, F-1
AVG, 9-18
CEIL, F-1
CHAR_TO_ROWID, F-1
CHR, F-1
compatible, 9-18
compensated, 9-19
CONCAT, 9-18
CONVERT, F-1
COS, F-1
COSH, F-1
COUNT(*), 9-18
COUNT(DISTINCT expression), 9-18
DECODE, F-1
DUMP, F-1
EXP, F-1
FLOOR, F-2
GREATEST, F-2
HEXTORAW, F-2
INITCAP, F-2
INSTR, F-2
INSTRB, F-2
LAST_DAY, F-2
LEAST, F-2
LENGTH, F-2
LENGTHB, F-2
LN, F-2
LOG, F-2
LOWER, F-2
LPAD, F-2
LTRIM, F-2
MAX, 9-19
MIN, 9-19
MOD, F-2
MONTHS_BETWEEN, F-2
NEW_TIME, F-2
NEXT_DAY, F-2
NLS_INITCAP, F-2
NLS_LOWER, F-1
NLS_UPPER, F-1
NLSSORT, F-1
POWER, F-1
RAWTOHEX, F-1
REPLACE, F-1
ROUND, F-1
ROWIDTOCHAR, F-1
RPAD, F-1
RTRIM, F-1
SIGN, F-1
SIN, F-1
SINH, F-1
SOUNDEX, F-1
SQRT, F-1
STDDEV, F-1
SUBSTR, F-2
SUBSTRB, F-2
SUM, 9-19
SYSDATE, F-2
TAN, F-2
TANH, F-2
TO_CHAR, F-2
TO_DATE, F-2
TO_LABEL, F-2
TO_MULTI_BYTE, F-2
TO_NUMBER, F-2
TO_SINGLE_BYTE, F-2
TRANSLATE, F-2
translated, 9-19
TRUNC, F-2
UID, F-2
UPPER, F-2
USER, F-2
USERENV, F-2
VARIANCE, F-2
VSIZE, F-2
SUM, 9-20
TO_DATE, 9-15, 9-16

G

G4AUTH
exit, 7-9
for DB2 logon exit, 5-7
sample user exit, 7-5
G4DB2PLN
DB2 plan name, 5-6
G4sid, 5-32
gateway
advantages
migration and coexistence, 1-7
multisite transactions, 1-7
security, 1-8
site autonomy, 1-7
two-phase commit, 1-7
architecture, 1-8
components, 1-8
DB2 server, 1-8
Oracle database server, 1-8
configuration, C-3
CPU time, 8-5
development applications, 9-2
how it works, 1-9
local date exit, 9-16
messages, 10-4
MPM, 7-2
protection of current investment, 1-8
security, 7-4, 7-5
authorization id, 7-5
DB2AUTH exit, 7-8
Oracle user exit facility, 7-5
SAF router, 7-5
sample exit programs, 7-9
secondary authorization id, 7-5
specifying an exit module, 7-6
gateway configuration, 5-3
gateway messages, format explained, 10-3
gateway region parameters (sidPARM), 5-18
gateway service
opening a, 11-5
gateway service DEFINE parameters, 5-30
gateway service definition, 5-30
gateway service, configuring a, 11-4
GETHOSTBYNAME API, Oracle Net IBM TCP/IP HPNS, 6-8
GREATEST SQL function, F-2
GTF, 10-11

H

heterogeneous replication
STREAMS, 2-3
HEXTORAW SQL function, F-2
high-level qualifier, 4-22
choosing data set name qualifiers, H-2
data set name qualifier rules, H-3
INDEX parameter, 4-6
HPNS interface, 11-7
HS initialization parameters, 5-28
HS_OPEN_CURSORS
parameter, 8-5
HS_RPC_FETCH_REBLOCKING
parameter, 9-3
HS_RPC_FETCH_SIZE
initialization parameter, 3-2
parameter, 9-3

I

IBM DATE
column, 9-13
data type, 9-13
IBM maintenance, 3-3
IEAAPFxx member, 4-22
IEASYSnn member, 4-22
IEBUPDTE utility, 4-22
incompatibilities, release, 11-7
incorrect output errors, 10-8
INIT_SESSIONS, 5-19
INIT_STACK_SIZE, 5-19
INITCAP SQL function, F-2
initialization
parameters
HS_RPC_FETCH_SIZE, 3-2
INITSESS, 5-19
INSERT
clause, 9-20
command, 8-15
SQL clause, 9-16
statement, 10-5
installation
before starting the gateway, 4-22
checking distribution kit, 3-5
jobs, 4-13
post installation steps, 5-36
INSTR SQL function, F-2
INSTRB SQL function, F-2
interface, Oracle array processing, 9-2
Internet support, 1-4
Intranet support, 1-4
INTSTKSZ, 5-19
IPL
avoiding IPL after job ORIJC00, 4-14
IPLing OS/390, 4-14, 4-22
isolation level, 5-17
ISPCLIB
library, A-2
ISPF
EDIT, 4-22
ISPF profile files
selecting, 5-3
ISPSLIB
library, A-2
ISPTLIB library, A-2
IXCF support, 11-7

J

JCL
DB2 bind, 9-7
define an ALIAS before loading the installation JCL, H-2
errors associated with missing libraries, 4-14
loading Oracle installation JCL, 4-3
MPM startup, 5-37
ORAFMT sample, D-10
running generated installation jobs, 4-13
suffix for Oracle JCL procedures, 4-12
JCL, gateway instance, 11-4
JCL, network region, 6-6
job
job to load the installation JCL, 4-3
ORDJA01, 5-10
ORIJB00, 4-14
ORIJC00, 4-14
OSPIJA00 job parameters, 4-6
JOBNAME (gateway service DEFINE parameter), 5-31
JOBNAME parameter, 4-11, 5-9
jobs
sidJC02, 5-7
JOIN capability, 1-3

K

Katakana DB2 support, 9-18
KEEPALIVE
function, 8-4, 8-5
Oracle Net, 8-5
keyword abbreviations, OSDI command, B-15
known problems, 2-4
known restrictions, 2-4
ASCII and EBCDIC character sets, 2-4
binary literal notation, 2-4
DB2
plan, 2-4
DD basic tables and views, 2-4
literal values, 2-4
OCI, 2-5
Oracle database server SQL, 2-5
precompiling, 2-5
RAW data, 2-5
savepoints, 2-6
SQL, 2-5

L

Language Environment runtime library (LE)
Oracle Net, 6-8
LAST_DAY SQL function, F-2
LDAP.ORA file, sample, 6-10
LEAST SQL function, F-2
LENGTH SQL function, F-2
LENGTHB SQL function, F-2
libraries
AUTHLOAD, 4-22, 4-23
authorized, 4-22
CMDLOAD, 5-37
DSNEXIT, 5-6
DSPRT, A-2
ISPCLIB, A-2
ISPSLIB, A-2
ISPTLIB, A-2
load, 4-22
PARMLIB, 8-5
SRCLIB, 7-9
SYS1.PARMLIB, 4-22, 4-23
link pack area See LPA
linkage conventions
SIMPLE, 9-7
SIMPLE WITH NULLS, 9-7
linklist library, system
job ORIJC00, 4-14
listener
OSDI, See OSDI listener
listener architecture, 6-2
LN SQL function, F-2
load library, authorizing, 4-22
LOCAL DB2 date format, 9-14
LOG SQL function, F-2
LOGDATA
structure, 7-9
LOGON_AUTH
LGNAUTH, 5-19
LONG
column, 8-16, 9-11
data type, 9-12
LOWER SQL function, F-2
low-level qualifier, 4-22
LPA, moving modules into, 5-36
LPAD SQL function, F-2
LTRIM SQL function, F-2
LUNAME column, 9-5

M

MACRO API interface, with Oracle Net, 6-8
managing threads, 8-4
mapping error messages, 10-2
MAX
option, 9-20
Oracle database server function, 9-20
SQL function, 9-19
MAX_SESSIONS, 5-19
MAXFILEPROC parameter, 6-8
MAXSESS, 5-19
MAXSOCKETS parameter, 6-8
member
BPXPRMxx, 6-8
OSPIJA00, loads ISPF libraries, 4-4
members
DB2AUTH, 7-9
DFLTLIST, A-2
IEAAPFxx, 4-22
IEASYSnn, 4-22
ORAFMTCL, D-8
ORAFMTGO, D-8
PARMLIB, 7-6
PROGxx, 4-22
SHIPLIST, A-2
sidENV, 8-5
SMFPRMxx, D-2
message
CSV210I, job ORIJC00, 4-14
messages, 10-2
debugging, 5-7
error, 10-1
format, 10-3
gateway, 10-2
generated by gateway, 10-4
mapped, 10-2
ORA-2025, 8-9
ORA-2070, 2-6
ORA-9100, 10-2
Oracle database server, 10-8
stored procedure, 10-4
migrating from MPM
cautions, 11-4
MIN
option, 9-20
Oracle database server function, 9-20
SQL function, 9-19
missing functionality, 10-10
Mobile Agents, 1-4
MOD SQL function, F-2
MODIFY (F), OS/390 command
communicating with a running Oracle Net service, 6-11
MONTHS_BETWEEN SQL function, F-2
MPM
operation, 7-2
startup JCL, 5-37
STEPLIB, 7-6
SYSABEND for startup, 5-37
SYSUDUMP for startup, 5-37
MPM commands
DISPLAY EXIT, 7-6
gateway operation, 7-2
MPM messages, obsolescence of, 11-3
MPM parameters
gateway subsystem, 7-2
MPM to OSDI migration, 11-7
MPM, compared to OSDI, 11-2
MPM/TNS coexistence, 11-10
multiple gateway services, configuring, 11-9

N

Net service
See OSDI listener
NET8LOG DD statement, 6-7
network service
configuring, 11-6
operating, 11-6
OSDI, 11-2
NEW_TIME SQL function, F-2
NEXT_DAY SQL function, F-2
NLS
DB2 configuration, C-4
NLS_DATE_FORMAT
parameter, 9-15
NLS_DATE_FORMAT (sidENV variable), 5-26
NLS_INITCAP SQL function, F-2
NLS_LANG
parameter, C-3
specification, C-2
NLS_LANG (sidENV variable), 5-26
NLS_LOWER SQL function, F-1
NLS_NCHAR (sidENV variable), 5-26
NLS_UPPER SQL function, F-1
NLSSORT SQL function, F-1
NOTIFY parameter, 4-11, 5-9
NOWAIT option, 9-20
numeric data types, 9-17

O

OCI, 2-5, 9-7, 10-3
OPEN_LINKS parameter, 8-4
operator initiated dumps, 10-11
options
AVG, 9-20
FOR BIT DATA, 9-12
MAX, 9-20
MIN, 9-20
NOWAIT, 9-20
SUM, 9-20
TO_DATE, 9-20
OR@INST panel, 4-8, 5-4, H-4
OR@PRIM panel, 4-8, 5-4, H-3
ORA$ENV (DD statement), 5-32
ORA$ENV DD statement, C-3
ORA_MAX_DATE (sidENV variable), 5-26
ORA-12660 error, 6-14
ORA-2025 message, 8-9
ORA-2063, example error message, 10-3
ORA-2070 message, 2-6
ORA-9100 message, 10-2
Oracle Advanced Security Option
See ASO
Oracle Call Interface See OCI
Oracle database server
data type, 9-13
DATE columns, 9-14
dump data sets, 5-37
functions
AVG, 9-20
MAX, 9-20
MIN, 9-20
SUM, 9-20
TO_DATE, 9-20
subsystem
accounting information, D-1
error reporting, 10-8
resource usage, D-1
statistics, D-1
triggers, 8-9
user exit facility, 7-5
Oracle Developer, 1-6
Oracle Discoverer, 1-6
Oracle distribution libraries
job ORIJB00, 4-14
Oracle libraries
creating, 4-4
Oracle Net
IBM TCP/IP
requirements, 3-5
KEEPALIVE function, 8-5
OSDI listener, 6-2
overview, 6-2
Oracle net
requirements
resource, 3-2
Oracle Primary Option Menu panel, 4-13
Oracle Support Services, 10-5
ORACLE2PC table, 2-4, 8-8
Oracle9i database server
database triggers, 1-4
distributed query optimization, 1-3
stored procedures, 1-4
two-phase commit protection, 1-4
ORAFMT program for SMF, D-4, D-8
ORAFMTCL
member, D-8
sample JCL, D-8
ORAFMTGO
member, D-8
sample JCL, D-8
ORAIND sample DB2 stored procedure, G-3
ORARECID (sidENV variable), 5-25
ORDBIP90 panel, 5-9
ORDJA01 job, 5-10
ORDSN panel, 4-12
ORDSNO panel, 4-12
ORGDIP10 panel, 5-5, 5-10
ORGDIP20 panel, 5-6, 5-7
ORGDIP35 panel, 5-8
ORGDIP40 panel, 5-8
ORGDIP50 panel, 5-9
ORGDJA01 panel, 5-10
ORIJB00 job, 4-14
ORIJC00 job, 4-14
ORINIP00 panel, 4-10, H-3
ORINIP15 panel, 4-11
ORINIP20 panel, 4-11
ORINIP25 panel, 4-12
ORINIP60 panel, 4-13
ORLANG panel, 4-11
ORNEWDB panel, 5-5, H-4
ORPRIM0 panel, 4-10, H-4
ORPRODS panel, 4-10
OS/390
commands
DUMP, 10-10
SLIP, 10-9
link pack areas, 5-37
operating system, supported releases, 3-3
operating system, supported versions, 3-2
OS/390 UNIX System Services (USS)
with network service, 6-8
OSDI
command
keyword abbreviations, B-15
DEFINE SERVICE command, 5-10
listener, 6-2
START command, 5-10
subsystems, 11-2
upgrade or migration to, 11-8
OSDI command verbs, 7-3
OSDI commands
access to, 7-2
OSDI DEDICATED_TCB, 5-18
OSDI DEFINE SERVICE, 5-30
OSDI listener
configuration, 6-4
DEFINE parameters, 6-5
OSDI listener architecture, 6-2
OSDI network service, 11-2
OSDSI
differences from MPM, 11-2
OSPIJA00 job, parameters, 4-6
OSPIJA00 member
member that loads ISPF libraries, 4-4
symbolic parameters in, 4-5
OTGDB2 userid, 5-6
OTGREGISTER view, 9-22, E-9

P

pageable link pack area See PLPA
panel
OR@INST, 4-8, 5-4, H-4
OR@PRIM, 4-8, 5-4, H-3
Oracle Primary Option Menu, 4-13
ORDBIP90, 5-9
ORDSN, 4-12
ORDSNO, 4-12
ORGDIP10, 5-5, 5-10
ORINIP00, 4-10, H-3
ORINIP15, 4-11
ORINIP20), 4-11
ORINIP25, 4-12
ORINIP60, 4-13
ORLANG, 4-11
ORNEWDB, 5-5, H-4
ORPRIM0, 4-10, H-4
ORPRODS, 4-10
panel ORGDIP20, 5-6, 5-7
panel ORGDIP35, 5-8
panel ORGDIP40, 5-8
panel ORGDIP50, 5-9
panel ORGDJA01, 5-10
parameter
ASO, setting for server, 6-13
configuration, resetting on server, 6-14
encryption, 6-13
job OSPIJA00, 4-6
JOBNAME, 4-11, 5-9
MAXFILEPROC, 6-8
MAXSOCKETS, 6-8
NOTIFY, 4-11, 5-9
REGION
network region JCL, 6-7
setting, for client, 6-13
parameters
DB2READONLY, 8-6
HS_OPEN_CURSORS, 8-5
HS_RPC_FETCH_REBLOCKING, 9-3
HS_RPC_FETCH_SIZE, 9-3
initialization
HS_RPC_FETCH_SIZE, 3-2
list for stored procedures, 9-6
MPM
startup, D-2
NLS_DATE_FORMAT, 9-15
NLS_LANG, C-3
OPEN_LINKS, 8-4
Oracle Net TNSNAMES SID, 2-3
READONLY, 8-6
SQLNET.EXPIRE_TIME, 8-5
stored procedures list, 9-6
PARM (gateway service DEFINE parameter), 5-31
PARMLIB
library, 8-5
member, 7-6
PARMLIB member
editing of, 5-18
PARMLIB members
DEDICATED_TCB, 5-18
INIT_SESSIONS, 5-19
INIT_STACK_SIZE, 5-19
LOGON_AUTH, 5-19
MAX_SESSIONS, 5-19
SERVER_LOADMOD, 5-18
SMF_STAT_RECNO, 5-20
TRACE_DSNAME, 5-20
PARMLIST field, 9-6
passthrough, 1-5, 8-6, 9-7, 9-8, 9-9
result sets, 9-8, 9-9
passthru See passthrough
PDS, A-2
performance
issues, 10-9
PLPA, 5-37
PLPA, moving modules into
PL/SQL, 9-7
call, 9-4
DB2, 9-7
routine, 1-6
standard Oracle, 1-6
POWER SQL function, F-1
Precompiler limitations, 2-5
PROC (gateway service DEFINE parameter), 5-31
PROCEDURE column, 9-5
procedures
error example for stored procedures, 10-4
native stored, 1-6
sample DB2 DB2IND, G-1
sample for DB2 ORAIND, G-3
stored, 1-4, 1-5, 8-6, 9-4
processing SQL, 9-19
product set, 2-2
program loop, 10-9
PROGxx member, 4-22
protection of investment, 1-8
protocols
commit confirm, 1-7
PTFs, 3-3

Q

queries, distributed, 8-7

R

RACF
with network service, 6-8
RAW
columns, known restrictions, 2-4
data type, 9-18
data, known restrictions, 2-5
format, 9-18
RAWTOHEX SQL function, F-1
RECO user ID, 5-5
recording SMF information, D-2
reentrant modules, moving to EPLPA
REGION parameter, 6-7
REPLACE SQL function, F-1
replication, 8-8
requirements
CPU, 3-2
disk space, 3-2
IBM DB2, 3-4
ISMF, 3-4
Oracle Net, 3-2, 3-4
REXX, 3-4
virtual memory, 3-2
resource usage, D-1
RESUME command
defined, B-13
Oracle Net, 6-12
RMODE linkage, 5-36
ROUND SQL function, F-1
routines
PL/SQL, 1-6
ROWID
column, 9-17
DELETE, 9-17
restrictions, 9-17
snapshots, 9-17
UPDATE, 9-17
WHERE CURRENT OF CURSOR clause, 9-17
function, 2-5, 9-17
ROWIDTOCHAR SQL function, F-1
RPAD SQL function, F-1
RTRIM SQL functions, F-1

S

SAF
calls, 5-7
considerations, 7-5
router, 7-5
savepoints, known restrictions, 2-6
scripts
SQL DD, 2-4
secondary authorization id, 7-5
second-level qualifier, data set name qualifier rules, H-3
security, 5-7
advanced, 1-4
ANO, 1-4
class, 5-7
encryption, 1-4
for gateway, 7-4, 7-5
SAF router considerations, 7-5
specifying an exit module, 7-6
user exit, 7-5
Security Authorization Facility See SAF
SELECT
result column list, 9-20
statement, 8-6, 9-3, 9-19, 9-20
SELECT FOR DELETE clause, 9-20
SELECT FOR INSERT clause, 9-20
SELECT FOR UPDATE clause, 9-20
SELECT WHERE SQL clause, 9-16
SELECT_CONCAT_ON (sidENV variable), 5-28
SERVER_LOADMOD, 5-18
service
definition commands, B-5
service group
definition commands, B-3
service group, definition of, 11-3
service name
gateway (DEFINE parameter), 5-30
session connection, 8-1
SETPROG system command, 4-22, 4-23
SETSSI system command, 4-22, 4-23
setting of, 5-17
SHIPLIST member, A-2
SHOW SERVICE, OSDI command, B-10
SHOW SERVICEGROUP, OSDI command, B-5
SHOW, OSDI command, B-3
sid
gateway instance, 11-4
SID (gateway service DEFINE parameter), 5-31
sidENV
HS initialization parameters, 5-28
sidENV member, 8-5
sidENV parameters, 5-21
sidJC00 job, 5-10
sidJC01 and sidJC01
configuration, 5-11
sidJC02 job, 5-7
sidJD00 job, 5-15
sidPARM, 5-18
SIGN SQL function, F-1
SIMPLE linkage convention, 9-7
SIMPLE WITH NULLS linkage convention, 9-7, G-1
SIN SQL function, F-1
SINH SQL function, F-1
SITEINFO file, 6-8
SLIP command, 10-9
SMF
abends, D-3
abnormal terminations, D-3
activating, D-2
commands
SETSMF, D-3
default record types, D-3
interpreting records, D-3
ORAFMT program, D-4, D-8
record type, specifying, D-2
recording
starting, D-3
stopping, D-3
records, D-1
records, interpreting, D-3
sample formatting program, D-8
starting dynamically, D-3
types of users, D-2
user-defined data section, D-8
when records are written, D-3
SMFAUTH authorization id, D-6, D-9
SMFPRMxx member, D-2
SMFWCPU field, 8-5
snapshots, 9-17
complete refresh, 8-15
CREATE SNAPSHOT command, 8-15
Oracle snapshot feature, 8-8
SNS/TCPaccess, 11-7
software requirements, 3-2
IBM maintenance, 3-3
OS/390 operating system, 3-3
SOUNDEX function, F-1
specifying
SMF record type, D-2
SPOOL
file, 5-37
space, 5-37
SQL, 1-5
ANSI standard, 1-5
clauses
DELETE, 9-16
INSERT, 9-16
SELECT WHERE, 9-16
UPDATE, 9-16
commands, 8-2
constructs, Oracle-specific, 9-19
DB2, 9-7
DD script, 2-4
functions, 9-18, F-1
ABS, F-1
ACOS, F-1
ADD_MONTHS, F-1
advanced, 9-19
ASCII, F-1
ASIN, F-1
ATAN, F-1
ATAN2, F-1
AVG, 9-18
CEIL, F-1
CHAR_TO_ROWID, F-1
CHR, F-1
compatible, 9-18
compensated, 9-19
CONCAT, 9-18
CONVERT, F-1
COS, F-1
COSH, F-1
COUNT(*), 9-18
COUNT(DISTINCT expression), 9-18
DECODE, F-1
DUMP, F-1
EXP, F-1
FLOOR, F-2
GREATEST, F-2
HEXTORAW, F-2
INITCAP, F-2
INSTR, F-2
INSTRB, F-2
LAST_DAY, F-2
LEAST, F-2
LENGTH, F-2
LENGTHB, F-2
LN, F-2
LOG, F-2
LOWER, F-2
LPAD, F-2
LTRIM, F-2
MAX, 9-19
MIN, 9-19
MOD, F-2
MONTHS_BETWEEN, F-2
NEW_TIME, F-2
NEXT_DAY, F-2
NLS_INITCAP, F-2
NLS_LOWER, F-1
NLS_UPPER, F-1
NLSSORT, F-1
POWER, F-1
RAWTOHEX, F-1
REPLACE, F-1
ROUND, F-1
ROWIDTOCHAR, F-1
RPAD, F-1
RTRIM, F-1
SIGN, F-1
SIN, F-1
SINH, F-1
SOUNDEX, F-1
SQRT, F-1
STDDEV, F-1
SUBSTR, F-2
SUBSTRB, F-2
SUM, 9-19
SYSDATE, F-2
TAN, F-2
TANH, F-2
TO_CHAR, F-2
TO_DATE, F-2
TO_LABEL, F-2
TO_MULTI_BYTE, F-2
TO_NUMBER, F-2
TO_SINGLE_BYTE, F-2
TRANSLATE, F-2
translated, 9-19
TRUNC, F-2
UID, F-2
UPPER, F-2
USER, F-2
USERENV, F-2
VARIANCE, F-2
VSIZE, F-2
ISO standard, 1-5
limitations, 2-5
passthrough, 8-6, 9-7, 9-8, 9-9
statements, 8-7, 9-2
DB2, 9-8, 9-15
passing through gateway, 9-7
SQL*Plus, 1-6
commands
COPY, 8-9, 8-10
DELETE, 9-21
INSERT, 8-9
SQLID, secondary id, 5-8
SQLNET.EXPIRE_TIME parameter, 8-5
SQLNET.ORA file, 8-5
SQRT SQL function, F-1
SRB (service request block)
Oracle Net architecture, 6-3
SRCLIB
library, 7-9
SRVRLMOD, 5-18
START
OSDI command
defined, B-11
starting Oracle Net service, 6-10
START command, 7-2
statements
ALTER SESSION CLOSE DATABASE LINK, 8-3
CONNECT TO, 8-3
CREATE DATABASE LINK, 8-2
DB2 CREATE TABLE, 1-5
DDL, 9-8
DROP DATABASE LINK, 8-3
INSERT, 10-5
ORA$ENV DD, C-3
SELECT, 8-6, 9-3, 9-19, 9-20
SQL, 8-7, 9-2
DB2, 9-8, 9-15
passing through gateway, 9-7
SYSMDUMP DD, 5-37
STDDEV SQL function, F-1
STEPLIB DD statement
Oracle Net region JCL, 6-7
STOP
OSDI command, 6-11
defined, B-14
STOP (P) OS/390 System command, 6-11
STOP command, 7-2
storage requirements, 3-2
stored procedures, 1-4, 1-5
AUTHID column, 9-5
creating on DB2, 9-4
DB2, 8-6, 9-4, 9-7
CURRENT SERVER value, 9-5
PROC1, 9-5
using, 9-4
DB2IND, G-1
error message, 10-4
executing, 9-5
LUNAME column, 9-5
native DB2, 1-6
Oracle, 1-6
Oracle database server
local instance, 9-3
PL/SQL, 9-3
remote instance, 9-3
using, 9-3
ORAIND, G-3
parameter list, 9-6
PROCEDURE column, 9-5
SYSPROC qualifier, 9-6
SYSPROCEDURES catalog table, 9-5
two-phase commit processing, 9-4
stored procedures in DB2, gateway features, 2-2
Streams Heterogeneous Replication, 2-3
SUBSTR SQL function, F-2
SUBSTRB SQL function, F-2
SUM
option, 9-20
Oracle database server function, 9-20
SQL function, 9-19
support
sending tapes, 10-5
synonym feature, 8-6
SYS1.PARMLIB
library, 4-22, 4-23
SYSABEND for MPM startup, 5-37
SYSDATE SQL function, F-2
SYSIBM.SYSPROCEDURES DB2 catalog table, 9-5
SYSMDUMP DD statement, 5-37
SYSOUT
data set, 5-37
SYSPROCEDURES catalog table, 9-5, 9-6
system
dump data sets, 10-10
requirements
resource, 3-2
software, 3-2
SYSUDUMP for MPM startup JCL, 5-37

T

TABLE_PRIVILEGES view, E-10
tables
ASCII, 2-4
DB2, 2-4, 8-16, 9-11, 9-12
EBCDIC, 2-4
ORACLE2PC, 2-4, 8-8
SYSIBM.SYSPROCEDURES DB2 data dictionary, 9-7
SYSPROCEDURES, 9-5
TAN SQL functions, F-2
TANH SQL function, F-2
tape
contents, 3-5
TARGET (sidENV variable), 5-25
TCB, 7-9
TCP/IP
KEEPALIVE, 8-5
TESTAUTH link, 5-7
threads
canceling, 8-5
managing, 8-4
TIME data type, 9-13
time operations, 9-12
TIMESTAMP data type, 9-13
TNS
connect descriptor, 8-2
TNS facility, 11-2
TNS messages, obsolescence of, 11-3
TNSNAMES SID
parameter, 2-3
TNSNAMES.ORA
connect descriptor, 8-2
TO_CHAR
SQL function, F-2
TO_DATE
clause, 9-16
function, 9-14, 9-15, 9-16
option, 9-20
Oracle database server function, 9-20
SQL function, F-2
TO_LABEL function, F-2
TO_MULTI_BYTE SQL function, F-2
TO_NUMBER SQL function, F-2
TO_NUMBER_OFF (sidENV variable), 5-27
TO_SINGLE_BYTE SQL function, F-2
Trace Files
OSDI, 11-3
TRACELEVEL (sidENV variable), 5-27
TRANSLATE SQL function, F-2
translated SQL function, 9-19
TRCASST, Oracle Net utility program, 6-12
triggers, 8-8
database, 1-4
DB2 server, 8-9
Oracle database server, 8-9
TRUNC SQL function, F-2
two-phase commit, 1-4, 8-8
TYPE (gateway service DEFINE parameter), 5-31

U

UID SQL function, F-2
UNION capability, 1-3
UNIX environment, 8-4
UPDATE SQL clause, 9-16
UPPER SQL function, F-2
USER
SQL function, F-2
user
exit module, 7-6
record type, D-2
USER_CATALOG view, E-10
USER_COL_COMMENTS view, E-11
USER_CONS_COLUMNS view, E-11
USER_CONSTRAINTS view, E-11
USER_DB_LINKS data dictionary view, 8-3
USER_INDEXES view, E-12
USER_OBJECTS view, E-13
USER_SYNONYMS view, E-13
USER_TAB_COLUMNS view, E-14
USER_TAB_COMMENTS view, E-14
USER_VIEWS view, E-16
USERENV function, F-2
userids
CONNECT TO, 8-3
OTGDB2, 5-6
using
the data dictionary, 9-22
USING clause, 8-2
USS (OS/390 UNIX System Services)
with network service, 6-8
utilities
IEBUPDTE, 4-22

V

VALUES clause, 9-16
VARIANCE SQL function, F-2
views
catalog for DB2, 9-22
data dictionary, 9-22
ALL_CATALOG, E-2
ALL_COL_COMMENTS, E-2
ALL_CON_COLUMNS, E-3
ALL_CONSTRAINTS, E-3
ALL_DB_LINKS, 8-3
ALL_IND_COLUMNS, E-4
ALL_INDEXES, E-4
ALL_OBJECTS, E-5
ALL_SYNONYMS, E-6
ALL_TAB_COLUMNS, E-6
ALL_TAB_COMMENTS, E-7
ALL_TABLES, E-7
ALL_USERS, E-8
ALL_VIEWS, E-9
COLUMN_PRIVILEGES, E-9
DBA_DB_LINKS, 8-3
OTGREGISTER, 9-22, E-9
TABLE_PRIVILEGES, E-10
USER_CATALOG, E-10
USER_COL_COMMENTS, E-11
USER_CONS_COLUMNS, E-11
USER_CONSTRAINTS, E-11
USER_DB_LINKS, 8-3
USER_INDEXES, E-12
USER_OBJECTS, E-13
USER_SYNONYMS, E-13
USER_TAB_COLUMNS, E-14
USER_TAB_COMMENTS, E-14
USER_VIEWS, E-16
virtual memory requirements, 3-2
volume serial number specification, 4-6
volume unit specification, 4-7
VSAM
file, 9-7
VSIZE SQL function, F-2

W

WE8EBCDIC37C with NLS, C-5
WHERE clause, 8-15, 9-19, 9-20
WHERE CURRENT OF CURSOR clause, 9-17
wireless communication, 1-4
Workload Manager (WLM)
Oracle Net for OS/390 architecture, 6-3

Go to previous page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents