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_01C124BB.EEF3E490 Content-Type: text/plain; charset="iso-8859-1" Hi fellow listers. Environment: HPe3000/979-200 + MPE/iX 6.5 + PowerHouse 819C5 Due to performance reasons, the machine nearly dies, we need to have Quiz and QTP to use a non-RAID disc for it's sort work files. Each account on our system has a group that is placed on a volume set that only has non-RAID disc's. Any job that needs to perform a large sort, 10000 plus records, has to logon to this group. Recently I've seen it written that HP's SORT uses HPSORTS1 and HPSORTS2 as the name of it's sort/scratch files. Therefore, if I file equate them to a non-RAID disc then that should work. Does it hell!! Results of my attempt are shown below. Anybody have any ideas? There IS enough space on BOTH of these drives. :FILE HPSORTS1;DEV=12 :FILE HPSORTS2;DEV=15 :QUIZ Q U I Z (PowerHouse 8.19.C5) Copyright 1999 COGNOS INCORPORATED WINDSONG HOLDINGS LIMITED > access product-no-mstr > sort on prod-no > report prod-no > set report limit 10000 > go *E* There was a sort error. *E* The Scratch file cannot be opened. Sort error encountered: QUIZ terminating. RUN QUIZ.CURRENT.COGNOS;INFO="";PRI=DS;XL="*PHLIBODX *PHLIBXL *ORDBA ORACLEXL.PUB.ORACLEM" Program terminated in an error state. (CIERR 976) : regards, +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ |Robert W.Mills (Systems Development Manager) | |Windsong Services, St. Mary Cray, ENGLAND | |Tel : +44 (0)1689 870622 x3005 | |Fax : +44 (0)1689 899026 | |Email: Robert.Mills@windsong-services.co.uk | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ ------_=_NextPart_001_01C124BB.EEF3E490 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">Getting Quiz/QTP SORT to use a different disc. Hi fellow listers.
Environment: HPe3000/979-200 + MPE/iX 6.5 + = PowerHouse 819C5
Due to performance reasons, the machine nearly dies, = we need to have Quiz and QTP to use a non-RAID disc for it's sort work = files. Each account on our system has a group that is placed on a = volume set that only has non-RAID disc's. Any job that needs to perform = a large sort, 10000 plus records, has to logon to this = group.
Recently I've seen it written that HP's SORT uses = HPSORTS1 and HPSORTS2 as the name of it's sort/scratch files. = Therefore, if I file equate them to a non-RAID disc then that should = work. Does it hell!! Results of my attempt are shown below.
Anybody have any ideas? There IS enough space on BOTH = of these drives.
:FILE HPSORTS1;DEV=3D12
:FILE HPSORTS2;DEV=3D15
:QUIZQ U I Z (PowerHouse 8.19.C5)
Copyright 1999 COGNOS INCORPORATED
WINDSONG HOLDINGS LIMITED> access product-no-mstr
> sort on prod-no
> report prod-no
> set report limit 10000
> go
*E* There was a sort error.
*E* The Scratch file cannot be opened.
Sort error encountered: QUIZ terminating.RUN = QUIZ.CURRENT.COGNOS;INFO=3D"";PRI=3DDS;XL=3D"*PHLIBODX = *PHLIBXL *ORDBA ORACLEXL.PUB.ORACLEM"
Program terminated in an error state. (CIERR = 976)
:regards,
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
|Robert W.Mills (Systems Development Manager) = |
|Windsong Services, St. Mary Cray, = ENGLAND |
|Tel : +44 (0)1689 870622 = x3005 &= nbsp; |
|Fax : +44 (0)1689 = 899026 = |
|Email: Robert.Mills@windsong-services.co.uk = |
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
------_=_NextPart_001_01C124BB.EEF3E490--