Tobias asked: > But i now want to know, where does DFSORT get the information how much storage is allocated to other DFSORT instances.
Ahead of Dave Betten (of DFSORT Development) answering here's a reply that I hope will be useful to you... Individual DFSORT instances DON'T communicate with each other. But they do ascertain the state of available memory using the STGTEST SYSEVENT system call. Since 1997 - when we introduced "Dynamic Hipersorting" with Release 13 - these checks for available memory happen at various stages during the SORTIN phase (while the work files are being built). This "repetitive checking" regime reduces the risk of two sorts grabbing "the same piece" of memory. Note: By using STGTEST SYSEVENT DFSORT is actually conditioning its usage not just relative to other DFSORT invocations but relative to other address spaces and system conditions in general. In short, even in the same address space (which is one of the DB2 Version 8 Utilities scenarios - with Parallel Index Build etc) DFSORT invocations don't communicate with each other. But then you don't need them to. :-) Dave's a great friend and I'm sure he'll give you a better answer. But he won't give it to you for another 4 or 5 hours. :-) Cheers, Martin Martin Packer Performance Consultant IBM United Kingdom Ltd +44-20-8832-5167 +44-7802-245-584 [EMAIL PROTECTED] Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
