Go to main content
29/29
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
Symbols
$DISPLAY environmental variables
on HP-UX,
8.6.3
on Solaris,
6.6.2
$ORACLE_HOME
on HP-UX,
8.6.1
on Solaris,
6.6.1
Numerics
22421
H1 Head1
Migrating existing Gateway Instance to New Release,
15.1
A
accessing
DRDA servers,
11.9
gateway,
11.8
main topic,
12.2
Advanced Program to Program Communication (APPC/LU6.2) protocol
IBM Communication Server product on AIX,
7
SNAP-IX product on Solaris,
6
SNAPlus2 product on HP-UX,
8
Advanced Security
CHECKSUM command,
10.5
encryption,
10.5
international version types supported,
10.6
resetting configuration parameters on gateway,
10.7
setting test parameters for gateway,
10.6
setting test parameters for Oracle integrating server,
10.6
setting up for test,
10.6
testing gateway and Oracle integrating server,
10.7
export encryption algorithms,
10.5
function of the gateway,
1.3.3
purpose,
1.3.3
test error,
10.7
12660,
10.6
AGW ADD USERID command,
14.5.1.2
AGW DELETE USERID command,
14.5.1.2
AIX
AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME,
C.4.17
alias
CPI-C destination
on HP-UX,
8.6.3
on Solaris,
6.6.2
DB2,
C.4.9
Ethernet parameters,
8.6.3
local LU alias,
6.6.2
partner LU,
7.1.2.2
alias objects, DB2
known restrictions,
2.6
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,
12.1.3
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,
12.1.1
ANSI-standard SQL,
1.3.5
,
1.9
API (application program interface),
10.3
APPC
concurrent connections,
3.1
configuring IBM Communication Server on AIX,
7
configuring SNAP-IX on Solaris,
6
configuring SNAPlus2 on HP-UX,
8
conversations on AIX,
7.1.1
creating SNAP-IX profiles,
6.4
creating SNAPlus2 profiles,
8.4
DB2/VM,
14.5.1.2
number of database link connections,
13.4
password length,
16.3
user ID length,
16.3
APPC VTAM Support (AVS)
also see AVS,
14.5.1.2
known restrictions,
2.6.1
APPC/LU6.2
parallel session limits on AIX,
7.1.2.2
protocol
on HP-UX,
8
on Solaris,
6
side information profile on AIX,
7.1.2.2
APPEND command
supported by COPY,
12.8
application
authenticating logons,
14.2
portability,
1.9
server support,
1.3.3
application development on the gateway,
1.9
application program interface (API),
10.3
APPN
node, advanced peer-to-peer networking node on AIX,
7.1.2.2
support requires VTAM Version 4 ( on AIX),
7.1.2.2
architecture of the gateway,
1.5
array size
fetch reblocking,
1.9
how determined,
13.1.1
AS/400
command, DSPRDBDIRE,
5.3
communications, configuring,
5.3
files and file members, accessing,
12.3
library name, DRDA_PACKAGE_COLLID,
C.4.20
ASCII
code page,
D.3
sort order,
13.6.2
tables, known restrictions,
1.9
translated from EBCDIC,
13.7.1
US7ASCII,
D.3.2.1
US7ASCII as default,
D.2
authority
CONNECT,
14.5.1.2
execute,
14.5.1.2
autonomy, site,
1.3.14
available products menu,
4.6
AVS
also see APPC VTAM Support,
2.6.1
configuring,
5.5
DB2/VM,
14.5.1.2
mapping user IDs,
2.6.1
,
14.5.1.2
mapping user IDs (DB2/VM)
known restrictions,
2.6.1
mapping user IDs with DB2/VMT,
14.5.1.2
B
binary data, non-character,
13.7.1
Bind Package Stored Procedure
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
BIND privilege
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
bind variables
known restrictions, SQL limitations,
2.6.2
SQL passthrough,
13.8
BINDADD authority,
11.4.2
BINDADD privilege
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
BINDAGENT privilege
DB2/OS390,
5.2
DB2/VM,
5.5
binding the DRDA package
backward compatibility,
15.4
configuring the gateway on DB2/UDB,
11.4.2
configuring the gateway on DRDA Server,
11.4.1
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
gateway pre-binding checklist,
11.5.1
Bourne shell
setting ORACLE_HOME variable,
4.6
bug
debugging
debug library,
16.4.2
drc values in the DRDA software,
16.1.3
setting trace parameters,
16.4
SQL tracing,
12.10
number 205538, known restrictions, SQL limitations,
2.6.2
C
C shell, setting ORACLE_HOME variable,
4.6
call
a CICS or IMS transaction,
13.3.2
DB2 stored procedure,
13.3
,
13.3.1
DRDA_DISABLE_CALL,
11.5.1.1
,
B.1
empproc stored procedure,
13.3
Oracle Call Interfaces,
16.1
PL/SQL,
13.3.1
stored procedure
creating a synonym to maintain location transparency,
13.2
using standard Oracle PL/SQL,
13.2
to stored procedure
known restrictions,
2.6.1
capabilities of DRDA Server, native semantics,
13.6
CCSID
65535 as the default for all tables created,
C.4.8
codepage mapping facility,
D.4
description,
D.1
external mapping to Oracle character sets supported,
1.9
CCSID (coded character set identifiers), defined,
D.5
CD-ROM drive requirements,
3.1
changed parameters,
15.3.2
changes in this release
IBM DB2 Version 5.1 EBCDIC and ASCII Tables,
1.9
IBM DB2/UDB supported,
1.9
read-only support,
1.9
CHARACTER SET
clause, client/server configuration,
D.2
parameter, description,
D.1
character sets
and codepage map facility,
D.4
ASCII,
1.9
CCSID,
D.1
codepage,
C.4.8
EBCDIC,
1.9
supported,
1.9
character string
converting datatypes,
13.7.2
performing operations,
13.7.2
checklist
configuring the communications interfaces
on AIX,
7.1
on HP-UX,
8.1
on Solaris,
6.1
configuring the DRDA Server,
5.1
gateway configuration,
11.1
gateway installation,
4.3
installation overview,
4.3
Oracle Net installation and configuration,
10.1
CHECKSUM command,
10.5
extended advanced networking,
1.3.3
CICS transaction,
13.3.2
clause
CHARACTER SET, client/server configuration,
D.2
clauses
CONNECT TO,
12.1.1
GROUP BY, SQL Set Clauses,
13.6.3
HAVING, SQL Set Clauses,
13.6.3
ORDER BY, SQL Set Clauses,
13.6.3
SQL
DELETE,
13.7.7
INSERT,
13.7.7
SELECT WHERE,
13.7.7
UPDATE,
13.7.7
USING,
12.1.1
VALUES
functions not allowed by DB2,
13.7.7
WHERE
known restrictions, SQL limitations,
2.6.2
SQL Set Clauses,
13.6.3
WHERE CURRENT OF CURSOR, known restrictions, SQL limitations,
2.6.2
code tracing,
C.4.41
codepage map facility
configuring support for character sets, known restrictions,
2.6.1
for data translation,
D.4
supported by gateway,
1.9
coercion
of data,
13.6
collection privilege - CREATE IN
DB2/OS390,
5.2
DB2/VM,
5.5
collection privilege - CREATETAB
DB2/OS390,
5.2
column
date columns, TO_DATE function,
13.7.7
Oracle ROWID
known restrictions,
2.6.2
supported in a result set,
1.9
commands
AGW ADD USERID,
14.5.1.2
AGW DELETE USERID,
14.5.1.2
CHECKSUM,
1.3.3
,
10.5
COPY
known restrictions,
2.6
Oracle Database server to DRDA Server,
12.8
SQL*Plus command,
12.8
CREATE DATABASE LINK
DB2/VM,
5.5
EXECUTE,
1.3.9
EXPLAIN PLAN,
16.4.1
INSERT
known restrictions,
2.6
not supported,
12.8
lanscan
on HP-UX,
8.6.3
on Solaris,
6.6.2
commit confirm protocol,
1.3.13
Communication Database (CDB) tables, DDF,
5.2
communications requirements,
3.2
Communications Server
configuring server profiles (on AIX),
7.1.1
creating profiles (on AIX),
7.1.2
compatible SQL set operators and clauses,
13.6.3
concatenation restrictions, string concatenation of numbers,
2.6.1
concurrent connections
APPC,
3.1
TCP/IP,
3.1
configuring
additional DRDA servers,
11.9
AS/400 communications,
5.3
AVS,
5.5
binding DRDA package,
11.5
checklist
communications interfaces,
6.1
,
8.1
for DRDA Server,
5.1
for installation overview,
4.3
for the gateway,
11.1
IBM Communication Server product on AIX,
7.1
Oracle Net,
10.1
checklist for gateway,
11.1
DB2/400,
5.3
,
5.3
,
5.4
DB2/OS390,
5.2
host workstation for gateway,
11.4
MVS VTAM,
5.2
Oracle integrating server,
11.7
Oracle Net,
10.4
other Oracle Database servers,
11.8
SNA server
creating profiles,
7.1.2
testing connection,
7.1.3
SNAPlus2 on HP-UX,
8
TCP/IP
DB2/400,
5.3
DB2/OS390,
5.2
DB2/VM,
5.5
under Solaris,
9.2
VM VTAM,
5.5
CONNECT authority
DB2/UDB,
11.4.2
DB2/VM,
14.5.1.2
CONNECT BY not supported
known restrictions, SQL limitations,
2.6.2
,
2.6.2
CONNECT privilege
DB2/UDB,
5.4
CONNECT TO clause,
12.1.1
contact information
in configuring SNAplus2,
6.6.2
,
8.6.3
convert
character string,
13.7.2
datatypes
DRDA to Oracle datatypes,
13.7
DATE,
13.7.4.2
floating point to integer,
13.7.8
inbound user ID,
14.5.1.2
into most suitable datatype,
13.7.10
SQL,
1.7
to the numeric datatype,
13.7.8
converter, protocol,
1.3.3
COPY command
Oracle Database server to DRDA Server,
12.8
COPY privilege
DB2/OS390,
5.2
DB2/VM,
5.5
COPY SQL*Plus command,
12.8
substituted for INSERT, known restrictions,
2.6
copying data
from the DRDA Server,
12.9
from the Oracle server to DRDA Server,
12.8
COS SQL function,
13.5.3.1
COUNT function,
13.7.9
CP (Control Point for the Node),
6.5
,
8.5
CPI-C
communication error messages,
16.1.4
,
16.3
create Side Information Profile,
6.6.2
,
8.6.3
profiles, creating,
6.6.2
,
8.6.3
routine,
16.1.4
side information profile,
6.6.2
,
8.6.3
CREATE command
supported by COPY,
12.8
CREATE DATABASE LINK command,
12.1.1
DB2/VM,
5.5
CREATE DATABASE statement, client/server configuration,
D.2
CREATE IN privilege
DB2/OS390,
5.2
DB2/VM,
5.5
CREATE PUBLIC DATABASE LINK privilege,
11.4.1
,
11.7.1
CREATE TABLE statement,
1.3.8
CREATEIN privilege
DB2/UDB,
5.4
CREATETAB authority,
11.4.2
CREATETAB privilege
DB2/OS390,
5.2
DB2/UDB,
5.4
creating
a new directory,
4.6
CPI-C and mode definitions,
6.6.2
,
8.6.3
database link,
12.1.1
link station,
6.6.2
,
8.6.3
local LU names,
6.6.2
,
8.6.3
partner LUs,
6.6.2
,
8.6.3
remote node definition,
6.6.2
,
8.6.3
SNA definitions for the gateway,
6.6
,
8.6
SNAplus2 profiles,
6.4
,
8.4
cursor
defining the number of,
13.10
number of cursors, DRDA_PACKAGE_SECTIONS,
C.4.24
stability, DRDA_ISOLATION_LEVEL,
C.4.16
D
data coercion,
13.6
data control language (DCL),
1.3.7
DATA datatype,
13.7.4.1
data definition language (DDL),
1.3.6
data dictionary
support,
11.5.2
using,
13.9.1
views
ALL_DB_LINKS,
12.1.3
considerations for migration from previous releases,
15.4
emulation on DRDA Server,
13.9
for DB2/VM and DB2/UDB not supported,
A.1
list and descriptions,
A.2
supported for DB2/OS390 and DB2/400 servers,
A.1
USER_DB_LINKS,
12.1.3
database
authorities - CONNECT, BINDADD, and CREATETAB,
5.4
catalogs,
13.9
link
behavior,
13.4
binding the gateway package,
11.4.1
creating,
12.1.1
defining and controlling,
14.3
dropping links,
12.1.2
examining,
12.1.3
guidelines,
12.1.1
limits,
12.1.4
processing,
12.1
public,
11.7.1
suffix,
13.1
to identify the gateway,
1.7
triggers,
1.3.2
datatype
character string,
13.7.1
column (ALL_TAB_COLUMNS),
A.2.10
column (USER_TAB_COLUMNS),
A.2.26
conversion
DRDA to Oracle datatypes,
13.7
no control over,
13.7.8
converting character string,
13.7.1
,
13.7.2
data and time,
13.7.4
differences between Oracle server and DRDA databases,
13
DRDA Server datatypes list,
13.7
mapping,
13.7
numeric,
13.7.10
operations, numeric,
13.7.8
Oracle datatypes RAW and LONG RAW,
13.7.1
restrictions,
13.7
size and value limitations,
13.7
datatypes
DATE,
13.7.4
GRAPHIC,
13.7.3
LONG,
13.7.2
LONG RAW,
13.7.1
Oracle and IBM DATE,
13.7.4.2
Oracle DATE,
13.7.4.1
RAW
character string operations,
13.7.1
DRDA_DEFAULT_CCSID,
C.4.8
TIME,
13.7.4
TIMESTAMP,
13.7.4
VARCHAR,
13.7.2
date
date columns, TO_DATE function,
13.7.7
DELETE
statement,
13.7.5
HS_NLS_DATE_FORMAT parameter,
13.7.5
,
13.7.6
INSERT
statement,
13.7.5
operations,
13.7.4
SELECT statement,
13.7.5
TO_DATE function,
13.7.5
UPDATE
statement,
13.7.5
date arithmetic
known restrictions,
2.6.1
DATE datatype,
13.7.4
DB_DOMAIN parameter
known restrictions,
2.6.1
DB2
02pcg.sql granting authority,
11.5.2.1
alias objects
known restrictions,
2.6
aliases,
C.4.9
CICS,
13.3.2
configuring DB2/OS390,
5.2
data access,
1.3.9
Distributed Data Facility (DDF),
5.2
DRDA_DESCRIBE_TABLE compatibility,
C.4.9
IBM DB2 Version 5.1 ASCII Tables,
1.9
IMS,
13.3.2
native SQL,
1.3.8
native stored procedures,
1.3.9
procedural feature considerations,
13.3.2
SPUFI utility,
5.2
SQL statements,
13.8.1
statements
CREATE TABLE,
1.3.8
stored procedures,
13.3.2
DB2/400
catalog view,
13.9.1
configuring,
5.3
data dictionary views supported by gateway,
A.1
DRDA_DEFAULT_CCSID,
C.4.8
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_OPTIMIZE_QUERY,
C.4.19
DRDA_PACKAGE_COLLID,
C.4.20
user ID mapping,
14.5.1.3
DB2/OS390
catalog view,
13.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
user ID mapping,
14.5.1.1
V6, V7 and V8 stored procedures supported,
1.9
DB2/UDB
binding packages,
11.4.2
binding the gateway package,
11.5.1.2
catalog view,
13.9.1
configuring,
5.4
,
5.4
data dictionary views not supported,
A.1
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_OPTIMIZE_QUERY,
C.4.19
known restrictions,
2.6.1
supported,
1.9
user ID mapping,
14.5.1.4
DB2/VM
catalog view,
13.9.1
configuring,
5.5
data dictionary views not supported,
A.1
database and SQL functions,
13.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
server machine,
14.5.1.2
user ID mapping,
14.5.1.2
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function,
13.8
DD basic tables, known restrictions,
2.6.1
DDF
DB2 (Distributed Data Facility),
5.2
subsystem,
5.2
DDL
statement,
13.8
debug
gateway,
16.4
library,
16.4.2
debugging
error codes,
16.1.3
SQL tracing,
16.4
your application,
12.10
default port number for DRDA, TCP/IP configuration,
9.1
default TP name for DRDA Server
SNAP-IX product on Solaris,
6.6.2
SNAPlus2 product on HP-UX,
8.6.3
de-installing the gateway,
4.7
DELETE
known restrictions, SQL limitations,
2.6.2
operation,
13.1
read-only gateway,
12.6
SQL clause,
13.7.7
statement,
13.8
DESCRIBE
character string operations,
13.7.1
Destination Hostname or IP Address, same as DRDA Server Hostname or IP Address (configuring TCP/IP, worksheet),
E
Destination Service Port Number, same as DRDA Server Service Port Number (configuring TCP/IP, worksheet),
E
diagnostic parameter,
C.4.39
dictionary
mapping,
1.3.4
tables,
13.9
DICTIONARY view,
A.2.15
disk space requirements,
3.1
distributed
applications, support for,
1.9
data facility (DDF),
5.2
database,
10.3
distributed query optimizer (DQO)
DRDA-specific parameters,
C.4.19
performing distributed queries,
12.5
DRDA transactions,
12.5.2
operations, DB2,
5.2
processing,
10.3
queries
two-phase commit,
12.5.1
transaction, DRDA_RECOVERY_USERID,
C.4.27
dmesg,
6.6.2
double-byte support,
D.5
DQO
also see distributed query optimizer,
12.5
DRDA-specific parameters,
C.4.19
drc error code,
16.1.3
DRDA
catalog,
13.9.2
database requirements,
3.2
defining number of cursors,
13.10
DRDA Application Server Function,
1.9
gateway package considerations,
11.5
location name
for DB2/UDB instance,
5.4
for DB2/VM instance,
5.5
mode, IBMRDB
on HP-UX,
8.6.3
on Solaris,
6.6.2
session security options,
14.5.1.1
DRDA Server
accessing,
11.9
and dependent LUs
on HP-UX,
8.5
on Solaris,
6.5
and independent LUs
on HP-UX,
8.5
on Solaris,
6.5
and Side Information Profiles
on HP-UX,
8.4
on Solaris,
6.4
architecture,
1.5
capabilities, native semantics,
13.6
character sets
known restrictions,
2.6.1
client applications initiate conversations using dependent LUs
on HP-UX,
8.5
on Solaris,
6.5
configuring
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
considerations for binding packages,
15.4
copying data
from Oracle server,
12.8
to Oracle server,
12.9
database link behavior,
13.4
default port number for TCP/IP configuration,
9.1
default TP name
on HP-UX,
8.6.3
on Solaris,
6.6.2
functions,
13.6
Hostname or IP Address (configuring TCP/IP, worksheet),
E
languages and character sets in configuration,
D.4
Logical Unit (LU)
IBM Communication Server product on AIX,
7.2
SNAP-IX product on Solaris,
6.7
SNAPlus2 product on HP-UX,
8.7
partner LU
on HP-UX,
8.6.3
on Solaris,
6.6.2
port number (TCP/IP),
9.1
Service Port Number (configuring TCP/IP, worksheet),
E
stored procedures,
13.3
VTAM definitions and local LU names
on HP-UX,
8.6.3
on Solaris,
6.6.2
DRDA_CAPABILITY parameter,
13.6
DRDA_CMSRC_CM_IMMEDIATE parameter,
C.4.7
DRDA_CODEPAGE_MAP parameter,
D.4
DRDA_COMM_BUFLEN parameter,
C.4.4
DRDA_CONNECT_PARM (SNA format) parameter,
C.4.5
DRDA_CONNECT_PARM (TCP/IP format) parameter,
C.4.6
DRDA_CONNECT_PARM parameter
communication errors,
16.1.4
DRDA_DEFAULT_CCSID parameter,
C.4.8
DRDA_DESCRIBE_TABLE parameter
defined,
C.4.9
known restrictions,
2.6
DRDA_DESCRIBE_TABLE=FALSE initialization parameter
known restrictions,
2.6
DRDA_DISABLE_CALL parameter
binding the DRDA gateway package,
11.5.1.1
defined,
C.4.10
DRDA_FLUSH_CACHE parameter,
C.4.11
DRDA_GRAPHIC_LIT_CHECK parameter,
C.4.14
DRDA_GRAPHIC_PAD_SIZE parameter,
C.4.13
DRDA_GRAPHIC_TO_MBCS parameter,
C.4.15
DRDA_ISOLATION_LEVEL parameter,
C.4.16
DRDA_LOCAL_NODE_NAME parameter,
C.4.17
DRDA_MBCS_TO_GRAPHIC parameter,
C.4.18
DRDA_OPTIMIZE_QUERY parameter
defined,
C.4.19
DQO capability turned on and off,
12.5
DRDA_PACKAGE_COLLID parameter
defined,
C.4.20
errors detected by the server database,
16.1.5
DRDA_PACKAGE_CONSTOKEN parameter,
C.4.21
DRDA_PACKAGE_NAME parameter
binding the DRDA gateway package,
11.5.1.1
defined,
C.4.22
errors detected by the server database,
16.1.5
DRDA_PACKAGE_OWNER parameter,
C.4.23
DRDA_PACKAGE_SECTIONS parameter
defined,
C.4.24
defining the number of DRDA cursors,
13.10
DRDA_READ_ONLY parameter,
12.6
defined,
C.4.25
DRDA_RECOVER_USERID
DB2/400,
5.3
DB2/OS390,
5.2
DB2/VM,
5.5
if the user ID is not specified,
5.4
DRDA_RECOVERY_PASSWORD parameter
DB2/400,
5.3
DB2/OS390,
5.2
defined,
C.4.26
defining the recovery user ID,
5.4
DRDA_RECOVERY_USERID parameter
DB2/400,
5.3
DB2/OS390,
5.2
DB2/VM,
5.5
defined,
C.4.27
defining the recovery user ID,
5.4
DRDA_REMOTE_DB_NAME parameter,
C.4.28
DRDA_SECURITY_TYPE parameter,
C.4.29
DROP DATABASE LINK statement,
12.1.2
dropold.sql script,
11.5.2.1
DSPRDBDIRE command,
5.3
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,
13.6.2
tables, known restrictions,
1.9
translated to ASCII,
13.7.1
EMP
system-wide synonym,
12.4
table,
12.8
empproc
stored procedure,
13.3
encryption types for Advanced Security,
10.6
environment
heterogeneous,
12.7
environment variable
$DISPLAY
on HP-UX,
8.6.3
on Solaris,
6.6.2
NLS_LANG
client character set,
D.2
description of use,
D.1
ORA_NLS33,
D.1
ORACLE_HOME,
4.6
errd
mapped error example,
16.2
errmc
CPI-C routine,
16.1.4
errmc field lists any error tokens,
16.1.3
error tokens,
16.1.5
mapped error example,
16.2
error
12660 (test error for Advanced Security),
10.6
array (errd),
16.1.5
basic description,
16.1
change, ORA-09100 to ORA-28500,
16.1.3
change, ORA-09101 to ORA-28501,
16.1.3
codes
drc,
16.1.3
grc,
16.1.3
communication,
16.1.4
date,
D.3.2.3
detected
by Oracle integrating server,
16.1.1
by server database,
16.1.5
by the gateway,
16.1.2
in DRDA software,
16.1.3
drc= field
-300xx,
16.3
-7xx,
16.3
HGO-00706,
16.1.2
interpreting error messages,
16.1
mapped sqlstate,
16.2
messages
Oracle LONG datatype is too long,
13.7.2
SNA Security Option,
6.8.2
,
7.3.2
,
8.7.1
messages & codes,
16
obsolete parameters,
15.3.4
ORA-00001, index constraint violated,
16.2
ORA-00942
mapped error example,
16.2
object name too long,
16.2
ORA-01017, logon denied,
16.2
ORA-01031, insufficient privileges,
16.2
ORA-01460, invalid CCSID,
16.2
ORA-01476, divide by zero,
16.2
ORA-02019,
16.1.1
ORA-2025, when using INSERT command,
12.8
ORA-28500 (was ORA-09100),
16.1.3
ORA-28501
communication error,
16.1.4
was ORA-09101,
16.1.4
ORA-9100 to ORA-9199,
16.1.1
Oracle mapped error codes,
16.2
specific gateway error codes,
16.3
tokens,
16.1.3
translation,
13.7.1
while binding the gateway package,
11.4.1
with Native Semantics,
13.6
errp
errp field indicates program that detected error,
16.1.3
mapped error example,
16.2
EXCEPT set operator, SQL Set Clauses,
13.6.3
execute authority,
14.5.1.2
EXECUTE command,
1.3.9
EXECUTE privilege
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
exits
gateway local date,
13.7.6
EXPLAIN PLAN command,
16.4.1
EXPLAIN_PLAN table,
1.9
export encryption algorithms,
10.5
F
FDS_CLASS parameter,
C.4.30
FDS_CLASS_VERSION parameter,
C.4.31
FDS_INSTANCE parameter,
C.4.32
features of the gateway
application development and end-user tools,
1.9
application portability,
1.9
columns supported in a result set,
1.9
distributed applications supported,
1.9
EXPLAIN_PLAN improvement,
1.9
fetch reblocking,
1.9
heterogeneous database integration,
1.9
heterogeneous services architecture,
1.9
large base of data access,
1.9
main topic,
1.9
minimum impact on existing systems,
1.9
Native Semantics,
1.9
Oracle Database passthrough supported,
1.9
Oracle snapshots,
12.7
performance enhancements,
1.9
remote data access,
1.9
retrieving result sets through passthrough,
1.9
support for TCP/IP,
1.9
fetch array size, with HS_FDS_FETCH_ROWS,
C.4.33
fetch reblocking
controlled by two Heterogeneous Services initialization parameters,
1.9
supported by Oracle Database server,
13.1.1
fetched date,
C.4.37
fields
errmc, lists any error tokens,
16.1.3
errp, indicates program that detected error,
16.1.3
file member
accessing AS/400 files,
12.3
name,
12.3
files
initsid.ora
communication errors,
16.1.5
gateway error -700,
16.3
listener.ora,
10.4
sample
listener.ora,
B.3
tnsnames.ora,
B.2
sna_domn.cfg
on HP-UX,
8.6
on Solaris,
6.6
sna_node.cfg
on HP-UX,
8.6
on Solaris,
6.6
tnsnames.ora
configuring additional DRDA Server instances,
11.9
modifying,
10.4
VSAM,
13.3.2
FOR BIT DATA
DRDA_DEFAULT_CCSID,
C.4.8
option,
13.7.1
free session, DRDA_CMSRC_CM_IMMEDIATE,
C.4.7
functions
COS,
13.5.3.1
COUNT,
13.7.9
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE,
13.8
DRDA Server,
13.6
SQL
SUBSTR,
13.6
SUBSTR
known restrictions,
2.6.1
TO_DATE
DB2 ISO format,
13.7.6
processing DATE data,
13.7.4.2
twenty-first century dates,
13.7.5
TO_DATE, main topic,
13.7.7
G
g4ddtab.sql script,
11.5.2.1
g4ddview.sql script,
11.5.2.1
gateway
accessing
from other Oracle servers,
11.8
main topic,
12.2
advantages
main topic,
1.2
migration and coexistence,
1.3.15
multi-site transactions,
1.3.13
security,
1.3.16
server technology and tools,
1.3.11
site autonomy,
1.3.14
two-phase commit,
1.3.13
and Oracle tools,
1.8
and stored procedures (Oracle and non-Oracle),
1.3.9
application tools,
1.9
architecture,
1.5
authenticating logons,
14.2
benefits of integration with Oracle Database server,
1.3.3
binding DRDA packages,
11.4.1
components,
1.6
configuration,
11.3
definition of terms,
1.4
de-installing,
4.7
,
4.8
DRDA package considerations,
11.5
error codes,
16.3
errors detected,
16.1.2
features, main topic,
1.9
how to access,
12.2
installation
log file,
4.6
steps via Oracle Universal Installer,
4.6
steps, from CD-ROM,
4.6
interface,
1.7
local date exit,
13.7.6
logging, LOG_DESTINATION,
C.4.36
migration problems,
15.2
parameter,
5.5
performance enhancements,
1.9
performance versus transparency,
13.6
performing distributed queries,
12.5
read-only option,
12.6
service name entries in the tnsnames.ora,
15.5
settings for security options
on AIX,
7.3
on HP-UX,
8.7.1
on Solaris,
6.8
SQL differences,
1.7
supported languages,
D.4
tracing
LOG_DESTINATION,
C.4.36
SQL statements,
12.10
using,
12
with other Oracle products, SQL*Plus,
1.3.12
Gateway Initialization File
backup and recovery of gateway configuration,
11.6
configuring for binding the DRDA gateway package,
11.4.1
if errors are reported,
11.4.1
modifying,
C.1
parameters
DRDA_READ_ONLY,
12.6
list,
C.4
LOG_DESTINATION,
16.4.2
new since V4 gateway,
15.3.1
ORACLE_DRDA_TCTL,
16.4.2
stored in initsid.ora,
C.2
TRACE_LEVEL,
16.4.2
sample,
B.1
Gateway System Identifier (SID),
11.2
GCS virtual machine,
14.5.1.2
GLOBAL_NAMES
known restrictions,
2.6.1
GRANT statement
DB2/VM access,
14.5.1.2
synonyms and views,
11.7.2
granting authority to a package for DB2,
11.5.2.1
GRAPHIC datatype,
13.7.3
graphic string operations
unsupported,
13.7.3
grc error code,
16.1.3
GROUP BY clause
SQL Set Clauses,
13.6.3
GTW$_BIND_PKG
internal stored procedure,
11.5
stored procedure,
11.4.1
H
hardware requirements,
3.1
HAVING clause
SQL Set Clauses,
13.6.3
heterogeneous database integration,
1.9
Heterogeneous Services (HS), see HS,
1.2
HGO-00706 error,
16.1.2
host
DRDA Server, SNA and TCP/IP protocols,
1.5
Logical Unit (LU)
on AIX,
7.2
on HP-UX,
8.7
on Solaris,
6.7
networking needs,
3.2
performing character string operations on,
13.7.1
relationship to gateway and Oracle Server,
1.5
security validation required to begin database link
on AIX,
7.2
on HP-UX,
8.7
on Solaris,
6.7
SNAP-IX definitions,
6.6.1
variable,
13.7
HP9000 host
creating local LUs,
8.6.3
invoking xsnapadmin,
8.6.3
sample SNAPlus2 definitions,
8.6.1
HS (Heterogeneous Services)
architecture features,
1.9
Oracle Net considerations,
15.5
HS= (TNSNAMES parameter for Oracle Net)
gateway migration problems,
15.2
modify tnsnames.ora file,
10.4
HS_DB_DOMAIN parameter
known restrictions,
2.6.1
HS_FDS_FETCH_ROWS parameter,
C.4.33
HS_LANGUAGE parameter,
C.4.34
HS_NLS_DATE_FORMAT
for dates used by the DRDA Server,
D.3.2.3
four date patterns,
13.7.6
HS_NLS_DATE_LANGUAGE,
D.3.2.4
HS_NLS_NCHAR
character set to interchange GRAPHIC data,
D.3.2.2
defined,
C.4.35
HS_RPC_FETCH_REBLOCKING parameter
controlling array blocksize and the block fetch,
1.9
Oracle Database server support,
13.1.1
HS_RPC_FETCH_SIZE parameter
specified in the Gateway Initialization File,
1.9
value determines array size,
13.1.1
I
IBMRDB
DRDA mode on HP-UX
CPI-C destination dialog box,
8.6.3
IBMRDB mode dialog box,
8.6.3
DRDA mode on Solaris
CPI-C destination dialog box,
6.6.2
IBMRDB mode dialog box,
6.6.2
implementation,
1.6
implicit data conversion,
13.6
implicit protocol conversion,
1.3.3
IMS transaction,
13.3.2
IN and OUT columns, multi-byte support,
D.5
inbound connections
processing,
14.5
initdrdahoa1.ora
sample,
B.1
initialization parameters
new since V4 gateway,
15.3.1
initsid.gtwboot file, migrating,
15.1
initsid.ora file
communication errors,
16.1.5
migrating,
15.1
NLS parameters,
D.3.2
input bind variables,
13.7.4.2
INSERT
known restrictions,
2.6
operation,
13.1
Oracle SQL command, known restrictions,
2.6
read-only gateway,
12.6
SQL clause,
13.7.7
statement
dates,
13.7.5
passthrough SQL feature,
13.8
INSERT command
known restrictions,
2.6
not supported,
12.8
supported by COPY,
12.8
installation
checklist for gateway installation,
4.3
checklists,
4.3
,
10.1
installing the gateway from CD,
4.6
overview,
4.4
internal tracing,
C.4.40
Internet support,
1.3.3
INTERSECT, SQL set operators and clauses,
13.6.3
IPC adapter,
B.3
ISO standard,
1.3.5
isolation level, DRDA_ISOLATION_LEVEL,
C.4.16
J
JOIN capability,
1.3.2
JOIN SQL statement,
13.1
K
keywords, LISTENER,
B.3
known restrictions
accessing DB2 alias objects,
2.6
AVS mapping user IDs,
2.6.1
bind variables become SQL parameter markers,
2.6.2
binding the DRDA gateway package on DB2/UDB,
2.6.1
CONNECT BY not supported, SQL limitations,
2.6.2
,
2.6.2
datatype limitations,
2.6.1
date arithmetic,
2.6.1
DD basic tables and views,
2.6.1
dictionary views not provided for DB2/VM,
2.6.1
DRDA Server character sets,
2.6.1
GLOBAL_NAMES parameter,
2.6.1
INSERT (Oracle SQL command),
2.6
LONG datatype in SQL*Plus,
2.6.1
null values and stored procedures,
2.6.1
Oracle ROWID column,
2.6.2
row length limitation,
2.6.1
SAVEPOINT,
2.6.1
single gateway instances per DRDA network interface,
2.6.1
string concatenation,
2.6.1
SUBSTR function post-processed,
2.6.1
Korn shell
setting ORACLE_HOME variable,
4.6
L
LANGUAGE parameter,
D.3.2.1
languages
access through the gateway,
1.3.10
SQL*Plus,
1.3.12
lanscan command,
6.6.2
,
8.6.3
link station
creating,
6.6.2
,
8.6.3
parameters,
6.6.2
,
8.6.3
testing SNA connection,
6.9
,
8.8
link, also see Database Link,
13.4
linkage conventions
SIMPLE WITH NULLS,
13.3.2
listener,
B.3
LISTENER keyword,
B.3
listener.ora file,
10.4
sample,
B.3
literal
character literals,
13.7.4.1
date,
13.7.4.2
specific datatype,
13.7
TO_DATE, format support,
13.7.7
log file, gateway installation,
4.6
LOG_DESTINATION parameter
defined,
C.4.36
file name or path name,
16.4.2
SQL tracing,
16.4.2
with ORACLE_DRDA_TRACE,
C.4.40
logging, LOG_DESTINATION,
C.4.36
Logical Unit (LU)
IBM Communication Server product on AIX,
7.2
SNAP-IX product on Solaris,
6.7
SNAPlus2 product on HP-UX,
8.7
Login as DBA,
4.6
LONG datatype,
13.7.2
LONG RAW datatype,
13.7.1
,
13.7.1
LU
dependent
additional SNAPlus2 configuration needed,
6.5
,
8.5
Side Information Profiles,
6.5
,
8.5
SNAP-IX product on Solaris,
6.5
SNAPlus2 product on HP-UX,
8.5
independent vs. dependent
SNAP-IX product on Solaris,
6.5
SNAPlus2 product on HP-UX,
8.5
local LU alias
CPI-C destination on HP-UX,
8.6.3
CPI-C destination on Solaris,
6.6.2
create Local LU names on Solaris,
6.6.2
Ethernet parameters on HP-UX,
8.6.3
local names
creating, on HP-UX,
8.6.3
creating, on Solaris,
6.6.2
names,
6.6.2
,
8.6.3
partner
creating,
6.6.2
,
8.6.3
SNAP-IX profiles,
6.4
SNAPlus2 profiles,
8.4
traffic type, in configuring SNAplus2,
6.6.2
,
8.6.3
LU name,
14.5.1.1
LU6.2
local LU profile,
7.1.2.2
profile types,
7.1.2.2
side information profile,
7.1.2.2
SNA APPC
IBM Communication Server product on AIX,
7
SNAP-IX product on Solaris,
6
SNAPlus2 product on HP-UX,
8
M
MAC address
in SNA configuration, Solaris,
6.6.2
in SNAplus2 configuration, HP-UX,
8.6.3
mapped sqlstate errors,
16.2
mapping user IDs
AVS,
14.5.1.2
known restrictions,
2.6.1
migrating the gateway instance,
15.4
migration problems,
15.2
MINUS
set operator, SQL Set Clauses,
13.6.3
SQL set operators and clauses,
13.6.3
Mobile Agents,
1.3.3
mode
name, HP-UX,
8.6.3
name, Solaris,
6.6.2
profiles, creating on HP-UX,
8.6.3
profiles, creating on Solaris,
6.6.2
Mode Profile
SNA Server profile on AIX,
7.1.2.2
multi-byte support,
D.5
MVS VTAM
configuring DB2/OS390,
5.2
N
National Language Support (NLS)
overview,
D
Native Semantics
gateway architecture,
1.9
parameters, SQL Set Clauses,
13.6.3
with SUBSTR function, known restrictions,
2.6.1
network
attachment,
3.1
Oracle Net configuration,
10.4
requirements,
3.1
NLS (National Language Support)
DRDA Server character sets,
D.4
initsid.ora parameters,
D.3.2
parameters
configuration on client and Oracle servers,
D.2
NLS_LANG
environmental variable,
D.1
server-side parameter,
D.1
NLS_LANG environment variable,
D.2
non-character binary data,
13.7.1
null
rows, mapping the COUNT function,
13.7.9
values
mapping the COUNT function,
13.7.9
number of cursors, DRDA_PACKAGE_SECTIONS,
C.4.24
numbers
concatenation restrictions,
2.6.1
numeric datatype
zoned decimal column,
13.7.10
O
o2pc.sql
ORACLE2PC table,
11.5.2.1
two-phase commit transactions,
12.5.1
obsolete parameters since V4 gateway,
15.3.4
open cursors, at the IBM database,
13.10
OPEN_LINKS parameter,
12.1.4
operating system
user ID for DB2/UDB,
5.4
operating system requirements,
3.2
operations
DELETE,
13.1
INSERT,
13.1
SELECT,
13.1
UPDATE,
13.1
operators
UNION ALL, SQL Set Clauses,
13.6.3
UNION, SQL Set Clauses,
13.6.3
option
binding packages,
11.4.2
data dictionary views,
13.9
date format string,
13.7.5
DRDA session security,
14.5.1.1
FOR BIT DATA,
13.7.1
Oracle server,
1.5
read-only
gateway configuration,
1.3.13
replicating,
12.7
security conduct,
14.5
service port number, DRDA_CONNECT_PARM,
C.4.6
SNA security,
6.8
,
7.3
,
8.7.1
SQL functions,
13.6.1
SQL*Plus COPY command,
12.8
ORA_MAX_DATE parameter,
C.4.37
ORA_NLS33 parameter,
C.4.38
description,
D.1
ORA-00001 error, index constraint violated,
16.2
ORA-00942 error
mapped error example,
16.2
object name too long,
16.2
ORA-01017 error, logon denied,
16.2
ORA-01031 error, insufficient privileges,
16.2
ORA-01460 error, invalid CCSID,
16.2
ORA-01476 error, divide by zero,
16.2
ORA-02019 error,
16.1.1
ORA1 Oracle instance,
13.2
ORA2 Oracle instance,
13.2
ORA-2025
error when using INSERT command,
12.8
ORA-28500 error
was ORA-09100,
16.1.3
ORA-28501 error
communication error,
16.1.4
ORA-9100 to ORA-9199 errors,
16.1.1
Oracle
directory tree,
4.6
mapped error codes,
16.2
products compatibility,
1.8
RAW datatype,
C.4.8
snapshots,
12.7
Oracle Database
stored procedure, defined,
13.2
Oracle integrating server
accessing gateway from other Oracle Database servers,
11.8
accessing other DRDA servers,
11.9
accessing the gateway,
12.2
architecture,
1.5
configuration,
11.7
definition,
1.4
errors detected,
16.1.1
requirements,
3.2
using, in application development,
13.1
Oracle Net,
15.5
and application development,
1.9
and distributed processing,
10.3
and remote data access,
1.9
and server coexistence,
1.5
API,
10.3
compatibility with SQL*Net,
10.2
configuring,
10.4
,
10.4
distributed
database,
10.3
processing,
10.3
editing to set up security test,
10.6
Heterogeneous Services (HS) facility,
10.2
integrated with Oracle Database server,
1.3.11
introduction,
10.2
operating system authentication,
14.2
overview,
10.3
purpose,
1.6
requirements,
3.2
,
3.2
sample files,
B
sample listener.ora file,
B.3
support for CHECKSUM and encryption,
10.5
terminology,
10.3
client,
10.3
driver,
10.3
host,
10.3
network,
10.3
protocol,
10.3
TNS connect descriptor specification,
12.1.1
Oracle ROWID column
known restrictions,
2.6.2
Oracle server
copying data
from DRDA Server,
12.9
to DRDA Server,
12.8
relationship to host,
1.5
services
database triggers,
1.3.2
distributed capabilities,
1.3.2
distributed query optimization,
1.3.2
extended database services,
1.3.2
SQL,
1.3.2
stored procedures,
1.3.2
two-phase commit protection,
1.3.2
triggers,
12.7
Oracle Universal Installer
removing the gateway,
4.8
starting,
4.6
steps to install the gateway,
4.6
upgrading for installation,
4.6
ORACLE_DRDA_TCTL parameter
defined,
C.4.39
SQL tracing in the gateway,
16.4.2
ORACLE_DRDA_TRACE parameter, defined,
C.4.40
ORACLE_HOME
environmental variable,
4.6
for the gateway,
4.6
ORACLE2PC table
binding packages on DB2/UDB,
11.4.2
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
,
5.4
DB2/VM,
5.5
distributed DRDA transactions,
12.5.2
DRDA_PACKAGE_OWNER,
C.4.23
ORADRDA.ORACLE2PC table,
12.5.1
oraproc1, stored procedure,
13.2
oraproc2, stored procedure,
13.2
ORARECOV user ID
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
DRDA_RECOVERY_USERID,
C.4.27
ORDER BY clause
SQL Set Clauses,
13.6.3
OS/390 (MVS)
configuring DB2/OS390,
5.2
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
privileges - BIND, COPY, and EXECUTE
DB2/OS390,
5.2
DB2/VM,
5.5
packed decimal,
13.7.10
parameter
changed,
15.3.2
checking settings,
11.5.1.1
diagnostic,
C.4.39
gateway,
5.5
link station
on HP-UX,
8.6.3
on Solaris,
6.6.2
Native Semantics, SQL Set Clauses,
13.6.3
new since V4 gateway,
15.3.1
obsolete since V4 gateway,
15.3.4
renamed since V4 gateway,
15.3.3
setting up trace parameters,
16.4
parameter file
tailoring to configure the host,
11.4
parameters
DB_DOMAIN
known restrictions,
2.6.1
DRDA_CAPABILITY,
13.6
DRDA_CODEPAGE_MAP
defined,
C.4.3
mapping IBM CCSID,
D.4
DRDA_DESCRIBE_TABLE
known restrictions,
2.6
DRDA_DISABLE_CALL,
11.5.1.1
DRDA_PACKAGE_NAME,
11.5.1.1
DRDA_PACKAGE_SECTIONS,
13.10
DRDA_READ_ONLY,
12.6
DRDA_RECOVERY_PASSWORD
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DRDA_RECOVERY_USERID
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
FDS_CLASS,
C.4.30
FDS_CLASS_VERSION,
C.4.31
FDS_INSTANCE,
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,
16.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.14
DRDA_GRAPHIC_PAD_SIZE,
C.4.13
DRDA_GRAPHIC_TO_MBCS,
C.4.15
DRDA_ISOLATION_LEVEL,
C.4.16
DRDA_LOCAL_NODE_NAME,
C.4.17
DRDA_MBCS_TO_GRAPHIC,
C.4.18
DRDA_OPTIMIZE_QUERY,
12.5
,
C.4.19
DRDA_PACKAGE_COLLID,
16.1.5
,
C.4.20
DRDA_PACKAGE_CONSTOKEN,
C.4.21
DRDA_PACKAGE_NAME,
16.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
ORACLE_DRDA_TRACE,
C.4.40
TRACE_LEVEL,
C.4.41
HS_DB_DOMAIN
known restrictions,
2.6.1
HS_NLS_DATE_FORMAT,
13.7.5
,
13.7.6
HS_RPC_FETCH_REBLOCKING,
1.9
,
13.1.1
,
13.1.1
HS_RPC_FETCH_SIZE,
1.9
,
13.1.1
,
13.1.1
LOG_DESTINATION,
C.4.40
LOG_DESTINATON,
16.4.2
OPEN_LINKS,
12.1.4
USING, modifying tnsnames.ora file,
10.4
partner LU
creating, on HP-UX,
8.6.3
creating, on Solaris,
6.6.2
partner LU alias,
7.1.2.2
passthrough
gateway features,
1.9
native DB2 SQL,
1.3.8
send SQL statement directly to DRDA Server,
13.8
patch set
Oracle integrating server requires the latest released patch set,
3.2
patches
required for IBM Communications Server for AIX,
3.2
performance,
13.6
performance enhancements
with fetch reblocking,
13.1.1
PL/SQL
call,
13.3.1
DRDA stored procedures,
13.3
records,
13.3.2
routine,
1.3.9
standard Oracle,
1.3.9
stored procedure,
13.2
port,
6.6.2
,
8.6.3
adding, for SNA,
6.6.2
,
8.6.3
name, adding, for SNA,
6.6.2
,
8.6.3
port number
446 as default for DRDA services (TCP/IP),
9.1
5000 as default for DRDA services (TCP/IP),
9.1
for DRDA Server (TCP/IP),
9.1
Primary,
5.2
DB2/400,
5.3
Recovery,
5.2
DB2/400,
5.3
post-processed SQL functions
overview,
13.5.3.1
post-processing
native semantics,
13.6
SQL tracing in the gateway,
16.4.1
PREPARE TRANSACTION statement,
12.5.1
primary port number
DB2/400,
5.3
DB2/OS390,
5.2
privileges
BIND
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
BINDADD
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
BINDAGENT
DB2/OS390,
5.2
DB2/VM,
5.5
CONNECT
DB2/UDB,
5.4
COPY
DB2/OS390,
5.2
DB2/VM,
5.5
CREATE IN
DB2/OS390,
5.2
DB2/VM,
5.5
CREATE PUBLIC DATABASE LINK,
11.4.1
,
11.7.1
CREATEIN
DB2/UDB,
5.4
CREATETAB
DB2/OS390,
5.2
DB2/UDB,
5.4
data dictionary emulation,
13.9
EXECUTE
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
procedure
stored
read only gateway,
12.6
using DRDA Server,
13.3
processing time, with GROUPBY, HAVING, WHERE,
13.6.2
product installation directory,
4.6
profile
CPI-C side information,
6.6.2
,
8.6.3
creating
CPI-C and Mode profiles,
6.6.2
,
8.6.3
name
creating SNAP-IX profiles,
6.4
creating SNAPlus2 profiles,
8.4
set,
11.9
types, communication server profiles,
7.1.2.2
protocol
APPC/LU6.2
IBM Communication Server product on AIX,
7
SNAP-IX product on Solaris,
6
SNAPlus2 product on HP-UX,
8
commit confirm,
1.3.13
communications protocols,
10.3
converter,
1.3.3
definition,
10.3
implicit protocol conversion,
1.3.3
network,
12.4
Oracle Net Protocol Adapters,
10.2
PROTOCOL=IPC, sample,
B.2
protocol-independent encryption,
1.3.3
two-phase commit,
12.5.1
protocols
IPC,
10.4
SNA,
1.5
TCP/IP
DRDA Server architecture,
1.5
gateway transparency,
1.3.1
implicit protocol conversion,
1.3.3
public database link,
11.7.1
Q
queries, distributed,
12.5
R
RAW datatype
caution with DRDA_DEFAULT_CCSID,
C.4.8
performing character string operations,
13.7.1
read-only gateway option
improved performance and security,
12.6
set with DRDA_READ_ONLY,
C.4.25
read-only support,
1.9
rebind required with any change to
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
DB2/OS390,
5.2
recovery user ID and password
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
remote
computer,
10.3
connections,
12.1.4
data,
1.3.2
data access,
1.9
database
copying data,
12.8
creating database links,
12.1.1
DB2/400,
5.3
DB2/OS390,
5.2
DB2/UDB,
5.4
DB2/VM,
5.5
defining a path,
12.1.1
DRDA gateway package considerations, privileges,
11.5
DRDA_PACKAGE_SECTIONS,
C.4.24
errors detected by the Oracle integrating server,
16.1.1
gateway error code 30061,
16.3
privileges of user/ID,
E
DB2 system,
2.6
DRDA database, DRDA_ISOLATION_LEVEL,
C.4.16
instance, and Oracle stored procedures,
13.2
LU,
7.1.2.2
Oracle instance
using DRDA Server stored procedures with the gateway,
13.3
using Oracle stored procedures with the gateway,
13.2
Oracle servers, distributed database,
10.3
procedure,
1.3.9
table,
1.3.4
transaction program
creating communication server profiles,
7.1.2
hardware memory requirements,
3.1
userid and password,
12.1.1
remote node definition
creating a link station
SNAP-IX on Solaris,
6.6.2
SNAPlus2 on HP-UX,
8.6.3
renamed parameters,
15.3.3
REPLACE command, supported by COPY,
12.8
replication,
12.7
requirements
hardware,
3.1
software,
3.2
RESULT,
13.3.1
result sets
columns in,
1.9
retrieving result sets through passthrough,
1.9
REVISE_SALARY
stored procedure,
13.3.1
ROWID
Oracle column
known restrictions,
2.6.2
S
sample
files,
B
listener.ora file,
B.3
SQL scripts,
11.5.2
tnsnames.ora file,
B.2
SAP
dialog box,
6.6.2
,
8.6.3
number,
6.6.2
,
8.6.3
SAVEPOINT
known restrictions,
2.6.1
schema privileges - CREATEIN,
5.4
scripts
dropold.sql,
11.5.2.1
g4ddtab,
11.5.2.1
g4ddview.sql,
11.5.2.1
SDLC Coaxial network attachment,
3.1
security
Advanced Security,
1.3.3
DRDA_SECURITY_TYPE,
C.4.29
encryption,
10.5
for session use,
6.6.2
,
8.6.3
overview,
14.1
site autonomy,
1.3.14
validation
for SNA,
6.7
,
7.2
,
8.7
for TCP/IP,
14.4
SELECT and array size,
1.9
SELECT operation,
13.1
SELECT statement
fetch reblocking,
13.1.1
read-only gateway,
12.6
retrieving results sets,
13.8.2
SELECT WHERE
SQL clause,
13.7.7
semantics,
13.6
server database error,
16.1.5
server profiles
IBM Communication Server product on AIX,
7
SNAP-IX product on Solaris,
6
SNAPlus2 product on HP-UX,
8
service port number, DRDA_CONNECT_PARM,
C.4.6
Service TP
"07F6C4C2",
6.6.2
,
8.6.3
session
authorization,
6.6.2
,
8.6.3
connection,
13.4
set operators
compatibility, SQL Set Clauses,
13.6.3
EXCEPT, SQL Set Clauses,
13.6.3
INTERSECT, SQL Set Clauses,
13.6.3
MINUS, SQL Set Clauses,
13.6.3
shift attribute, multi-byte support,
D.5
SID
also see Gateway System Identifier,
11.2
choosing for gateway,
11.2
configuring additional DRDA Server instances,
11.9
definition,
11.2
side information profile
communication errors,
16.1.4
creating,
6.6.2
,
8.6.3
defining, to use dependent LUs,
6.5
,
8.5
description and role,
6.4
,
8.4
profile types,
7.1.2.2
,
7.1.2.2
specifies Local LU profile name,
7.1.2.2
SIMPLE linkage convention
gateway support,
13.3.2
sample DB2 stored procedure,
G.1
single-threaded conversations for dependent LUs,
6.5
,
8.5
site autonomy,
1.3.14
SNA
APPC,
7
,
8
configuring DB2/400,
5.3
configuring DB2/OS390,
5.2
configuring DB2/UDB,
5.4
configuring DB2/VM,
5.5
configuring server profiles,
7.1.1
connectivity via APPC,
6
conversation security,
6.8
,
7.3
,
8.7.1
CPI-C error,
16.1.4
definitions,
6.6.1
,
8.6.1
creating, for SNAP-IX,
6.6.2
creating, for SNAplus2,
8.6.2
creating, for the gateway,
6.6
,
8.6
maintenance,
6.6
,
8.6
facilities,
1.9
functions,
1.6
LU,
7.1.2.2
network,
6.6.1
,
6.6.1
,
6.6.2
,
8.6.1
name, in creating partner LUs,
6.6.2
,
8.6.3
profile,
11.9
profile definitions,
7.1.2
profiles,
6.4
,
8.4
protocol,
1.5
,
1.5
,
6.6.2
,
8.6.3
remote access,
1.9
sample profile definitions,
7.1.2.1
security
DRDA_SECURITY_TYPE,
C.4.29
option with IBM Communication Server product on AIX,
7.3.2
option with SNAP-IX product on Solaris,
6.8.2
option with SNAPlus2 product on HP-UX,
8.7.1
validation in SNA network versus TCP/IP,
14.4
validation with IBM Communication Server product on AIX,
7.2
validation with SNAP-IX product on Solaris,
6.7
validation with SNAPlus2 product on HP-UX,
8.7
SECURITY=PROGRAM,
6.8.1
,
7.3.1
,
8.7.1
SECURITY=SAME,
6.8.2
,
7.3.2
,
8.7.1
send/receive buffer,
C.4.4
session allocation mode, DRDA_CMSRC_CM_IMMEDIATE,
C.4.7
TPN,
7.1.2.2
SNA LU6.2
configuring DB2/400,
5.3
configuring DB2/OS390,
5.2
SNA node,
6.3
,
6.6.2
,
6.6.2
,
8.3
,
8.6.3
,
8.6.3
configuring,
6.6.2
,
8.6.3
SNA security option
IBM Communication Server product on AIX,
7.3.2
SNAP-IX product on Solaris,
6.8.2
SNAPlus2 product on HP-UX,
8.7.1
SNA Server
Link Profile,
7.1.2.2
Local LU Profile,
7.1.2.2
Partner LU Location Profile,
7.1.2.2
Partner LU Profile,
7.1.2.2
profiles
creating,
7.1.2
sample profile definitions,
7.1.2.1
Side Information Profile,
7.1.2.2
SNA server
network requirements,
3.1
sna_domn.cfg file,
6.6
,
8.6
sna_node.cfg file,
6.6
,
8.6
SNAP-IX
configuring,
6
configuring, using xsnaadmin program,
6.3
configuring, using xsnapadmin,
6.6.2
definitions
for the gateway,
6.6.1
stored in directory,
6.6
Side Information Profiles required,
6.4
testing the connection,
6.9
SNAPlus2
configuring,
8
configuring, using xsnapadmin,
8.6.2
SNAplus2
additional configuration needed for multiple dependent LUs,
6.5
,
8.5
configuring, using xsnapadmin program,
8.3
definitions
for the gateway,
8.6.1
stored in directory,
8.6
Side Information Profiles required,
8.4
testing the connection,
8.8
,
8.8
version required,
3.2
snapshots
known restrictions, SQL limitations,
2.6.2
Oracle Snapshot feature,
12.7
software requirements,
3.2
sort order
with ORDERBY,
13.6.2
SPUFI, a database native tool,
11.5.2
SQL
ANSI standard,
1.3.5
clause compatibility,
13.6.3
clauses
DELETE,
13.7.7
INSERT,
13.7.7
SELECT WHERE,
13.7.7
UPDATE,
13.7.7
constructs
Oracle processing,
13.5
differences in the gateway,
1.7
errors mapped to Oracle error codes,
16.2
functions
SUBSTR,
13.6
functions and Native Semantics,
13.6
functions list,
F
gateway architecture,
1.2
gateway transparency,
1.3.5
ISO standard,
1.3.5
native DB2,
1.3.8
passthrough,
13.8
,
13.8.1
,
13.8.2
,
13.8.2.1
statements,
13.1
DB2,
13.8.1
issued through the gateway,
12.10
passing through gateway,
13.8
statements, DRDA_ISOLATION_LEVEL,
C.4.16
syntax,
13.7.9
tracing, not to be used in production environment,
12.10
SQL functions
column functions,
13.5.1
compatible, defined,
13.5.1
compensated, defined,
13.5.3
DB2/400,
13.5.7
DB2/OS390,
13.5.5
DB2/UDB,
13.5.6
DB2/VM,
13.5.8
post-processing, defined,
13.5.3.1
that can be disabled,
13.6.2
that can be enabled,
13.6.1
translated, defined,
13.5.2
with Native Semantics,
13.6.1
SQL tracing
in Oracle Database,
16.4.1
in the gateway,
16.4.2
LOG_DESTINATION,
16.4.2
ORACLE_DRDA_TCTL parameter,
16.4.2
TRACE_LEVEL parameter,
16.4.2
SQL*Net
gateway migration problems,
15.2
Heterogeneous Services (HS) facility,
10.2
replaced by Oracle Net,
10.2
SQL*Plus
connecting to gateway,
10.7
COPY command,
12.8
extending gateway uses,
1.8.1
moving data,
1.3.12
sqlstate, mapped errors,
16.2
stability, of cursor, DRDA_ISOLATION_LEVEL,
C.4.16
standard port number for DRDA, TCP/IP configuration,
9.1
Startup Shell Script
parameter, tailoring to configure the host,
11.4
statement
CREATE DATABASE, client/server configuration,
D.2
statements
CREATE DATABASE LINK,
12.1.1
DB2 CREATE TABLE,
1.3.8
DDL,
13.8
,
13.8.1
DELETE,
13.7.5
,
13.8
DROP DATABASE LINK,
12.1.2
GRANT,
11.7.2
INSERT,
13.8
PREPARE TRANSACTION,
12.5.1
SELECT,
13.1.1
,
13.1.1
,
13.8.2
read-only gateway,
12.6
SQL
DB2,
13.8.1
JOIN,
13.1
SELECT,
13.8.2
UPDATE,
13.7.5
,
13.8
stored definitions
Side Information Profile needed for SNAP-IX,
6.4
Side Information Profile needed for SNAplus2,
8.4
stored procedure
creating on DB2,
13.3.1
DB2,
13.3.2
native DB2,
1.3.9
Oracle and non-Oracle,
1.3.9
Oracle Database Server
local instance,
13.2
Oracle Database server
PL/SQL,
13.2
remote instance,
13.2
Oracle Server
using,
13.2
Oracle, description,
1.3.9
restriction,
2.6.1
usage,
C.4.10
using DRDA Server,
13.3
stored procedures,
1.3.2
DB2,
12.6
,
13.3
GTW$_BIND_PKG,
11.4.1
REVISE_SALARY,
13.3.1
using with the gateway,
13.2
string concatenation
known restrictions,
2.6.1
string index, with Native Semantics,
13.6
Structured Query Language, also see SQL,
1.2
SUBSTR SQL function,
13.6
known restrictions,
2.6.1
with Native Semantics, known restrictions,
2.6.1
synonym
feature,
12.4
for location transparency,
13.2
how the gateway works,
1.7
system privileges - BINDADD and BINDAGENT
DB2/OS390,
5.2
DB2/VM,
5.5
T
table
create a table in DB2,
13.8.1.1
insert a row into a DB2 table,
13.8.1.1
TABLE_PRIVILEGES view,
A.2.17
tables
EXPLAIN_PLAN,
1.9
ORACLE2PC,
12.5.2
DB2/UDB,
11.5.1.2
scripts to create Data Dictionary tables and view,
11.5.2.1
ORADRDA.ORACLE2PC,
12.5.1
TCP/IP
adapter,
B.3
concurrent connections,
3.1
configuring
DB2/400,
5.3
DB2/OS390,
5.2
DB2/VM,
5.5
configuring under Solaris,
9.2
DRDA_CONNECT_PARM,
C.4.6
facilities,
1.9
format, gateway initialization file parameter,
C.4.6
functions,
1.6
modifying tnsnames.ora in Oracle Net,
10.4
network attachment,
3.1
number of database link connections,
13.4
protocol
gateway architecture,
1.5
gateway transparency,
1.3.1
implicit protocol conversion,
1.3.3
remote access,
1.9
security,
14.4
security validation,
14.4
support,
1.9
terminology defined,
1.4
tg4drda directory, also known as ORACLE_HOME,
4.6
TIME datatype,
13.7.4.1
time operations,
13.7.4
TIMESTAMP datatype,
13.7.4.1
TNSNAMES.ORA
changes to, during migration problems,
15.2
tnsnames.ora
connect descriptor,
12.1.1
file
adding a gateway service name,
10.4
configuring additional DRDA Server instances,
11.9
modifying for Oracle Net,
15.5
sample file,
B.2
TO_DATE function, main topic,
13.7.7
Token Ring,
3.1
token, package consistency, DRDA_PACKAGE_CONSTOKEN,
C.4.21
tools and the gateway,
1.8
TP name (TPN),
6.6.2
,
7.1.2.2
,
8.6.3
trace control,
C.4.39
trace parameters
setting,
16.4
TRACE_LEVEL parameter
defined,
C.4.41
SQL tracing in the gateway,
16.4.2
tracing
code,
C.4.41
LOG_DESTINATION,
C.4.36
ORACLE_DRDA_TRACE,
C.4.40
SQL statements,
12.10
trade-off, Native Semantics,
13.6
transaction mode, read-only, DRDA_READ_ONLY,
C.4.25
transaction program name, remote,
7.1.2.2
transactions
CICS,
13.3.2
IMS,
13.3.2
transform, character set transforms with multi-byte support,
D.5
transform, not required for DRDA Server,
D.5
transparency
main topic, gateway transparency,
1.3.1
native semantics,
13.6
triggers for Oracle Server,
12.7
TSO
configuring DB2/OS390,
5.2
two-phase commit
ORACLE2PC table
DB2/400,
5.3
DB2/UDB,
5.4
DB2/VM,
5.5
ORACLE2PC table, DB2/OS390,
5.2
processing transactions,
12.5.1
protection,
1.3.2
unsupported statement,
12.5.1
U
UNION
capability,
1.3.2
operator, SQL Set Clauses,
13.6.3
SQL set operators and clauses,
13.6.3
UNION ALL
operator, SQL Set Clauses,
13.6.3
SQL set operators and clauses,
13.6.3
UPDATE
known restrictions, SQL limitations,
2.6.2
operation,
13.1
read-only gateway,
12.6
SQL clause,
13.7.7
statement,
13.8
user ID mapping
AVS,
14.5.1.2
DB2/400,
14.5.1.3
DB2/OS390,
14.5.1.1
DB2/VM,
14.5.1.2
user ID translation, DB2,
14.5.1.2
user privileges,
13.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,
12.1.3
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
USING clause,
12.1.1
USING parameter, modifying tnsnames.ora file,
10.4
Using the gateway,
12
V
VALUES clause
functions not allowed by DB2,
13.7.7
VARCHAR datatype,
13.7.2
variable
bind, SQL passthrough,
13.8
input bind,
13.7.4.2
view
catalog
DB2/400,
13.9.1
DB2/OS390,
13.9.1
DB2/UDB,
13.9.1
DB2/VM,
13.9.1
creating,
11.7.2
data dictionary
emulation on DRDA Server,
13.9
VM VTAM
configuring,
5.5
VSAM
file,
13.3.2
VTAM
configuring DB2/OS390,
5.2
definitions
relationship to SNAplus2 definitions,
6.9
,
8.8
same local LU name as on remote DRDA Server,
6.6.2
,
8.6.3
security validation,
6.7
,
7.2
,
8.7
W
WHERE clause
known restrictions, SQL limitations,
2.6.2
SQL Set Clauses,
13.6.3
WHERE CURRENT OF CURSOR clause
known restrictions, SQL limitations,
2.6.2
wireless communication,
1.3.3
X
xsnaadmin
creating SNA definitions,
6.6.2
invoking,
6.6.2
SNAP-IX definitions,
6.6.1
tool to configure SNAP-IX,
6.3
tool to create SNAP-IX definitions,
6.6
xsnapadmin
creating SNA definitions,
8.6.2
invoking,
8.6.3
tool to configure SNAplus2,
8.3
tool to create SNAplus2 definitions,
8.6
X-Windows,
6.3
,
8.3
Z
zoned decimal operations,
13.7.10
Scripting on this page enhances content navigation, but does not change the content in any way.