Just start up two lisp images and connect to the same database. Transactions will ensure there is no interaction between processes. This has not been extensively tested, but should work without any problem. Any field experience will get reflected in this section of the manual
Distributed applications may be supported if the underlying SQL server or an appropriate Berkeley DB database is used. We provide no documentation nor have we heard of this use-case. This remains fertile ground for future investigation.