Oracle Transparent Gateway for IBM DRDA Installation and User's Guide -- Index

ABS SQL function, 10-25, F-1

accessing

DRDA servers, 8-12

gateway, 8-12, 9-4

ACOS function, F-1

ADD_MONTHS function, F-1

Advanced Program to Program Communication (APPC/LU6.2) protocol, 7-1

Advanced Security

CHECKSUM command, 5-6

encryption, 5-6

international version types supported, 5-6

resetting configuration parameters on gateway, 5-8

setting test parameters for gateway, 5-7

setting test parameters for integrating Oracle server, 5-7

setting up for test, 5-6

testing gateway and integrating Oracle server, 5-8

export encryption algorithms, 5-6

function on the gateway, 1-6

purpose, 1-6

test error, 5-8

12660, 5-6

AGW ADD USERID command, 11-9

AGW DELETE USERID command, 11-9

AIX, 6-7

AIX_RS6K, default value, C-7

System Management Interface Tool, 7-3

system support for APPC & for TCP/IP, 7-1

alias

DB2, C-5

partner LU, 7-5

alias objects, DB2

known restrictions, 2-5

ALL_CATALOG view, A-3

ALL_COL_COMMENTS view, A-3

ALL_CON_COLUMNS view, A-4

ALL_CONSTRAINTS view, A-5

ALL_DB_LINKS data dictionary view, 9-3

ALL_INDEXES view, A-6

ALL_OBJECTS view, A-8

ALL_SYNONYMS view, A-8

ALL_TAB_COMMENTS view, A-11

ALL_TABLES view, A-9

ALL_USERS view, A-12

ALL_VIEWS view, A-12

allocation mode, SNA session, C-4

ALTER session statement, 9-3

ANSI-standard SQL, 1-7, 1-16

API (application program interface), 5-3

APPC, 7-1

concurrent connections, 3-2

conversations, 7-3

DB2/VMT, 11-9

number of database link connections, 10-8

password length, 13-7

profile, 8-12

user ID length, 13-6

APPC VTAM Support (AVS), 2-6

also see AVS, 11-9

APPC/LU6.2

parallel session limits, 7-4

protocol, 1-4

side information profile, 7-6

APPEND command

supported by COPY, 9-10

application

authenticating logons, 11-3

portability, 1-16

server support, 1-6

application development on the gateway, 1-18

application program interface

see API

APPN

node, advanced peer-to-peer networking node, 7-5

support requires VTAM Version 4, 7-5

architecture of the gateway, 1-11

array size, 1-15

how determined, 10-2

AS/400, 1-16, 6-5

command

DSPRDBDIRE, 6-6

communications

configuring, 6-5

files and file members

accessing, 9-5

ASCII, 10-28

code page, D-5

function, F-1

sort order, 10-25

tables, known restrictions, 2-3

US7ASCII, D-5, D-7

ASCII SQL function, 10-25

ASIN function, F-1

asynchronous replication, 9-9

ATAN function, F-1

ATAN2 function, F-1

authority

CONNECT, 11-10

execute, 11-10

autonomy, site, 1-9

available products, 4-6

available products menu, 4-6

AVS

also see APPC VTAM Support, 2-6

configuring, 6-9

DB2/VMT, 11-9

mapping user IDs, 2-6, 11-9

mapping user IDs (DB2/VM), 2-6

mapping user IDs with DB2/VMT, 11-9

binary data, non-character, 10-28

Bind Package Stored Procedure, 6-3, 6-5, 6-7, 6-9

BIND privilege, 6-3, 6-7, 6-9

bind variables, 10-35

restrictions, 2-9

BINDADD authority, 8-7

BINDADD privilege, 6-3, 6-7, 6-9

BINDAGENT privilege, 6-3, 6-7, 6-9

binding the DRDA package, 6-3, 6-5, 6-7, 6-9

backward compatibility, 12-6

on DB2/UDB, 8-7

on DRDA server, 8-6

pre-binding checklist, 8-8

books

other recommended reading, 3-5

Bourne shell, 2-3

setting ORACLE_HOME variable, 4-5

bug

debugging, 9-11, 13-3, 13-8, 13-9

debugging with Startup Shell Script, 8-4

number 205538, 2-9

bugs fixed in this release, 2-4

C shell

setting ORACLE_HOME variable, 4-5

call

a CICS or IMS transaction, 10-7

DB2 stored procedure, 10-5, 10-6

DRDA_DISABLE_CALL, 8-8, B-2

empproc stored procedure, 10-5

Oracle Call Interfaces, 13-2

PL/SQL, 10-6

stored procedure, 10-3, 10-4

to stored procedure, 2-7

capabilities

DRDA server, 10-24

catalog views, 10-38

caths.sql script, 4-3, 8-4, 8-11

CCSID, C-8

65535 as the default for all tables created, C-4

codepage mapping facility, D-9

description, D-4

external mapping to Oracle character sets supported, 2-2

CD-ROM drive requirements, 3-2

CEIL SQL function, 10-25, F-1

changed parameters, 12-4

changes in this release, 2-2

bugs fixed, 2-4

gateway parameters, 2-3

IBM DB2 Version 5.1 EBCDIC and ASCII Tables, 2-3

IBM DB2/UDB supported, 2-3

Oracle server dependencies, 2-3

read-only support, 2-3

TNSNAMES.ORA, 2-3

CHAR_TO_ROWID function, F-1

CHARACTER SET parameter, D-5

description, D-3

character sets

