Index

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

A

access method transparency (introduction), 1.3.1

accessing

DRDA Servers, 10.9

gateway, 10.8

action items of Oracle Universal Installer, 4.6.4

Advanced Security

CHECKSUM command, 9.5

encryption

export encryption algorithms, 9.5

international version types supported, 9.6

resetting configuration parameters on gateway, 9.7.2

setting test parameters for gateway, 9.6.1

setting test parameters for Oracle integrating server, 9.6.2

setting up for test, 9.6

testing gateway and Oracle integrating server, 9.7.1

function on the gateway, 1.3.3

test error

error 12660, 9.6

testing advanced security encryption, 9.7.1

AGW ADD USERID command, 13.5.1.2

AGW DELETE USERID command, 13.5.1.2

AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME, C.4.17

alias

DB2, C.4.9

objects, DB2, known restrictions, 2.5

ALL_CATALOG view, A.2.1

ALL_COL_COMMENTS view, A.2.2

ALL_CON_COLUMNS view, A.2.3

ALL_CONSTRAINTS view, A.2.4

ALL_DB_LINKS data dictionary view, 11.1.4

ALL_INDEXES view, A.2.5

ALL_OBJECTS view, A.2.7

ALL_SYNONYMS view, A.2.8

ALL_TAB_COMMENTS view, A.2.11

ALL_TABLES view, A.2.9

ALL_USERS view, A.2.12

ALL_VIEWS view, A.2.13

allocation mode, SNA session, DRDA_CMSRC_CM_IMMEDIATE, C.4.7

ALTER session statement, 11.1.2

ANSI-standard SQL

gateway capabilities, 1.3.5

heterogeneous database integration, 1.9.10

API (application program interface), Oracle Net, 9.3

APPC

concurrent connections, 3.1.2

configuring another profile, 10.9

database link behavior, 12.4

DB2/VM, 13.5.1.2

mode definition, 6.4.3.6

password length, 15.3

user ID length, 15.3

APPC VTAM Support (AVS)

also see AVS, 13.5.1.2

mapping user ID, 2.5.1

APPEND command

supported by COPY, 11.8

application

application program interface defined, see API, 9.3

authenticating logons, 13.2

development on the gateway, 1.9.16

portability, 1.9.13

server support, 1.3.3

architecture of the gateway, 1.5

array size

fetch reblocking, 1.9.3

how determined, 12.1.1

AS/400

command DSPRDBDIRE, 5.3.4

configuring communications, 5.3.1

defining user ID, 5.3.2

library name, DRDA_PACKAGE_COLLID, C.4.20

ASCII

code page, D.3

sort order, 12.6.2

tables, known restrictions, 1.9.21

translated from EBCDIC, 12.7.1

US7ASCII, D.3.2.1

US7ASCII, NLS, D.2

authority

CONNECT, 13.5.1.2

execute, 13.5.1.2

autonomy, site, 1.3.14

AVS

also see APPC VTAM Support, 2.5.1

configuring, 5.5.1

DB2/VM, 13.5.1.2

mapping user IDs (DB2/VM), 2.5.1

user ID mapping, 13.5.1.2

B

binary data, non-character, 12.7.1

Bind Package Stored Procedure

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

bind privilege

configuration worksheet, E

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

bind variables

native SQL passthrough, 12.8

restrictions, 2.5.2

BINDADD authority, binding packages on DB2/UDB, 10.4.5

BINDADD privilege

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

BINDAGENT privilege

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

binding the DRDA package

authority of user ID and password

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

backward compatibility, 14.4

configuring the host, 10.4.4

on DB2/UDB, 10.4.5

upgrading from version 3, 10.4.5

bug

bugs fixed in release 10.1.0.2.0, 2.3

debugging

drc values used by Oracle Support Services, 15.1.3

setting trace parameters, 15.4

SQL tracing reduces gateway performance, 11.10

number 205538, 2.5.2

C

call

a CICS or IMS transaction, 12.3.2

DB2 stored procedure

DRDA Server definition, 12.3

look up in server catalog, 12.3.1

DRDA_DISABLE_CALL

default, 10.5.1.1

sample Gateway Initialization File, B.1

empproc stored procedure, 12.3

Oracle Call Interface, 15.1

PL/SQL, 12.3.1

stored procedure

location transparency with synonym, 12.2

null values not passed, 2.5.1

using standard Oracle PL/SQL, 12.2

capabilities, DRDA server, native semantics, 12.6

CCSID

65535 as the default for all tables created, C.4.8

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

code page mapping facility, D.4

DRDA Server, NLS, D.1

external mapping to supported Oracle character sets, Codepage Map Facility, 1.9.19

changed parameters, 14.3.2

changes in this release

IBM DB2 Version 5.1 EBCDIC and ASCII Tables, 1.9.21

IBM DB2/UDB supported, 1.9.20

read-only support, 1.9.22

CHARACTER SET

clause, client/server configuration, D.2

parameter description, D.1

character sets

and code page map facility, D.4

ASCII, known restrictions, 1.9.21

codepage, DRDA_DEFAULT_CCSID specifies default CCSID, C.4.8

EBCDIC, known restrictions, 1.9.21

supported, codepage map facility, 1.9.19

character strings

converting character string data types, 12.7.2

performing character string operations, 12.7.1

checklist

DRDA Server configuration, 5.1

gateway configuration, 10.1

gateway installation, 4.3

Oracle Net, 9.1

CHECKSUM command

also see Advanced Security, 1.3.3

Oracle Net, Advanced Security Encryption, 9.5

CICS transaction, 12.3.2

clauses

CHARACTER SET, client/server configuration, D.2

CONNECT TO, 11.1.1

GROUP BY, 12.6.3

HAVING, 12.6.3

ORDER BY, 12.6.3

SQL

DELETE, 12.7.7

INSERT, 12.7.7

SELECT WHERE, 12.7.7

UPDATE, 12.7.7

TO_DATE, 12.7.7

USING, 11.1.1

VALUES, 12.7.7

WHERE

compatible for all versions of DRDA Server, 12.6.3

SQL limitations, Oracle ROWID column, 2.5.2

WHERE CURRENT OF CURSOR, ROWID column, 2.5.2

client, defined in gateway architecture, 1.5

code page map facility

for data translation, D.4

code tracing, C.4.41

codepage map facility

configuring support for character sets, 2.5.1

supported by gateway, 1.9.19

coercion of data, defined, 12.6

collection privilege - CREATE IN

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

collection privilege - CREATETAB, DB2/OS390, 5.2.2

column

date columns function, 12.7.7

Oracle ROWID, 2.5.2

supported in a result set, 1.9.8

commands

AGW ADD USERID, 13.5.1.2

AGW DELETE USERID, 13.5.1.2

CHECKSUM

advanced security, 1.3.3

supported by Oracle Net, 9.5

COPY

known restriction for INSERT, 2.5

SQL*Plus command, 11.8

CREATE DATABASE LINK, 5.5.2

EXECUTE, 1.3.9.1

EXPLAIN PLAN, 15.4.1

INSERT, known restriction, 2.5

commit confirm protocol, 1.3.13

Communication Database (CDB) tables, DDF, 5.2.5

communications requirements, 3.2.3

compatible SQL set operators and clauses, 12.6.3

concatenation restrictions, 2.5.1

concurrent connections

APPC, 3.1.2

TCP/IP, 3.1.2

configuring

additional DRDA Servers, 10.9

AS/400 communications, 5.3.1

AVS, 5.5.1

binding DRDA package, 10.5

checklist for gateway, 10.1

checklists for DRDA Server, 5.1

DB2/400, 5.3

DB2/OS390, 5.2

DB2/UDB, 5.4

list of parameters needed to configure the gateway, E

Oracle integrating server, 10.7

Oracle Net, 9.4

OS/390 (MVS) VTAM, 5.2.1

