Error: Twitter did not respond. Please wait a few minutes and refresh this page.
Recently used tags
Tag Archives: netezza
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
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
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
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
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