Overview of Running Scoring Models in DB2

There are two ways to run scoring models in DB2.
  • You can create scoring functions for each EM_ output variable. The model publishing macro creates the scoring functions that are published as DB2 user-defined functions. These functions can then be used in any SQL query. For more information, see Using Scoring Functions to Run Scoring Models.
  • Starting with the December 2011 release, you can also use the SAS Embedded Process. The SAS Embedded Process is a SAS server process that runs inside DB2 to read and write data. The model publishing macro creates scoring files. These scoring files are then used by a DB2 built-in function to run the scoring model. For more information, see Using the SAS Embedded Process to Run Scoring Models.