- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Sort and the SortworkN files
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:13 AM
тАО08-22-2005 04:13 AM
1. Find the blocksize of the file(s) to be sorted.
2. Mutliply that by 3.
3. Assign sortworkN to as many "N" as needed to obtain the "3-times-blocksize" space.
I usually assign the space so that Sortwork1 has the most space, Sortwork2 has the second most space, etc. But it seems that VMS always rearranges things so that the first disk used is the one with the least space, and so on.
Is this true? If so, why?
Dom
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 04:50 AM
тАО08-22-2005 04:50 AM
Re: Sort and the SortworkN files
Are we talking about sorting variable record length sequential files?
Sort sizes the work file based on the longerst record length. So if that is 'way off' then you may end up using much more work space than you actually need. Typically this is seen with LRL=32767. Trim that back to the actual longerst record and you may be much better of.
How big a sort are we talking about Gigabytes?
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 05:28 AM
тАО08-22-2005 05:28 AM
Re: Sort and the SortworkN files
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 06:31 AM
тАО08-22-2005 06:31 AM
Re: Sort and the SortworkN files
Hmmm, under 600MB. Just sort in memory?
(needs big pgflqquo and such!)
Also, did you try & compare with Hypersort or good'ole sort?
Best I understand Sort will write 'runs' of sorted data to a scratch file for as long as it can, then switch to the next file for the next run and so on untill all done. At then end it merges those pre-sorted runs back together into a single output.
The (dis)order withing the input data will influence which workfile will get use more or less.
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 09:53 AM
тАО08-22-2005 09:53 AM
SolutionHow SORT chooses which disk to allocate workspace to is not documented and subject to change.
I think the only way SORT knows how much space is available on a particular disk is by an extend failure, so I doubt the behaviour you observe is deliberate. More likely it's a "last in first out" consequence of the way you order your work files. Have you tried reversing your order of definitions?
That said, it really shouldn't matter which way you define the logical names, or the order which SORT uses them.
Search the source code [SORT32.LIS] if you really want to find out the design decisions, but please DON'T make your application dependent on undocumented behaviour.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 06:40 PM
тАО08-22-2005 06:40 PM
Re: Sort and the SortworkN files
due to size of your file may be hypert-sort can't work. See HP note
http://h71000.www7.hp.com/doc/731FINAL/4493/4493pro_060.html#4493_sor_chap
About work files.
HP documentation says:
Consider the following when you assign work files to devices:
- Assign work files to the fastest devices available. For example, random-access, mass storage devices such as disks.
- Choose devices with the least activity and the most space available.
- Assign each work file to a different physical device to maximize overlapping input and output.
Therefore SORT choice is not only depending by your declaration.
HP documentatio says too:
If Sort requires work files (for example, if you are sorting a large file), a larger working set can increase sort efficiency. However, if your system is used heavily, it might be unable to allocate all the pages in the working set extent to your process. This can result in paging, which occurs when the operating system transfers parts of a process between physical memory and memory on a paging device; only the active part of the process remains in the physical memory. To avoid excessive paging, you can decrease the working set extent for your process. (Use the SET WORKING_SET command to decrease the working set extent.)
For furthermore information read here
http://h71000.www7.hp.com/doc/731FINAL/6489/6489pro_023.html
Antonio Vigliotti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-22-2005 07:30 PM
тАО08-22-2005 07:30 PM
Re: Sort and the SortworkN files
For diagnostic purposes, I would be interested in your checking the following items:
- please give us the results of a SHOW LOGICAL SORTWORK*
- the quotas for your account on each of the disks identified in the step above
- a SHOW PROCESS/QUOTAS and SHOW PAGE from your SORT process before the operation.
While I would, as John mentioned, not RELY on undocumented SORT behavior, it is useful at least in understanding what is happening (and reporting behavior anomalies to Engineering).
One that I am curious about is the possibility that the relationship between free space and available space quota on your disks is reversed, namely, that the disk on which you (by your quota) have the most free space is also has the least overall free space available.
There are other posssibilities. In other situations, I have seen SORT have problems if certain UAF parameters were set in what would seem innocuous ways.
- Bob Gezelter, http://www.rlgsc.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-23-2005 03:30 AM
тАО08-23-2005 03:30 AM
Re: Sort and the SortworkN files
" due to size of your file may be hypert-sort can't work. See HP note
http://h71000.www7.hp.com/doc/731FINAL/4493/4493pro_060.html#4493_sor_
chap "
Why would you conclude that? Please explain such that we can fix the documentation if needed. Best I know the file size has no implication on whether hypersort can be used or not. ALL the doc indicates is that you may have to be more carefull with workingset / quota setting.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-23-2005 03:38 AM
тАО08-23-2005 03:38 AM
Re: Sort and the SortworkN files
don't angry :-)
HP suggests in linked documentation don't use hyper-sort in large files.
I don't know why, I merely extracted a little sentence of guide.
Antonio Vigliotti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-23-2005 10:48 AM
тАО08-23-2005 10:48 AM
Re: Sort and the SortworkN files
I am not angry, just dumb.
I fail to see the line that made you conclude hypersort can not do large files.
I woudl like to know which line that was to try to understand whether there is perhaps a misunderstanding an how we can clarify this in the future.
Is it the note "Memory allocation differences may limit the high-performance Sort/Merge utility's ability to perform the same number of concurrent sort operations as the Sort/Merge utility can perform in the same amount of virtual memory" ?
Feel free to send Email on this in order not to clutter this topic: firstname@company.com
Mind you, I am intested to know whether Dominic tried hypersort vs classic sort and what his experince might be.
Thanks,
Hein.