On Wed, 26 Mar 2003 16:13:14 +0100
GUILLAUMONT Etienne <eguillau AT RGB-TECHNOLOGIE DOT FR> wrote:

> Hello,
> 
> I had a problem with my TSM db, it couldn't make a reclamation with an
> error on the db (some raws could not be deleted as I remember)
> So I am trying to do an auditdb but the problem is that I get the
> followings messages :
> 
> ANR4306I AUDITDB: Processed 324433 database entries (cumulative).
> ANR4306I AUDITDB: Processed 324433 database entries (cumulative).
> ANR4306I AUDITDB: Processed 324433 database entries (cumulative).
> ANR4306I AUDITDB: Processed 324433 database entries (cumulative).
> ANR4306I AUDITDB: Processed 324433 database entries (cumulative).
> ANR4306I AUDITDB: Processed 324433 database entries (cumulative).
> ANR9999D imaudit.c(5630): ThreadId<11> Inventory object 0.3081816 deleted.
> ANR4306I AUDITDB: Processed 324434 database entries (cumulative).
> ANR4306I AUDITDB: Processed 324434 database entries (cumulative).
> ANR4306I AUDITDB: Processed 324434 database entries (cumulative).
> 
> 
> Ant it last for hours. It went quickly to something like 324420 database
> entries and it took hours to go to 324434.
> 
> Is it normal ? should I wait it to finish or not ? I think I have about
> 390000 entries in my database, but if it goes this fast, it will last
> centuries before the auditdb is finished and I fear the year 10000 bug !
> 


Hi,

yes this is normal, auditdb is painfully slow. We did one on a test instance
on our server in only 4.5 days (104 hours), that is auditing about
500,000,000 objects on a 4-cpu 4 GB RAM AIX system using whopping fast
disks. You only have about 1/1000 of the number of object, so you'd expect
to take only a few minutes, but then again, your server may not be as fast
as ours...

If you have a lot of empty space in your database.... well who knows how
fast auditdb goes through that....
> 
> Etienne GUILLAUMONT
> e-mail : etienne AT rgb-technologie DOT fr
> 
> RGB Technologie
> Parc d'Innovation, Bâtiment PYTHAGORE
> 11 Rue Jean SAPIDUS
> 67400 ILLKIRCH
> Tél :  03 90 40 60 60
> Fax : 03 90 40 60 61

-- 
Met vriendelijke groeten,

Remco Post

SARA - Stichting Academisch Rekencentrum Amsterdam    http://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008    Fax. +31 20 668 3167

"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end." -- Douglas Adams