IBM PureData System for Analytics (Netezza) and Db2 system view compatibility
Netezza system views are not automatically mapped to Db2® system views, but you can manually replace Netezza views with similar Db2 views.
The following table maps some of the most commonly used Netezza system views to their closest Db2 equivalents. Also, if you used _t_* Netezza system tables, use the following table to help determine which Db2 system views to use instead.
| Netezza® system view | Db2 system view |
|---|---|
| _v_aggregate | SYSCAT.ROUTINES |
| _v_environ | SYSIBMADM.ENV_INST_INFO |
| _v_external | SYSCAT.EXTERNAL_TABLEOPTIONS |
| _v_extobject | SYSCAT.TABLES |
| _v_function | SYSCAT.ROUTINES |
| _v_procedure | SYSCAT.ROUTINES |
| _v_relation_column | SYSCAT.COLUMNS |
| _v_relation_column_def | SYSCAT.COLUMNS |
| _v_schema | SYSCAT.SCHEMAMATA |
| _v_statistic | SYSSTAT.TABLES |
| _v_synonym | SYSCAT.TABLES (when querying, specify TYPE ='A', as shown in the following example:
|
| _v_sys_columns | SYSCAT.COLUMNS |
| _v_sys_datatype | SYSCAT.DATATYPES |
| _v_table | SYSCAT.TABLES |
| _v_view | SYSCAT.VIEWS |
In addition, instead of the Netezza _v_session view, you can use the Db2 MON_GET_CONNECTION table function.