Skip Headers

Oracle Transparent Gateway for IBM DRDA Installation and User's Guide
Release 9.2.0.1.0 for UNIX
Part Number A96194-02
Go To Table Of Contents
Contents

Go to previous page

Index

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

Symbols

$DISPLAY
environmental variables, 7-4, 9-4
$ORACLE_HOME, 7-4, 9-4

A

ABS SQL function, 14-25, F-1
accessing
DRDA servers, 11-14
gateway, 11-13
main topic, 13-4
ACOS function, F-1
ADD_MONTHS function, F-1
Advanced Program to Program Communication (APPC/LU6.2) protocol, 6-1, 7-1, 8-1, 9-1
Advanced Security
CHECKSUM command, 12-6
encryption, 12-6
international version types supported, 12-7
resetting configuration parameters on gateway, 12-8
setting test parameters for gateway, 12-7
setting test parameters for Oracle integrating server, 12-7
setting up for test, 12-7
testing gateway and Oracle integrating server, 12-8
export encryption algorithms, 12-6
function on the gateway, 1-6
purpose, 1-6
test error, 12-8
12660, 12-7
AGW ADD USERID command, 15-6
AGW DELETE USERID command, 15-6
AIX
AIX_RS6K, default value, C-7
System Management Interface Tool, 8-3
user ID for DB2/UDB, 5-7
alias
CPI-C destination, 7-15, 9-16
DB2, C-5
Ethernet parameters, 9-11
local LU alias, 7-10
partner LU, 8-5
alias objects, DB2
known restrictions, 2-6
ALL_CATALOG view, A-4
ALL_COL_COMMENTS view, A-4
ALL_CON_COLUMNS view, A-5
ALL_CONSTRAINTS view, A-6
ALL_DB_LINKS data dictionary view, 13-3
ALL_INDEXES view, A-7
ALL_OBJECTS view, A-9
ALL_SYNONYMS view, A-9
ALL_TAB_COMMENTS view, A-12
ALL_TABLES view, A-10
ALL_USERS view, A-13
ALL_VIEWS view, A-13
allocation mode, SNA session, DRDA_CMSRC_CM_IMMEDIATE, C-4
ALTER session statement, 13-3
ANSI-standard SQL, 1-6, 1-15
API (application program interface), 12-3
APPC
concurrent connections, 3-2
configuring IBM Communication Server, 8-1
configuring SNAP-IX interfaces, 7-1
configuring SUNLINK, 6-1
conversations, 8-3
creating SNAP-IX profiles, 7-2
creating SNAPlus2 profiles, 9-2
DB2/VM, 15-6
number of database link connections, 14-8
password length, 17-7
user ID length, 17-6
APPC VTAM Support (AVS)
also see AVS, 15-6
known restrictions, 2-6
APPC/LU6.2
parallel session limits, 8-4
protocol, 1-4, 7-1, 9-1
side information profile, 8-5
APPEND command
supported by COPY, 13-10
application
authenticating logons, 15-2
portability, 1-16
server support, 1-5
application development on the gateway, 1-18
application program interface
see API
APPN
node, advanced peer-to-peer networking node, 8-5
support requires VTAM Version 4, 8-5
architecture of the gateway, 1-10
array size, 1-14
how determined, 14-3
AS/400
command
DSPRDBDIRE, 5-6
communications
configuring, 5-5
files and file members
accessing, 13-5
library name, DRDA_PACKAGE_COLLID, C-9
ASCII
code page, D-5
function, F-1
sort order, 14-25
tables, known restrictions, 2-3
translated from EBCDIC, 14-27
US7ASCII, D-7
US7ASCII as default, D-4
ASCII SQL function, 14-25
ASIN function, F-1
ATAN function, F-1
ATAN2 function, F-1
authority
CONNECT, 15-6
execute, 15-6
autonomy, site, 1-9
available products, 4-7
available products menu, 4-7
AVS
also see APPC VTAM Support, 2-6
configuring, 5-9
DB2/VM, 15-6
mapping user IDs, 2-6, 15-6
mapping user IDs (DB2/VM)
known restrictions, 2-6
mapping user IDs with DB2/VMT, 15-6

B

binary data, non-character, 14-27
Bind Package Stored Procedure
DB2/400, 5-5
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
BIND privilege
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
bind variables, 14-36
restrictions, 2-10
BINDADD authority, 11-9
BINDADD privilege
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
BINDAGENT privilege
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
binding the DRDA package
backward compatibility, 16-6
DB2/400, 5-5
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
on DB2/UDB, 11-9
on DRDA server, 11-8
pre-binding checklist, 11-10
books
other recommended reading, 3-5
Bourne shell
setting ORACLE_HOME variable, 4-5
bug
debugging, 13-11, 17-3, 17-8
debugging with Startup Shell Script, 11-4
number 205538, known restrictions, 2-9
bugs fixed in this release, 2-4

C

C shell
setting ORACLE_HOME variable, 4-5
call
a CICS or IMS transaction, 14-7
DB2 stored procedure, 14-5, 14-6
DRDA_DISABLE_CALL, 11-10, B-2
empproc stored procedure, 14-5
Oracle Call Interfaces, 17-2
PL/SQL, 14-6
stored procedure, 14-3, 14-4
to stored procedure
known restrictions, 2-7
capabilities
DRDA server, 14-24
capability classification, C-14
catalog views, 14-39
CCSID
65535 as the default for all tables created, C-5
codepage mapping facility, D-9
description, D-4
DRDA_OVERRIDE_FROM_CODEPAGE, C-8
external mapping to Oracle character sets supported, 2-2
CD-ROM drive requirements, 3-2
CEIL SQL function, 14-25, F-1
changed parameters, 16-4
changes in this release
main topic, 2-3
bugs fixed, 2-4
gateway parameters, 2-3
IBM DB2 Version 5.1 EBCDIC and ASCII Tables, 2-3
IBM DB2/UDB supported, 2-3
Oracle server dependencies, 2-3
read-only support, 2-4
TNSNAMES.ORA, 2-3
CHAR_TO_ROWID function, F-1
CHARACTER SET parameter, D-4
description, D-3
character sets
and codepage map facility, D-9
ASCII, 2-3
CCSID, D-4
codepage, C-5
EBCDIC, 2-3
limitation, 2-7
supported, 2-2
character string
converting datatypes, 14-28
performing operations, 14-28
checklist
configuring the communications interfaces, 6-2, 8-2
configuring the DRDA server, 5-2
gateway configuration, 11-2
gateway installation, 4-3
installation overview, 4-3
Oracle Net, 12-2
CHECKSUM command, 1-6, 12-6
CHR SQL function, 14-25, F-1
CICS transaction, 14-7
clauses
CONNECT TO, 13-2
GROUP BY, 14-26
HAVING, 14-26
ORDER BY, 14-26
SQL
DELETE, 14-34
INSERT, 14-34
SELECT WHERE, 14-34
UPDATE, 14-34
USING, 13-2
VALUES
functions not allowed by DB2, 14-34
WHERE, 14-26
known restrictions, 2-9
WHERE CURRENT OF CURSOR
known restrictions, 2-9
code tracing, C-17
codepage map facility
configuring support for character sets, known restrictions, 2-7
for data translation, D-9
supported by gateway, 2-2
codepage, overriding, C-8
coercion
of data, 14-24
collection privilege - CREATE IN, 5-3, 5-7, 5-9
column
date columns, TO_DATE function, 14-34
Oracle ROWID
known restrictions, 2-9
supported in a result set, 1-15
commands
AGW ADD USERID, 15-6
AGW DELETE USERID, 15-6
CHECKSUM, 1-6, 12-6
COPY
known restrictions, 2-6
Oracle9i server to DRDA server, 13-10
COPY (SQL*Plus command), 13-10
CREATE DATABASE LINK
DB2/VM, 5-9
DESCRIBE
known restrictions, 2-6
EXECUTE, 1-7
EXPLAIN PLAN, 17-8
INSERT
known restrictions, 2-6
INSERT, not supported, 13-10
lanscan, 7-7, 9-7
commit confirm protocol, 1-8
Communication Database (CDB) tables, DDF, 5-4
communications requirements, 3-4
Communications Server
configuring server profiles, 8-3
profiles
creating, 8-3
compatible SQL set operators and clauses, 14-26
concatenation restrictions, 2-7
concurrent connections
APPC, 3-2
TCP/IP, 3-2
configuration
SNA sample file, 6-4
configuring
additional DRDA servers, 11-14
AS/400 communications, 5-5
AVS, 5-9
binding DRDA package, 11-10
checklist for gateway, 11-2
checklist for installation overview, 4-3
checklists, 4-3, 5-2, 6-2, 8-2, 11-2, 12-2
communications interfaces, steps for, 7-2, 9-2
DB2/400, 5-5, 5-7
DB2/OS390, 5-3
DB2/UDB, 5-7
host workstation for gateway, 11-4
MVS VTAM, 5-3
Oracle integrating server, 11-13
Oracle Net, 12-4
other Oracle servers, 11-13
SNA server
creating profiles, 8-3
testing connection, 8-6
SNAPlus2 on HP-UX, 9-1
SunLink SNA Peer-to Peer product, 6-3
TCP/IP
DB2/400, 5-5
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
under Solaris, 10-2
VM VTAM, 5-9
CONNECT authority, 11-9, 15-6
CONNECT BY not supported
known restrictions, 2-10
CONNECT TO clause, 13-2
contact information
in configuring SNAplus2, 7-8, 9-9
conversion
errors, C-5
convert
character string, 14-28
datatypes
DRDA to Oracle datatypes, 14-26
DATE, 14-29
floating point to integer, 14-34
inbound user ID, 15-6
into most suitable datatype, 14-35
SQL, 1-13
to the numeric datatype, 14-34
CONVERT SQL function, 14-25, F-1
converter, protocol, 1-6
COPY command
Oracle9i server to DRDA server, 13-10
COPY privilege
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
COPY SQL*Plus command, 13-10
substituted for INSERT, known restrictions, 2-6
copying data
from the DRDA server, 13-10
from the Oracle server to DRDA server, 13-10
COS SQL function, 14-9, 14-25, F-1
COSH SQL function, 14-25, F-1
COUNT function, 14-35
CP (Control Point for the Node), 7-3, 9-3
CPI-C
communication error messages, 17-4, 17-7
create Side Information Profile, 7-14, 9-15
profiles, creating, 7-12, 9-13
requires Side Information File, 6-4
routine, 17-4
side information profile, 7-14, 9-15
CREATE command
supported by COPY, 13-10
CREATE DATABASE LINK command, 13-2
DB2/VM, 5-9
CREATE IN privilege
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
CREATE PUBLIC DATABASE LINK privilege, 11-8, 11-13
CREATE TABLE statement, 1-7
CREATETAB authority, 11-9
creating
a new directory, 4-5
CPI-C and mode definitions, 7-12, 9-13
database link, 13-2
link station, 7-7, 9-8
local LU names, 7-10, 9-11
partner LUs, 7-11, 9-12
remote node definition, 7-7, 9-8
SNA definitions for the gateway, 7-3, 9-3
SNAplus2 profiles, 7-2, 9-2
cursor
defining the number of, 14-39
number of, C-11
stability, C-7
customizing
Startup Shell Script, B-3

