Using Netezza SQL, you can create, drop, rename and change the database owners. These are some important commands you should know if you are working as a Netezza database administrator. In this article, we will check Netezza create, drop, rename database commands and some of examples. Read: Netezza SQL Identifiers Netezza Create Database Command You can use CREATE DATABASE command to create new database in Netezza system: system(admin)=> CREATE DATABASE newdb; CREATE DATABASE Database names can be up to a maximum length of 128 bytes, system displays an error message if…

If you are working on the Netezza with the heavy load on it then you might have seen the Netezza too many concurrent sessions issue when you try to connect to the Netezza system. You may get this issue while connecting to Netezza from Aginity workbench or from Putty. In this article, we will see how to resolve Netezza too many concurrent session issue. Check Netezza too many Concurrent Sessions issue To verify the concurrent sessions follow below steps: Login to Netezza either from Putty or from Aginity Workbench and…

There are two ways to identify the size of table in Netezza. One, query the Netezza system tables and get the table size. Second, use the Netezza admin tool to check table size. In this article, we will discuss on how to find Netezza table size using Netezza nzsql and Netezza admin tools. More Readings: Netezza system tables and views Netezza nzsql command and its usage How to install Aginity workbench for Netezza? How to Find Netezza Table Size? When you create a table in Netezza using nzsql, the table…

In the real world scenario, you may derive the some column from base table and instead of creating temporary table you may use that derived query in FROM clause of the SQL statement. These types of queries are called derived tables. In this article,we will check on the Netezza derived tables.  Netezza Derived Tables A derived table is basically a subquery which is always in the FROM clause of a SQL query Statements. The reason it is called a derived table is because it essentially functions as a table as far as the entire query…

Sometimes if you try to delete or truncate data from the table that is being used by the other process then session may lock the table resulting deadlock. You have to identify and kill such sessions before attempting to delete or truncate that table.In this article, we will discuss about Netezza identify and kill tables locks with an examples. Read: Netezza Table Locking and Concurrency Netezza Identify and Kill Table Locks The mail question is how to identify the locks? There are couple of options available to identify the table…