In this blog post, let’s learn about the error message “172 ISAM error: Unexpected internal error.” in Hydra and the description of the error.
Error Message
172 ISAM error: Unexpected internal error.
Error Details
A program that uses a particular locking method or index-node size has attempted to access an ISAM file that was created using a different locking method or index-node size.
If you are migrating files from a platform that uses another index-node size, you must run the bcheck or secheck utility with the -s option against all of the ISAM files (.dat and .idx) to resize the index nodes.
For INFORMIX-SE, if you are migrating applications between platforms that use different locking methods, you must set the environment variable RESETLOCK to convert ISAM files as you access them. You can access all files for a given database by running UPDATE STATISTICS in that database, if time permits.
For C-ISAM applications, if you are migrating applications between platforms that use different locking methods, you must set the environment variable RESETLOCK to convert C-ISAM files as you access them.