Skip to Content
0
Jan 18, 2018 at 06:25 PM

Any status update on CR 811073 ( hash() on varbinary columns can use up procedure cache)

75 Views Last edit Jan 18, 2018 at 06:27 PM 3 rev

We have a bunch of large varbinary columns in use at our site. I've been using rs_subcmp to check replicate db copies (because of sporadic repserver crashes with large varbinary data (with no stacktrace data: CR 811377) ).

But if I use the "-h" option with rs_subcmp, it calls the hash() function in ASE for the varbinary columns, and ends up filling up the procedure cache (causing ASE stability problems).

CR 811073 was created for this. I don't see it in the Knowledge Base yet. Any status update on it?

Thanks in advance
Ben