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.6.3, 9.6.3

$ORACLE_HOME, 7.6.1, 9.6.1

A

accessing

DRDA servers, 12.9

gateway, 12.8

main topic, 13.2

Advanced Program to Program Communication (APPC/LU6.2) protocol, 6, 7, 8, 9

Advanced Security

CHECKSUM command, 11.5

encryption, 11.5

international version types supported, 11.6

resetting configuration parameters on gateway, 11.7.2

setting test parameters for gateway, 11.6.1

setting test parameters for Oracle integrating server, 11.6.2

setting up for test, 11.6

testing gateway and Oracle integrating server, 11.7.1

export encryption algorithms, 11.5

function of the gateway, 1.3.3

purpose, 1.3.3

test error, 11.7.1

12660, 11.6

AGW ADD USERID command, 15.5.1.2

AGW DELETE USERID command, 15.5.1.2

AIX

AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME, C.4.16

System Management Interface Tool, 8.3

user ID for DB2/UDB, 5.4.2

alias

CPI-C destination, 7.6.3, 9.6.3

DB2, C.4.9

Ethernet parameters, 9.6.3

local LU alias, 7.6.3

partner LU, 8.3.2.4

alias objects, DB2

known restrictions, 2.5

ALL_CATALOG view, A.2.1

ALL_COL_COMMENTS view, A.2.2

ALL_CON_COLUMNS view, A.2.3

ALL_CONSTRAINTS view, A.2.4

ALL_DB_LINKS data dictionary view, 13.1.4

ALL_INDEXES view, A.2.5

ALL_OBJECTS view, A.2.7

ALL_SYNONYMS view, A.2.8

ALL_TAB_COMMENTS view, A.2.11

ALL_TABLES view, A.2.9

ALL_USERS view, A.2.12

ALL_VIEWS view, A.2.13

allocation mode, SNA session, DRDA_CMSRC_CM_IMMEDIATE, C.4.7

ALTER session statement, 13.1.2

ANSI-standard SQL, 1.3.5, 1.9.10

API (application program interface), 11.3

APPC

concurrent connections, 3.1.2

configuring IBM Communication Server, 8

configuring SNAP-IX interfaces, 7

configuring SUNLINK, 6

conversations, 8.2

creating SNAP-IX profiles, 7.4

creating SNAPlus2 profiles, 9.4

DB2/VM, 15.5.1.2

number of database link connections, 14.4

password length, 17.3

user ID length, 17.3

APPC VTAM Support (AVS)

also see AVS, 15.5.1.2

known restrictions, 2.5.1

APPC/LU6.2

parallel session limits, 8.3.2.1

protocol, 7, 9

side information profile, 8.3.2.6

APPEND command

supported by COPY, 13.8

application

authenticating logons, 15.2

portability, 1.9.13

server support, 1.3.3

application development on the gateway, 1.9.16

application program interface (API), 11.3

APPN

node, advanced peer-to-peer networking node, 8.3.2.5

support requires VTAM Version 4, 8.3.2.5

architecture of the gateway, 1.5

array size

fetch reblocking, 1.9.3

how determined, 14.1.1

AS/400

command, DSPRDBDIRE, 5.3.4

communications, configuring, 5.3.1

files and file members, accessing, 13.3

library name, DRDA_PACKAGE_COLLID, C.4.19

ASCII

code page, D.3

sort order, 14.6.2

tables, known restrictions, 1.9.21

translated from EBCDIC, 14.7.1

US7ASCII, D.3.2.1

US7ASCII as default, D.2

authority

CONNECT, 15.5.1.2

execute, 15.5.1.2

autonomy, site, 1.3.14

available products menu, 4.6.6

AVS

also see APPC VTAM Support, 2.5.1

configuring, 5.5.1

DB2/VM, 15.5.1.2

mapping user IDs, 2.5.1, 15.5.1.2

mapping user IDs (DB2/VM)

known restrictions, 2.5.1

mapping user IDs with DB2/VMT, 15.5.1.2

B

binary data, non-character, 14.7.1

Bind Package Stored Procedure

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

BIND privilege

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

bind variables

known restrictions, SQL limitations, 2.5.2

SQL passthrough, 14.8

BINDADD authority, 12.4.4

BINDADD privilege

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

BINDAGENT privilege

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

binding the DRDA package

backward compatibility, 16.4

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

on DB2/UDB, 12.4.4

on DRDA server, 12.4.3

pre-binding checklist, 12.5.1

Bourne shell

setting ORACLE_HOME variable, 4.6.3

bug

debugging, 13.10, 17.1.3, 17.4, 17.4.2

number 205538, known restrictions, SQL limitations, 2.5.2

number 3275652, 2.4

C

C shell

setting ORACLE_HOME variable, 4.6.3

call

a CICS or IMS transaction, 14.3.2

DB2 stored procedure, 14.3, 14.3.1

DRDA_DISABLE_CALL, 12.5.1.1, B.1

empproc stored procedure, 14.3

Oracle Call Interfaces, 17.1

PL/SQL, 14.3.1

stored procedure, 14.2, 14.2

to stored procedure

known restrictions, 2.5.1

capabilities of DRDA server, native semantics, 14.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.19

CCSID (coded character set identifiers), defined, D.5

CD-ROM drive requirements, 3.1.4

changed parameters, 16.3.2

changes in this release

IBM DB2 Version 5.1 EBCDIC and ASCII Tables, 1.9.21

IBM DB2/UDB supported, 1.9.20

read-only support, 1.9.22

CHARACTER SET clause, client/server configuration, D.2

CHARACTER SET parameter

description, D.1

character sets

and codepage map facility, D.4

ASCII, 1.9.21

CCSID, D.1

codepage, C.4.8

EBCDIC, 1.9.21

supported, 1.9.19

character string

converting datatypes, 14.7.2

performing operations, 14.7.2

checklist

configuring the communications interfaces, 6.1, 8.1

configuring the DRDA server, 5.1

gateway configuration, 12.1

gateway installation, 4.3

installation overview, 4.3

Oracle Net, 11.1

CHECKSUM command, 1.3.3, 11.5

CICS transaction, 14.3.2

clause

CHARACTER SET, client/server configuration, D.2

clauses

CONNECT TO, 13.1.1

GROUP BY, SQL Set Clauses, 14.6.3

HAVING, SQL Set Clauses, 14.6.3

ORDER BY, SQL Set Clauses, 14.6.3

SQL

DELETE, 14.7.7

INSERT, 14.7.7

SELECT WHERE, 14.7.7

UPDATE, 14.7.7

USING, 13.1.1

VALUES

functions not allowed by DB2, 14.7.7

WHERE

known restrictions, SQL limitations, 2.5.2

WHERE CURRENT OF CURSOR

known restrictions, SQL limitations, 2.5.2

WHERE, SQL Set Clauses, 14.6.3

code tracing, C.4.40

codepage map facility

configuring support for character sets, known restrictions, 2.5.1

for data translation, D.4

supported by gateway, 1.9.19

coercion

of data, 14.6

collection privilege - CREATE IN, 5.2.2, 5.5.2

collection privilege - CREATETAB, 5.2.2

column

date columns, TO_DATE function, 14.7.7

Oracle ROWID

known restrictions, 2.5.2

supported in a result set, 1.9.8

commands

AGW ADD USERID, 15.5.1.2

AGW DELETE USERID, 15.5.1.2

CHECKSUM, 1.3.3, 11.5

COPY

known restrictions, 2.5

Oracle Database server to DRDA server, 13.8

COPY (SQL*Plus command), 13.8

CREATE DATABASE LINK

DB2/VM, 5.5.2

DESCRIBE

known restrictions, 2.4

EXECUTE, 1.3.9.1

EXPLAIN PLAN, 17.4.1

INSERT

known restrictions, 2.5

INSERT, not supported, 13.8

lanscan, 7.6.3, 9.6.3

commit confirm protocol, 1.3.13

Communication Database (CDB) tables, DDF, 5.2.5

communications requirements, 3.2.3

Communications Server

configuring server profiles, 8.2

profiles

creating, 8.3

compatible SQL set operators and clauses, 14.6.3

concatenation restrictions, 2.5.1

concurrent connections

APPC, 3.1.2

TCP/IP, 3.1.2

configuration

SNA sample file, 6.3

configuring

additional DRDA servers, 12.9

AS/400 communications, 5.3.1

