If you have created a broker that uses a Sybase database, and you expect extensive use of retained publications with multiple topics, apply row-level locking to the retained publications table in the database. If you do not plan to use retained publications, or expect their use to be infrequent, you do not have to make this change.
If you do not apply row-level locking, and your use of retained publications is too great, the broker will experience deadlock problems.
To apply row-level locking:
sp_help BRETAINEDPUBS go
The locking scheme is displayed: lock scheme datarows.
If the change has not completed, it is displayed as: lock scheme allpages.