and codepage map facility, D-9

ASCII, 2-3

CCSID, D-4

codepage, C-4

EBCDIC, 2-3

limitation, 2-6

supported, 2-2

character string

converting datatypes, 10-28

performing operations, 10-28

checklist

configuring the communications interfaces, 7-2

configuring the DRDA server, 6-2

gateway configuration, 8-2

gateway installation, 4-3

installation overview, 4-3

Oracle Net, 5-2

CHECKSUM command, 1-6, 5-6

also see Advanced Security

CHR SQL function, 10-25, F-1

CICS transaction, 10-7

clauses

CONNECT TO, 9-2

GROUP BY, 10-26

HAVING, 10-26

ORDER BY, 10-26

SQL

DELETE, 10-33

INSERT, 10-33

SELECT WHERE, 10-33

UPDATE, 10-33

TO_DATE, 10-33

USING, 9-2

VALUES, 10-33

WHERE, 2-9, 10-26

WHERE CURRENT OF CURSOR, 2-9

code tracing, C-14

codepage

overriding, C-8

codepage map facility

configuring support for character sets, 2-6

for data translation, D-9

supported by gateway, 2-2

coercion

of data, 10-24

collection privilege - CREATE IN, 6-3, 6-7, 6-9

column

date, 10-33

Oracle ROWID, 2-8

supported in a result set, 1-16

commands

AGW ADD USERID, 11-9

AGW DELETE USERID, 11-9

CHECKSUM, 1-6, 5-6

COPY, 2-5

COPY (SQL*Plus command), 9-10

CREATE DATABASE LINK, 6-9

DESCRIBE, 2-5

EXECUTE, 1-8

EXPLAIN PLAN, 13-8

INSERT, 2-5

commit confirm protocol, 1-9

Communication Database (CDB) tables, DDF, 6-4

communications requirements, 3-3

Communications Server

configuring server profiles, 7-3

profiles

creating, 7-3

compatible SQL set operators and clauses, 10-26

components when installed on gateway, 1-12

concatenation restrictions, 2-7

concurrent connections

APPC, 3-2

TCP/IP, 3-2

configuring

additional DRDA servers, 8-12

AS/400 communications, 6-5

AVS, 6-9

binding DRDA package, 8-8

checklist for gateway, 8-2

checklist for installation overview, 4-3

checklists, 4-3, 5-2, 6-2, 7-2, 8-2

DB2/400, 6-5, 6-7

DB2/MVS, 6-3

DB2/UDB, 6-7

integrating Oracle server, 8-11

MVS VTAM, 6-3

Oracle Net, 5-4

other Oracle servers, 8-12

RS/6000 host workstation for gateway, 8-5

SMIT, 6-7

SNA server

creating profiles, 7-3

testing connection, 7-6

TCP/IP, 6-3, 6-5, 6-7, 6-9, 7-7

VM VATM, 6-9

CONNECT authority, 8-7, 11-10

CONNECT BY not supported

known restrictions, 2-9

CONNECT TO clause, 9-2

conversion

errors, C-4

convert

character string, 10-28

datatypes, 10-26

DATE, 10-29

floating point to integer, 10-33

inbound user ID, 11-9

into most suitable datatype, 10-34

SQL, 1-13

to the numeric datatype, 10-33

CONVERT SQL function, 10-25, F-1

converter, protocol, 1-6

COPY privilege, 6-3, 6-7, 6-9

COPY SQL*Plus command, 9-10

substituted for INSERT, 2-5

copying data

from the DRDA server, 9-10

from the Oracle server to DRDA server, 9-9

COS SQL function, 10-9, 10-25, F-1

COSH SQL function, 10-25, F-1

COUNT function, 10-34

CPI-C

communication error messages, 13-4, 13-7

routine, 13-4

CREATE command

supported by COPY, 9-10

CREATE DATABASE LINK command, 6-9, 9-2

CREATE IN privilege, 6-3, 6-7, 6-9

CREATE PUBLIC DATABASE LINK privilege, 8-7, 8-11

CREATE TABLE statement, 1-8

CREATE VIEW, SQL function, 9-5

CREATETAB authority, 8-7

creating

a new directory, 4-4

database link, 9-2

cursor

defining the number of, 10-39

number of, C-11

stability, C-6

customizing

Startup Shell Script, B-3

data coercion, 10-24

data control language (DCL), 1-7

DATA datatype, 10-29

data definition language (DDL), 1-7

data dictionary

improved in this release, 2-2

scripts for DB2/400, 8-9

scripts for DB2/MVS, 8-9

support, 8-9

tables and view, 8-9

using, 10-38

views, 10-38

ALL_DB_LINKS, 9-3

considerations for migration from previous releases, 12-6

for DB2/VM and DB2/UDB not supported, A-2

list and descriptions, A-3

USER_DB_LINKS, 9-3

views supported for DB2/MVS and DB2/400 servers, A-2

database

catalogs, 10-38

database link, 8-6

behavior, 10-8

creating, 9-2

defining and controlling, 11-4

dropping links, 9-3

examining, 9-3

guidelines, 9-3

limits, 9-3

processing, 9-2

public, 8-11

suffix, 10-2

to identify the gateway, 1-13

database triggers, 1-5

datatype

character string, 10-28

column (ALL_TAB_COLUMNS), A-10

column (USER_TAB_COLUMNS), A-20

conversion, 10-26

control over, 10-33

converting character string, 10-28

data and time, 10-29

differences between Oracle server and DRDA databases, 10-1

