If you have created a broker that uses a Sybase database, and you expect to run message flows that include message aggregation, you are recommended to apply row-level locking to the aggregation table in the database. If you do not plan to use aggregation, you do not have to make this change.
If you do not apply row-level locking, and your use of message aggregation is too great, the broker will experience deadlock problems.
To apply row-level locking:
sp_help BAGGREGATE go
The locking scheme is displayed: lock scheme datarows.
If the change has not completed, it is displayed as: lock scheme allpages.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ah14510_ |