D

data coercion, 14-24
data control language (DCL), 1-7
DATA datatype, 14-29
data definition language (DDL), 1-7
data dictionary
improved in this release, 2-3
support, 11-11
using, 14-39
views
ALL_DB_LINKS, 13-3
considerations for migration from previous releases, 16-6
emulation on DRDA server, 14-38
for DB2/VM and DB2/UDB not supported, A-2
list and descriptions, A-4
supported for DB2/OS390 and DB2/400 servers, A-2
USER_DB_LINKS, 13-3
database
catalogs, 14-38
database link
behavior, 14-7
binding the gateway package, 11-8
creating, 13-2
defining and controlling, 15-3
dropping links, 13-3
examining, 13-3
guidelines, 13-3
limits, 13-3
processing, 13-2
public, 11-13
suffix, 14-2
to identify the gateway, 1-12
database triggers, 1-5
datatype
character string, 14-27
column (ALL_TAB_COLUMNS), A-11
column (USER_TAB_COLUMNS), A-22
conversion
DRDA to Oracle datatypes, 14-26
no control over, 14-34
converting character string, 14-27, 14-28
data and time, 14-29
differences between Oracle server and DRDA databases, 14-1
DRDA server datatypes list, 14-26
mapping, 14-26
numeric, 14-34, 14-35
operations, numeric, 14-34
Oracle datatypes RAW and LONG RAW, 14-28
restrictions, 14-26
size and value limitations, 14-26
datatypes
DATE, 14-29
GRAPHIC, 14-28
LONG, 14-28
LONG RAW, 14-28
Oracle and IBM DATE, 14-29
Oracle DATE, 14-29
RAW, 14-28, C-5
TIME, 14-29
TIMESTAMP, 14-29
VARCHAR, 14-28
VARGRAPHIC, 14-28
date
date columns, TO_DATE function, 14-34
DELETE
statement, 14-32
HS_NLS_DATE_FORMAT parameter, 14-32, 14-33
INSERT
statement, 14-32
operations, 14-29
SELECT statement, 14-32
TO_DATE function, 14-32
UPDATE
statement, 14-32
date arithmetic
known restrictions, 2-8
DATE datatype, 14-29
DB_DOMAIN parameter
known restrictions, 2-7
DB2
02pcg.sql granting authority, 11-12
alias objects
known restrictions, 2-6
aliases, C-5
CICS, 14-7
configuring DB2/OS390, 5-3
data access, 1-7
Distributed Data Facility (DDF), 5-4
DRDA_DESCRIBE_TABLE compatibility, C-5
IBM DB2 Version 5.1 ASCII Tables, 2-3
IMS, 14-7
native SQL, 1-7
native stored procedures, 1-7
procedural feature considerations, 14-7
SPUFI utility, 5-4
SQL statements, 14-36
statements
CREATE TABLE, 1-7
stored procedures, 14-7
DB2/400
catalog view, 14-39
configuring, 5-5, 5-7
data dictionary views supported by gateway, A-2
DRDA_DEFAULT_CCSID, C-5
DRDA_DISABLE_CALL, C-6
DRDA_ISOLATION_LEVEL, C-7
DRDA_OPTIMIZE_QUERY, C-8
DRDA_PACKAGE_COLLID, C-9
user ID mapping, 15-7
DB2IND sample DB2 stored procedure, G-2
DB2/OS390
catalog view, 14-39
configuring, 5-3
data dictionary views supported by gateway, A-2
DRDA_DISABLE_CALL, C-6
DRDA_ISOLATION_LEVEL, C-7
DRDA_OPTIMIZE_QUERY, C-8
user ID mapping, 15-5
V6 and V7 stored procedures supported, 2-2
DB2/UDB
binding packages, 11-9
binding the gateway package, 11-10
catalog view, 14-39
configuring, 5-7
data dictionary views not supported, A-2
DRDA_ISOLATION_LEVEL, C-7
DRDA_OPTIMIZE_QUERY, C-8
incompatibilities with gateway, 2-5
known restrictions, 2-8
supported, 2-3
user ID mapping, 15-7
DB2/VM
catalog view, 14-39
configuring, 5-9
data dictionary views not supported, A-2
database and SQL functions, 14-20
DRDA_ISOLATION_LEVEL, C-7
DRDA_OPTIMIZE_QUERY, C-8
DRDA_PACKAGE_OWNER, C-11
instance, DRDA location name, 5-10
server machine, 15-6
user ID mapping, 15-6
DBCS (double-byte character set)
known restrictions, 2-7
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 14-36
DD basic tables, known restrictions, 2-6
DDF
DB2 (Distributed Data Facility), 5-4
subsystem, 5-3
DDL
statement, 14-36
debug
gateway, 17-8
library, 17-8
debugging
error codes, 17-3
SQL tracing, 17-8
with Startup Shell Script, 11-4
your application, 13-11
DECODE SQL function, 14-25, F-1
de-installing the gateway, 4-8
DELETE
known restrictions, 2-9
operation, 14-2
read-only gateway, 13-9
SQL clause, 14-34
statement, 14-36
DESCRIBE
character string operations, 14-28
command, known restrictions, 2-6
diagnostic parameter, C-16
dictionary
mapping, 1-6
see also data dictionary
tables, 14-38
DICTIONARY view, A-14
disk space requirements, 3-3
distributed
operations, DB2, 5-4
queries
example of, 13-7
two-phase commit, 13-8
transaction, C-12
distributed applications
support for, 1-18
distributed data facility (DDF), 5-4
distributed database, 12-3
distributed DRDA transactions, 13-8
distributed processing, 12-3
distributed query optimizer (DQO), 13-6
DRDA-specific parameters, C-8
dmesg, 7-7
documentation
recommended, 3-5
double-byte character set (DBCS)
known restrictions, 2-7
DQO
also see distributed query optimizer, 13-6
DRDA-specific parameters, C-8
drc error code, 17-3
DRDA
catalog, 14-39
database requirements, 3-3
defining number of cursors, 14-39
gateway package considerations, 11-10
location name
for DB2/UDB instance, 5-8
for DB2/VM instance, 5-10
mode
IBMRDB, 7-13, 9-14
session security options, 15-5
DRDA Application Server Function, 1-16
DRDA server
accessing, 11-14
and dependent LUs, 7-3, 9-3
and independent LUs, 7-3, 9-3
and Side Information Profiles, 7-2, 9-2
architecture, 1-10
capabilities, 14-24
character sets
known restrictions, 2-7
client applications initiate conversations using dependent LUs, 7-3, 9-3
configuring
DB2/400, 5-5
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
considerations for binding packages, 16-6
copying data
from Oracle server, 13-10
to Oracle server, 13-10
database link behavior, 14-8
default TP name, 7-15, 9-16
functions, 14-24
languages and character sets in configuration, D-9
Logical Unit (LU), 6-6, 7-17, 8-7, 9-18
partner LU, 7-11, 9-12
stored procedures, 14-5
VTAM definitions and local LU names, 7-10, 9-11
DRDA_CAPABILITY parameter, 14-24
DRDA_CMSRC_CM_IMMEDIATE parameter, C-4
DRDA_CODEPAGE_MAP parameter, D-9
DRDA_COMM_BUFLEN parameter, C-3
DRDA_CONNECT_PARM (SNA format) parameter, C-4
DRDA_CONNECT_PARM (TCP/IP format) parameter, C-4
DRDA_CONNECT_PARM parameter, 17-4
determine SNA V9 value for worksheet, 6-6
DRDA_DEFAULT_CCSID parameter, C-5
DRDA_DESCRIBE_TABLE parameter, C-5
known restrictions, 2-6
DRDA_DESCRIBE_TABLE=FALSE initialization parameter
known restrictions, 2-6
DRDA_DISABLE_CALL parameter, 11-10, C-6
DRDA_FLUSH_CACHE parameter, C-6
DRDA_ISOLATION_LEVEL parameter, C-7
DRDA_LOCAL_NODE_NAME parameter, C-7
DRDA_OPTIMIZE_QUERY parameter, 13-6, C-8
DRDA_PACKAGE_COLLID parameter, 17-4, C-9
DRDA_PACKAGE_CONSTOKEN parameter, C-10
DRDA_PACKAGE_NAME parameter, 11-10, 17-4, C-10
DRDA_PACKAGE_OWNER parameter, C-11
DRDA_PACKAGE_SECTIONS parameter, 14-39, C-11
DRDA_READ_ONLY parameter, 13-9, C-12
DRDA_RECOVER_USERID, 5-8
DB2/400, 5-5
DB2/OS390, 5-4
DB2/VM, 5-9
DRDA_RECOVERY_PASSWORD parameter, 5-8, C-12
DB2/400, 5-5
DB2/OS390, 5-4
DRDA_RECOVERY_USERID parameter, 5-8, C-12
DB2/400, 5-5
DB2/OS390, 5-4
DB2/VM, 5-9
DRDA_REMOTE_DB_NAME parameter, C-13
DRDA_SECURITY_TYPE parameter, C-13
DROP DATABASE LINK statement, 13-3
dropold.sql script, 11-11
DSPRDBDIRE command, 5-6
DUMP SQL function, 14-25, F-1
dynamic dictionary mapping, 1-6

