So we have some work for the database administrator ( here I'm using DB2 10.5 on Linux, other databases are available ): -
Connect to BPM DB
db2 connect to bpmdb
Set Current Schema to db2user1
db2 set current schema db2user1
Check Execution Status
db2 "select STATUS_ID, NAME from LSW_BPD_STATUS_CODES"
1. Active
2. Completed
3. Failed
4. Terminated
5. Did_not_Start
6. Suspended
Summarise Status
db2 "select inst.EXECUTION_STATUS, count(*) as total from LSW_BPD_INSTANCE inst, LSW_TASK task where task.BPD_INSTANCE_ID = inst.BPD_INSTANCE_ID group by inst.EXECUTION_STATUS"
EXECUTION_STATUS TOTAL
---------------- -----------
1. 1
2. 1
4. 1
6. 1
This means that we have four instances in total; one Active, one Completed, one Terminated and one Suspended.
Check for Active Instances
db2 "select BPD_INSTANCE_ID,SNAPSHOT_ID from LSW_BPD_INSTANCE where EXECUTION_STATUS = '1'"
BPD_INSTANCE_ID SNAPSHOT_ID
11. 3053758b-8764-4c1c-854a-ad0982143313
Check for Completed Instances
db2 "select BPD_INSTANCE_ID,SNAPSHOT_ID from LSW_BPD_INSTANCE where EXECUTION_STATUS = '2'"
BPD_INSTANCE_ID SNAPSHOT_ID
4. 3053758b-8764-4c1c-854a-ad0982143313
Check for Terminated Instances
db2 "select BPD_INSTANCE_ID,SNAPSHOT_ID from LSW_BPD_INSTANCE where EXECUTION_STATUS = '4'"
BPD_INSTANCE_ID SNAPSHOT_ID
6. 3053758b-8764-4c1c-854a-ad0982143313
7. 3053758b-8764-4c1c-854a-ad0982143313
8. 3053758b-8764-4c1c-854a-ad0982143313
9. 3053758b-8764-4c1c-854a-ad0982143313
Check for Suspended Instances
db2 "select BPD_INSTANCE_ID,SNAPSHOT_ID from LSW_BPD_INSTANCE where EXECUTION_STATUS = '6'"
BPD_INSTANCE_ID SNAPSHOT_ID
10. f1659d94-2365-4903-8a90-9fa62f3ccc97
Correlate Snapshots to Process Applications
db2 "select NAME,ACRONYM from LSW_SNAPSHOT where SNAPSHOT_ID = '3053758b-8764-4c1c-854a-ad0982143313'"
NAME ACRONYM
Procurement Sample v8570 PSV8570
db2 "select NAME,ACRONYM from LSW_SNAPSHOT where SNAPSHOT_ID = 'f1659d94-2365-4903-8a90-9fa62f3ccc97'"
NAME ACRONYM
Responsive Hiring Sample v8570 RHSV8_1
With the details of the snapshots, applications and instances, we now pass control to the BPM administrator: -
Start WSAdmin Client ( note; this is against the AppCluster SOAP port )
/opt/ibm/WebSphereProfiles/Dmgr01/bin/wsadmin.sh -host bpm857.uk.ibm.com -port 8881 -lang jython -user wasadmin -password passw0rd
List Installed Process Applications
print AdminTask.BPMListProcessApplications()
...
Name: Hiring Sample
Acronym: HSS
Description: Hiring Sample
Toolkit: false
Name: Hiring Sample Advanced
Acronym: HSAV1
Description:
Toolkit: false
Name: Procurement Sample
Acronym: STPPS1
Description:
Toolkit: false
...
Show Snapshot Details of Chosen Process Application
print AdminTask.BPMShowProcessApplication('[-containerAcronym HSAV1]')
Name: Hiring Sample Advanced
Acronym: HSAV1
Description:
Toolkit: false
Tracks:
Track Name: Main
Track Acronym: Main
Default: true
Tip:
Created On: 2016-12-30 14:01:25.987
Created By: User.9
State: State[Inactive]
Capability: Capability[Advanced]
No of running instances: 0
List of Snapshots:
Name: Advanced Hiring Sample v8570
Acronym: AHSV857
Created On: 2016-12-30 14:01:25.987
Created By: User.9
Is Default: false
State: State[Undeployed]
Capability: Capability[Advanced]
No of running instances: 0
print AdminTask.BPMShowSnapshot('[-containerAcronym HSAV1 -containerSnapshotAcronym AHSV857 ]')
Name: Advanced Hiring Sample v8570
Acronym: AHSV857
Created On: 2016-12-30 14:01:25.987
Created By: User.9
Is Default: false
State: State[Undeployed]
Capability: Capability[Advanced]
Theme: BPM Theme
No of running instances: 0
Dependency:
Toolkit Acronym: TWSYS
Toolkit Name: System Data
Toolkit Track Acronym: Main
Toolkit Track Name: Main
Snapshot Name: 8.5.7.0
Snapshot Acronym: 8.5.7.0
Created On: 2016-12-30 14:00:39.906
Created By: User.9
Dependency:
Toolkit Acronym: SYSC
Toolkit Name: Coaches
Toolkit Track Acronym: Main
Toolkit Track Name: Main
Snapshot Name: 8.5.7.0
Snapshot Acronym: 8.5.7.0
Created On: 2016-12-30 14:00:47.195
Created By: User.9
Dependency:
Toolkit Acronym: SYSRC
Toolkit Name: Responsive Coaches
Toolkit Track Acronym: Main
Toolkit Track Name: Main
Snapshot Name: 8.5.7.0
Snapshot Acronym: 8.5.7.0
Created On: 2016-12-30 14:00:50.024
Created By: User.9
print AdminTask.BPMShowProcessApplication('[-containerAcronym HSS]')
Name: Hiring Sample
Acronym: HSS
Description: Hiring Sample
Toolkit: false
Tracks:
Track Name: Main
Track Acronym: Main
Default: true
Tip:
Created On: 2016-12-30 14:01:22.959
Created By: User.9
State: State[Inactive]
Capability: Capability[Standard]
No of running instances: 0
List of Snapshots:
Name: Responsive Hiring Sample v8570
Acronym: RHSV8_1
Created On: 2016-12-30 14:01:22.959
Created By: User.9
Is Default: false
State: State[Inactive]
Capability: Capability[Standard]
No of running instances: 0
print AdminTask.BPMShowSnapshot('[-containerAcronym HSS -containerSnapshotAcronym RHSV8_1 ]')
Name: Responsive Hiring Sample v8570
Acronym: RHSV8_1
Created On: 2016-12-30 14:01:22.959
Created By: User.9
Is Default: false
State: State[Inactive]
Capability: Capability[Standard]
Theme: BPM Theme
No of running instances: 0
Dependency:
Toolkit Acronym: TWSYS
Toolkit Name: System Data
Toolkit Track Acronym: Main
Toolkit Track Name: Main
Snapshot Name: 8.5.7.0
Snapshot Acronym: 8.5.7.0
Created On: 2016-12-30 14:00:39.906
Created By: User.9
Dependency:
Toolkit Acronym: SYSRC
Toolkit Name: Responsive Coaches
Toolkit Track Acronym: Main
Toolkit Track Name: Main
Snapshot Name: 8.5.7.0
Snapshot Acronym: 8.5.7.0
Created On: 2016-12-30 14:00:50.024
Created By: User.9
print AdminTask.BPMShowProcessApplication('[-containerAcronym STPPS1]')
Name: Procurement Sample
Acronym: STPPS1
Description:
Toolkit: false
Tracks:
Track Name: Main
Track Acronym: Main
Default: true
Tip:
Created On: 2016-12-30 14:01:30.466
Created By: User.9
State: State[Inactive]
Capability: Capability[Advanced]
No of running instances: 0
List of Snapshots:
Name: Procurement Sample v8570
Acronym: PSV8570
Created On: 2016-12-30 14:01:30.466
Created By: User.9
Is Default: false
State: State[Undeployed]
Capability: Capability[Advanced]
No of running instances: 0
print AdminTask.BPMShowSnapshot('[-containerAcronym STPPS1 -containerSnapshotAcronym PSV8570 ]')
Name: Procurement Sample v8570
Acronym: PSV8570
Created On: 2016-12-30 14:01:30.466
Created By: User.9
Is Default: false
State: State[Undeployed]
Capability: Capability[Advanced]
Theme: BPM Theme
No of running instances: 0
Dependency:
Toolkit Acronym: TWSYS
Toolkit Name: System Data
Toolkit Track Acronym: Main
Toolkit Track Name: Main
Snapshot Name: 8.5.7.0
Snapshot Acronym: 8.5.7.0
Created On: 2016-12-30 14:00:39.906
Created By: User.9
Dependency:
Toolkit Acronym: SYSRC
Toolkit Name: Responsive Coaches
Toolkit Track Acronym: Main
Toolkit Track Name: Main
Snapshot Name: 8.5.7.0
Snapshot Acronym: 8.5.7.0
Created On: 2016-12-30 14:00:50.024
Created By: User.9
Run Instance Cleanup for Hire Sample ( note; all instances, regardless of status )
print AdminTask.BPMProcessInstancesCleanup('[-containerAcronym HSS -containerSnapshotAcronym RHSV8_1 ]')
The BPMProcessInstancesCleanup command passed.
Check results in AppCluster Logs
tail -f /opt/ibm/WebSphereProfiles/AppSrv01/logs/AppClusterMember1/SystemOut.log
[04/01/17 09:58:05:333 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesCleanup Entering
[04/01/17 09:58:05:355 GMT] 000001eb Log I PAL: About to start the BPMProcessInstancesCleanup with parameters: -containerAcronym Hiring Sample -containerSnapshotAcronym RHSV8_1 -instanceStatus ALL -maximumduration 0 -transactionSlice 1
[04/01/17 09:58:05:355 GMT] 000001eb Log I PAL: Number of qualifying instances before deletion: 1
[04/01/17 09:58:05:543 GMT] 000001eb Log I PAL: A deletion job is running. Progress: Deleted 1 instance(s).
[04/01/17 09:58:05:544 GMT] 000001eb Log I PAL: Every instance has been deleted. The deletion job finished.
[04/01/17 09:58:05:564 GMT] 000001eb Log I PAL: Successfully ran the BPMProcessInstancesCleanup command with parameters: -containerAcronym Hiring Sample -containerSnapshotAcronym RHSV8_1 -instanceStatus ALL -maximumduration 0 -transactionSlice 1
[04/01/17 09:58:05:564 GMT] 000001eb Log I PAL: Number of qualifying instances before deletion: 1
[04/01/17 09:58:05:569 GMT] 000001eb Log I PAL: Number of qualifying instances after deletion: 0
[04/01/17 09:58:05:573 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesCleanup Exiting
[04/01/17 09:58:15:288 GMT] 00000124 ProcessIndexB I CWLLG0757I: The purge process was completed successfully. 2 tasks and 1 instances were successfully removed from the search index.
Run Instance Cleanup for Hire Sample Advanced ( note; all instances, regardless of status )
print AdminTask.BPMProcessInstancesCleanup('[-containerAcronym HSAV1 -containerSnapshotAcronym AHSV857 ]')
The BPMProcessInstancesCleanup command passed.
Check results in AppCluster Logs
tail -f /opt/ibm/WebSphereProfiles/AppSrv01/logs/AppClusterMember1/SystemOut.log
[04/01/17 10:03:46:320 GMT] 000001ec CommandServic I PALAdminCommands otherProcessInstancesCleanup Entering
[04/01/17 10:03:46:340 GMT] 000001ec Log I PAL: About to start the BPMProcessInstancesCleanup with parameters: -containerAcronym Hiring Sample Advanced -containerSnapshotAcronym AHSV857 -instanceStatus ALL -maximumduration 0 -transactionSlice 1
[04/01/17 10:03:46:340 GMT] 000001ec Log I PAL: Number of qualifying instances before deletion: 1
[04/01/17 10:03:46:422 GMT] 000001ec Log I PAL: A deletion job is running. Progress: Deleted 1 instance(s).
[04/01/17 10:03:46:423 GMT] 000001ec Log I PAL: Every instance has been deleted. The deletion job finished.
[04/01/17 10:03:46:433 GMT] 000001ec Log I PAL: Successfully ran the BPMProcessInstancesCleanup command with parameters: -containerAcronym Hiring Sample Advanced -containerSnapshotAcronym AHSV857 -instanceStatus ALL -maximumduration 0 -transactionSlice 1
[04/01/17 10:03:46:434 GMT] 000001ec Log I PAL: Number of qualifying instances before deletion: 1
[04/01/17 10:03:46:439 GMT] 000001ec Log I PAL: Number of qualifying instances after deletion: 0
[04/01/17 10:03:46:444 GMT] 000001ec CommandServic I PALAdminCommands otherProcessInstancesCleanup Exiting
[04/01/17 10:03:55:324 GMT] 00000124 ProcessIndexB I CWLLG0757I: The purge process was completed successfully. 3 tasks and 1 instances were successfully removed from the search index.
Run Instance Cleanup for Procurement Sample; only for Terminated instances
print AdminTask.BPMProcessInstancesCleanup('[-containerAcronym STPPS1 -containerSnapshotAcronym PSV8570 -instanceStatus CANCELED -instanceID [ 6 7 8 9 ]]')
The BPMProcessInstancesCleanup command passed.
Check results in AppCluster Logs
tail -f /opt/ibm/WebSphereProfiles/AppSrv01/logs/AppClusterMember1/SystemOut.log
[04/01/17 16:18:02:778 GMT] 000001ec CommandServic I PALAdminCommands otherProcessInstancesCleanup Entering
[04/01/17 16:18:02:800 GMT] 000001ec Log I PAL: About to start the BPMProcessInstancesCleanup with parameters: -containerAcronym Procurement Sample -containerSnapshotAcronym PSV8570 -instanceStatus CANCELED -instanceID [6, 7, 8, 9] -maximumduration 0 -transactionSlice 1
[04/01/17 16:18:02:801 GMT] 000001ec Log I PAL: Number of qualifying instances before deletion: 4
[04/01/17 16:18:02:883 GMT] 000001ec Log I PAL: A deletion job is running. Progress: Deleted 1 instance(s).
[04/01/17 16:18:02:907 GMT] 000001ec Log I PAL: A deletion job is running. Progress: Deleted 1 instance(s).
[04/01/17 16:18:02:919 GMT] 000001ec Log I PAL: A deletion job is running. Progress: Deleted 1 instance(s).
[04/01/17 16:18:02:931 GMT] 000001ec Log I PAL: A deletion job is running. Progress: Deleted 1 instance(s).
[04/01/17 16:18:02:931 GMT] 000001ec Log I PAL: Every instance has been deleted. The deletion job finished.
[04/01/17 16:18:02:947 GMT] 000001ec Log I PAL: Successfully ran the BPMProcessInstancesCleanup command with parameters: -containerAcronym Procurement Sample -containerSnapshotAcronym PSV8570 -instanceStatus CANCELED -instanceID [6, 7, 8, 9] -maximumduration 0 -transactionSlice 1
[04/01/17 16:18:02:948 GMT] 000001ec Log I PAL: Number of qualifying instances before deletion: 4
[04/01/17 16:18:02:954 GMT] 000001ec Log I PAL: Number of qualifying instances after deletion: 0
[04/01/17 16:18:02:959 GMT] 000001ec CommandServic I PALAdminCommands otherProcessInstancesCleanup Exiting
[04/01/17 16:18:08:806 GMT] 00000124 ProcessIndexB I CWLLG0757I: The purge process was completed successfully. 4 tasks and 4 instances were successfully removed from the search index.
Run Instance Cleanup for Responsive Hiring Sample; only for Suspended Instances
print AdminTask.BPMProcessInstancesCleanup('[-containerAcronym HSS -containerSnapshotAcronym RHSV8_1 -instanceStatus ALL -instanceID [ 10 ]]')
The BPMProcessInstancesCleanup command passed.
Check results in AppCluster Logs
tail -f /opt/ibm/WebSphereProfiles/AppSrv01/logs/AppClusterMember1/SystemOut.log
[04/01/17 16:35:30:072 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesCleanup Entering
[04/01/17 16:35:30:089 GMT] 000001eb Log I PAL: The process instance with the ID '10' is in the state '6' which is not a specified state and will not be deleted.
[04/01/17 16:35:30:096 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesCleanup Exiting
[04/01/17 16:35:38:927 GMT] 00000124 ProcessIndexB I CWLLG0757I: The purge process was completed successfully. 0 tasks and 0 instances were successfully removed from the search index.
This shows that one can NOT cleanup instances that are suspended; the instance either needs to be resumed, and then completed, OR terminated, before cleanup can take place
Run Instance Cleanup for Procurement Sample; only for Active Instances
print AdminTask.BPMProcessInstancesCleanup('[-containerAcronym STPPS1 -containerSnapshotAcronym PSV8570 -instanceStatus ALL -instanceID [ 11 ]]')
The BPMProcessInstancesCleanup command passed.
Check results in AppCluster Logs
tail -f /opt/ibm/WebSphereProfiles/AppSrv01/logs/AppClusterMember1/SystemOut.log
[04/01/17 16:46:24:475 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesCleanup Entering
[04/01/17 16:46:24:489 GMT] 000001eb Log I PAL: The process instance with the ID '11' is in the state '1' which is not a specified state and will not be deleted.
[04/01/17 16:46:24:494 GMT] 000001eb CommandServic I PALAdminCommands otherProcessInstancesCleanup Exiting
[04/01/17 16:46:34:029 GMT] 00000124 ProcessIndexB I CWLLG0757I: The purge process was completed successfully. 0 tasks and 0 instances were successfully removed from the search index.
This shows that one can NOT cleanup instances that are active; the instance either needs to be completed, OR terminated, before cleanup can take place