Getting Quiz/QTP SORT to use a different disc.

[Ken Paul]

Hi Robert,

At 03:09 PM 8/14/01 +0200, Neil Harvey wrote:
>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  | 
>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ 

The reason that Neil Harvey's example works and yours does not is because he
is redirecting the file to another group which is on the other volume set
and is HOMEVS'd to that volume set.  Your file equation is just telling the
system to build the file in the CURRENT group and account but on an ldev
that is on another volume set and this will not work.  As an example I tried
to do a similar test by specifying a file equation to an ldev and then doing
a back referenced build and here is what I got:

:file foo;dev=1
:build *foo
:listf foo,2
ACCOUNT=  SYS         GROUP=  PUB     

FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----
                  SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX

FOO               128W  FB           0       1023   1        0  0  *


:purge foo
:file foo;dev=2
:build *foo
DEVICE UNAVAILABLE  (FSERR 55)
Build of file "*FOO" failed. (CIERR 279)

The second BUILD failed because LDEV 2 is on a different volume set than
LDEV 1 which is on the SYSTEM volume set.

Hope this helps,

Ken

Ken Paul
Independent Consultant & Contract Programmer
KenRPaul@Concentric.Net
(303) 694-0920