best way to delete database

 4 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
andrew5499
New Member Send Private Message
Posts: 0
New Member

Since our upgrade - we have an old Prod803 database sitting out there - doing nothing (currently set to offline in SQL).

What is the best way to delete the database in lawson ?

I am sure there is more to it, than just deleting in SQL

thansk

andrew

John Henley
Send Private Message
Posts: 3351
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 for using the LawsonGuru.com forums!
John
andrew5499
New Member Send Private Message
Posts: 0
New Member

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.

John Henley
Send Private Message
Posts: 3351
Using the -d option on the dbreorg will prevent the database from being accessed, so you can keep it offline.
Thanks for using the LawsonGuru.com forums!
John
andrew5499
New Member Send Private Message
Posts: 0
New Member
As always, much appreciated.