Resolution:
# If Checkpoints are used and engines are configured in FT mode ( deployed on multiple machines)  then the checkpoint information can be stored either on a shared file system or a DB.

#2 If duplicate detection is enabled across multiple engines then the storage has to be on *DB ONLY*

#3 If “shared variables” need to be used across multiple engines then the storage has to be on *DB ONLY*.

#4 If “wait/notify” is used across multiple engines on different machines then the storage has to be on *DB ONLY*.

#5 If “critical section” group is used across multiple engines on different machines then the storage has to be on *DB ONLY*.

Anytime multiple engines are involved, it is DB ONLY and, of course, with all engines configured to same *DATABASE TABLES*.  FT allows File because only one engine at a time is actually running.  The backup engine when it takes over replaces the primary engine

Keywords:- database, BW, checkpoint, wait, notify, duplicate detection, shared variable, critical section

Can BW engines in FT deployed across multiple machines use file as storage for checkpointed jobs ?