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

2 Answers

0 votes
by (10.6k 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 157 views
0 votes
2 answers 349 views
0 votes
2 answers 303 views
asked Aug 31, 2018 in BPD by Haritha.G (1.6k points)
0 votes
1 answer 99 views
0 votes
1 answer 130 views
0 votes
1 answer 60 views
0 votes
0 answers 263 views
0 votes
0 answers 13 views
0 votes
0 answers 27 views
0 votes
1 answer 157 views
0 votes
1 answer 82 views

494 questions

404 answers

81 comments

1.6k users

Created By Dosvak LLC (WWW.DOSVAK.COM)
Our Public Git Repository

Dosvak UI Toolkit --- Download --- Demo

Subscribe us at

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
...