# In-database analytics compatibility

In most cases, Db2® Warehouse provide the same analytic functions that are available in IBM PureData® System for Analytics Netezza®). For example, in most cases, a particular Netezza analytic function has an equivalent Db2 Warehouse analytic function. In some cases, changes are required.

## Compatibility matrix for IBM PureData System for Analytics (Netezza) built-in and Db2 Warehouse analytic functions

The following tables identify the Netezza functions of the corresponding category and, if ported to Db2 Warehouse, the corresponding Db2 Warehouse functions. The tables also show changes and limitations.

The categories and the corresponding functions are sorted alphabetically.

## Association rules

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

ARULE | ASSOCRULES | New routine with new parameters. Migration required. |

PREDICT_ARULE | PREDICT_ASSOCRULES | New routine with new parameters. Migration required. |

PRINT_ARULE | PRINT_MODEL | New routine with new parameters. Migration required. |

VERIFY_ARULE | No alternative is available. | Not applicable. |

## Classification

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

CROSS_VALIDATION | No alternative is available. | Not applicable. |

DECTREE | DECTREE | None. |

GROW_DECTREE | GROW_DECTREE | None. |

KNN | KNN | New sampling: 10000 by default instead of unlimited sampling. Additional parameters: maxsize and randseed. |

NAIVEBAYES | NAIVEBAYES | None. |

PERCENTAGE_SPLIT | No alternative is available. | Use classification algorithms and quality measures instead. |

PMML_DECTREE | PMML_MODEL | None. |

PMML_NAIVEBAYES | No alternative is available. | Not applicable. |

PREDICT_DECTREE | PREDICT_DECTREE | None. |

PREDICT_KNN | PREDICT_KNN | None. |

PREDICT_NAIVEBAYES | PREDICT_NAIVEBAYES | None. |

PRINT_DECTREE | PRINT_MODEL | Use PRINT_MODEL instead. |

PRUNE_DECTREE | PRUNE_DECTREE | None. |

TRAIN_TEST | No alternative is available. | Use classification algorithms and quality measures instead. |

## Clustering

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

DIVCLUSTER | No alternative is available. | Not applicable. |

KMEANS | KMEANS | The mahalanobis parameter values is not available. |

PREDICT_DIVCLUSTER | No alternative is available. | Not applicable. |

PREDICT_KMEANS | PREDICT_KMEANS | Not all parameter values available. |

PREDICT_TWOSTEP | No alternative is available. | This stored procedure is implemented using Apache Spark, and can be used only on a Db2 Warehouse system for which Spark capability is enabled. |

PRINT_KMEANS | PRINT_MODEL | Use PRINT_MODEL and the respective parameters for KMEANS instead. |

PRINT_TWOSTEP | PRINT_MODEL | New routine with new parameters. Migration required. |

SET_CLUSTERNAME | No alternative is available. | Not applicable. |

TWOSTEP | No alternative is available. | None. |

## Column properties

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

COLUMN_PROPERTIES | COLUMN_PROPERTIES | None. |

GET_COLUMN_LIST | GET_COLUMN_LIST | None. |

SET_COLUMN_PROPERTIES | SET_COLUMN_PROPERTIES | None. |

## Data transformation

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

IMPUTE_DATA | IMPUTE_DATA | None. |

PCA | No alternative is available. | Not applicable. |

PROJECT_PCA | No alternative is available. | Not applicable. |

SPLIT_DATA | SPLIT_DATA | None. |

STD_NORM | STD_NORM | None. |

## Diagnostic measures

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

ACC | ACC | None. |

CERROR | CERROR | None. |

CMATRIX_ACC | CMATRIX_ACC | None. |

CMATRIX_STATS | CMATRIX_STATS | None. |

CMATRIX_WACC | CMATRIX_WACC | None. |

CONFUSION_MATRIX | CONFUSION_MATRIX | None. |

FMEASURE | FMEASURE | None. |

FPR | FPR | None. |

MAE | MAE | None. |

MSE | MSE | None. |

PPV | PPV | None. |

RAE | RAE | None. |

RSE | RSE | None. |

TPR | TPR | None. |

WACC | WACC | None. |

## Discretization

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

No Netezza function is available. | AGGDISC | None. |

APPLY_DISC | APPLY_DISC | None. |

EFDISC | EFDISC | None. |

EMDISC | EMDISC | None. |

EWDISC | EWDISC | None. |

EWDISC_NICE | EWDISC_NICE | None. |

## Model management

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

ALTER_MODEL | ALTER_MODEL | None. |

CLEANUP | CLEANUP | None. |

COPY_MODEL | COPY_MODEL | None. |

DROP_ALL_MODELS | DROP_ALL_MODELS | None. |

DROP_MODEL | DROP_MODEL | None. |

EXPORT_MODEL | EXPORT_MODEL | None. |

