IBM Support

HPL loader fails to unload data - Informix Server 12.10 on Linux:

Troubleshooting


Problem

HPL generates error and fails to unload data.

Symptom

    Log file indicates error as shown below:

      > cat customers.log
      Connecting to onpload, Please wait...
      Successful connection to onpload established
      Wed Sep 15 09:18:12 2014

      SHMBASE        0x0000000044000000
      CLIENTNUM      0x0000000049010000
      Session ID 1

      Unload Database -> tomtmp
      Query Name      -> customer
      Device Array    -> customer
      Query Mapping   -> customer
      Query           -> select * from 'informix'.customer  for read only
      Convert Reject  -> /tmp/customer.rej
      Fatal error getting stream buffer from server         <--------  Error
      Error occured at HPL failpoint: 10561             <---------

Cause

Server was unable to load the pload library.

Resolving The Problem

Set the following environment variable with values specified:

   PLOAD_SHMBASE to 0x000004000000000  and
   IFX_XFER_SHMBASE to 0x000005000000000

For example, in K-Shell:

   export PLOAD_SHMBASE=0x000004000000000
   export IFX_XFER_SHMBASE=0x000005000000000

and then rerun the HPL utility to unload data.


This information, value for PLOAD_SHMBASE and IFX_XFER_SHMBASE, are also mentioned in the machine notes.

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"12.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 June 2021

UID

swg21683918