Groups > DB2 > DB2 UDB > Re: DB2 PERSONAL EDITION - DROPPING THE DATABASE




DB2 PERSONAL EDITION - DROPPING THE DATABASE

DB2 PERSONAL EDITION - DROPPING THE DATABASE
Thu, 16 Aug 2007 15:16:00 EDT
CAN ANYONE TELL ME HOW TO DROP THE DB2 DATABASE USING A SCRIPT. I'M TRYING TO
AUTOMATE THIS PROCESS AND THE PROBLEM I'M HAVING IS GETTING THE COMMAND
"DB2 DROP DATABASE [DATABASE NAME]" TO WORK. 

EXAMPLE OF DROP_DB2.BAT:

CD "C:\PROGRAM FILES\IBM\SQLLIB\BIN"
{HERE IS WHERE MY PROBLEM LIES, HOW TO PIPE THE COMMAND TO DROP THE DB}


YOUR HELP IS GREATLY APPRECIATED.
Post Reply
Re: DB2 PERSONAL EDITION - DROPPING THE DATABASE
Fri, 17 Aug 2007 08:09:51 +020
wattsun@aol.com wrote:

> CAN ANYONE TELL ME HOW TO DROP THE DB2 DATABASE USING A SCRIPT. I'M TRYING
> TO AUTOMATE THIS PROCESS AND THE PROBLEM I'M HAVING IS GETTING THE COMMAND
> "DB2 DROP DATABASE [DATABASE NAME]" TO WORK.
> 
> EXAMPLE OF DROP_DB2.BAT:
> 
> CD "C:\PROGRAM FILES\IBM\SQLLIB\BIN"
> {HERE IS WHERE MY PROBLEM LIES, HOW TO PIPE THE COMMAND TO DROP THE DB}
> 
> 
> YOUR HELP IS GREATLY APPRECIATED.

Using all-caps is very rude because it implies shouting.

Could you let us know what exactly the problems are?  How does your script
look like and what exactly is the error message that DB2 gave you?

-- 
Knut Stolze
DB2 z/OS Utilities Development
Post Reply
about | contact