Re: HPL and PDQ
--0__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462
Content-type: multipart/alternative;
Boundary="1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462"
--1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Hi Neil,
How are u running the onpload. Are you using ipload or onpladm?
If that is the case then we might not be passing these environment
varaibles to onpload.
If onpload is being used to run the job then I see not reason why we do=
not
pickup the PDQPRIORITY=3D1 variable.
Regards,
Pravin.
=
"Neil Truby" =
<neil.truby@arden =
ta.com> =
To
Sent by: informix-list@iiug.org =
owner-informix-li =
cc
st@iiug.org =
Subj=
ect
HPL and PDQ =
08/18/2004 03:19 =
PM =
=
=
Please respond to =
"Neil Truby" =
=
=
IDS 9.40FC3W2 on HP-UX11.11
I'm running an onpload (HPL) run job which is loading 35m rows to a tab=
le
then enabling the indexes. The index "enable", which I understand to b=
e 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 PDQPRIORI=
TY
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 pic=
ked
up (you can see this from the output below).
Obviously running the index separately is a straigtforward workaround w=
hich
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
=
--1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi Neil,<br>
<br>
How are u running the onpload. Are you using ipload or onpladm?<br>
If that is the case then we might not be passing these environment vara=
ibles to onpload.<br>
<br>@