SQL query to display the Bps’ configuration in B2B Integrator

Oracle and DB2 query to display Business Process definition details for Sterling B2B Integrator:

select NAME, WFD.EXECNODE, WFD.PRIORITY QUEUE, WFD.LIFE_SPAN, WFD.PERSISTENCE_LEVEL PERSISTENCE_LEVEL_ID,

CASE PERSISTENCE_LEVEL

when 0 then 'SystemDefault'

when 1 then 'Full'

when 3 then 'StepStatusEMO'

when 4 then 'StartStopEMO'

when 5 then 'StepStatusOnly'

when 8 then 'StartStop'

when 9 then 'Zero'

when 10 then 'ErrorOnly'

else ''||persistence_level

END PERSISTENCE_LEVEL

from WFD wfd, wfd_versions wfdv

where WFD.WFD_ID=WFDV.WFD_ID and WFD.WFD_VERSION = WFDV.WFD_VERSION

and WFD.WFD_VERSION=WFDV.DEFAULT_VERSION;

MS SQL Server Version:

select NAME, WFD.EXECNODE, WFD.PRIORITY QUEUE, WFD.LIFE_SPAN, WFD.PERSISTENCE_LEVEL PERSISTENCE_LEVEL_ID,


CASE PERSISTENCE_LEVEL


when 0 then 'SystemDefault'


when 1 then 'Full'


when 3 then 'StepStatusEMO'


when 4 then 'StartStopEMO'


when 5 then 'StepStatusOnly'


when 8 then 'StartStop'


when 9 then 'Zero'


when 10 then 'ErrorOnly'

else 'other '
END PERSISTENCE_LEVEL

from WFD WFD, WFD_VERSIONS WFDV

where WFD.WFD_ID=WFDV.WFD_ID and WFD.WFD_VERSION = WFDV.WFD_VERSION

and WFD.WFD_VERSION=WFDV.DEFAULT_VERSION

You can add the Recovery_level column to the SQL query to display the BP recovery level information.

By default it is 3 (manual recovery).

WFD table Recovery_level meaning:

• Auto Resume : RECOVERY_LEVEL =1
• Auto Restart: RECOVERY_LEVEL =2
• Manual: RECOVERY_LEVEL =3
• Terminate: RECOVERY_LEVEL =4
• Auto Resume with Error: RECOVERY_LEVEL =5

Check more useful SQL queries:

• Useful SQL queries for Sterling B2B Integrator.
• TRANS_DATA related queries.
• Filegateway related SQL queries.
• Communication and adapter stats SQL.
• Slow services and steps SQL.