other Oracle servers, 10.8

SNA server, creating profiles, 6.3, 7.3

TCP/IP

for AS/400, 5.3.1

for DB2/VM, 5.5.1

for MS Windows, 8.2

for OS/390, 5.2.1

VM VTAM on DB2/VM, 5.5.1

workstation for gateway, 10.4

CONNECT authority

binding packages on DB2/UDB, 10.4.5

DB2/UDB, 5.4.2

user ID mapping on DB2/VM, 13.5.1.2

CONNECT BY not supported, known restrictions, 2.5.2

CONNECT TO clause, 11.1.1

connection

definition, 6.4.3.4

testing, 6.5, 7.5

conversion

data types, 12.7

errors, C.4.8

convert

character string data types, 12.7.2

character string operations, 12.7.1

DATE, 12.7.4.2

floating point to integer, 12.7.8

inbound user ID, 13.5.1.2

into most suitable data type, 12.7.10

to the numeric data type, 12.7.8

converter, protocol, 1.3.3

COPY

copying data from the DRDA server, 11.9

copying data from the Oracle server, 11.8

privilege

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

SQL*Plus COPY command

Oracle server to DRDA server, 11.8

substituted for INSERT, 2.5

COS function, 12.5.3

COUNT function, 12.7.9

CPI-C routine, 15.1.4

CPI-C Symbolic Destination Names, 6.4.3.8

CREATE command, supported by COPY, 11.8

CREATE DATABASE LINK

command, binding package on DB2/VM, 5.5.2

statement, defining path to remote database, 11.1.1

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

CREATE IN privilege

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CREATE PUBLIC DATABASE LINK privilege

binding the DRDA gateway package, 10.4.4

configuring Oracle integrating server, 10.7.1

CREATE TABLE statement, 1.3.8

CREATEIN privilege, DB2/UDB, 5.4.2

CREATETAB authority, 10.4.5

CREATETAB privilege

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

creating a database link, 11.1.1

cursor

defining the number of, 12.10

number of cursors, DRDA_PACKAGE_SECTIONS, C.4.24

stability, DRDA_ISOLATION_LEVEL, C.4.16

D

data coercion, defined, 12.6

data control language (DCL), 1.3.7

data definition language (DDL), 1.3.6

data dictionary

support, 10.5.2

using, 12.9.1

views

ALL_DB_LINKS, 11.1.4

considerations for migration from previous releases, 14.4

list and descriptions, A.2

not supported for DB2/VM, A.1

Oracle Emulation on DRDA Server, 12.9

supported for DB2/OS390, DB2/UDB, and DB2/400 servers, A.1

USER_DB_LINKS shows defined database links, 11.1.4

data storage transparency (introduction), 1.3.1

data type

column (ALL_TAB_COLUMNS), A.2.10

column (USER_TAB_COLUMNS), A.2.26

conversion

between Oracle and DRDA, 1.7

control over, 12.7.8

converting character string data types, 12.7.2

gateway mapping and restrictions, 12.7

performing character string operations, 12.7.1

date, 2.5.1

differences between Oracle server and DRDA databases, 12

DRDA Server data types list, 12.7

known restrictions, 2.5.1

mapping, 12.7

numeric

zoned decimal field, 12.7.10

Oracle data types RAW and LONG RAW, 12.7.1

performing character string operations, 12.7.1

restrictions, 12.7

size and value limitations, 12.7

supported by IBM DRDA, 12.7.4

supported by IBM DRDA databases, 12.7.4

data types

DATE, as calendar date only, 12.7.4

GRAPHIC, 12.7.3

LONG

converting character string data types, 12.7.2

known restrictions, 2.5.1

LONG RAW, translating ASCII to EBCDIC, 12.7.1

Oracle and IBM DATA data types are mapped to each other, 12.7.4.2

Oracle and IBM DATE, 12.7.4.2

processing TIME data types to Oracle DATE, 12.7.4.1

RAW

CCSID 65535, C.4.8

translating ASCII to EBCDIC, 12.7.1

TIME, time of day only, 12.7.4

TIMESTAMP, combining calendar data and time of day, 12.7.4

VARCHAR, 12.7.2

database

authorities - CONNECT, BINDADD, and CREATETAB, 5.4.2

catalogs, 12.9

link

behavior, 12.4

binding DRDA gateway package, 10.4.4

creating, 11.1.1

defining and controlling, 13.3

dropping links, 11.1.3

examining, 11.1.4

guidelines, 11.1.2

limits, 11.1.5

processing, 11.1

public, 10.7.1

suffix, 12.1

to identify the gateway, 1.7

native tool, 10.5.2

triggers, 1.3.2

date

2 or 4 digits, 12.7.5

arithmetic, known restrictions, 2.5.1

columns function, 12.7.7

data types and DRDA server restriction, 2.5.1

data types supported by IBM DRDA, 12.7.4

date handling has two categories, 12.7.5

gateway local date exit for DB2 ISO format, 12.7.6

HS_NLS_DATE_FORMAT

parameter, date handling, 12.7.5

patterns, 12.7.6

operations, 12.7.4

statements, SELECT, INSERT, UPDATE, DELETE, 12.7.5

TO_DATE function

date handling, 12.7.5

preprocessed in SQL, 12.7.7

DATE data type

implementation, 12.7.4

processing DATE data, 12.7.4.2

DB_DOMAIN parameter, 2.5.1

DB2

02pcg.sql granting authority, 10.5.2.5

alias objects, known restrictions, 2.5

aliases, not compatible with DRDA_DESCRIBE_TABLE, C.4.9

CICS, IMS, 12.3.2

data access, 1.3.9.1

Distributed Data Facility (DDF), 5.2.5

DRDA_DESCRIBE_TABLE compatibility, C.4.9

IBM DB2 version 5.1 ASCII Tables, 1.9.21

native SQL, 1.3.8

native stored procedures, 1.3.9.2

procedural feature considerations, 12.3.2

SPUFI utility, 5.2.5

SQL statements, 12.8.2

statements, CREATE TABLE, 1.3.8

stored procedures, considerations for use, 12.3.2

with OS/390, 5.2

DB2/400

catalog view, 12.9.1

configuring the DRDA Server, 5.3

data dictionary views supported by gateway, A.1

defining user ID, 5.3.2

DRDA_DEFAULT_CCSID, C.4.8

DRDA_ISOLATION_LEVEL, C.4.16

DRDA_OPTIMIZE_QUERY, C.4.19

DRDA_PACKAGE_COLLID, C.4.20

userid mapping, different capability, 13.5.1.3

DB2INS sample DB2 stored procedure, G.1

DB2/OS390

catalog view, 12.9.1

configuring, 5.2

data dictionary views supported by gateway, A.1

DRDA_ISOLATION_LEVEL, C.4.16

DRDA_OPTIMIZE_QUERY, C.4.19

userid mapping, 13.5.1.1

V6, V7 and V8 stored procedures supported, 1.9.18

with SPUFI, 10.5.2

DB2/UDB

catalog view, 12.9.1

configuring, 5.4

configuring the DRDA Server, 5.4

data dictionary views not supported, A.1

DRDA_ISOLATION_LEVEL, C.4.16

DRDA_OPTIMIZE_QUERY, C.4.19

grant authority, 10.5.2.5

known restrictions, 2.5.1

ORACLE2PC table, binding packages, 10.5.1.2

supported, changes in this release, 1.9.20

userid mapping, 13.5.1.4

DB2/VM

catalog view, 12.9.1

configuring, 5.5

data dictionary views not supported, A.1

database and SQL functions, 12.5.8

DRDA_ISOLATION_LEVEL, C.4.16

DRDA_OPTIMIZE_QUERY, C.4.19

DRDA_PACKAGE_OWNER, C.4.23

instance, DRDA location name, 5.5.4

