Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Expand all | Collapse all

Informix 14.10.FC10 onload error occurred: ISAM error: illegal argument to ISAM function. Error building TBLspace.

  • 1.  Informix 14.10.FC10 onload error occurred: ISAM error: illegal argument to ISAM function. Error building TBLspace.

    Posted Tue November 19, 2024 08:46 PM
    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.



  • 2.  RE: Informix 14.10.FC10 onload error occurred: ISAM error: illegal argument to ISAM function. Error building TBLspace.

    Posted Wed November 20, 2024 10:37 AM

    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
    ------------------------------