Created By Dosvak LLC (WWW.DOSVAK.COM)

0 votes
147 views
in Interview Questions by (1.6k points)

2 Answers

0 votes
by (8.1k points)
You can use the TWSearch to search by Process Name and status completed to get a list of all such instances or directly query the LSW_BPD_INSTANCE table

select distinct LBI.BPD_INSTANCE_ID as value, LBI.BPD_NAME as name from LSW_BPD_STATUS_CODES LBSC, LSW_BPD_INSTANCE LBI, LSW_PROJECT LP where LBI.EXECUTION_STATUS = LBSC.STATUS_ID and LBI.PROJECT_ID = LP.PROJECT_ID and LBI.LAST_MODIFIED_DATETIME <= (SYSDATE - ?) and LBSC.STATUS_ID IN <#=tw.local.statusIN#> and LP.SHORT_NAME IN <#=tw.local.appIN#>

Then using the built in stored procedure provided by IBM delete such instances one by one in a loop

call LSW_BPD_INSTANCE_DELETE(?)

parameter is the instanceID
0 votes
by (1.2k points)
You can delete that by WAS server also.

Related questions

0 votes
1 answer 133 views
0 votes
2 answers 317 views
0 votes
2 answers 262 views
asked Aug 31, 2018 in BPD by Haritha.G (1.6k points)
0 votes
1 answer 92 views
0 votes
1 answer 111 views
0 votes
1 answer 53 views
...