best way to delete database

Well, assuming you want to remove the PROD803 product line also, right?

If so,
in dbdef, change the database space to blank (i.e. detach the database from the product line).
run
> blddbdict prod803
> dbreorg -d prod803

then go back into dbdef, press F9 to remove the product line [this will take a LONG time]; confirming when asked about removing source code.

If you're on LSF9 and you have SEA applications, remove the PROD803_* services in ssoconfig.

Then delete the database itself.

Finally, if you're not on LSF9, run:
> stoplaw
> startladb
> dbreorg -g GEN
> stopladb
> startlaw
This last step will need to be done without anyone on the system, and rebuild all the indexes on GEN tables to reflect the removal of the product line...

Thanks John, yes we are on LFS9.0, and we want to dump the whole thing.

Actually we need space on our server - having the old Prod803 out there is taking up needed space.

One question - Does it matter if the databse is "offline" or "online" withing SQl. Currently we have offline (so no one would use old jobs pointing to it). ?

Thanks again for you quick reply. Very helpful as always.

Using the -d option on the dbreorg will prevent the database from being accessed, so you can keep it offline.

As always, much appreciated.