Details about Netezza

Netezza

Netezza Query History details using nz_query_history Table

Sometimes you may need to verify the queries that are running for a long time on production servers. There are several ways that you can perform this task. For instance, you can use Netezza administrative tool to verify long running queries. In this post, we will check how to get Netezza query history details using nz_query_history table. Netezza query history configuration steps are simple. You can follow below steps to use Netezza query history views to collect Netezza queries historical data in separate history table in optional history database. Why…

Continue ReadingNetezza Query History details using nz_query_history Table
Comments Off on Netezza Query History details using nz_query_history Table
January 24, 2019
Netezza

Steps to Generate and Load TPC-DS Data into Netezza Server

The TPC-DS benchmark model decision support system of a retail product supplier. This includes various queries and data maintenance. Database schema, data population, queries, data maintenance model and implementation rules have been designed to be broadly representative of new or modern decision support systems. In this post, we will discuss steps to generate and load TPC-DS data into Netezza or puredata systems server. What is TPC-DS? The Transaction Processing Performance Council (TPC) is a benchmark model decision support system. Several major firms are member of TPC. You can get more…

Continue ReadingSteps to Generate and Load TPC-DS Data into Netezza Server
Comments Off on Steps to Generate and Load TPC-DS Data into Netezza Server
December 28, 2018
Netezza

Different Methods to Display Netezza Table Statistics

IBM Netezza or Puredata Systems uses the cost based optimizer to determine best methods determine redistribution, scan, join, join orders. Optimizer uses statistics to generate optimal execution plan. You need collect statistics on tables or databases regularly. In my other post, Netezza Generate Statistics: A Guide and Best Practices, we have discussed some of best practices to generate statistics on Netezza tables. In this post, we will discuss different methods to display Netezza table statistics with some examples. What Are Table Statistics? Tables statistics are nothing but information about each column…

Continue ReadingDifferent Methods to Display Netezza Table Statistics
Comments Off on Different Methods to Display Netezza Table Statistics
December 20, 2018
Netezza

How to Connect Netezza using JDBC Driver and working Examples

Netezza is one of the widely used MPP database. You connect to it by using various methods and programming languages. Netezza supports ODBC, OLEDB and JDBC drivers for connections. Connection to Netezza using JDBC driver is easy and one of the widely used method. In this article, we will check how to connect Netezza using JDBC driver and some working examples. Netezza JDBC Driver Netezza provides JDBC driver, you can use that driver from any programming language that supports JDBC connections such as Java, Python etc. You can download JDBC…

Continue ReadingHow to Connect Netezza using JDBC Driver and working Examples
Comments Off on How to Connect Netezza using JDBC Driver and working Examples
December 2, 2018
Netezza

Netezza Stored Procedure ARRAY Variables and Examples

The ARRAY data type is a composite data value that consists of zero or more elements of a specified specific data type. Netezza nzplsql allows you to define ARRAY types along with other scalar variables. In this article, we will check Netezza stored procedure ARRAY variables, declaration and examples. Netezza Stored Procedure ARRAY Variables You can define and use VARRAY in Netezza stored procedures. You can insert values to array variables, increase array size in case if length is exceeded and remove elements from array. ARRAY variables are allowed anywhere…

Continue ReadingNetezza Stored Procedure ARRAY Variables and Examples
Comments Off on Netezza Stored Procedure ARRAY Variables and Examples
June 6, 2018
Netezza

Netezza Data Transformation Functions and Examples

You must secure the data in case if you are working on various sensitive and confidential data. Netezza does provides various transformation functions that you can use to change the data representation. In this article, we will check Netezza data transformation functions and some examples. Netezza Data Transformation Functions The data transformation functions in Netezza are used to change data into different representation for purpose of security (encryption and decryption), space saving (compression) and save time to transmit data across various medium. IBM used industry standard algorithms to build these…

Continue ReadingNetezza Data Transformation Functions and Examples
Comments Off on Netezza Data Transformation Functions and Examples
May 19, 2018
Netezza

Netezza Phonetic Matching Functions and Examples

Netezza nzsql language support phonetic matching functions, that is, you can encode names into phonetic representations. These functions are useful to match names that are based on their pronunciation and reduce misses that might result from spelling variations. In this article, we will check types of Netezza phonetic matching functions and usage with some examples. Netezza Phonetic Matching Functions There are two types of Phonetic matching functions supported in Netezza:  SoundEx NYSIIS algorithm  Double Metaphone (dbl_mp) algorithm There are three helper functions in Double Metaphone:  Primary Metaohine (pri_mp)  Secondary Metaphone…

Continue ReadingNetezza Phonetic Matching Functions and Examples
Comments Off on Netezza Phonetic Matching Functions and Examples
May 16, 2018
Netezza

Netezza nz_migrate Script Usage and Examples

If you have upgraded you Netezza server to higher capacity box then want to migrate data from one netezza server to other, you can use the IBM provided Netezza nz_migrate utility. You can either mention the tables to be migrated or you can migrate all tables available in source database. Netezza nz_migrate script is one of the best Netezza utility that provides lot of option to use while migrating data from one server to other. nz_migrate optionally creates destination database if it is not already present.  All the tables mentioned in the…

Continue ReadingNetezza nz_migrate Script Usage and Examples
2 Comments
April 25, 2018
Netezza

Connecting Netezza using Python pyodbc – Working Example

In this modern era, data plays very important role in every decision making. Most of applications that is written in various programming languages require access to relational databases to get required data for its process. Before you can run SQL statements to create, update, delete, or retrieve data, you must connect to a database. In this article, we will check process and working example on connecting Netezza using Python pyodbc driver. Netezza also supports JDBC driver: How to Connect Netezza using JDBC Driver and working Examples Netezza ODBC drivers Before attempting…

Continue ReadingConnecting Netezza using Python pyodbc – Working Example
Comments Off on Connecting Netezza using Python pyodbc – Working Example
March 28, 2018
Netezza

Export Netezza Table Data to Linux Local File System

In my other post ‘Netezza Export Table Data to CSV format’, we have seen how to export table to CSV format on a Netezza host machine. In this article, we will check how to export Netezza table data to Linux local file system. We will discuss below topics in this post How to install and configure Netezza ODBC drivers in remote machie Export Netezza table data to Linux local file system using External Tables How to export Netezza table using nzsql command line interface Install Netezza ODBC Drivers In other…

Continue ReadingExport Netezza Table Data to Linux Local File System
Comments Off on Export Netezza Table Data to Linux Local File System
March 6, 2018