DRDA server datatypes list, 10-26

mapping, 10-26

numeric, 10-33, 10-34

operations

numeric, 10-33

Oracle datatypes RAW and LONG RAW, 10-28

restrictions, 10-26

size and value limitations, 10-26

datatypes

DATE, 10-29

GRAPHIC, 10-29

LONG, 10-28

LONG RAW, 10-28

Oracle and IBM DATE, 10-29

Oracle DATE, 10-29

RAW, 10-28, C-4

TIME, 10-29

TIMESTAMP, 10-29

VARCHAR, 10-28

VARGRAPHIC, 10-29

date

DELETE

clause, 10-33

statement, 10-31

HS_NLS_DATE_FORMAT parameter, 10-31, 10-32

INSERT

clause, 10-33

statement, 10-31

SELECT statement, 10-31

SELECT WHERE clause, 10-33

TO_DATE function, 10-31, 10-33

UPDATE

clause, 10-33

statement, 10-31

date arithmetic

known restrictions, 2-7

DATE datatype, 10-29

dates

columns, 10-33

in 21st century, 10-31

operations, 10-29

DB_DOMAIN parameter, 2-7

DB2, 6-3, C-5

02pcg.sql granting authority, 8-10

alias objects

known restrictions, 2-5

aliases, C-5

CICS, 10-7

data access, 1-8

Distributed Data Facility (DDF), 6-4

IBM DB2 Version 5.1 ASCII Tables, 2-3

IMS, 10-7

native SQL, 1-8

native stored procedures, 1-8

procedural feature considerations, 10-7

server

SPUFI utility, 6-4

SQL statements, 10-35

statements

CREATE TABLE, 1-8

stored procedures, 10-7

DB2 Universal Database, see DB2/UDB

DB2/400, 1-10, C-4, C-5, C-6, C-7

catalog view, 10-38

configuring, 6-5, 6-7

data dictionary scripts, 8-9

data dictionary views supported by gateway, A-2

user ID mapping, 11-10

DB2IND sample DB2 stored procedure, G-2

DB2/MVS, 1-10, C-5, C-6, C-7

catalog view, 10-38

configuring, 6-3

data dictionary views supported by gateway, A-2

scripts to create data dictionary tables, 8-9

user ID mapping, 11-8

DB2/MVS V6

stored procedures supported, 2-2

DB2/UDB, 8-9, 8-10, C-6, C-7

binding packages, 8-7

catalog view, 10-38

configuring, 6-7

data dictionary views not supported, A-2

incompatibilities with gateway, 2-5

known restrictions, 2-7

scripts to create data dictionary tables, 8-9

supported, 2-3

user ID mapping, 11-10

DB2/VM, C-6, C-7, C-10

catalog view, 10-38

configuring, 6-9

data dictionary views not supported, A-2

database and SQL functions, 10-20

instance, DRDA location name, 6-10

server machine, 11-10

user ID mapping, 11-9

DBA

authority, 9-3

DBCS (double-byte character set), 2-6

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 10-35

DD basic tables, known restrictions, 2-6

DDF

DB2 (Distributed Data Facility), 6-4

subsystem, 6-3

DDL

statement, 10-35

debug

gateway, 13-8, 13-9

library, 13-9

debugging

error codes, 13-3

SQL tracing, 13-8, 13-9

with Startup Shell Script, 8-4

your application, 9-11

DECODE SQL function, 10-25, F-1

de-installing the gateway, 4-8

DELETE, 9-8

known restrictions, 2-9

operation, 10-2

SQL clause, 10-33

statement, 10-35

DESCRIBE

character string operations, 10-28

command, known restrictions, 2-5

statement, 8-4, 8-11

diagnostic parameter, C-13

dictionary

also see data dictionary

mapping, 1-7

tables, 10-38

DICTIONARY view, A-13

disk space requirements, 3-2

distributed

operations, DB2, 6-4

queries

example of, 9-6

two-phase commit, 9-7

transaction, C-12

distributed applications

support for, 1-18

distributed data facility (DDF), 6-4

distributed database, 5-3

distributed DRDA transactions, 9-8

distributed processing, 5-3

distributed query optimizer (DQO), 9-6

DRDA-specific parameters, C-7

documentation

recommended, 3-5

double-byte character set (DBCS), 2-6

DQO

also see distributed query optimizer, 9-6

DRDA-specific parameters, C-7

drc error code, 13-3

DRDA

catalog, 10-38

database requirements, 3-3

defining number of cursors, 10-39

gateway package considerations, 8-8

location name, 6-10

for DB2/UDB instance, 6-8

for DB2/VM instance, 6-10

DRDA Application Server Function, 1-16

DRDA server

accessing, 8-12

architecture, 1-11

capabilities, 10-24

character sets

known restrictions, 2-6

configuring

DB2/400, 6-5

DB2/MVS, 6-3

DB2/UDB, 6-7

DB2/VM, 6-9

considerations for binding packages, 12-6

copying data

from Oracle server, 9-9

to Oracle server, 9-10

database link behavior, 10-8

functions, 10-24

languages and character sets in configuration, D-9

stored procedures, 10-5

types supported by gateway, 1-10

DRDA server Logical Unit (LU), 11-5

DRDA session security options, 11-8

DRDA_CAPABILITY parameter, 10-24

DRDA_CMSRC_CM_IMMEDIATE parameter, C-4

DRDA_CODEPAGE_MAP parameter, D-9