server machine, 13.5.1.2

userid mapping, 13.5.1.2

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function

limited to nonqueries, 12.8

native SQL passthrough, 12.8

syntax, 12.8.2

DD basic tables, known restrictions, 2.5.1

DDF

subsystem, 5.2.1

DDL statement

native SQL passthrough, 12.8

number of rows affected, 12.8.2

debugging

error codes, 15.1.3

SQL tracing, 15.4

your application, 11.10

de-installing the gateway, 4.7.1

DELETE

known restrictions, 2.5.2

operation, 12.1

SQL clause, 12.7.7

statement

dates, 12.7.5

native SQL passthrough, 12.8

transaction semantics, 1.7.1

with read-only gateway, 11.6

Dependent LU, 6.3.1, 7.3.1

DESCRIBE

character string operations, 12.7.1

diagnostic parameter, C.4.39

dictionary

mapping, 1.3.4

tables, 12.9

DICTIONARY view, A.2.15

disk space requirements, 3.1.4

distributed

applications, support for, 1.9.15

database, 9.3.2

distributed query optimizer (DQO), better performance of distributed queries, 11.5

operations, DB2, 5.2.5

processing, 9.3.1

queries

example of, 11.5.1

two-phase commit, 11.5.2

transaction, DRDA_RECOVERY_USERID, C.4.27

distributed query optimizer (DQO), DRDA-specific parameters, C.4.19

double-byte support, D.5

DQO

also see distributed query optimizer, 11.5

DRDA-specific parameters, C.4.19

drc error code, 15.1.3

DRDA

catalog, 12.9.2

database requirements, 3.2.2

defining number of cursors, 12.10

location name

for DB2/UDB instance, 5.4.4

for DB2/VM instance, 5.5.4

session security options, 13.5.1.1

DRDA Application Server Function, 1.9.12

DRDA Server

accessing, 10.9

capabilities, native semantics, 12.6

CCSID

character set to store data in DRDA database, D.1

gateway code page map facility, D.4

parameters needed for NLS, D.1

character sets, known restrictions, 2.5.1

configuring

DB2/400, 5.3

DB2/OS390, 5.2

DB2/UDB, 5.4

DB2/VM, 5.5

considerations for binding packages, 14.4

database link behavior, 12.4

functions, native semantics, 12.6

gateway architecture definition, 1.5

Hostname or IP Address (configuring TCP/IP, worksheet), E

port number (TCP/IP), 8.1.1

Service Port Number (configuring TCP/IP, worksheet), E

stored procedures, native to DRDA server, 12.3

DRDA_CAPABILITY parameter, 12.6

DRDA_CMSRC_CM_IMMEDIATE parameter, description, C.4.7

DRDA_CODEPAGE_MAP parameter, D.4

DRDA_COMM_BUFLEN parameter, description, C.4.4

DRDA_CONNECT_PARM

(SNA format) parameter, description, C.4.5

(TCP/IP format) parameter, description, C.4.6

configuring IBM Communication Server, 7.4.1.2

configuring Microsoft SNA server or host server, 6.4.3.8

parameter

communication errors, 15.1.4

configuring the gateway for TCP/IP, 8.2

DRDA_DEFAULT_CCSID parameter, description, C.4.8

DRDA_DESCRIBE_TABLE parameter

description, C.4.9

known restrictions, 2.5

DRDA_DESCRIBE_TABLE=FALSE initialization parameter, 2.5

DRDA_DISABLE_CALL parameter

binding the DRDA gateway package, 10.5.1.1

description, C.4.10

DRDA_FLUSH_CACHE parameter, description, C.4.11

DRDA_GRAPHIC_LIT_CHECK parameter, description, C.4.13

DRDA_GRAPHIC_PAD_SIZE parameter, description, C.4.12

DRDA_GRAPHIC_TO_MBCS parameter, description, C.4.14

DRDA_ISOLATION_LEVEL parameter, description, C.4.16

DRDA_LOCAL_NODE_NAME parameter, description, C.4.17

DRDA_MBCS_TO_GRAPHIC parameter, description, C.4.18

DRDA_OPTIMIZE_QUERY parameter

description, C.4.19

DQO capability turned ON and OFF, 11.5

DRDA_PACKAGE_COLLID parameter

description, C.4.20

errors detected by server database, 15.1.5

DRDA_PACKAGE_CONSTOKEN parameter, description, C.4.21

DRDA_PACKAGE_NAME parameter

description, C.4.22

detecting errors, 15.1.5

value must be unique, 10.5.1.1

DRDA_PACKAGE_OWNER parameter, description, C.4.23

DRDA_PACKAGE_SECTIONS parameter

description, C.4.24

number of open cursors at IBM database, 12.10

DRDA_READ_ONLY parameter

description, C.4.25

read-only gateway, 11.6

DRDA_RECOVER_USERID parameter

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DRDA_RECOVERY_PASSWORD parameter

DB2/OS390, 5.2.3, 5.3.3

DB2/UDB, 5.4.3

DB2/VM, 5.5.3

description, C.4.26

DRDA_RECOVERY_USERID parameter

DB2/400, 5.3.3

DB2/UDB, 5.4.3

DB2/VM, 5.5.3

description, C.4.27

DRDA_REMOTE_DB_NAME parameter, description, C.4.28

DRDA_SECURITY_TYPE parameter, description, C.4.29

DROP DATABASE LINK statement, 11.1.3

dropold.sql script, 10.5.2.2

DSPRDBDIRE command, 5.3.4

dynamic dictionary mapping, 1.3.4

E

EBCDIC

character set support, D.3.2.1

code page, D.3

DRDA server CCSID, D.7

sort order, 12.6.2

tables, known restrictions, 1.9.21

translated to ASCII, 12.7.1

EMP

creating system-wide synonym for EMP file, 11.4

table, 11.8

empproc

stored procedure, 12.3

encryption

export encryption algorithms, 9.5

types for Advanced Security, 9.6

environment

distributed, 12.2

heterogeneous, replicating in, 11.7

variable, NLS_LANG, D.2

environmental variable

NLS_LANG, D.1

ORA_NLS33, D.1

errd

error array returned from DRDA server database, 15.1.5

example of translated, mapped error, 15.2

example, retrieving data, 11.2.3

errmc

(error tokens), 15.1.5

communication errors, 15.1.4

errmc field lists any error tokens, 15.1.3

example of translated, mapped error, 15.2

example, retrieving data, 11.2.3

error

12660 (test error for Advanced Security), 9.6

basic description, 15.1

change

ORA-09100 to ORA-28500, 15.1.3

ORA-09101 to ORA-28501, 15.1.3

codes

drc, 15.1.3

grc, 15.1.3

communication, 15.1.4

condition, 15.1

conversion, C.4.8

date, D.3.2.3

detected

by gateway, 15.1.2

by integrating Oracle instance, 15.1.1

by server database, 15.1.5

in DRDA software, 15.1.3

drc= field

-300xx, 15.3

-7xx, 15.3

HGO-00706, 15.1.2

host database, 15.3

interpreting error messages, 15.1

mapped sqlstate, 15.2

messages & codes, main chapter, 15

messages, Oracle LONG data type larger than 32740 bytes, 12.7.2

number, return code, 15.1

ORA-00001, index constraint violated, 15.2

ORA-00942

object does not exist, 15.2

object name too long, 15.2

ORA-01017, logon denied, 15.2

ORA-01031, insufficient privileges, 15.2

ORA-01460, invalid CCSID, 15.2

ORA-01476, divide by zero, 15.2

ORA-02019, undefined database link name is specified, 15.1.1

ORA-28500

was ORA-09100, 15.1.3

detected by server database, 15.1.5

example, collection ID or package name not recognized, 15.1.5

ORA-28501

was ORA-09101, 15.1.4

communication error, 15.1.4