AVS, 5.5.1

binding DRDA package, 12.5

checklist for gateway, 12.1

checklist for installation overview, 4.3

checklists, 4.3, 4.3, 5.1, 6.1, 8.1, 11.1, 12.1

communications interfaces, steps for, 7.1, 9.1

DB2/400, 5.3, 5.3.1, 5.4

DB2/OS390, 5.2

DB2/UDB, 5.4.1

host workstation for gateway, 12.4

MVS VTAM, 5.2.1

Oracle integrating server, 12.7

Oracle Net, 11.4, 11.4

other Oracle Database servers, 12.8

SNA server

creating profiles, 8.3

testing connection, 8.4

SNAPlus2 on HP-UX, 9

SunLink SNA Peer-to Peer product, 6.3

TCP/IP

DB2/400, 5.3.1

DB2/OS390, 5.2.1

DB2/UDB, 5.4.1

DB2/VM, 5.5.1

under Solaris, 10.2

VM VTAM, 5.5.1

CONNECT authority, 12.4.4, 15.5.1.2

CONNECT BY not supported

known restrictions, SQL limitations, 2.5.2

CONNECT privilege

DB2/UDB, 5.4.2

CONNECT TO clause, 13.1.1

contact information

in configuring SNAplus2, 7.6.3, 9.6.3

conversion

errors, C.4.8

convert

character string, 14.7.2

datatypes

DRDA to Oracle datatypes, 14.7

DATE, 14.7.4.2

floating point to integer, 14.7.8

inbound user ID, 15.5.1.2

into most suitable datatype, 14.7.10

SQL, 1.7.1

to the numeric datatype, 14.7.8

converter, protocol, 1.3.3

COPY command

Oracle Database server to DRDA server, 13.8

COPY privilege

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

COPY SQL*Plus command, 13.8

substituted for INSERT, known restrictions, 2.5

copying data

from the DRDA server, 13.9

from the Oracle server to DRDA server, 13.8

COS SQL function, 14.5.3.1

COUNT function, 14.7.9, 14.7.9

CP (Control Point for the Node), 7.5, 9.5

CPI-C

communication error messages, 17.1.4, 17.3

create Side Information Profile, 7.6.3, 9.6.3

profiles, creating, 7.6.3, 9.6.3

requires Side Information File, 6.4

routine, 17.1.4

side information profile, 7.6.3, 9.6.3

CREATE command

supported by COPY, 13.8

CREATE DATABASE LINK command, 13.1.1

DB2/VM, 5.5.2

CREATE DATABASE statement, client/server configuration, D.2

CREATE IN privilege

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CREATE PUBLIC DATABASE LINK privilege, 12.4.3, 12.7.1

CREATE TABLE statement, 1.3.8

CREATEIN privilege

DB2/UDB, 5.4.2

CREATETAB authority, 12.4.4

CREATETAB privilege

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

creating

a new directory, 4.6.2

CPI-C and mode definitions, 7.6.3, 9.6.3

database link, 13.1.1

link station, 7.6.3, 9.6.3

local LU names, 7.6.3, 9.6.3

partner LUs, 7.6.3, 9.6.3

remote node definition, 7.6.3, 9.6.3

SNA definitions for the gateway, 7.6, 9.6

SNAplus2 profiles, 7.4, 9.4

cursor

defining the number of, 14.10

number of cursors, DRDA_PACKAGE_SECTIONS, C.4.23

stability, DRDA_ISOLATION_LEVEL, C.4.15

D

data coercion, 14.6

data control language (DCL), 1.3.7

DATA datatype, 14.7.4.1

data definition language (DDL), 1.3.6

data dictionary

support, 12.5.2

using, 14.9.1

views

ALL_DB_LINKS, 13.1.4

considerations for migration from previous releases, 16.4

emulation on DRDA server, 14.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, 13.1.4

database

catalogs, 14.9

database authorities - CONNECT, BINDADD, and CREATETAB, 5.4.2

database link

behavior, 14.4

binding the gateway package, 12.4.3

creating, 13.1.1

defining and controlling, 15.3

dropping links, 13.1.3

examining, 13.1.4

guidelines, 13.1.2

limits, 13.1.5

processing, 13.1

public, 12.7.1

suffix, 14.1

to identify the gateway, 1.7

database triggers, 1.3.2

datatype

character string, 14.7.1

column (ALL_TAB_COLUMNS), A.2.10

column (USER_TAB_COLUMNS), A.2.26

conversion

DRDA to Oracle datatypes, 14.7

no control over, 14.7.8

converting character string, 14.7.1, 14.7.2

data and time, 14.7.4

differences between Oracle server and DRDA databases, 14

DRDA server datatypes list, 14.7

mapping, 14.7

numeric, 14.7.8, 14.7.10

operations, numeric, 14.7.8

Oracle datatypes RAW and LONG RAW, 14.7.1

restrictions, 14.7

size and value limitations, 14.7

datatypes

DATE, 14.7.4, 14.7.4, 14.7.4.1, 14.7.4.2

GRAPHIC, 14.7.3

LONG, 14.7.2

LONG RAW, 14.7.1

Oracle and IBM DATE, 14.7.4.2

Oracle DATE, 14.7.4.1

RAW, 14.7.1, C.4.8

TIME, 14.7.4, 14.7.4.1

TIMESTAMP, 14.7.4, 14.7.4.1

VARCHAR, 14.7.2

date

date columns, TO_DATE function, 14.7.7

DELETE

statement, 14.7.5, 14.7.5

HS_NLS_DATE_FORMAT parameter, 14.7.5, 14.7.6

INSERT

statement, 14.7.5, 14.7.5

operations, 14.7.4

SELECT statement, 14.7.5, 14.7.5

TO_DATE function, 14.7.5

UPDATE

statement, 14.7.5, 14.7.5

date arithmetic

known restrictions, 2.5.1

DATE datatype, 14.7.4, 14.7.4.2

DB_DOMAIN parameter

known restrictions, 2.5.1

DB2

02pcg.sql granting authority, 12.5.2.1

alias objects

known restrictions, 2.5

aliases, C.4.9

CICS, 14.3.2

configuring DB2/OS390, 5.2

data access, 1.3.9.1

Distributed Data Facility (DDF), 5.2.5

DRDA_DESCRIBE_TABLE compatibility, C.4.9

IBM DB2 Version 5.1 ASCII Tables, 1.9.21

IMS, 14.3.2

native SQL, 1.3.8

native stored procedures, 1.3.9.2

procedural feature considerations, 14.3.2

SPUFI utility, 5.2.5

SQL statements, 14.8.1

statements

CREATE TABLE, 1.3.8

stored procedures, 14.3.2

DB2/400

catalog view, 14.9.1

configuring, 5.3, 5.3.1, 5.3.2, 5.4

data dictionary views supported by gateway, A.1

DRDA_DEFAULT_CCSID, C.4.8

DRDA_DISABLE_CALL, C.4.10

DRDA_ISOLATION_LEVEL, C.4.15

DRDA_OPTIMIZE_QUERY, C.4.18

DRDA_PACKAGE_COLLID, C.4.19

user ID mapping, 15.5.1.3

DB2/OS390

catalog view, 14.9.1

configuring, 5.2

data dictionary views supported by gateway, A.1

DRDA_DISABLE_CALL, C.4.10

DRDA_ISOLATION_LEVEL, C.4.15

DRDA_OPTIMIZE_QUERY, C.4.18

user ID mapping, 15.5.1.1

DB2/OS390 V6 and V7

stored procedures supported, 1.9.18

DB2/UDB

binding packages, 12.4.4

binding the gateway package, 12.5.1.2

catalog view, 14.9.1

configuring, 5.4, 5.4.1

data dictionary views not supported, A.1

DRDA_ISOLATION_LEVEL, C.4.15

DRDA_OPTIMIZE_QUERY, C.4.18

incompatibilities with gateway, 2.4

known restrictions, 2.5.1

supported, 1.9.20

user ID mapping, 15.5.1.4

DB2/VM

catalog view, 14.9.1

configuring, 5.5

data dictionary views not supported, A.1

database and SQL functions, 14.5.8

DRDA_ISOLATION_LEVEL, C.4.15

DRDA_OPTIMIZE_QUERY, C.4.18

DRDA_PACKAGE_OWNER, C.4.22

instance, DRDA location name, 5.5.4

server machine, 15.5.1.2

