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

ABS SQL function, 10-24, 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-5

encryption, 5-5

international version types supported, 5-6

resetting configuration parameters on gateway, 5-7

setting test parameters for gateway, 5-6

setting test parameters for integrating Oracle server, 5-6

setting up for test, 5-5

testing gateway and integrating Oracle server, 5-7

export encryption algorithms, 5-5

function on the gateway, 1-6

purpose, 1-6

test error, 5-7

12660, 5-5

AGW ADD USERID command, 11-8

AGW DELETE USERID command, 11-8

AIX, 6-7

AIX_RS6K, default value, C-7

alias

DB2, C-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-4

ALL_DB_LINKS data dictionary view, 9-3

ALL_INDEXES view, A-5

ALL_OBJECTS view, A-7

ALL_SYNONYMS view, A-7

ALL_TAB_COMMENTS view, A-10

ALL_TABLES view, A-8

ALL_USERS view, A-11

ALL_VIEWS view, A-11

allocation mode, SNA session, C-4

ALTER session statement, 9-3

ANSI-standard SQL, 1-7, 1-15

API (application program interface), 5-3

APPC, 7-1

changing Startup Shell Script for SunLink Peer-to-Peer, 8-6

concurrent connections, 3-2

DB2/VMT, 11-8

number of database link connections, 10-7

password length, 13-6

profile, 8-12

user ID length, 13-6

APPC VTAM Support (AVS), 2-5

also see AVS, 11-8

APPC_GATEWAY

SunLink gateway name, 8-6

APPC/LU6.2

protocol, 1-4

APPEND command

supported by COPY, 9-9

application

authenticating logons, 11-2

portability, 1-16

server support, 1-5

application development on the gateway, 1-17

application program interface

see API

architecture of the gateway, 1-10

array size, 1-14

how determined, 10-2

AS/400, 1-16, 6-5

command

DSPRDBDIRE, 6-6

communications

configuring, 6-5

files and file members

accessing, 9-4

ASCII, 10-27

code page, D-5

function, F-1

sort order, 10-25

tables, known restrictions, 2-3

US7ASCII, D-4, D-7

ASCII SQL function, 10-24

ASIN function, F-1

asynchronous replication, 9-9

ATAN function, F-1

ATAN2 function, F-1

authority

CONNECT, 11-8

execute, 11-8

autonomy, site, 1-9

available products, 4-5

available products menu, 4-5

AVS

also see APPC VTAM Support, 2-5

configuring, 6-9

DB2/VMT, 11-8

mapping user IDs, 2-5, 11-8

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

mapping user IDs with DB2/VMT, 11-8

binary data, non-character, 10-27

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

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

bind variables, 10-33

restrictions, 2-8

BINDADD authority, 8-8

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-5

on DB2/UDB, 8-7

on DRDA server, 8-6

pre-binding checklist, 8-8

books

other recommended reading, 3-4

Bourne shell, 2-3

setting ORACLE_HOME variable, 4-4

bug

debugging, 9-10, 13-3, 13-7, 13-8

debugging with Startup Shell Script, 8-4

number 205538, 2-8

bugs fixed in this release, 2-4

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-6

capabilities

DRDA server, 10-23

catalog views, 10-36

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

CCSID, C-7

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-24, 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-2

read-only support, 2-3

Sun Solaris v.2.3 not supported, 2-3

TNSNAMES.ORA, 2-3

CHAR_TO_ROWID function, F-1

CHARACTER SET parameter, D-4

description, D-3

character sets

and codepage map facility, D-9

ASCII, 2-3

CCSID, D-4

codepage, C-4

EBCDIC, 2-3

limitation, 2-6

supported, 2-2

character string

converting datatypes, 10-27

performing operations, 10-27

checklist

configuring the communications interfaces, 7-2

configuring the DRDA server, 6-2

gateway configuration, 8-2

gateway installation, 4-2

installation overview, 4-2