DRDA_COMM_BUFLEN parameter, C-3

DRDA_CONNECT_PARM (SNA format) parameter, C-3

DRDA_CONNECT_PARM (TCP/IP format) parameter, C-3

DRDA_CONNECT_PARM parameter, 13-4

DRDA_DEFAULT_CCSID parameter, C-4

DRDA_DESCRIBE_TABLE parameter, 2-5, C-5

DRDA_DESCRIBE_TABLE=FALSE initialization parameter, 2-5

DRDA_DISABLE_CALL parameter, 8-8, C-5

DRDA_FLUSH_CACHE parameter, C-6

DRDA_ISOLATION_LEVEL parameter, C-6

DRDA_LOCAL_NODE_NAME parameter, C-7

DRDA_OPTIMIZE_QUERY parameter, 9-6, C-7

DRDA_PACKAGE_COLLID parameter, 13-4, C-9

DRDA_PACKAGE_CONSTOKEN parameter, C-10

DRDA_PACKAGE_NAME parameter, 8-8, 13-4, C-10

DRDA_PACKAGE_OWNER parameter, C-10

DRDA_PACKAGE_SECTIONS parameter, 10-39, C-11

DRDA_READ_ONLY parameter, 9-8, C-11

DRDA_RECOVER_USERID, 6-4, 6-5, 6-8, 6-9

DRDA_RECOVERY_PASSWORD parameter, 6-4, 6-5, 6-8, C-11

DRDA_RECOVERY_USERID parameter, 6-4, 6-5, 6-8, 6-9, C-12

DRDA_REMOTE_DB_NAME parameter, C-12

DRDA_SECURITY_TYPE parameter, C-12

DROP DATABASE LINK statement, 9-3

dropold.sql, 8-9

DSPRDBDIRE command, 6-6

DUMP SQL function, 10-25, F-1

dynamic dictionary mapping, 1-7

EBCDIC, 10-28

character set support, D-7

code page, D-5

DRDA server CCSID, D-12

sort order, 10-25

tables, known restrictions, 2-3

EMP, 9-5

table, 9-10

empproc

stored procedure, 10-5

encryption types for Advanced Security, 5-6

enhancements in this release, 2-2

environment

heterogeneous, 9-8

environmental variable

NLS_LANG, D-3

ORA_NLS33, D-3

ORACLE_HOME, 4-5

errd, 13-5, C-8

errmc, 13-4, 13-5, C-8

(error tokens), 13-4

field, 13-3

error

12660 (test error for Advanced Security), 5-6

basic description, 13-2

codes

drc, 13-3

grc, 13-3

communication, 13-4

condition, 13-2

conversion, C-4

date, D-7

drc= field

-300xx, 13-7

-7xx, 13-6

HGO-00706, 13-3

host database, 13-7

interpreting error messages, 13-2

mapped sqlstate, 13-5

messages, 10-28, 11-7

messages & codes, 13-1

number, 13-2

obsolete parameters, 12-6

ORA-00001, 13-5

ORA-00942, 13-5

ORA-01017, 13-5

ORA-01031, 13-5

ORA-01460, 13-5

ORA-01476, 13-5

ORA-02019, 13-2

ORA-09100, 13-3, 13-4

ORA-09101, 13-4

ORA-1460, C-8

ORA-9100 to ORA-9199, 13-2

Oracle mapped error codes, 13-5

server database, 13-4

specific gateway error codes, 13-6

tokens, 13-3, 13-4

translation, 10-28

while binding the gateway package, 8-7

with Native Semantics, 10-24

error array (errd), See errd

errors

detected by integrating Oracle Server, 13-2

detected by server database, 13-4

detected by the gateway, 13-3

detected in the DRDA software, 13-3

errp, 13-4, 13-5, C-8

errp field, 13-3

estimated memory requirement, 3-2

EXCEPT set operator, 10-26

execute authority

DB2/400, 11-10

DB2/UDB, 11-10

DB2/VM, 11-10

on the gateway DRDA package, 11-10

EXECUTE command, 1-8

EXECUTE privilege, 6-3, 6-7, 6-9

exits

gateway local date, 10-32

EXP SQL function, 10-25, F-1

EXPLAIN PLAN command, 13-8

EXPLAIN_PLAN table, 1-16

export encryption algorithms, 5-6

FDS_CLASS parameter, C-15

FDS_CLASS_VERSION parameter, C-15

FDS_INSTANCE parameter, C-16

features

Oracle Snapshots, 9-9

features of the gateway, 1-14

application development and end-user tools, 1-18

application portability, 1-16

columns supported in a result set, 1-16

distributed applications supported, 1-18

EXPLAIN_PLAN improvement, 1-16

fetch reblocking, 1-15

heterogeneous database integration, 1-16

heterogeneous services architecture, 1-14

large base of data access, 1-16

minimum impact on existing systems, 1-16

Native Semantics, 1-15

Oracle9i passthrough supported, 1-15

performance enhancements, 1-15

remote data access, 1-17

retrieving result sets through passthrough, 1-15

support for TCP/IP, 1-15

fetch reblocking, 1-15, 10-2

fetched date, C-13

fields

errmc, 13-3

errp, 13-3

file member name, 9-5

file members

accessing AS/400 files, 9-5

files

initsid.ora, 13-4, 13-6

listener.ora, 5-5, 8-5

sample, B-1

listener.ora, B-4

tnsnames.ora, B-3

tnsnames.ora, 8-11, 8-12

modifying, 5-5

