Netezza

Netezza Failover – High Availability Architecture

Netezza appliance include necessary components to function seamlessly in the event of any hardware issue so that its availability is more that 99.99%. This is called Netezza high availability architecture that perform seamlessly in case of Netezza failover. There are two host in a cluster in all Netezza appliances so that if one fails other once can take over the task that is being carried out. Netezza Failover - High Availability Architecture Overview Netezza appliance uses the Linux-HA (high availability) and Distributed Replicated Block Device (DRBD) for the host cluster…

Continue ReadingNetezza Failover – High Availability Architecture
Comments Off on Netezza Failover – High Availability Architecture
October 31, 2016
Netezza

Netezza Backup and Restore: Best Practices

In this post you will learn about Netezza backup and restore data. It provides general information on backup and restore methods available with Netezza system. Netezza Backup and Restore Overview Netezza provides several backup and restore methods as per the different requirements. You can take table or database backup whenever required: You can create full and incremental backups of your various Netezza databases in compressed internal using the nzbackup command and restore them to a Netezza system whenever required using nzrestore command. As a best practice create script that perform…

Continue ReadingNetezza Backup and Restore: Best Practices
Comments Off on Netezza Backup and Restore: Best Practices
October 25, 2016
Netezza

Netezza Pad Zero with Working Example

Netezza pad zero functions are string functions used to remove or add the string to beginning or end of the expression. An expression could be column values. There are two pad functions available in Netezza; LPAD and RPAD string functions. You can use those function in Netezza pad zero or any other character provided in arguments: Read: Netezza String Functions and Usage Different types of Netezza Trim Functions and Examples Netezza Date Functions and Examples nzsql Command and its Usage Netezza LPAD function You can use this function to pad string…

Continue ReadingNetezza Pad Zero with Working Example
Comments Off on Netezza Pad Zero with Working Example
October 24, 2016
Netezza

Netezza Export Table Data to CSV format

You can export the Netezza table in many ways. Netezza export table is done using either Netezza external table or Netezza nzsql commands. Use of Netezza external table is fastest way to export Netezza table data compared to a Netezza nzsql command. Netezza nzsql with option -o is easy method compared to creating Netezza external tables. Netezza Export Table using Netezza External Tables You can use the Netezza transient external table to export the data table to flat file (CSV format). This feature is very handy if you are exporting…

Continue ReadingNetezza Export Table Data to CSV format
4 Comments
October 21, 2016
Netezza

Netezza MERGE command to Manipulate Records from Table

Use the Netezza MERGE command to insert, update, or delete rows in a target table using data from a source such as a table, view, or sub-query and based on rules specified for a matching condition in the merge statements. In the Netezza merge command, you must specify at least one matching_condition statement to identify the rows that you want to update, insert or delete. This feature is not supported in all versions of Netezza. IBM has introduced this feature in Netezza 7.2.1 or higher. MEGRE command is used to…

Continue ReadingNetezza MERGE command to Manipulate Records from Table
Comments Off on Netezza MERGE command to Manipulate Records from Table
October 20, 2016
Netezza

Netezza Temporary Tables and Examples

Like any other database, Netezza also supports temp or temporary tables. There are three types of Netezza temporary tables; all of them have advantage over traditional temporary tables. Netezza Temporary Tables Netezza temporary tables are local to the user session. You can use temporary table repeatedly within a user session for multiple times. Like derived tables, temporary tables also use Netezza swap partition space. You can drop and recreate the temporary table within the user session. However, these temporary tables are not visible outside the user session. You do not…

Continue ReadingNetezza Temporary Tables and Examples
Comments Off on Netezza Temporary Tables and Examples
October 19, 2016
Netezza

Netezza Query Tool Introduction, Features and Screenshot

Netezza supports JDBC, ODBC and OLEDB connectors. There are many free and paid Netezza query tool available in market. There most popular Netezza query tool includes Aginity workbench, WinSQL, SQuirrel SQL Client tool etc. Aginity Workbench Aginity Workbench is free, most popular and an easy-to-use application that enhances your performance when you are working with your Netezza data warehouse. If anybody think of Netezza query tool then first thing comes to their mind is Aginity workbench. This SQL database development tool offers unique capabilities that allow you to focus on…

Continue ReadingNetezza Query Tool Introduction, Features and Screenshot
Comments Off on Netezza Query Tool Introduction, Features and Screenshot
October 18, 2016
Netezza

Netezza ROWNUM Pseudo Column Alternative

If you are coming from Oracle database background, you will find it difficult in Netezza without ROWNUM pseudo column. The one possible solution to this is ROW_NUMBER() analytical function as Netezza ROWNUM pseudo column alternative. You can use ROW_NUMBER analytic function as a Netezza ROWNUM equivalent. I think most of the distributed databases does not provide the ROWNUM columns. There is a LIMIT clause to restrict the output but very difficult to assign the sequential numbers to the rows in the Netezza tables. Even Netezza Sequences also does not produce…

Continue ReadingNetezza ROWNUM Pseudo Column Alternative
Comments Off on Netezza ROWNUM Pseudo Column Alternative
October 16, 2016
Netezza

How Netezza Update Records in Tables?

Netezza update records operation is costlier. IBM Netezza does not perform updates, but rather does deletes the records and inserts updated values. When you run nzsql command to update record, Netezza marks the record being updated as logically deleted by setting current transaction value to the deletexid field, but does not delete it. This ensures that the database system adheres to the ACID properties of RDBMS SQL standards. How Netezza Update Records in Tables? Each record in Netezza contains two slots, one for createxid another for deletexid. Deletexid allows you…

Continue ReadingHow Netezza Update Records in Tables?
Comments Off on How Netezza Update Records in Tables?
October 5, 2016
Netezza

Netezza Encrypt Password with nzpassword Command Utility

Database user accounts must be authenticated during access requests to the IBM Netezza database. You can secure the password by using Netezza encrypt password facility. Local authentication requires a password for every account which connects to the Netezza server. You must enter the clear text password, when you use Netezza CLI commands. You can set the environment variable NZ_PASSWORD to avoid the type of password every time but this variable also stores the clear text password. Read: Commonly used Netezza Utility Netezza Best Practices to Improve Performance Netezza nzsql Commands and…

Continue ReadingNetezza Encrypt Password with nzpassword Command Utility
Comments Off on Netezza Encrypt Password with nzpassword Command Utility
October 4, 2016