Allows RANDOM function compatibility between systems managed by Teradata Business Continuity Manager that are running different database versions.
Prior database releases had an issue with the RANDOM function, RANDOM(lower_bound,upper_bound), whereby, in rare instances, the function could return a value that was one greater than the specified upper_bound. Although this issue has been fixed, Business Continuity Manager-paired systems, RANDOM function behavior must be consistent between systems. This field ensures that the RANDOM function behaves identically for systems managed by Teradata Business Continuity Manager, regardless of the database version each system is running.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| TRUE | Ensures consistent and correct results for RANDOM function operations when multiple systems managed by Teradata Business Continuity Manager have the FixSRandomRange field available. |
| FALSE | Maintains consistency of RANDOM function results between multiple systems managed by Teradata Business Continuity Manager when the FixSRandomRange field is not available on all systems. |
Default
TRUE on systems initialized (sysinited) on Teradata Database 15.0 or for which this issue with the RANDOM function has been fixed.
FALSE on systems upgraded from prior releases and not re-initialized, where this RANDOM issue still exists.
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
If all systems being managed by Teradata Business Continuity Manager have FixSRandomRange available in DBS control, it should be set to TRUE on all systems. Otherwise, it should be set to FALSE on all systems where the field is available.
Related Information
| For more information on… | See… |
|---|---|
| the RANDOM function | Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145 |
| Teratada Business Continuity Manager | Teradata® Business Continuity Manager User Guide, B035-2550 |