/**
* DB서비스 모니터링를 수행한다.
*
* @param
* @return
* @throws Exception
*/
public void monitorDb() throws Exception {
// 모니터링 대상 정보 읽어들이기~~~
List<DbMntrng> targetList = null;
DbMntrng searchVO = new DbMntrng();
// 모니터링 대상 검색 조건 초기화
searchVO.setPageIndex(1);
searchVO.setFirstIndex(0);
searchVO.setRecordCountPerPage(RECORD_COUNT_PER_PAGE);
targetList = dbMntrngService.selectDbMntrngList(searchVO);
LOGGER.debug("조회조건 {}", searchVO);
LOGGER.debug("Result 건수 : {}", targetList.size());
// 서비스체크 함수 호출.
Iterator<DbMntrng> iter = targetList.iterator();
DbMntrng target = null;
DbMntrngResult result = null;
DbMntrngLog dbMntrngLog = null;
String dmMntrngLogId = null;
while (iter.hasNext()) {
target = iter.next();
LOGGER.debug("Data : {}", target);
// 서비스 체크 수행.
result = DbMntrngChecker.check(context, target.getDataSourcNm(), target.getCeckSql());
// 대상테이블에 DB에 결과값 저장
if (result.isNrmltAt()) {
target.setMntrngSttus("01");
} else {
target.setMntrngSttus("02");
}
target.setLastUpdusrId("SYSTEM");
dbMntrngService.updateDbMntrng(target);
// 로그테이블 추가저장.
dbMntrngLog = new DbMntrngLog();
dmMntrngLogId = idgenService.getNextStringId();
dbMntrngLog.setLogId(dmMntrngLogId);
dbMntrngLog.setDataSourcNm(target.getDataSourcNm());
dbMntrngLog.setServerNm(target.getServerNm());
dbMntrngLog.setDbmsKind(target.getDbmsKind());
dbMntrngLog.setCeckSql(target.getCeckSql());
dbMntrngLog.setMngrNm(target.getMngrNm());
dbMntrngLog.setMngrEmailAddr(target.getMngrEmailAddr());
dbMntrngLog.setMntrngSttus(target.getMntrngSttus());
dbMntrngLog.setFrstRegisterId("SYSTEM");
dbMntrngLog.setLastUpdusrId("SYSTEM");
if (result.getCause() != null) {
LOGGER.debug("에러메시지: {}", result.getCause().getMessage());
if (result.getCause().getMessage() != null) {
dbMntrngLog.setLogInfo(result.getCause().getMessage());
} else {
dbMntrngLog.setLogInfo("");
}
} else {
dbMntrngLog.setLogInfo("");
}
dbMntrngService.insertDbMntrngLog(dbMntrngLog);
// 모니터링시각을 가져오기위해 로그정보를 가져온다.
dbMntrngLog = dbMntrngService.selectDbMntrngLog(dbMntrngLog);
LOGGER.debug("DB서비스로그 Data : {}", dbMntrngLog);
// email 전송.
if (!result.isNrmltAt()) {
sendEmail(dbMntrngLog);
}
}
}
/**
* DB서비스 모니터링를 수행한다.
*
* @param
* @return
* @throws Exception
*/
public int monitorDb() throws Exception {
int batchResult = 0;
// 모니터링 대상 정보 읽어들이기~~~
List<EgovMap> targetList = null;
DbMntrngVO dbMntrngVO = new DbMntrngVO();
// 모니터링 대상 검색 조건 초기화
dbMntrngVO.getSearchVO().setPageIndex(1);
dbMntrngVO.getSearchVO().setFirstIndex(0);
dbMntrngVO.getSearchVO().setRecordPerPage(RECORD_COUNT_PER_PAGE);
targetList = dbMntrngService.selectDbMntrngList(dbMntrngVO);
if (LOG.isDebugEnabled()) {
LOG.debug("조회조건 " + dbMntrngVO);
LOG.debug("Result 건수 : " + targetList.size());
}
// 서비스체크 함수 호출.
Iterator<EgovMap> iter = targetList.iterator();
EgovMap target = null;
DbMntrngResult result = null;
DbMntrngVO dbMntrng = null;
DbMntrngLogVO dbMntrngLog = null;
while (iter.hasNext()) {
target = iter.next();
if (LOG.isDebugEnabled()) {
LOG.debug("Data : " + target);
}
dbMntrng = new DbMntrngVO();
dbMntrng.setDataSourcNm((String) target.get("dataSourcNm"));
dbMntrng.setServerNm((String) target.get("serverNm"));
dbMntrng.setDbmsKind((String) target.get("dbmsKind"));
dbMntrng.setCeckSql((String) target.get("ceckSql"));
dbMntrng.setMngrNm((String) target.get("mngrNm"));
dbMntrng.setMngrEmailAddr((String) target.get("mngrEmailAddr"));
dbMntrng.setMntrngSttus((String) target.get("mntrngSttus"));
// 서비스 체크 수행.
result = DbMntrngChecker.check(dataSource, dbMntrng.getDataSourcNm(), dbMntrng.getCeckSql());
// 대상테이블에 DB에 결과값 저장
if (result.isNrmltAt()) {
dbMntrng.setMntrngSttus("01");
} else {
dbMntrng.setMntrngSttus("02");
}
dbMntrng.setLastUpdusrId("SYSTEM");
dbMntrngService.updateDbMntrng(dbMntrng);
// 로그테이블 추가저장.
dbMntrngLog = new DbMntrngLogVO();
dbMntrngLog.setLogId(dbMntrngLogIdGnrService.getNextStringId());
dbMntrngLog.setDataSourcNm(dbMntrng.getDataSourcNm());
dbMntrngLog.setServerNm(dbMntrng.getServerNm());
dbMntrngLog.setDbmsKind(dbMntrng.getDbmsKind());
dbMntrngLog.setCeckSql(dbMntrng.getCeckSql());
dbMntrngLog.setMngrNm(dbMntrng.getMngrNm());
dbMntrngLog.setMngrEmailAddr(dbMntrng.getMngrEmailAddr());
dbMntrngLog.setMntrngSttus(dbMntrng.getMntrngSttus());
dbMntrngLog.setFrstRegisterId(dbMntrng.getLastUpdusrId());
if (result.getCause() != null) {
if (LOG.isDebugEnabled()) {
LOG.debug("에러메시지: " + result.getCause().getMessage());
}
if (result.getCause().getMessage() != null) {
dbMntrngLog.setLogInfo(result.getCause().getMessage());
} else {
dbMntrngLog.setLogInfo("");
}
} else {
dbMntrngLog.setLogInfo("");
}
dbMntrngService.insertDbMntrngLog(dbMntrngLog);
// 모니터링시각을 가져오기위해 로그정보를 가져온다.
dbMntrngLog = dbMntrngService.selectDbMntrngLog(dbMntrngLog);
if (LOG.isDebugEnabled()) {
LOG.debug("DB서비스로그 Data : " + dbMntrngLog);
}
// email 전송.
if (!result.isNrmltAt()) {
batchResult = -1;
sendEmail(dbMntrngLog);
}
}
return batchResult;
}