SQL that we are using to perform impact analysis is:
Code: Select all
SELECT distinct X.ProjectName, X.JobName, JS.StageName, JL.LinkName, DL.DATASTORENAME, DL.DataCollectionName AS TableName, JL.IsTarget
FROM DSODB.JOBRUN R
JOIN DSODB.JOBEXEC X ON R.JOBID = X.JOBID
JOIN DSODB.JOBSTAGE JS ON X.JOBID = JS.JOBID
JOIN DSODB.JOBRUNSTAGE RS ON (JS.STAGEID = RS.STAGEID and R.RUNID = RS.RUNID)
JOIN DSODB.JOBLINK JL ON (JS.STAGEID = JL.FROMSTAGEID OR JS.STAGEID = JL.TOSTAGEID)
JOIN DSODB.JOBRUNLINK RL ON (R.RUNID = RL.RUNID AND RL.LINKID = JL.LINKID)
JOIN DSODB.DATALOCATOR DL ON RL.LOCATORID = DL.LOCATORID
WHERE DL.DATACOLLECTIONSUBCLASS = 'TABLE'
-- AND R.RUNSTARTTIMESTAMP > (SYSDATE - 1)
ORDER BY 1, 2, 3
There is an outstanding Request For Enhancement to capture all the tablenames in DSODB.DataLocator.
Please review this enhancement request. If you agree with it, please VOTE using following linkwith your IBM ID.