WHERE (AL1.CLMS=AL2.CLMS AND AL1.BICNUM=AL2.BICNUM
AND AL1.REF_NUM=AL2.REF_NUM AND
AND ((AL1.ACTV_IND_CD='A' AND AL1.ADJU_LVL='I' AND AL1.WKLD='04' AND
(NOT AL1.APP_RCPDT IS NULL)))
Some more questions(not complete):
c) What DB2 version/release and OS are you using?
d) What are your difinitions(CREATE statements) of tables/indexes ?
e) How many rows in each tables?
f) How many rows returned(or expected) in the query, before and after applying DISTINCT?
g) Did you checked result of explain(access path)?
h) Is it used indexes?
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80040E4D Description: " SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 ". End Error Error: 2011-09-27 11:27:03.02 Code: 0xC020801C Source: Adding new PSC info into T2PendJuris Table OLE DB Source  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER . The AcquireConnection method call to the connection manager "DBP8.0758" failed with error code 0xC0202009. There may be error messages posted before this with more ... The package execution fa... The step failed