Category Archives: administration

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

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

IBM Netezza analytics to analyze query history table usage

Using Netezza’s in-database analytics package FPGROWTH, database administrators can identify the most commonly used combination of tables and the performance of the queries that reference those sets of tables. First, let’s see the most commonly used combination of tables.  Today, … Continue reading

Posted in administration, analytics, Performance | 2 Comments

Reporting on newly created databases

I came up with a quick query that can be run daily to identify newly created databases.  The scenario behind this was that our sandbox environment has gotten out of control.  Many of the databases are completely empty or were … Continue reading

Posted in administration, General | Leave a comment