user ID mapping, 15.5.1.2

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 14.8, 14.8, 14.8.1

DD basic tables, known restrictions, 2.5.1

DDF

DB2 (Distributed Data Facility), 5.2.5

subsystem, 5.2.1

DDL

statement, 14.8, 14.8.1

debug

gateway, 17.4, 17.4.2

library, 17.4.2

debugging

error codes, 17.1.3

SQL tracing, 17.4, 17.4.2

your application, 13.10

de-installing the gateway, 4.7, 4.7.1

DELETE

known restrictions, SQL limitations, 2.5.2

operation, 14.1

read-only gateway, 13.6

SQL clause, 14.7.7

statement, 14.8

DESCRIBE

character string operations, 14.7.1

command, known restrictions, 2.4

diagnostic parameter, C.4.38

dictionary

mapping, 1.3.4

tables, 14.9

DICTIONARY view, A.2.15

disk space requirements, 3.1.5

distributed

operations, DB2, 5.2.5

queries

example of, 13.5.1

two-phase commit, 13.5.2

transaction, DRDA_RECOVERY_USERID, C.4.26

distributed applications

support for, 1.9.15

distributed data facility (DDF), 5.2.5

distributed database, 11.3.2

distributed DRDA transactions, 13.5.3

distributed processing, 11.3.1

distributed query optimizer (DQO), 13.5

DRDA-specific parameters, C.4.18

dmesg, 7.6.3

double-byte support, D.5

DQO

also see distributed query optimizer, 13.5

DRDA-specific parameters, C.4.18

drc error code, 17.1.3

DRDA

catalog, 14.9.2

database requirements, 3.2.2

defining number of cursors, 14.10

gateway package considerations, 12.5

location name

for DB2/UDB instance, 5.4.4

for DB2/VM instance, 5.5.4

mode

IBMRDB, 7.6.3, 9.6.3

session security options, 15.5.1.1

DRDA Application Server Function, 1.9.12

DRDA server

accessing, 12.9

and dependent LUs, 7.5, 9.5

and independent LUs, 7.5, 9.5

and Side Information Profiles, 7.4, 9.4

architecture, 1.5

capabilities, native semantics, 14.6

character sets

known restrictions, 2.5.1

client applications initiate conversations using dependent LUs, 7.5, 9.5

configuring

DB2/400, 5.3

DB2/OS390, 5.2

DB2/UDB, 5.4

DB2/VM, 5.5

considerations for binding packages, 16.4

copying data

from Oracle server, 13.8

to Oracle server, 13.9

database link behavior, 14.4

default TP name, 7.6.3, 9.6.3

functions, 14.6

languages and character sets in configuration, D.4

Logical Unit (LU), 6.6, 7.7, 8.5, 9.7

partner LU, 7.6.3, 9.6.3

stored procedures, 14.3

VTAM definitions and local LU names, 7.6.3, 9.6.3

DRDA_CAPABILITY parameter, 14.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, 17.1.4

determine SNA V9 value for worksheet, 6.4.4

DRDA_DEFAULT_CCSID parameter, C.4.8

DRDA_DESCRIBE_TABLE parameter, C.4.9

known restrictions, 2.5

DRDA_DESCRIBE_TABLE=FALSE initialization parameter

known restrictions, 2.5

DRDA_DISABLE_CALL parameter, 12.5.1.1, C.4.10

DRDA_FLUSH_CACHE parameter, C.4.11

DRDA_GRAPHIC_LIT_CHECK parameter, C.4.13

DRDA_GRAPHIC_PAD_SIZE parameter, C.4.12

DRDA_GRAPHIC_TO_MBCS parameter, C.4.14

DRDA_ISOLATION_LEVEL parameter, C.4.15

DRDA_LOCAL_NODE_NAME parameter, C.4.16

DRDA_MBCS_TO_GRAPHIC parameter, C.4.17

DRDA_OPTIMIZE_QUERY parameter, 13.5, C.4.18

DRDA_PACKAGE_COLLID parameter, 17.1.5, C.4.19

DRDA_PACKAGE_CONSTOKEN parameter, C.4.20

DRDA_PACKAGE_NAME parameter, 12.5.1.1, 17.1.5, C.4.21

DRDA_PACKAGE_OWNER parameter, C.4.22

DRDA_PACKAGE_SECTIONS parameter, 14.10, C.4.23

DRDA_READ_ONLY parameter, 13.6, C.4.24

DRDA_RECOVER_USERID, 5.4.3

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/VM, 5.5.3

DRDA_RECOVERY_PASSWORD parameter, 5.4.3, C.4.25

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DRDA_RECOVERY_USERID parameter, 5.4.3, C.4.26

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/VM, 5.5.3

DRDA_REMOTE_DB_NAME parameter, C.4.27

DRDA_SECURITY_TYPE parameter, C.4.28

DROP DATABASE LINK statement, 13.1.3

dropold.sql script, 12.5.2.1

DSPRDBDIRE command, 5.3.4

dynamic dictionary mapping, 1.3.4

E

EBCDIC

character set support, D.3.2.1

code page, D.3

DRDA server CCSID, D.7

sort order, 14.6.2

tables, known restrictions, 1.9.21

translated to ASCII, 14.7.1

EMP

system-wide synonym, 13.4

table, 13.8

empproc

stored procedure, 14.3

encryption types for Advanced Security, 11.6

environment

heterogeneous, 13.7

environment variable

NLS_LANG, D.2

environmental variable

NLS_LANG, D.1

ORA_NLS33, D.1

ORACLE_HOME, 4.6.3

environmental variables

$DISPLAY, 7.6.3, 9.6.3

errd

mapped error example, 17.2

errmc

CPI-C routine, 17.1.4

errmc field lists any error tokens, 17.1.3

errmc=1245, error at gateway bind, Bug 3275652, 2.4

ERRMC=124C, Bug 3121041 (fixed), 2.3

error tokens, 17.1.5

mapped error example, 17.2

errnc

ERRNC 124C, Bug 2787316 (fixed), 2.3

error

12660 (test error for Advanced Security), 11.6

basic description, 17.1

change, ORA-09100 to ORA-28500, 17.1.3

change, ORA-09101 to ORA-28501, 17.1.3

codes

drc, 17.1.3

grc, 17.1.3

communication, 17.1.4, 17.1.4

condition, 17.1

conversion, C.4.8

date, D.3.2.3

detected

by Oracle integrating server, 17.1.1

by server database, 17.1.5

by the gateway, 17.1.2

in DRDA software, 17.1.3

in the DRDA software, 17.1.3

drc= field

-300xx, 17.3

-7xx, 17.3

HGO-00706, 17.1.2

host database, 17.3

interpreting error messages, 17.1

mapped sqlstate, 17.2

messages, 6.7.2, 7.8.2, 8.6.2, 9.8.2, 14.7.2

messages & codes, 17

number, 17.1

obsolete parameters, 16.3.4

ORA-00001, index constraint violated, 17.2

ORA-00942

mapped error example, 17.2

object name too long, 17.2

ORA-01017, logon denied, 17.2

ORA-01031, insufficient privileges, 17.2

ORA-01460, invalid CCSID, 17.2

ORA-01476, divide by zero, 17.2

ORA-02019, 17.1.1

ORA-2025, when using INSERT command, 13.8

ORA-28500 (was ORA-09100), 17.1.3, 17.1.5

ORA-28501

communication error, 17.1.4

was ORA-09101, 17.1.4

ORA-9100 to ORA-9199, 17.1.1

Oracle mapped error codes, 17.2

specific gateway error codes, 17.3

tokens, 17.1.3, 17.1.5

translation, 14.7.1

while binding the gateway package, 12.4.3

with Native Semantics, 14.6

error array (errd), See errd

errp

errp field indicates program that detected error, 17.1.3

errp=GDJMRC, error at gateway bind, Bug 3275652, 2.4

ERRP=GDJMRCCH, Bug 3121041 (fixed), 2.3

mapped error example, 17.2

EXCEPT set operator, SQL Set Clauses, 14.6.3

execute authority, 15.5.1.2

EXECUTE command, 1.3.9.1

EXECUTE privilege

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

exits

gateway local date, 14.7.6

EXPLAIN PLAN command, 17.4.1

EXPLAIN_PLAN table, 1.9.9, 1.9.9

export encryption algorithms, 11.5

F

FDS_CLASS parameter, C.4.29

