Tag Archives: netezza

Enabling Netezza Analytics for use in a database

Many of Netezza’s analytic functions require the presence of some metadata tables/views in order to work.  These tables/views are created when you initialize the analytic libraries in a particular database. SYSTEM(ADMIN)=> call nza..kmeans(‘intable=t1,id=int1,k=10,model=kmeans,outtable=out,maxiter=5’); ERROR:  The metadata tables are not initialized. … Continue reading

Posted in administration, analytics, General | Tagged , , , , , | Leave a comment

Dropping a Netezza Analytics model

The result of most of Netezza’s analytic functions are a series of tables.  The tables produced vary from function to function.  We schedule jobs to run the analytic functions and want to reuse the same model name so that our … Continue reading

Posted in administration, analytics, General | Tagged , , , | Leave a comment

Using nz_zonemap to visualize Netezza’s zone map effectiveness

Netezza has a lot of tools in /nz/support/contrib/bin that make life for the NZ DBA much, MUCH easier.  One such tool is nz_zonemap. Zone maps are how the system keeps track of what records exist in a particular extent (3MB … Continue reading

Posted in administration, General, Performance | Tagged , , , , | 3 Comments

The relationship between groom and nzbackup

There are three basic functions that every Netezza DBA must perform regularly: Ensure statistics are up to date Groom your tables Backup your production databases Let’s focus on groom and its dependency on nzbackup.  I recently ran into an issue … Continue reading

Posted in administration, General, Performance, Uncategorized | Tagged , , , , | Leave a comment

Using Netezza’s event manager to generate SNMP traps

If you have Tivoli ITM or Openview — or anything similar —  you can configure the Netezza event manager to generate SNMP traps instead of email alerts that can then be routed to your logging agent.  To do it, you … Continue reading

Posted in administration, General, Uncategorized | Tagged , , , , | Leave a comment

Market Basket Analysis with IBM Netezza Analytics

PLEASE NOTE: This article is outdated and does not reflect changes made in IBM Netezza Analytics V2   IBM Netezza’s analytics package became available earlier this year.  The documentation on it is okay but I think they went a little … Continue reading

Posted in analytics | Tagged , , , | Leave a comment