Gail,
You shouldn't need to reorg your database and there is no recognised process for
doing so anyway.
Are you running expiration as a regular daily process?
If you are you should see the  Pct Util figure of your database decrease if you
are deleting lots of filespaces.
That is provided that these filespaces do not contain just a few  files.
A "q db f=d" command will show you how your database currently stands.
The database is made up of 1 or more logical database volumes which are
physically  linear vsam flles, and the query command will show you the maximum
reduction that you can possibly make to your database.
You can do this via the reduce DB command (must be specfied in increments of
4mb.)
Bear in mind for performance reasons database shouldn't run over 90% utilised.
Reducing your databse will not necessarily free any of the linear vsam files for
deletion, but if  you issue a "q dbvol f=d"
command this will show if any of your database logical volumes are completely
free.
The logical volume can the be removed from ADSM via a "delete dbvol 'inear vsam
cluster name'  " command
 Once this process has completed you can delete the linear vsam file itself.
If you issue a "delete dbvol" command against a database volume which still has
allocated data, it will only work if there is enough room on the the remaining
database volumes to move the data to.  ADSM will generate a process to do that.
If you know all this and your database is still growing you need to look at your
individual clients.
How many files are you backing up nightly. Is this increasing ?
Have you "queried occupancy"
If you have large numbers of small files you may want to look at values for
TXNGROUPMAX specified in the server options file  and  TXNBYTELIMIT specified in
the client options file.
Both of these options impact on file aggregation (where large numbers of small
filesare grouped together in an aggregate database entry)
An aggregate database entry takes less space than the equivalent in  individual
database entries.
Hope this helps






**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************