Oracle Net, 5-2

CHECKSUM command, 1-6, 5-5

also see Advanced Security

CHR SQL function, 10-24, F-1

CICS transaction, 10-7

clauses

CONNECT TO, 9-2

GROUP BY, 10-25

HAVING, 10-25

ORDER BY, 10-25

SQL

DELETE, 10-31

INSERT, 10-31

SELECT WHERE, 10-31

UPDATE, 10-31

TO_DATE, 10-31

USING, 9-2

VALUES, 10-31

WHERE, 2-8, 10-25

WHERE CURRENT OF CURSOR, 2-8

code tracing, C-14

codepage

overriding, C-7

codepage map facility

configuring support for character sets, 2-6

for data translation, D-9

supported by gateway, 2-2

coercion

of data, 10-23

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

column

date, 10-31

Oracle ROWID, 2-8

supported in a result set, 1-15

commands

AGW ADD USERID, 11-8

AGW DELETE USERID, 11-8

CHECKSUM, 1-6, 5-5

COPY, 2-5

COPY (SQL*Plus command), 9-9

CREATE DATABASE LINK, 6-9

DESCRIBE, 2-5

EXECUTE, 1-7

EXPLAIN PLAN, 13-7

INSERT, 2-5

commit confirm protocol, 1-9

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

communications requirements, 3-3

compatible SQL set operators and clauses, 10-25

components when installed on gateway, 1-12

concatenation restrictions, 2-6

concurrent connections

APPC, 3-2

TCP/IP, 3-2

configuration

SNA sample file, 7-3

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

checklists, 4-2, 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-10

MVS VTAM, 6-3

Oracle Net, 5-4

other Oracle servers, 8-12

SMIT, 6-7

Sun host workstation for gateway, 8-4

SunLink SNA Peer-to Peer product, 7-2

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

VM VATM, 6-9

CONNECT authority, 8-8, 11-8

CONNECT BY not supported

known restrictions, 2-8

CONNECT TO clause, 9-2

conversion

errors, C-4

convert

character string, 10-27

datatypes, 10-25

DATE, 10-28

floating point to integer, 10-32

inbound user ID, 11-8

into most suitable datatype, 10-33

SQL, 1-13

to the numeric datatype, 10-32

CONVERT SQL function, 10-24, F-1

converter, protocol, 1-6

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

COPY SQL*Plus command, 9-9

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-24, F-1

COSH SQL function, 10-24, F-1

COUNT function, 10-32

CPI-C

communication error messages, 13-3, 13-7

needed to run SunLink SNA Peer-to-Peer, 3-3

requires Side Information File, 7-4

routine, 13-3

SunLink SNA Peer-to-Peer installation path, 4-3

CREATE command

supported by COPY, 9-9

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

CREATE VIEW, SQL function, 9-5

CREATETAB authority, 8-8

creating

a new directory, 4-4

database link, 9-2

cursor

defining the number of, 10-36

number of, C-10

stability, C-6

customizing

Startup Shell Script, B-3

data coercion, 10-23

data control language (DCL), 1-7

DATA datatype, 10-28

data definition language (DDL), 1-7

data dictionary

improved in this release, 2-2

scripts for DB2/400, 8-10

scripts for DB2/MVS, 8-10

support, 8-9

tables and view, 8-10

using, 10-36

views, 10-35, 10-36

ALL_DB_LINKS, 9-3

considerations for migration from previous releases, 12-5

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-35

database link, 8-7

behavior, 10-7

creating, 9-2

defining and controlling, 11-3

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-12

database triggers, 1-5

datatype

character string, 10-27

column (ALL_TAB_COLUMNS), A-9

column (USER_TAB_COLUMNS), A-19

conversion, 10-25

control over, 10-32

converting character string, 10-27

data and time, 10-28

DRDA server datatypes list, 10-26

mapping, 10-26

numeric, 10-32, 10-33

operations

numeric, 10-32