Side Information Profile not defined, 15.1.4

ORA-28527, conversion errors, C.4.8

ORA-9100 to ORA-9199, reserved for generic gateway layer, 15.1.1

Oracle error code for mapped errors, 15.2

server database, 15.1.5

specific error codes, 15.3

tokens listed by errmc for errors

detected by DRDA gateway, 15.1.3

detected by server database, 15.1.5

translation, 12.7.1

while binding the gateway package, 10.4.4

with Native Semantics, 12.6

errp

example, retrieving data, 11.2.3, 15.1.3, 15.1.5, 15.2

EXCEPT set operator, 12.6.3

execute authority

DB2/400, 13.5.1.3

DB2/UDB, 13.5.1.4

DB2/VM, 13.5.1.2

on the gateway DRDA package, 13.5.1.2

EXECUTE command, 1.3.9.1

EXECUTE privilege

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

exits, gateway local date, 12.7.6

EXPLAIN PLAN command, 15.4.1

EXPLAIN_PLAN table, features of the gateway, 1.9.9

export encryption algorithms, 9.5

F

FDS_CLASS parameter, description, C.4.30

FDS_CLASS_VERSION parameter, description, C.4.31

FDS_INSTANCE parameter, description, C.4.32

features of the gateway

main topic, 1.9

application development and end-user tools, 1.9.16

application portability, 1.9.13

columns supported in a result set, 1.9.8

distributed applications supported, 1.9.15

EXPLAIN_PLAN improvement, 1.9.9

fetch reblocking, 1.9.3

heterogeneous database integration, 1.9.10

heterogeneous services architecture, 1.9.1

large base of data access, 1.9.12

minimum impact on existing systems, 1.9.11

Native Semantics, 1.9.7

Oracle Database 10g passthrough supported, 1.9.4

Oracle snapshot, 11.7.2

performance enhancements, 1.9.2

remote data access, 1.9.14

retrieving result sets through passthrough, 1.9.5

support for TCP/IP, 1.9.6

fetch array size, with HS_FDS_FETCH_ROWS, C.4.33

fetch reblocking

features of the gateway, 1.9.3

supported with HS_RPC_RETCH_REBLOCKING, 12.1.1

fetched date, ORA_MAX_DATE parameter, description, C.4.37

fields

errmc, lists any error tokens, 15.1.3

errp, indicates program that detected error, 15.1.3

files

initsid.ora

invalid ORA_MAX_DATE specified, 15.3

parameter not recognized, 15.1.5

installation log file, verifying successful installation, 4.6.5

listener.ora

configure additional instance, 10.9

IPC key defined in, 9.4.2

member name, 11.3

sample

gateway initialization, tnsnames.ora, listener.ora, B

listener.ora, B.3

tnsnames.ora

configuring additional DRDA Server instance, 10.9

modifying the file, 9.4.2

VSAM, 12.3.2

FOR BIT DATA

DRDA_DEFAULT_CCSID, C.4.8

indicates RAW or LONG RAW, 12.7.1

option, 12.7.1

free session, DRDA_CMSRC_CM_IMMEDIATE, C.4.7

functions

COS, 12.5.3

COUNT, 12.7.9

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 12.8.2

DRDA server, native semantics, 12.6

GROUPBY, 12.6.2

HAVING, 12.6.2

ROWID, with UPDATE or DELETE, 2.5.2

SQL, SUBSTR, 12.6

SUBSTR

known restrictions, 2.5.1

TO_DATE

entering twenty-first century dates, 12.7.5

Oracle function, preprocessed in SQL, 12.7.7

processing DATE data, 12.7.4.2

WHERE, 12.6.2

G

g4ddtab.sql script, 10.5.2.3

g4ddview.sql script, 10.5.2.3

gateway

access, 10.8

advantages

migration and coexistence, 1.3.15

security, 1.3.16

server technology and tools, 1.3.11

site autonomy, 1.3.14

two-phase commit and multi-site transactions, 1.3.13

use of SQL, 1.2.1

application tools, 1.9.16

architecture, 1.5

benefits of integration with Oracle Database 10g server, 1.3.3

configuration, 10.3

definition of terms, 1.4

de-installing, 4.7.1

features, main topic, 1.9

gateway and Oracle integrating server not on same host, 1.5

installing, 4.6

interface function, 1.7

local date exit, 12.7.6

logging, LOG_DESTINATION, C.4.36

migration problems, backout considerations, 14.2

parameter, 5.5.4

performance, 12.6

performance enhancements, 1.9.2

service name entries in the tnsnames.ora, 14.5

SQL differences, 1.7.1

stored procedures (Oracle and non-Oracle), 1.3.9

supported languages

CCSID, D.1

codepage map facility, D.4

tracing

LOG_DESTINATION, C.4.36

SQL statements, 11.10

Gateway Initialization File

parameter

list, C.4

new since V4 gateway, 14.3.1.1

reported errors, 10.4.4

sample, B.1

Gateway Initialization Parameter, DRDA_READ_ONLY, 11.6

Gateway System Identifier (SID), defined, 10.2

GCS virtual machine, 13.5.1.2

GLOBAL_NAMES

known restrictions, 2.5.1

GRANT

DB2/VM security, 13.5.1.2

statement, synonyms and views, 10.7.2

granting authority to a package for DB2, 10.5.2.5

GRAPHIC data type, 12.7.3

graphic string operations, unsupported, 12.7.3

grc error code, 15.1.3

GROUP BY clause, 12.6.3

GROUPBY function, 12.6.2

GTW$_BIND_PKG

configuring the host, 10.4.4

gateway package considerations, 10.5

H

hardware requirements, memory, 3.1.2

HAVING

clause compatible for all versions of DRDA Server, 12.6.3

SQL Functions That Can Be Disabled, 12.6.2

heterogeneous database integration, 1.9.10

Heterogeneous Services (HS)

I

IBM Communication Server

definitions, 7.4.1

server selection, 7.4.1.1

implementation, gateway components, 1.6

implicit data conversion, 12.6

implicit protocol conversion, 1.3.3

IMS transaction, 12.3.2

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

inbound connections

processing, 13.5

Independent LU

configuring IBM Communication Server, 7.3.1

configuring Microsoft SNA Server, 6.3.1

initdrdahoa1.ora

sample Gateway Initialization File, B.1

initialization parameters

new since V4 gateway, 14.3.1.1

initsid.gtw file

sample, 10.4.1

initsid.gtwboot

file, migrating, 14.1.2

parameters moved to initsid.ora, 10.4

initsid.ora file

containing initsid.gwtboot parameters, 10.4

invalid ORA_MAX_DATE specified, 15.3

migrating, 14.1.2

NLS parameters, D.3.2

parameter not recognized, 15.1.5

parameters have changed format, 14.1.3

sample, 10.4.1

simplified syntax, see Appendix C, 10.4

tailoring, 10.4.2.1

input bind variables, 12.7.4.2

INSERT

command

known restriction, 2.5

supported by COPY, 11.8

operation, 12.1

Oracle SQL command, known restrictions, 2.5

SQL clause, 12.7.7

statement

dates, 12.7.5

native SQL passthrough, 12.8

transaction semantics, 1.7.1

with read-only gateway, 11.6

installation

checklists

configuring the gateway, 10.1

DRDA Server, 5.1

gateway, 4.3

Oracle Net, 9.1

configuring multiple DRDA Servers

details, 10.9

overview, 4.4

configuring multiple integrating servers

details, 10.8

overview, 4.4

from CD, 4.6

log file, INSTALL.LOG, 4.6.5

overview, 4.4

INSTALL.LOG, 4.6.5

internal tracing, C.4.40

Internet and intranet support, 1.3.3

INTERSECT, set operators, 12.6.3

IPC adapter, B.3

ISO standard

SQL, 1.3.5

isolation level, DRDA_ISOLATION_LEVEL, C.4.16

