Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
High-Performance Loader User's GuideThe describes how to use the HCL Informix® to load and unload large quantities of data efficiently to or from Informix® databases.
The onpload utilityThis section describes how to use the onpload utility.
Load data into collection data type columns

Load data into collection data type columns

The onpload utility might need to create temporary smart large objects while loading data into collection data type columns. To create temporary smart large objects, onpload obtains sbspace information from the SBSPACETEMP configuration parameter, or if that parameter is not set, from the SBSPACENAME configuration parameter. For more information about temporary sbspaces, see the Informix® Administrator's Guide.

If onpload does not find a temporary sbspace, the load job fails with the following error message in the onpload log file:

Fatal error in server row processing - SQL error -9810 ISAM error -12053

If you see the error message shown previously in onpload log file, configure a temporary sbspace by using the SBSPACETEMP configuration parameter or a default sbspace by using the SBSPACENAME configuration parameter and then restart the load job.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.