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 dddPlease 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_PAGESMAX_FILL_DATA_PAGES 1echo "drop database ddd"|dbaccess -
Database dropped.
onload -t /tmp/ddd.unl -b 1024 dddPlease 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 dddPlease 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.
↪ replying to Philip Yeh
Hi Philip,
thanks for reporting!
APAR IT47284 created ... and already fixed (fix going to be available in next fixpack).
For the time being I guess the obvious workaround - temporarily turning off MAX_FILL_DATA_PAGES - will be good enough.
BR,
Andreas
------------------------------
Andreas Legner
Dev Engineer
HCL Software
------------------------------