Oracle datatypes RAW and LONG RAW, 10-27

restrictions, 10-26

size and value limitations, 10-26

datatypes

DATE, 10-28

GRAPHIC, 10-28

LONG, 10-27

LONG RAW, 10-27

Oracle and IBM DATE, 10-28

Oracle DATE, 10-28

RAW, 10-27, C-4

TIME, 10-28

TIMESTAMP, 10-28

VARCHAR, 10-27

VARGRAPHIC, 10-28

date

DELETE

clause, 10-31

statement, 10-30

HS_NLS_DATE_FORMAT parameter, 10-30

INSERT

clause, 10-31

statement, 10-30

SELECT statement, 10-30

SELECT WHERE clause, 10-31

TO_DATE function, 10-30, 10-31

UPDATE

clause, 10-31

statement, 10-30

date arithmetic

known restrictions, 2-7

DATE datatype, 10-28

dates

columns, 10-31

in 21st century, 10-30

operations, 10-28

DB_DOMAIN parameter, 2-6

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

Distributed Data Facility (DDF), 6-4

IBM DB2 Version 5.1 ASCII Tables, 2-3

IMS, 10-7

native SQL, 1-7

native stored procedures, 1-8

procedural feature considerations, 10-7

server

SPUFI utility, 6-4

SQL statements, 10-34

statements

CREATE TABLE, 1-7

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-36

configuring, 6-5, 6-7

data dictionary scripts, 8-10

data dictionary views supported by gateway, A-2

user ID mapping, 11-8

DB2IND sample DB2 stored procedure, G-2

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

catalog view, 10-36

configuring, 6-3

data dictionary views supported by gateway, A-2

scripts to create data dictionary tables, 8-10

user ID mapping, 11-7

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-36

configuring, 6-7

data dictionary views not supported, A-2

incompatibilities with gateway, 2-4

known restrictions, 2-6

scripts to create data dictionary tables, 8-10

supported, 2-3

user ID mapping, 11-9

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

catalog view, 10-36

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-8

user ID mapping, 11-8

DBA

authority, 9-3

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

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 10-33, 10-34

DD basic tables, known restrictions, 2-5

DDF

DB2 (Distributed Data Facility), 6-4

subsystem, 6-3

DDL

statement, 10-33, 10-34

debug

gateway, 13-7, 13-8

library, 13-8

debugging

error codes, 13-3

SQL tracing, 13-7, 13-8

with Startup Shell Script, 8-4

your application, 9-10

DECODE SQL function, 10-24, F-1

de-installing the gateway, 4-6

DELETE, 9-8

known restrictions, 2-8

operation, 10-2

SQL clause, 10-31

statement, 10-33

DESCRIBE

character string operations, 10-27

command, known restrictions, 2-5

statement, 8-3, 8-11

diagnostic parameter, C-13

dictionary

also see data dictionary

mapping, 1-6

tables, 10-35

DICTIONARY view, A-12

disk space requirements, 3-3

distributed

operations, DB2, 6-4

queries

example of, 9-6

two-phase commit, 9-7

transaction, C-11

distributed applications

support for, 1-17

distributed data facility (DDF), 6-4

distributed database, 5-3

distributed DRDA transactions, 9-7

distributed processing, 5-3

distributed query optimizer (DQO), 9-5

DRDA-specific parameters, C-7

documentation

recommended, 3-4

required, xx

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

DQO

also see distributed query optimizer, 9-5

DRDA-specific parameters, C-7

drc error code, 13-3

DRDA

catalog, 10-36

database requirements, 3-3

defining number of cursors, 10-36

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-23

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-5

copying data

from Oracle server, 9-9

to Oracle server, 9-10

database link behavior, 10-8

functions, 10-23

languages and character sets in configuration, D-9

stored procedures, 10-5

types supported by gateway, 1-10

DRDA server Logical Unit (LU), 11-4

DRDA session security options, 11-7

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-3