J

JOIN capability, 1.3.2

JOIN SQL statement, 12.1

K

keywords

LISTENER, sample listener.ora file, B.3

known restrictions

main topic, 2.5

accessing DB2 alias objects, 2.5

AVS mapping user IDs, 2.5.1

bind variables become SQL parameter markers, 2.5.2

binding the DRDA gateway package on DB2/UDB, 2.5.1

CONNECT BY not supported, 2.5.2

data type limitations, 2.5.1

date arithmetic, 2.5.1

DD basic tables and views, 2.5.1

dictionary views not provided for DB2/VM, 2.5.1

DRDA server character sets, 2.5.1

GLOBAL_NAMES parameter, 2.5.1

LONG data type in SQL*Plus, 2.5.1

null values and stored procedures, 2.5.1

Oracle ROWID column, 2.5.2

row length, 2.5.1

row length limitation, 2.5.1

SAVEPOINT, 2.5.1

single gateway instances per DRDA network interface, 2.5.1

string concatenation, 2.5.1

SUBSTR function post-processed, 2.5.1

L

LANGUAGE parameter, D.3.2.1

languages

SQL*Plus, 1.3.12

tools supported through the gateway, 1.3.10

link

also see Database Link, 12.4

service definition, 6.4.3.3

linkage conventions

SIMPLE with nulls, 12.3.2

listener

sample Oracle Net listener.ora file, B.3

LISTENER keyword, sample listener.ora file, B.3

listener.ora file

configuring additional DRDA Server instances, 10.9

IPC key defined, 9.4.2

sample, B.3

literal

character literals, 12.7.4.1

date, 12.7.4.2

specific data type, 12.7

TO_DATE, 12.7.7

Local LU definition, 6.4.3.5

location transparency (introduction), 1.3.1

log file, installation, verifying success, 4.6.5

LOG_DESTINATION parameter

description, C.4.36

used with ORACLE_DRDA_TRACE, C.4.40

logging, LOG_DESTINATION, C.4.36

LONG columns, known restrictions, 2.5.1

LONG data type

converting character string data types, 12.7.2

known restrictions, 2.5.1

LONG RAW datat ype, translating ASCII to EBCDIC, 12.7.1

LUs

dependent, 7.3.1

independent, 7.3.1

independent and dependent, 6.3.1

local definition, alias, network name, 6.4.3.5

remote definition, 6.4.3.7

M

mapped sqlstate errors, 15.2

mapping user IDs, known restrictions, 2.5.1

memory, hardware requirements, 3.1.2

Microsoft Windows Sockets, network attachment, 3.1.3

migration

defined, 14.1

migrating the gateway instance, 14.4

obsolete parameters, 14.3.4

problems, backout considerations, 14.2

MINUS

set operator, 12.6.3

Mobile Agents, 1.3.3

Mode definition, 6.4.3.6

multi-byte support, D.5

N

National Language Support

initsid.ora parameters, D.3.2

overview, D

Native Semantics

main topic, 12.6

gateway features, 1.9.7

parameters, 12.6.3

with SUBSTR function, 2.5.1

native SQL passthrough, 12.8

network

configuration tool, 8.2

Oracle Net configuration, 9.4

requirements, 3.1.3

transparency (introduction), 1.3.1

NLS

also see National Language Support, D

DRDA server character sets

codepage map facility, D.4

parameters needed for NLS processing, D.1

NLS parameters, configuration on client and Oracle servers, D.2

NLS_LANG

environment variable

client-server configuration, D.2

parameters needed for NLS processing, D.1

server-side parameter, D.1

non-character binary data, 12.7.1

null

rows, mapping the COUNT function, 12.7.9

values

known restrictions, 2.5.1

mapping the COUNT function, 12.7.9

number of cursors, DRDA_PACKAGE_SECTIONS, C.4.24

numbers, concatenation restrictions, 2.5.1

numeric data type

conversion, destination column, 12.7.8

zoned decimal operations, 12.7.10

O

o2pc.sql

binding the DRDA gateway package, 10.5.2.6

two-phase commit processing, 11.5.2

obsolete parameters since V4 gateway, 14.3.4

open cursors, at the IBM database, 12.10

OPEN_LINKS parameter, 11.1.5

operating system requirements, 3.2.1

operating system transparency (introduction), 1.3.1

operations, SELECT, INSERT, UPDATE, DELETE, 12.1

operators

UNION, 12.6.3

UNION ALL, 12.6.3

option

binding packages, 10.4.5

data dictionary views, 12.9

date format string, 12.7.5

DRDA session security, 13.5.1.1

FOR BIT DATA, 12.7.1

Oracle server, 1.5

read-only

gateway configuration, 1.3.13

no updates permited by gateway, 11.6

replicating, 11.7

security conduct, 13.5

service port number, DRDA_CONNECT_PARM, C.4.6

SNA security

configuring IBM Communication Server, 7.7

configuring Microsoft SNA Server or Host Integration Server, 6.7

SQL functions that can be disabled, 12.6.2

SQL functions that can be enabled, 12.6.1

SQL*Plus COPY command, 11.8

ora

listener.ora file, 10.9

tnsnames.ora file, 9.4.2

ORA_MAX_DATE parameter, description, C.4.37

ORA_NLS33 parameter

description (default value), C.4.38

needed in system environment, D.1

ORA-00001 error, index constraint violated, 15.2

ORA-00942 error

object does not exist, 15.2

object name too long, 15.2

ORA-01017 error, logon denied, 15.2

ORA-01031 error, insufficient privileges, 15.2

ORA-01460 error, invalid CCSID, 15.2

ORA-01476 error, divide by zero, 15.2

ORA-02019 error, undefined database link name is specified, 15.1.1

ORA1 Oracle instance, 12.2

ORA-28500 error

was ORA-09100, 15.1.3

example, collection ID or package name not recognized, 15.1.5

ORA-28501 error

was ORA-09101, 15.1.3

communication error, 15.1.4

Side Information Profile not defined, 15.1.4

ORA-28527, conversion errors, C.4.8

ORA-9100 error, 15.1.1

ORA-9199 error, 15.1.1

Oracle

error code, mapped errors, 15.2

error number or return code, 15.1

products compatibility, 1.8

RAW data type, C.4.8

snapshots, 11.7.2

stored procedure, defined, 12.2

Oracle Database 10g server

introduction, 1.2

relationship to host, 1.5

services

list, 1.3.2

database triggers, 1.3.2

distributed capabilities, 1.3.2

distributed query optimization, 1.3.2

SQL, 1.3.2

stored procedures, 1.3.2

two-phase commit protection, 1.3.2

Oracle integrating server

architecture, 1.5

configuration, 10.7

defined in gateway architecture, 1.5

gateway and Oracle integrating server not on same host, 1.5

requirements, 3.2.4

Oracle Net

and application development, 1.9.16

and remote data access, 1.9.14

and server coexistence, 1.5

API, 9.3

compatibility with SQL*Net, 9.2

configuring, 9.4

distributed

database, 9.3.2

processing, 9.3.1

editing to set up security test, 9.6.1

gateway and Oracle integrating server not on same host, 1.5

gateway migration problems, 14.2

Heterogeneous Services (HS) facility, 9.2

introduction, 9.2

migration considerations, 14.5

operating system authentication, 13.2

overview, 9.3

purpose, 1.6

requirements, 3.2.5

sample files, B

sample listener.ora file, B.3

support (introduction), 1.3.11

support for CHECKSUM and encryption, 9.5

terminology, 9.3.3

Oracle ROWID column, 2.5.2

Oracle ROWID function, with UPDATE or DELETE, 2.5.2

ORACLE_DRDA_TCTL parameter, description, C.4.39

ORACLE_DRDA_TRACE parameter, description, C.4.40