E

EBCDIC
character set support, D-7
code page, D-5
DRDA server CCSID, D-12
sort order, 14-25
tables, known restrictions, 2-3
translated to ASCII, 14-27
EMP
system-wide synonym, 13-5
table, 13-10
empproc
stored procedure, 14-5
encryption types for Advanced Security, 12-7
enhancements in this release, 2-2
environment
heterogeneous, 13-9
environmental variable
NLS_LANG, D-3
ORA_NLS33, D-3
ORACLE_HOME, 4-5
environmental variables
$DISPLAY, 7-4, 9-4
errd, 13-4
DRDA_OVERRIDE_FROM_CODEPAGE usage note, C-8
mapped error example, 17-5
errmc, 13-4
CPI-C routine, 17-4
DRDA_OVERRIDE_FROM_CODEPAGE usage note, C-8
errmc field lists any error tokens, 17-3
error tokens, 17-4
mapped error example, 17-5
errp
errp field indicates program that detected error, 17-3
error
12660 (test error for Advanced Security), 12-7
basic description, 17-2
change, ORA-09100 to ORA-28500, 17-3
change, ORA-09101 to ORA-28501, 17-3
codes
drc, 17-3
grc, 17-3
communication, 17-4
condition, 17-2
conversion, C-5
date, D-7
detected
by Oracle integrating server, 17-2
by server database, 17-4
by the gateway, 17-3
in DRDA software, 17-3
in the DRDA software, 17-3
drc= field
-300xx, 17-7
-7xx, 17-6
HGO-00706, 17-3
host database, 17-7
interpreting error messages, 17-2
mapped sqlstate, 17-5
messages, 6-8, 7-19, 8-9, 9-20, 14-28
messages & codes, 17-1
number, 17-2
obsolete parameters, 16-5
ORA-00001, index constraint violated, 17-5
ORA-00942
mapped error example, 17-5
object does not exist, 17-5
object name too long, 17-5
ORA-01017, logon denied, 17-5
ORA-01031, insufficient privileges, 17-5
ORA-01460, invalid CCSID, 17-5
ORA-01476, divide by zero, 17-5
ORA-02019, 17-2
ORA-2025, when using INSERT command, 13-10
ORA-28500 (was ORA-09100), 17-3, 17-4
ORA-28501
communication error, 17-4
was ORA-09101, 17-4
ORA-28527
DRDA_OVERRIDE_FROM_CODEPAGE usage note, C-8
ORA-9100 to ORA-9199, 17-2
Oracle mapped error codes, 17-5
specific gateway error codes, 17-6
tokens, 17-3, 17-4
translation, 14-28
while binding the gateway package, 11-8
with Native Semantics, 14-24
error array (errd), See errd
errp, 13-4
DRDA_OVERRIDE_FROM_CODEPAGE usage note, C-8
mapped error example, 17-5
EXCEPT set operator, 14-26
execute authority, 15-6
EXECUTE command, 1-7
EXECUTE privilege
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
exits
gateway local date, 14-33
EXP SQL function, 14-25, F-1
EXPLAIN PLAN command, 17-8
EXPLAIN_PLAN table, 1-15
export encryption algorithms, 12-6

F

FDS_CLASS parameter, C-14
FDS_CLASS_VERSION parameter, C-14
FDS_INSTANCE parameter, C-15
features
Oracle Snapshots, 13-9
features of the gateway
application development and end-user tools, 1-18
application portability, 1-16
columns supported in a result set, 1-15
distributed applications supported, 1-18
EXPLAIN_PLAN improvement, 1-15
fetch reblocking, 1-14
heterogeneous database integration, 1-15
heterogeneous services architecture, 1-14
large base of data access, 1-16
main topic, 1-14
minimum impact on existing systems, 1-16
Native Semantics, 1-15
Oracle9i passthrough supported, 1-14
performance enhancements, 1-14
remote data access, 1-17
retrieving result sets through passthrough, 1-15
support for TCP/IP, 1-15
fetch array size, with HS_FDS_FETCH_ROWS, C-15
fetch reblocking, 1-14, 14-3
fetched date, C-16
fields
errmc, lists any error tokens, 17-3
errp, indicates program that detected error, 17-3
file member name, 13-5
file members
accessing AS/400 files, 13-5
files
initsid.ora
communication errors, 17-4
gateway error -700, 17-6
listener.ora, 11-5, 12-5
sample, B-1
listener.ora, B-4
tnsnames.ora, B-3
sna_domn.cfg, 7-3, 9-3
sna_node.cfg, 7-3, 9-3
tnsnames.ora, 11-13, 11-14
modifying, 12-5
VSAM, 14-7
FLOOR SQL function, 14-25, F-1
FOR BIT DATA
DRDA_DEFAULT_CCSID, C-5
option, 14-28
free session, DRDA_CMSRC_CM_IMMEDIATE, C-4
functions
ABS, F-1
ACOS, F-1
ADD_MONTHS, F-1
ASCII, F-1
ASIN, F-1
ATAN, F-1
ATAN2, F-1
CEIL, F-1
CHAR_TO_ROWID, F-1
CHR, F-1
CONVERT, F-1
COS, 14-9, F-1
COSH, F-1
COUNT, 14-35
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 14-36
DECODE, F-1
DRDA server, 14-24
DUMP, F-1
EXP, F-1
FLOOR, F-1
GREATEST, F-1
HEXTORAW, F-1
INITCAP, F-2
INSTR, F-2
INSTRB, F-2
LAST_DAY, F-2
LEAST, F-2
LENGTH, F-2
LENGTHB, F-2
LN, F-2
LOG, F-2
LOWER, F-2
LPAD, F-2
LTRIM, F-2
MOD, F-1
MONTHS_BETWEEN, F-1
NEW_TIME, F-1
NEXT_DAY, F-1
NLS_INITCAP, F-1
NLS_LOWER, F-1
NLS_UPPER, F-1
NLSSORT, F-1
POWER, F-1
RAWTOHEX, F-1
REPLACE, F-1
ROUND, F-1
ROWIDTOCHAR, F-1
RPAD, F-1
RTRIM, F-1
SIGN, F-1
SIN, F-1
SOUNDEX, F-1
SQL
SUBSTR, 14-24
TANH, F-2
SQRT, F-2
STDDEV, F-2
SUBSTR, F-2
known restrictions, 2-6
SUBSTRB, F-2
SYSDATE, F-2
TAN, F-2
TO_CHAR, F-2
TO_DATE, 14-30, 14-32, 14-33, F-2
TO_DATE, main topic, 14-34
TO_LABEL, F-2
TO_MULTI_BYTE, F-2
TO_NUMBER, F-2
TO_SINGLE_BYTE, F-2
TRANSLATE, F-2
TRUNC, F-2
UID, F-2
UPPER, F-2
USER, F-2
USERENV, F-2
VARIANCE, F-2
VSIZE, F-2