determine SNA V9 value for worksheet, 7-5

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-5, C-7

DRDA_PACKAGE_COLLID parameter, 13-4, C-9

DRDA_PACKAGE_CONSTOKEN parameter, C-9

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

DRDA_PACKAGE_OWNER parameter, C-10

DRDA_PACKAGE_SECTIONS parameter, 10-36, C-10

DRDA_READ_ONLY parameter, 9-8, C-11

DRDA_RECOVER_USERID, 6-3, 6-5, 6-7, 6-9

DRDA_RECOVERY_PASSWORD parameter, 6-3, 6-5, 6-7, C-11

DRDA_RECOVERY_USERID parameter, 6-3, 6-5, 6-7, 6-9, C-11

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-24, F-1

dynamic dictionary mapping, 1-6

EBCDIC, 10-27

character set support, D-7

code page, D-5

DRDA server CCSID, D-11

sort order, 10-25

tables, known restrictions, 2-3

EMP, 9-5

table, 9-9

empproc

stored procedure, 10-5

encryption types for Advanced Security, 5-6

enhancements in this release, 2-2

environment

heterogeneous, 9-8

environmental variable

customized settings in Startup Shell Script, 8-6

NLS_LANG, D-3

ORA_NLS33, D-3

ORACLE_HOME, 4-4

errd, 13-5, C-7

errmc, 13-3, 13-5, C-7

(error tokens), 13-4

field, 13-3

error

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

basic description, 13-2

codes

drc, 13-3

grc, 13-3

communication, 13-3

condition, 13-2

conversion, C-4

date, D-7

diagnosing gateway errors, xix

drc= field

-300xx, 13-6

-7xx, 13-5

HGO-00706, 13-3

host database, 13-6

interpreting error messages, 13-2

mapped sqlstate, 13-4

messages, xx, 10-27, 11-6

messages & codes, 13-1

number, 13-2

obsolete parameters, 12-5

ORA-00001, 13-4

ORA-00942, 13-4, 13-5

ORA-01017, 13-5

ORA-01031, 13-4

ORA-01460, 13-5

ORA-01476, 13-5

ORA-02019, 13-2

ORA-09100, 13-3, 13-4

ORA-09101, 13-3

ORA-1460, C-7

ORA-9100 to ORA-9199, 13-2

Oracle mapped error codes, 13-4

server database, 13-4

specific gateway error codes, 13-5

tokens, 13-3, 13-4

translation, 10-27

while binding the gateway package, 8-7

with Native Semantics, 10-23

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

errp field, 13-3

estimated memory requirement, 3-2

EXCEPT set operator, 10-25

execute authority

DB2/400, 11-9

DB2/UDB, 11-9

DB2/VM, 11-8

on the gateway DRDA package, 11-8

EXECUTE command, 1-7

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

exits

gateway local date, 10-31

EXP SQL function, 10-24, F-1

EXPLAIN PLAN command, 13-7

EXPLAIN_PLAN table, 1-15

export encryption algorithms, 5-5

FDS_CLASS parameter, C-14

FDS_CLASS_VERSION parameter, C-15

FDS_INSTANCE parameter, C-15

features

Oracle Snapshots, 9-8

features of the gateway, 1-14

application development and end-user tools, 1-17

application portability, 1-16

columns supported in a result set, 1-15

distributed applications supported, 1-17

EXPLAIN_PLAN improvement, 1-15

fetch reblocking, 1-14

heterogeneous database integration, 1-15

heterogeneous services architecture, 1-14

large base of data access, 1-16

minimum impact on existing systems, 1-16

Native Semantics, 1-15

Oracle9i passthrough supported, 1-15

performance enhancements, 1-14

remote data access, 1-16

retrieving result sets through passthrough, 1-15

support for TCP/IP, 1-15

fetch reblocking, 1-14, 10-2

fetched date, C-13

fields

errmc, 13-3

errp, 13-3

file member name, 9-4

