Pro-ISAM maximum file size
Posted 27 August 1999 - 12:32 PM
we found the maximum file size we could obtain was 192meg. We
currently upgraded to version 4 of Pro-iv and have found that you
can use the new iscr to get a file up to 384meg. Pro-iv has told
us this is due to the increase (doubling) of the page size from
1500 to 3000. They also told us that they would not support this
maximum file size. We have customers that are fastly approaching
the 192meg limitation and we are contemplating breaking the file
into 2 separate files to eleviate the problem wich we are estimating
at being a pretty good size task. Has anyone else run into the
192meg file limitation and used the 'new' 384meg file size? If so,
have your file(s) exceeded the 192meg size without any ill effects?
I appreciate any comments that you may have on this. Thanks.
FYI - The file that we are having a problem with has 3 re-defines. Our
approach is to have 1 file with the larger of the 3 and the other file
to contain the remaining 2 redefines.
Posted 28 August 1999 - 11:52 PM
C-ISAM supports very large files.
supports alternate indexes
But C-ISAM files are 2-3 times the size per record.
The latest proiv releases supposedly support varialble legnth c-isam files, but I have not been able to creat variable legnth c-isam files with alternate indexes.
The alternate indexes are a great feature...
Posted 29 August 1999 - 06:37 PM
I know how to do it in C++, PRO-IV ltd said that we would have to pay for a special licence for them to develop PRO-IV with variable record length CISAM files.
Posted 29 August 1999 - 07:03 PM
iscr & isin almost support variable legnth C-ISAM.
I can create a variable legnth C-ISAM file. 'bcheck' indicates that the file is a variable record legnth file.
However all my c-iam files have alternate indexes, and I can't figure out how to great a c-isam file with alternate indexes from command line.
Posted 01 May 2000 - 09:05 PM
We were under the impression that files upto 192 MB would not create any problems but we are having problem with certain customized files which are still failing when they reach 64 MB size.
Is there any way with the new version to find out the page length and the maximum size that the file can go upto.
Any help in this matter will be appreciated.
Thanks in Advance.
Posted 02 May 2000 - 09:18 AM
In unix run...
**WARNING: THIS WILL REMOVE ALL DATA IN THE FILE!!!
You must copy the data, do the 'iscr' and then copy the data back in.
With version 4.6r200 and above you can also set the record size to 3000 (I think to give 384MB files) but I'm not sure if this is on all platforms.
Posted 02 May 2000 - 12:32 PM
ischk -v [file]
This will give you the follwing information:
dwm1.pro: 0 records
Page size 512 bytes
Level 0: 1 pages
Level 1: 1 pages
2 total pages, 0 free. 100%
Load factor 0%
The page size determines the maximum file size, for every 512 bytes of paging space you get 32mb added to your file size. In your case the page space for the 64mb file is probably 1024. You can use the isout utility to get all the data out of your file then use the iscr command to recreate at a larger size (iscr -k?? -r1530 [file] -- is max support under 4.0) and then use the isin to put the data back. We have had to do this numerous times, since ProIV only creates files at the least size for the record length.
512 --> 32mb iscr -k? -r250 (or less)
1024 --> 64mb iscr -k? -r500 (251 - 500)
3584 --> 192mb iscr -k? -r1500 (1280 - 1500)
6144 --> 384mb (under 4.6) iscr -k? -r3000
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users