Db2 (On Premises and Cloud)

Expand all | Collapse all

DBMS_RANDOM

  • 1.  DBMS_RANDOM

    Posted 10 days ago

    Hello,

     

    what are the algorithm behind the new DBMS_RANDOM module?

    Mersenne Twister

    Sobol

    Linear congruential generator

    Linear feedback shift Register

     

    just to list some  RNGs.

     

    Are they vectorized?



  • 2.  RE: DBMS_RANDOM

    Posted 10 days ago
    Hi Olaf. I don't know those details off the top of my head, but can say that this is essentially an interface ​wrapper around the existing SYSFUN.RAND, for application compatibility