Getting Quiz/QTP SORT to use a different disc.

Tue, 14 Aug 2001 15:09:22 +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_01C124C2.559184E0
Content-Type: text/plain;
	charset="iso-8859-1"

Hi Robert

We do this quite successfully to redirect sort space onto a private volume.
Basically, we set up an account and group on eth PV, and issue:-

FILE HPSORTS1=HPSORTS1.GROUP.ACCOUNT

FILE HPSORTS2=HPSORTS2.GROUP.ACCOUNT

Glance/iX confirms that this works, as do the little green flashing lights.
I'm not sure why your ldev doesn't work, but I'd ask this question on
HP3000-L.

Good luck

Neil

-----Original Message-----
From: Robert Mills [mailto:robert.mills@windsong-services.co.uk]
Sent: 14 August 2001 02:24
To: 'PowerHouse List'
Subject: 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=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_01C124C2.559184E0
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">
<TITLE>Getting Quiz/QTP SORT to use a different disc.</TITLE>

<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY>
<DIV>Hi 
Robert</DIV>
<DIV>&nbsp;</DIV>
<DIV>We do 
this quite successfully to redirect sort space onto a private 
volume.</DIV>
<DIV>Basically, we set up an account and group on eth PV, 
and issue:-</DIV>
<DIV>&nbsp;</DIV>
<DIV>
FILE 
HPSORTS1=HPSORTS1.GROUP.ACCOUNT
FILE 
HPSORTS2=HPSORTS2.GROUP.ACCOUNT
Glance/iX confirms 
that this works, as do the little green flashing lights. I'm not sure why your 
ldev doesn't work, but I'd ask this question on HP3000-L.
Good 
luck
Neil
&nbsp;</DIV>
<BLOCKQUOTE>
 <DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Robert Mills 
 [mailto:robert.mills@windsong-services.co.uk] Sent: 14 August 2001 
 02:24 To: 'PowerHouse List' Subject: Getting Quiz/QTP SORT 
 to use a different disc. </DIV>
 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&nbsp;&nbsp; (PowerHouse&nbsp; 8.19.C5) 
 Copyright 1999 COGNOS INCORPORATED WINDSONG HOLDINGS LIMITED 
 &gt; access product-no-mstr &gt; sort 
 on prod-no &gt; report prod-no &gt; set report limit 10000 &gt; 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&nbsp;&nbsp;&nbsp; | 
 |Tel&nbsp; : +44 (0)1689 870622 
 x3005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 | |Fax&nbsp; : +44 (0)1689 
 899026&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 | |Email: Robert.Mills@windsong-services.co.uk&nbsp; 
 | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ 
 </BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C124C2.559184E0--