G

g4ddtab.sql script, 11-11
g4ddview.sql script, 11-11
g4drdrv
former startup program, 11-5
gateway
accessing
from other Oracle servers, 11-13
main topic, 13-4
advantages
main topic, 1-3
migration and coexistence, 1-9
multisite transactions, 1-8
security, 1-9
server technology and tools, 1-8
site autonomy, 1-9
two-phase commit, 1-8
and Oracle tools, 1-13
and stored procedures (Oracle and non-Oracle), 1-7
application tools, 1-18
architecture, 1-10
authenticating logons, 15-2
benefits of integration with 9i server, 1-5
binding DRDA packages, 11-8
capabilities, C-14
components, 1-11
configuration and the Startup Shell Script, 11-4
definition of terms, 1-9
de-installing, 4-8
DRDA package considerations, 11-10
error codes, 17-6
errors detected, 17-3
features, 1-14
main topic, 1-14
how to access, 13-4
installation
log file, 4-8
steps, 4-4
steps via Oracle Universal Installer, 4-7
interface, 1-12
local date exit, 14-33
logging, C-16
migration problems, 16-3
name, setting up, with Sunlink, 6-3
parameter, 5-10
performance, 14-24
performance enhancements, 1-14
performing distributed queries, 13-6
read-only option, 13-9
service name entries in the tnsnames.ora, 16-6
settings for security options, 6-7, 7-17, 8-8, 9-19
SQL differences, 1-13
startup time, 11-4
supported languages, D-9
tracing, C-16
tracing SQL statements, 13-11
using, 13-1
with other Oracle products
SQL*Plus, 1-8
Gateway Initialization File
backup and recovery of gateway configuration, 11-12
configuring for binding the DRDA gateway package, 11-8
defining userids and passwords, 15-8
encrypting passwords, 15-9
if errors are reported, 11-8
modifying, C-2
parameters
changes in release 9.0.1, 2-3
DRDA_READ_ONLY, 13-9
LOG_DESTINATION, 17-9
LOG_DESTINATION parameter, tracing, 17-9
new since V4 gateway, 16-4
ORACLE_DRDA_TCTL, 17-9
stored in initsid.ora, C-2
TRACE_LEVEL, 17-9
parameters, list, C-3
sample, B-2
see also parameters
Gateway System Identifier (SID), 11-4
GCS virtual machine, 15-6
GLOBAL_NAMES
known restrictions, 2-7
GRANT, 15-6
GRANT statement, 11-13
granting authority to a package for DB2, 11-12
GRAPHIC datatype, 14-28
graphic string operations
unsupported, 14-28
grc error code, 17-3
GREATEST SQL function, 14-25, F-1
GROUP BY clause, 14-26
GROUPBY SQL function, 14-25
GTW$_BIND_PKG
internal stored procedure, 11-10
stored procedure, 11-8

H

hardware requirements, 3-2
HAVING clause, 14-26
HAVING SQL function, 14-25
heterogeneous database integration, 1-15
Heterogeneous Services (HS), see HS, 1-2
HEXTORAW SQL function, 14-25, F-1
HGO-00706 error, 17-3
host
DRDA server, SNA and TCP/IP protocols, 1-10
networking needs, 3-4
performing character string operations on, 14-27
relationship to gateway and Oracle Server, 1-10
security validation required to begin database link, 6-6, 7-17, 8-7, 9-18
SNAP-IX definitions, 7-4
host database error, 17-7
host Logical Unit (LU), 6-6, 7-17, 8-7, 9-18
host variable, 14-26, 14-28
HP9000 host, 9-4, 9-11
invoking xsnapadmin, 9-4
HS (Heterogeneous Services)
architecture features, 1-14
Oracle Net considerations, 16-6
HS= (TNSNAMES parameter for Oracle Net), 12-5
gateway migration problems, 16-3
HS_DB_DOMAIN parameter
known restrictions, 2-7
HS_FDS_FETCH_ROWS parameter, C-15
HS_NLS_DATE_FORMAT, D-7
parameter, 14-33
HS_NLS_DATE_LANGUAGE, D-7
HS_RPC_FETCH_REBLOCKING parameter, 1-14, 14-3
HS_RPC_FETCH_SIZE parameter, 1-14, 14-3

I

IBM Communications Server for AIX
and SNA security option, 6-8, 7-18, 8-9, 9-20
tailoring Startup Shell Script for Version 9.0, 11-6
Version 5 required patches, 3-4
IBMRDB, 7-15, 9-16
DRDA mode, 7-13, 9-14
implementation, 1-11
implicit data conversion, 14-24
implicit protocol conversion, 1-6
IMS transaction, 14-7
inbound connections
processing, 15-4
init parameter, in Startup Shell Script, 11-5
INITCAP SQL function, 14-25, F-2
initdrdahoa1.ora
sample, B-2
see also Gateway Initialization File parameters
initdrdahoa1.sh
Also See Startup Shell Script, 11-4
sample, B-3
initialization parameters
new since V4 gateway, 16-4
see also Gateway Initialization Files, parameters
where stored, 11-4
initsid.gtwboot, 16-2
parameters formerly stored in the gateway instance directories, 11-4
initsid.ora
transferring initialization file parameters, 16-2
initsid.ora file
communication errors, 17-4
gateway error -700, 17-6
migrating, 16-2
NLS parameters, D-6
parameters formerly stored in the gateway instance directories, 11-4
input bind variables, 14-30
INSERT
known restrictions, 2-6
operation, 14-2
Oracle SQL command, known restrictions, 2-6
read-only gateway, 13-9
SQL clause, 14-34
statement, 14-32, 14-36
INSERT command
known restrictions, 2-6
supported by COPY, 13-10
INSERT command, not supported, 13-10
installation
checklists, 4-3, 5-2, 6-2, 8-2, 11-2, 12-2
overview, 4-4
installing the gateway
from CD, 4-4
INSTR SQL function, 14-25, F-2
INSTRB SQL function, 14-25, F-2
internal tracing, C-17
Internet support, 1-5
INTERSECT
SQL set operators and clauses, 14-26
IPC
adapter, B-4
ISO standard, 1-6
isolation level, C-7

J

JOIN
capability, 1-5
JOIN SQL statement, 14-2

K

keywords
LISTENER, B-4
known problems, 2-5
compatibility with DB2/UDB, 2-5
known restrictions, 2-6
accessing DB2 alias objects, 2-6
AVS mapping user IDs, 2-6
bind variables become SQL parameter markers, 2-10
binding the DRDA gateway package on DB2/UDB, 2-8
character set limitation, 2-7
CONNECT BY not supported, 2-10
datatype limitations, 2-7
date arithmetic, 2-8
DD basic tables and views, 2-6
dictionary views not provided for DB2/VM or DB2/UDB, 2-9
DRDA server character sets, 2-7
GLOBAL_NAMES parameter, 2-7
INSERT (Oracle SQL command), 2-6
LONG datatype in SQL*Plus, 2-8
null values and stored procedures, 2-7
Oracle ROWID column, 2-9
row length limitation, 2-8
SAVEPOINT, 2-7
single gateway instances per DRDA network interface, 2-9
SQL*Plus DESCRIBE command, 2-6
string concatenation, 2-7
SUBSTR function post-processed, 2-6
Korn shell
setting ORACLE_HOME variable, 4-5

