[TRAFODION-2146] Use of CQD to set scratch directory locations

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: foundation, sql-exe
• Assignee: Sandhya Sundaresan
• Reporter: Sandhya Sundaresan
• Created: 05/Aug/16 19:36
• Updated: 05/Sep/18 21:31
• Resolved: 02/Sep/16 21:36

Description

Allow a CQD specification to override the env settings for STFS locations.

Currently the scratch directory locations and set at installtion time . The STFS layer that manages the scratch file creation reads the envvar in ms.env to determine where to create the scratch files.
Now we allow a CQD to be specified that will override the envvar setting. If the CQD is not set (empty) , the envvar setting will work. This will give the user some flexibility to change scratch directory locations. The requirement is that the directoryies MUST exists on every node and that Trafodion user will need permissions to write to those directories. If not an error will be returned when a query invliving sort/hash overflow is executed. .

Issue Links

• links to: GitHub Pull Request #647