Index

A B C D E F G I L M O P Q R S T U V W

A

action items, 5.2

administrative user, creating, 7.7.2.5

authorization for WebSphere MQ objects, 8.1.3

AUTHORIZATION_MODEL parameter, 7.6.2

B

buttons

cancel, 6.1.2

close, 6.1.2

deinstall products, 6.1.2

help, 6.1.2, 6.1.2

installed products, 6.1.2

location, 6.1.2

no, 6.1.2

remove, 6.1.2

save as, 6.1.2

yes, 6.1.2

C

changes in this release

Oracle server dependencies, 2.1.1.1

choosing a repository server, 7.7.1.1

closing a queue, A.2

commit-confirm transactions, 8.2.3.2

configuring

gateway, 7.2

Oracle Net, 7.3

with default values, 7.2.1

without default values, 7.2.2

constant definitions for PGM package, A.6

CREATE DATABASE LINK statement, 7.6.2

ORA-29400, 8.3.2

Strict model, 8.1.2

creating

a database link, 7.6.2

the administrative user, 7.7.2.5

creating alias library, 7.6.4

D

data dictionary

checked by pgvwbrepos.sql script, 7.7.2.2

database link

behavior, 7.6

creating, 7.6.2

determining available links, 7.6.3

DBMS_OUTPUT package, 7.7.1.4, 7.7.2.3, 7.8.1, 7.8.2

DBMS_PIPE package, 7.7.2.3, 7.8.1, 7.8.2

default values

changing during configuration, 7.2.3

deinstall

the Visual Workbench repository, 7.7.4

deinstallation, 6.1

Oracle Discoverer 4i Viewer, 6.1.1

using Oracle Universal Installer, 6.2

DESCRIBE statement, 7.7.1.3, 7.7.1.4

directory, script file, 7.7.1.2

distributed transactions

commit-confirm, 8.2.3.2

recovery requirements, 7.5

dropping alias library, 7.6.5

E

environment variable

MCAUSER, 8.1.2.2

MQ_PASSWORD, 8.1.2.2

MQ_USER_ID, 8.1.2.2

error

error codes, WebSphere MQ, 8.3.1

ORA-29400, 8.3.1

errors

common errors, 8.3.2

common WebSphere MQ errors, 8.3.2

from Oracle server, 8.3.1

from WebSphere MQ, 8.3.1

gateway message format, 8.3.1.1

F

file

default gateway initialization file, 7.2.3.2

file transfer program, 7.7.1.2

function

UTL_RAW.BIT_AND, B.2.2

UTL_RAW.BIT_COMPLEMENT, B.2.3

UTL_RAW.BIT_OR, B.2.4

UTL_RAW.BIT_XOR, B.2.5

UTL_RAW.CAST_TO_RAW, B.2, B.2.6

UTL_RAW.CAST_TO_VARCHAR2, B.2, B.2.7

UTL_RAW.COMPARE, B.2.8

UTL_RAW.CONCAT, B.2, B.2.9

UTL_RAW.CONVERT, B.2.10

UTL_RAW.COPIES, B.2.11

UTL_RAW.LENGTH, B.2.12

UTL_RAW.OVERLAY, B.2.13

UTL_RAW.REVERSE, B.2.14

UTL_RAW.SUBSTR, B.2.15

UTL_RAW.TRANSLATE, B.2.16

UTL_RAW.TRANSLITERATE, B.2.17

UTL_RAW.XRANGE, B.2.18

G

gateway

advantages, 1.3.3

components, 1.3.4

configured with default values, 7.2.1

configured without default values, 7.2.2

default SIDs, 7.2

description, 1.3

directories, 1.3.6

error message format, 8.3.1.1

initialization file, 1.3.2, 7.1

authorization model, 8.1

default, 7.2.3.2

gateway parameters, C.1

with commit-confirm, 8.2.3.2

with transaction log queue, 7.5

known problems and restrictions, 2.3

PGM package, A.1

retrieving messages from a queue, A.3

running environment, 8

security models, 8.1

SID, 7.2.3.1

starting, 1.3.7

structure, initialization file, 1.3.6

terms, 1.3.2

tracing, 8.3.3, C.2.4

using Visual Workbench, 1.3.1

verifying that it works, 8.3.4

Gateway Ininialization File

passwords in, C.2.7

I

initialization file

customizing, 7.2.3.2

default file name, 7.2.3.2

gateway, 1.3.2, 7.1

authorization model, 8.1

default, 7.2.3.2

parameters, C.1

with commit-confirm, 8.2.3.2

with transaction log queue, 7.5

gateway structure, 1.3.6

initsid.ora file, C.1

customizing the gateway initialization file, 7.2.3.2