file members

accessing AS/400 files, 9-4

files

initsid.ora, 13-4, 13-5

listener.ora, 5-4, 8-5

sample, B-1

listener.ora, B-4

tnsnames.ora, B-3

tnsnames.ora, 8-11, 8-12

modifying, 5-4

VSAM, 10-7

FLOOR SQL function, 10-24, F-1

FOR BIT DATA, 10-27, C-4

option, 10-27

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-32

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 10-33, 10-34

DECODE, F-1

DRDA server, 10-23

DUMP, F-1

EXP, F-1

FLOOR, F-1

GREATEST, F-1

HEXTORAW, F-1

INITCAP, F-2

INSTR, F-2

INSTRB, F-2

LAST_DAY, F-2

LEAST, F-2

LENGTH, F-2

LENGTHB, F-2

LN, F-2

LOG, F-2

LOWER, F-2

LPAD, F-2

LTRIM, F-2

MOD, F-1

MONTHS_BETWEEN, F-1

NEW_TIME, F-1

NEXT_DAY, F-1

NLS_INITCAP, F-1

NLS_LOWER, F-1

NLS_UPPER, F-1

NLSSORT, F-1

POWER, F-1

RAWTOHEX, F-1

REPLACE, F-1

ROUND, F-1

ROWID, 2-8

ROWIDTOCHAR, F-1

RPAD, F-1

RTRIM, F-1

SIGN, F-1

SIN, F-1

SOUNDEX, F-1

SQL

SUBSTR, 10-24

TANH, F-2

SQRT, F-2

STDDEV, F-2

SUBSTR, F-2

known restrictions, 2-5

SUBSTRB, F-2

SYSDATE, F-2

TAN, F-2

TO_CHAR, F-2

TO_DATE, 10-28, 10-30, 10-31, 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-10

g4ddview.sql script, 8-10

g4drdrv

former startup program, 8-5

gateway

accessing, 9-4

from other Oracle servers, 8-12

advantages, 1-3

migration and coexistence, 1-9

multisite transactions, 1-8

security, 1-9

server technology and tools, 1-8

site autonomy, 1-9

two-phase commit, 1-8

and Oracle tools, 1-13

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

application tools, 1-17

architecture, 1-10

authenticating logons, 11-2

benefits of integration with 9i server, 1-5

binding DRDA packages, 8-6

components, 1-12

configuration and the Startup Shell Script, 8-4

definition of terms, 1-9

de-installing, 4-6

DRDA package considerations, 8-8

error codes, 13-5

errors detected, 13-3

features, 1-14

how to access, 9-4

installation

log file, 4-6

needs, 4-2

steps, 4-4

steps via Oracle Universal Installer, 4-5

interface, 1-12

local date exit, 10-31

logging, C-12

migration problems, 12-2

parameter, 2-3, 6-10

performance enhancements, 1-14

performing distributed queries, 9-5

read-only option, 9-8

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

settings for security options, 11-4

SQL differences, 1-13

startup time, 8-4

supported languages, D-9

tracing, C-12

tracing SQL statements, 9-10

using, 9-1

with other Oracle products

SQL*Plus, 1-8

Gateway Initialization File

Also See "parameters"

configuring, 8-6

modifying, C-2

parameters, 2-3, 13-9

DRDA_READ_ONLY, 9-8

LOG_DESTINATION, 13-8

new since V4 gateway, 12-3

ORACLE_DRDA_TCTL, 13-8

stored in initsid.ora, C-2

TRACE_LEVEL, 13-8

parameters, list, C-2

reported errors in parameter, 8-7

sample, B-2

gateway name

setting up, with Sunlink, 7-2

gateway performance, 10-23

Gateway System Identifier (SID), 8-4

GCS virtual machine, 11-8

GLOBAL_NAMES

known restrictions, 2-6

GRANT, 11-8

GRANT statement, 8-11

granting authority to a package for DB2, 8-10

