Re: running SQR (produces reports) on Unix box

[Franck Masson <franck.masson@BRIO.COM>]

Jin,

1)*       For any sqr report processes, if they are not producing any
.lis file (reports) we will try to run them on Unix box (Server) to
improve performance.

IT IS A VERY GOOD IDEA

2) *       Is any software in the market, which allows sqr running on
Unix to produce reports on the NT side (instead of Unix side)

THERE IS ON THE MAKET SOME SOFTWARE THAT ALLOW TO SHARE DISK/DIRECTORY
BETWEEN NT/UNIX.
(LIKE SAMBA or NFS)

3) *       What are your experiences and suggestions?
The best performance is usualy obtain by running SQR on the database
server if this server still have some cpu, I/O available.
If the report provide output, you can put this output to a web/ftp
server or Brio.portal sever to let the user acces to it.
It is easier to maintain a web/ftp server than a file server.
The users with a simple browser can access their report.
Lot of Peoplesoft customer in version 7.5 have this kind of
configuration.

franck,

Lambert, Jin wrote:
>
> Hi, all-
>
> I want to hear from your experts out there, about possibilities of running
> SQR reports on the Unix Server???
>
> (we are on SQR V4.3.4, Peoplesoft 7.52 application with 7.58 tools, the Unix
> server HP-UX 11.0 , the NT server 4 SP 5 and SP 6A)
>
> Current situation in our shop
>
> *       For any sqr report processes, if they are not producing any .lis
> file (reports) we will try to run them on Unix box (Server) to improve
> performance.
>
> *       For any sqr report process producing any type of .lis file
> (reports), we are forced to run them on Client so any produced reports
> (.lis) can be either printed (LPT1), or resided on the local drive (C: ) or
> the network drive (NT) somewhere.
>
> Desired situation
>
> *       We would like to utilize Unix serve's horse power but not sure the
> followings-
>
> *       If the sqr runs on the Unix, then all reports will be generated in
> the Unix directory, how do we efficiently ftp reports back to the NT network
> drive?
> *       Is any software in the market, which allows sqr running on Unix to
> produce reports on the NT side (instead of Unix side)
> *       What are your experiences and suggestions?
>
> -JL
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
org:            Brio Technology EMEA
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
title:          Sales Manager Northern Europe
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard