Go to main content
28/28
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
A
access method transparency (introduction),
1.3.1
accessing
DRDA Servers,
10.9
gateway,
10.8
action items of Oracle Universal Installer,
4.6.4
Advanced Security
CHECKSUM command,
9.5
encryption
export encryption algorithms,
9.5
international version types supported,
9.6
resetting configuration parameters on gateway,
9.7.2
setting test parameters for gateway,
9.6.1
setting test parameters for Oracle integrating server,
9.6.2
setting up for test,
9.6
testing gateway and Oracle integrating server,
9.7.1
function on the gateway,
1.3.3
test error
error 12660,
9.6
testing advanced security encryption,
9.7.1
AGW ADD USERID command,
13.5.1.2
AGW DELETE USERID command,
13.5.1.2
AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME,
C.4.17
alias
DB2,
C.4.9
objects, DB2, known restrictions,
2.5
ALL_CATALOG view,
A.2.1
ALL_COL_COMMENTS view,
A.2.2
ALL_CON_COLUMNS view,
A.2.3
ALL_CONSTRAINTS view,
A.2.4
ALL_DB_LINKS data dictionary view,
11.1.4
ALL_INDEXES view,
A.2.5
ALL_OBJECTS view,
A.2.7
ALL_SYNONYMS view,
A.2.8
ALL_TAB_COMMENTS view,
A.2.11
ALL_TABLES view,
A.2.9
ALL_USERS view,
A.2.12
ALL_VIEWS view,
A.2.13
allocation mode, SNA session, DRDA_CMSRC_CM_IMMEDIATE,
C.4.7
ALTER session statement,
11.1.2
ANSI-standard SQL
gateway capabilities,
1.3.5
heterogeneous database integration,
1.9.10
API (application program interface), Oracle Net,
9.3
APPC
concurrent connections,
3.1.2
configuring another profile,
10.9
database link behavior,
12.4
DB2/VM,
13.5.1.2
mode definition,
6.4.3.6
password length,
15.3
user ID length,
15.3
APPC VTAM Support (AVS)
also see AVS,
13.5.1.2
mapping user ID,
2.5.1
APPEND command
supported by COPY,
11.8
application
application program interface defined, see API,
9.3
authenticating logons,
13.2
development on the gateway,
1.9.16
portability,
1.9.13
server support,
1.3.3
architecture of the gateway,
1.5
array size
fetch reblocking,
1.9.3
how determined,
12.1.1
AS/400
command DSPRDBDIRE,
5.3.4
configuring communications,
5.3.1
defining user ID,
5.3.2
library name, DRDA_PACKAGE_COLLID,
C.4.20
ASCII
code page,
D.3
sort order,
12.6.2
tables, known restrictions,
1.9.21
translated from EBCDIC,
12.7.1
US7ASCII,
D.3.2.1
US7ASCII, NLS,
D.2
authority
CONNECT,
13.5.1.2
execute,
13.5.1.2
autonomy, site,
1.3.14
AVS
also see APPC VTAM Support,
2.5.1
configuring,
5.5.1
DB2/VM,
13.5.1.2
mapping user IDs (DB2/VM),
2.5.1
user ID mapping,
13.5.1.2
B
binary data, non-character,
12.7.1
Bind Package Stored Procedure
DB2/400,
5.3.2
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
bind privilege
configuration worksheet,
E
DB2/400,
5.3.2
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
bind variables
native SQL passthrough,
12.8
restrictions,
2.5.2
BINDADD authority, binding packages on DB2/UDB,
10.4.5
BINDADD privilege
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
BINDAGENT privilege
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
binding the DRDA package
authority of user ID and password
DB2/400,
5.3.2
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
backward compatibility,
14.4
configuring the host,
10.4.4
on DB2/UDB,
10.4.5
upgrading from version 3,
10.4.5
bug
bugs fixed in release 10.1.0.2.0,
2.3
debugging
drc values used by Oracle Support Services,
15.1.3
setting trace parameters,
15.4
SQL tracing reduces gateway performance,
11.10
number 205538,
2.5.2
C
call
a CICS or IMS transaction,
12.3.2
DB2 stored procedure
DRDA Server definition,
12.3
look up in server catalog,
12.3.1
DRDA_DISABLE_CALL
default,
10.5.1.1
sample Gateway Initialization File,
B.1
empproc stored procedure,
12.3
Oracle Call Interface,
15.1
PL/SQL,
12.3.1
stored procedure
location transparency with synonym,
12.2
null values not passed,
2.5.1
using standard Oracle PL/SQL,
12.2
capabilities, DRDA server, native semantics,
12.6
CCSID
65535 as the default for all tables created,
C.4.8
CCSID (coded character set identifiers), defined,
D.5
code page mapping facility,
D.4
DRDA Server, NLS,
D.1
external mapping to supported Oracle character sets, Codepage Map Facility,
1.9.19
changed parameters,
14.3.2
changes in this release
IBM DB2 Version 5.1 EBCDIC and ASCII Tables,
1.9.21
IBM DB2/UDB supported,
1.9.20
read-only support,
1.9.22
CHARACTER SET
clause, client/server configuration,
D.2
parameter description,
D.1
character sets
and code page map facility,
D.4
ASCII, known restrictions,
1.9.21
codepage, DRDA_DEFAULT_CCSID specifies default CCSID,
C.4.8
EBCDIC, known restrictions,
1.9.21
supported, codepage map facility,
1.9.19
character strings
converting character string data types,
12.7.2
performing character string operations,
12.7.1
checklist
DRDA Server configuration,
5.1
gateway configuration,
10.1
gateway installation,
4.3
Oracle Net,
9.1
CHECKSUM command
also see Advanced Security,
1.3.3
Oracle Net, Advanced Security Encryption,
9.5
CICS transaction,
12.3.2
clauses
CHARACTER SET, client/server configuration,
D.2
CONNECT TO,
11.1.1
GROUP BY,
12.6.3
HAVING,
12.6.3
ORDER BY,
12.6.3
SQL
DELETE,
12.7.7
INSERT,
12.7.7
SELECT WHERE,
12.7.7
UPDATE,
12.7.7
TO_DATE,
12.7.7
USING,
11.1.1
VALUES,
12.7.7
WHERE
compatible for all versions of DRDA Server,
12.6.3
SQL limitations, Oracle ROWID column,
2.5.2
WHERE CURRENT OF CURSOR, ROWID column,
2.5.2
client, defined in gateway architecture,
1.5
code page map facility
for data translation,
D.4
code tracing,
C.4.41
codepage map facility
configuring support for character sets,
2.5.1
supported by gateway,
1.9.19
coercion of data, defined,
12.6
collection privilege - CREATE IN
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
collection privilege - CREATETAB, DB2/OS390,
5.2.2
column
date columns function,
12.7.7
Oracle ROWID,
2.5.2
supported in a result set,
1.9.8
commands
AGW ADD USERID,
13.5.1.2
AGW DELETE USERID,
13.5.1.2
CHECKSUM
advanced security,
1.3.3
supported by Oracle Net,
9.5
COPY
known restriction for INSERT,
2.5
SQL*Plus command,
11.8
CREATE DATABASE LINK,
5.5.2
EXECUTE,
1.3.9.1
EXPLAIN PLAN,
15.4.1
INSERT, known restriction,
2.5
commit confirm protocol,
1.3.13
Communication Database (CDB) tables, DDF,
5.2.5
communications requirements,
3.2.3
compatible SQL set operators and clauses,
12.6.3
concatenation restrictions,
2.5.1
concurrent connections
APPC,
3.1.2
TCP/IP,
3.1.2
configuring
additional DRDA Servers,
10.9
AS/400 communications,
5.3.1
AVS,
5.5.1
binding DRDA package,
10.5
checklist for gateway,
10.1
checklists for DRDA Server,
5.1
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
list of parameters needed to configure the gateway,
E
Oracle integrating server,
10.7
Oracle Net,
9.4
OS/390 (MVS) VTAM,
5.2.1
other Oracle servers,
10.8
SNA server, creating profiles,
6.3
,
7.3
TCP/IP
for AS/400,
5.3.1
for DB2/VM,
5.5.1
for MS Windows,
8.2
for OS/390,
5.2.1
VM VTAM on DB2/VM,
5.5.1
workstation for gateway,
10.4
CONNECT authority
binding packages on DB2/UDB,
10.4.5
DB2/UDB,
5.4.2
user ID mapping on DB2/VM,
13.5.1.2
CONNECT BY not supported, known restrictions,
2.5.2
CONNECT TO clause,
11.1.1
connection
definition,
6.4.3.4
testing,
6.5
,
7.5
conversion
data types,
12.7
errors,
C.4.8
convert
character string data types,
12.7.2
character string operations,
12.7.1
DATE,
12.7.4.2
floating point to integer,
12.7.8
inbound user ID,
13.5.1.2
into most suitable data type,
12.7.10
to the numeric data type,
12.7.8
converter, protocol,
1.3.3
COPY
copying data from the DRDA server,
11.9
copying data from the Oracle server,
11.8
privilege
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
SQL*Plus COPY command
Oracle server to DRDA server,
11.8
substituted for INSERT,
2.5
COS function,
12.5.3
COUNT function,
12.7.9
CPI-C routine,
15.1.4
CPI-C Symbolic Destination Names,
6.4.3.8
CREATE command, supported by COPY,
11.8
CREATE DATABASE LINK
command, binding package on DB2/VM,
5.5.2
statement, defining path to remote database,
11.1.1
CREATE DATABASE statement, client/server configuration,
D.2
CREATE IN privilege
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
CREATE PUBLIC DATABASE LINK privilege
binding the DRDA gateway package,
10.4.4
configuring Oracle integrating server,
10.7.1
CREATE TABLE statement,
1.3.8
CREATEIN privilege, DB2/UDB,
5.4.2
CREATETAB authority,
10.4.5
CREATETAB privilege
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
creating a database link,
11.1.1
cursor
defining the number of,
12.10
number of cursors, DRDA_PACKAGE_SECTIONS,
C.4.24
stability, DRDA_ISOLATION_LEVEL,
C.4.16
D
data coercion, defined,
12.6
data control language (DCL),
1.3.7
data definition language (DDL),
1.3.6
data dictionary
support,
10.5.2
using,
12.9.1
views
ALL_DB_LINKS,
11.1.4
considerations for migration from previous releases,
14.4
list and descriptions,
A.2
not supported for DB2/VM,
A.1
Oracle Emulation on DRDA Server,
12.9
supported for DB2/OS390, DB2/UDB, and DB2/400 servers,
A.1
USER_DB_LINKS shows defined database links,
11.1.4
data storage transparency (introduction),
1.3.1
data type
column (ALL_TAB_COLUMNS),
A.2.10
column (USER_TAB_COLUMNS),
A.2.26
conversion
between Oracle and DRDA,
1.7
control over,
12.7.8
converting character string data types,
12.7.2
gateway mapping and restrictions,
12.7
performing character string operations,
12.7.1
date,
2.5.1
differences between Oracle server and DRDA databases,
12
DRDA Server data types list,
12.7
known restrictions,
2.5.1
mapping,
12.7
numeric
zoned decimal field,
12.7.10
Oracle data types RAW and LONG RAW,
12.7.1
performing character string operations,
12.7.1
restrictions,
12.7
size and value limitations,
12.7
supported by IBM DRDA,
12.7.4
supported by IBM DRDA databases,
12.7.4
data types
DATE, as calendar date only,
12.7.4
GRAPHIC,
12.7.3
LONG
converting character string data types,
12.7.2
known restrictions,
2.5.1
LONG RAW, translating ASCII to EBCDIC,
12.7.1
Oracle and IBM DATA data types are mapped to each other,
12.7.4.2
Oracle and IBM DATE,
12.7.4.2
processing TIME data types to Oracle DATE,
12.7.4.1
RAW
CCSID 65535,
C.4.8
translating ASCII to EBCDIC,
12.7.1
TIME, time of day only,
12.7.4
TIMESTAMP, combining calendar data and time of day,
12.7.4
VARCHAR,
12.7.2
database
authorities - CONNECT, BINDADD, and CREATETAB,
5.4.2
catalogs,
12.9
link
behavior,
12.4
binding DRDA gateway package,
10.4.4
creating,
11.1.1
defining and controlling,
13.3
dropping links,
11.1.3
examining,
11.1.4
guidelines,
11.1.2
limits,
11.1.5
processing,
11.1
public,
10.7.1
suffix,
12.1
to identify the gateway,
1.7
native tool,
10.5.2
triggers,
1.3.2
date
2 or 4 digits,
12.7.5
arithmetic, known restrictions,
2.5.1
columns function,
12.7.7
data types and DRDA server restriction,
2.5.1
data types supported by IBM DRDA,
12.7.4
date handling has two categories,
12.7.5
gateway local date exit for DB2 ISO format,
12.7.6
HS_NLS_DATE_FORMAT
parameter, date handling,
12.7.5
patterns,
12.7.6
operations,
12.7.4
statements, SELECT, INSERT, UPDATE, DELETE,
12.7.5
TO_DATE function
date handling,
12.7.5
preprocessed in SQL,
12.7.7
DATE data type
implementation,
12.7.4
processing DATE data,
12.7.4.2
DB_DOMAIN parameter,
2.5.1
DB2
02pcg.sql granting authority,
10.5.2.5
alias objects, known restrictions,
2.5
aliases, not compatible with DRDA_DESCRIBE_TABLE,
C.4.9
CICS, IMS,
12.3.2
data access,
1.3.9.1
Distributed Data Facility (DDF),
5.2.5
DRDA_DESCRIBE_TABLE compatibility,
C.4.9
IBM DB2 version 5.1 ASCII Tables,
1.9.21
native SQL,
1.3.8
native stored procedures,
1.3.9.2
procedural feature considerations,
12.3.2
SPUFI utility,
5.2.5
SQL statements,
12.8.2
statements, CREATE TABLE,
1.3.8
stored procedures, considerations for use,
12.3.2
with OS/390,
5.2
DB2/400
catalog view,
12.9.1
configuring the DRDA Server,
5.3
data dictionary views supported by gateway,
A.1
defining user ID,
5.3.2
DRDA_DEFAULT_CCSID,
C.4.8
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_OPTIMIZE_QUERY,
C.4.19
DRDA_PACKAGE_COLLID,
C.4.20
userid mapping, different capability,
13.5.1.3
DB2INS sample DB2 stored procedure,
G.1
DB2/OS390
catalog view,
12.9.1
configuring,
5.2
data dictionary views supported by gateway,
A.1
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_OPTIMIZE_QUERY,
C.4.19
userid mapping,
13.5.1.1
V6, V7 and V8 stored procedures supported,
1.9.18
with SPUFI,
10.5.2
DB2/UDB
catalog view,
12.9.1
configuring,
5.4
configuring the DRDA Server,
5.4
data dictionary views not supported,
A.1
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_OPTIMIZE_QUERY,
C.4.19
grant authority,
10.5.2.5
known restrictions,
2.5.1
ORACLE2PC table, binding packages,
10.5.1.2
supported, changes in this release,
1.9.20
userid mapping,
13.5.1.4
DB2/VM
catalog view,
12.9.1
configuring,
5.5
data dictionary views not supported,
A.1
database and SQL functions,
12.5.8
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_OPTIMIZE_QUERY,
C.4.19
DRDA_PACKAGE_OWNER,
C.4.23
instance, DRDA location name,
5.5.4
server machine,
13.5.1.2
userid mapping,
13.5.1.2
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function
limited to nonqueries,
12.8
native SQL passthrough,
12.8
syntax,
12.8.2
DD basic tables, known restrictions,
2.5.1
DDF
subsystem,
5.2.1
DDL statement
native SQL passthrough,
12.8
number of rows affected,
12.8.2
debugging
error codes,
15.1.3
SQL tracing,
15.4
your application,
11.10
de-installing the gateway,
4.7.1
DELETE
known restrictions,
2.5.2
operation,
12.1
SQL clause,
12.7.7
statement
dates,
12.7.5
native SQL passthrough,
12.8
transaction semantics,
1.7.1
with read-only gateway,
11.6
Dependent LU,
6.3.1
,
7.3.1
DESCRIBE
character string operations,
12.7.1
diagnostic parameter,
C.4.39
dictionary
mapping,
1.3.4
tables,
12.9
DICTIONARY view,
A.2.15
disk space requirements,
3.1.4
distributed
applications, support for,
1.9.15
database,
9.3.2
distributed query optimizer (DQO), better performance of distributed queries,
11.5
operations, DB2,
5.2.5
processing,
9.3.1
queries
example of,
11.5.1
two-phase commit,
11.5.2
transaction, DRDA_RECOVERY_USERID,
C.4.27
distributed query optimizer (DQO), DRDA-specific parameters,
C.4.19
double-byte support,
D.5
DQO
also see distributed query optimizer,
11.5
DRDA-specific parameters,
C.4.19
drc error code,
15.1.3
DRDA
catalog,
12.9.2
database requirements,
3.2.2
defining number of cursors,
12.10
location name
for DB2/UDB instance,
5.4.4
for DB2/VM instance,
5.5.4
session security options,
13.5.1.1
DRDA Application Server Function,
1.9.12
DRDA Server
accessing,
10.9
capabilities, native semantics,
12.6
CCSID
character set to store data in DRDA database,
D.1
gateway code page map facility,
D.4
parameters needed for NLS,
D.1
character sets, known restrictions,
2.5.1
configuring
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
considerations for binding packages,
14.4
database link behavior,
12.4
functions, native semantics,
12.6
gateway architecture definition,
1.5
Hostname or IP Address (configuring TCP/IP, worksheet),
E
port number (TCP/IP),
8.1.1
Service Port Number (configuring TCP/IP, worksheet),
E
stored procedures, native to DRDA server,
12.3
DRDA_CAPABILITY parameter,
12.6
DRDA_CMSRC_CM_IMMEDIATE parameter, description,
C.4.7
DRDA_CODEPAGE_MAP parameter,
D.4
DRDA_COMM_BUFLEN parameter, description,
C.4.4
DRDA_CONNECT_PARM
(SNA format) parameter, description,
C.4.5
(TCP/IP format) parameter, description,
C.4.6
configuring IBM Communication Server,
7.4.1.2
configuring Microsoft SNA server or host server,
6.4.3.8
parameter
communication errors,
15.1.4
configuring the gateway for TCP/IP,
8.2
DRDA_DEFAULT_CCSID parameter, description,
C.4.8
DRDA_DESCRIBE_TABLE parameter
description,
C.4.9
known restrictions,
2.5
DRDA_DESCRIBE_TABLE=FALSE initialization parameter,
2.5
DRDA_DISABLE_CALL parameter
binding the DRDA gateway package,
10.5.1.1
description,
C.4.10
DRDA_FLUSH_CACHE parameter, description,
C.4.11
DRDA_GRAPHIC_LIT_CHECK parameter, description,
C.4.13
DRDA_GRAPHIC_PAD_SIZE parameter, description,
C.4.12
DRDA_GRAPHIC_TO_MBCS parameter, description,
C.4.14
DRDA_ISOLATION_LEVEL parameter, description,
C.4.16
DRDA_LOCAL_NODE_NAME parameter, description,
C.4.17
DRDA_MBCS_TO_GRAPHIC parameter, description,
C.4.18
DRDA_OPTIMIZE_QUERY parameter
description,
C.4.19
DQO capability turned ON and OFF,
11.5
DRDA_PACKAGE_COLLID parameter
description,
C.4.20
errors detected by server database,
15.1.5
DRDA_PACKAGE_CONSTOKEN parameter, description,
C.4.21
DRDA_PACKAGE_NAME parameter
description,
C.4.22
detecting errors,
15.1.5
value must be unique,
10.5.1.1
DRDA_PACKAGE_OWNER parameter, description,
C.4.23
DRDA_PACKAGE_SECTIONS parameter
description,
C.4.24
number of open cursors at IBM database,
12.10
DRDA_READ_ONLY parameter
description,
C.4.25
read-only gateway,
11.6
DRDA_RECOVER_USERID parameter
DB2/400,
5.3.3
DB2/OS390,
5.2.3
DRDA_RECOVERY_PASSWORD parameter
DB2/OS390,
5.2.3
,
5.3.3
DB2/UDB,
5.4.3
DB2/VM,
5.5.3
description,
C.4.26
DRDA_RECOVERY_USERID parameter
DB2/400,
5.3.3
DB2/UDB,
5.4.3
DB2/VM,
5.5.3
description,
C.4.27
DRDA_REMOTE_DB_NAME parameter, description,
C.4.28
DRDA_SECURITY_TYPE parameter, description,
C.4.29
DROP DATABASE LINK statement,
11.1.3
dropold.sql script,
10.5.2.2
DSPRDBDIRE command,
5.3.4
dynamic dictionary mapping,
1.3.4
E
EBCDIC
character set support,
D.3.2.1
code page,
D.3
DRDA server CCSID,
D.7
sort order,
12.6.2
tables, known restrictions,
1.9.21
translated to ASCII,
12.7.1
EMP
creating system-wide synonym for EMP file,
11.4
table,
11.8
empproc
stored procedure,
12.3
encryption
export encryption algorithms,
9.5
types for Advanced Security,
9.6
environment
distributed,
12.2
heterogeneous, replicating in,
11.7
variable, NLS_LANG,
D.2
environmental variable
NLS_LANG,
D.1
ORA_NLS33,
D.1
errd
error array returned from DRDA server database,
15.1.5
example of translated, mapped error,
15.2
example, retrieving data,
11.2.3
errmc
(error tokens),
15.1.5
communication errors,
15.1.4
errmc field lists any error tokens,
15.1.3
example of translated, mapped error,
15.2
example, retrieving data,
11.2.3
error
12660 (test error for Advanced Security),
9.6
basic description,
15.1
change
ORA-09100 to ORA-28500,
15.1.3
ORA-09101 to ORA-28501,
15.1.3
codes
drc,
15.1.3
grc,
15.1.3
communication,
15.1.4
condition,
15.1
conversion,
C.4.8
date,
D.3.2.3
detected
by gateway,
15.1.2
by integrating Oracle instance,
15.1.1
by server database,
15.1.5
in DRDA software,
15.1.3
drc= field
-300xx,
15.3
-7xx,
15.3
HGO-00706,
15.1.2
host database,
15.3
interpreting error messages,
15.1
mapped sqlstate,
15.2
messages & codes, main chapter,
15
messages, Oracle LONG data type larger than 32740 bytes,
12.7.2
number, return code,
15.1
ORA-00001, index constraint violated,
15.2
ORA-00942
object does not exist,
15.2
object name too long,
15.2
ORA-01017, logon denied,
15.2
ORA-01031, insufficient privileges,
15.2
ORA-01460, invalid CCSID,
15.2
ORA-01476, divide by zero,
15.2
ORA-02019, undefined database link name is specified,
15.1.1
ORA-28500
was ORA-09100,
15.1.3
detected by server database,
15.1.5
example, collection ID or package name not recognized,
15.1.5
ORA-28501
was ORA-09101,
15.1.4
communication error,
15.1.4
Side Information Profile not defined,
15.1.4
ORA-28527, conversion errors,
C.4.8
ORA-9100 to ORA-9199, reserved for generic gateway layer,
15.1.1
Oracle error code for mapped errors,
15.2
server database,
15.1.5
specific error codes,
15.3
tokens listed by errmc for errors
detected by DRDA gateway,
15.1.3
detected by server database,
15.1.5
translation,
12.7.1
while binding the gateway package,
10.4.4
with Native Semantics,
12.6
errp
example, retrieving data,
11.2.3
,
15.1.3
,
15.1.5
,
15.2
EXCEPT set operator,
12.6.3
execute authority
DB2/400,
13.5.1.3
DB2/UDB,
13.5.1.4
DB2/VM,
13.5.1.2
on the gateway DRDA package,
13.5.1.2
EXECUTE command,
1.3.9.1
EXECUTE privilege
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
exits, gateway local date,
12.7.6
EXPLAIN PLAN command,
15.4.1
EXPLAIN_PLAN table, features of the gateway,
1.9.9
export encryption algorithms,
9.5
F
FDS_CLASS parameter, description,
C.4.30
FDS_CLASS_VERSION parameter, description,
C.4.31
FDS_INSTANCE parameter, description,
C.4.32
features of the gateway
main topic,
1.9
application development and end-user tools,
1.9.16
application portability,
1.9.13
columns supported in a result set,
1.9.8
distributed applications supported,
1.9.15
EXPLAIN_PLAN improvement,
1.9.9
fetch reblocking,
1.9.3
heterogeneous database integration,
1.9.10
heterogeneous services architecture,
1.9.1
large base of data access,
1.9.12
minimum impact on existing systems,
1.9.11
Native Semantics,
1.9.7
Oracle Database 10g passthrough supported,
1.9.4
Oracle snapshot,
11.7.2
performance enhancements,
1.9.2
remote data access,
1.9.14
retrieving result sets through passthrough,
1.9.5
support for TCP/IP,
1.9.6
fetch array size, with HS_FDS_FETCH_ROWS,
C.4.33
fetch reblocking
features of the gateway,
1.9.3
supported with HS_RPC_RETCH_REBLOCKING,
12.1.1
fetched date, ORA_MAX_DATE parameter, description,
C.4.37
fields
errmc, lists any error tokens,
15.1.3
errp, indicates program that detected error,
15.1.3
files
initsid.ora
invalid ORA_MAX_DATE specified,
15.3
parameter not recognized,
15.1.5
installation log file, verifying successful installation,
4.6.5
listener.ora
configure additional instance,
10.9
IPC key defined in,
9.4.2
member name,
11.3
sample
gateway initialization, tnsnames.ora, listener.ora,
B
listener.ora,
B.3
tnsnames.ora
configuring additional DRDA Server instance,
10.9
modifying the file,
9.4.2
VSAM,
12.3.2
FOR BIT DATA
DRDA_DEFAULT_CCSID,
C.4.8
indicates RAW or LONG RAW,
12.7.1
option,
12.7.1
free session, DRDA_CMSRC_CM_IMMEDIATE,
C.4.7
functions
COS,
12.5.3
COUNT,
12.7.9
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE,
12.8.2
DRDA server, native semantics,
12.6
GROUPBY,
12.6.2
HAVING,
12.6.2
ROWID, with UPDATE or DELETE,
2.5.2
SQL, SUBSTR,
12.6
SUBSTR
known restrictions,
2.5.1
TO_DATE
entering twenty-first century dates,
12.7.5
Oracle function, preprocessed in SQL,
12.7.7
processing DATE data,
12.7.4.2
WHERE,
12.6.2
G
g4ddtab.sql script,
10.5.2.3
g4ddview.sql script,
10.5.2.3
gateway
access,
10.8
advantages
migration and coexistence,
1.3.15
security,
1.3.16
server technology and tools,
1.3.11
site autonomy,
1.3.14
two-phase commit and multi-site transactions,
1.3.13
use of SQL,
1.2.1
application tools,
1.9.16
architecture,
1.5
benefits of integration with Oracle Database 10g server,
1.3.3
configuration,
10.3
definition of terms,
1.4
de-installing,
4.7.1
features, main topic,
1.9
gateway and Oracle integrating server not on same host,
1.5
installing,
4.6
interface function,
1.7
local date exit,
12.7.6
logging, LOG_DESTINATION,
C.4.36
migration problems, backout considerations,
14.2
parameter,
5.5.4
performance,
12.6
performance enhancements,
1.9.2
service name entries in the tnsnames.ora,
14.5
SQL differences,
1.7.1
stored procedures (Oracle and non-Oracle),
1.3.9
supported languages
CCSID,
D.1
codepage map facility,
D.4
tracing
LOG_DESTINATION,
C.4.36
SQL statements,
11.10
Gateway Initialization File
parameter
list,
C.4
new since V4 gateway,
14.3.1.1
reported errors,
10.4.4
sample,
B.1
Gateway Initialization Parameter, DRDA_READ_ONLY,
11.6
Gateway System Identifier (SID), defined,
10.2
GCS virtual machine,
13.5.1.2
GLOBAL_NAMES
known restrictions,
2.5.1
GRANT
DB2/VM security,
13.5.1.2
statement, synonyms and views,
10.7.2
granting authority to a package for DB2,
10.5.2.5
GRAPHIC data type,
12.7.3
graphic string operations, unsupported,
12.7.3
grc error code,
15.1.3
GROUP BY clause,
12.6.3
GROUPBY function,
12.6.2
GTW$_BIND_PKG
configuring the host,
10.4.4
gateway package considerations,
10.5
H
hardware requirements, memory,
3.1.2
HAVING
clause compatible for all versions of DRDA Server,
12.6.3
SQL Functions That Can Be Disabled,
12.6.2
heterogeneous database integration,
1.9.10
Heterogeneous Services (HS)
see also HS,
1.2
component of the Oracle Database 10g server,
1.2
parameter syntax and usage,
C.3
HGO-00706 error,
15.1.2
host
architecture,
1.5
components when installed on gateway,
1.6
creating an independent process,
1.6
database error,
15.3
networking needs,
3.2.5
relationship to gateway and Oracle server,
1.5
variable
converting character string data types,
12.7.2
moving data between applications and the database,
12.7
HS (Heterogeneous Services)
architecture features,
1.9.1
Oracle Net considerations,
14.5
HS= (TNSNAMES parameter for Oracle Net)
gateway migration problems,
14.2
modify tnsnames.ora file,
9.4.2
HS_DB_DOMAIN parameter,
2.5.1
HS_DB_NAME parameter,
2.5.1
HS_FDS_FETCH_ROWS parameter, description,
C.4.33
HS_LANGUAGE parameter, description,
C.4.34
HS_NLS_DATE_FORMAT
NLS parameters for initsid.ora file,
D.3.2.3
parameter,
12.7.5
support,
12.7.6
HS_NLS_DATE_LANGUAGE,
D.3.2.4
HS_NLS_NCHAR
parameter description,
C.4.35
parameters in the Gateway Initialization File,
D.3.2.2
HS_RPC_FETCH_REBLOCKING parameter
fetch reblocking described,
12.1.1
gateway features,
1.9.3
HS_RPC_FETCH_SIZE parameter
fetch reblocking described,
12.1.1
gateway features,
1.9.3
I
IBM Communication Server
definitions,
7.4.1
server selection,
7.4.1.1
implementation, gateway components,
1.6
implicit data conversion,
12.6
implicit protocol conversion,
1.3.3
IMS transaction,
12.3.2
IN and OUT columns, multi-byte support,
D.5
inbound connections
processing,
13.5
Independent LU
configuring IBM Communication Server,
7.3.1
configuring Microsoft SNA Server,
6.3.1
initdrdahoa1.ora
sample Gateway Initialization File,
B.1
initialization parameters
new since V4 gateway,
14.3.1.1
initsid.gtw file
sample,
10.4.1
initsid.gtwboot
file, migrating,
14.1.2
parameters moved to initsid.ora,
10.4
initsid.ora file
containing initsid.gwtboot parameters,
10.4
invalid ORA_MAX_DATE specified,
15.3
migrating,
14.1.2
NLS parameters,
D.3.2
parameter not recognized,
15.1.5
parameters have changed format,
14.1.3
sample,
10.4.1
simplified syntax, see Appendix C,
10.4
tailoring,
10.4.2.1
input bind variables,
12.7.4.2
INSERT
command
known restriction,
2.5
supported by COPY,
11.8
operation,
12.1
Oracle SQL command, known restrictions,
2.5
SQL clause,
12.7.7
statement
dates,
12.7.5
native SQL passthrough,
12.8
transaction semantics,
1.7.1
with read-only gateway,
11.6
installation
checklists
configuring the gateway,
10.1
DRDA Server,
5.1
gateway,
4.3
Oracle Net,
9.1
configuring multiple DRDA Servers
details,
10.9
overview,
4.4
configuring multiple integrating servers
details,
10.8
overview,
4.4
from CD,
4.6
log file, INSTALL.LOG,
4.6.5
overview,
4.4
INSTALL.LOG,
4.6.5
internal tracing,
C.4.40
Internet and intranet support,
1.3.3
INTERSECT, set operators,
12.6.3
IPC adapter,
B.3
ISO standard
SQL,
1.3.5
isolation level, DRDA_ISOLATION_LEVEL,
C.4.16
J
JOIN capability,
1.3.2
JOIN SQL statement,
12.1
K
keywords
LISTENER, sample listener.ora file,
B.3
known restrictions
main topic,
2.5
accessing DB2 alias objects,
2.5
AVS mapping user IDs,
2.5.1
bind variables become SQL parameter markers,
2.5.2
binding the DRDA gateway package on DB2/UDB,
2.5.1
CONNECT BY not supported,
2.5.2
data type limitations,
2.5.1
date arithmetic,
2.5.1
DD basic tables and views,
2.5.1
dictionary views not provided for DB2/VM,
2.5.1
DRDA server character sets,
2.5.1
GLOBAL_NAMES parameter,
2.5.1
LONG data type in SQL*Plus,
2.5.1
null values and stored procedures,
2.5.1
Oracle ROWID column,
2.5.2
row length,
2.5.1
row length limitation,
2.5.1
SAVEPOINT,
2.5.1
single gateway instances per DRDA network interface,
2.5.1
string concatenation,
2.5.1
SUBSTR function post-processed,
2.5.1
L
LANGUAGE parameter,
D.3.2.1
languages
SQL*Plus,
1.3.12
tools supported through the gateway,
1.3.10
link
also see Database Link,
12.4
service definition,
6.4.3.3
linkage conventions
SIMPLE with nulls,
12.3.2
listener
sample Oracle Net listener.ora file,
B.3
LISTENER keyword, sample listener.ora file,
B.3
listener.ora file
configuring additional DRDA Server instances,
10.9
IPC key defined,
9.4.2
sample,
B.3
literal
character literals,
12.7.4.1
date,
12.7.4.2
specific data type,
12.7
TO_DATE,
12.7.7
Local LU definition,
6.4.3.5
location transparency (introduction),
1.3.1
log file, installation, verifying success,
4.6.5
LOG_DESTINATION parameter
description,
C.4.36
used with ORACLE_DRDA_TRACE,
C.4.40
logging, LOG_DESTINATION,
C.4.36
LONG columns, known restrictions,
2.5.1
LONG data type
converting character string data types,
12.7.2
known restrictions,
2.5.1
LONG RAW datat ype, translating ASCII to EBCDIC,
12.7.1
LUs
dependent,
7.3.1
independent,
7.3.1
independent and dependent,
6.3.1
local definition, alias, network name,
6.4.3.5
remote definition,
6.4.3.7
M
mapped sqlstate errors,
15.2
mapping user IDs, known restrictions,
2.5.1
memory, hardware requirements,
3.1.2
Microsoft Windows Sockets, network attachment,
3.1.3
migration
defined,
14.1
migrating the gateway instance,
14.4
obsolete parameters,
14.3.4
problems, backout considerations,
14.2
MINUS
set operator,
12.6.3
Mobile Agents,
1.3.3
Mode definition,
6.4.3.6
multi-byte support,
D.5
N
National Language Support
initsid.ora parameters,
D.3.2
overview,
D
Native Semantics
main topic,
12.6
gateway features,
1.9.7
parameters,
12.6.3
with SUBSTR function,
2.5.1
native SQL passthrough,
12.8
network
configuration tool,
8.2
Oracle Net configuration,
9.4
requirements,
3.1.3
transparency (introduction),
1.3.1
NLS
also see National Language Support,
D
DRDA server character sets
codepage map facility,
D.4
parameters needed for NLS processing,
D.1
NLS parameters, configuration on client and Oracle servers,
D.2
NLS_LANG
environment variable
client-server configuration,
D.2
parameters needed for NLS processing,
D.1
server-side parameter,
D.1
non-character binary data,
12.7.1
null
rows, mapping the COUNT function,
12.7.9
values
known restrictions,
2.5.1
mapping the COUNT function,
12.7.9
number of cursors, DRDA_PACKAGE_SECTIONS,
C.4.24
numbers, concatenation restrictions,
2.5.1
numeric data type
conversion, destination column,
12.7.8
zoned decimal operations,
12.7.10
O
o2pc.sql
binding the DRDA gateway package,
10.5.2.6
two-phase commit processing,
11.5.2
obsolete parameters since V4 gateway,
14.3.4
open cursors, at the IBM database,
12.10
OPEN_LINKS parameter,
11.1.5
operating system requirements,
3.2.1
operating system transparency (introduction),
1.3.1
operations, SELECT, INSERT, UPDATE, DELETE,
12.1
operators
UNION,
12.6.3
UNION ALL,
12.6.3
option
binding packages,
10.4.5
data dictionary views,
12.9
date format string,
12.7.5
DRDA session security,
13.5.1.1
FOR BIT DATA,
12.7.1
Oracle server,
1.5
read-only
gateway configuration,
1.3.13
no updates permited by gateway,
11.6
replicating,
11.7
security conduct,
13.5
service port number, DRDA_CONNECT_PARM,
C.4.6
SNA security
configuring IBM Communication Server,
7.7
configuring Microsoft SNA Server or Host Integration Server,
6.7
SQL functions that can be disabled,
12.6.2
SQL functions that can be enabled,
12.6.1
SQL*Plus COPY command,
11.8
ora
listener.ora file,
10.9
tnsnames.ora file,
9.4.2
ORA_MAX_DATE parameter, description,
C.4.37
ORA_NLS33 parameter
description (default value),
C.4.38
needed in system environment,
D.1
ORA-00001 error, index constraint violated,
15.2
ORA-00942 error
object does not exist,
15.2
object name too long,
15.2
ORA-01017 error, logon denied,
15.2
ORA-01031 error, insufficient privileges,
15.2
ORA-01460 error, invalid CCSID,
15.2
ORA-01476 error, divide by zero,
15.2
ORA-02019 error, undefined database link name is specified,
15.1.1
ORA1 Oracle instance,
12.2
ORA-28500 error
was ORA-09100,
15.1.3
example, collection ID or package name not recognized,
15.1.5
ORA-28501 error
was ORA-09101,
15.1.3
communication error,
15.1.4
Side Information Profile not defined,
15.1.4
ORA-28527, conversion errors,
C.4.8
ORA-9100 error,
15.1.1
ORA-9199 error,
15.1.1
Oracle
error code, mapped errors,
15.2
error number or return code,
15.1
products compatibility,
1.8
RAW data type,
C.4.8
snapshots,
11.7.2
stored procedure, defined,
12.2
Oracle Database 10g server
introduction,
1.2
relationship to host,
1.5
services
list,
1.3.2
database triggers,
1.3.2
distributed capabilities,
1.3.2
distributed query optimization,
1.3.2
SQL,
1.3.2
stored procedures,
1.3.2
two-phase commit protection,
1.3.2
Oracle integrating server
architecture,
1.5
configuration,
10.7
defined in gateway architecture,
1.5
gateway and Oracle integrating server not on same host,
1.5
requirements,
3.2.4
Oracle Net
and application development,
1.9.16
and remote data access,
1.9.14
and server coexistence,
1.5
API,
9.3
compatibility with SQL*Net,
9.2
configuring,
9.4
distributed
database,
9.3.2
processing,
9.3.1
editing to set up security test,
9.6.1
gateway and Oracle integrating server not on same host,
1.5
gateway migration problems,
14.2
Heterogeneous Services (HS) facility,
9.2
introduction,
9.2
migration considerations,
14.5
operating system authentication,
13.2
overview,
9.3
purpose,
1.6
requirements,
3.2.5
sample files,
B
sample listener.ora file,
B.3
support (introduction),
1.3.11
support for CHECKSUM and encryption,
9.5
terminology,
9.3.3
Oracle ROWID column,
2.5.2
Oracle ROWID function, with UPDATE or DELETE,
2.5.2
ORACLE_DRDA_TCTL parameter, description,
C.4.39
ORACLE_DRDA_TRACE parameter, description,
C.4.40
ORACLE_HOME, preinstallation and caution notice,
4.5
ORACLE2PC table
before binding gateway package,
10.5.1.2
binding packages on DB2/UDB,
10.4.5
DB2/400,
5.3.2
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/UDB, granting authority to package,
10.5.2.5
DB2/VM,
5.5.2
distributed DRDA transactions,
11.5.3
DRDA_PACKAGE_OWNER description,
C.4.23
ORADRDA.ORACLE2PC table, two-phase commit,
11.5.2
ORAIND sample DB2 stored procedure,
G.2
oraproc1, stored procedure,
12.2
oraproc2, stored procedure,
12.2
ORARECOV user ID
DB2/400,
5.3.3
DB2/OS390,
5.2.3
DB2/UDB,
5.4.3
DB2/VM,
5.5.3
DRDA_RECOVERY_USERID description,
C.4.27
ORA2 Oracle instance,
12.2
ORDER BY clause,
12.6.3
OS/390 (MVS) VTAM, configuring,
5.2.1
P
package
collection id, DRDA_PACKAGE_COLLID,
C.4.20
consistency token, DRDA_PACKAGE_CONSTOKEN,
C.4.21
privileges - BIND and EXECUTE, DB2/UDB,
5.4.2
privileges - BIND, COPY, and EXECUTE
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
packed decimal,
12.7.10
parameter
changed,
14.3.2
checking settings,
10.5.1.1
diagnostic,
C.4.39
gateway,
5.5.4
list of parameters needed to configure the gateway,
E
Native Semantics,
12.6.3
new since V4 gateway,
14.3.1.1
obsolete since V4 gateway,
14.3.4
parameter syntax and usage,
C.3
renamed since V4 gateway,
14.3.3
parameters
DB_DOMAIN,
2.5.1
DRDA_CAPABILITY,
12.6
DRDA_CODEPAGE_MAP
described,
C.4.3
mapping IBM CCSID,
D.4
DRDA_CONNECT_PARM
configuring IBM Communication Server,
7.4.1.2
configuring Microsoft SNA server or host server,
6.4.3.8
configuring the gateway for TCP/IP,
8.2
DRDA_DESCRIBE_TABLE, known restrictions,
2.5
DRDA_DISABLE_CALL,
10.5.1.1
DRDA_PACKAGE_NAME,
10.5.1.1
DRDA_PACKAGE_SECTIONS, open cursors,
12.10
DRDA_READ_ONLY, read-only gateway,
11.6
DRDA_RECOVERY_PASSWORD
DB2/400,
5.3.3
DB2/OS390,
5.2.3
DB2/UDB,
5.4.3
DB2/VM,
5.5.3
DRDA_RECOVERY_USERID
DB2/400,
5.3.3
DB2/OS390,
5.2.3
DB2/UDB,
5.4.3
DB2/VM,
5.5.3
FDS_CLASS, description,
C.4.30
FDS_CLASS_VERSION, description,
C.4.31
FDS_INSTANCE, description,
C.4.32
Gateway Initialization File
DRDA_CACHE_TABLE_DESC,
C.4.1
DRDA_CAPABILITY,
C.4.2
DRDA_CMSRC_CM_IMMEDIATE,
C.4.7
DRDA_CODEPAGE_MAP,
C.4.3
DRDA_COMM_BUFLEN,
C.4.4
DRDA_CONNECT_PARM,
8.2
,
15.1.4
DRDA_CONNECT_PARM (SNA format),
C.4.5
DRDA_CONNECT_PARM (TCP/IP format),
C.4.6
DRDA_DEFAULT_CCSID,
C.4.8
DRDA_DESCRIBE_TABLE,
C.4.9
DRDA_DISABLE_CALL,
C.4.10
DRDA_FLUSH_CACHE,
C.4.11
DRDA_GRAPHIC_LIT_CHECK,
C.4.13
DRDA_GRAPHIC_PAD_SIZE,
C.4.12
DRDA_GRAPHIC_TO_MBCS,
C.4.14
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_LOCAL_NODE_NAME,
C.4.17
DRDA_MBCS_TO_GRAPHIC,
C.4.18
DRDA_OPTIMIZE_QUERY,
11.5
,
C.4.19
DRDA_PACKAGE_COLLID,
15.1.5
,
C.4.20
DRDA_PACKAGE_CONSTOKEN,
C.4.21
DRDA_PACKAGE_NAME,
15.1.5
,
C.4.22
DRDA_PACKAGE_OWNER,
C.4.23
DRDA_PACKAGE_SECTIONS,
C.4.24
DRDA_READ_ONLY,
C.4.25
DRDA_RECOVERY_PASSWORD,
C.4.26
DRDA_RECOVERY_USERID,
C.4.27
DRDA_REMOTE_DB_NAME,
C.4.28
DRDA_SECURITY_TYPE,
C.4.29
HS_FDS_FETCH_ROWS,
C.4.33
HS_LANGUAGE,
C.4.34
HS_NLS_NCHAR,
C.4.35
LOG_DESTINATION,
C.4.36
ORA_MAX_DATE,
C.4.37
ORA_NLS33,
C.4.38
ORACLE_DRDA_TCTL,
C.4.39
,
C.4.39
ORACLE_DRDA_TRACE,
C.4.40
TRACE_LEVEL,
C.4.41
HS_DB_DOMAIN,
2.5.1
HS_DB_NAME,
2.5.1
HS_NLS_DATE_FORMAT,
12.7.5
HS_RPC_FETCH_REBLOCKING
gateway features,
1.9.3
gateway support for fetch reblocking,
12.1.1
HS_RPC_FETCH_SIZE
gateway features,
1.9.3
gateway support for fetch reblocking,
12.1.1
LOG_DESTINATION, description,
C.4.40
NLS_DATE_FORMAT,
12.7.5
OPEN_LINKS,
11.1.5
passthrough
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE
gateway features,
1.9.4
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE syntax
using the passthrough function,
12.8.2
example,
12.8.3.1
gateway feature,
1.3.8
native SQL through the gateway,
12.8
result sets example,
12.8.3.1
result sets from queries,
12.8
retrieving result sets,
12.8.3
SQL feature,
12.8
performance enhancements with fetch reblocking,
12.1.1
PL/SQL
call,
12.3.1
records,
12.3.2
routine,
1.3.9.1
running stored procedures,
12.3
standard Oracle,
1.3.9.2
stored procedure,
12.2
port number
446 as default for DRDA services (TCP/IP),
8.1.1
5000 as default for DRDA services (TCP/IP),
8.1.1
for DRDA Server (TCP/IP),
8.1.1
Primary
DB2/400,
5.3.1
DB2/OS390,
5.2.1
Recovery
DB2/400,
5.3.1
DB2/OS390,
5.2.1
post processing
defined,
12.5.3
native semantics,
12.6
post-processed SQL functions, overview,
12.5.3
SQL tracing,
15.4.1
PREPARE TRANSACTION statement, two-phase commit,
11.5.2
primary port number
DB2/400,
5.3.1
DB2/OS390,
5.2.1
privileges
BIND
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
BINDADD
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
BINDAGENT
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
CONNECT
DB2/UDB,
5.4.2
COPY
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
CREATE IN
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
CREATE PUBLIC DATABASE LINK
binding the DRDA gateway package,
10.4.4
configuring the Oracle integrating server,
10.7.1
CREATEIN
DB2/UDB,
5.4.2
CREATETAB
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
data dictionary limitations,
12.9
EXECUTE
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
procedure
stored procedures
REVISE_SALARY, example,
12.3.1
using DRDA server,
12.3
with read-only gateway,
11.6
procedures
DB2
DB2INS, sample,
G.1
ORAIND, sample,
G.2
processing time, with GROUPBY, HAVING, WHERE,
12.6.2
processor requirements,
3.1.1
profile set, APPC, configuring,
10.9
protocol
commit confirm,
1.3.13
communications and DRDA-specific parameters,
8.2
communications protocols with Oracle Net,
9.3
converter,
1.3.3
definition,
9.3.3
implicit protocol conversion,
1.3.3
network,
11.4
Oracle Net Protocol Adapters,
9.2
protocol-independent encryption,
1.3.3
two-phase commit,
11.5.2
protocols
IPC,
9.4.2
SNA, for the DRDA server,
1.5
TCP/IP
for the DRDA server,
1.5
how supported,
1.9.6
implicit protocol conversion,
1.3.3
public database link,
10.7.1
Q
queries, distributed,
11.5
R
RAW data type
DRDA_DEFAULT_CCSID description,
C.4.8
translating ASCII to EBCDIC,
12.7.1
read-only gateway
main topic,
11.6
option, DRDA_READ_ONLY,
C.4.25
read-only support, changes in this release,
1.9.22
rebind
DRDA_DISABLE_CALL,
C.4.10
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_PACKAGE_COLLID,
C.4.20
DRDA_PACKAGE_CONSTOKEN,
C.4.21
DRDA_PACKAGE_NAME,
C.4.22
DRDA_PACKAGE_OWNER,
C.4.23
DRDA_PACKAGE_SECTIONS,
C.4.24
recovery port number
DB2/400,
5.3.1
DB2/OS390,
5.2.1
recovery user ID and password
DB2/400,
5.3.3
DB2/OS390,
5.2.3
DB2/UDB,
5.4.3
DB2/VM,
5.5.3
remote
computer,
9.3.1
connections,
11.1.5
data,
1.3.2
data access,
1.9.14
database
configuration worksheet,
E
copy data from Oracle Database server to DRDA Server database,
11.8
creating database links,
11.1.1
DB2/400,
5.3.3
DB2/OS390,
5.2.3
DB2/UDB,
5.4.3
DB2/VM,
5.5.3
defining a path,
11.1.1
DRDA gateway package considerations,
10.5
DRDA_PACKAGE_SECTIONS,
C.4.24
example error message,
15.1.1
gateway error codes, 30061, RDB not found,
15.3
DB2 system,
2.5
DRDA database, DRDA_ISOLATION_LEVEL,
C.4.16
instance,
12.2
LU definition,
6.4.3.7
objects,
13.3.1
Oracle instance
running a DB2 stored procedure,
12.3
synonym for calling a stored procedure,
12.2
Oracle servers,
9.3.2
procedure,
1.3.9.2
table,
1.3.4
transaction program,
3.1.2
userid and password,
11.1.1
renamed parameters,
14.3.3
REPLACE
command, supported by COPY,
11.8
replication in heterogeneous environment,
11.7
requirements
hardware,
3.1
software,
3.2
restrictions,
2.5
RESULT,
12.3.1
result sets
columns in,
1.9.8
features of the gateway,
1.9.5
return code, error,
15.1
REVISE_SALARY
stored procedure example,
12.3.1
row length
known restrictions,
2.5.1
ROWID
known restrictions,
2.5.2
Oracle column,
2.5.2
with UPDATE or DELETE,
2.5.2
S
sample
files
gateway initialization, tnsnames.ora, listener.ora,
B
initsid.gtw,
10.4.1
initsid.ora,
10.4.1
Gateway Initialization File, initdrdahoa1.ora,
B.1
listener.ora file,
B.3
SQL scripts,
10.5.2
SAVEPOINT, known restrictions,
2.5.1
schema privileges - CREATEIN,
5.4.2
scripts
dropold.sql,
10.5.2.2
g4ddtab,
10.5.2.3
g4ddview.sql,
10.5.2.3
security
Advanced Security,
1.3.3
DRDA_SECURITY_TYPE,
C.4.29
encryption,
9.5
overview,
13.1
site autonomy,
1.3.14
validation for SNA,
6.6
,
7.6
validation for TCP/IP,
13.4
SELECT
and array size,
1.9.3
operation,
12.1
SQL statement,
12.8.3
statement
compensated SQL functions,
12.5.3
dates,
12.7.5
fetch reblocking,
12.1.1
retrieve results sets,
12.8.3
with read-only gateway,
11.6
SELECT WHERE SQL clause,
12.7.7
semantics,
12.6
server selection,
6.4.3.1
,
7.4.1.1
service port number, DRDA_CONNECT_PARM,
C.4.6
session, connection,
12.4
set operators
compatibility,
12.6.3
EXCEPT,
12.6.3
INTERSECT,
12.6.3
MINUS,
12.6.3
SQL set operators and clauses,
12.6.3
shift attribute, multi-byte support,
D.5
SID
choosing a gateway SID,
10.2
configuring additional DRDA server instances,
10.9
Gateway System Identifier, defined,
10.2
Side Information Profile
communication error,
15.1.4
definition,
6.3
,
7.3
SIMPLE linkage convention
DB2INS, sample DB2 stored procedure,
G.1
of DB2 stored procedures,
12.3.2
site autonomy,
1.3.14
SNA,
5.4.1
configuring
AS/400 communications,
5.3.1
OS/390 communications,
5.2.1
VM communications,
5.5.1
conversation security,
6.7
,
7.7
CPI-C error,
15.1.4
facilities,
1.9.11
functions,
1.6
LU,
13.5.1.1
protocol
DRDA server support,
1.5
remote access,
1.9.14
security validation
IBM Communication Server,
7.6
Microsoft SNA Server or Host Integration Server,
6.6
versus TCP/IP security,
13.4
security, DRDA_SECURITY_TYPE,
C.4.29
SECURITY=PROGRAM,
6.7.1
,
7.7.1
SECURITY=SAME,
6.7.2
,
7.7.2
send/receive buffer,
C.4.4
session allocation mode, DRDA_CMSRC_CM_IMMEDIATE,
C.4.7
SNA Server
connection definition,
6.4.3.4
CPI-C symbolic destination names,
6.4.3.8
definitions
creating side information profiles,
7.3
creating SNA definitions for SNA Server version 3,
6.4.3
side information profiles,
6.3
for Windows NT,
6.3.1
link service definition,
6.4.3.3
local LU definition,
6.4.3.5
mode definition,
6.4.3.6
remote LU definition,
6.4.3.7
server selection,
6.4.3.1
testing the connection,
6.5
SNA Server for Windows NT
dependent LUs,
7.3.1
independent LUs,
7.3.1
testing the connection,
7.5
SNACFG command,
6.4.1
snacfg.ctl file,
6.4.1
,
7.3.2.1
snapshots
known restrictions,
2.5.2
Oracle snapshot feature,
11.7.2
software requirements,
3.2
sort order
with ORDERBY,
12.6.2
SPUFI on DB2/OS390,
10.5.2
SQL
main topic,
1.3.5
ANSI standard,
1.3.5
clause compatibility,
12.6.3
clauses
DELETE,
12.7.7
INSERT,
12.7.7
SELECT WHERE,
12.7.7
UPDATE,
12.7.7
constructs, Oracle processing,
12.5
differences in the gateway,
1.7.1
functions
and Native Semantics,
12.6
quick reference list,
F
SUBSTR,
12.6
ISO standard,
1.3.5
native DB2,
1.3.8
passthrough
described,
12.8
retrieving results sets example,
12.8.3.1
using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE,
12.8.2
statements
DB2,
12.8.2
DRDA_ISOLATION_LEVEL,
C.4.16
passing through gateway,
12.8
run through the gateway,
11.10
using JOIN,
12.1
syntax,
12.7.9
tracing
improving performance,
11.10
tracing errors in the Oracle Database,
15.4.1
SQL functions
column functions,
12.5.1
compatible, defined,
12.5.1
compensated, defined,
12.5.3
DB2/400,
12.5.7
DB2/OS390,
12.5.5
DB2/UDB,
12.5.6
DB2/VM,
12.5.8
that can be disabled,
12.6.2
that can be enabled,
12.6.1
translated
defined,
12.5.2
with Native Semantics,
12.6.1
SQL set operators and clauses,
12.6.3
SQL*Net
Heterogeneous Services (HS) facility,
9.2
replaced by Oracle Net,
9.2
SQL*Plus
connecting gateway to Oracle integrating server,
9.7.1
copying data from Oracle server to DRDA Server,
11.8
extending gateway uses,
1.8.1
introduction,
1.3.12
sqlstate, mapped sqlstate errors,
15.2
stability, of cursor, DRDA_ISOLATION_LEVEL,
C.4.16
Startup Shell Script
migration,
14.1.2
statements
CREATE DATABASE LINK,
11.1.1
CREATE DATABASE, client/server configuration,
D.2
DB2 CREATE TABLE,
1.3.8
DDL
nonqueries supported by gateway passthrough,
12.8
number of rows affected by passthrough,
12.8.2
DELETE
and TO_DATE function,
12.7.5
nonqueries supported by gateway passthrough,
12.8
DROP DATABASE LINK,
11.1.3
GRANT,
10.7.2
INSERT
and TO_DATE function,
12.7.5
nonqueries supported by gateway passthrough,
12.8
passing SQL through gateway,
12.8
PREPARE TRANSACTION, two-phase commit,
11.5.2
SELECT
and TO_DATE function,
12.7.5
compensated SQL functions,
12.5.3
fetch reblocking, array size,
12.1.1
retrieve results sets,
12.8.3
with read-only gateway,
11.6
SQL
DB2,
12.8.2
JOIN,
12.1
SELECT,
12.8.3
UPDATE
and TO_DATE function,
12.7.5
nonqueries supported by gateway passthrough,
12.8
stored procedure
creating on DB2,
12.3.1
DB2
considerations for use,
12.3.2
native to DRDA server,
12.3
with read-only gateway,
11.6
DB2INS, sample,
G.1
extended database services,
1.3.2
GTW$_BIND_PKG,
10.4.4
native DB2,
1.3.9.2
Oracle and non-Oracle,
1.3.9
Oracle Database 10g server
using,
12.2
Oracle database server
local instance,
12.2
PL/SQL,
12.2
remote instance,
12.2
Oracle, description,
1.3.9.1
ORAIND, sample,
G.2
restriction,
2.5.1
REVISE_SALARY, example,
12.3.1
usage,
C.4.10
using DRDA server,
12.3
string concatenation, known restrictions,
2.5.1
string index, with Native Semantics,
12.6
Structured Query Language, also see SQL,
1.2.1
SUBSTR
SQL function
known restrictions,
2.5.1
Oracle implementation permits negative values,
12.6
with Native Semantics,
2.5.1
synonym
feature,
11.4
for location transparency,
12.2
how the gateway works,
1.7
system privileges - BINDADD and BINDAGENT
configuration worksheet,
E
DB2/OS390,
5.2.2
DB2/VM,
5.5.2
T
table
create a table in DB2,
12.8.2.1
insert a row into a DB2 table,
12.8.2.1
TABLE_PRIVILEGES view,
A.2.17
tables
ORACLE2PC,
10.5.1.2
,
10.5.2.5
ORACLE2PC, distributed transactions,
11.5.3
ORADRDA.ORACLE2PC, two-phase commit,
11.5.2
tailoring
initsid.ora file,
10.4.2
TCP/IP
affecting memory requirements,
3.1.2
concurrent connections,
3.1.2
configuration chapter,
8
configuration worksheet,
E
configuring
for AS/400,
5.3.1
for OS/390,
5.2.1
for VM,
5.5.1
to use DNS,
8.2
using DRDA_CONNECT_PARM parameter,
8.2
database link behavior,
12.4
default port number,
9.4.2
DRDA_CONNECT_PARM,
C.4.6
facilities,
1.9.11
format, gateway initialization file parameter,
C.4.6
functions,
1.6
gateway architecture, connecting to DRDA Server,
1.5
known restrictions, DRDA Network Interfaces,
2.5.1
modifying tnsnames.ora in Oracle Net,
9.4.2
protocol
access across multiple networks - transparency,
1.3.1
DRDA server support,
1.5
implicit protocol conversion,
1.3.3
remote access,
1.9.14
sample Oracle Net listener.ora file,
B.3
security validation,
13.4
support,
1.9.6
you must choose either SNA or TCP/IP for the Networking Interface,
8.2
terminology defined,
1.4
tg4drdasnacommsvr subdirectory, sample SNA Server definitions,
7.3.2.1
,
7.3.2.1
tg4drdasnamssna subdirectory, sample SNA Server definitions,
6.4.1
TIME data type,
12.7.4.1
time operations,
12.7.4
TIMESTAMP data type,
12.7.4.1
TNSNAMES.ORA
changes to, during migration problems,
14.2
tnsnames.ora
adding a gateway service name,
9.4.2
,
9.4.2
configuring additional DRDA Server instances,
10.9
connect descriptor,
11.1.1
using the HS facilities,
14.5
TO_DATE function
Oracle function preprocessed in SQL,
12.7.7
processing DATE data,
12.7.4.2
twenty-first century dates,
12.7.5
token
error tokens,
15.1.3
package consistency, DRDA_PACKAGE_CONSTOKEN,
C.4.21
trace control,
C.4.39
TRACE_LEVEL parameter,
C.4.41
tracing
code,
C.4.41
LOG_DESTINATION,
C.4.36
ORACLE_DRDA_TRACE,
C.4.40
SQL statements,
11.10
trade-off, Native Semantics,
12.6
transaction mode, read-only, DRDA_READ_ONLY,
C.4.25
transactions
CICS,
12.3.2
IMS,
12.3.2
transform
character set transforms with multi-byte support,
D.5
not required for DRDA Server,
D.5
transparency
and performance,
12.6
main topic, gateway transparency,
1.3.1
triggers for Oracle Database 10g server,
11.7.1
TSO,
5.2
two-phase commit
ORACLE2PC table
DB2/400,
5.3.2
DB2/OS390,
5.2.2
DB2/UDB,
5.4.2
DB2/VM,
5.5.2
protection,
1.3.2
transactions, distributed queries,
11.5.2
unsupported statement,
11.5.2
U
UNION
capability,
1.3.2
operator,
12.6.3
UNION ALL
operator,
12.6.3
UPDATE
known restrictions,
2.5.2
operation,
12.1
SQL clause,
12.7.7
statement
dates,
12.7.5
native SQL passthrough,
12.8
transaction semantics,
1.7.1
with read-only gateway,
11.6
upgrading, defined,
14.1
user privileges,
12.9
USER_CATALOG view,
A.2.18
USER_COL_COMMENTS view,
A.2.19
USER_CONS_COLUMNS view,
A.2.21
USER_CONSTRAINTS view,
A.2.20
USER_DB_LINKS data dictionary view,
11.1.4
USER_INDEXES view,
A.2.22
USER_OBJECTS view,
A.2.23
USER_SYNONYMS view,
A.2.24
USER_TAB_COLUMNS view,
A.2.26
USER_TAB_COMMENTS view,
A.2.27
USER_TABLES view,
A.2.25
USER_USERS view,
A.2.28
USER_VIEWS view,
A.2.29
userid mapping
DB2/400,
13.5.1.3
DB2/OS390,
13.5.1.1
DB2/VM,
13.5.1.2
security,
13.5.1
userid translation
DB2,
13.5.1.2
USING clause,
11.1.1
V
VALUES clause,
12.7.7
VARCHAR data type,
12.7.2
variable
bind,
12.8
input bind,
12.7.4.2
view
catalog
DB2/400,
12.9.1
DB2/OS390,
12.9.1
DB2/UDB,
12.9.1
DB2/VM,
12.9.1
creating,
10.7.2
data dictionary,
12.9
VSAM file,
12.3.2
VTAM
DB2/OS390,
5.2
DB2/VM VTAM configuring,
5.5.1
W
WHERE clause
compatible for all versions of DRDA Server,
12.6.3
SQL limitations, Oracle ROWID column,
2.5.2
WHERE CURRENT OF CURSOR clause, ROWID column,
2.5.2
WHERE function,
12.6.2
wireless communication,
1.3.3
workarounds,
2.4
Z
zoned decimal operations,
12.7.10
Scripting on this page enhances content navigation, but does not change the content in any way.