Retrieve a portion of the error/recover db at a time

[Todd Horst]

Occasionally we will have a major issue where either transaction all go to the error database or a large amount will be queued in the recover database.

Is there any way to get a list of the record ids, or a portion of the transactions at a time.

I know you can use -c to get a count, and that is partially useful to see if we are working with a large result set, but what would be really useful is if you could get like the first X amount, and then potentially loop over that if need be.

As it is I know no way to get a portion of the db and interacting with the db is painfully slow. If we could interact with a “page” at a time then we could work the errors faster.

Thanks,

Topic