Re: Configuration and usage of high performance loader in SAP
--0__=08BBE444DFF8E0338f9e8a93df938690918c08BBE444DFF8E033
Content-type: multipart/alternative;
Boundary="1__=08BBE444DFF8E0338f9e8a93df938690918c08BBE444DFF8E033"
--1__=08BBE444DFF8E0338f9e8a93df938690918c08BBE444DFF8E033
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: quoted-printable
Hi Torsten,
I do not know much about the SAP setup or the version on which customer=
is?
If you are using 9x servers, this can be done very easily using HPL uti=
lity
onpladm.
Using onpladm, with one command you can create jobs for each of the tab=
les
that you want to load/unload/reorg.
For details about onpladm you can refer to the IBM IDS 9.4 HPL manual.
But if you have a specific need, I can do/help with creating and exampl=
e
script to create/run onpladm jobs.
But require you to be more specific with the SAP schema etc.
Thanks,
Pravin.
=
Torsten Barth =
<tbarth@barth-rz. =
de> =
To
Sent by: informix-list@iiug.org, =
owner-informix-li sapmix@iiug.org =
st@iiug.org =
cc
=
Subj=
ect
07/20/2004 03:58 Configuration and usage of high =
AM performance loader in SAP =
=
=
=
=
=
=
Hi,
I am not experienced in using hpl and I need to know how to configure a=
nd
use
the HPL to reorg large tables.
We have to reorg some very large tables in just 5 hours (24*7). So I ca=
nnot
use
SAP's sapdba. Somebody out there who has real advise for me ?
Thanks in advance !!
Regards
Torsten Barth
-----------------------------------------------------------------------=
----------------------------------
Barth Rechenzentrum + Systemhaus GmbH & Co. KG
Organisation & SW-Entwicklung
M=FChleneschweg 5
D- 49090 Osnabr=FCck
Telefon +49 541 609 10 - 88
Telefax +49 541 609 10 - 89
mailto: tbarth@barth-rz.de
sending to informix-list
=
--1__=08BBE444DFF8E0338f9e8a93df938690918c08BBE444DFF8E033
Content-type: text/html; charset=ISO-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi Torsten,<br>
<br>
I do not know much about the SAP setup or the version on which customer=
is?<br>
If you are using 9x servers, this can be done very easily using HPL uti=
lity onpladm.<br>
<br>
Using onpladm, with one command you can create jobs for each of the tab=
les that you want to load/unload/reorg.<br>
For details about onpladm you can refer to the IBM IDS 9.4 HPL manual.<=
br>
<br>
But if you have a specific need, I can do/help with creating and exampl=
e script to create/run onpladm jobs.<br>
But require you to be more specific with the SAP schema etc.<br>
<br>
Thanks,<br>
Pravin.<br>
<br>
<img src=3D"cid:10__=3D08BBE444DFF8E0338f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for Torsten Barth <t=
barth@barth-rz.de>">Torsten Barth <tbarth@barth-rz.de><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE44=
4DFF8E0338f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">Torsten Barth <tbarth@barth-rz.de></font>=
</b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">07/20/2004 03:58 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE444DFF8E0338f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D08BBE444DFF8E0338f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">informix-list@iiug.org, sapmix@iiug.org</font></td></t=
r>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE444DFF8E0338f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D08BBE444DFF8E0338f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D08BBE444DFF8E0338f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D08BBE444DFF8E0338f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Configuration and usage of high performance loader in =
SAP</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE444DFF8=
E0338f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE444DFF8E0338f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt><br>
<br>