ca.portal.admin

A puzzling question..

Discussion created by ca.portal.admin on Sep 28, 2005
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
This communication is intended for the use of the recipient to which it is addressed, and may contain confidential, personal and or privileged information. Please contact us immediately if you are not the intended recipients of this communication, and do not copy, distribute, or take action relying on it. Any communication received in error, or subsequent reply, should be deleted or destroyed.

"
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 (Another Update)
"Hello All:

I really am not blind, there is a discrepancy between OPER and PMRM.

OPER says the verb # is 42 and PMRM says the VERB # is 21, this is easy to
catch because it runs so long, I can switch between OPER and PMRM while it is
executing.

I believe OPER as it has been around a lot longer.

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
Another Perfmon question
"When a Performance Monitor report lists the CPU used by a dialog, does
that only include CPU generated by the dialog itself? Or does it also
include CPU used by the CV doing work on the dialog's behalf, such as
I/O's?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov

"
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 (Final Update)
"Hello Everyone:

After a 12 hour IDMSDBAN run report 5 told the truth, the whole truth and
nothing but the truth. There were five sets with set lengths greater than 512
members and the maximum set length was approximately 16,545 members.


So much for the programmer stating the set length was approximately 1 to 20!


If you remember this was a sorted chained set, so in order to insert a new
member in it's proper position the DBMS has to start at the owner and follow
the chain looking for the insertion point.

In addition I also ran journal reports that showed the records requested to
match with what IDMSDBAN reported.

Now to fix it, based on a few responses I received it seems that it should
be converted to a user owned index set, anybody have any other thoughts?

Thanks to everyone who responded for your time and support.

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
"Bill,

The verb number is the IDBMSCOM field. I do not remember if this is hex or
not, but I think it is hex. Appendix D in the DML Reference COBOL contains
the lay out of the verb call formats and corresponding IDBMSCOM. There is a
value of 21 listed:

¦ FIND FIRST WITHIN¦ 21 ¦ area-name ¦
¦ ¦ ¦
¦ ¦ area-name ¦ ¦ ¦

Assuming it is a hex value then 33 is:

¦ FIND record-name ¦ 33 ¦ record-name ¦ set-name ¦
sort-key ¦ ¦
¦ ¦ WITHIN ¦ ¦ ¦
¦ ¦ ¦
¦ ¦ set-name USING ¦ ¦ ¦
¦ ¦ ¦
¦ ¦ sort-key ¦ ¦ ¦


Would not the DBMS be generating this FIND internally in order to set proper
currency for storing the record in the sorted set? I have used this value
before from PERFMON often in the past to debug problems and I always found
it to be accurate. I just cannot remember for certain if it is in hex, but
the FIND within sorted set makes more since than FIND first within area.

Good Luck,

John Collins

858-826-3463

Outcomes