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
Table 1. Functions for 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
Table 2. Functions for 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
Table 3. Functions for 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
Table 4. Functions for 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. |
Diagnostic measures
Table 6. Functions for 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
Table 7. Functions for discretization and moments
| 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
Table 8. Functions for 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
Table 9. Functions for 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
Table 10. Functions for 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
Table 11. Functions for 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
Table 12. Functions for sampling
| Netezza function |
Db2 Warehouse function |
Changes and limitations |
| RANDOM_SAMPLE |
RANDOM_SAMPLE |
None. |
Sequential patterns
Table 13. Functions for 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
Table 14. Functions for 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
Table 15. Functions for 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
Table 16. Functions for 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. |