EXPORT_PMML | EXPORT_PMML | None. |

GRANT_MODEL | GRANT_MODEL | None. |

IMPORT_MODEL | IMPORT_MODEL | None. |

INITIALIZE | INITIALIZE | Only needed on a Db2 Warehouse system. |

IS_INITIALIZED | IS_INITIALIZED | Only needed on a Db2 Warehouse system. |

LIST_COLPROPS | LIST_COLPROPS | None. |

LIST_COMPONENTS | LIST_COMPONENTS | None. |

LIST_MODELS | LIST_MODELS | None. |

LIST_PARAMS | LIST_PARAMS | None. |

LIST_PRIVILEGES | LIST_PRIVILEGES | None. |

METADATA_ANALYZE | No alternative is available. | Not applicable. |

MIGRATE_MODEL | No alternative is available. | Not required on Db2 systems. |

MODEL_EXISTS | MODEL_EXISTS | None. |

PMML_MODEL | PMML_MODEL | None. |

PRINT_MODEL | PRINT_MODEL | None. |

REGISTER_MODEL | No alternative is available. | Not required on Db2 systems. |

REVOKE_MODEL | REVOKE_MODEL | None. |

## Probability distributions

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

CUMULATIVE | No alternative is available. | Not applicable. |

DBERN | DBERN | None. |

DBETA | DBETA | None. |

DBINOM | DBINOM | None. |

DCAUCHY | DCAUCHY | None. |

DCHISQ | DCHISQ | None. |

DENSITY | DENSITY | None. |

DEXP | DEXP | None. |

DF | DF | None. |

DFISK | DFISK | None. |

DGAMMA | DGAMMA | None. |

DGEOM | DGEOM | None. |

DHYPER | DHYPER | None. |

DLNORM | DLNORM | None. |

DLOGIS | DLOGIS | None. |

DMWW | DMWW | None. |

DNBINOM | DNBINOM | None. |

DNORM | DNORM | None. |

DNORM3P | DNORM3P | None. |

DPOIS | DPOIS | None. |

DT | DT | None. |

DUNIF | DUNIF | None. |

DWALD | DWALD | None. |

DWEIBULL | DWEIBULL | None. |

DWILCOX | DWILCOX | None. |

PBERN | PBERN | None. |

PBERN_H | PBERN_H | None. |

PBETA | PBETA | None. |

PBETA_H | PBETA_H | None. |

PBINOM | PBINOM | None. |

PBINOM_H | PBINOM_H | None. |

PCAUCHY | PCAUCHY | None. |

PCAUCHY_H | PCAUCHY_H | None. |

PCHISQ | PCHISQ | None. |

PCHISQ_H | PCHISQ_H | None. |

PCHISQ_S | PCHISQ_S | None. |

PEXP | PEXP | None. |

PEXP_H | PEXP_H | None. |

PF | PF | None. |

PF_H | PF_H | None. |

PFISK | PFISK | None. |

PFISK_H | PFISK_H | None. |

PGAMMA | PGAMMA | None. |

PGAMMA_H | PGAMMA_H | None. |

PGEOM | PGEOM | None. |

PGEOM_H | PGEOM_H | None. |

PHYPER | PHYPER | None. |

PHYPER_H | PHYPER_H | None. |

PLNORM | PLNORM | None. |

PLNORM_H | PLNORM_H | None. |

PLOGIS | PLOGIS | None. |

PLOGIS_H | PLOGIS_H | None. |

PMWW | PMWW | None. |

PMWW_H | PMWW_H | None. |

PNBINOM | PNBINOM | None. |

PNBINOM_H | PNBINOM_H | None. |

PNORM | PNORM | None. |

PNORM3P | PNORM3P | None. |

PNORM_H | PNORM_H | None. |

PPOINT | PPOINT | None. |

PPOIS | PPOIS | None. |

PPOIS_H | PPOIS_H | None. |

PT | PT | None. |

PT_H | PT_H | None. |

PUNIF | PUNIF | None. |

PUNIF_H | PUNIF_H | None. |

PWALD | PWALD | None. |

PWALD_H | PWALD_H | None. |

PWEIBULL | PWEIBULL | None. |

PWEIBULL_H | PWEIBULL_H | None. |

PWILCOX | PWILCOX | None. |

PWILCOX_H | PWILCOX_H | None. |

QBERN | QBERN | None. |

QBERN_H | QBERN_H | None. |

QBETA | QBETA | None. |

QBETA_H | QBETA_H | None. |

QBINOM | QBINOM | None. |

QBINOM_H | QBINOM_H | None. |

QCAUCHY | QCAUCHY | None. |

QCAUCHY_H | QCAUCHY_H | None. |

QCHISQ | QCHISQ | None. |

QCHISQ_H | QCHISQ_H | None. |

QEXP | QEXP | None. |

