SELECT RTRIM(ORD_MM.DEAL_NUMBER,' '),ORD_MM.AREA, ORD_MM.TRADE_DATE,
DB2_DRCRLD.ACTIVITY_DATE,
DB2_DRCRLD.CURRENCY,DB2_DRCRLD.ENTRY_AMOUNT,DB2_DRCRLD.DR_CR_FLAG,ORD_NOSTRO
.SHORT_CODE,RTRIM(ORD_SI.ADD1,' '),RTRIM(ORD_SI.ADD2,'
'),RTRIM(ORD_CS.CUST_NUMBER,' '),RTRIM(ORD_CS.NAME_FULL,' '),
DB2_DRCRLD.WSS_GDP_SITE, DB2_DRCRLD.WSS_COA_DATE, DB2_DRCRLD.WSS_TID,
DB2_DRCRLD.STATUS, DB2_DRCRLD.SEQUENCE_NO, DB2_DRCRLD.KEY_AMOUNT,
ORD_MM.WSS_TID, ORD_MM.EXT_TRAN_NO, ORD_MM.ORIG_NO, ORD_MM.REMARK_THREE,
ORDMM_ALIAS.DEAL_NUMBER FROM DB2_DRCRLD,ORD_AREA,ORD_MM,ORD_SI,ORD_CS,
ORD_NOSTRO, ORD_MM ORDMM_ALIAS WHERE DB2_DRCRLD.PRODUCT_CAT='MM' AND
ORD_AREA.AREA_CODE='DBGL' AND DB2_DRCRLD.DEAL_NUMBER = ORD_MM.DEAL_NUMBER
AND ORD_MM.AREA_INT_NO = DB2_DRCRLD.BOOKING_UNIT AND
ORD_MM.FSI_TID=ORD_SI.WSS_TID AND ORD_MM.PRODUCT IN
('DEP','MML','DEPR','MMLR','CLD','CLL','MTND','FFD','FFL') AND
ORD_MM.WSS_GDP_SITE=ORDMM_ALIAS.WSS_GDP_SITE(+) AND
ORD_MM.ROLLOVER_TID=ORDMM_ALIAS.WSS_TID(+) AND
DB2_DRCRLD.AREA_UNIT=ORD_AREA.AREA_UNIT AND
DB2_DRCRLD.CUST_TID=ORD_CS.WSS_TID AND
DB2_DRCRLD.SUB_LEDGER_ACCOUNT='NOSTRO' AND
ORD_NOSTRO.ACCOUNT=DB2_DRCRLD.SUB_LEDGER_ACCOUNT AND
ORD_NOSTRO.AREA_UNIT=DB2_DRCRLD.AREA_UNIT AND
ORD_NOSTRO.QUALIFIER=DB2_DRCRLD.QUALIFIER AND
ORD_NOSTRO.CURRENCY=DB2_DRCRLD.CURRENCY AND
DB2_DRCRLD.WSS_COA_DATE=ORD_AREA.AREA_DATE AND FILE_NAME IS NULL

The script above runs every 15mins in our production enviroment. This works OK for what it is intended for. Every morning about 7:30am the database is shutdown for backup. After the database has been brought up this script is takes about 3 hours to return any data. After that thing are OK until the next shutdown.

I am hoping you db gurus will point me in the right direction to sort this out. Any suggestions welcomed

will