NonStop JMS User's Manual (NonStop JMS 2.0+)

NSJMS Installation and Configuration
NonStop Server for Java Message Service User’s Manual—522356-002
2-17
SQL/MP Table Partitioning
•
/examples – Contains
°
SimpleSender.java. This sample program sends simple messages to a
queue.
°
SimpleReceiver.java. This sample program receives simple messages
from a queue.
°
SimplePublisher.java. This sample program publishes simple messages
to a topic.
°
SimpleConsumer.java. This sample program subscribes and consumes
messages from a topic.
°
JmsAdminServlet.html. This sample program uses the administrative
servlet.
°
web.xml. This file is used with the administrative servlet sample program.
°
/bridge – Contains
°
readme.txt. This file contains instructions that describe how to build and
run a Bridge between clients.
°
Bridge.java. This sample program runs a Bridge between different
NSJMS providers or between an NSJMS provider and another JMS
provider.
°
The remainder of the files are used by the Bridge.java sample program.
SQL/MP Table Partitioning
You can optionally partition SQL/MP tables to achieve greater scalability by adding
range partitioning to the message table. Partitioning spreads the space required by
queues or topics across several disks and also spreads the DP2 execution load across
several processors. See the Compaq NonStop SQL/MP Installation and Management
Guide for information about planning and executing table partitioning.
In these examples, the SQLCI ALTER TABLE command is used to partition SQL/MP
tables. An existing message table residing on $VOL1 is split into two partitions
resulting in the new partition residing on $VOL2:
SQLCI>> ALTER TABLE $VOL1.NSJMS.MESSAGE
+> PARTONLY MOVE FROM KEY (10000,0) TO $VOL2.NSJMS.MESSAGE
+> CATALOG $VOL1.NSJMS
+> EXTENT (1000,200);
--- SQL OPERATION COMPLETE