L

LANGUAGE parameter, D-6
see also Gateway Initialization File
languages, 1-8
SQL*Plus, 1-8
lanscan command, 7-7, 9-7
LAST_DAY function, F-2
LEAST SQL function, 14-25, F-2
LENGTH SQL function, 14-25, F-2
LENGTHB SQL function, 14-25, F-2
link station
creating, 7-7, 9-8
parameters, 7-9, 9-10
testing SNA connection, 7-19, 9-21
link, also see Database Link, 14-7
linkage conventions
SIMPLE WITH NULLS, 14-7
linkname, 11-13
listener, B-4
LISTENER keyword, B-4
listener.ora file, 11-5, 12-5
sample, B-4
literal
character literals, 14-29
date, 14-29
specific datatype, 14-26
TO_DATE, format support, 14-34
LN SQL function, 14-25, F-2
log file, gateway installation, 4-8
LOG SQL function, 14-25, F-2
LOG_DESTINATION parameter, 17-9, C-16, C-17
logging, C-16
Logical Unit (LU), 6-6, 7-17, 8-7, 9-18
Login as DBA, 4-4
LONG datatype, 14-28
LONG RAW datatype, 14-28
LOWER SQL function, 14-25, F-2
LPAD SQL function, 14-25, F-2
LTRIM SQL function, 14-25, F-2
LU
dependent, 7-3, 9-3
additional SNAPlus2 configuration needed, 7-3, 9-3
Side Information Profiles, 7-3, 9-3
independent vs. dependent, 7-3, 9-3
local LU alias, 7-10
CPI-C destination, 7-15, 9-16
Ethernet parameters, 9-11
local names, 9-11
creating, 7-10, 9-11
names, 7-15, 9-16
partner
creating, 7-11, 9-12
SNAP-IX profiles, 7-2
SNAPlus2 profiles, 9-2
traffic type, in configuring SNAplus2, 7-8, 9-9
LU name, 15-5
LU6.2
local LU profile, 8-4
profile types, 8-3
side information profile, 8-5
SNA APPC, 6-1, 7-1, 8-1, 9-1

M

MAC address
in SNA configuration, 7-9
in SNAplus2 configuration, 9-10
mapped sqlstate errors, 17-5
mapping user IDs
AVS, 15-6
known restrictions, 2-6
migrating the gateway instance, 16-6
migration problems, 16-3
MINUS
set operator, 14-26
SQL set operators and clauses, 14-26
MOD SQL function, 14-25, F-1
mode
name, 7-15, 9-16
profiles, creating, 7-12, 9-13
Mode Profile
SNA Server profile, 8-4
Mode_name
description, 6-5
MONTHS_BETWEEN function, F-1
MVS VTAM
configuring DB2/OS390, 5-3

N

National Language Support
initsid.ora parameters, D-6
overriding codepage, C-8
overview, D-1
Native Semantics, 14-24
gateway architecture, 1-15
parameters, 14-26
with SUBSTR function, known restrictions, 2-6
network
attachment, 3-2
Oracle Net configuration, 12-4
requirements, 3-2
transparency, 1-4
NEW_TIME function, F-1
NEXT_DAY function, F-1
NLS
Also See National Language Support, D-1
DRDA server character sets, D-9
NLS parameters
configuration on client and Oracle servers, D-4
NLS_INITCAP SQL function, F-1
NLS_LANG
environmental variable, D-3
parameter
default setting, D-8
syntax, D-8
server-side parameter, D-3
NLS_LOWER SQL function, F-1
NLS_UPPER function, F-1
NLS_UPPER SQL function, F-1
NLSSORT SQL function, 14-25, F-1
non-character binary data, 14-27
null
rows, 14-35
values, 14-35
number of cursors, C-11
numbers
concatenation restrictions, 2-7
numeric datatype, 14-34, 14-35

O

o2pc.sql, 11-12, 13-8
obsolete parameters
DRDA_OVERRIDE_FROM_CODEPAGE, C-8
DRDA_OVERRIDE_TO_CODEPAGE, C-9
DRDA_RDBMS_TYPE, C-11
obsolete parameters since V4 gateway, 16-5
open cursors, at the IBM database, 14-39
OPEN_LINKS parameter, 13-3
operating system requirements, 3-3
operations
DELETE, 14-2
INSERT, 14-2
SELECT, 14-2
UPDATE, 14-2
operators
UNION, 14-26
UNION ALL, 14-26
option
binding packages, 11-9
data dictionary views, 14-38
date format string, 14-32
DRDA session security, 15-5
FOR BIT DATA, 14-28
Oracle server, 1-10
read-only
gateway configuration, 1-8
replicating, 13-9
security conduct, 15-4
service port number, DRDA_CONNECT_PARM, C-4
SNA security, 6-7, 7-17, 8-8, 9-19
SQL functions, 14-25
SQL*Plus COPY command, 13-10
ORA_MAX_DATE parameter, C-16
ORA_NLS33 parameter
description, D-3
syntax, D-8
ORA-00001 error, index constraint violated, 17-5
ORA-00942 error
mapped error example, 17-5
object does not exist, 17-5
object name too long, 17-5
ORA-01017 error, logon denied, 17-5
ORA-01031 error, insufficient privileges, 17-5
ORA-01460 error, invalid CCSID, 17-5
ORA-01476 error, divide by zero, 17-5
ORA-02019 error, 17-2
ORA1 Oracle instance, 14-3
ORA2 Oracle instance, 14-3
ORA-2025
error when using INSERT command, 13-10
ORA-28500 error
was ORA-09100, 17-3
ORA-28501 error
communication error, 17-4
ORA-28527 error
DRDA_OVERRIDE_FROM_CODEPAGE usage note, C-8
ORA-9100 to ORA-9199 errors, 17-2
Oracle
directory tree, 4-5
error number or return code, 17-2
mapped error codes, 17-5
products compatibility, 1-13
RAW datatype, C-5
snapshots, 13-9
stored procedure, defined, 14-3
Oracle integrating server
accessing gateway from other Oracle servers, 11-13
accessing other DRDA servers, 11-14
accessing the gateway, 13-4
architecture, 1-10
configuration, 11-13
definition, 1-9
errors detected, 17-2
requirements, 3-4
using, in application development, 14-2
Oracle Net, 1-8, 16-6
and application development, 1-18
and distributed processing, 12-3
and remote data access, 1-17
and server coexistence, 1-10
API, 12-3
compatibility with SQL*Net, 12-3
configuring, 12-4
distributed
database, 12-3
processing, 12-3
editing to set up security test, 12-7
Heterogeneous Services (HS) facility, 12-3
introduction, 12-3
operating system authentication, 15-3
overview, 12-3
product version, 2-2
purpose, 1-11
requirements, 3-4
sample files, B-1
sample listener.ora file, B-4
support for CHECKSUM and encryption, 12-6
terminology, 12-4
client, 12-4
driver, 12-4
host, 12-4
network, 12-4
protocol, 12-4
TNS connect descriptor specification, 13-2
Oracle ROWID column
known restrictions, 2-9
Oracle server dependencies, 2-3
Oracle Universal Installer
de-installing the gateway, 4-8
starting, 4-6
steps to install the gateway, 4-7
upgrading for installation, 4-7
ORACLE_DRDA_TCTL parameter, 17-9, C-16
ORACLE_DRDA_TRACE parameter, C-17
ORACLE_HOME
environmental variable, 4-5
for the gateway, 4-5
ORACLE2PC table, 11-9, 11-10, 11-12, 13-8, C-11
DB2/400, 5-5
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
Oracle9i Server
relationship to host, 1-10
services, 1-4
database triggers, 1-5
distributed capabilities, 1-5
distributed query optimization, 1-5
SQL, 1-4
stored procedures, 1-5
two-phase commit protection, 1-5
triggers, 13-9
Oracle9i server
copying data
from DRDA server, 13-10
to DRDA server, 13-10
Oracle9i database server, description, 1-2
ORADRDA.ORACLE2PC table, 13-8
ORAIND sample DB2 stored procedure, G-4
oraproc1, 14-4
stored procedure, 14-3
oraproc2
stored procedure, 14-3
ORARECOV user ID, 5-8, C-12
DB2/400, 5-5
DB2/OS390, 5-4
DB2/VM, 5-9
ORDER BY clause, 14-26
ORDERBY SQL function, 14-25
OS/390 (MVS)
configuring DB2/OS390, 5-3
overriding codepage, C-8

P

