Hello All,
I have one file which is K type Enscribe Format 1 file. That file is >90% full now.
I wand to make that file to a Format 2 file. The existing file has one altfile. Please suggest.
Or, I can add a new partition (Format 2) to the existing file.
Please give your valuable suggestions.
Thanks,
Indranil
On Monday, October 11, 2021 at 9:59:57 AM UTC-4, indra...@gmail.com wrote:and once its reach there is not option to extend pages also, just create new one with same structure with Format 2 and do renames.
Hello All,
I have one file which is K type Enscribe Format 1 file. That file is >90% full now.
I wand to make that file to a Format 2 file. The existing file has one altfile. Please suggest.
Or, I can add a new partition (Format 2) to the existing file.
Please give your valuable suggestions.
Thanks,There is no such command to convert Format 1 to Format 2 file. You need to create a new file as Format 2 with same structure and copy data from your Format 1 file , that's the only option. I also struggled a lot due to size limit of Format 1 to 2 GB
Indranil
Thanks.
Rajan.
On Monday, October 11, 2021 at 12:04:50 PM UTC-7, Rajan Aggroia wrote:and once its reach there is not option to extend pages also, just create new one with same structure with Format 2 and do renames.
On Monday, October 11, 2021 at 9:59:57 AM UTC-4, indra...@gmail.com wrote:
Hello All,
I have one file which is K type Enscribe Format 1 file. That file is >90% full now.
I wand to make that file to a Format 2 file. The existing file has one altfile. Please suggest.
Or, I can add a new partition (Format 2) to the existing file.
Please give your valuable suggestions.
Thanks,There is no such command to convert Format 1 to Format 2 file. You need to create a new file as Format 2 with same structure and copy data from your Format 1 file , that's the only option. I also struggled a lot due to size limit of Format 1 to 2 GB
Indranil
records that have been deleted from the file, or space at the end of the individual data blocks that was left unused because the SLACK setting for the file said to reserve the space. Whether there is much unused space in the file that can be recoveredThanks.Rajan is correct in what he says, but there are a few things worth noting beyond what he said.
Rajan.
First, if you have not already done this, you might be able to extend the time you can use the existing file if it contains a lot of unused space. The FUP RELOAD command will reorganize the records in the file to remove space that used to be taken by
Rajan said to create a new file that is format 2 and has the same record structure and copy the data into it. That works, but using the FUP LOAD command with the SORTED option is much faster than COPY. COPY will sort the input records, which for alarge input file will take a very long time. When you tell LOAD the data is already sorted in the correct order, which it will be if you are creating the new file with the same key, the input data is already in the correct order, and LOAD will not sort
If you can free up enough room on the volume that contains the current file, you can create the new file on the same volume, giving it a different name. Then, when the new file is loaded and ready to be used, you can rename the original file to someother name, rename the new file to the original name, and you will not have to change any programs or command files that refer to the file name. If you have to create the new file on a different volume, you will either have to change the references to
If the alternate key file is not nearing its size limit, you can make the new data file refer to the original alternate key file AFTER the LOAD is done (create the data file without alternate keys and only add the alternate key descriptions after theLOAD is done). If, for some reason, you want to create a new alternate key file, it is best to create the data file without the alternate keys, then add them after the LOAD is done and use the FUP LOADALTFILE command to load the alternate key file after
No application access to the file being converted should be allowed while the above steps are being done (except FUP RELOAD can be done while the file is accessed normally).
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 294 |
Nodes: | 16 (2 / 14) |
Uptime: | 246:48:25 |
Calls: | 6,626 |
Calls today: | 2 |
Files: | 12,175 |
Messages: | 5,320,794 |