ca.portal.admin

Jreport

Discussion created by ca.portal.admin on May 22, 2007
Hello Pete:

Thanks for your time and support.

When I look at the particular Queue Records they all have an AP in the
first
two characters of the actual queue record. I can see this when I use
DMLO
GET QUEUE 'Q8DIE027' FIRST and I spoke to the programmer and the first
two
positions are some kind of code that tells the program how to process
this queue
record.

By the way, this is a warning to everyone regarding DMLO GET QUEUE, if
you
use the GET QUEUE command in DMLO be extra careful because the default
on a GET
QUEUE is DELETE, this is what is causing the need for the Jreport. If
you do
not want to delete the QUEUE record you must use syntax like GET QUEUE
'Q8DIE027' FIRST KEEP, if you don't use keep the queue record will be
deleted when
you use a finish. Of course you could always do a ROLLBACK in DMLO
instead
of a finish.

Bill Allen
(704) 641-0296



************************************** See what's free at
http://www.aol.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: Journal buffer waits
"JOURNAL READ WAITS:
Look for a high number of journal read waits which indicate rollback operations. The only way to control read waits is to eliminate abends. During a rollback a single buffer is
dynamically allocated and none of the existing journal buffers are used. Use the Application Monitor batch reports (refer to CA-IDMS Performance Monitor System Administration) to
determine which transactions are experiencing the journal waits.

JOURNAL JBC WAITS:
This field indicates the number of times a task had to wait for space in the journal buffer. You can increase the number of pages in the journal
buffer to remedy this problem. The field is incremented when IDMSDBIO determines that all the pages in the buffer are exclusively held and must therefore wait until a buffer page
becomes available.


Edward A. Timm
Sallie Mae, Senior Database Analyst
ETIMM@salliemae.com
(317) 596-1182
Fax (317) 595-1494
""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV> 05/22/2007 03:55:14 PM >>>
According to report PMIRPT01, one of our production CV's shows a lot of
wait time for ""journal buffer"". Not ""journal I/O"" however. What does
this mean? According to the journal offload report, most journal pages
are 90-100% full, if that is any help.

To further confuse things, report PMIRPT01 shows 105,245 journal buffer
waits for the same time period that ""DCMT DISPLAY STA SYSTEM"" shows 15
buffer waits. Which is correct?

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

This E-Mail has been scanned for viruses.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Areas unlocked while a cv has it in update mode
"Exactely the answer i needed.

Many thanks Bob.

Rene.

Outcomes