Oracle9i Heterogeneous Connectivity Administrator's Guide -- Index

agent control utility. See agtctl.

agents

Generic Connectivity, 2-4

Heterogeneous Services

architecture, 2-2, 5-2

disabling self-registration, 4-14

registering, 4-10, 4-11, 4-12

types of agents, 2-3

multithreaded Heterogeneous Services, 5-1

specifying initialization parameters for, 4-4

Transparent Gateways, 2-3

agtctl, 5-3, 5-7

commands, 5-7

shell mode commands, 5-12

single-line command mode, 5-8

application development

Heterogeneous Services

controlling array fetches between non-Oracle server and agent, 4-9

controlling array fetches between Oracle server and agent, 4-9

controlling reblocking of array fetches, 4-9

DBMS_HS_PASSTHROUGH package, 3-5

pass-through SQL, 3-5

using bulk fetches, 4-7

using OCI for bulk fetches, 4-8

array fetches, 4-8

agents, 4-9

bind queries

executing using pass-through SQL, 3-11

BIND_INOUT_VARIABLE procedure, 3-6, 3-10

BIND_OUT_VARIABLE procedure, 3-6, 3-10

BIND_VARIABLE procedure, 3-6

buffers

multiple rows, 3-12

bulk fetches

optimizing data transfers using, 4-7

CATHO.SQL script

installing data dictionary for Heterogeneous Services, 4-2

character sets

Heterogeneous Services, A-7

CLOSE_CURSOR function, 3-6

commit point site

commit point strength, A-3

configuring

Generic Connectivity, 7-8

Transparent Gateways, 4-2

copying data

from Oracle database server to SQL Server, 4-16

from SQL Server to Oracle database server, 4-18

INSERT statement, 4-17

SQL*Plus COPY command, 4-16

data dictionary

contents with Generic Connectivity, D-6

installing for Heterogeneous Services, 4-2

mapping for Generic Connectivity, D-6

Oracle server name/SQL Server name, D-6

translation support for Generic Connectivity, D-1

data dictionary views

Generic Connectivity, D-6

Heterogeneous Services, 4-18, D-2

database links

heterogeneous systems, 4-4

date formats

Heterogeneous Services, A-8, A-9

DBMS_HS_PASSTHROUGH package, 3-5

list of functions and procedures, 3-6

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, C-17

describe cache high water mark

definition, A-4

dispatcher threads

multithreaded Heterogeneous Services agents, 5-3, 5-6

distributed queries

optimizing performance, 6-3

drivers

ODBC, 7-13

OLE DB (FS), 7-16

OLE DB (SQL), 7-15

dynamic performance views

Heterogeneous Services, 4-24

determining open sessions, 4-25

determining which agents are on host, 4-24

EXECUTE_IMMEDIATE procedure, 3-7

restrictions, 3-7

EXECUTE_NON_QUERY procedure, 3-6

FDS_CLASS, 4-12

FDS_CLASS_VERSION, 4-12

FDS_INST_NAME, 4-13

FETCH_ROW procedure, 3-7

executing queries using pass-through SQL, 3-11

fetches

bulk, 4-7

optimizing round-trips, 3-12

gateways

how they work, 2-9

Generic Connectivity

architecture, 7-3

Oracle and non-Oracle on same machine, 7-4

Oracle and non-Oracle on separate machines, 7-3

configuration, 7-8

creating initialization file, 7-8

data dictionary

translation support, D-1

defined, 1-3

definition, 7-2

DELETE statement, 7-7

editing initialization file, 7-8

Heterogeneous Services, 2-4

INSERT statement, 7-7

non-Oracle data dictionary access, D-2

ODBC connectivity requirements, 7-13

OLE DB (FS) connectivity requirements, 7-16

OLE DB (SQL) connectivity requirements, 7-15

restrictions, 7-6

setting parameters for ODBC source, 7-10

UNIX, 7-11

Windows NT, 7-10

setting parameters for OLE DB source, 7-12