package
collection id, C-9
consistency token, C-10
privileges - BIND, COPY, and EXECUTE, 5-3, 5-7, 5-9
packed decimal, 14-35
parameter
changed, 16-4
checking settings, 11-10
diagnostic, C-16
gateway, 5-10
init, in Startup Shell Script, 11-5
link station, 7-9, 9-10
Native Semantics, 14-26
new since V4 gateway, 16-4
obsolete since V4 gateway, 16-5
renamed since V4 gateway, 16-5
setting up trace parameters, 17-8
Startup Shell Script, new since V4 gateway, 16-3
parameter file
tailoring to configure the host, 11-4
parameters
CHARACTER SET, D-4
DB_DOMAIN
known restrictions, 2-7
DRDA_CAPABILITY, 14-24
DRDA_CODEPAGE_MAP, C-3, C-14, D-9
DRDA_DESCRIBE_TABLE
known restrictions, 2-6
DRDA_DISABLE_CALL, 11-10
DRDA_PACKAGE_NAME, 11-10
DRDA_PACKAGE_SECTIONS, 14-39
DRDA_READ_ONLY, 13-9
DRDA_RECOVERY_PASSWORD, 5-8
DB2/400, 5-5
DB2/OS390, 5-4
DRDA_RECOVERY_USERID, 5-8
DB2/400, 5-5
DB2/OS390, 5-4
DB2/VM, 5-9
FDS_CLASS, C-14
FDS_CLASS_VERSION, C-14
FDS_INSTANCE, C-15
Gateway Initialization File
DRDA_CAPABILITY, C-3
DRDA_CMSRC_CM_IMMEDIATE, C-4
DRDA_CODEPAGE_MAP, C-3
DRDA_COMM_BUFLEN, C-3
DRDA_CONNECT_PARM, 17-4
DRDA_CONNECT_PARM (SNA format), C-4
DRDA_CONNECT_PARM (TCP/IP format), C-4
DRDA_DEFAULT_CCSID, C-5
DRDA_DESCRIBE_TABLE, C-5
DRDA_DISABLE_CALL, C-6
DRDA_FLUSH_CACHE, C-6
DRDA_ISOLATION_LEVEL, C-7
DRDA_LOCAL_NODE_NAME, C-7
DRDA_OPTIMIZE_QUERY, 13-6, C-8
DRDA_PACKAGE_COLLID, 17-4, C-9
DRDA_PACKAGE_CONSTOKEN, C-10
DRDA_PACKAGE_NAME, 17-4, C-10
DRDA_PACKAGE_OWNER, C-11
DRDA_PACKAGE_SECTIONS, C-11
DRDA_READ_ONLY, C-12
DRDA_RECOVERY_PASSWORD, C-12
DRDA_RECOVERY_USERID, C-12
DRDA_REMOTE_DB_NAME, C-13
DRDA_SECURITY_TYPE, C-13
HS_FDS_FETCH_ROWS, C-15
LOG_DESTINATION, C-16
ORA_MAX_DATE, C-16
ORACLE_DRDA_TCTL, C-16
ORACLE_DRDA_TRACE, C-17
TRACE_LEVEL, C-17
HS_DB_DOMAIN
known restrictions, 2-7
HS_NLS_DATE_FORMAT, 14-32, 14-33
HS_RPC_FETCH_REBLOCKING, 1-14, 14-3
HS_RPC_FETCH_SIZE, 1-14, 14-3
LOG_DESTINATION, C-17
LOG_DESTINATON, 17-9
NLS_LANG, D-8
OPEN_LINKS, 13-3
ORA_NLS33, D-8
PROGRAM, 11-5
USING, modifying tnsnames.ora file, 12-5
partner LU
creating, 7-11, 9-12
creating, also see LU, 7-11
see LU
partner LU alias, 8-5
partner LU profile, 6-5
Partner_LU_name
description, 6-5
passthrough, 1-7, 1-14, 14-36, 14-38
result sets, 14-36, 14-38
SQL feature, 14-36
patches
required for IBM Communications Server for AIX, 3-4
performance, 14-24
performance enhancements
with fetch reblocking, 14-3
PL/SQL
call, 14-6
DRDA stored procedures, 14-5
records, 14-7
routine, 1-7
standard Oracle, 1-7
stored procedure, 14-3
port, 7-7, 9-8
adding, for SNA, 7-6, 9-6
name, adding, for SNA, 7-6, 9-7
port number
Primary, 5-3
DB2/400, 5-5
DB2/UDB, 5-7
Recovery, 5-3
DB2/400, 5-5
DB2/UDB, 5-7
post-processed SQL functions
overview, 14-9
post-processing, 14-24, 17-8
POWER SQL function, 14-25, F-1
PREPARE TRANSACTION statement, 13-8
Primary port number, 5-3
DB2/400, 5-5
DB2/UDB, 5-7
privileges
BIND
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
BINDADD
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
BINDAGENT
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
COPY
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
CREATE IN
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
CREATE PUBLIC DATABASE LINK, 11-8, 11-13
data dictionary emulation, 14-38
EXECUTE
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
procedure
stored, 13-9
using DRDA server, 14-5
procedures
DB2 DB2IND, sample, G-2
DB2 ORAIND, sample for, G-4
processing time, with GROUPBY, HAVING, WHERE, 14-25
processor requirements, 3-2
product installation directory, 4-5
profile
creating
CPI-C and Mode profiles, 7-12, 9-13
name
see Side Information Profile
side information, 7-14, 9-15
type
see Side Information Profile
profile set, 11-14
profile types, 8-3
Mode Profile, 8-4
PROGRAM parameter, 11-5
protocol
APPC/LU6.2, 6-1, 7-1, 8-1, 9-1
commit confirm, 1-8
communications protocols, 12-3
converter, 1-6
definition, 12-4
implicit protocol conversion, 1-6
network, 13-5
Oracle Net Protocol Adapters, 12-3
PROTOCOL=IPC, sample, B-3
protocol-independent encryption, 1-6
two-phase commit, 13-8
protocols
APPC/LU6.2, 1-4
IPC, 12-5
SNA, 1-10
SPX/IPX, 1-4
TCP/IP, 1-4, 1-6, 1-10, 1-15
public database link, 11-13

Q

queries, distributed, 13-6

R

RAW datatype, 14-28, C-5
RAWTOHEX SQL function, 14-25, F-1
read-only gateway option, 13-9, C-12
read-only support, 2-4
rebind, C-6, C-7, C-9, C-11
recommended documentation, 3-5
Recovery port number, 5-3
DB2/400, 5-5
DB2/UDB, 5-7
recovery user ID and password, 5-4, 5-8
DB2/400, 5-5
DB2/VM, 5-9
remote
computer, 12-3
connections, 13-3
data, 1-5
data access, 1-17
database, 5-8, 11-10, 13-2, 13-10, 17-2, 17-7, C-11
DB2/400, 5-5
DB2/OS390, 5-4
DB2/VM, 5-9
database, defining a path, 13-2
database, privileges of user/ ID, E-5
DB2 system, 2-6
DRDA database, C-7
DRDA server object information, 2-6
instance, and Oracle stored procedures, 14-3
LU, 8-5
objects, 15-3
Oracle instance, 14-4, 14-5
Oracle servers, 12-3
procedure, 1-7
table, 1-6
TPN, 8-6
transaction program, 3-2, 8-3
userid and password, 13-2
Remote Node definition
creating, 7-7, 9-8
renamed parameters, 16-5
REPLACE
command
supported by COPY, 13-10
REPLACE SQL function, 14-25, F-1
replication, 13-9
requirements
hardware, 3-2
CD-ROM drive, 3-2
software, 3-3
restrictions, 2-6
RESULT, 14-6
result sets, 1-15
columns in, 1-15
return code, 17-2
REVISE_SALARY
stored procedure, 14-6
ROUND SQL function, 14-25, F-1
ROWID
Oracle column
known restrictions, 2-9
ROWIDTOCHAR function, F-1
RPAD SQL function, 14-25, F-1
RTRIM SQL function, 14-25, F-1

S

