Finding the next messages to be sent out on a thread

When there is a backlog of messages to be sent, it can be useful to know what the the next tansaction is going to be.

For example, there could be an issue with a transaction that abruptly ends a process. It would be helpful if you could know the queue order of the next transactions to be sent.

You can find the next messages to be sent out to a thread from the recovery database using filters and sorting with hcidbdump.

  1. On the command line, specify hcidbdump with the recovery database:
    hcidbdump -r
    If the source thread is conn_1, append the -f conn_1 flag.
  2. Specify the state. For example, state 11 is: -s 11
  3. Sort by outbound time. For example: -O o
    This displays the messages to be sent out next from the recovery database. For example:
    C:\cloverleaf\cis6.1\integrator\639442_orig>hcidbdump -r -s conn_1 -s 11 -O o

    The output is:

     C
     l T
     a y F
     s p w
    Created   Message Id  s e d  Prio  State  Length  Source  Dest
    -------   ----------  - - -  ----  -----  ------  ------  ------
    16:52:14  [0.0.8]     P D N  5120   11     594    conn_1  conn_2
    16:52:14  [0.0.10]    P D N  5120   11     582    conn_1  conn_2
    16:52:15  [0.0.12]    P D N  5120   11     575    conn_1  conn_2
    16:52:16  [0.0.14]    P D N  5120   11     591    conn_1  conn_2