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

NSJMS Installation and Configuration for TNS/R
NonStop Server for Java Message Service User’s Manual—522356-006
2-19
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 through
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.
Uninstalling NSJMS
To remove an installed version of NSJMS, follow these steps from within the OSS
environment:
1. Remove the NSJMS library archive.

If NonStop Server for Java (T0083V31) is installed use these commands:

If NonStop Server for Java (T2766V10) is installed use these commands:
2. Rerun the make utility by using these commands:
3. Remove the NSJMS Administrative servlet.
a. Remove the modifications made to the iTP Secure WebServer servlet.config
file in Step 3 on page 6-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/java_public_lib
OSH: rm libnsjms.a
OSH: cd /usr/tandem/java/install
OSH: make