[TRAFODION-3216] UDR libraries need to be stored in metadata table as a blob

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4
• Fix Version/s: 2.4
• Component/s: sql-general
• Assignee: Sandhya Sundaresan
• Reporter: Sandhya Sundaresan
• Created: 28/Sep/18 04:09
• Updated: 30/Nov/18 18:17
• Resolved: 30/Nov/18 18:17

Description

This is one of many  infrastructure changes for SPJs that was planned. 

• Store UDR libraries in BLOBs   

• Add BLOB column to library metadata table
• Change CREATE LIBRARY command to store library in BLOB
• Change library file names to include the timestamp (so updating a library changes the name)
• Add a cache for libraries (a new directory, $TRAF_HOME/udr/public/lib)
• Change UDR code to read library from the metadata table when not in cache
• Upgrade support

 

Issue Links

• links to: GitHub Pull Request #1721
• links to: GitHub Pull Request #1740