VSAM, 10-7

FLOOR SQL function, 10-25, F-1

FOR BIT DATA, 10-28, C-4

option, 10-28

free session, C-4

functions

ABS, F-1

ACOS, F-1

ADD_MONTHS, F-1

ASCII, F-1

ASIN, F-1

ATAN, F-1

ATAN2, F-1

CEIL, F-1

CHAR_TO_ROWID, F-1

CHR, F-1

CONVERT, F-1

COS, 10-9, F-1

COSH, F-1

COUNT, 10-34

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 10-35

DECODE, F-1

DRDA server, 10-24

DUMP, F-1

EXP, F-1

FLOOR, F-1

GREATEST, F-2

HEXTORAW, F-2

INITCAP, F-2

INSTR, F-2

INSTRB, F-2

LAST_DAY, F-2

LEAST, F-2

LENGTH, F-2

LENGTHB, F-2

LN, F-2

LOG, F-2

LOWER, F-2

LPAD, F-2

LTRIM, F-2

MOD, F-1

MONTHS_BETWEEN, F-1

NEW_TIME, F-1

NEXT_DAY, F-1

NLS_INITCAP, F-1

NLS_LOWER, F-1

NLS_UPPER, F-1

NLSSORT, F-1

POWER, F-1

RAWTOHEX, F-1

REPLACE, F-1

ROUND, F-1

ROWID, 2-9

ROWIDTOCHAR, F-1

RPAD, F-1

RTRIM, F-1

SIGN, F-1

SIN, F-1

SOUNDEX, F-2

SQL

SUBSTR, 10-24

TANH, F-2

SQRT, F-2

STDDEV, F-2

SUBSTR, F-2

known restrictions, 2-6

SUBSTRB, F-2

SYSDATE, F-2

TAN, F-2

TO_CHAR, F-2

TO_DATE, 10-30, 10-31, 10-32, 10-33, F-2

TO_LABEL, F-2

TO_MULTI_BYTE, F-2

TO_NUMBER, F-2

TO_SINGLE_BYTE, F-2

TRANSLATE, F-2

TRUNC, F-2

UID, F-2

UPPER, F-2

USER, F-2

USERENV, F-2

VARIANCE, F-2

VSIZE, F-2

g4ddtab.sql script, 8-9

g4ddview.sql script, 8-9

g4drdrv

former startup program, 8-5

gateway

accessing, 9-4

from other Oracle servers, 8-12

advantages, 1-3

migration and coexistence, 1-10

multisite transactions, 1-9

security, 1-10

server technology and tools, 1-8

site autonomy, 1-9

two-phase commit, 1-9

and Oracle tools, 1-14

and stored procedures (Oracle and non-Oracle), 1-8

application tools, 1-18

architecture, 1-11

authenticating logons, 11-3

benefits of integration with 9i server, 1-6

binding DRDA packages, 8-6

components, 1-12

configuration and the Startup Shell Script, 8-4

definition of terms, 1-10

de-installing, 4-8

DRDA package considerations, 8-8

error codes, 13-6

errors detected, 13-3

features, 1-14

how to access, 9-4

installation

log file, 4-8

needs, 4-2

steps, 4-4

steps via Oracle Universal Installer, 4-7

interface, 1-13

local date exit, 10-32

logging, C-13

migration problems, 12-3

parameter, 2-3, 6-10

performance enhancements, 1-15

performing distributed queries, 9-6

read-only option, 9-8

service name entries in the tnsnames.ora, 12-6

settings for security options, 11-6

SQL differences, 1-13

startup time, 8-4

supported languages, D-9

tracing, C-13

tracing SQL statements, 9-11

using, 9-1

with other Oracle products

SQL*Plus, 1-9

Gateway Initialization File

Also See "parameters"

configuring, 8-6

modifying, C-2

parameters, 2-3, 13-10

DRDA_READ_ONLY, 9-8

LOG_DESTINATION, 13-9

new since V4 gateway, 12-4

ORACLE_DRDA_TCTL, 13-9

stored in initsid.ora, C-2

TRACE_LEVEL, 13-9

parameters, list, C-2

reported errors in parameter, 8-7

sample, B-2

gateway performance, 10-24

Gateway System Identifier (SID), 8-4

GCS virtual machine, 11-9

GLOBAL_NAMES

known restrictions, 2-7

GRANT, 11-10

GRANT statement, 8-11

granting authority to a package for DB2, 8-10

GRAPHIC datatype, 10-29

graphic string operations

unsupported, 10-29

grc error code, 13-3

GREATEST SQL function, 10-25, F-2

GROUP BY clause, 10-26

GROUPBY SQL function, 10-25

GTW$_BIND_PKG

internal stored procedure, 8-8

stored procedure, 8-7

hardware requirements, 3-2

HAVING clause, 10-26

HAVING SQL function, 10-25

heterogeneous database integration, 1-16

Heterogeneous Services (HS), see HS, 1-3

HEXTORAW SQL function, 10-25, F-2

HGO-00706 error, 13-3

host database error, 13-7

host variable, 10-26, 10-28

HS (Heterogeneous Services)

architecture features, 1-14

Oracle Net considerations, 12-6

HS Catalog Script, side information profile, 7-6

HS= (TNSNAMES parameter for Oracle Net), 5-5

gateway migration problems, 12-3

HS_DB_DOMAIN parameter, 2-7

HS_DB_NAME parameter, 2-7

HS_NLS_DATE_FORMAT, 10-31, D-7

function, 10-31

