RE: START REPORT X TO PIPE Y ?

Hi all, Thanks for that suggestion Bill. I was monitoring the spool area for the report and the report never was produced (not spooled). As I mentioned the report is big (20 MB). Using arrays and cursors the report is churned out. Temp dbspace (400 MB) was used but never beyond the size of the report. I suspect a limit has been hit. My SHMTOTAL is unlimited. How can I find out the memory usage for the user ? I tried onstat -g ses : session #RSAM total used id user tty pid hostname threads memory memory 29 informix - 0 - 0 8192 7052 What unit(Kb/Mb/bytes) is the total memory and used memory measured in? Can I use this to check ? >Subject: RE: START REPORT X TO PIPE Y ? > >Sending the report directly to a printer, as you do here, can result in loss of >the data if the printer or network is down. You can look in your /usr/spool >directory and see if there is a file out there, but in many cases, Unix just >happily spools out the report and thinks it is done, especially if your printers >are all Network printers, and the file will be gone. > >A better solution is to start the report to a literal file (we put it in the >user's home directory to keep from overwriting other user's reports) and then >after the FINISH REPORT, use a RUN statement to initiate the lp command of the >file to the printer. That way if the lp is not successful, you still have a hard >copy of the file you can send to the printer when the user calls and says "my >report didn't print out!". As far as the files go, we use cron jobs to delete >old user files so we don't have any real issue with these lying around forever. > >--- On Wed, 25 Feb 1998 17:55:45 PST SH Lim <sweehock@hotmail.com> wrote: >Yup. There is a finish report later in the code. I've managed to >completed the report to a output file first and it's over 20 MB in size. >Would there be an intermediate file in my OS or is temdbs used or the >report is processed in memory ? >Can anyone help pls. > >>From jleffler@visa.com Tue Feb 24 08:14:39 1998 >>Subject: RE: START REPORT X TO PIPE Y ? >>Date: Tue, 24 Feb 1998 08:15:05 -0800 > >> >>Did you do 'FINISH REPORT X' too? >>If not, then you wouldn't necessarily get any output... >> >>Yours, >>Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> >> >> >>---------- >>From: SH Lim[SMTP:sweehock@hotmail.com] >>Sent: Monday, February 23, 1998 10:47 PM >>To: informix-list@iiug.org >>Subject: START REPORT X TO PIPE Y ? >> >>Hi ! >> I've a problem. My backgroud report process identified with : >>ps -ef | grep myreport.exe >>completed (as the process ends) but my report does not come out. This >>report has been successfuly printed many times. >> >> I figure it could be a problem with my storage. I'm just not sure >>where to look when I do a TO PIPE (file system (?), temdbs or ?) : >>Please feel free to comment. >> >>LET pr_path= "lp -d ", queuename CLIPPED, " > /dev/null" >>... >>. >>START REPORT print_report TO PIPE pr_path >> >>Thanks. >>SH ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com