GRAPHIC datatype, 10-28

graphic string operations

unsupported, 10-28

grc error code, 13-3

GREATEST SQL function, 10-24, F-1

GROUP BY clause, 10-25

GROUPBY SQL function, 10-25

GTW$_BIND_PKG

internal stored procedure, 8-8

stored procedure, 8-7

hardware requirements, 3-2

HAVING clause, 10-25

HAVING SQL function, 10-25

heterogeneous database integration, 1-15

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

HEXTORAW SQL function, 10-24, F-1

HGO-00706 error, 13-3

host database error, 13-6

host variable, 10-25, 10-27

HS (Heterogeneous Services)

architecture features, 1-14

Oracle Net considerations, 12-5

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

gateway migration problems, 12-2

HS_DB_DOMAIN parameter, 2-6

HS_NLS_DATE_FORMAT, 10-30, D-7

function, 10-30

parameter, 10-30

HS_NLS_DATE_LANGUAGE, D-7

HS_RPC_FETCH_REBLOCKING parameter, 1-14, 10-2

HS_RPC_FETCH_SIZE parameter, 1-14, 10-2

implementation, 1-12

implicit data conversion, 10-23

implicit protocol conversion, 1-6

IMS transaction, 10-7

inbound connections

processing, 11-6

incremental row changes, 9-9

init parameter, 8-5

INITCAP SQL function, 10-24, 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-3

initsid.gtwboot

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

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

NLS parameters, D-6

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

input bind variables, 10-29

INSERT, 9-8

known restrictions, 2-5

operation, 10-2

Oracle SQL command, known restrictions, 2-5

SQL clause, 10-31

statement, 10-30, 10-33

INSERT command, 2-5

supported by COPY, 9-9

installation

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

overview, 4-3

installing the gateway

from CD, 4-4

INSTR SQL function, 10-24, F-2

INSTRB SQL function, 10-24, 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-10

configuration, 8-10

definition, 1-10

errors detected, 13-2

requirements, 3-4

using, in application development, 10-2

internal tracing, C-13

Internet support, 1-5

INTERSECT

SQL set operators and clauses, 10-25

IPC

adapter, B-4

ISO standard, 1-7

isolation level, C-6

JOIN

capability, 1-5

JOIN SQL statement, 10-2

keywords

LISTENER, B-4

known problems, 2-4

compatibility with DB2/UDB, 2-4

known restrictions, 2-5

accessing DB2 alias objects, 2-5

AVS mapping user IDs, 2-5

bind variables become SQL parameter markers, 2-8

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

character set limitation, 2-6

CONNECT BY not supported, 2-8

datatype limitations, 2-6

date arithmetic, 2-7

DD basic tables and views, 2-5

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

DRDA server character sets, 2-6

GLOBAL_NAMES parameter, 2-6

INSERT (Oracle SQL command), 2-5

LONG datatype in SQL*Plus, 2-7

null values and stored procedures, 2-6

Oracle ROWID column, 2-8

row length limitation, 2-7

SAVEPOINT, 2-6

single gateway instances per DRDA network interface, 2-8

SQL*Plus DESCRIBE command, 2-5

string concatenation, 2-6

SUBSTR function post-processed, 2-5

Korn shell

setting ORACLE_HOME variable, 4-4

LANGUAGE parameter, D-6

also see Gateway Initialization File

languages, 1-8

SQL*Plus, 1-8

LAST_DAY function, F-2

LEAST SQL function, 10-24, F-2

LENGTH SQL function, 10-24, F-2

LENGTHB SQL function, 10-24, F-2

link, also see Database Link, 10-7

linkage conventions

SIMPLE WITH NULLS, 10-7

linkname, 8-11

listener, B-4

LISTENER keyword, B-4

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

sample, B-4

literal

character literals, 10-28

date, 10-28

specific datatype, 10-25

TO_DATE, 10-31

LN SQL function, 10-24, F-2