ORACLE_HOME, preinstallation and caution notice, 4.5

ORACLE2PC table

before binding gateway package, 10.5.1.2

binding packages on DB2/UDB, 10.4.5

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/UDB, granting authority to package, 10.5.2.5

DB2/VM, 5.5.2

distributed DRDA transactions, 11.5.3

DRDA_PACKAGE_OWNER description, C.4.23

ORADRDA.ORACLE2PC table, two-phase commit, 11.5.2

ORAIND sample DB2 stored procedure, G.2

oraproc1, stored procedure, 12.2

oraproc2, stored procedure, 12.2

ORARECOV user ID

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/UDB, 5.4.3

DB2/VM, 5.5.3

DRDA_RECOVERY_USERID description, C.4.27

ORA2 Oracle instance, 12.2

ORDER BY clause, 12.6.3

OS/390 (MVS) VTAM, configuring, 5.2.1

P

package

collection id, DRDA_PACKAGE_COLLID, C.4.20

consistency token, DRDA_PACKAGE_CONSTOKEN, C.4.21

privileges - BIND and EXECUTE, DB2/UDB, 5.4.2

privileges - BIND, COPY, and EXECUTE

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

packed decimal, 12.7.10

parameter

changed, 14.3.2

checking settings, 10.5.1.1

diagnostic, C.4.39

gateway, 5.5.4

list of parameters needed to configure the gateway, E

Native Semantics, 12.6.3

new since V4 gateway, 14.3.1.1

obsolete since V4 gateway, 14.3.4

parameter syntax and usage, C.3

renamed since V4 gateway, 14.3.3

parameters

DB_DOMAIN, 2.5.1

DRDA_CAPABILITY, 12.6

DRDA_CODEPAGE_MAP

described, C.4.3

mapping IBM CCSID, D.4

DRDA_CONNECT_PARM

configuring IBM Communication Server, 7.4.1.2

configuring Microsoft SNA server or host server, 6.4.3.8

configuring the gateway for TCP/IP, 8.2

DRDA_DESCRIBE_TABLE, known restrictions, 2.5

DRDA_DISABLE_CALL, 10.5.1.1

DRDA_PACKAGE_NAME, 10.5.1.1

DRDA_PACKAGE_SECTIONS, open cursors, 12.10

DRDA_READ_ONLY, read-only gateway, 11.6

DRDA_RECOVERY_PASSWORD

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/UDB, 5.4.3

DB2/VM, 5.5.3

DRDA_RECOVERY_USERID

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/UDB, 5.4.3

DB2/VM, 5.5.3

FDS_CLASS, description, C.4.30

FDS_CLASS_VERSION, description, C.4.31

FDS_INSTANCE, description, C.4.32

Gateway Initialization File

DRDA_CACHE_TABLE_DESC, C.4.1

DRDA_CAPABILITY, C.4.2

DRDA_CMSRC_CM_IMMEDIATE, C.4.7

DRDA_CODEPAGE_MAP, C.4.3

DRDA_COMM_BUFLEN, C.4.4

DRDA_CONNECT_PARM, 8.2, 15.1.4

DRDA_CONNECT_PARM (SNA format), C.4.5

DRDA_CONNECT_PARM (TCP/IP format), C.4.6

DRDA_DEFAULT_CCSID, C.4.8

DRDA_DESCRIBE_TABLE, C.4.9

DRDA_DISABLE_CALL, C.4.10

DRDA_FLUSH_CACHE, C.4.11

DRDA_GRAPHIC_LIT_CHECK, C.4.13

DRDA_GRAPHIC_PAD_SIZE, C.4.12

DRDA_GRAPHIC_TO_MBCS, C.4.14

DRDA_ISOLATION_LEVEL, C.4.16

DRDA_LOCAL_NODE_NAME, C.4.17

DRDA_MBCS_TO_GRAPHIC, C.4.18

DRDA_OPTIMIZE_QUERY, 11.5, C.4.19

DRDA_PACKAGE_COLLID, 15.1.5, C.4.20

DRDA_PACKAGE_CONSTOKEN, C.4.21

DRDA_PACKAGE_NAME, 15.1.5, C.4.22

DRDA_PACKAGE_OWNER, C.4.23

DRDA_PACKAGE_SECTIONS, C.4.24

DRDA_READ_ONLY, C.4.25

DRDA_RECOVERY_PASSWORD, C.4.26

DRDA_RECOVERY_USERID, C.4.27

DRDA_REMOTE_DB_NAME, C.4.28

DRDA_SECURITY_TYPE, C.4.29

HS_FDS_FETCH_ROWS, C.4.33

HS_LANGUAGE, C.4.34

HS_NLS_NCHAR, C.4.35

LOG_DESTINATION, C.4.36

ORA_MAX_DATE, C.4.37

ORA_NLS33, C.4.38

ORACLE_DRDA_TCTL, C.4.39, C.4.39

ORACLE_DRDA_TRACE, C.4.40

TRACE_LEVEL, C.4.41

HS_DB_DOMAIN, 2.5.1

HS_DB_NAME, 2.5.1

HS_NLS_DATE_FORMAT, 12.7.5

HS_RPC_FETCH_REBLOCKING

gateway features, 1.9.3

gateway support for fetch reblocking, 12.1.1

HS_RPC_FETCH_SIZE

gateway features, 1.9.3

gateway support for fetch reblocking, 12.1.1

LOG_DESTINATION, description, C.4.40

NLS_DATE_FORMAT, 12.7.5

OPEN_LINKS, 11.1.5

passthrough

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE

gateway features, 1.9.4

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE syntax

using the passthrough function, 12.8.2

example, 12.8.3.1

gateway feature, 1.3.8

native SQL through the gateway, 12.8

result sets example, 12.8.3.1

result sets from queries, 12.8

retrieving result sets, 12.8.3

SQL feature, 12.8

performance enhancements with fetch reblocking, 12.1.1

PL/SQL

call, 12.3.1

records, 12.3.2

routine, 1.3.9.1

running stored procedures, 12.3

standard Oracle, 1.3.9.2

stored procedure, 12.2

port number

446 as default for DRDA services (TCP/IP), 8.1.1

5000 as default for DRDA services (TCP/IP), 8.1.1

for DRDA Server (TCP/IP), 8.1.1

Primary

DB2/400, 5.3.1

DB2/OS390, 5.2.1

Recovery

DB2/400, 5.3.1

DB2/OS390, 5.2.1

post processing

defined, 12.5.3

native semantics, 12.6

post-processed SQL functions, overview, 12.5.3

SQL tracing, 15.4.1

PREPARE TRANSACTION statement, two-phase commit, 11.5.2

primary port number

DB2/400, 5.3.1

DB2/OS390, 5.2.1

privileges

BIND

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

BINDADD

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

BINDAGENT

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CONNECT

DB2/UDB, 5.4.2

COPY

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CREATE IN

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

CREATE PUBLIC DATABASE LINK

binding the DRDA gateway package, 10.4.4

configuring the Oracle integrating server, 10.7.1

CREATEIN

DB2/UDB, 5.4.2

CREATETAB

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

data dictionary limitations, 12.9

EXECUTE

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

procedure

stored procedures

REVISE_SALARY, example, 12.3.1

using DRDA server, 12.3

with read-only gateway, 11.6

procedures

DB2

DB2INS, sample, G.1

ORAIND, sample, G.2

processing time, with GROUPBY, HAVING, WHERE, 12.6.2

processor requirements, 3.1.1

profile set, APPC, configuring, 10.9

protocol

commit confirm, 1.3.13

communications and DRDA-specific parameters, 8.2

communications protocols with Oracle Net, 9.3

converter, 1.3.3

definition, 9.3.3

implicit protocol conversion, 1.3.3

network, 11.4

Oracle Net Protocol Adapters, 9.2

protocol-independent encryption, 1.3.3