FDS_CLASS_VERSION parameter, C.4.30

FDS_INSTANCE parameter, C.4.31

features

Oracle Snapshots, 13.7.2

features of the gateway

application development and end-user tools, 1.9.16

application portability, 1.9.13

columns supported in a result set, 1.9.8

distributed applications supported, 1.9.15

EXPLAIN_PLAN improvement, 1.9.9

fetch reblocking, 1.9.3

heterogeneous database integration, 1.9.10

heterogeneous services architecture, 1.9.1

large base of data access, 1.9.12

main topic, 1.9

minimum impact on existing systems, 1.9.11

Native Semantics, 1.9.7

Oracle Database passthrough supported, 1.9.4

performance enhancements, 1.9.2

remote data access, 1.9.14

retrieving result sets through passthrough, 1.9.5

support for TCP/IP, 1.9.6

fetch array size, with HS_FDS_FETCH_ROWS, C.4.32

fetch reblocking, 1.9.3, 14.1.1, 14.1.1

fetched date, C.4.36

fields

errmc, lists any error tokens, 17.1.3

errp, indicates program that detected error, 17.1.3

file member name, 13.3

file members

accessing AS/400 files, 13.3

files

initsid.ora

communication errors, 17.1.5

gateway error -700, 17.3

listener.ora, 11.4.2

sample, B

listener.ora, B.3

tnsnames.ora, B.2

sna_domn.cfg, 7.6, 9.6

sna_node.cfg, 7.6, 9.6

tnsnames.ora, 12.7.1, 12.9

modifying, 11.4.2

VSAM, 14.3.2

FOR BIT DATA

DRDA_DEFAULT_CCSID, C.4.8

option, 14.7.1

free session, DRDA_CMSRC_CM_IMMEDIATE, C.4.7

functions

COS, 14.5.3.1

COUNT, 14.7.9

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 14.8, 14.8, 14.8.1

DRDA server, 14.6

SQL

SUBSTR, 14.6

SUBSTR

known restrictions, 2.5.1

TO_DATE, 14.7.4.2, 14.7.5, 14.7.6

TO_DATE, main topic, 14.7.7

G

g4ddtab.sql script, 12.5.2.1

g4ddview.sql script, 12.5.2.1

gateway

accessing

from other Oracle servers, 12.8

main topic, 13.2

advantages

main topic, 1.2.1

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.16

architecture, 1.5, 1.5

authenticating logons, 15.2

benefits of integration with Oracle Database server, 1.3.3

binding DRDA packages, 12.4.3

components, 1.6

configuration, 12.3

definition of terms, 1.4

de-installing, 4.7, 4.7.1

DRDA package considerations, 12.5

error codes, 17.3

errors detected, 17.1.2

features, 1.9

main topic, 1.9

how to access, 13.2

installation

log file, 4.6.8

steps, 4.6

steps via Oracle Universal Installer, 4.6.7

interface, 1.7

local date exit, 14.7.6

logging, LOG_DESTINATION, C.4.35

migration problems, 16.2

name, setting up, with Sunlink, 6.2

parameter, 5.5.4

performance, 14.6

performance enhancements, 1.9.2

performing distributed queries, 13.5

read-only option, 13.6

service name entries in the tnsnames.ora, 16.5

settings for security options, 6.7, 7.8, 8.6, 9.8

SQL differences, 1.7.1

supported languages, D.4

tracing SQL statements, 13.10

tracing, LOG_DESTINATION, C.4.35

using, 13

with other Oracle products

SQL*Plus, 1.3.12

Gateway Initialization File

backup and recovery of gateway configuration, 12.6

configuring for binding the DRDA gateway package, 12.4.3

defining userids and passwords, 15.6

encrypting passwords, 15.7

if errors are reported, 12.4.3

modifying, C.1

parameters

DRDA_READ_ONLY, 13.6

LOG_DESTINATION, 17.4.2

LOG_DESTINATION parameter, tracing, 17.4.2

new since V4 gateway, 16.3.1.1

ORACLE_DRDA_TCTL, 17.4.2

stored in initsid.ora, C.2

TRACE_LEVEL, 17.4.2

parameters, list, C.4

sample, B.1

Gateway System Identifier (SID), 12.2

GCS virtual machine, 15.5.1.2

GLOBAL_NAMES

known restrictions, 2.5.1

GRANT, 15.5.1.2

GRANT statement, 12.7.2

granting authority to a package for DB2, 12.5.2.1

GRAPHIC datatype, 14.7.3

graphic string operations

unsupported, 14.7.3

grc error code, 17.1.3

GROUP BY clause

SQL Set Clauses, 14.6.3

GTW$_BIND_PKG

internal stored procedure, 12.5

stored procedure, 12.4.3

H

hardware requirements, 3.1

HAVING clause

SQL Set Clauses, 14.6.3

heterogeneous database integration, 1.9.10, 1.9.10

Heterogeneous Services (HS), see HS, 1.2

HGO-00706 error, 17.1.2

host

DRDA server, SNA and TCP/IP protocols, 1.5

networking needs, 3.2.5

performing character string operations on, 14.7.1

relationship to gateway and Oracle Server, 1.5

security validation required to begin database link, 6.6, 7.7, 8.5, 9.7

SNAP-IX definitions, 7.6.1

host database error, 17.3

host Logical Unit (LU), 6.6, 7.7, 8.5, 9.7

host variable, 14.7, 14.7.2

HP9000 host, 9.6.1, 9.6.3

invoking xsnapadmin, 9.6.3

HS (Heterogeneous Services)

architecture features, 1.9.1

Oracle Net considerations, 16.5

HS= (TNSNAMES parameter for Oracle Net), 11.4.2, 11.4.2

gateway migration problems, 16.2

HS_DB_DOMAIN parameter

known restrictions, 2.5.1

HS_FDS_FETCH_ROWS parameter, C.4.32

HS_LANGUAGE parameter, C.4.33

HS_NLS_DATE_FORMAT, D.3.2.3

parameter, 14.7.6

HS_NLS_DATE_LANGUAGE, D.3.2.4

HS_NLS_NCHAR, D.3.2.2

HS_NLS_NCHAR parameter, C.4.34

HS_RPC_FETCH_REBLOCKING parameter, 1.9.3, 14.1.1

HS_RPC_FETCH_SIZE parameter, 1.9.3, 14.1.1, 14.1.1

I

IBM Communications Server for AIX

and SNA security option, 6.7.2, 7.8.2, 8.6.2, 9.8.2

Version 5 required patches, 3.2.4

IBMRDB, 7.6.3, 9.6.3

DRDA mode, 7.6.3, 9.6.3

implementation, 1.6

implicit data conversion, 14.6

implicit protocol conversion, 1.3.3

IMS transaction, 14.3.2

IN and OUT columns, multi-byte support, D.5

inbound connections

processing, 15.5

initdrdahoa1.ora

sample, B.1

see also Gateway Initialization File parameters

initialization parameters

new since V4 gateway, 16.3.1.1

see also Gateway Initialization Files, parameters

initsid.gtwboot file

migrating, 16.1.2

initsid.ora file

communication errors, 17.1.5

gateway error -700, 17.3

migrating, 16.1.2

NLS parameters, D.3.2

input bind variables, 14.7.4.2

INSERT

known restrictions, 2.5

operation, 14.1

Oracle SQL command, known restrictions, 2.5

read-only gateway, 13.6

SQL clause, 14.7.7

statement, 14.7.5, 14.7.5, 14.8

INSERT command

known restrictions, 2.5

supported by COPY, 13.8

INSERT command, not supported, 13.8

installation

checklists, 4.3, 4.3, 5.1, 6.1, 8.1, 11.1, 12.1

overview, 4.4

installing the gateway

from CD, 4.6

internal tracing, C.4.39

Internet support, 1.3.3

INTERSECT

SQL set operators and clauses, 14.6.3

IPC

adapter, B.3

ISO standard, 1.3.5

isolation level, DRDA_ISOLATION_LEVEL, C.4.15

J

JOIN

capability, 1.3.2

JOIN SQL statement, 14.1

K

keywords

LISTENER, B.3

known problems

compatibility with DB2/UDB, 2.4

known restrictions

accessing DB2 alias objects, 2.5

AVS mapping user IDs, 2.5.1

bind variables become SQL parameter markers, 2.5.2

binding the DRDA gateway package on DB2/UDB, 2.5.1

