Informix 14.10.FC10 onload error occurred:
ISAM error: illegal argument to ISAM function.
Error building TBLspace.
After testing, it was found that the reason is because the MAX_FILL_DATA_PAGES parameter is set to 1. If it is set to 0, no error will occur. Even if the DB is empty, such an error will occur. The steps to reproduce are as follows:
touch /tmp/ddd.unl
chmod 660 /tmp/ddd.unl
echo "create database ddd with log" | dbaccess -
Database created.
Database closed.
onunload -t /tmp/ddd.unl -b 1024 ddd
Please mount tape and press Return to continue ...
Please label this as tape number 1 in the tape sequence.
onstat -g cfg|grep MAX_FILL_DATA_PAGES
MAX_FILL_DATA_PAGES 1
echo "drop database ddd"|dbaccess -
Database dropped.
onload -t /tmp/ddd.unl -b 1024 ddd
Please mount tape and press Return to continue ...
ISAM error: illegal argument to ISAM function.
Error building TBLspace.
onmode -wf MAX_FILL_DATA_PAGES=0
Value for MAX_FILL_DATA_PAGES (0) was saved in config file.
Value of MAX_FILL_DATA_PAGES has been changed to 0.
onload -t /tmp/ddd.unl -b 1024 ddd
Please mount tape and press Return to continue ...
The load has successfully completed.
In addition, I have tested the 12.10, 11.70, and 11.50 versions and there will be no errors in onload. There will be no errors in 14.10.FC1. However, starting from 14.10.FC2, the onload will have errors because MAX_FILL_DATA_PAGES is set to 1.
------------------------------
Philip Yeh
------------------------------