Index

A

administrative user, creating 1
AUTHORIZATION_MODEL parameter 1
authorization for WebSphere MQ objects 1

B

Bourne shell
- DISPLAY 1
- ORACLE_HOME 1, 2, 3
- TMP 1

C

changes in this release
- Oracle database dependencies 1
choosing a repository server 1
closing a queue 1
commit-confirm transactions 1
configuring
- gateway 1
- Oracle Net 1
- with default values 1
- without default values 1
constant definitions for PGM package 1
CREATE DATABASE LINK statement 1
- ORA-29400 1
- Strict model 1
creating
- a database link 1
- the administrative user 1
creating alias library 1
C shell
- DISPLAY 1
- ORACLE_HOME 1, 2, 3
- TMP 1

D

database link
- behavior 1
- creating 1
- determining available links 1
- dropping 1
- limiting active links 1
data dictionary
- checked by pgvwbrepos.sql script 1
DBMS_OUTPUT package 1, 2, 3, 4
DBMS_PIPE package 1, 2, 3
default values
- changing during configuration 1
deinstall
- the Visual Workbench repository 1
deinstallation 1
- using Oracle Universal Installer 1
DESCRIBE statement 1, 2
dg4pwd utility
- using 1
directory, script file 1
DISPLAY 1
distributed transactions
- commit-confirm 1
- recovery requirements 1
DROP DATABASE LINK statement 1
dropping a database link 1
dropping alias library 1

E

environment variable
- MCAUSER 1
- MQ_PASSWORD 1
- MQ_USER_ID 1
error
- error codes, WebSphere MQ 1
- ORA-29400 1
errors
- common errors 1
- common WebSphere MQ errors 1
- from Oracle database 1
- from WebSphere MQ 1
- gateway message format 1

F

file
- default gateway initialization file 1
file transfer program 1
function
- UTL_RAW.BIT_AND 1
- UTL_RAW.BIT_COMPLEMENT 1
- UTL_RAW.BIT_OR 1
- UTL_RAW.BIT_XOR 1
- UTL_RAW.CAST_TO_RAW 1, 2
- UTL_RAW.CAST_TO_VARCHAR2 1, 2
- UTL_RAW.COMPARE 1
- UTL_RAW.CONCAT 1, 2
- UTL_RAW.CONVERT 1
- UTL_RAW.COPIES 1
- UTL_RAW.LENGTH 1
- UTL_RAW.OVERLAY 1
- UTL_RAW.REVERSE 1
- UTL_RAW.SUBSTR 1
- UTL_RAW.TRANSLATE 1
- UTL_RAW.TRANSLITERATE 1
- UTL_RAW.XRANGE 1

G

gateway
- advantages 1
- components 1
- configured with default values 1
- configured without default values 1
- default SIDs 1
- description 1
- directories 1
- error message format 1
- initialization file 1, 2
  - authorization model 1
  - default 1
  - gateway parameters 1
  - with commit-confirm 1
  - with transaction log queue 1
- known problems and restrictions 1
- PGM package 1
- retrieving messages from a queue 1
- running environment 1
- security models 1
- SID 1
- starting 1
- structure, initialization file 1
- terms 1
- tracing 1, 2
- using Visual Workbench 1
- verifying that it works 1
Gateway Ininialization File
- passwords in 1

I

initialization file
- customizing 1
- default file name 1
- gateway 1, 2
  - authorization model 1
  - default 1
  - parameters 1
  - with commit-confirm 1
  - with transaction log queue 1
- gateway structure 1
initsid.ora file 1
- customizing the gateway initialization file 1
installation log files 1
installation scripts 1
installing
- the repository 1
IPC protocol 1, 2

K

Korn shell
- DISPLAY 1
- ORACLE_HOME 1, 2, 3
- TMP 1

L

limiting database links 1
listener.ora file 1, 2
- for IPC adapter 1
LOG_DESTINATION parameter 1, 2

M

MCAUSER environment variable 1
message queue interface
- See MQI 1
message queues, definition 1
message queuing, description 1
migration tips
- PGM package and DG4MQ procedures 1
MIP
- data profiles 1
- description 1, 2
- PGM_SUP package 1
- PGM package 1
- UTL_RAW functions 1
MQ_PASSWORD environment variable 1
MQ_USER_ID environment variable 1
MQCLOSE procedure 1
- description 1
MQGET procedure
- retrieving short messages 1
MQI
- definition 1
- gateway calls and structures 1
- MQBACK 1
- MQCMIT 1
- MQCONN 1
- MQDISC 1
- MQINQ 1
- MQPUT1 1
- MQSET 1
MQOPEN procedure
- description 1
- opening a queue 1
MQPUT procedure
- sending short messages 1

O

opening a queue 1
ORA-08500 error 1
ORACLE_HOME 1
- Bourne shell 1, 2, 3
- C shell 1, 2, 3
- Korn shell 1, 2, 3
- preventing conflicts 1
Oracle applications 1
Oracle Application Server
- preinstallation tasks 1
Oracle database
- connected to gateway 1
- error messages 1
Oracle database dependencies 1
Oracle Database Gateway for WebSphere MQ
- reinstallation 1
Oracle Developer 1
Oracle Financials 1
Oracle Net
- configuring for Oracle database 1
Oracle Net Listener 1
- checking status 1
- starting 1
- stopping 1
Oracle Universal Installer 1, 3
- overview 1
- starting 1
oraInventory directory 1
- location 1
overview
- Oracle Universal Installer 1