installation log files, 4.2.1, 4.2.1

installation scripts, 7.7.1.2

installing

the repository, 7.7

IPC protocol, 7.3.2.1, 7.4.2.2

L

listener.ora file, 7.3, 7.3.2.1

for IPC adapter, 7.3.2.1

for TCP/IP adapter, 7.3.2.1

LOG_DESTINATION parameter, 8.3.3, C.2.4

M

MCAUSER environment variable, 8.1.2.2

message queue interface

See MQI, 1.2.1

message queues, definition, 1.2.1

message queuing, description, 1.1

migration tips

PGM package and PG4MQ procedures, A.1.5

MIP

data profiles, B.1

description, 1.3.1, 1.3.2

PGM package, A

PGM_SUP package, A

UTL_RAW functions, B.1

MQ_PASSWORD environment variable, 8.1.2.2

MQ_USER_ID environment variable, 8.1.2.2

MQCLOSE procedure, A.6.5

description, A.2

MQGET procedure

retrieving short messages, A.3

MQI

definition, 1.2.1

gateway calls and structures, A.1

MQBACK, A.1.3

MQCMIT, A.1.3

MQCONN, A.1.3

MQDISC, A.1.3

MQINQ, A.1.4

MQPUT1, A.1.4

MQSET, A.1.4

MQOPEN procedure

description, A.4

opening a queue, A.4

MQPUT procedure

sending short messages, A.5

O

opening a queue, A.4

ORA-08500 error, 8.3.1

Oracle Application Server

reinstallation, 6.2

Oracle applications, 1.3.5.1

Oracle Developer, 1.3.3

Oracle Financials, 1.3.3

Oracle Net

configuring for Oracle server, 7.4

Oracle Procedural Gateway for Message Queuing Visual Workbench

See Visual Workbench, 1.3.1

Oracle server

connected to gateway, 1.3.5.2

error messages, 8.3.1

Oracle server dependencies, 2.1.1.1

Oracle Universal Installer, 4.2.1, 4.2.1, 4.2.2

overview, 4.2

starting, 4.2.2

Oracle9i Application Server

preinstallation tasks, 4.1

oraInventory directory, 4.2.1, 4.2.1, 4.2.1, 4.2.1

overview

Oracle Universal Installer, 4.2

P

package

DBMS_OUTPUT, 7.7.1.4, 7.7.2.3, 7.8.1, 7.8.2

DBMS_PIPE, 7.7.2.3, 7.8.1, 7.8.2

PGM_BQM, 7.7.2.5, 7.8.1, 7.8.2

PGM_SUP, 7.7.2.5, 7.8.1, 7.8.2, A.6

PL/SQL, 7.8.1, 7.8.2, 7.8.3

UTL_PG, 7.7.2.4, 7.8.1, 7.8.2

UTL_RAW, 7.7.1.3, 7.7.2.3, 7.8.1, 7.8.2

parameter

AUTHORIZATION_MODEL, 7.6.2

LOG_DESTINATION, 8.3.3, C.2.4

QUEUE_MANAGER, C.2.3

TRACE_LEVEL, 8.3.3, C.2.4

TRANSACTION_LOG_QUEUE, 8.2.3.2, C.2.5

TRANSACTION_MODEL, 7.5, C.2.6

TRANSACTION_RECOVERY_PASSWORD, 8.2.3.2, C.2.7

TRANSACTION_RECOVERY_USER, 8.2.3.2, C.2.8

pg4mqpwd utility

using, C.2.7

PGM package

description, A.1

error code definitions, A.6.8

unsupported MQI calls, A.1.4

PGM_BQM package, 7.7.2.5, 7.8.1, 7.8.2

PGM_SUP package, 7.7.2.5, 7.8.1, 7.8.2

description, A.6

PGM8.MQOPEN procedure

error condition 2085, 8.3.2

PGMADMIN, 7.7.2.5, 7.7.4.1

pgmdeploy8.sql script, 7.8.1

PGMDEV role, 7.7.3

PGM.MQGMO type definition

description, A.3.2

PGM_SUP constants, A.6.1

PGM.MQMD type definition, A.3.1

PGM_SUP constants, A.6.2

PGM.MQOD type definition

PGM_SUP constants, A.6.3

PGM.MQOPEN procedure

error condition 2085, 8.3.2

PGM_SUP constants, A.6.6

PGM.MQPMO type definition

description, A.5.1

PGM_SUP constants, A.6.4

pgmundeploy.sql script, 7.8.1

pgvwbremove9.sql script, 7.7.4

pgvwbrepos9.sql script, 7.7.2, 7.7.3

PL/SQL

installing missing packages, 7.8.1

package, 7.8.1, 7.8.2, 7.8.3

removing packages, 7.8.3

