- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- The Sort Utility and available diskspace
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 04:18 AM
тАО08-22-2005 04:18 AM
%SORT-E-WRITEERR, error writing _HSD10$DIA140:[PATENTS]SORTWORK.TMP;
-SYSTEM-F-EXDISKQUOTA, disk quota exceeded
We're of two minds here. Some of us say that this "E" error for sort and the "F" error from system are handled by the Sort Utility, so that it just goes to the next SortworkN disk. Proof of this is that Sort does not just die, but continues on and reports its statistics correctly.
Others say it is an "E" and "F" error, and therefore the results of the sort are not correct.
Any ideas?
Dom
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 04:46 AM
тАО08-22-2005 04:46 AM
Re: The Sort Utility and available diskspace
>> Some of us say that this "E" error for sort and the "F" error from system are handled by the Sort Utility.
Agreed. This can happen with diskspace and also virtual memory (where sort switches to disk earlier then it intended).
>> ;
-SYSTEM-F-EXDISKQUOTA, disk quota exceeded
Quota exceeded is kind of a silly reason to run into trouble isn't it? Or is this just meant as an example and are you mostly concerned about really running out of actual disk space.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 04:53 AM
тАО08-22-2005 04:53 AM
Re: The Sort Utility and available diskspace
HELP /MES WRITEERR WRITEERR
WRITEERR, error writing 'file-spec'
Facility: Shared by several facilities
Explanation: During an OpenVMS RMS file system operation, an error is
encountered while writing a file.
If this error occurred during a macro assembly operation,
the assembler encountered an I/O error when writing to the
output object module or listing file; 'file-spec' is the file
specification of the file being written.
User Action: Determine that the file is open and that you have write
access. If this is a macro assembly error, retry the assembly.
If the error is reproducible, notify your system manager.
I think your sorted file is not correct. However I don't risk lost data :-!
Antonio Vigliotti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 05:32 AM
тАО08-22-2005 05:32 AM
Re: The Sort Utility and available diskspace
Antoniov -- I'm aware of the explanation, but the question remains, "Is sort handling this error? If not, why does it not just crash?"
Thanks to both of you guys.
Dom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 06:35 AM
тАО08-22-2005 06:35 AM
SolutionUse /STAT to confirm that there were as many input records as output records.
I'll include a most exquisite answer from an orginal sort engineer from our archives:
Hien.
----------------------------------------
Note 24.10 Strange SORT behaviour
CLT::GILBERT "Multiple inheritence happens" 4-OCT-1988
----------------------------------------
> We will consider down grading the error message to warning.
Thanks. I'm guilty of rampant conservatism for making it E-level in the first place. The code that diagnoses this problem *does* continue gracefully, and *does* produce correct results; so an I-level diagnostic seems most appropriate -- strangely enough!
%SORT-I-WRITEERR, Error writing to your scratch file
-SYSTEM-F-HEADCRASH, Head crash on disk
-SYSTEM-F-SMITHEREENS, Disk exploded and caught on fire
%SORT-S-TIMEX, But VAX Sort/Merge takes a licking and keeps on ticking!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 06:54 AM
тАО08-22-2005 06:54 AM
Re: The Sort Utility and available diskspace
And I always include a "/Stat" qualifier, and I always check the $Status symbol.
Thanks again,
Dom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 10:30 AM
тАО08-22-2005 10:30 AM
Re: The Sort Utility and available diskspace
As Hein has pointed out, it takes a seriously bad event to break SORT. Just check the stats.
There are techniques for creating sort work areas that permit sortwork files to bypass disk quotas.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 10:51 AM
тАО08-22-2005 10:51 AM
Re: The Sort Utility and available diskspace
That's interesting. Can you give me some hints?
Dom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 03:51 PM
тАО08-22-2005 03:51 PM
Re: The Sort Utility and available diskspace
Sure, In the Guide to OpenVMS Security manual you'll find a cookbook example of a "project directory". This is a directory owned by a resource identifier, with access control lists and identifier's granted to allow authrized users to create files in that directory. The files will be owned by the identifier, and therefore subject to the identifier's quota, rather than the quota of the creator.
One thing to be a bit wary of is to make sure each user specifies unique file names for their SORTWORK files (especially concurrent users). Otherwise theycan tread on each others toes. If you're running a late enough version use F$UNIQUE()
$ DEFINE SORTWORK1 PROJDIR1:'F$UNIQUE()
$ DEFINE SORTWORK2 PROJDIR2:'F$UNIQUE()
etc...
The only issue here is users can create other files in the same directory, and consume any extended quota. Simple way around that is to regularly delete anything not currently open.
A possible alternative which might be more bullet proof (but I've never tested), you could install SORT32 as a protected subsystem image. Work areas could be setup to only be writeable from the SORT32 image.
See the Guide to OpenVMS System Security for details on protected subsystems - they're an incredibly powerful, but little used feature of OpenVMS. In effect they allow you to bind a set of objects to a specific set of images. For example, some data files that can only be read or written from certain applications.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 07:15 PM
тАО08-22-2005 07:15 PM
Re: The Sort Utility and available diskspace
as other thread I report same link
http://h71000.www7.hp.com/doc/731FINAL/6489/6489pro_023.html
where you can see some hints about sort.
Antonio Vigliotti