parameter, 10-32

HS_NLS_DATE_LANGUAGE, D-7

HS_RPC_FETCH_REBLOCKING parameter, 1-15, 10-2

HS_RPC_FETCH_SIZE parameter, 1-15, 10-2

IBM Communications Server for AIX

and SNA security option, 11-7

tailoring Startup Shell Script for Version 9.0, 8-6

Version 5 required patches, 3-3

implementation, 1-12

implicit data conversion, 10-24

implicit protocol conversion, 1-6

IMS transaction, 10-7

inbound connections

processing, 11-8

incremental row changes, 9-9

init parameter, 8-5

INITCAP SQL function, 10-25, F-2

initdrdahoa1.ora

Also See Gateway Initialization File parameters

sample, B-2

initdrdahoa1.sh

Also See Startup Shell Script

sample, B-3

initialization parameters, 2-3

Also See Gateway Initialization Files and see "parameters"

new since V4 gateway, 12-4

initsid.gtwboot

parameters formerly stored in the gateway instance directories, 8-5

initsid.ora file, 13-4, 13-6

NLS parameters, D-6

parameters formerly stored in the gateway instance directories, 8-5

input bind variables, 10-30

INSERT, 9-8

known restrictions, 2-5

operation, 10-2

Oracle SQL command, known restrictions, 2-5

SQL clause, 10-33

statement, 10-31, 10-35

INSERT command, 2-5

supported by COPY, 9-10

installation

checklists, 4-3, 5-2, 6-2, 7-2, 8-2

overview, 4-4

installing the gateway

from CD, 4-4

INSTR SQL function, 10-25, F-2

INSTRB SQL function, 10-25, F-2

integrating Oracle Server

accessing gateway from other Oracle servers, 8-12

accessing other DRDA servers, 8-12

accessing the gateway, 9-4

architecture, 1-11

configuration, 8-11

definition, 1-10

errors detected, 13-2

requirements, 3-3

using, in application development, 10-2

internal tracing, C-14

Internet support, 1-6

INTERSECT

SQL set operators and clauses, 10-26

IPC

adapter, B-5

ISO standard, 1-7

isolation level, C-6

JOIN

capability, 1-5

JOIN SQL statement, 10-2

keywords

LISTENER, B-5

known problems, 2-5

compatibility with DB2/UDB, 2-5

known restrictions, 2-5

accessing DB2 alias objects, 2-5

AVS mapping user IDs, 2-6

bind variables become SQL parameter markers, 2-9

binding the DRDA gateway package on DB2/UDB, 2-7

character set limitation, 2-6

CONNECT BY not supported, 2-9

datatype limitations, 2-6

date arithmetic, 2-7

DD basic tables and views, 2-6

dictionary views not provided for DB2/VM or DB2/UDB, 2-8

DRDA server character sets, 2-6

GLOBAL_NAMES parameter, 2-7

INSERT (Oracle SQL command), 2-5

LONG datatype in SQL*Plus, 2-8

null values and stored procedures, 2-7

Oracle ROWID column, 2-8

row length limitation, 2-8

SAVEPOINT, 2-6

single gateway instances per DRDA network interface, 2-8

SQL*Plus DESCRIBE command, 2-5

string concatenation, 2-7

SUBSTR function post-processed, 2-6

Korn shell

setting ORACLE_HOME variable, 4-5

LANGUAGE parameter, D-7

also see Gateway Initialization File

languages, 1-8

SQL*Plus, 1-9

LAST_DAY function, F-2

LEAST SQL function, 10-25, F-2

LENGTH SQL function, 10-25, F-2

LENGTHB SQL function, 10-25, F-2

link, also see Database Link, 10-8

linkage conventions

SIMPLE WITH NULLS, 10-7

linkname, 8-11

listener, B-5

LISTENER keyword, B-5

listener.ora file, 5-5, 8-5

sample, B-4

literal

character literals, 10-29

date, 10-29

specific datatype, 10-26

TO_DATE, 10-33

LN SQL function, 10-25, F-2

log file, gateway installation, 4-8

LOG SQL function, 10-25, F-2

LOG_DESTINATION parameter, 13-9, 13-10, C-13, C-14

and log files, 13-10

logging, C-13

Logical Unit (LU), 11-5

Login as DBA, 4-4

LONG datatype, 10-28

LONG RAW datatype, 10-28

LOWER SQL function, 10-25, F-2

LPAD SQL function, 10-25, F-2

LTRIM SQL function, 10-25, F-2

LU name, 11-8

LU6.2

local LU profile, 7-4

profile types, 7-4

protocol, 1-11

side information profile, 7-6

SNA APPC, 7-1

mapped sqlstate errors, 13-5

mapping user IDs

AVS, 11-9

known restrictions, 2-6

memory requirement, estimated, 3-2

migrating the gateway instance, 12-6

migration problems, 12-3

MINUS

set operator, 10-26

SQL set operators and clauses, 10-26

Mobile Agents, 1-6

MOD SQL function, 10-25, F-1

Mode Profile

SNA Server profile, 7-4

MONTHS_BETWEEN function, F-1

MVS, 1-16, 6-3

MVS VTAM

configuring, 6-3

National Language Support

initsid.ora parameters, D-6

overriding codepage, C-8

overview, D-1

Native Semantics, 1-15

parameters, 10-26

with SUBSTR function, 2-6

network

attachment, 3-2

Oracle Net configuration, 5-4

requirements, 3-2

transparency, 1-4