two-phase commit, 11.5.2

protocols

IPC, 9.4.2

SNA, for the DRDA server, 1.5

TCP/IP

for the DRDA server, 1.5

how supported, 1.9.6

implicit protocol conversion, 1.3.3

public database link, 10.7.1

Q

queries, distributed, 11.5

R

RAW data type

DRDA_DEFAULT_CCSID description, C.4.8

translating ASCII to EBCDIC, 12.7.1

read-only gateway

main topic, 11.6

option, DRDA_READ_ONLY, C.4.25

read-only support, changes in this release, 1.9.22

rebind

DRDA_DISABLE_CALL, C.4.10

DRDA_ISOLATION_LEVEL, C.4.16

DRDA_PACKAGE_COLLID, C.4.20

DRDA_PACKAGE_CONSTOKEN, C.4.21

DRDA_PACKAGE_NAME, C.4.22

DRDA_PACKAGE_OWNER, C.4.23

DRDA_PACKAGE_SECTIONS, C.4.24

recovery port number

DB2/400, 5.3.1

DB2/OS390, 5.2.1

recovery user ID and password

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/UDB, 5.4.3

DB2/VM, 5.5.3

remote

computer, 9.3.1

connections, 11.1.5

data, 1.3.2

data access, 1.9.14

database

configuration worksheet, E

copy data from Oracle Database server to DRDA Server database, 11.8

creating database links, 11.1.1

DB2/400, 5.3.3

DB2/OS390, 5.2.3

DB2/UDB, 5.4.3

DB2/VM, 5.5.3

defining a path, 11.1.1

DRDA gateway package considerations, 10.5

DRDA_PACKAGE_SECTIONS, C.4.24

example error message, 15.1.1

gateway error codes, 30061, RDB not found, 15.3

DB2 system, 2.5

DRDA database, DRDA_ISOLATION_LEVEL, C.4.16

instance, 12.2

LU definition, 6.4.3.7

objects, 13.3.1

Oracle instance

running a DB2 stored procedure, 12.3

synonym for calling a stored procedure, 12.2

Oracle servers, 9.3.2

procedure, 1.3.9.2

table, 1.3.4

transaction program, 3.1.2

userid and password, 11.1.1

renamed parameters, 14.3.3

REPLACE

command, supported by COPY, 11.8

replication in heterogeneous environment, 11.7

requirements

hardware, 3.1

software, 3.2

restrictions, 2.5

RESULT, 12.3.1

result sets

columns in, 1.9.8

features of the gateway, 1.9.5

return code, error, 15.1

REVISE_SALARY

stored procedure example, 12.3.1

row length

known restrictions, 2.5.1

ROWID

known restrictions, 2.5.2

Oracle column, 2.5.2

with UPDATE or DELETE, 2.5.2

S

sample

files

gateway initialization, tnsnames.ora, listener.ora, B

initsid.gtw, 10.4.1

initsid.ora, 10.4.1

Gateway Initialization File, initdrdahoa1.ora, B.1

listener.ora file, B.3

SQL scripts, 10.5.2

SAVEPOINT, known restrictions, 2.5.1

schema privileges - CREATEIN, 5.4.2

scripts

dropold.sql, 10.5.2.2

g4ddtab, 10.5.2.3

g4ddview.sql, 10.5.2.3

security

Advanced Security, 1.3.3

DRDA_SECURITY_TYPE, C.4.29

encryption, 9.5

overview, 13.1

site autonomy, 1.3.14

validation for SNA, 6.6, 7.6

validation for TCP/IP, 13.4

SELECT

and array size, 1.9.3

operation, 12.1

SQL statement, 12.8.3

statement

compensated SQL functions, 12.5.3

dates, 12.7.5

fetch reblocking, 12.1.1

retrieve results sets, 12.8.3

with read-only gateway, 11.6

SELECT WHERE SQL clause, 12.7.7

semantics, 12.6

server selection, 6.4.3.1, 7.4.1.1

service port number, DRDA_CONNECT_PARM, C.4.6

session, connection, 12.4

set operators

compatibility, 12.6.3

EXCEPT, 12.6.3

INTERSECT, 12.6.3

MINUS, 12.6.3

SQL set operators and clauses, 12.6.3

shift attribute, multi-byte support, D.5

SID

choosing a gateway SID, 10.2

configuring additional DRDA server instances, 10.9

Gateway System Identifier, defined, 10.2

Side Information Profile

communication error, 15.1.4

definition, 6.3, 7.3

SIMPLE linkage convention

DB2INS, sample DB2 stored procedure, G.1

of DB2 stored procedures, 12.3.2

site autonomy, 1.3.14

SNA, 5.4.1

configuring

AS/400 communications, 5.3.1

OS/390 communications, 5.2.1

VM communications, 5.5.1

conversation security, 6.7, 7.7

CPI-C error, 15.1.4

facilities, 1.9.11

functions, 1.6

LU, 13.5.1.1

protocol

DRDA server support, 1.5

remote access, 1.9.14

security validation

IBM Communication Server, 7.6

Microsoft SNA Server or Host Integration Server, 6.6

versus TCP/IP security, 13.4

security, DRDA_SECURITY_TYPE, C.4.29

SECURITY=PROGRAM, 6.7.1, 7.7.1

SECURITY=SAME, 6.7.2, 7.7.2

send/receive buffer, C.4.4

session allocation mode, DRDA_CMSRC_CM_IMMEDIATE, C.4.7

SNA Server

connection definition, 6.4.3.4

CPI-C symbolic destination names, 6.4.3.8

definitions

creating side information profiles, 7.3

creating SNA definitions for SNA Server version 3, 6.4.3

side information profiles, 6.3

for Windows NT, 6.3.1

link service definition, 6.4.3.3

local LU definition, 6.4.3.5

mode definition, 6.4.3.6

remote LU definition, 6.4.3.7

server selection, 6.4.3.1

testing the connection, 6.5

SNA Server for Windows NT

dependent LUs, 7.3.1

independent LUs, 7.3.1

testing the connection, 7.5

SNACFG command, 6.4.1

snacfg.ctl file, 6.4.1, 7.3.2.1

snapshots

known restrictions, 2.5.2

Oracle snapshot feature, 11.7.2

software requirements, 3.2

sort order

with ORDERBY, 12.6.2

SPUFI on DB2/OS390, 10.5.2

SQL

main topic, 1.3.5

ANSI standard, 1.3.5

clause compatibility, 12.6.3

clauses

DELETE, 12.7.7

INSERT, 12.7.7

SELECT WHERE, 12.7.7

UPDATE, 12.7.7

constructs, Oracle processing, 12.5

differences in the gateway, 1.7.1

functions

and Native Semantics, 12.6

quick reference list, F

SUBSTR, 12.6

ISO standard, 1.3.5

native DB2, 1.3.8

passthrough

described, 12.8

retrieving results sets example, 12.8.3.1

using DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 12.8.2

statements

DB2, 12.8.2

DRDA_ISOLATION_LEVEL, C.4.16

passing through gateway, 12.8

run through the gateway, 11.10

using JOIN, 12.1

syntax, 12.7.9

tracing

improving performance, 11.10

tracing errors in the Oracle Database, 15.4.1

SQL functions

column functions, 12.5.1

compatible, defined, 12.5.1

compensated, defined, 12.5.3

DB2/400, 12.5.7

DB2/OS390, 12.5.5

DB2/UDB, 12.5.6

DB2/VM, 12.5.8

that can be disabled, 12.6.2

that can be enabled, 12.6.1

translated

defined, 12.5.2

with Native Semantics, 12.6.1

SQL set operators and clauses, 12.6.3

SQL*Net

Heterogeneous Services (HS) facility, 9.2

replaced by Oracle Net, 9.2

SQL*Plus

connecting gateway to Oracle integrating server, 9.7.1

