Recreate Derby Database Under WebSphere
Thu, 22 Apr 2010 09:02:40 +0000
WebSphere uses SQL databases for internal managment of MQ queues (Derby database engine under the covers). Sometimes you need to reset their state. Here's the script that erase and recreate BPEDB database state (tested under WS 6.1.2):
rm -rf $WID_HOME/pf/wps/databases/BPEDB echo "CONNECT 'jdbc:derby:$WID_HOME/pf/wps/databases/BPEDB;create=true' AS BPEDB;"|\ $WID_HOME/runtimes/bi_v61/derby/bin/embedded/ij.sh /dev/stdin