code: @Override
  	public StepStatus getStepStatus(long instanceId, String stepName) {
  		logger.entering(CLASSNAME, "getStepStatus", new Object[] {instanceId, stepName});
  		Connection conn = null;
  		PreparedStatement statement = null;
  		ResultSet rs = null;
  		RuntimeJobExecution jobExecution = null;
  		String query = "SELECT obj FROM stepstatus WHERE id IN ("
  				+ "SELECT B.stepexecid FROM executioninstancedata A INNER JOIN stepexecutioninstancedata B ON A.jobexecid = B.jobexecid " 
  				+ "WHERE A.jobinstanceid = ? and B.stepname = ?)";
  		StepStatus stepStatus = null;
  
  		try {
  			conn = getConnection();
  			statement = conn.prepareStatement(query);
  			statement.setLong(1, instanceId);
  			statement.setString(2, stepName);
  			rs = statement.executeQuery();
  			if(rs.next()) {
  				stepStatus = (StepStatus)deserializeObject(rs.getBytes(1));
  			}
  		} catch (SQLException e) {
  			throw new PersistenceException(e);
  		} catch (IOException e) {
  			throw new PersistenceException(e);
  		} catch (ClassNotFoundException e) {
  			throw new PersistenceException(e);
  		} finally {
  			cleanupConnection(conn, rs, statement);
  		}
  		logger.exiting(CLASSNAME, "getStepStatus", stepStatus==null ? "<null>" : stepStatus);
  		return stepStatus;
  	}
docs: /* (non-Javadoc)
  @see com.ibm.jbatch.container.services.IPersistenceManagerService#getStepStatus(long, java.lang.String)