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-19
Overflow Table Partitioning
The creatsql file that is provided with NSJMS includes this command to insert a
dummy record with a destination ID value of 0.
The destination ID value of 0 is never assigned as a destination.
When you create a new partition with a destination ID range of 5000 to 10000, this
command adds a dummy record with a destination ID value of 5000:
You should then use the administrative utility ADD Command to assign destination ID’s
for the new partition starting at 5001.
Overflow Table Partitioning
You can also partition overflows table by using commands similar to those used to
partition SQL/MP tables. The overflow table is used for messages larger than
approximately 3900 bytes. If large messages are used, the overflow table should be
partitioned to match the message table.
Uninstalling NSJMS
To remove an installed version of NSJMS, follow these steps from within the OSS
environment:
1. Remove the NSJMS library archive file by executing these commands:
2. Remove the JMS schema file from the sqlmx usermodules by executing these
commands:
where timestamp represents the timestamp for the version of NSJMS to remove.
3. Rerun the make utility by executing these commands:
4. Remove the NSJMS Administrative servlet.
a. Remove the modifications made to the iTP Secure WebServer servlet.config
file in Step 3 on page 4-2.
SQLCI>> INSERT INTO MESSAGE VALUES (0, 0, 1000000000000000000,0,'');
SQLCI>> INSERT INTO MESSAGE VALUES (5000, 0, 1000000000000000000,0,'');
OSH: cd /usr/tandem/java/jre/lib/oss/posix_threads
OSH: rm libnsjms.a
OSH: cd /usr/tandem/sqlmx/USERMODULES
OSH: rm TANDEM_SYSTEM_NSK.JMS_SCHEMA.LIBNSJMS_timestamp
OSH: cd /usr/tandem/java/install
OSH: make