Sort file limit -- QTP 843D

[Joe Boyle]

I thought that this was limited to cisam, could it be that the version of
cisam you are accessing is not the latest shipped with PH ? 

I thought I understood that the latest version of cisam, shipped with PH8,
is capable of handling 2 Gig (i.e. 2^31) records of any acceptable (to pdl)
byte size.

Is it possible that it is the Unix environment that is limiting the sort
file size ?

I seem to recall seeing a comment suggesting you create an indexed subfile
on the sort key; I realize that this would take a long time to populate, but
then you could use 'choose viaindex idxname' with 'sorted on idxname_col'
syntax and avoid a sort.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Peter Bateman
Sent: 07 February 2006 16:53
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 MSNR 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.