SQL execution, 7-6

supported functions, 7-7

supported SQL syntax, 7-7

types of agents, 7-2

UPDATE statement, 7-7

generic connectivity

error tracing, A-6

GET_VALUE procedure, 3-7, 3-10

heterogeneous distributed systems

accessing, 4-2

Heterogeneous Services

agent control utility (agtctl), 5-7

agent registration, 4-10

avoiding configuration mismatches, 4-11

disabling, 4-14

enabling, 4-10

self-registration, 4-12

application development

controlling array fetches between non-Oracle server and agent, 4-9

controlling array fetches between Oracle server and agent, 4-9

controlling reblocking of array fetches, 4-9

DBMS_HS_PASSTHOUGH package, 3-5

pass-through SQL, 3-5

using bulk fetches, 4-7

using OCI for bulk fetches, 4-8

creating database links, 4-4

data dictionary views, 4-18, D-2

types, 4-18

understanding sources, 4-19

using general views, 4-20

using SQL service views, 4-22

using transaction service views, 4-21

defining maximum number of open cursors, A-10

dynamic performance views, 4-24

V$HS_AGENT view, 4-24

V$HS_SESSION view, 4-25

Generic Connectivity

architecture, 7-3

creating initialization file, 7-8

definition, 7-2

editing initialization file, 7-8

non-Oracle data dictionary access, D-2

ODBC connectivity requirements, 7-13

OLE DB (FS) connectivity requirements, 7-16

OLE DB (SQL) connectivity requirements, 7-15

restrictions, 7-6

setting parameters for ODBC source, 7-10

setting parameters for OLE DB source, 7-12

SQL execution, 7-6

supported functions, 7-7

supported SQL syntax, 7-7

supported tables, D-6

types of agents, 7-2

initialization parameters, 2-6, 4-5, 7-8, A-1

installing data dictionary, 4-2

multithreaded agents, 5-1

optimizing data transfer, A-10

setting global name, A-4

setting up access using Transparent Gateway, 4-2

setting up environment, 4-2

specifying cache high water mark, A-4

specifying cache size, A-10

specifying commit point strength, A-3

SQL service, 2-5

testing connections, 4-4

transaction service, 2-4

tuning internal data buffering, A-11

tuning LONG data transfer, A-8

HS_AUTOREGISTER initialization parameter

using to enable agent self-registration, 4-14

HS_BASE_CAPS view, 4-19

HS_BASE_DD view, 4-19

HS_CLASS_CAPS view, 4-19

HS_CLASS_DD view, 4-19

HS_CLASS_INIT view, 4-19

HS_DESCRIBE_CACHE_HWM initialization parameter, A-4

HS_FDS_CLASS view, 4-19

HS_FDS_CONNECT_INFO initialization parameter, A-4

specifying connection information, 7-9

HS_FDS_DEFAULT_SCHEMA_NAME initialization parameter, A-5

HS_FDS_FETCH_ROWS initialization parameter, 4-9

HS_FDS_INST view, 4-19

HS_FDS_SHAREABLE_NAME initialization parameter, A-6

HS_FDS_TRACE_LEVEL initialization parameter, A-6

enabling agent tracing, 7-9

HS_LANGUAGE initialization parameter, A-6

HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, A-8

HS_NLS_DATE_FORMAT initialization parameter, A-8

HS_NLS_DATE_LANGUAGE initialization parameter, A-8

HS_NLS_NCHAR initialization parameter, A-9

HS_NLS_TIMESTAMP_FORMAT initialization parameter, A-9

HS_NLS_TIMESTAMP_TZ_FORMAT initialization parameter, A-9

HS_OPEN_CURSORS initialization parameter, A-10

HS_ROWID_CACHE_SIZE initialization parameter, A-10

HS_RPC_FETCH_REBLOCKING initialization parameter, 4-9, A-10

HS_RPC_FETCH_SIZE initialization parameter, 4-9, A-11

