Re: Problem with audit DB
2003-03-26 11:36:32
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
|
|
|