I can't get HPL on 11.50.FC1 to work

[Database Administrator]

Connecting to onpload, Please wait...
Successful connection to onpload established
Thu Jul 31 15:34:38 2008

SHMBASE 0x0000004000000000
CLIENTNUM 0x0000000049010000
Session ID 1

Unload Database -> bmn
Query Name -> unload_ev_change
Device Array -> unload_ev_change
Query Mapping -> unload_ev_change
Query -> select * from ev_change for read only
Convert Reject -> /tmp/unload_ev_change.rej
Error occured at HPL failpoint: 11620
0

I set the environment variables based on reading the release notes.

The following two environment variables are required to be set as:

PLOAD_SHMBASE=0x000004000000000
IFX_XFER_SHMBASE=0x000005000000000

[Database Administrator]

On Jul 31, 9:19*pm, bozon wrote:
> Connecting to onpload, Please wait...
> Successful connection to onpload established
> Thu Jul 31 15:34:38 2008
>
> SHMBASE * * * *0x0000004000000000
> CLIENTNUM * * *0x0000000049010000
> Session ID 1
>
> Unload Database -> bmn
> Query Name * * *-> unload_ev_change
> Device Array * *-> unload_ev_change
> Query Mapping * -> unload_ev_change
> Query * * * * * -> select * from ev_change for read only
> Convert Reject *-> /tmp/unload_ev_change.rej
> Error occured at HPL failpoint: 11620
> 0
>
> I set the environment variables based on reading the release notes.
>
> * The following two environment variables are required to be set as:
>
> * * * * PLOAD_SHMBASE=0x000004000000000
> * * * * IFX_XFER_SHMBASE=0x000005000000000

Did you ever get an answer to why this problem was happening

[Uncle Fester]

Originally Posted by KR

On Jul 31, 9:19*pm, bozon wrote:
> Connecting to onpload, Please wait...
> Successful connection to onpload established
> Thu Jul 31 15:34:38 2008
>
> SHMBASE * * * *0x0000004000000000
> CLIENTNUM * * *0x0000000049010000
> Session ID 1
>
> Unload Database -> bmn
> Query Name * * *-> unload_ev_change
> Device Array * *-> unload_ev_change
> Query Mapping * -> unload_ev_change
> Query * * * * * -> select * from ev_change for read only
> Convert Reject *-> /tmp/unload_ev_change.rej
> Error occured at HPL failpoint: 11620
> 0
>
> I set the environment variables based on reading the release notes.
>
> * The following two environment variables are required to be set as:
>
> * * * * PLOAD_SHMBASE=0x000004000000000
> * * * * IFX_XFER_SHMBASE=0x000005000000000

Did you ever get an answer to why this problem was happening

We had exactly the same problem following migration from 10.00.FC6X2 to 11.50.FC1. After much research, IBM Support were able to reproduce the problem on 11.50.FC1 and SLES10, and went on to confirm that the problem was absent under FC2. They say there's a HPL-related fix that "somehow disappeared" from 11.50.FC1, but reappeared in 11.50.FC2!

If you upgrade to 11.50.FC2, you should be fine...

HTH,
Fester