Db2

 View Only
  • 1.  DBMS_RANDOM

    Posted Thu April 08, 2021 09:44 AM

    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?


    #Db2
    #Db2EarlyAccessProgram(EAP)Forum


  • 2.  RE: DBMS_RANDOM

    Posted Thu April 08, 2021 09:44 AM
    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