The legacy of bad chunk names
Posted in 2000
Lateral thinking please!
When I joined my client's site they were already on IDS v7.24, but all the
chunk names are /opt/informixV7.13/dbspaces1/lawson_default_1 etc. It was
set up this way because of a lack of foresight by the DBA.
Now we're on v9.20, but still with the /opt/informixV7.13 ... chunknames!
It's really quite confusing but, more importantly, it's high;y unpleasing
aesthetically. I can't see that we can ever get away from it. IDS 9.20 has
re-introduced the old v7.24 bug in onunload where it tries to put indexes
into into their original dbspaces (well done those people in QA!). But even
if they hadn't, a "feature" of IDS9.2x, hightlighted by Art Kagel et al, is
that you cannoy use onunload to unload a database converted from v7.2x.
The database in question is over 200GBytes in size. So dbexport is
untenable. Are we destined to be stuck with informixV7.13 names forever?