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 laterHP 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
#######################
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:
####################################
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 |