NEW_TIME function, F-1

NEXT_DAY function, F-1

NLS

Also See National Language Support, D-1

DRDA server character sets, D-9

NLS parameters

configuration on client and Oracle servers, D-5

NLS_INITCAP SQL function, F-1

NLS_LANG

environmental variable, D-3

parameter

default setting, D-8

syntax, D-8

server-side parameter, D-3

NLS_LOWER SQL function, F-1

NLS_UPPER function, F-1

NLS_UPPER SQL function, F-1

NLSSORT SQL function, 10-25, F-1

non-character binary data, 10-28

NT, 1-16

null

rows, 10-34

values, 10-34

number of cursors, C-11

numbers

concatenation restrictions, 2-7

numeric datatype, 10-33, 10-34

o2pc.sql, 8-10, 9-7

obsolete parameters

DRDA_OVERRIDE_FROM_CODEPAGE, C-8

DRDA_OVERRIDE_TO_CODEPAGE, C-9

DRDA_RDBMS_TYPE, C-11

obsolete parameters since V4 gateway, 12-6

open cursors, at the IBM database, 10-39

OPEN_LINKS parameter, 9-3

operating system requirements, 3-3

operations

DELETE, 10-2

INSERT, 10-2

SELECT, 10-2

UPDATE, 10-2

operators

UNION, 10-26

UNION ALL, 10-26

option

binding packages, 8-8

data dictionary views, 10-38

date format string, 10-31

dates, 10-31

DRDA session security, 11-8

FOR BIT DATA, 10-28

for dates in 21st century, 10-31

Oracle server, 1-11

read-only, 9-8

gateway configuration, 1-9

replicating, 9-8

security conduct, 11-8

service port number, C-3

SNA security, 11-6

SQL functions, 10-25

SQL*Plus COPY command, 9-10

ORA_MAX_DATE parameter, C-13

ORA_NLS33 parameter

description, D-3

syntax, D-8

ORA-00001 error, 13-5

ORA-00942 error, 13-5

ORA-01017 error, 13-5

ORA-01031 error, 13-5

ORA-01460 error, 13-5

ORA-01476 error, 13-5

ORA-02019 error, 13-2

ORA-09100 error, 13-3, 13-4

ORA-09101 error, 13-4

ORA1 Oracle instance, 10-3

ORA-1460 error, C-8

ORA2 Oracle instance, 10-3

ORA-9100 to ORA-9199 errors, 13-2

Oracle

directory tree, 4-4

error number or return code, 13-2

mapped error codes, 13-5

products compatibility, 1-14

RAW datatype, C-4

snapshots, 9-9

stored procedure, defined, 10-3

Oracle Forms

known restrictions, 2-9

Oracle Net, 1-9, 12-6

and application development, 1-18

and distributed processing, 5-3

and remote data access, 1-17

and server coexistence, 1-11

API, 5-3

compatibility with SQL*Net, 5-3

configuring, 5-4

distributed

database, 5-3

processing, 5-3

editing to set up security test, 5-7

Heterogeneous Services (HS) facility, 5-3

introduction, 5-3

operating system authentication, 11-3

overview, 5-3

product version, 2-2

purpose, 1-12

requirements, 3-4

sample files, B-1

sample listener.ora file, B-4

support for CHECKSUM and encryption, 5-6

terminology, 5-4

client, 5-4

driver, 5-4

host, 5-4

network, 5-4

protocol, 5-4

TNS connect descriptor specification, 9-2

Oracle Replication Services, 9-9

Oracle ROWID column, 2-8

Oracle ROWID function, 2-9

Oracle server dependencies, 2-3

Oracle Universal Installer

de-installing the gateway, 4-8

starting, 4-6

steps to install the gateway, 4-7

upgrading for installation, 4-6

ORACLE_DRDA_TCTL parameter, 13-9, C-13

ORACLE_DRDA_TRACE parameter, C-14

ORACLE_HOME

environmental variable, 4-5

for the gateway, 4-4

ORACLE2PC table, 6-3, 6-5, 6-7, 6-9, 8-7, 8-9, 8-10, 9-8, C-10

Oracle9i database server, 1-3

description, 1-3

Oracle9i Server, 1-3

copying data

from DRDA server, 9-10

to DRDA server, 9-9

relationship to RS/6000 host, 1-11

services, 1-5

database triggers, 1-5

distributed capabilities, 1-5

distributed query optimization, 1-5

SQL, 1-5

stored procedures, 1-5

two-phase commit protection, 1-5

triggers, 9-9

ORADRDA.ORACLE2PC table, 9-7

ORAIND sample DB2 stored procedure, G-4

oraproc1, 10-4

stored procedure, 10-3

oraproc2

stored procedure, 10-3

ORARECOV user ID, 6-4, 6-5, 6-8, 6-9, C-12

ORDER BY clause, 10-26

ORDERBY SQL function, 10-25

overriding codepage, C-8

package

collection id, C-9

consistency token, C-10

privileges - BIND, COPY, and EXECUTE, 6-3, 6-7, 6-9

packed decimal, 10-34

parameter

changed, 12-4

checking settings, 8-8

diagnostic, C-13

gateway, 2-3, 6-10

in the Startup Shell Script, C-14

initialization, 2-3

Native Semantics, 10-26

syntax, C-14

parameter file

tailoring to configure the RS/6000 host, 8-5

parameters

CHARACTER SET, D-5

DB_DOMAIN, 2-7

DRDA_CAPABILITY, 10-24

