Realia File System Limits

[jpanagia]

Does anyone know what the realia (Version 6) file system limits are? I'm creating an indexed file with around 2,500,000 records, each record contains 829 bytes. I have 6 alternate indexes in addition to the primary index. This program craps out at around 2,050,000 records with status code 98 or 99. The byte count of the file at abend time is a little over 2Gig.

Any Ideas?

TIA, John Panagia

 

[slade]

Hi John,

I have no experience w/Realia, but in a mainframe environment, the access method determines the file size limit. So you may have to pursue the owner of the AM, not necessarily the owner of the compiler.

A PC environment may be different. In any case, once you determine who "owns" the AM, you know your direction.

BTW, at one time 2Gig was the mainframe VSAM limit.

Jack

 

[Crox]

Hi,

There are some parms you can change for indexed files.

You should look it up in the helpfiles which are on the cd you have. They are not all installed by default.

The parms look like this:

[X:Bnn:Rnnnnn:Inn:Hnn:Wnn:Knn:Vn]

B is important I think. Else Andy Ortloff from CA is a great guy to answer your questions on their support site.

Do you use RCOPY to create it from a sequential file?

Regards,

Crox

 

[jpanagia]

Hi Crox,

I wrote a cobol program to create the indexed file. Like I mentioned it processed 95% of the file (About 2.5 hours) and then I got the error. I'm guessing there is a limit on number of bytes or number of records but I can't find it documented. I did fool around with the switches on the file descriptor. I found using [X:I1024} gave the best performance. Below is the select statement form my program.

Thanks.

select Cats
assign to "S:\Data\R_Master.dat[X:I1024]"
organization is Indexed Record Key is I-RecNo of Rout
alternate record key is I-FIPS of Rout with duplicates
alternate record key is I-CD of Rout with duplicates
alternate record key is I-LD of Rout with duplicates
alternate record key is I-SD Of Rout with duplicates
alternate record key is I-RZIP5 Of Rout with duplicates
alternate record key is I-RCITY Of Rout with duplicates
alternate record key is I-LN Of Rout with duplicates
access mode is dynamic.