NonStop JMS User's Manual (H06.03+, J06.03+, NonStop JMS 3.0+)

NSJMS Installation and Configuration for TNS/E
NonStop Server for Java Message Service User’s Manual—522356-006
3-18
Overflow Table Partitioning
The creatsql file that is provided with NSJMS includes this command to insert a
dummy record that has a destination ID value of 0.
The destination ID value of 0 is never assigned as a destination.
When you create a new partition that has a destination ID range of 5000 to 10000, this
command adds a dummy record that has a destination ID value of 5000:
Then use the administrative utility ADD Command on page 7-2 to assign destination
IDs for the new partition starting at 5001.
Overflow Table Partitioning
You can also partition an overflow table by using commands similar to those used to
partition SQL/MP tables. The overflow table holds messages larger than approximately
3900 bytes. If large messages are used, the overflow table should be partitioned to
match the message table.
SQLCI>> INSERT INTO MESSAGE VALUES (0, 0, 1000000000000000000,0,'');
SQLCI>> INSERT INTO MESSAGE VALUES (5000, 0, 1000000000000000000,0,'');