0 votes
2.2k views
in Interview Questions by

2 Answers

0 votes
by (16.3k 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 1.0k views
0 votes
1 answer 1.5k views
0 votes
2 answers 2.3k views
0 votes
3 answers 2.8k views
0 votes
2 answers 1.7k views
asked Aug 31, 2018 in BPD by anonymous
0 votes
1 answer 1.2k views
0 votes
1 answer 1.1k views
+1 vote
1 answer 3.0k views
0 votes
1 answer 776 views
+1 vote
0 answers 1.3k views

635 questions

495 answers

98 comments

3.0k users

Join BPM Community Discord Channel

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.
Created by Dosvak LLC
Our Youtube Channel
...