sample
files, B-1
listener.ora file, B-4
SQL scripts, 11-11
tnsnames.ora file, B-3
samples
Side Information File, SunLink SNA Peer-to-Peer, 6-4, 6-6
SNA configuration file, 6-4
SAP
dialog box, 7-6, 9-7
number, 7-9, 9-10
SAVEPOINT
known restrictions, 2-7
scripts
dropold.sql, 11-11
g4ddtab, 11-11
g4ddview.sql, 11-11
SDLC Coaxial network attachment, 3-2
security
Advanced Security, 1-6
DRDA_SECURITY_TYPE, C-13
encryption, 12-6
for session use, 7-15, 9-16
overview, 15-2
site autonomy, 1-9
validation
for SNA, 6-6, 7-17, 8-7, 9-18
for TCP/IP, 15-4
SELECT and array size, 1-14
SELECT operation, 14-2
SELECT statement, 14-3, 14-9, 14-38
read-only gateway, 13-9
SELECT WHERE
SQL clause, 14-34
semantics, 14-24
server database error, 17-4
server profiles, 6-1, 7-1, 8-1, 9-1
service port number, DRDA_CONNECT_PARM, C-4
Service TP
"07F6C4C2", 7-15, 9-16
session
authorization, 7-15, 9-16
session, connection, 14-7
set operators
compatibility, 14-26
EXCEPT, 14-26
INTERSECT, 14-26
MINUS, 14-26
SID
also see Gateway System Identifier, 11-4
choosing for gateway, 11-4
configuring additional DRDA server instances, 11-14
definition, 11-4
naming suggestion, 11-5
Side Information File
information needed, 6-4
sample files, 6-4
Version 9 sample, 6-6
Side Information Profile, 7-14, 8-5, 9-15, 17-4
defining, to use dependent LUs, 7-3, 9-3
description and role, 7-2, 9-2
specifies Local LU Profile name, 8-4
side information profile, 8-5
SIGN SQL function, 14-25, F-1
SIMPLE linkage convention, 14-7, G-2
SIN SQL function, 14-25, F-1
single-threaded conversations for dependent LUs, 7-3, 9-3
SINH SQL function, 14-25, F-1
site autonomy, 1-9
SMIT (System Management Interface Tool)
AIX System Management Interface Tool, 8-3
SNA
APPC, 6-1, 8-1, 9-1
configuring DB2/400, 5-5
configuring DB2/OS390, 5-3
configuring DB2/UDB, 5-7
configuring DB2/VM, 5-9
configuring server profiles, 8-3
connectivity via APPC, 7-1
conversation security, 6-7, 7-17, 8-8, 9-19
CPI-C error, 17-4
definitions, 7-4, 9-4
creating, for SNAP-IX, 7-4
creating, for SNAplus2, 9-4
creating, for the gateway, 7-3, 9-3
maintenance, 7-3, 9-3
facilities, 1-16
functions, 1-12
LU, 8-4, 15-5
network, 7-4, 9-4
name, in creating partner LUs, 7-11, 9-12
profile, 11-14
profile definitions, 8-3
profiles, 7-2, 9-2
protocol, 1-10, 7-6, 9-7
remote access, 1-17
sample configuration file, 6-4
sample profile definitions, 8-3
security, C-13
option and IBM Communications Server for AIX, 6-8, 7-18, 8-9, 9-20
validation, 15-4
security validation, 6-6, 7-17, 8-7, 9-18
SECURITY=PROGRAM, 6-7, 7-17, 8-8, 9-19
SECURITY=SAME, 6-8, 7-18, 8-9, 9-20
send/receive buffer, C-3
session allocation mode, DRDA_CMSRC_CM_IMMEDIATE, C-4
TPN, 8-6
SNA LU6.2
configuring DB2/400, 5-5
configuring DB2/OS390, 5-3
SNA node, 7-2, 7-4, 7-7, 9-2, 9-4, 9-8
configuring, 7-5, 9-5
SNA security option, 6-7, 7-17, 8-8, 9-19
SNA Server
Link Profile, 8-5
Local LU Profile, 8-4
Partner LU Location Profile, 8-5
Partner LU Profile, 8-5
profiles
creating, 8-3
sample profile definitions, 8-3
Side Information Profile, 8-5
SNA server
network requirements, 3-2
sna_domn.cfg file, 7-3, 9-3
sna_node.cfg file, 7-3, 9-3
SNAP-IX
configuring, 7-1
configuring, using xsnaadmin program, 7-2
configuring, using xsnapadmin, 7-4
definitions
for the gateway, 7-4
stored in directory, 7-3
Side Information Profiles required, 7-2
testing the connection, 7-19
SNAPlus2
configuring, 9-1
configuring, using xsnapadmin, 9-4
SNAplus2
additional configuration needed for multiple dependent LUs, 7-3, 9-3
configuring, using xsnapadmin program, 9-2
definitions
for the gateway, 9-4
stored in directory, 9-3
Side Information Profiles required, 9-2
testing the connection, 9-21
version required, 3-4
snapshots
known restrictions, 2-9
Oracle Snapshot feature, 13-9
software requirements, 3-3
Solaris
system support for APPC, 6-1
sort order
with ORDERBY, 14-25
SOUNDEX function, F-1
SPUFI, a database native tool, 11-11
SPX/IPX protocol, 1-4
SQL
ANSI standard, 1-6
clause compatibility, 14-26
clauses
DELETE, 14-34
INSERT, 14-34
SELECT WHERE, 14-34
UPDATE, 14-34
commands
DESCRIBE, known restrictions, 2-6
constructs
Oracle processing, 14-8
differences in the gateway, 1-13
errors mapped to Oracle error codes, 17-5
functions
ABS, 14-25, F-1
ACOS, F-1
ADD_MONTHS, F-1
ASCII, 14-25, F-1
ASIN, F-1
ATAN, F-1
ATAN2, F-1
CEIL, 14-25, F-1
CHAR_TO_ROWID, F-1
CHR, 14-25, F-1
CONVERT, 14-25, F-1
COS, 14-25, F-1
COSH, 14-25, F-1
DECODE, 14-25, F-1
DUMP, 14-25, F-1
EXP, 14-25, F-1
FLOOR, 14-25, F-1
GREATEST, 14-25, F-1
GROUPBY, 14-25
HAVING, 14-25
HEXTORAW, 14-25, F-1
INITCAP, 14-25, F-2
INSTR, 14-25, F-2
INSTRB, 14-25, F-2
LAST_DAY, F-2
LEAST, 14-25, F-2
LENGTH, 14-25, F-2
LENGTHB, 14-25, F-2
LN, 14-25, F-2
LOG, 14-25, F-2
LOWER, 14-25, F-2
LPAD, 14-25, F-2
LTRIM, 14-25, F-2
MOD, 14-25, F-1
MONTHS_BETWEEN, F-1
NEW_TIME, F-1
NEXT_DAY, F-1
NLS_INITCAP, F-1
NLS_LOWER, F-1
NLS_UPPER, F-1
NLSSORT, 14-25, F-1
ORDERBY, 14-25
POWER, 14-25, F-1
RAWTOHEX, 14-25, F-1
REPLACE, 14-25, F-1
ROUND, 14-25, F-1
ROWIDTOCHAR, F-1
RPAD, 14-25, F-1
RTRIM, 14-25, F-1
SIGN, 14-25, F-1
SIN, 14-25, F-1
SINH, 14-25, F-1
SOUNDEX, F-1
SQRT, 14-25, F-2
STDDEV, 14-25, F-2
SUBSTR, 14-24, 14-25, F-2
SUBSTRB, 14-25, F-2
SYSDATE, F-2
TAN, 14-25, F-2
TANH, 14-25, F-2
TO_CHAR, F-2
TO_DATE, F-2
TO_LABEL, F-2
TO_MULTI_BYTE, F-2
TO_NUMBER, F-2
TO_SINGLE_BYTE, F-2
TRANSLATE, 14-25, F-2
TRUNC, 14-25, F-2
UID, F-2
UPPER, 14-25, F-2
USER, F-2
USERENV, F-2
VARIANCE, 14-25, F-2
VSIZE, F-2
WHERE, 14-25
functions and Native Semantics, 14-24
functions list, F-1
gateway architecture, 1-3
gateway transparency, 1-6
ISO standard, 1-6
native DB2, 1-7
passthrough, 14-36, 14-38
statements, 14-2, C-7
DB2, 14-36
issued through the gateway, 13-11
passing through gateway, 14-36
syntax, 14-35
tracing, not to be used in production environment, 13-11
SQL functions
column functions, 14-8
compatible, defined, 14-8
compensated, defined, 14-9
DB2/400, 14-17
DB2/OS390, 14-10
DB2/UDB, 14-13
DB2/VM, 14-20
translated, defined, 14-8
with Native Semantics, 14-25
SQL tracing
in Oracle database, 17-8
in the gateway, 17-8
LOG_DESTINATION, 17-9
ORACLE_DRDA_TCTL parameter, 17-9
TRACE_LEVEL parameter, 17-9
SQL*Net
gateway migration problems, 16-3
Heterogeneous Services (HS) facility, 12-3
replaced by Oracle Net, 12-3
SQL*Plus
connecting to gateway, 12-8
COPY command, 13-10
DESCRIBE command, known restrictions, 2-6
extending gateway uses, 1-13
known restrictions, 2-6
moving data, 1-8
sqlstate, mapped errors, 17-5
SQRT SQL function, 14-25, F-2
stability, of cursor, C-7
Startup Shell Script
and gateway configuration, 11-4
backup and recovery of gateway configuration, 11-12
binding the DRDA gateway package, 11-8
choosing, 11-4
creating, 11-5
customizing, B-3
listener.ora file, 12-4
NLS parameters, D-8
parameter, tailoring to configure the host, 11-4
parameters governing UNIX and IBM Communications Server for AIX environments, 11-6
parameters new since V4 gateway, 16-3
sample, B-3
tailoring file for IBM Communications Server for AIX, 11-6
troubleshooting environment, 11-4
startup time, gateway, 11-4
statements
CREATE DATABASE LINK, 13-2
DB2 CREATE TABLE, 1-7
DDL, 14-36
DELETE, 14-32, 14-36
DROP DATABASE LINK, 13-3
GRANT, 11-13
INSERT, 14-36
PREPARE TRANSACTION, 13-8
SELECT, 14-3, 14-9, 14-38
read-only gateway, 13-9
SQL
DB2, 14-36
JOIN, 14-2
SELECT, 14-38
UPDATE, 14-32, 14-36
STDDEV SQL function, 14-25, F-2
steps for
configuring communications interfaces, 7-2, 9-2
stored definitions
Side Information Profile needed for SNAP-IX, 7-2
Side Information Profile needed for SNAplus2, 9-2
stored procedure
creating on DB2, 14-6
DB2, 14-7
native DB2, 1-7
Oracle and non-Oracle, 1-7
Oracle database server
PL/SQL, 14-3
remote instance, 14-3
Oracle, description, 1-7
Oracle9i Server
local instance, 14-3
using, 14-3
restriction, 2-7
usage, C-6
using DRDA server, 14-5
stored procedures, 1-5
DB2, 13-9, 14-5
DB2IND, G-2
GTW$_BIND_PKG, 11-8
ORAIND, G-4
REVISE_SALARY, 14-6
using with the gateway, 14-3
string concatenation
known restrictions, 2-7
string index, with Native Semantics, 14-24
Structured Query Language, also see SQL, 1-3
SUBSTR SQL function, 14-24, 14-25, F-2
known restrictions, 2-6
with Native Semantics, known restrictions, 2-6
SUBSTRB SQL function, 14-25, F-2
Sun host
configuring the SunLink SNA Peer-to-Peer, 6-3
defining the gateway name, 6-3
SunLink SNA Peer-to-Peer product
configuring
side information record file, 6-4
sample configuration files shipped, 6-3
setting up a configuration file, 6-3
setting up a gateway name, 6-3
starting Version 9, 6-4
synonym, 1-12
feature, 13-5
for location transparency, 14-4
SYSDATE function, F-2
system privileges - BINDADD and BINDAGENT, 5-3, 5-7, 5-9