DRDA_CODEPAGE_MAP, C-3, C-15, D-9

DRDA_DESCRIBE_TABLE, 2-5

DRDA_DISABLE_CALL, 8-8

DRDA_PACKAGE_NAME, 8-8

DRDA_PACKAGE_SECTIONS, 10-39

DRDA_READ_ONLY, 9-8

DRDA_RECOVERY_PASSWORD, 6-4, 6-5, 6-8

DRDA_RECOVERY_USERID, 6-4, 6-5, 6-8, 6-9

FDS_CLASS, C-15

FDS_CLASS_VERSION, C-15

FDS_INSTANCE, C-16

Gateway Initialization File

DRDA_CAPABILITY, C-2

DRDA_CMSRC_CM_IMMEDIATE, C-4

DRDA_CODEPAGE_MAP, C-3

DRDA_COMM_BUFLEN, C-3

DRDA_CONNECT_PARM, 13-4

DRDA_CONNECT_PARM (SNA format), C-3

DRDA_CONNECT_PARM (TCP/IP format), C-3

DRDA_DEFAULT_CCSID, C-4

DRDA_DESCRIBE_TABLE, C-5

DRDA_DISABLE_CALL, C-5

DRDA_FLUSH_CACHE, C-6

DRDA_ISOLATION_LEVEL, C-6

DRDA_LOCAL_NODE_NAME, C-7

DRDA_OPTIMIZE_QUERY, 9-6, C-7

DRDA_PACKAGE_COLLID, 13-4, C-9

DRDA_PACKAGE_CONSTOKEN, C-10

DRDA_PACKAGE_NAME, 13-4, C-10

DRDA_PACKAGE_OWNER, C-10

DRDA_PACKAGE_SECTIONS, C-11

DRDA_READ_ONLY, C-11

DRDA_RECOVERY_PASSWORD, C-11

DRDA_RECOVERY_USERID, C-12

DRDA_REMOTE_DB_NAME, C-12

DRDA_SECURITY_TYPE, C-12

LOG_DESTINATION, C-13

ORA_MAX_DATE, C-13

ORACLE_DRDA_TCTL, C-13

ORACLE_DRDA_TRACE, C-14

TRACE_LEVEL, C-14

HS_DB_DOMAIN, 2-7

HS_DB_NAME, 2-7

HS_NLS_DATE_FORMAT, 10-31, 10-32

HS_RPC_FETCH_REBLOCKING, 1-15, 10-2

HS_RPC_FETCH_SIZE, 1-15, 10-2

init, 8-5

LOG_DESTINATION, C-14

LOG_DESTINATON, 13-9

new since V4 gateway, 12-4

NLS_LANG, D-8

obsolete since V4 gateway, 12-6

OPEN_LINKS, 9-3

ORA_NLS33, D-8

PROGRAM, 8-5

renamed since V4 gateway, 12-5

see also Gateway Initialization File, 2-3

setting up trace parameters, 13-8

Startup Shell Script, new since V4 gateway, 12-3

partner LU alias, 7-5

passthrough, 1-8, 1-15, 10-35, 10-37

result sets, 10-35, 10-37

SQL feature, 10-35

patches

required for IBM Communications Server for AIX, 3-3

performance, 10-24

performance enhancements

with fetch reblocking, 10-2

PL/SQL, 10-5

call, 10-6

records, 10-7

routine, 1-8

standard Oracle, 1-8

stored procedure, 10-3

port number

Primary, 6-3, 6-5, 6-7

Recovery, 6-3, 6-5, 6-7

post-processed SQL functions

overview, 10-9

post-processing, 10-24, 13-8

POWER SQL function, 10-25, F-1

PREPARE TRANSACTION statement, 9-7

Primary port number, 6-3, 6-5, 6-7

privileges, 10-38

BIND, 6-3, 6-7, 6-9

BINDADD, 6-3, 6-7, 6-9

BINDAGENT, 6-3, 6-7, 6-9

COPY, 6-3, 6-7, 6-9

CREATE IN, 6-3, 6-7, 6-9

CREATE PUBLIC DATABASE LINK, 8-7, 8-11

EXECUTE, 6-3, 6-7, 6-9

procedure

stored, 9-8

using DRDA server, 10-5

procedures

DB2 DB2IND, sample, G-2

DB2 ORAIND, sample for, G-4

processing time, with GROUPBY, HAVING, WHERE, 10-25

processor requirements, 3-2

product installation directory, 4-4

profile set, 8-12

profile types, 7-4

Mode Profile, 7-4

PROGRAM parameter, 8-5

protocol

commit confirm, 1-9

communications, 7-7

communications protocols, 5-3

converter, 1-6

definition, 5-4

implicit protocol conversion, 1-6

IPC, 5-5

network, 9-5

Oracle Net Protocol Adapters, 5-3

PROTOCOL=IPC, sample, B-3

protocol-independent encryption, 1-6

TCP/IP, 1-15

two-phase commit, 9-7

protocols

APPC/LU6.2, 1-4

APPC/LU6.2, TCP/IP, 7-1

LU6.2, 1-11

SNA, 1-11

SPX/IPX, 1-4, 1-6

TCP/IP, 1-4, 1-6, 1-11

public database link, 8-11

queries, distributed, 9-6

RAW datatype, 10-28, C-4

RAWTOHEX SQL function, 10-25, F-1

read-only gateway option, 9-8, C-11

read-only support, 2-3

rebind, C-5, C-6, C-9, C-10