import java.sql.*;
public class DB2Util{
    public static void main(String[] args) throws Exception{
        String url="jdbc:db2://10.85.38.144:sample";
        String userId="Administrator";
        String password="*****";
        String sql="select * from administrator.org";
        Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();
        Connection con=DriverManager.getConnection( url, userId, password );
        Statement statement=con.createStatement();
        statement.execute("delete from administrator.explain_statement");
        statement.execute("explain all with snapshot for "+sql);
        ResultSet rs=statement.executeQuery(
            "select total_cost from administrator.explain_statement "+
            "where explain_level='P'");
        System.out.println("Cost for '"+sql+"'");
        while(rs.next()){
            System.out.println(rs.getString(1));
        }
        rs.close();
        statement.close();
        con.close();
    }
}