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

LONG datatype, 13.7.2

LONG RAW datatype, 13.7.1, 13.7.1

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