P

package
- DBMS_OUTPUT 1, 2, 3, 4
- DBMS_PIPE 1, 2, 3
- PGM_BQM 1, 2, 3
- PGM_SUP 1, 2, 3, 4
- PL/SQL 1, 2, 3
- UTL_PG 1, 2, 3
- UTL_RAW 1, 2, 3, 4
parameter
- AUTHORIZATION_MODEL 1
- LOG_DESTINATION 1, 2
- QUEUE_MANAGER 1
- TRACE_LEVEL 1, 2
- TRANSACTION_LOG_QUEUE 1, 2
- TRANSACTION_MODEL 1, 2
- TRANSACTION_RECOVERY_PASSWORD 1, 2
- TRANSACTION_RECOVERY_USER 1, 2
PGM_BQM package 1, 2, 3
PGM_SUP package 1, 2, 3
- description 1
PGM.MQGMO type definition
- description 1
- PGM_SUP constants 1
PGM.MQMD type definition 1
- PGM_SUP constants 1
PGM.MQOD type definition
- PGM_SUP constants 1
PGM.MQOPEN procedure
- error condition 2085 1
- PGM_SUP constants 1
PGM.MQPMO type definition
- description 1
- PGM_SUP constants 1
PGM8.MQOPEN procedure
- error condition 2085 1
PGMADMIN 1, 2
PGMDEV role 1
PGM package
- error code definitions 1
- unsupported MQI calls 1
pgvwbrepos9.sql script 1
PL/SQL
- installing missing packages 1
- package 1, 2, 3
- removing packages 1
- verifying packages exist 1
preinstallation
- environment variables 1
  - DISPLAY 1
  - TMP 1
private access privileges 1
private repository 1
privileges, private access 1
privileges, public access 1
procedure
- MQCLOSE 1, 2
- MQGET 1
- MQOPEN 1
- MQPUT 1
- PGM.MQOPEN 1, 2
- PGM8.MQOPEN 1
program
- file transfer 1
protocol
- IPC 1, 2
prvtrawb.plb script 1
public access privileges 1

Q

queue
- closing 1
- opening 1
QUEUE_MANAGER parameter 1

R

reinstallation
- Oracle Database Gateway for WebSphere MQ 1
relaxed security model, defined 1
Remote Procedure Call (RPC) 1
repository
- choosing a server 1
- deinstall 1
- development privileges 1
- installation scripts 1
- installing 1
- installing the repository 1
- private 1
- server, definition 1
requirements
- hardware 1
- software 1
retrieving messages
- shorter than 32\ 767 bytes 1
role
- PGMDEV 1
root.sh script 1

S

script
- file directory 1
- prvtrawb.plb 1
- test.sql 1
sending messages
- shorter than 32 767 bytes 1
setting
- DISPLAY 1
- TMP 1
SID
- default values 1
- description 1
- length 1
single-site transactions 1
software requirements 1
SQL*Net
- configuring 1
- configuring for gateway 1
- purpose 1
starting 1
- Oracle Universal Installer 1
statement
- CREATE DATABASE LINK 1
  - ORA-29400 1
  - Strict model 1
- DESCRIBE 1, 2
- DROP DATABASE LINK 1
strict security model
- defined 1
- running root.sh 1
system ID
- See SID 1

T

TCP/IP protocol 1, 2
test.sql script 1
TMP 1
tnsnames.ora file 1
TRACE_LEVEL parameter 1, 2
trace feature 1
TRANSACTION_LOG_QUEUE parameter 1, 2
TRANSACTION_MODEL parameter 1, 2
TRANSACTION_RECOVERY_PASSWORD parameter 1, 2
TRANSACTION_RECOVERY_USER parameter 1
TRANSACTION_RECOVERY_USER parameters 1
transaction capability types
- description 1
transaction levels
- commit-confirm 1
- single-site 1
transaction log queue
- creating 1
triggers
- WebSphere MQ 1

U

upgrade the Visual Workbench Repository 1
UTL_PG package 1, 2, 3
UTL_RAW.BIT_AND function 1
UTL_RAW.BIT_COMPLEMENT function 1
UTL_RAW.BIT_OR function 1
UTL_RAW.BIT_XOR function 1
UTL_RAW.CAST_TO_RAW function 1, 2
UTL_RAW.CAST_TO_VARCHAR2 function 1, 2
UTL_RAW.COMPARE function 1
UTL_RAW.CONCAT function 1, 2
UTL_RAW.CONVERT function 1
UTL_RAW.COPIES function 1
UTL_RAW.LENGTH function 1
UTL_RAW.OVERLAY function 1
UTL_RAW.REVERSE function 1
UTL_RAW.SUBSTR function 1
UTL_RAW.TRANSLATE function 1
UTL_RAW.TRANSLITERATE function 1
UTL_RAW.XRANGE function 1
UTL_RAW package 1, 2, 3, 4
- example of using functions 1
- function syntax 1

V

variable
- environment
  - MCAUSER 1
  - MQ_PASSWORD 1
  - MQ_USER_ID 1
Visual Workbench
- deinstall repository 1
- description 1
- development privileges for repository 1
- installing the repository 1
- MIP 1
Visual Workbench Repository
- upgrade 1

W

WebSphere MQ
- access authorization 1
- client configuration definition 1
- common error messages 1
- description 1
- error codes 1
- queue manager definition 1
- triggers 1
- WebSphere MQ server 1