What are you using to measure whether the db shrunk or not? You should have
seen the Used Pages count go down, but 101915 objects will not necessarily
lower your Max PCT Util.
Each version of a file is said to require 400 - 600 bytes of DB space  and
cached and copy storage pool copy's require about 100 - 200 bytes ,then add
25% for what is labeled overhead.
Don't forget to reset dbmaxutilization to get a real time query of your db
results.

Hope this helps.
John Stephens
Storage Solutions Specialists Inc.
www.Storsol.com
Stephens AT storsol DOT cocm

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> malkit
> Sent: Sunday, March 14, 1999 9:32 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Expire Inventory
>
>
> 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
>