Sort file limit -- QTP 843D

[Guy Werry]

Peter,

Perhaps using an indexed subfile would work?  I don't know if the subfiles
under 8.43 would go over 2g, but if they do then setting up an indexed
subfile will give you far faster execution than sorting all of those
records.  When you read the subfile the records get read in the order of the
index, which gives you your sort, with much less overhead than the sort
process.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: Peter Bateman [mailto:pfbcs at hotmail.com]
Sent: Tuesday, February 07, 2006 10:53 AM
To: powerh-l at lists.sowder.com
Subject: Sort file limit -- QTP 843D


Hi all:

Does anybody know of a way to have QTP 843D get by what appears to be a
2G limit on the sort process. HP UX 11?  A run time parameter or an 
environment variable
would be nice.

# of records.            =   4,437,271
   rec size                 =   584

file size                     = 2,591,366,264

Even though I have PHTEMP point to a very large file system.

I get :-

Insufficient disk space for sort.

Regards,
Peter

_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet has

to offer. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt
p://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.