log file, gateway installation, 4-6

LOG SQL function, 10-24, F-2

LOG_DESTINATION parameter, 13-8, 13-9, C-12, C-13

and log files, 13-9

logging, C-12

Logical Unit (LU), 11-4

Login as DBA, 4-4

LONG datatype, 10-27

LONG RAW datatype, 10-27

LOWER SQL function, 10-24, F-2

LPAD SQL function, 10-24, F-2

LTRIM SQL function, 10-24, F-2

LU name, 11-7

LU6.2

protocol, 1-11

SNA APPC, 7-1

mapped sqlstate errors, 13-4

mapping user IDs

AVS, 11-8

known restrictions, 2-5

memory requirement, estimated, 3-2

migrating the gateway instance, 12-5

migration problems, 12-2

MINUS

set operator, 10-25

SQL set operators and clauses, 10-25

Mobile Agents, 1-6

MOD SQL function, 10-24, F-1

Mode_name

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

overview, D-1

Native Semantics, 1-15

parameters, 10-25

with SUBSTR function, 2-5

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-4

NLS_INITCAP SQL function, F-1

NLS_LANG

environmental variable, D-3

parameter

default setting, D-8

syntax, D-8

server-side parameter, D-3

NLS_LOWER SQL function, F-1

NLS_UPPER function, F-1

NLS_UPPER SQL function, F-1

NLSSORT SQL function, 10-24, F-1

non-character binary data, 10-27

NT, 1-16

null

rows, 10-32

values, 10-32

number of cursors, C-10

numbers

concatenation restrictions, 2-6

numeric datatype, 10-32, 10-33

o2pc.sql, 8-10, 9-7

obsolete parameters

DRDA_OVERRIDE_FROM_CODEPAGE, C-7

DRDA_OVERRIDE_TO_CODEPAGE, C-8

DRDA_RDBMS_TYPE, C-11

obsolete parameters since V4 gateway, 12-5

open cursors, at the IBM database, 10-36

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-25

UNION ALL, 10-25

option

binding packages, 8-8

data dictionary views, 10-35

date format string, 10-30

dates, 10-30

DRDA session security, 11-7

FOR BIT DATA, 10-27

for dates in 21st century, 10-30

Oracle server, 1-10

read-only, 9-8

gateway configuration, 1-9

replicating, 9-8

security conduct, 11-6

service port number, C-4

SNA security, 11-4

SQL functions, 10-24

SQL*Plus COPY command, 9-9

ORA_MAX_DATE parameter, C-13

ORA_NLS33 parameter

description, D-3

syntax, D-8

ORA-00001 error, 13-4

ORA-00942 error, 13-4, 13-5

ORA-01017 error, 13-5

ORA-01031 error, 13-4

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-3

ORA1 Oracle instance, 10-3

ORA-1460 error, C-7

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-4

products compatibility, 1-13

RAW datatype, C-4

snapshots, 9-8

stored procedure, defined, 10-3

Oracle Forms

known restrictions, 2-8

Oracle Net, 1-8, 12-5

and application development, 1-17

and distributed processing, 5-3

and remote data access, 1-16

and server coexistence, 1-10

API, 5-2

compatibility with SQL*Net, 5-2

configuring, 5-4

distributed

database, 5-3

processing, 5-3

editing to set up security test, 5-6

Heterogeneous Services (HS) facility, 5-2

introduction, 5-2

operating system authentication, 11-3

overview, 5-2

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-5

terminology, 5-3

client, 5-3

driver, 5-3

host, 5-3

network, 5-3

protocol, 5-3

TNS connect descriptor specification, 9-2

Oracle Replication Services, 9-9

Oracle ROWID column, 2-8

Oracle ROWID function, 2-8

Oracle server dependencies, 2-2

Oracle Universal Installer

de-installing the gateway, 4-6

starting, 4-5

steps to install the gateway, 4-5

upgrading for installation, 4-5

