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
General

How Column Oriented Database Stores Data? – Details

Column-oriented databases save their data grouped by columns. Subsequent column values are stored contiguously on disk. Columnar storage for database tables is one of an important factor in optimizing analytic query performance in the database.In this article, we will check how column oriented database stores data. Also we will check the difference between row oriented database and columnar database - columnar database vs document database What is Column Oriented Database? The column-oriented databases save their data grouped by columns. This differs from the usual row-oriented approach of traditional databases, which…

Continue ReadingHow Column Oriented Database Stores Data? – Details
Comments Off on How Column Oriented Database Stores Data? – Details
February 15, 2018
Netezza

Load HDFS file into Netezza Table Using nzload and External Tables

nzload command is bulk copy command available in Netezza data warehouse appliance. This Netezza native command provides an easy method for using external tables and getting data into the Netezza appliance. There is no straight forward option to load hdfs file into Netezza tables using nzload command. You must use some work around to get hdfs file into Netezza tables. In this article, we will check out methods to load HDFS file into Netezza Table Using nzload and external tables with some examples. Install Netezza Drivers Before attempting to load…

Continue ReadingLoad HDFS file into Netezza Table Using nzload and External Tables
Comments Off on Load HDFS file into Netezza Table Using nzload and External Tables
January 16, 2018
Netezza

Netezza Stored Procedure Return Resultset and working Example

You can use the stored procedure to return the resultset in your applications. Typically, stored procedure returns a unique value, it can also return resultset in the form of tables. In this article, we will see Netezza Stored Procedure Return Resultset with an example. Netezza Stored Procedure Return Resultset Below are the steps you can follow to return resultset using stored procedure: Create table that you will be using as a REFTABLE. The table specified in the RETURNS value must exist at the time that the stored procedure is created,…

Continue ReadingNetezza Stored Procedure Return Resultset and working Example
Comments Off on Netezza Stored Procedure Return Resultset and working Example
December 12, 2017
Netezza

How to Identify Netezza Server I/O Usage using System Views?

You may have to query Netezza system tables or views to get information about system, for example, to identify Netezza server I/O Usage. These kind of information will help you to manage Netezza server and databases. As a server maintenance activity, you may have to regularly to identify Netezza Server I/O and monitor regularly to minimize the performance degrade. Identify Netezza Server I/O Usage using System Views Below query provides the Netezza I/O usage i.e. identify read and write details on Netezza disks. select cast(START_TIME as date) as startDate, cast(END_TIME…

Continue ReadingHow to Identify Netezza Server I/O Usage using System Views?
Comments Off on How to Identify Netezza Server I/O Usage using System Views?
November 24, 2017
Netezza

How to List Netezza Database High Volume Tables?

You may have to query Netezza system tables or views to get information about system, for example, list Netezza database high volume tables. These kind of information will help you to manage Netezza server and databases. As a server maintenance activity, you may have to regularly verify the Netezza database table size and identify the growing tables in server to minimize the performance degrade. How to List Netezza Database High Volume Tables? Below query provides the information of big or high volume tables of database available in the Netezza data…

Continue ReadingHow to List Netezza Database High Volume Tables?
Comments Off on How to List Netezza Database High Volume Tables?
November 24, 2017
Netezza

How to Get Netezza databases Allocated, Used, Available Space?

You may have to query Netezza system tables to get information about system, for example, get Netezza databases allocated, used, available space. These kind of information will help you to manage Netezza server and databases. As a server maintenance activity, you may have to regularly verify the Netezza database size to minimize the performance degrade. Get Netezza databases Allocated, Used, Available Space Below query provides the information of size of each database available in the Netezza server. This query is useful for the Netezza administrator who frequently verify the databases…

Continue ReadingHow to Get Netezza databases Allocated, Used, Available Space?
Comments Off on How to Get Netezza databases Allocated, Used, Available Space?
November 24, 2017
Netezza

Netezza Count All Database Objects – System Table Query

You may have to query few system tables to get information about system, for example, get list of all tables, views, system tables, synonyms, sequences, etc available in Netezza data warehouse appliance. Getting object details information will help you to identify and manage Netezza system better. You can identify the tables or view which are needs to be deleted or removed from Netezza server. Below are few queries that are consolidated to provide useful information: Netezza Count All Database Objects – Tables, Views, Synonyms, System Tables, Databases Below query provide…

Continue ReadingNetezza Count All Database Objects – System Table Query
Comments Off on Netezza Count All Database Objects – System Table Query
November 24, 2017
Netezza

Easy Methods to Integrate Netezza and Amazon S3 – Steps

Amazon AWS is gaining popularity as cloud based web services. It will just take few clicks to make your system or storage up and running. Amazon web services (AWS) provides on-demand cloud computing platforms and storage services (S3). Amazon S3 is fast, reliable cloud storage that is the reason most of organizations are using it to store its data. In this article, we will check easy methods to Integrate Netezza and Amazon S3 storage for data transfer between them. You may have to connect to Amazon S3 to pull data…

Continue ReadingEasy Methods to Integrate Netezza and Amazon S3 – Steps
Comments Off on Easy Methods to Integrate Netezza and Amazon S3 – Steps
November 15, 2017