rs_queuemsgtxt

Stores the command or text portion of messages in stable queues. Each stable queue entry is represented by one or more rows in this table. Multiple rows are needed when the length of data in the stable queue entry exceeds the maximum command field length of 255 bytes.

Column

Datatype

Description

q_number

int

Queue number

q_type

int

Queue type

q_seg

int

Segment that contains the message

q_blk

int

Block within the segment that contains the message

q_row

int

Row within the block that contains the message

q_seq

int

Sequence number of the row for this entry

txt

varchar(255)

Text of the entry

txtbin

binary(255)

Text in binary

Indexes

Unique default index on (q_number, q_type, q_seq, q_seg, q_blk, q_row)