ORACLE_DRDA_TCTL parameter, 13-8, C-13

ORACLE_DRDA_TRACE parameter, C-13

ORACLE_HOME

environmental variable, 4-4

for the gateway, 4-4

ORACLE2PC table, 6-3, 6-5, 6-7, 6-9, 8-7, 8-9, 8-10, 9-7, 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

services, 1-4

database triggers, 1-5

distributed capabilities, 1-5

distributed query optimization, 1-5

SQL, 1-4

stored procedures, 1-5

two-phase commit protection, 1-5

triggers, 9-8

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-3, 6-5, 6-7, 6-9, C-12

ORDER BY clause, 10-25

ORDERBY SQL function, 10-25

overriding codepage, C-7

package

collection id, C-9

consistency token, C-9

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

packed decimal, 10-33

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-25

syntax, C-14

parameter file

tailoring to configure the Sun host, 8-4

parameters

CHARACTER SET, D-4

DB_DOMAIN, 2-6

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-9

DRDA_PACKAGE_SECTIONS, 10-36

DRDA_READ_ONLY, 9-8

DRDA_RECOVERY_PASSWORD, 6-3, 6-5, 6-7

DRDA_RECOVERY_USERID, 6-3, 6-5, 6-7, 6-9

FDS_CLASS, C-14

FDS_CLASS_VERSION, C-15

FDS_INSTANCE, C-15

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-3

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-5, C-7

DRDA_PACKAGE_COLLID, 13-4, C-9

DRDA_PACKAGE_CONSTOKEN, C-9

DRDA_PACKAGE_NAME, 13-4, C-9

DRDA_PACKAGE_OWNER, C-10

DRDA_PACKAGE_SECTIONS, C-10

DRDA_READ_ONLY, C-11

DRDA_RECOVERY_PASSWORD, C-11

DRDA_RECOVERY_USERID, C-11

DRDA_REMOTE_DB_NAME, C-12

DRDA_SECURITY_TYPE, C-12

LOG_DESTINATION, C-12

ORA_MAX_DATE, C-13

ORACLE_DRDA_TCTL, C-13

ORACLE_DRDA_TRACE, C-13

TRACE_LEVEL, C-14

HS_DB_DOMAIN, 2-6

HS_NLS_DATE_FORMAT, 10-30

HS_RPC_FETCH_REBLOCKING, 1-14, 10-2

HS_RPC_FETCH_SIZE, 1-14, 10-2

init, 8-5

LOG_DESTINATION, C-13

LOG_DESTINATON, 13-8

new since V4 gateway, 12-3

NLS_LANG, D-8

obsolete since V4 gateway, 12-5

OPEN_LINKS, 9-3

ORA_NLS33, D-8

PROGRAM, 8-5

renamed since V4 gateway, 12-4

see also Gateway Initialization File, 2-3

setting up trace parameters, 13-7

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

partner LU profile, 7-4

Partner_LU_name

description, 7-4

passthrough, 1-7, 1-15, 10-33, 10-34, 10-35

result sets, 10-33, 10-35

SQL feature, 10-33

patches

required for SunLink 9.0, 3-3

PATH

Side Information Directory for SunLink, 8-6

performance, 10-23

performance enhancements

with fetch reblocking, 10-2

PL/SQL, 10-5

call, 10-6

records, 10-7

routine, 1-7

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-23, 13-7

POWER SQL function, 10-24, F-1

PREPARE TRANSACTION statement, 9-7

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

privileges, 10-35

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

product publications, xx

profile set, 8-12

PROGRAM parameter, 8-5

protocol

commit confirm, 1-9

communications protocols, 5-3

converter, 1-6

definition, 5-3

implicit protocol conversion, 1-6

IPC, 5-4

network, 9-5

Oracle Net Protocol Adapters, 5-2

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-5

RAW datatype, 10-27, C-4

RAWTOHEX SQL function, 10-24, F-1

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

read-only support, 2-3

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