QEXP_H | QEXP_H | None. |

QF | QF | None. |

QF_H | QF_H | None. |

QFISK | QFISK | None. |

QFISK_H | QFISK_H | None. |

QGAMMA | QGAMMA | None. |

QGAMMA_H | QGAMMA_H | None. |

QGEOM | QGEOM | None. |

QGEOM_H | QGEOM_H | None. |

QHYPER | QHYPER | None. |

QHYPER_H | QHYPER_H | None. |

QLNORM | QLNORM | None. |

QLNORM_H | QLNORM_H | None. |

QLOGIS | QLOGIS | None. |

QLOGIS_H | QLOGIS_H | None. |

QMWW | QMWW | None. |

QMWW_H | QMWW_H | None. |

QNBINOM | QNBINOM | None. |

QNBINOM_H | QNBINOM_H | None. |

QNORM | QNORM | None. |

QNORM3P | QNORM3P | None. |

QNORM_H | QNORM_H | None. |

QPOIS | QPOIS | None. |

QPOIS_H | QPOIS_H | None. |

QT | QT | None. |

QT_H | QT_H | None. |

QUNIF | QUNIF | None. |

QUNIF_H | QUNIF_H | None. |

QWALD | QWALD | None. |

QWALD_H | QWALD_H | None. |

QWEIBULL | QWEIBULL | None. |

QWEIBULL_H | QWEIBULL_H | None. |

QWILCOX | QWILCOX | None. |

QWILCOX_H | QWILCOX_H | None. |

## Quantiles and outliers

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

IQR | No alternative is available. | Not applicable. |

MEDIAN | No alternative is available. | Not applicable. |

MEDIAN_DISC | No alternative is available. | Not applicable. |

OUTLIERS | No alternative is available. | Not applicable. |

QUANTILE | No alternative is available. | Not applicable. |

QUANTILE_DISC | No alternative is available. | Not applicable. |

QUARTILE | No alternative is available. | Not applicable. |

QUARTILE_DISC | No alternative is available. | Not applicable. |

## Regression

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

BTBNET_GROW | No alternative is available. | Not applicable. |

GLM | No alternative is available. | None. |

GROW_REGTREE | GROW_REGTREE | None. |

LINEAR_REGRESSION | LINEAR_REGRESSION | Not available on Linux on IBM z Systems. |

MTBNET_DIFF | No alternative is available. | Not applicable. |

MTBNET_GROW | No alternative is available. | Not applicable. |

PREDICT_GLM | No alternative is available. | None. |

PREDICT_LINEAR_REGRESSION | PREDICT_LINEAR_REGRESSION | Not available on Linux on IBM z Systems. |

PREDICT_REGTREE | PREDICT_REGTREE | None. |

PRINT_GLM | No alternative is available. | Not applicable. |

PRINT_REGTREE | PRINT_MODEL | Use PRINT_MODEL instead. |

PRUNE_REGTREE | PRUNE_REGTREE | None. |

REGTREE | REGTREE | None. |

TANET_APPLY | No alternative is available. | Not applicable. |

TANET_CLASSAPPLY | No alternative is available. | Not applicable. |

TANET_GROW | No alternative is available. | Not applicable. |

TBNET1G | No alternative is available. | Not applicable. |

TBNET1G2P | No alternative is available. | Not applicable. |

TBNET2G | No alternative is available. | Not applicable. |

TBNET_APPLY | No alternative is available. | Not applicable. |

TBNET_GROW | No alternative is available. | Not applicable. |

## Sampling

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

RANDOM_SAMPLE | RANDOM_SAMPLE | None. |

## Sequential patterns

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

PREDICT_SEQRULES | PREDICT_SEQRULES | None. |

PRINT_SEQRULES | PRINT_MODEL | Use PRINT_MODEL instead. |

PRUNE_SEQRULES | PRUNE_SEQRULES | None. |

SEQRULES | SEQRULES | None. |

## Statistics

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

ANOVA_CRD_TEST | ANOVA_CRD_TEST | None. |

ANOVA_RBD_TEST | ANOVA_RBD_TEST | None. |

BITABLE | No alternative is available. | Not applicable. |

CHISQ_TEST | CHISQ_TEST | None. |

CHISQ_TEST_AGG | CHISQ_TEST_AGG | None. |

CHISQ_TEST_S_AGG | CHISQ_TEST_S_AGG | None. |

COL2TRCV_MANOVA_ONE_WAY_TEST | No alternative is available. | Not applicable. |

COL2TRCV_MANOVA_TWO_WAY_TEST | No alternative is available. | Not applicable. |

DROP_SUMMARY1000 | DROP_SUMMARY1000 | None. |

HIST | No alternative is available. | Not applicable. |

JOINT_ENTROPY | JOINT_ENTROPY | None. |

KURTOSIS_AGG | KURTOSIS_AGG | None. |

