Problem Solved
Neil Harvey
neil@nha.co.za
Fri, 21 Jul 2000 13:19:25 +0200
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF305.8748AE21
Content-Type: text/plain;
charset="iso-8859-1"
Why not simply open the largest file the operating system will allow
(currently 4GB on MPE/iX 6.0)? So calculate the number of records as 4GB /
Recsize, and "open" the output file as that.
MPE only allocates sectors as it needs them, I think, so a big file that can
hold 4 million 1024Byte records but ends up with 1 record in it takes 256
sectors (see below).
Or am I off the track here?
Neil
/:l bigfile,2
ACCOUNT= NHA GROUP= DEV
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----
SIZE TYP EOF LIMIT R/B SECTORS #X MX
BIGFILE 1024B FA 1 4000000 1 256 1 32
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: 21 July 2000 10:24
To: powerh-l@sphere.swau.edu
Subject: RE: Problem Solved
I would be amazed if we hadn't encountered this one in the deep dark distant
past. Now that the problem has been solved (thanks Mike), I realize what's
happening. We use the REPORT LIMIT for all sorts of disk file limits because
MPE/iX doesn't have dynamic disk allocation. When you create the file you
need a size. So what do we use on the report file to disc? The REPORT LIMIT
of course. Not counting on there being any headings and footings in the
report (du-uh) :-(
I don't know if there's anything we can do physically in QUIZ to resolve
this. Logically, you'd think that we could count the expected lines, but we
don't know how many control breaks there will be.
However, I do agree that the report should not output what it does. Please
file this as a bug. We should abort the report if the output disk file
overflows. If you can get the bug number, please send it to me and I'll see
what I can do. This really is a report integrity problem. Imagine if you
were printing checks/cheques.
Bob Deskin
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com
(613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
-----Original Message-----
From: Ron Burnett [mailto:ron@cryptic.rch.unimelb.edu.au]
Sent: July 20, 2000 8:38 PM
To: powerh-l@sphere.swau.edu
Cc: juristam@cryptic.rch.unimelb.edu.au; anna@cryptic.rch.unimelb.edu.au
Subject: Problem Solved
At 18:07 20/07/2000 -0400, Mike Godsey wrote:
>I have had this happen before. Increase the process/report limit. What
>happens is it creates a fixed size file that completely fills and then PH
>resets the file and continues to write records beginning again at the start
>of the file.
This was the perfect solution ...... the output file was being closed on
reaching its limit, and then reset and re-opened leaving me with only
the tail end of what I expected.
It would be nice if there were more intelligent clues printed in the
STDLIST. Does anyone else see this as a bug (or at the very least,
an unfriendly feature)? QUIZ should abort on reaching an output file
limit. Its not much use getting an output file that doesn't contain what
your program asks for.
Many thanks to all who replied to my message.
Ron Burnett
Women's & Children's Health
Melbourne, Australia
ron@lis.rch.unimelb.edu.au
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
------_=_NextPart_001_01BFF305.8748AE21
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=798571411-21072000>Why
not simply open the largest file the operating system will allow (currently
4GB on MPE/iX 6.0)? So calculate the number of records as 4GB / Recsize, and
"open" the output file as that.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=798571411-21072000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=798571411-21072000>MPE
only allocates sectors as it needs them, I think, so a big file that can hold 4
million 1024Byte records but ends up with 1 record in it takes 256 sectors
(see below).</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=798571411-21072000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=798571411-21072000>Or am
I off the track here?</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=798571411-21072000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=798571411-21072000>Neil</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=798571411-21072000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=798571411-21072000><FONT
face=r_ansi size=2><FONT face=r_ansi size=2>
<P>/:l bigfile,2</P>
<P>ACCOUNT= NHA GROUP= DEV </P>
<P>FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----</P>
<P>SIZE TYP EOF LIMIT R/B SECTORS #X MX</P>
<P>BIGFILE 1024B FA 1 4000000 1 256 1 32</P>
<P> </P>
<P> </P></FONT></FONT></SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Deskin, Bob
[mailto:Bob.Deskin@Cognos.COM]<BR><B>Sent:</B> 21 July 2000
10:24<BR><B>To:</B> powerh-l@sphere.swau.edu<BR><B>Subject:</B> RE: Problem
Solved<BR><BR></DIV></FONT>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=040071908-21072000>I
would be amazed if we hadn't encountered this one in the deep dark distant
past. Now that the problem has been solved (thanks Mike), I realize what's
happening. We use the REPORT LIMIT for all sorts of disk file limits because
MPE/iX doesn't have dynamic disk allocation. When you create the file you need
a size. So what do we use on the report file to disc? The REPORT LIMIT of
course. Not counting on there being any headings and footings in the report
(du-uh) :-(</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=040071908-21072000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=040071908-21072000>I
don't know if there's anything we can do physically in QUIZ to resolve this.
Logically, you'd think that we could count the expected lines, but we don't
know how many control breaks there will be.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=040071908-21072000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=040071908-21072000>However, I do agree that the report should not output
what it does. Please file this as a bug. We should abort the report if the
output disk file overflows. If you can get the bug number, please send it to
me and I'll see what I can do. This really is a report integrity problem.
Imagine if you were printing checks/cheques.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=040071908-21072000>
<P><FONT size=2>Bob
Deskin <BR>PowerHouse
Web Product Manager and Senior Product Advisor<BR>Application Development
Tools, Cognos Inc.<BR>bob.deskin@cognos.com<BR>(613) 738-1338 ext 4205
FAX: (613) 228-3149<BR>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON
K1G 4K9 CANADA<BR></FONT></P></SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Ron Burnett
[mailto:ron@cryptic.rch.unimelb.edu.au]<BR><B>Sent:</B> July 20, 2000 8:38
PM<BR><B>To:</B> powerh-l@sphere.swau.edu<BR><B>Cc:</B>
juristam@cryptic.rch.unimelb.edu.au;
anna@cryptic.rch.unimelb.edu.au<BR><B>Subject:</B> Problem
Solved<BR><BR></DIV></FONT><FONT size=3>At 18:07 20/07/2000 -0400, Mike
Godsey wrote:<BR>>I have had this happen before. Increase the
process/report limit. What<BR>>happens is it creates a fixed size file
that completely fills and then PH<BR>>resets the file and continues to
write records beginning again at the start<BR>>of the file. <BR><BR>This
was the perfect solution ...... the output file was being closed
on<BR>reaching its limit, and then reset and re-opened leaving me with
only<BR>the tail end of what I expected.<BR><BR>It would be nice if there
were more intelligent clues printed in the<BR>STDLIST. Does anyone
else see this as a bug (or at the very least,<BR>an unfriendly
feature)? QUIZ should abort on reaching an output file<BR>limit.
Its not much use getting an output file that doesn't contain what<BR>your
program asks for.<BR><BR>Many thanks to all who replied to my
message.<BR><BR>Ron Burnett<BR>Women's & Children's Health<BR>Melbourne,
Australia<BR>ron@lis.rch.unimelb.edu.au<BR></FONT><BR>= = = = = = = = = = =
= = = = = = = = = = = = = = = = = = = = = = = = = = = Subscribe: "subscribe
powerh-l" in message body to majordomo@lists.swau.edu Unsubscribe:
"unsubscribe powerh-l" in message to majordomo@lists.swau.edu This list is
closed, thus to post to the list, you must be a
subscriber.</BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01BFF305.8748AE21--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.