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