CONNECT BY not supported, SQL limitations, 2.5.2

datatype limitations, 2.5.1

date arithmetic, 2.5.1

DD basic tables and views, 2.5.1

dictionary views not provided for DB2/VM, 2.5.1

DRDA server character sets, 2.5.1

GLOBAL_NAMES parameter, 2.5.1

INSERT (Oracle SQL command), 2.5

LONG datatype in SQL*Plus, 2.5.1

null values and stored procedures, 2.5.1

Oracle ROWID column, 2.5.2

row length limitation, 2.5.1

SAVEPOINT, 2.5.1

single gateway instances per DRDA network interface, 2.5.1

SQL*Plus DESCRIBE command, 2.4

string concatenation, 2.5.1

SUBSTR function post-processed, 2.5.1

Korn shell

setting ORACLE_HOME variable, 4.6.3

L

LANGUAGE parameter, D.3.2.1

languages, 1.3.10

SQL*Plus, 1.3.12

lanscan command, 7.6.3, 9.6.3

link station

creating, 7.6.3, 9.6.3

parameters, 7.6.3, 9.6.3

testing SNA connection, 7.9, 9.9

link, also see Database Link, 14.4

linkage conventions

SIMPLE WITH NULLS, 14.3.2

linkname, 12.7.1

listener, B.3

LISTENER keyword, B.3

listener.ora file, 11.4.2

sample, B.3

literal

character literals, 14.7.4.1

date, 14.7.4.2

specific datatype, 14.7

TO_DATE, format support, 14.7.7

log file, gateway installation, 4.6.8

LOG_DESTINATION parameter, 17.4.2, 17.4.2, C.4.35, C.4.39

logging, LOG_DESTINATION, C.4.35

Logical Unit (LU), 6.6, 7.7, 8.5, 9.7

LONG datatype, 14.7.2

LONG RAW datatype, 14.7.1, 14.7.1

dependent, 7.5, 9.5

additional SNAPlus2 configuration needed, 7.5, 9.5

Side Information Profiles, 7.5, 9.5

independent vs. dependent, 7.5, 9.5

local LU alias, 7.6.3

CPI-C destination, 7.6.3, 9.6.3

Ethernet parameters, 9.6.3

local names, 9.6.3

creating, 7.6.3, 9.6.3

names, 7.6.3, 9.6.3

partner

creating, 7.6.3, 9.6.3

SNAP-IX profiles, 7.4

SNAPlus2 profiles, 9.4

traffic type, in configuring SNAplus2, 7.6.3, 9.6.3

LU name, 15.5.1.1

LU6.2

local LU profile, 8.3.2.2

profile types, 8.3.2

side information profile, 8.3.2.6

SNA APPC, 6, 7, 8, 9

M

MAC address

in SNA configuration, 7.6.3

in SNAplus2 configuration, 9.6.3

mapped sqlstate errors, 17.2

mapping user IDs

AVS, 15.5.1.2

known restrictions, 2.5.1

migrating the gateway instance, 16.4

migration problems, 16.2

MINUS

set operator, SQL Set Clauses, 14.6.3

SQL set operators and clauses, 14.6.3

mode

name, 7.6.3, 9.6.3

profiles, creating, 7.6.3, 9.6.3

Mode Profile

SNA Server profile, 8.3.2.1

Mode_name

description, 6.4.2

multi-byte support, D.5

MVS VTAM

configuring DB2/OS390, 5.2.1

N

National Language Support

initsid.ora parameters, D.3.2

overview, D

Native Semantics

gateway architecture, 1.9.7

parameters, SQL Set Clauses, 14.6.3

with SUBSTR function, known restrictions, 2.5.1

network

attachment, 3.1.3

Oracle Net configuration, 11.4

requirements, 3.1.3

NLS

Also See National Language Support, D

DRDA server character sets, D.4

NLS 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, 14.7.1

null

rows, 14.7.9

values, 14.7.9

number of cursors, DRDA_PACKAGE_SECTIONS, C.4.23

numbers

concatenation restrictions, 2.5.1

numeric datatype, 14.7.8, 14.7.10

O

o2pc.sql, 12.5.2.1, 13.5.2

obsolete parameters since V4 gateway, 16.3.4

open cursors, at the IBM database, 14.10

OPEN_LINKS parameter, 13.1.5

operating system requirements, 3.2.1

operations

DELETE, 14.1

INSERT, 14.1

SELECT, 14.1

UPDATE, 14.1

operators

UNION ALL, SQL Set Clauses, 14.6.3

UNION, SQL Set Clauses, 14.6.3

option

binding packages, 12.4.4

data dictionary views, 14.9

date format string, 14.7.5

DRDA session security, 15.5.1.1

FOR BIT DATA, 14.7.1

Oracle server, 1.5

read-only

gateway configuration, 1.3.13

replicating, 13.7

security conduct, 15.5

service port number, DRDA_CONNECT_PARM, C.4.6

SNA security, 6.7, 7.8, 8.6, 9.8

SQL functions, 14.6.1

SQL*Plus COPY command, 13.8

ORA_MAX_DATE parameter, C.4.36

ORA_NLS33 parameter, C.4.37

description, D.1

ORA-00001 error, index constraint violated, 17.2

ORA-00942 error

mapped error example, 17.2

object name too long, 17.2

ORA-01017 error, logon denied, 17.2

ORA-01031 error, insufficient privileges, 17.2

ORA-01403 error at gateway bind, Bug 3275652, 2.4

ORA-01460 error, invalid CCSID, 17.2

ORA-01476 error, divide by zero, 17.2

ORA-02019 error, 17.1.1

ORA-06512 error at gateway bind, Bug 3275652, 2.4

ORA1 Oracle instance, 14.2

ORA-1821 with bug 1941672 (fixed), 2.3

ORA2 Oracle instance, 14.2

ORA-2025

error when using INSERT command, 13.8

ORA-2068 with Bug 2854129 (fixed), 2.3

ORA-28500 error

was ORA-09100, 17.1.3

ORA-28500 with Bug 3121041 (fixed), 2.3

ORA-28501 error

communication error, 17.1.4

ORA-28511 with Bug 2854129 (fixed), 2.3

ORA-28527, conversion errors, C.4.8

ORA-9100 to ORA-9199 errors, 17.1.1

Oracle

directory tree, 4.6.2

error number or return code, 17.1

mapped error codes, 17.2

products compatibility, 1.8

RAW datatype, C.4.8

snapshots, 13.7.2

Oracle Database

stored procedure, defined, 14.2

Oracle Database 10g

server description, 1.2

Oracle integrating server

accessing gateway from other Oracle Database servers, 12.8

accessing other DRDA servers, 12.9

accessing the gateway, 13.2

architecture, 1.5

configuration, 12.7

definition, 1.4

errors detected, 17.1.1

requirements, 3.2.4

using, in application development, 14.1

Oracle Net, 1.3.11, 16.5

and application development, 1.9.16

and distributed processing, 11.3.1

and remote data access, 1.9.14

and server coexistence, 1.5

API, 11.3

compatibility with SQL*Net, 11.2

configuring, 11.4, 11.4

distributed

database, 11.3.2

processing, 11.3.1

editing to set up security test, 11.6.1

Heterogeneous Services (HS) facility, 11.2

introduction, 11.2

operating system authentication, 15.2

overview, 11.3

purpose, 1.6

requirements, 3.2.5, 3.2.5

sample files, B

sample listener.ora file, B.3

support for CHECKSUM and encryption, 11.5

terminology, 11.3.3

client, 11.3.3

driver, 11.3.3

host, 11.3.3

network, 11.3.3

protocol, 11.3.3

TNS connect descriptor specification, 13.1.1

Oracle ROWID column

known restrictions, 2.5.2

Oracle Server

relationship to host, 1.5

services, 1.3.2

database triggers, 1.3.2

distributed capabilities, 1.3.2

distributed query optimization, 1.3.2

SQL, 1.3.2

stored procedures, 1.3.2

two-phase commit protection, 1.3.2

triggers, 13.7.1

Oracle server

copying data

from DRDA server, 13.9

to DRDA server, 13.8

Oracle Universal Installer

de-installing the gateway, 4.7.1

starting, 4.6.6

steps to install the gateway, 4.6.7

upgrading for installation, 4.6.6

ORACLE_DRDA_TCTL parameter, 17.4.2, C.4.38

