Index

A

administrative user, creating 7.7.2.5
AUTHORIZATION_MODEL parameter 7.6.2
authorization for WebSphere MQ objects 8.1.3

B

Bourne shell
- DISPLAY 4.1.2.3.1
- ORACLE_HOME 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
- TMP 4.1.2.4

C

changes in this release
- Oracle database dependencies 2.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.6
C shell
- DISPLAY 4.1.2.3.1
- ORACLE_HOME 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
- TMP 4.1.2.4

D

database link
- behavior 7.6
- creating 7.6.2
- determining available links 7.6.4
- dropping 7.6.3
- limiting active links 7.6.5
data dictionary
- checked by pgvwbrepos.sql script 7.7.2.2
DBMS_OUTPUT package 7.7.1.5, 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
- using Oracle Universal Installer 6.2
DESCRIBE statement 7.7.1.4, 7.7.1.5
dg4pwd utility
- using C.2.7
directory, script file 7.7.1.2
DISPLAY 4.1.2.3
distributed transactions
- commit-confirm 8.2.3.2
- recovery requirements 7.5
DROP DATABASE LINK statement 7.6.3
dropping a database link 7.6.3
dropping alias library 7.6.7

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 database 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.2
- 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
installation scripts 7.7.1.2
installing
- the repository 7.7
IPC protocol 7.3.2.1, 7.4.2.2

K

Korn shell
- DISPLAY 4.1.2.3.1
- ORACLE_HOME 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
- TMP 4.1.2.4

L

limiting database links 7.6.5
listener.ora file 7.3, 7.3.2.1
- for IPC 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 DG4MQ procedures A.1.5
MIP
- data profiles B.1
- description 1.3.1, 1.3.2
- PGM_SUP package A
- PGM 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_HOME 4.1.2.1
- Bourne shell 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
- C shell 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
- Korn shell 4.1.2.1.1, 4.1.2.1.2, 4.1.2.2.1
- preventing conflicts 4.1.2.1.1
Oracle applications 1.3.5.1
Oracle Application Server
- preinstallation tasks 4.1
Oracle database
- connected to gateway 1.3.5.2
- error messages 8.3.1
Oracle database dependencies 2.1.1
Oracle Database Gateway for WebSphere MQ
- reinstallation 6.2
Oracle Developer 1.3.3
Oracle Financials 1.3.3
Oracle Net
- configuring for Oracle database 7.4
Oracle Net Listener 7.3
- checking status 7.3.2.2
- starting 7.3.2.2
- stopping 7.3.2.2
Oracle Universal Installer 4.2.1, 4.2.2
- overview 4.2
- starting 4.2.2
oraInventory directory 4.2.1
- location 4.2.1
overview
- Oracle Universal Installer 4.2

P

package
- DBMS_OUTPUT 7.7.1.5, 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.4, 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
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
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
PGM8.MQOPEN procedure
- error condition 2085 8.3.2
PGMADMIN 7.7.2.5, 7.7.4.1
PGMDEV role 7.7.3
PGM package
- error code definitions A.6.8
- unsupported MQI calls A.1.4
pgvwbrepos9.sql script 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
preinstallation
- environment variables 4.1.2
  - DISPLAY 4.1.2.3
  - TMP 4.1.2.4
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
procedure
- MQCLOSE A.2, A.6.5
- MQGET A.3
- MQOPEN A.4
- MQPUT A.5
- PGM.MQOPEN 8.3.2, A.6.6
- PGM8.MQOPEN 8.3.2
program
- file transfer 7.7.1.2
protocol
- IPC 7.3.2.1, 7.4.2.2
prvtrawb.plb script 7.7.1.4
public access privileges 7.7.2.6

Q

queue
- closing A.2
- opening A.4
QUEUE_MANAGER parameter C.2.3

R

reinstallation
- Oracle Database Gateway for WebSphere MQ 6.2
relaxed security model, defined 8.1.1
Remote Procedure Call (RPC) 1.3
repository
- choosing a server 7.7.1.1
- deinstall 7.7.4
- development privileges 7.7.3
- installation scripts 7.7.1.2
- installing 7.7
- installing the repository 7.7
- private 7.7.4.2
- server, definition 7.7.1.1
requirements
- hardware 3.1
- software 3.2
retrieving messages
- shorter than 32\ 767 bytes A.3
role
- PGMDEV 7.7.3
root.sh script 5.2

S

script
- file directory 7.7.1.2
- prvtrawb.plb 7.7.1.4
- test.sql 8.3.4
sending messages
- shorter than 32 767 bytes A.5
setting
- DISPLAY 4.1.2.3
- TMP 4.1.2.4
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
statement
- CREATE DATABASE LINK 7.6.2
  - ORA-29400 8.3.2
  - Strict model 8.1.2
- DESCRIBE 7.7.1.4, 7.7.1.5
- DROP DATABASE LINK 7.6.3
strict security model
- defined 8.1.2
- running root.sh 5.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
TMP 4.1.2.4
tnsnames.ora file 7.4
TRACE_LEVEL parameter 8.3.3, C.2.4
trace feature 8.3.3
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
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
triggers
- WebSphere MQ 1.2.1

U

upgrade the Visual Workbench Repository 7.7.1.3
UTL_PG package 7.7.2.4, 7.8.1, 7.8.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
UTL_RAW package 7.7.1.4, 7.7.2.3, 7.8.1, 7.8.2
- example of using functions B.2
- function syntax B.2

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
- development privileges for repository 7.7.3
- installing the repository 7.7
- MIP A
Visual Workbench Repository
- upgrade 7.7.1.3

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