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_01C12560.A665EBB0
Content-Type: text/plain;
charset="iso-8859-1"
My thanks go to Neil (for letting me know how they solved this problem) and
Ken (for explaining why my method did not work).
We've created a group in our 'systems' (NOT SYS) account that sits on a
non-RAID private volume. Then we added a fileeq in our system-wide login
script pointing HPSORTS1 and HPSORTS2 to this group. All works fine now.
-----Original Message-----
From: Ken Paul [mailto:KenRPaul@Concentric.Net]
Sent: 15 August 2001 01:16
To: powerh-l@lists.swau.edu; robert.mills@windsong-services.co.uk
Subject: RE: Getting Quiz/QTP SORT to use a different disc.
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
------_=_NextPart_001_01C12560.A665EBB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
RE: Getting Quiz/QTP SORT to use a different disc.
My thanks go to Neil (for letting me know how they =
solved this problem) and Ken (for explaining why my method did not =
work).
We've created a group in our 'systems' (NOT SYS) =
account that sits on a non-RAID private volume. Then we added a fileeq =
in our system-wide login script pointing HPSORTS1 and HPSORTS2 to this =
group. All works fine now.
-----Original Message-----
From: Ken Paul [mailto:KenRPaul@Concentric.Net]
Sent: 15 August 2001 01:16
To: powerh-l@lists.swau.edu; =
robert.mills@windsong-services.co.uk
Subject: RE: Getting Quiz/QTP SORT to use a =
different disc.
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=3DHPSORTS1.GROUP.ACCOUNT
>
>FILE HPSORTS2=3DHPSORTS2.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=3D12
>:FILE HPSORTS2;DEV=3D15
>: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=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 |
>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ =
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=3D1
:build *foo
:listf foo,2
ACCOUNT=3D =
SYS GROUP=3D =
PUB
FILENAME CODE ------------LOGICAL =
RECORD----------- ----SPACE----
&nb=
sp; SIZE =
TYP =
EOF LIMIT R/B SECTORS #X MX
FOO =
128W =
FB =
0 1023 =
1 0 0 *
:purge foo
:file foo;dev=3D2
: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
------_=_NextPart_001_01C12560.A665EBB0--