verifying packages exist, 7.8.1

private access privileges, 7.7.2.6

private repository, 7.7.4.2

privileges, private access, 7.7.2.6

privileges, public access, 7.7.2.6

procedural gateway

database link for access, 7.7.1.5

procedure

MQCLOSE, A.2, A.6.5

MQGET, A.3

MQOPEN, A.4, A.4

MQPUT, A.5

PGM8.MQOPEN, 8.3.2

PGM.MQOPEN, 8.3.2, A.6.6

program

file transfer, 7.7.1.2

protocol

IPC, 7.3.2.1, 7.4.2.2

prvtrawb.plb script, 7.7.1.3

public access privileges, 7.7.2.6

Q

queue

closing, A.2

opening, A.4

QUEUE_MANAGER parameter, C.2.3

R

reinstallation

Oracle Application Server, 6.2

S

script

file directory, 7.7.1.2

pgmdeploy8.sql, 7.8.1

pgmundeploy.sql, 7.8.1

pgvwbremove9.sql, 7.7.4

pgvwbrepos9.sql, 7.7.2, 7.7.3

prvtrawb.plb, 7.7.1.3

test.sql, 8.3.4

utlraw.sql, 7.7.1.3

sending messages

shorter than 32 767 bytes, A.5

SID

default values, 7.2

description, 7.2

length, 7.2.3.1

single-site transactions, 8.2.3.1

software requirements, 3.2

SQL*Net

configuring, 7.3

configuring for gateway, 7.3

purpose, 1.3.5.3

starting, 4.2.2

Oracle Universal Installer, 4.2.2, 4.2.2

statement

CREATE DATABASE LINK, 7.6.2

ORA-29400, 8.3.2

Strict model, 8.1.2

DESCRIBE, 7.7.1.3, 7.7.1.4

strict security model

defined, 8.1.2

system ID

See SID, 7.2

T

TCP/IP protocol, 7.3.2.1, 7.4.2.1

test.sql script, 8.3.4

TNS listener, 7.3

checking status, 7.3.2.2

starting, 7.3.2.2

stopping, 7.3.2.2

tnsnames.ora file, 7.4

trace feature, 8.3.3

TRACE_LEVEL parameter, 8.3.3, C.2.4

transaction capability types

description, 8.2.2

transaction levels

commit-confirm, 8.2.3.2

single-site, 8.2.3.1

transaction log queue

creating, 7.5

TRANSACTION_LOG_QUEUE parameter, 8.2.3.2, C.2.5

TRANSACTION_MODEL parameter, 7.5, C.2.6

TRANSACTION_RECOVERY_PASSWORD parameter, 8.2.3.2, C.2.7

TRANSACTION_RECOVERY_USER parameter, C.2.8

TRANSACTION_RECOVERY_USER parameters, 8.2.3.2

triggers

WebSphere MQ, 1.2.1

U

UTL_PG package, 7.7.2.4, 7.8.1, 7.8.2

UTL_RAW package, 7.7.1.3, 7.7.2.3, 7.8.1, 7.8.2

example of using functions, B.2

function syntax, B.2

UTL_RAW.BIT_AND function, B.2.2

UTL_RAW.BIT_COMPLEMENT function, B.2.3

UTL_RAW.BIT_OR function, B.2.4

UTL_RAW.BIT_XOR function, B.2.5

UTL_RAW.CAST_TO_RAW function, B.2, B.2.6

UTL_RAW.CAST_TO_VARCHAR2 function, B.2, B.2.7

UTL_RAW.COMPARE function, B.2.8

UTL_RAW.CONCAT function, B.2, B.2.9

UTL_RAW.CONVERT function, B.2.10

UTL_RAW.COPIES function, B.2.11

UTL_RAW.LENGTH function, B.2.12

UTL_RAW.OVERLAY function, B.2.13

UTL_RAW.REVERSE function, B.2.14

UTL_RAW.SUBSTR function, B.2.15

UTL_RAW.TRANSLATE function, B.2.16

UTL_RAW.TRANSLITERATE function, B.2.17

UTL_RAW.XRANGE function, B.2.18

utlraw.sql script, 7.7.1.3

V

variable

environment

MCAUSER, 8.1.2.2

MQ_PASSWORD, 8.1.2.2

MQ_USER_ID, 8.1.2.2

Visual Workbench

deinstall repository, 7.7.4

description, 1.3.1

installing the repository, 7.7

MIP, A

W

WebSphere MQ

access authorization, 8.1.3

client configuration definition, 1.2.1

common error messages, 8.3.2

description, 1.2

error codes, 8.3.1

queue manager definition, 1.2.1

triggers, 1.2.1

WebSphere MQ server, 1.3.5.5