copying data from Oracle server to DRDA Server, 11.8

extending gateway uses, 1.8.1

introduction, 1.3.12

sqlstate, mapped sqlstate errors, 15.2

stability, of cursor, DRDA_ISOLATION_LEVEL, C.4.16

Startup Shell Script

migration, 14.1.2

statements

CREATE DATABASE LINK, 11.1.1

CREATE DATABASE, client/server configuration, D.2

DB2 CREATE TABLE, 1.3.8

DDL

nonqueries supported by gateway passthrough, 12.8

number of rows affected by passthrough, 12.8.2

DELETE

and TO_DATE function, 12.7.5

nonqueries supported by gateway passthrough, 12.8

DROP DATABASE LINK, 11.1.3

GRANT, 10.7.2

INSERT

and TO_DATE function, 12.7.5

nonqueries supported by gateway passthrough, 12.8

passing SQL through gateway, 12.8

PREPARE TRANSACTION, two-phase commit, 11.5.2

SELECT

and TO_DATE function, 12.7.5

compensated SQL functions, 12.5.3

fetch reblocking, array size, 12.1.1

retrieve results sets, 12.8.3

with read-only gateway, 11.6

SQL

DB2, 12.8.2

JOIN, 12.1

SELECT, 12.8.3

UPDATE

and TO_DATE function, 12.7.5

nonqueries supported by gateway passthrough, 12.8

stored procedure

creating on DB2, 12.3.1

DB2

considerations for use, 12.3.2

native to DRDA server, 12.3

with read-only gateway, 11.6

DB2INS, sample, G.1

extended database services, 1.3.2

GTW$_BIND_PKG, 10.4.4

native DB2, 1.3.9.2

Oracle and non-Oracle, 1.3.9

Oracle Database 10g server

using, 12.2

Oracle database server

local instance, 12.2

PL/SQL, 12.2

remote instance, 12.2

Oracle, description, 1.3.9.1

ORAIND, sample, G.2

restriction, 2.5.1

REVISE_SALARY, example, 12.3.1

usage, C.4.10

using DRDA server, 12.3

string concatenation, known restrictions, 2.5.1

string index, with Native Semantics, 12.6

Structured Query Language, also see SQL, 1.2.1

SUBSTR

SQL function

known restrictions, 2.5.1

Oracle implementation permits negative values, 12.6

with Native Semantics, 2.5.1

synonym

feature, 11.4

for location transparency, 12.2

how the gateway works, 1.7

system privileges - BINDADD and BINDAGENT

configuration worksheet, E

DB2/OS390, 5.2.2

DB2/VM, 5.5.2

T

table

create a table in DB2, 12.8.2.1

insert a row into a DB2 table, 12.8.2.1

TABLE_PRIVILEGES view, A.2.17

tables

ORACLE2PC, 10.5.1.2, 10.5.2.5

ORACLE2PC, distributed transactions, 11.5.3

ORADRDA.ORACLE2PC, two-phase commit, 11.5.2

tailoring

initsid.ora file, 10.4.2

TCP/IP

affecting memory requirements, 3.1.2

concurrent connections, 3.1.2

configuration chapter, 8

configuration worksheet, E

configuring

for AS/400, 5.3.1

for OS/390, 5.2.1

for VM, 5.5.1

to use DNS, 8.2

using DRDA_CONNECT_PARM parameter, 8.2

database link behavior, 12.4

default port number, 9.4.2

DRDA_CONNECT_PARM, C.4.6

facilities, 1.9.11

format, gateway initialization file parameter, C.4.6

functions, 1.6

gateway architecture, connecting to DRDA Server, 1.5

known restrictions, DRDA Network Interfaces, 2.5.1

modifying tnsnames.ora in Oracle Net, 9.4.2

protocol

access across multiple networks - transparency, 1.3.1

DRDA server support, 1.5

implicit protocol conversion, 1.3.3

remote access, 1.9.14

sample Oracle Net listener.ora file, B.3

security validation, 13.4

support, 1.9.6

you must choose either SNA or TCP/IP for the Networking Interface, 8.2

terminology defined, 1.4

tg4drdasnacommsvr subdirectory, sample SNA Server definitions, 7.3.2.1, 7.3.2.1

tg4drdasnamssna subdirectory, sample SNA Server definitions, 6.4.1

TIME data type, 12.7.4.1

time operations, 12.7.4

TIMESTAMP data type, 12.7.4.1

TNSNAMES.ORA

changes to, during migration problems, 14.2

tnsnames.ora

adding a gateway service name, 9.4.2, 9.4.2

configuring additional DRDA Server instances, 10.9

connect descriptor, 11.1.1

using the HS facilities, 14.5

TO_DATE function

Oracle function preprocessed in SQL, 12.7.7

processing DATE data, 12.7.4.2

twenty-first century dates, 12.7.5

token

error tokens, 15.1.3

package consistency, DRDA_PACKAGE_CONSTOKEN, C.4.21

trace control, C.4.39

TRACE_LEVEL parameter, C.4.41

tracing

code, C.4.41

LOG_DESTINATION, C.4.36

ORACLE_DRDA_TRACE, C.4.40

SQL statements, 11.10

trade-off, Native Semantics, 12.6

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

transactions

CICS, 12.3.2

IMS, 12.3.2

transform

character set transforms with multi-byte support, D.5

not required for DRDA Server, D.5

transparency

and performance, 12.6

main topic, gateway transparency, 1.3.1

triggers for Oracle Database 10g server, 11.7.1

TSO, 5.2

two-phase commit

ORACLE2PC table

DB2/400, 5.3.2

DB2/OS390, 5.2.2

DB2/UDB, 5.4.2

DB2/VM, 5.5.2

protection, 1.3.2

transactions, distributed queries, 11.5.2

unsupported statement, 11.5.2

U

UNION

capability, 1.3.2

operator, 12.6.3

UNION ALL

operator, 12.6.3

UPDATE

known restrictions, 2.5.2

operation, 12.1

SQL clause, 12.7.7

statement

dates, 12.7.5

native SQL passthrough, 12.8

transaction semantics, 1.7.1

with read-only gateway, 11.6

upgrading, defined, 14.1

user privileges, 12.9

USER_CATALOG view, A.2.18

USER_COL_COMMENTS view, A.2.19

USER_CONS_COLUMNS view, A.2.21

USER_CONSTRAINTS view, A.2.20

USER_DB_LINKS data dictionary view, 11.1.4

USER_INDEXES view, A.2.22

USER_OBJECTS view, A.2.23

USER_SYNONYMS view, A.2.24

USER_TAB_COLUMNS view, A.2.26

USER_TAB_COMMENTS view, A.2.27

USER_TABLES view, A.2.25

USER_USERS view, A.2.28

USER_VIEWS view, A.2.29

userid mapping

DB2/400, 13.5.1.3

DB2/OS390, 13.5.1.1

DB2/VM, 13.5.1.2

security, 13.5.1

userid translation

DB2, 13.5.1.2

USING clause, 11.1.1

V

VALUES clause, 12.7.7

VARCHAR data type, 12.7.2

variable

bind, 12.8

input bind, 12.7.4.2

view

catalog

DB2/400, 12.9.1

DB2/OS390, 12.9.1

DB2/UDB, 12.9.1

DB2/VM, 12.9.1

creating, 10.7.2

data dictionary, 12.9

VSAM file, 12.3.2

VTAM

DB2/OS390, 5.2

DB2/VM VTAM configuring, 5.5.1

W

WHERE clause

compatible for all versions of DRDA Server, 12.6.3

SQL limitations, Oracle ROWID column, 2.5.2

WHERE CURRENT OF CURSOR clause, ROWID column, 2.5.2

WHERE function, 12.6.2

wireless communication, 1.3.3

workarounds, 2.4

Z

zoned decimal operations, 12.7.10