ORACLE_DRDA_TRACE parameter, C.4.39

ORACLE_HOME

environmental variable, 4.6.3

for the gateway, 4.6.2

ORACLE2PC table, 12.4.4, 12.5.1.2, 12.5.2.1, 13.5.3

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2, 5.4.2

DB2/VM, 5.5.2

ORACLE2PC table, DRDA_PACKAGE_OWNER, C.4.22

ORADRDA.ORACLE2PC table, 13.5.2

oraproc1, 14.2

stored procedure, 14.2

oraproc2

stored procedure, 14.2

ORARECOV user ID, 5.4.3

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/VM, 5.5.3

ORARECOV user ID, DRDA_RECOVERY_USERID, C.4.26

ORDER BY clause

SQL Set Clauses, 14.6.3

OS/390 (MVS)

configuring DB2/OS390, 5.2

P

package

collection id, DRDA_PACKAGE_COLLID, C.4.19

consistency token, DRDA_PACKAGE_CONSTOKEN, C.4.20

privileges - BIND and EXECUTE, 5.4.2

privileges - BIND, COPY, and EXECUTE, 5.2.2, 5.5.2

packed decimal, 14.7.10

parameter

changed, 16.3.2

checking settings, 12.5.1.1

diagnostic, C.4.38

gateway, 5.5.4

link station, 7.6.3, 9.6.3

Native Semantics, SQL Set Clauses, 14.6.3

new since V4 gateway, 16.3.1.1

obsolete since V4 gateway, 16.3.4

renamed since V4 gateway, 16.3.3

setting up trace parameters, 17.4

parameter file

tailoring to configure the host, 12.4

parameters

DB_DOMAIN

known restrictions, 2.5.1

DRDA_CAPABILITY, 14.6

DRDA_CODEPAGE_MAP, C.4.3, D.4

DRDA_DESCRIBE_TABLE

known restrictions, 2.5

DRDA_DISABLE_CALL, 12.5.1.1

DRDA_PACKAGE_NAME, 12.5.1.1

DRDA_PACKAGE_SECTIONS, 14.10

DRDA_READ_ONLY, 13.6

DRDA_RECOVERY_PASSWORD, 5.4.3

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DRDA_RECOVERY_USERID, 5.4.3

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/VM, 5.5.3

FDS_CLASS, C.4.29

FDS_CLASS_VERSION, C.4.30

FDS_INSTANCE, C.4.31

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, 17.1.4

DRDA_CONNECT_PARM (SNA format), C.4.5

DRDA_CONNECT_PARM (TCP/IP format), C.4.6

DRDA_DEFAULT_CCSID, C.4.8

DRDA_DESCRIBE_TABLE, C.4.9

DRDA_DISABLE_CALL, C.4.10

DRDA_FLUSH_CACHE, C.4.11

DRDA_GRAPHIC_LIT_CHECK, C.4.13

DRDA_GRAPHIC_PAD_SIZE, C.4.12

DRDA_GRAPHIC_TO_MBCS, C.4.14

DRDA_ISOLATION_LEVEL, C.4.15

DRDA_LOCAL_NODE_NAME, C.4.16

DRDA_MBCS_TO_GRAPHIC, C.4.17

DRDA_OPTIMIZE_QUERY, 13.5, C.4.18

DRDA_PACKAGE_COLLID, 17.1.5, C.4.19

DRDA_PACKAGE_CONSTOKEN, C.4.20

DRDA_PACKAGE_NAME, 17.1.5, C.4.21

DRDA_PACKAGE_OWNER, C.4.22

DRDA_PACKAGE_SECTIONS, C.4.23

DRDA_READ_ONLY, C.4.24

DRDA_RECOVERY_PASSWORD, C.4.25

DRDA_RECOVERY_USERID, C.4.26

DRDA_REMOTE_DB_NAME, C.4.27

DRDA_SECURITY_TYPE, C.4.28

HS_FDS_FETCH_ROWS, C.4.32

HS_LANGUAGE, C.4.33

HS_NLS_NCHAR, C.4.34

LOG_DESTINATION, C.4.35

ORA_MAX_DATE, C.4.36

ORA_NLS33, C.4.37

ORACLE_DRDA_TCTL, C.4.38

ORACLE_DRDA_TRACE, C.4.39

TRACE_LEVEL, C.4.40

HS_DB_DOMAIN

known restrictions, 2.5.1

HS_NLS_DATE_FORMAT, 14.7.5, 14.7.6

HS_RPC_FETCH_REBLOCKING, 1.9.3, 14.1.1, 14.1.1

HS_RPC_FETCH_SIZE, 1.9.3, 14.1.1, 14.1.1

LOG_DESTINATION, C.4.39

LOG_DESTINATON, 17.4.2

OPEN_LINKS, 13.1.5

USING, modifying tnsnames.ora file, 11.4.2

partner LU

creating, 7.6.3, 9.6.3

creating, also see LU, 7.6.3

see LU

partner LU alias, 8.3.2.4

partner LU profile, 6.4.1

Partner_LU_name

description, 6.4.1

passthrough, 1.3.8, 1.9.4, 14.8, 14.8.1, 14.8.2, 14.8.2.1

result sets, 14.8, 14.8.2, 14.8.2.1

SQL feature, 14.8

patches

required for IBM Communications Server for AIX, 3.2.4

performance, 14.6

performance enhancements

with fetch reblocking, 14.1.1

PL/SQL

call, 14.3.1

DRDA stored procedures, 14.3

records, 14.3.2

routine, 1.3.9.1

standard Oracle, 1.3.9.2

stored procedure, 14.2

port, 7.6.3, 9.6.3

adding, for SNA, 7.6.3, 9.6.3

name, adding, for SNA, 7.6.3, 9.6.3

port number

Primary, 5.2.1

DB2/400, 5.3.1

DB2/UDB, 5.4.1

Recovery, 5.2.1

DB2/400, 5.3.1

DB2/UDB, 5.4.1

post-processed SQL functions

overview, 14.5.3.1

post-processing, 14.6, 17.4.1

PREPARE TRANSACTION statement, 13.5.2

Primary port number, 5.2.1

DB2/400, 5.3.1

DB2/UDB, 5.4.1

privileges

BIND

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

BINDADD

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

BINDAGENT

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CONNECT

DB2/UDB, 5.4.2

COPY

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CREATE IN

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CREATE PUBLIC DATABASE LINK, 12.4.3, 12.7.1

CREATEIN

DB2/UDB, 5.4.2

CREATETAB

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

data dictionary emulation, 14.9

EXECUTE

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

procedure

stored, 13.6

using DRDA server, 14.3

processing time, with GROUPBY, HAVING, WHERE, 14.6.2

product installation directory, 4.6.2

profile

creating

CPI-C and Mode profiles, 7.6.3, 9.6.3

name

see Side Information Profile

side information, 7.6.3, 9.6.3

type

see Side Information Profile

profile set, 12.9

profile types, 8.3.2

Mode Profile, 8.3.2.1

protocol

APPC/LU6.2, 6, 7, 8, 9

commit confirm, 1.3.13, 1.3.13

communications protocols, 11.3

converter, 1.3.3

definition, 11.3.3

implicit protocol conversion, 1.3.3

network, 13.4

Oracle Net Protocol Adapters, 11.2

PROTOCOL=IPC, sample, B.2

protocol-independent encryption, 1.3.3

two-phase commit, 13.5.2

protocols

IPC, 11.4.2

SNA, 1.5

TCP/IP, 1.3.3, 1.5, 1.9.6

TCP/IP, gateway transparency, 1.3.1

public database link, 12.7.1

Q

queries, distributed, 13.5

R

RAW datatype, 14.7.1, 14.7.1, C.4.8

read-only gateway option, 13.6

read-only gateway option, DRDA_READ_ONLY, C.4.24

read-only support, 1.9.22

rebind, C.4.15

DRDA_DISABLE_CALL, C.4.10

DRDA_PACKAGE_COLLID, C.4.19

DRDA_PACKAGE_CONSTOKEN, C.4.20

DRDA_PACKAGE_NAME, C.4.21

DRDA_PACKAGE_OWNER, C.4.22

DRDA_PACKAGE_SECTIONS, C.4.23

Recovery port number, 5.2.1

DB2/400, 5.3.1

DB2/UDB, 5.4.1

recovery user ID and password, 5.2.3, 5.4.3

DB2/400, 5.3.3