HS_TIME_ZONE initialization parameter, A-11

IFILE initialization parameter, A-12

information integration

benefits of Oracle solutions, 1-4

challenges, 1-2

Generic Connectivity, 1-3

how Oracle addresses, 1-2

Messaging Gateway, 1-4

Open System Interfaces, 1-4

Oracle Streams, 1-4

Oracle Transparent Gateways, 1-3

initialization parameters

Heterogeneous Services (HS), 2-6, 4-5, 7-8, A-1

initialization parameters (HS)

common to all gateways, 4-5

descriptions, A-1

Generic Connectivity, 7-8

purpose, 2-6

listeners, 4-2

Messaging Gateway

defined, 1-4

monitor thread

multithreaded Heterogeneous Services agents, 5-3, 5-6

multiple rows

buffering, 3-12

multithreaded Heterogeneous Services agents

administering, 5-7

advantages, 5-3

agent control utility (agtctl), 5-7

architecture, 5-3

configuration parameters, 5-13

dispatcher threads, 5-3, 5-6

monitor thread, 5-3, 5-6

task threads, 5-4, 5-6

National Language Support (NLS)

Heterogeneous Services, A-6

character set of non-Oracle source, A-9

date format, A-8

languages in character date values, A-8

OCI

optimizing data transfers using, 4-8

ODBC agents

connectivity requirements, 7-13

functions, 7-13

ODBC connectivity

data dictionary mapping, D-6

ODBC driver, 7-13

requirements, 7-13

specifying connection information

UNIX, A-5

Windows NT, A-5

specifying path to library, A-6

OLE DB (FS) drivers, 7-16

OLE DB (SQL) drivers, 7-15

OLE DB agents

connectivity requirements, 7-15, 7-16

OLE DB connectivity

data dictionary mapping, D-6

setting connection information, A-5

OLE DB drivers

data provider requirements, 7-16

initialization properties, 7-17

rowset properties, 7-18

Open System Interfaces

defined, 1-4

OPEN_CURSOR procedure, 3-6

operating system dependencies, C-1

Oracle database server

SQL construct processing, 4-14

Oracle Net Services listener, 2-3, 4-2

Oracle precompiler

optimizing data transfers using, 4-8

Oracle Streams

defined, 1-4

Oracle Transparent Gateways

defined, 1-3

optimizing SQL statements, 6-2

using partitioned views, 6-2

OUT bind variables, 3-10

PARSE procedure, 3-6

partition views

using with Oracle Transparent Gateway, 6-2

pass-through SQL

avoiding SQL interpretation, 3-5

executing statements, 3-6

non-queries, 3-7

queries, 3-11

with bind variables, 3-7

with IN bind variables, 3-9

with IN OUT bind variables, 3-10

with OUT bind variables, 3-10

implications of using, 3-6

overview, 3-5

restrictions, 3-6

queries

pass-through SQL, 3-11

reblocking, 4-9

rows

buffering multiple, 3-12

SELECT statement

accessing non-Oracle system, D-2

service names

specifying in database links, 4-4

SQL capabilities

data dictionary tables, 4-23

SQL service

data dictionary views, 2-8, 4-19

Heterogeneous Services, 2-5

views

Heterogeneous Services, 4-22

SQL statements

optimizing distributed, 6-2

Streams

using for heterogeneous connectivity, 3-3

Synonyms, 4-15

task threads

multithreaded Heterogeneous Services agents, 5-4, 5-6

transaction service

Heterogeneous Services, 2-4

views

Heterogeneous Services, 4-21

transparent gateways

accessing Heterogeneous Services agents, 4-2

creating database links, 4-4

installing Heterogeneous Services data dictionary, 4-2

testing connections, 4-4

unsupported functions

Generic Connectivity, 7-7

V$HS_AGENT view

determining which agents are on host, 4-24

V$HS_PARAMETER view

listing HS parameters, 4-26

V$HS_SESSION view

determining open sessions, 4-25

variables

bind, 3-7