Tag Archives: nzsql

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

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

Assessing query performance … by table?

While looking for performance optimization opportunities, I decided to look at things from a slightly different perspective: by table.  I’m not entirely sure how helpful this will be – but since I wrote the query I figured I’d put it … Continue reading

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

Generating TPC-DS database and data in Netezza

“”The TPC-DS benchmark models the decision support system of a retail product supplier, including queries and data maintenance.” via TPC-DS. Working in retail, I’ve always wondered if a very generic data set existed that I could use on development systems … Continue reading

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