Re: onload - ISAM error

Jeff, You can't use onunload/onload across versions of informix. Onunload does a pages by page unload, at the ISAM level, if the page structure or ISAM file structure has changed in any way you will get errors. Also I have encountered a bug in onunload/onload where if the table has unused pages at the end of the allocation and there should be a bit map page in that area the onload will fail. The only reliable way to copy data from one version to another is by unloading to ascii files ie: dbexport or sql unload statements. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: onload - ISAM error Author: <jeffso@lucent.com> at WCA-INET Date: 20/3/98 7:55 PM I am trying to load ~7G of data using onload utility. The tape was prepared on Infx7.20, and the I am trying to load it onto Infx7.24. It had happened few time, when the first tape is almost done, the onload crash and show the following message : $ onload -t /dev/rst12 -b 96 -s 4000000 amciPlease mount tape and press Return to continue ... ISAM error: Unexpected internal error Checking the log file, I got : ---- 17:15:21 Assert Failed: pthdrpage:ptaltstat2:bad alter slot 17:15:21 Who: Session(19, ap@rodan, 27958, 50709984) Thread(47, onload, 3039558, 3) 17:15:21 Results: Cannot use TBLSpace page for TBLSpace 1048848 17:15:21 Action: Run 'oncheck -pt 1048848' 17:15:21 See Also: /tmp/af.2fea78, shmem.2fea78.0 17:15:22 Assert Failed: pthdrpage:pthdrdrop1:bad alter slot 17:15:22 Who: Session(19, ap@rodan, 27958, 50709984) Thread(47, onload, 3039558, 3) 17:15:22 Results: Cannot use TBLSpace page for TBLSpace 1048848 17:15:22 Action: Run 'oncheck -pt 1048848' 17:15:22 See Also: /tmp/af.2fea78, shmem.2fea78.1 17:15:22 Process exited with return code 1: /bin/sh /bin/sh -cno_log.sh 4 1 "Table failure: 'am ci:"ap".sw_cell'." "pthdrpage:ptaltstat2:bad alter slot" /tmp/a 17:15:22 Process exited with return code 1: /bin/sh /bin/sh -cno_log.sh 4 1 "Table failure: 'TB LSpace 1048848'." "pthdrpage:pthdrdrop1:bad alter slot" /tmp/af.2fea7 -------------- I am sure that we have enough space for the data, infact, I ran onstat -d just before the crash and it showed I have still 5G. Does anyone have an idea why this is happening? Thanks Jeff