ca.portal.admin

Re:Help with PERFMON Information

Discussion created by ca.portal.admin on Sep 28, 2005
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
Help with PERFMON Information
"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 (Update)
"Hello All:

I gave the list some bad information. I said the last verb number is 21, but
it is actually a 42. Sorry for the misleading information, old age, bad
eyesight, some times problems I guess!

Anyway, an IDBMSCOM (42) is a STORE, and that is my problem.

The IDMSDBAN ran in step 2 for over 10 hours and received an S 322, this is
a very large area with 8 3390's.

Now that I know the actual DML Verb and record I can narrow the IDMSDBAN
down to just that one set.

It sure would be nice if OPER and PMRM gave you the actual DML Sequence
Number and not the IDBMSCOM value, but, the DML Sequence number is optional,
maybe that is why they use the IDBMSCOM?

Thank you to all who replied so far, once again I apologize for the bad
information.

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
A puzzling question..
"Shortly after upgrading to r14.1 and LE Cobol we started getting UFC6
abends. After much hard work we found the solution to this to be a
program was not added to the sysgen. After adding the program to the
sysgen all was fine.

Now we upgraded to r15.0 and once again were getting a few UFC6 abends.
This time we found the problem to be a decimal divide exception (divide by
zero) .

Looking up UFC6 on the CA web site all references are to optional bit 232
and table procedures. We do not have the SQL option and therefore no
tables and or procedures.

I have tried to look up the UFC6 on the IBM web site to with no good
results.

Does anyone have any idea were I can find documentation on the UFC6 abend.


George Lewandowski
Database Administrator - High Availability Database Support
GTS Database Engineering
Abbott Laboratories
GB17, J46-2E
(847) 938-5526
george.lewandowski@abbott.com

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








Normal

Normal
Re: A puzzling question..
"George,

We just had a bout with a UFC6 error and found a DISPLAY command in a DC COBOL program that was the cause of the problem. Our issue surfaced when the systems group upgraded to z/OS 1.6. Hope this helps.

BTW - FC6 converts to 4038 decimal so it's really a U4038 error.

Jim Criscuolo
Database Specialist, Global Applications
IMS Health®
660 W. Germantown Pike
Plymouth Meeting, PA 19462
voice: 610.834.4684 s fax: 610.834.5180
email: <mailTo:jcriscuolo@us.imshealth.com>
www.imshealth.com

Outcomes