Search This Blog

Friday, November 16, 2012

Cleaning WCS developer database using DBClean

  • You need to copy these files from Windows installation of WCS..
  • Copy setenv.bat as setenv_DBClean.bat in {Toolkit_Home}\bin
  • Edit setenv_DBClean.bat and add the following line at the top of the file (without the ‘—>’ of course)
         —>   SET DB2_DRIVER={DB2_HOME}\java\db2java.zip
       where {DB2_HOME} is the value of your DB2 install root.
       Also change the .. to {WC6Toolkit_Home} so it looks like
         —>   call setshortname WCS_HOME {Toolkit_Home}
         —>   call setshortname WCLOGDIR {Toolkit_Home}\logs
         —>   call setshortname WCTEMPDIR {Toolkit_Home}\temp
  • Copy dbclean.bat from {WC_HOME}\bin to {Toolkit_Home}\bin
  • Edit {Toolkit_Home}\bin\dbclean.bat
         - change setenv.bat to setenv_DBClean.bat
         - change the path for Enablement-BaseComponentsLogic.jar from \wc.ear to \workspace\WC
         - change the path for jtopen.jar from \lib to \workspace\WC\lib
  • Import cleanconf rows for your toolkit’s CLEANCONF table or insert new rows as needed.

No comments:

Post a Comment