View Queue Data Dialog Box

The View Queue Data dialog box lets you filter and sort the data from a queue as an aid in troubleshooting transactions in the queue. You can also edit, delete, or undelete a given command, or purge the first transaction in the queue.

The View Queue Data dialog box contains the following fields:

Filter fields, which let you select the type of filters that the Replication Manager uses to display data from the queue. These filters include:
- Column
- Column value
- Segment
- Starting block
- Number of blocks displayed
- Number of rows displayed
- Whether to start at the first active segment or not
- Whether to include all data to the end of the segment
- Whether to include all rows or not
- Whether you want to show deleted data
- Whether to view all data to the end of the queue
General buttons, which let you:
- Display the queue data with the current filters
- Close the dialog box
- Purge the first transaction from the queue
- Edit transactions
- Delete transactions
- Undelete transactions
- Group transactions, which returns the Queue Data scrolling list display back to grouped transactions
Queue Data scrolling list, which contains rows of data from the current queue. Each column contains specific information about the command and transaction contained in each row. For example, to sort the queue data by a specific column, select that column name. The Queue Data scrolling list refreshes, sorting the data according to that column. An arrow displays next to the column name to show that you have sorted the data by that column. The columns you can sort by include:
- Segment
- Transaction Name
- Command
- Origin Site
- Origin Commit Time
- Origin User
- Transaction ID
- Origin QID

Note:

You can only delete, undelete, or purge queue transactions when Replication Server is in standalone mode. For more information, see “Managing Replication Server with Sybase Central” in the Replication Server Administration Guide Volume 1.