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-16
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

btool.sh. The btool.sh script is used to launch the reliable messaging bridge
configuration tool which is used to map between queues and topics and to
define the persistent environment parameters.

start_template.txt. This file is used by the configuration tool to generate
an executable Pathway start script.

stop_template.txt. This file is used by the configuration tool to generate
an executable Pathway stop script.
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. For information about planning and executing table partitioning,
see the SQL/MP Installation and Management Guide .
In these examples, the SQLCI ALTER TABLE command partitions 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