My Oracle Support Banner

PAMS ROUTINES OUTPUT CHANGED AFTER APPLYING RP41 (Doc ID 1565849.1)

Last updated on MAY 07, 2020

Applies to:

Oracle MessageQ - Version 5.1 and later
HP OpenVMS Itanium

Goal

pams_qn_to_qtype, pams_qn_to_pid and pams_get_q_counters are showing wrong results after upgrading to 5.01 RP41 from RP33. You can see below that the pams routine output does not match the MGR_UTILITY output(sent, Rcvd and QName columns). Also the PID from pams routine does not match the MGR_UTILITY DQ summary output.
  
The following is a test of the functions pams_qn_to_qtype, pams_qn_to_pid and pams_get_q_counters, for some selected queues. (The same test worked fine in RP33.)
  
  pams_qn_to_qtype -> Q.Name column
  pams_qn_to_pid -> PID column
  pams_get_q_counters -> Counters columns
 
PAMS Routine Output
#######################

  Q.Number Q.Name Q.Type PID Msg.Sent Msg.Received Msg.Pending
  1 Q_WORKFLOW_RW 0 00040000 540673 1124073520 1684439841
  2 Q_WORKFLOW_RW_1 0 0000001D 2105484 1174476811 268447773
  500 +WFL_SV_RW_2_©35_50 0 01800200 771792907 -536859556 3088988
  502 +WFL_SV_RW_2_©37_50 0 8516280A 16777728 29 1713477633


MGR_UTILITY, option Display Queue Detail:
####################################
 

 Que Name Type Sent Rcv'd Memory MRS Quota
  1 Q_WORKFLOW_RW MRQ 0 23871 0 0 35000
  2 Q_WORKFLOW_RW_1 MRQ 0 0 0 0 35000
  500 +WFL_SV_RW_2_©3_500 PQ 1030 572 0 0 64000
  502 +WFL_SV_RW_2_©3_502 PQ 1000 560 0 0 64000

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.