ca.portal.admin

Help with PERFMON Information

Discussion created by ca.portal.admin on Sep 28, 2005
Latest reply on Sep 28, 2005 by ca.portal.admin
Hello All:

We are having a data base performance problem that I am trying to figure
out with an online IDMS CICS Program. Using Performance monitor PMRM PF
6 Transaction Detail I can see the last verb number, current area name
and current record name, but, the last verb number is a 0021, here is
what help says for the Last Verb Number field:

03 Help for Field - Last_Verb_Number
Last Verb identifies the last DML verb issued for a transaction. The
number is assigned to the verb as a major function code (see the
CA-IDMS Programmer's Quick Reference.

Here is the problem, there is no DML Major Function Code of 0021 or 21,
if this field is the IDBMSCOM field, the program does not have an
IDBMSCOM (21), if this value is in hex, then the value would be 33, an
IDBMSCOM (33) is an obtain record name within set using sort key. One
problem with that is that the program does not have an OBTAIN RECORD
WITHIN SET USING SORT-KEY for the record named in the Current Record
name and Current Area Name. The area name and record name in the PMRM
display only has one DML Verb for the named record in the program and
it is a STORE ORDDTL.

The ORDDTL record is getting stored VIA into a sorted chained set, the
set has NP pointers, the set connection is MA, the sort order is ASC and
duplicates are last. I am running an IDMSDBAN now to determine set
lengths but according to the programmer there is a 1 to 25
relationship, 25 member records to each owner record .

The performance problem is that the program is reading approximately
16,000 records or 6,000 pages, the records requested from DB is 16,000
but the records current of transaction is only 28. Since this program
access the area in shared update it appears to be locking every record
it reads, the lock requests are also 16,000, of course this is causing
other tasks that access these records to get a DB-KEY wait and some Dead
Locks.

At this point I am confused by Performance Monitor, does anyone know
what this Last Verb Number Field really is? And can I believe the
Current Record Name and Current Area Name fields?

Bill Allen

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Help with PERFMON Information
"I believe the verb number is the value passed in argument 1, IDBMSCOM(nn),
in the ""Calling Arguments"" documentation. In that case a 21 would be a FIND
FIRST WITHIN area-name - where - area-name is calling argument 2. The verb
numbers in IDBMSCOM(nn) are given as decimal numbers - where (nn) is the
subscript into IDBMSCOM that is passed in the ""call"" statement generated by
the precompiler. The major function code is given as '03'.

HTH - cheers - Gary

Gary Cherlet
Justice Technology Services
Telephone +61 (0)8 8226 5199
Facsimile +61 (0)8 8226 5311
Mobile +61 (0)41 333 1613
MailTo:cherlet.gary@saugov.sa.gov.au

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original transmission
and its contents.
Confidentiality: This e-mail may contain confidential information which
also may be legally privileged. Only the intended recipient(s) may access,
use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are those
of the sender, not Justice Technology Services.
Computer Viruses: It is the recipient's responsibility to check the e-mail
and any attached files for viruses.

Outcomes