Troubleshooting
Problem
onpload gives the error: Error accessing table 'systables', SQL error 100, ISAM error 0 Error occured at HPL failpoint: 11008 when 'onpload -j myloadjob –fl' is run.
Cause
This could occur when dbexport/dbimport is used to load the databases during upgrade.
Resolving The Problem
Check the owner of the tables involved in the onpload job. If the table owner doesn't match the owner of the table when onpload job was created, you get the error.
Error accessing table 'systables', SQL error 100, ISAM error 0
Error occured at HPL failpoint: 11008
[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5;11.7","Edition":"Enterprise;Growth;Ultimate;Workgroup","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
03 June 2021
UID
swg21610012