DB2/VM, 5.5.3

remote

computer, 11.3.1

connections, 13.1.5

data, 1.3.2

data access, 1.9.14

database, 5.4.3, 12.5, 13.1.1, 13.8, 17.1.1, 17.3

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/VM, 5.5.3

database, defining a path, 13.1.1

database, DRDA_PACKAGE_SECTIONS, C.4.23

database, privileges of user/ ID, E

DB2 system, 2.5

DRDA database, DRDA_ISOLATION_LEVEL, C.4.15

DRDA server object information, 2.4

instance, and Oracle stored procedures, 14.2

LU, 8.3.2.4

objects, 15.3.1

Oracle instance, 14.2, 14.3

Oracle servers, 11.3.2

procedure, 1.3.9.2

table, 1.3.4

transaction program, 3.1.2, 8.3

userid and password, 13.1.1

Remote Node definition

creating, 7.6.3, 9.6.3

renamed parameters, 16.3.3

REPLACE

command

supported by COPY, 13.8

replication, 13.7

requirements

hardware, 3.1

CD-ROM drive, 3.1.4

software, 3.2

RESULT, 14.3.1

result sets, 1.9.5

columns in, 1.9.8

return code, 17.1

REVISE_SALARY

stored procedure, 14.3.1

ROWID

Oracle column

known restrictions, 2.5.2

S

sample

files, B

listener.ora file, B.3

SQL scripts, 12.5.2

tnsnames.ora file, B.2

samples

Side Information File, SunLink SNA Peer-to-Peer, 6.3, 6.4.4

SNA configuration file, 6.3

SAP

dialog box, 7.6.3, 9.6.3

number, 7.6.3, 9.6.3

SAVEPOINT

known restrictions, 2.5.1

schema privileges - CREATEIN, 5.4.2

scripts

dropold.sql, 12.5.2.1

g4ddtab, 12.5.2.1

g4ddview.sql, 12.5.2.1

SDLC Coaxial network attachment, 3.1.3

security

Advanced Security, 1.3.3

DRDA_SECURITY_TYPE, C.4.28

encryption, 11.5

for session use, 7.6.3, 9.6.3

overview, 15.1

site autonomy, 1.3.14

validation

for SNA, 6.6, 7.7, 8.5, 9.7

for TCP/IP, 15.4

SELECT and array size, 1.9.3

SELECT operation, 14.1

SELECT statement, 14.1.1, 14.1.1, 14.5.3.1, 14.8.2

read-only gateway, 13.6

SELECT WHERE

SQL clause, 14.7.7

semantics, 14.6

server database error, 17.1.5

server profiles, 6, 7, 8, 9

service port number, DRDA_CONNECT_PARM, C.4.6

Service TP

"07F6C4C2", 7.6.3, 9.6.3

session

authorization, 7.6.3, 9.6.3

session, connection, 14.4

set operators

compatibility, SQL Set Clauses, 14.6.3

EXCEPT, SQL Set Clauses, 14.6.3

INTERSECT, SQL Set Clauses, 14.6.3

MINUS, SQL Set Clauses, 14.6.3

shift attribute, multi-byte support, D.5

SID

also see Gateway System Identifier, 12.2

choosing for gateway, 12.2

configuring additional DRDA server instances, 12.9

definition, 12.2

Side Information File

information needed, 6.4

sample files, 6.3

Version 9 sample, 6.4.4

Side Information Profile, 7.6.3, 8.3.2.6, 9.6.3, 17.1.4

defining, to use dependent LUs, 7.5, 9.5

description and role, 7.4, 9.4

specifies Local LU Profile name, 8.3.2.2

side information profile, 8.3.2.6

SIMPLE linkage convention, 14.3.2, G.1

single-threaded conversations for dependent LUs, 7.5, 9.5

site autonomy, 1.3.14

SMIT (System Management Interface Tool)

AIX System Management Interface Tool, 8.3

SNA

APPC, 6, 8, 9

configuring DB2/400, 5.3.1

configuring DB2/OS390, 5.2.1

configuring DB2/UDB, 5.4.1

configuring DB2/VM, 5.5.1

configuring server profiles, 8.2

connectivity via APPC, 7

conversation security, 6.7, 7.8, 8.6, 9.8

CPI-C error, 17.1.4

definitions, 7.6.1, 9.6.1

creating, for SNAP-IX, 7.6.2

creating, for SNAplus2, 9.6.2

creating, for the gateway, 7.6, 9.6

maintenance, 7.6, 9.6

facilities, 1.9.11

functions, 1.6

LU, 8.3.2.2

network, 7.6.1, 7.6.1, 7.6.2, 9.6.1

name, in creating partner LUs, 7.6.3, 9.6.3

profile, 12.9

profile definitions, 8.3

profiles, 7.4, 9.4

protocol, 1.5, 1.5, 7.6.3, 9.6.3

remote access, 1.9.14

sample configuration file, 6.3

sample profile definitions, 8.3.1

security

option and IBM Communications Server for AIX, 6.7.2, 7.8.2, 8.6.2, 9.8.2

validation, 15.4

security validation, 6.6, 7.7, 8.5, 9.7

security, DRDA_SECURITY_TYPE, C.4.28

SECURITY=PROGRAM, 6.7.1, 7.8.1, 8.6.1, 9.8.1

SECURITY=SAME, 6.7.2, 7.8.2, 8.6.2, 9.8.2

send/receive buffer, C.4.4

session allocation mode, DRDA_CMSRC_CM_IMMEDIATE, C.4.7

TPN, 8.3.2.6

SNA LU6.2

configuring DB2/400, 5.3.1

configuring DB2/OS390, 5.2.1

SNA node, 7.3, 7.6.3, 7.6.3, 9.3, 9.6.3, 9.6.3

configuring, 7.6.3, 9.6.3

SNA security option, 6.7, 7.8, 8.6, 9.8

SNA Server

Link Profile, 8.3.2.3

Local LU Profile, 8.3.2.2

Partner LU Location Profile, 8.3.2.5

Partner LU Profile, 8.3.2.4

profiles

creating, 8.3

sample profile definitions, 8.3.1

Side Information Profile, 8.3.2.6

SNA server

network requirements, 3.1.3

sna_domn.cfg file, 7.6, 9.6

sna_node.cfg file, 7.6, 9.6

SNAP-IX

configuring, 7

configuring, using xsnaadmin program, 7.3

configuring, using xsnapadmin, 7.6.2

definitions

for the gateway, 7.6.1

stored in directory, 7.6

Side Information Profiles required, 7.4

testing the connection, 7.9

SNAPlus2

configuring, 9

configuring, using xsnapadmin, 9.6.2

SNAplus2

additional configuration needed for multiple dependent LUs, 7.5, 9.5

configuring, using xsnapadmin program, 9.3

definitions

for the gateway, 9.6.1

stored in directory, 9.6

Side Information Profiles required, 9.4

testing the connection, 9.9, 9.9

version required, 3.2.3.3

snapshots

known restrictions, SQL limitations, 2.5.2

Oracle Snapshot feature, 13.7.2

software requirements, 3.2

Solaris

system support for APPC, 6

sort order

with ORDERBY, 14.6.2

SPUFI, a database native tool, 12.5.2

SQL

ANSI standard, 1.3.5

clause compatibility, 14.6.3

clauses

DELETE, 14.7.7

INSERT, 14.7.7

SELECT WHERE, 14.7.7

UPDATE, 14.7.7

commands

DESCRIBE, known restrictions, 2.4

constructs

Oracle processing, 14.5

differences in the gateway, 1.7.1

errors mapped to Oracle error codes, 17.2

functions

SUBSTR, 14.6

functions and Native Semantics, 14.6

functions list, F

gateway architecture, 1.2.1

gateway transparency, 1.3.5

ISO standard, 1.3.5

native DB2, 1.3.8

passthrough, 14.8, 14.8.1, 14.8.2, 14.8.2.1

statements, 14.1

DB2, 14.8.1

issued through the gateway, 13.10

passing through gateway, 14.8

statements, DRDA_ISOLATION_LEVEL, C.4.15

syntax, 14.7.9

tracing, not to be used in production environment, 13.10

SQL functions

column functions, 14.5.1

compatible, defined, 14.5.1

compensated, defined, 14.5.3

DB2/400, 14.5.7

DB2/OS390, 14.5.5

DB2/UDB, 14.5.6

