Configuration and usage of high performance loader in SAP
Torsten Barth needed to reorganise SAP tables of about 16 million pages for a 24x7 customer with only 4 hours of downtime. Neil Truby suggested ALTER TABLE ... FRAGMENT as an alternative, since it can be cancelled. Richard Kofler asked for hardware and IDS details and estimated about 1 GB per minute with parallel HPL streams. Hari Gupta said no env or onconfig changes are needed and offered a reorg shell script. No final outcome.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi Chris, hi Richard, these tables are near 16 million pages and need to be reorganized. Main problem is the time available to do this, because this customer has 24*7 and only 4 hours to take the action. Mit freundlichen Gr''en Torsten Barth --------------------------------------------------------------------------------------------------------- Barth Rechenzentrum + Systemhaus GmbH & Co. KG Organisation & SW-Entwicklung M'hleneschweg 5 D- 49090 Osnabr'ck Telefon +49 541 609 10 - 88 Telefax +49 541 609 10 - 89 mailto: tbarth@barth-rz.de sending to informix-list
"Torsten Barth" <tbarth@barth-rz.de> wrote in message news:cdla58$6hl$1@news.xmission.com... > > > > > > > Hi Chris, hi Richard, > > these tables are near 16 million pages and need to be reorganized. > Main problem is the time available to do this, because this customer > has 24*7 and only 4 hours to take the action. An alternative, if you have the disk space, is ALTER TABLE .... FRAGMENT. This has the advantage of being instantly cannable, so no chance of over-running your allocated downtime.
Torsten Barth wrote: > > Hi Chris, hi Richard, > > these tables are near 16 million pages and need to be reorganized. > Main problem is the time available to do this, because this customer > has 24*7 and only 4 hours to take the action. > > Mit freundlichen Gr''en > > Torsten Barth > --------------------------------------------------------------------------------------------------------- > > Barth Rechenzentrum + Systemhaus GmbH & Co. KG > Organisation & SW-Entwicklung > M'hleneschweg 5 > D- 49090 Osnabr'ck > Telefon +49 541 609 10 - 88 > Telefax +49 541 609 10 - 89 > mailto: tbarth@barth-rz.de > > sending to informix-list Torsten, please give details about your hardware, operating system, I/O devices and IDS version. On modern disks and fast CPUs on a multi CPU machine you can use more than 1 HPL unload & load stream in parallel expect to reorg 1 GB (=500.000 pages) per minute. Without knowing any details about your hardware I cannot even tell you what & how you should benchmark beforehand Did you see the SAP reorg paper in the library? It deals about problems of your type. dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe
>> Hi Hari, >> thank you so far for the information. What parameters have to be >> set in the environment (.dbenv...) and in onconfig ? >> We never used it before so I am a rookie using it. >> Mit freundlichen Gr''en >> Trosten Barth --------------------------------------------------------------------------------------------------------- >> Barth Rechenzentrum + Systemhaus GmbH & Co. KG >> Organisation & SW-Entwicklung >> M'hleneschweg 5 >> D- 49090 Osnabr'ck >> Telefon +49 541 609 10 - 88 >> Telefax +49 541 609 10 - 89 >> mailto: tbarth@barth-rz.de Trosten, Regd. env. variable - Don't remember exactly but I don't think you need any env. variable/onconfig change. Also, as advised by Neil, a good alternative to reorg. Think on that direction as well, if you wish. Its a good way. Long time ago, I downloaded a beautiful piece of shell script (reorg.sh), developed by some Informix guru and posted either on newsgroup or in archives. I have used that script to reorg table with more than 8M rows (about 1M pages), no prob. at all. Pl. let me know if you need that script.