This is for a TSM server on an IBM 660-6M1, 4-way, with 6 GB of memory
-- database is on an ESS, mirrored on the same ESS, accessed via three
fiber HBAs.
ANR0812I Inventory file expiration process 7854 completed: examined
21384673
objects, deleting 43598 backup objects, 58278 archive objects, 0 DB
backup
volumes, and 0 recovery plan files. 0 errors were encountered.
ANR0987I Process 7854 for EXPIRE INVENTORY running in the BACKGROUND
processed
101876 items with a completion state of SUCCESS at 12:53:40.
The process started at 12:00; database looks like this:
30 GB available; 20 GB assigned; 87.7 % utilization
Here's a Monday run (takes the longest -- again, started at 12:00):
ANR0812I Inventory file expiration process 7620 completed: examined
30977138
objects, deleting 37521 backup objects, 743139 archive objects, 0 DB
backup
volumes, and 0 recovery plan files. 0 errors were encountered.
ANR0386I The BUFPoolsize has been changed to 194732.
ANR0987I Process 7620 for EXPIRE INVENTORY running in the BACKGROUND
processed
780660 items with a completion state of SUCCESS at 14:24:39.
Tom Kauffman
NIBCO, Inc
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Remeta, Mark
Sent: Friday, June 10, 2005 9:34 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: very very big DB!!!!
ANR0812I Inventory file expiration process 11413
completed: examined 94799 objects, deleting 94083 backup
objects, 106 archive objects, 0 DB backup volumes, and 0
recovery plan files. 0 errors were encountered. (SESSION:
52670, PROCESS: 11413)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Das, Samiran (IDS ECCS)
Sent: Friday, June 10, 2005 10:27 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: very very big DB!!!!
Mark,
How many objects are examined daily during expiration processing?
Regards, Samiran Das
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Remeta, Mark
Sent: Friday, June 10, 2005 10:25 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: very very big DB!!!!
We have a 112gb database that is 83% utilized and it only takes 30
minutes
to complete an expire inventory. Either I have a real fast server or you
have a real slow one!
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Rees, Chris (Corp)
Sent: Friday, June 10, 2005 10:15 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: very very big DB!!!!
Hi Rick
Our unload/reload what about 10 weeks ago and halved our database from
100Gb
for 50Gb... the database has grown by 20% since but expire inventory is
still much quicker than it was prior to the unload/reload, it is however
taking longer than immediately after the process...
definitely a worthwhile exercise.
Before 21 hours
Immediately after unload/reload 6 hours
Now 10 hours
It examines 21million objects..
Chris
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Rhodes
Sent: Friday, June 10, 2005 3:06 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] very very big DB!!!!
Did you notice a performance improvement after the reorg. If you did,
is it
still performing better since it has grown?
Thanks
Rick
"Warren, Matthew
(Retail)" To:
ADSM-L AT VM.MARIST DOT EDU
<Matthew.Warren@POWE cc:
RGEN.CO.UK> Subject: Re: very
very big DB!!!!
Sent by: "ADSM: Dist
Stor Manager"
<ADSM-L AT VM.MARIST DOT ED
U>
06/10/2005 06:24 AM
Please respond to
"ADSM: Dist Stor
Manager"
It is different from DBBackup - there are specific load/unload abilities
in
TSM. The process results in the DB being re-orged. We recently went
through
the process and approximatley halved the size of our 120GB DB, the gain
is
fairly short lived though. The re-org was around 8 weeks ago and the DB
is
back up to 80% of its original size.
Matt.
Computer says 'No'..
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Lawrence Clark
Sent: Thursday, June 09, 2005 3:33 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: very very big DB!!!!
unload / load? you mean backup then restore. will that reorg the db?
>>> dlcurrell AT YAHOO DOT COM 06/09/2005 10:23:23 AM >>>
30 GB is not outrageously large. I've worked with one that was almost
twice
that size. You can unload and load the database or perhaps do an audit
on
it. There's an entire section called utilities in the Admin Reference.
Be
forewarned that an audit could take days if not weeks...!!!
--- Mario Di Pede <mario.dipede AT GIDI DOT IT> wrote:
> Hi
> I have a TSM DB of 30 Gb - there are a utilities for cleaning its?????
>
> thank's all
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
___________________________ Disclaimer Notice __________________________
This message and any attachments are confidential and should only be
read by
those to whom they are addressed. If you are not the intended recipient,
please contact us, delete the message from your computer and destroy any
copies. Any distribution or copying without our prior permission is
prohibited.
Internet communications are not always secure and therefore Powergen
Retail
Limited does not accept legal responsibility for this message.
The recipient is responsible for verifying its authenticity before
acting on
the contents. Any views or opinions presented are solely those of the
author
and do not necessarily represent those of Powergen Retail Limited.
Powergen Retail Ltd is authorised and regulated by the Financial
Services
Authority for the sale and service of general insurance products.
Registered addresses:
Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry,
CV4 8LG. Registered in England and Wales No: 3407430
Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432
-----------------------------------------
The information contained in this message is intended only for the
personal
and confidential use of the recipient(s) named above. If the reader of
this
message is not the intended recipient or an agent responsible for
delivering
it to the intended recipient, you are hereby notified that you have
received
this document in error and that any review, dissemination, distribution,
or
copying of this message is strictly prohibited. If you have received
this
communication in error, please notify us immediately, and delete the
original message.
___________________________ Disclaimer Notice ____________________ This
message and any attachments are confidential and should only be read by
those to whom they are addressed. If you are not the intended recipient,
please contact us, delete the message from your computer and destroy any
copies. Any distribution or copying without our prior permission is
prohibited.
Internet communications are not always secure and therefore the E.ON
Group
does not accept legal responsibility for this message. The recipient is
responsible for verifying its authenticity before acting on the
contents.
Any views or opinions presented are solely those of the author and do
not
necessarily represent those of the E.ON Group.
E.ON UK plc, Westwood Way, Westwood Business Park, Coventry, CV4 8LG.
Registered in England & Wales No. 2366970
E.ON UK Trading Ltd, Westwood Way, Westwood Business Park, Coventry, CV4
8LG
Registered in England & Wales No. 4178314
E.ON UK Trading Ltd is regulated by the Financial Services Authority to
carry out investment activities.
Telephone +44 (0) 2476 42 4000
Fax +44 (0) 2476 42 5432
Confidentiality Note: The information transmitted is intended only for
the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities
other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately. Please be advised that someone
other than the intended recipients, including a third-party in the
Seligman
organization and government agencies, may review all electronic
communications to and from this address.
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy,
retain
or redistribute it. Click here for important additional terms relating
to
this e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
Confidentiality Note: The information transmitted is intended only for
the
person or entity to whom or which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of this information by persons or entities
other
than the intended recipient is prohibited. If you receive this in error,
please delete this material immediately.
Please be advised that someone other than the intended recipients,
including
a third-party in the Seligman organization and government agencies, may
review all electronic communications to and from this address.
|
