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.
Was this topic helpful?
Document Information
Modified date:
03 June 2021
UID
swg21683918