[TRAFODION-2698] Ensure RMS can be disabled properly

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: any
• Fix Version/s: 2.2.0
• Component/s: sql-exe
• Assignee: Selvaganesan Govindarajan
• Reporter: Selvaganesan Govindarajan
• Created: 29/Jul/17 00:03
• Updated: 15/Sep/18 07:32
• Resolved: 12/Oct/17 21:49

Description

By default, RMS gets started. If you stop RMS, the shared segment stay around and hence all the process would continue to assume RMS is up. The proper way to disable RMS is

export SQ_START_RMS=0
Then do sqstart

This would be the proper way to disable RMS in future.

We encounter cores of SQL processes and improper message with the above scenario. Disabling RMS in the above way ensures that the shared segment is never used.

Issue Links

• links to: GitHub Pull Request #1191