LDF_MANOVA_ONE_WAY_TEST | No alternative is available. | Not applicable. |

LDF_MANOVA_TWO_WAY_TEST | No alternative is available. | Not applicable. |

MANOVA_ONE_WAY_TEST | No alternative is available. | Not applicable. |

MANOVA_TWO_WAY_TEST | No alternative is available. | Not applicable. |

MOMENTS | MOMENTS | None. |

MUTUALINFO | MUTUALINFO | None. |

MUTUALINFO_AGG | MUTUALINFO_AGG | None. |

MWW_TEST | MWW_TEST | None. |

No Netezza function is available. | NUMERIC_SUMMARY | None. |

PRINT_MANOVA_ONE_WAY_TEST | No alternative is available. | Not applicable. |

PRINT_MANOVA_TWO_WAY_TEST | No alternative is available. | Not applicable. |

SKEWNESS_AGG | SKEWNESS_AGG | None. |

SPEARMAN_CORR | SPEARMAN_CORR | None. |

SPEARMAN_CORR_S | No alternative is available. | Not applicable. |

SUMMARY1000 | SUMMARY1000 | The talk parameter is deprecated and has no action. |

SUMMARY1000CHAR | SUMMARY1000CHAR | The talk parameter is deprecated and has no action. |

SUMMARY1000DATE | SUMMARY1000DATE | The talk parameter is deprecated and has no action. |

SUMMARY1000INTERVAL | No alternative is available. | Not applicable. |

SUMMARY1000NUM | SUMMARY1000NUM | The talk parameter is deprecated and has no action. |

SUMMARY1000TIME | SUMMARY1000TIME | The talk parameter is deprecated and has no action. |

SUMMARY1000TIMESTAMP | SUMMARY1000TIMESTAMP | The talk parameter is deprecated and has no action. |

T_LS_TEST | T_LS_TEST | The output table has a different format. |

T_LS_TEST_S_AGG | T_LS_TEST_S_AGG | None. |

T_ME_TEST | T_ME_TEST | The output table has a different format. |

T_ME_TEST_S_AGG | T_ME_TEST_S_AGG | None. |

T_PMD_TEST | T_PMD_TEST | The output table has a different format. |

T_PMD_TEST_S_AGG | No alternative is available. | Not applicable. |

T_TEST_AGG | T_TEST_AGG | The output table has a different format. |

T_TEST_S_AGG | T_TEST_S_AGG | None. |

No Netezza function is available. | SPLIT_TEST_S | None. |

T_UMD_TEST | T_UMD_TEST | The output table has a different format. |

UNITABLE | No alternative is available. | Not applicable. |

WILCOXON_TEST | WILCOXON_TEST | None. |

## Timeseries

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

PRINT_TIMESERIES | No alternative is available. | Not applicable. |

TIMESERIES | No alternative is available. | Not applicable. |

## Utilities

Netezza function | Db2 Warehouse function | Changes and limitations |
---|---|---|

msghelp | No alternative is available. | Not applicable. |

_sp_utl_dropAllAggregates | No alternative is available. | Not applicable. |

_sp_utl_dropAllFunctions | No alternative is available. | Not applicable. |

_sp_utl_dropAllLike | No alternative is available. | Not applicable. |

_sp_utl_dropAllProcedures | No alternative is available. | Not applicable. |

_sp_utl_dropAllUDX | No alternative is available. | Not applicable. |

_sp_utl_justExecute | No alternative is available. | Not applicable. |

DROP_TABLE | No alternative is available. | Not applicable. |

_sp_utl_aggregateExists | No alternative is available. | Not applicable. |

_sp_utl_columnContainsNulls | No alternative is available. | Not applicable. |

_sp_utl_columnExists | No alternative is available. | Not applicable. |

_sp_utl_columnIsId | No alternative is available. | Not applicable. |

_sp_utl_columnIsNumeric | No alternative is available. | Not applicable. |

_sp_utl_columnListExists | No alternative is available. | Not applicable. |

_sp_utl_columnsEqualTypes | No alternative is available. | Not applicable. |

_sp_utl_functionExists | No alternative is available. | Not applicable. |

_sp_utl_isTempTable | No alternative is available. | Not applicable. |

_sp_utl_procedureExists | No alternative is available. | Not applicable. |

_sp_utl_relationExists | No alternative is available. | Not applicable. |

_sp_utl_sequenceExists | No alternative is available. | Not applicable. |

_sp_utl_tableExists | No alternative is available. | Not applicable. |

_sp_utl_viewExists | No alternative is available. | Not applicable. |

ISDATE_TINY | No alternative is available. | Not applicable. |

_sp_utl_getColumnType | No alternative is available. | Not applicable. |

_sp_utl_getTableSize | No alternative is available. | Not applicable. |

drand64 | No alternative is available. | Not applicable. |