Skip to main content
๐Ÿ““ Tibero Online Manual Click here ๐Ÿ““

Search

Welcome to Tibero GTS!

Improvement of Initial Parameter Usage and Redevelopment of BTIP

Feature Number : 700481a

Overview* Specification improvement and stabilization of Initial Parameter
- Revamp of IPARAM related code API and enhancement of checks, logic improvement
- Refactoring of IPARAM related files 
- Added functions to iparam spec 
- Management of deprecated parameters
- Added alter system/session set parameter DDL functionality and complete structural refactoring
- Improved logic for TAC multi-instance parameter changes
 
* Restructuring of Binary tip and related feature improvements
- Changed to 4KB block unit storage and variable length parameter storage structure per instance 
 * Applied shadow paging in block group units
 * Improved BTIP path search priority
 * Added create btip reset / append options
 * Added btip dump functionality without reboot (tbsvr dump btip)
Details

Complete improvement and refactoring of internal initial parameter structure, binary tip, and alter system/session set DDL

1. Revamp of IPARAM API, enhanced checks, and logic improvement
 * Separation of Read/Write APIs within code
 * Improved session parameters to allow access without locks
 * Provided safe access APIs for all dynamic + string parameters
 * Strengthened compile-time static assert on incorrect sess/sys parameter access

2. Extension of IPARAM spec
 * Added resource items (CPU, MEMORY, STORAGE, SESSION, NETWORK)
  - Established tracking basis for parameters affected by resource changes
 * Added alternative item (specifies replacement parameter when deprecated)
 * Introduced session_only scope (cannot be changed by alter system, only alter session allowed)
 
3. Added handling and output features for deprecated parameters
 * Warning output when deprecated parameters are used during boot
 * If alternative is set in spec, recommended replacement parameter is output

4. Improvement and addition of alter system/session set parameter DDL features
 * Simplified syntax to allow scope and sid options only once per entire statement
 * Improved pre-check / pre-apply / post-apply logic per parameter
 * Fixed memory leak related to setparams when performing alter session
 * Simplified and optimized logic for NLS parameter derived processing
 * Added alter system reset feature (removes previously set parameters and initializes to default values) 
 
5. Improved logic for TAC multi-instance parameter changes
 * Supported changing parameters of other nodes in general tip via alter system set ... sid='*' / sid='<instance>'
 * Changed multi-instance parameter modification to best-effort approach (global atomicity not guaranteed, no full rollback on failure)
 * Improved detailed error output on errors changing parameters of other instances

6. Complete improvement of BTIP (Binary TIP) features
 * Changed to variable length parameter storage structure per instance (up to 100 instances)
 * Improved 4KB block unit storage and fast checksum verification
 * Applied shadow paging in block group units
 * Improved BTIP path search priority
 * Added create btip reset / append options
 * Supported forced down even if invalid parameters exist in btip
 * Added btip dump feature without reboot
 * Improved NLS derived parameter setting from per-session creation to once globally