Tag Archives: script

Setting custom properties for Hive databases

Hive supports the concept of a database as a logical collection of objects stored in separate catalogs or namespaces. One neat thing that you can do with Hive is add extended properties to your database that are displayed when describing … Continue reading

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

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

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