Hey Malkit...

I may be wrong here, but 101915/10203408 = 1%, so I wouldn't expect your
database to shrink by much.  Note that you may want to check the number of
pages used (q db) before and after to notice the difference.

malkit wrote:

> Hello !
>
> I have a customer with 6GB of data base. We upgrade to to V3.1.2.1 and
> run expire inventory. The output of the process was:
>
> ANR0812I Inventory file expiration process 3 completed:
>                           examined 372334 objects, deleting 101915
> backup objects,
>                           0 archive objects, 0 DB backup volumes, and 0
> recovery
>                           plan files. 0 errors were encountered.
> ANR0987I Process 3 for EXPIRE INVENTORY running in the
>                           BACKGROUND processed 101915 items with a
>                           complition state  of SUCCESS at 12:01:43.
>
> How come the data base didn't shrink ? We run audit reclaim and audit db
> as well, and the data base is still 6GB.
>
> I checked the number of files per node (LL_NAME) and got the following
> results:
>
> adsm> select node_name,count(ll_name) as "# files"  from backups group
> by node_name
>
> NODE_NAME         # files
> ------------------     -----------
> BART                     539421
> HOMER                 5728376
> LISA                       2918072
> MAGGIE                117951
> MARJ                     272645
> SYDNEY                626943
>
> --
> Regards
>
> Malkit Hayun , UDI
> Storage Products Manager
> IBM Certified Specialist-ADSM
> Office: 972-3-9233440
> Fax:    972-3-9233441
> Mobile: 972-52-834575
> Email: malkit AT udi.co DOT il

--
Bruce Elrick, Ph.D.
Bruce Elrick, Ph.D.
mailto:belrick AT home DOT com
http://members.home.net/belrick/