private void optimizeDatabase(){
  s_logger.log(Level.FINE,"optimizeDatabase",getDirection());
  String vendor=getVendor();
  String catalog=getCatalog();
  String schema=getSchema();
  int step=0;
  int errors=0;
  String sql="";
  Statement stmt=setStatement();
  sql=s_dbEngine.sqlAdmin_optimizeDatabase(step,vendor,catalog,schema);
  while (sql != null) {
    step++;
    if (executeUpdate(stmt,sql,false,false) == null)     errors++;
    sql=s_dbEngine.sqlAdmin_optimizeDatabase(step,vendor,catalog,schema);
  }
  releaseStatement(stmt);
  s_logger.log(Level.FINE,"databaseOptimized",new Object[]{Integer.toString(step - errors),Integer.toString(step)});
  s_logger.flush();
}

private void optimizeDatabase ( ) { s_logger . log ( Level . FINE , "optimizeDatabase" , getDirection ( ) ) ; String vendor = getVendor ( ) ; String catalog = getCatalog ( ) ; String schema = getSchema ( ) ; int step = 0 ; int errors = 0 ; String sql = "" ; Statement stmt = setStatement ( ) ; sql = s_dbEngine . sqlAdmin_optimizeDatabase ( step , vendor , catalog , schema ) ; while ( sql != null ) { step ++ ; if ( executeUpdate ( stmt , sql , false , false ) == null ) errors ++ ; sql = s_dbEngine . sqlAdmin_optimizeDatabase ( step , vendor , catalog , schema ) ; } releaseStatement ( stmt ) ; s_logger . log ( Level . FINE , "databaseOptimized" , new Object [ ] { Integer . toString ( step - errors ) , Integer . toString ( step ) } ) ; s_logger . flush ( ) ; }
optimize database after migration
