HPL and PDQ
IDS 9.40FC3W2 on HP-UX11.11
I'm running an onpload (HPL) run job which is loading 35m rows to a table
then enabling the indexes. The index "enable", which I understand to be an
ordinary build in a different jacket, is taking much longer than I'd expect.
I can see from the marvellous new onstat -g env facility that PDQPRIORITY
and PSORT_DBTEMP env variables have not been picked up by the onpload, which
I conclude is responsible for the slowness. If I then just run the
re-enable SQL as ordinary SQL from the same shell the variables are picked
up (you can see this from the output below).
Obviously running the index separately is a straigtforward workaround which
isn't that inconvenient. But does anyone know why HPL doesn't pick up the
PDQ variables?
thanks
Neil
# Enable index as HPL
informix@hamilton[/exports/neil/ardistrib] onstat -g env 145
IBM Informix Dynamic Server Version 9.40.FC3W2 -- On-Line -- Up
04:42:38 -- 2125352 Kbytes
Environment for session 145:
Variable Value [values-list]
CLIENT_LOCALE en_US.819
CLNT_PAM_CAPABLE 1
DBDATE DMY4/
DBDATE DMY4/
DBDELIMITER |
DBPATH .
DBPATH .
[.]
[//lawson_live_shm]
DBPRINT lp -s
DBTEMP /tmp
DB_LOCALE en_US.819
INFORMIXDIR /opt/informix/9.40
[/opt/informix/9.40]
[/usr/informix]
INFORMIXSERVER lawson_live
INFORMIXTERM termcap
KAIOON 1
LC_COLLATE en_US.819
LC_CTYPE en_US.819
LC_MONETARY en_US.819
LC_NUMERIC en_US.819
LC_TIME en_US.819
LKNOTIFY yes
LOCKDOWN no
NODEFDAC no
[no]
[no]
ONCONFIG onconfig.1
PATH
/opt/informix/9.40/bin:/opt/informix/9.40/bin:/usr/bin:/opt
/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:
/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/b
in:/opt/resmon/bin:/opt/scr/bin:/usr/dt/bin:/usr/bin/X11:/
usr/contrib/bin/X11:/opt/mx/bin:/usr/sbin/stm/uut/bin/prog
s:/opt/langtools/bin:/opt/perf/bin:/opt/imake/bin:/opt/ign
ite/bin:/usr/local/vnc:/opt/emc/SInquiry/V4.2/bin:/opt/prm
/bin:/opt/hpnpl//bin:.:/opt/Migration/bin:/usr/vue/bin
PSORT_NPROCS 12
SERVER_LOCALE en_US.819
SHELL /usr/bin/ksh
SINGLELEVEL no
TBCONFIG onconfig
TERM vt100
[vt100]
[dumb]
TERMCAP /etc/termcap
TZ GMT0BST
# Enable index as SQL
Environment for session 162:
Variable Value [values-list]
CLIENT_LOCALE en_US.8859-1
CLNT_PAM_CAPABLE 1
DBDATE DMY4/
DBDATE DMY4/
DBDELIMITER |
DBPATH .
[.]
[//lawson_live_shm]
DBPATH .
DBPRINT lp -s
DBTEMP /tmp
INFORMIXDIR /opt/informix/9.40
[/opt/informix/9.40]
[/usr/informix]
INFORMIXSERVER lawson_live
INFORMIXTERM termcap
KAIOON 1
LC_COLLATE en_US.819
LC_CTYPE en_US.819
LC_MONETARY en_US.819
LC_NUMERIC en_US.819
LC_TIME en_US.819
LKNOTIFY yes
LOCKDOWN no
LOCKDOWN no
NODEFDAC no
[no]
[no]
ONCONFIG onconfig.1
PATH
/opt/informix/9.40/bin:/opt/informix/9.40/bin:/usr/bin:/opt
/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:
/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/b
in:/opt/resmon/bin:/opt/scr/bin:/usr/dt/bin:/usr/bin/X11:/
usr/contrib/bin/X11:/opt/mx/bin:/usr/sbin/stm/uut/bin/prog
s:/opt/langtools/bin:/opt/perf/bin:/opt/imake/bin:/opt/ign
ite/bin:/usr/local/vnc:/opt/emc/SInquiry/V4.2/bin:/opt/prm
/bin:/opt/hpnpl//bin:.:/opt/Migration/bin:/usr/vue/bin
PDQPRIORITY 100
PSORT_DBTEMP
/opt/lawsonV7/lawson/print,/opt/lawsonV7/archive,/opt/lawso
nV7
PSORT_NPROCS 12
SERVER_LOCALE en_US.819
SHELL /usr/bin/ksh
SINGLELEVEL no
SUBQCACHESZ 10
TBCONFIG onconfig
TERM vt100
[vt100]
[dumb]
TERMCAP /etc/termcap
TZ GMT0BST