DB2/VM, 14.5.8

post-processing, defined, 14.5.3.1

that can be disabled, 14.6.2

that can be enabled, 14.6.1

translated, defined, 14.5.2

with Native Semantics, 14.6.1

SQL tracing

in Oracle Database, 17.4.1

in the gateway, 17.4.2

LOG_DESTINATION, 17.4.2

ORACLE_DRDA_TCTL parameter, 17.4.2

TRACE_LEVEL parameter, 17.4.2

SQL*Net

gateway migration problems, 16.2

Heterogeneous Services (HS) facility, 11.2

replaced by Oracle Net, 11.2

SQL*Plus

connecting to gateway, 11.7.1

COPY command, 13.8

DESCRIBE command, known restrictions, 2.4

extending gateway uses, 1.8.1

moving data, 1.3.12

sqlstate, mapped errors, 17.2

stability, of cursor, DRDA_ISOLATION_LEVEL, C.4.15

Startup Shell Script

parameter, tailoring to configure the host, 12.4

statement

CREATE DATABASE, client/server configuration, D.2

statements

CREATE DATABASE LINK, 13.1.1

DB2 CREATE TABLE, 1.3.8

DDL, 14.8, 14.8.1

DELETE, 14.7.5, 14.8

DROP DATABASE LINK, 13.1.3

GRANT, 12.7.2

INSERT, 14.8

PREPARE TRANSACTION, 13.5.2

SELECT, 14.1.1, 14.1.1, 14.5.3.1, 14.8.2

read-only gateway, 13.6

SQL

DB2, 14.8.1

JOIN, 14.1

SELECT, 14.8.2

UPDATE, 14.7.5, 14.8

steps for

configuring communications interfaces, 7.1, 9.1

stored definitions

Side Information Profile needed for SNAP-IX, 7.4

Side Information Profile needed for SNAplus2, 9.4

stored procedure

creating on DB2, 14.3.1

DB2, 14.3.2

native DB2, 1.3.9.2

Oracle and non-Oracle, 1.3.9

Oracle Database Server

local instance, 14.2

Oracle Database server

PL/SQL, 14.2

remote instance, 14.2

Oracle Server

using, 14.2

Oracle, description, 1.3.9.1

restriction, 2.5.1

usage, C.4.10

using DRDA server, 14.3

stored procedures, 1.3.2

DB2, 13.6, 14.3

GTW$_BIND_PKG, 12.4.3

REVISE_SALARY, 14.3.1

using with the gateway, 14.2

string concatenation

known restrictions, 2.5.1

string index, with Native Semantics, 14.6

Structured Query Language, also see SQL, 1.2.1

SUBSTR SQL function, 14.6

known restrictions, 2.5.1

with Native Semantics, known restrictions, 2.5.1

Sun host

configuring the SunLink SNA Peer-to-Peer, 6.3

defining the gateway name, 6.2

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.2

starting Version 9, 6.3.1

synonym, 1.7

feature, 13.4

for location transparency, 14.2

system privileges - BINDADD and BINDAGENT, 5.2.2, 5.5.2

T

table

create a table in DB2, 14.8.1.1

insert a row into a DB2 table, 14.8.1.1

TABLE_PRIVILEGES view, A.2.17

tables

EXPLAIN_PLAN, 1.9.9

ORACLE2PC, 12.5.1.2, 12.5.2.1, 13.5.3

ORADRDA.ORACLE2PC, 13.5.2

TCP/IP

adapter, B.3

concurrent connections, 3.1.2

configuring

DB2/400, 5.3.1

DB2/OS390, 5.2.1

DB2/UDB, 5.4.1

DB2/VM, 5.5.1

configuring under Solaris, 10.2

DRDA_CONNECT_PARM, C.4.6

facilities, 1.9.11

format, gateway initialization file parameter, C.4.6

functions, 1.6

modifying tnsnames.ora in Oracle Net, 11.4.2

network attachment, 3.1.3

number of database link connections, 14.4

protocol, 1.3.3, 1.5

protocol, gateway transparency, 1.3.1

remote access, 1.9.14

security, 15.4

security validation, 15.4

support, 1.9.6

terminology defined, 1.4

tg4drda directory, also known as ORACLE_HOME, 4.6.2

TIME datatype, 14.7.4.1

time operations, 14.7.4

TIMESTAMP datatype, 14.7.4.1

TNSNAMES.ORA

changes to, during migration problems, 16.2

tnsnames.ora

connect descriptor, 13.1.1

file, 11.4.2, 12.7.1, 12.9

modifying for Oracle Net, 16.5

sample file, B.2

TO_DATE

function, 14.7.4.2, 14.7.5, 14.7.6

TO_DATE function

main topic, 14.7.7

Token Ring, 3.1.3

token, package consistency, DRDA_PACKAGE_CONSTOKEN, C.4.20

tools and the gateway, 1.8

TP name, 7.6.3, 9.6.3

TP_name

description, 6.4.3

TPN, 8.3.2.6

trace control, C.4.38

trace parameters

setting, 17.4

TRACE_LEVEL parameter, 17.4.2, C.4.40

tracing

code, C.4.40

ORACLE_DRDA_TRACE, C.4.39

SQL statements, 13.10

tracing, LOG_DESTINATION, C.4.35

trade-off, Native Semantics, 14.6

transaction mode, read-only, DRDA_READ_ONLY, C.4.24

transaction program name, remote, 8.3.2.6

transactions

CICS, 14.3.2

IMS, 14.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, 14.6

triggers

for Oracle Server, 13.7.1

TSO

configuring DB2/OS390, 5.2

two-phase commit

ORACLE2PC table

DB2/400, 5.3.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

ORACLE2PC table, DB2/OS390, 5.2.2

processing transactions, 13.5.2

protection, 1.3.2

unsupported statement, 13.5.2

U

UNION

capability, 1.3.2

operator, SQL Set Clauses, 14.6.3

SQL set operators and clauses, 14.6.3

UNION ALL

operator, SQL Set Clauses, 14.6.3

SQL set operators and clauses, 14.6.3

UPDATE

known restrictions, SQL limitations, 2.5.2

operation, 14.1

read-only gateway, 13.6

SQL clause, 14.7.7

statement, 14.8

user ID mapping

AVS, 15.5.1.2

DB2/400, 15.5.1.3

DB2/OS390, 15.5.1.1

DB2/VM, 15.5.1.2

user ID translation, DB2, 15.5.1.2

user privileges, 14.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, 13.1.4

USER_INDEXES view, A.2.22

USER_OBJECTS view, A.2.23

USER_SYNONYMS view, A.2.24

USER_TAB_COLUMNS view, A.2.26

USER_TAB_COMMENTS view, A.2.27

USER_TABLES view, A.2.25

USER_USERS view, A.2.28

USER_VIEWS view, A.2.29

USING clause, 13.1.1

USING parameter, modifying tnsnames.ora file, 11.4.2

Using the gateway, 13

V

VALUES clause

functions not allowed by DB2, 14.7.7

VARCHAR datatype, 14.7.2

variable

bind, SQL passthrough, 14.8

input bind, 14.7.4.2

view

creating, 12.7.2

data dictionary

emulation on DRDA server, 14.9

views

catalog

DB2/400, 14.9.1

DB2/OS390, 14.9.1

DB2/UDB, 14.9.1

DB2/VM, 14.9.1

VM VTAM

configuring, 5.5.1

VSAM

file, 14.3.2

VTAM

configuring DB2/OS390, 5.2

definitions

relationship to SNAplus2 definitions, 7.9, 9.9

same local LU name as on remote DRDA server, 7.6.3, 9.6.3

security validation, 6.6, 7.7, 8.5, 9.7

W

WHERE clause

known restrictions, SQL limitations, 2.5.2

SQL Set Clauses, 14.6.3

WHERE CURRENT OF CURSOR clause

known restrictions, SQL limitations, 2.5.2

X

xsnaadmin

creating SNA definitions, 7.6.2

invoking, 7.6.3

SNAP-IX definitions, 7.6.1

tool to configure SNAP-IX, 7.3

tool to create SNAP-IX definitions, 7.6

xsnapadmin

creating SNA definitions, 9.6.2

invoking, 9.6.3

tool to configure SNAplus2, 9.3

tool to create SNAplus2 definitions, 9.6

X-Windows, 7.3, 9.3

Z

zoned decimal operations, 14.7.10