Highlighted
Absent Member.
Absent Member.
235 views

[archive] vision file system -- delete physical?

[Migrated content. Thread originally posted on 23 March 2005]

Again, porting from icobol (native icobol isams + informix cisams) and I'm looking for some detailed technical info on the vision file system, specifically on how it treats deleted records. Delete physical doesn't seem to be an option in the select statement?

If I have a file with very high record turn over (lots of new records daily, 99.9% deleted within hours) and want to maintain a reasonably small file and index tree, am I stuck taking the file offline and sweeping it periodically?

Some isam implementations won't recycle deleted records unless you write an identical primary key, others will recycle them if you do a write and the new index would go in the same 'leaf' of a 'page' where the index for a deleted record is stored? Does anyone know how the vision file system behaves (and/or where I can find detailed technical info for vision)?

Thanks!

Steve
0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

RE: [archive] vision file system -- delete physical?

I'm certainly no expert on VISION details, but I can tell you that the utility "vutil" will eliminate deleted records from the file. Seems like you might need a better way. I'd be interested in hearing a better way if there is one...

Rob
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.