快速找出DB2分区键设置不正确的表
http://www.diybl.com/ 2008-3-8 网络 点击:
[ 评论 ]
文章搜索：
【点击打包该文章】
//~--- non-JDK imports --------------------------------------------------------
import org.apache.commons.beanutils.DynaBean;
import org.apache.commons.beanutils.RowSetDynaClass;
//~--- JDK imports ------------------------------------------------------------
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
public class Main {
private static String
url = "jdbc:db2://:/",
username = "hndp",
password = "hndp";
private static RowSetDynaClass getResultSet(String sql) {
Connection conn = null;
Statement staem = null;
ResultSet rs = null;
RowSetDynaClass rsdc = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
conn = DriverManager.getConnection(url, username, password);
staem = conn.createStatement();
rs = staem.executeQuery(sql);
rsdc = new RowSetDynaClass(rs);
} catch (Exception e) {
e.printStackTrace();
} finally&n
DB2建立表的时候可以设置一个分区键，默认的情况下都是根据建表者自己的开发经验来决定。如果万一分区键没有设置正确，就会造成数据库节点数据分配不均匀。那么如何快速的找出哪些表的分区键设置不正确呢？？
自己写了一个不足130行的小程序就可以解决这个问题了
//~--- non-JDK imports --------------------------------------------------------
import org.apache.commons.beanutils.DynaBean;
import org.apache.commons.beanutils.RowSetDynaClass;
//~--- JDK imports ------------------------------------------------------------
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
public class Main {
private static String
url = "jdbc:db2://:/",
username = "hndp",
password = "hndp";
private static RowSetDynaClass getResultSet(String sql) {
Connection conn = null;
Statement staem = null;
ResultSet rs = null;
RowSetDynaClass rsdc = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
conn = DriverManager.getConnection(url, username, password);
staem = conn.createStatement();
rs = staem.executeQuery(sql);
rsdc = new RowSetDynaClass(rs);
} catch (Exception e) {
e.printStackTrace();
} finally&n
如果图片或页面不能正常显示请点击这里 站内搜索：
推荐文章 |