1. Index

Index

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

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