T

table
create a table in DB2, 14-37
insert a row into a DB2 table, 14-37
TABLE_PRIVILEGES view, A-15
tables
EXPLAIN_PLAN, 1-15
ORACLE2PC, 11-10, 11-12, 13-8
ORADRDA.ORACLE2PC, 13-8
TAN SQL function, 14-25, F-2
TANH SQL function, 14-25, F-2
TCP/IP
adapter, B-4
concurrent connections, 3-2
configuring
DB2/400, 5-5
DB2/OS390, 5-3
DB2/UDB, 5-7
DB2/VM, 5-9
configuring the host, 11-6
configuring under Solaris, 10-2
DRDA_CONNECT_PARM, C-4
facilities, 1-16
format, gateway initialization file parameter, C-4
functions, 1-12
modifying tnsnames.ora in Oracle Net, 12-5
network attachment, 3-2
number of database link connections, 14-8
protocol, 1-4, 1-6, 1-10
remote access, 1-17
security, 15-4
security validation, 15-4
support, 1-15
terminology defined, 1-9
tg4drda directory, also known as ORACLE_HOME, 4-5
TIME datatype, 14-29
time operations, 14-29
TIMESTAMP datatype, 14-29
TNSNAMES.ORA
changes to, during migration problems, 16-3
extra parameter needed (HS=), 2-3
tnsnames.ora
connect descriptor, 13-2
file, 11-13, 11-14, 12-5
modifying for Oracle Net, 16-6
sample file, B-3
TO_CHAR function, F-2
TO_DATE
function, 14-30, 14-32, 14-33, F-2
TO_DATE function
main topic, 14-34
TO_LABEL SQL function, F-2
TO_MULTI_BYTE function, F-2
TO_NUMBER function, F-2
TO_SINGLE_BYTE function, F-2
Token Ring, 3-2
token, package consistency, C-10
tools and the gateway, 1-13
TP name, 7-15, 9-16
TP_name
description, 6-5
TPN, 8-6
trace control, C-16
trace parameters
setting, 17-8
TRACE_LEVEL parameter, 17-9, C-17
tracing, C-16, C-17
code, C-17
SQL statements, 13-11
trade-off, Native Semantics, 14-24
transaction mode, read-only, C-12
transaction program name, remote, 8-6
transactions
CICS, 14-7
IMS, 14-7
transferring
initsid.ora gateway initialization file parameters, 16-2
TRANSLATE SQL function, 14-25, F-2
translation, C-8
transparency, 1-4
access method, 1-4
data storage, 1-4
location, 1-4
native semantics, 14-24
network, 1-4
triggers
for Oracle9i Server, 13-9
TRUNC function, F-2
TRUNC SQL function, 14-25
TSO
configuring DB2/OS390, 5-3
two-phase commit
ORACLE2PC table
DB2/400, 5-5
DB2/UDB, 5-7
DB2/VM, 5-9
ORACLE2PC table, DB2/OS390, 5-3
processing transactions, 13-8
protection, 1-5
unsupported statement, 13-8

U

UID function, F-2
UNION
capability, 1-5
operator, 14-26
SQL set operators and clauses, 14-26
UNION ALL
operator, 14-26
SQL set operators and clauses, 14-26
UNIX
Bourne shell
syntax, 11-4
UPDATE
known restrictions, 2-9
operation, 14-2
read-only gateway, 13-9
SQL clause, 14-34
statement, 14-36
UPPER SQL function, 14-25, F-2
USER function, F-2
user ID mapping
AVS, 15-6
DB2/400, 15-7
DB2/OS390, 15-5
DB2/VM, 15-6
user ID translation
DB2, 15-6
user privileges, 14-38
USER_CATALOG view, A-15
USER_COL_COMMENTS view, A-16
USER_CONS_COLUMNS view, A-17
USER_CONSTRAINTS view, A-16
USER_DB_LINKS data dictionary view, 13-3
USER_INDEXES view, A-17
USER_OBJECTS view, A-19
USER_SYNONYMS view, A-19
USER_TAB_COLUMNS view, A-22
USER_TAB_COMMENTS view, A-23
USER_TABLES view, A-20
USER_USERS view, A-23
USER_VIEWS view, A-24
USERENV function, F-2
USING clause, 13-2
USING parameter, modifying tnsnames.ora file, 12-5
Using the gateway, 13-1

V

VALUES clause
functions not allowed by DB2, 14-34
VARCHAR datatype, 14-28
VARGRAPHIC
datatype, 14-28
variable
bind, 14-36
input bind, 14-30
VARIANCE SQL function, 14-25, F-2
view
creating, 11-13
data dictionary
emulation on DRDA server, 14-38
views
catalog
DB2/400, 14-39
DB2/OS390, 14-39
DB2/UDB, 14-39
DB2/VM, 14-39
VM VTAM
configuring, 5-9
VSAM
file, 14-7
VSIZE function, F-2
VTAM
configuring DB2/OS390, 5-3
definitions
relationship to SNAplus2 definitions, 7-19, 9-21
same local LU name as on remote DRDA server, 7-10, 9-11
security validation, 6-6, 7-17, 8-7, 9-18

W

WHERE clause, 14-26
known restrictions, 2-9
WHERE CURRENT OF CURSOR clause
known restrictions, 2-9
WHERE SQL function, 14-25
workarounds, 2-5

X

xsnaadmin
creating SNA definitions, 7-4
invoking, 7-4
SNAP-IX definitions, 7-4
tool to configure SNAP-IX, 7-2
tool to create SNAP-IX definitions, 7-3
xsnapadmin, 9-4
creating SNA definitions, 9-4
invoking, 9-4
tool to configure SNAplus2, 9-2
tool to create SNAplus2 definitions, 9-3
X-Windows, 7-2, 9-2

Z

zoned decimal operations, 14-35
Go to previous page
Oracle
Copyright © 2001, 2002 Oracle Corporation.
All Rights Reserved.
Go To Table Of Contents
Contents