I am sorry I wasn't more specific the first time.  The salvage utilities are
documented in appendix B of the mvs ADSM AdminRef, sh26-4040-00. As to
problems encountered during the audit, you will probably need to call the
support center.

--
-----------------------------------------------------------
-----------------------------------------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma
bcolwell AT draper DOT com
-----------------------------------------------------------
In <0012900002856018000002*@MHS>, on 03/10/98
In <0012900002856018000002*@MHS>, on 03/10/98
   at 02:52 PM, Jerry Lawson <jlawson AT THEHARTFORD DOT COM> said:

>---------------------------- Forwarded with Changes
>---------------------------
>From: INTERNET.OWNERAD at SNADGATE
>Date: 3/9/98 1:23PM
>To: Jerry Lawson at ASUPO
>*To: *ADSM-L at SNADGATE
>Subject: Re: Data Base Reduction assistance required.... :-(
>-------------------------------------------------------------------------------
>Bill (and all of the others who replied)....

>Thanks for all of your help.  However, this is beginning to take on a life
>of its own.

>First, on the off chance that the scheduled Expire Inventory had not run, I
>tried that.  No help.

>Then I tried Kelly's suggestion of adding an extra volume, and then trying
>to take everything off ..... I was able to get the volume I wanted off, but
>instead of giving me all of my space back, it merely moved the 164MB of
>entries that were tied up to the new volume - it would only let me take 96
>more off - not what I wanted.  (I was hoping this would just move valid
>entries......)

>SO then, Bill, I tried your suggestion.

>First, where is  the documentation on Dumpdb, loaddb and auditdb?  I have
>checked through the Server Guide, the MVS server installation manual (on
>CDROM) and also poked through the 'sys1.samplib' member.  While I did pick
>up bits and pieces, I can't find any meaningful text on how to do these
>activities.  The samplib members did provide some of the syntax....

>Here's what I have done so far (JCL errors and failed attempts omitted for
>my sanity).

>1.  Ran Dumpdb.  Created a good ADSM dump of the DB.

>2.  Tried to run LOADDB.  - failed because the DB was not freshly
>initialized.

>3.  After several reformat jobs, and attempts to run loaddb, I finally came
>to the conclusion that the only way this would work is if I reinitialized
>the DB.  Followed the examples in the Installation manual, and
>reinitialized the DB.

>4.  LOADDB was now successful in reloading the DB, but indicated that the
>dump image was inconsistent, and I needed to run and audit db with fix=yes.
>The message was ANR4405.  Online help was of little assistance.

>5.  I then ran an AUDITDB with fix=yes.  I received the following messages:

>  ANR9999D ASAUDIT(2318): Error 2 retrieving AS.Volume.Status entry for
>volume 5.
>  ANR9999D ASAUDIT(1669): Error 267 checking volume occupancy.
>  ANR4142I AUDITDB: Database audit process terminated in error.

>At this point, I'm just glad that this is my test system.  Does anyone have
>any idea what the problem is with the LOAD failing and auidt not fixing it?

>The server is MVS at 2.1.0.13

>Jerry Lawson
>jlawson AT thehartford DOT com
>______________________________ Forward Header
>__________________________________ Subject: Re: Data Base Reduction
>assistance required.... :-( Author:  INTERNET.OWNERAD at SNADGATE
>Date:    3/9/98 1:23 PM


>In <0012900002840602000002*@MHS>, on 03/09/98
>   at 11:55 AM, Jerry Lawson <jlawson AT THEHARTFORD DOT COM> said:

>>Date:     March 9, 1998            Time: 9:40 AM
>>From:     Jerry Lawson
>>          The Hartford Insurance Group
>>(860)  547-2960          jlawson AT thehartford DOT com
>>-----------------------------------------------------------------------------
>>Another fine mess I've gotten myself into......

>>As an oldtimer on this list, I know this question has come up before, but I
>>can't remember exactly when, so I thought I'd ask it again - which means I
>>have to plead guilty to not paying good attention the first time it was
>>asked.  But based on what I do remember, this is perhaps the most
>>ridiculous example of this problem that's been posted......

>>I am trying to reduce my DB, but it will not reduce past a point, even
>>though the $%#@ thing is EMPTY!  :-(

>(snip)

>As I remember, the solution is to use the salvage utilities - dumpdb,
>loaddb, auditdb.  The problem is that expansion of some of the tables
>creates a high water mark which you can't reduce below.


>--
>-----------------------------------------------------------
>Bill Colwell
>C. S. Draper Lab
>Cambridge, Ma
>bcolwell AT draper DOT com
>-----------------------------------------------------------