Questions tagged [netezza]

A data warehouse and analytic appliance suite that IBM purchased around 2010. Utilizes SQL language to query data. It is a contender in the "big data" market and used comparable to Teradata or Hadoop. Pronounced Ne-Tease-Ah.

IBM purchased Netezza around 2010 and it the technology now powers their PureData System appliance products. It is a suite of products in the "big data" market, similar to Teradata or Microsoft's Hadoop.

It is unique itself that it utilizes a 2 tier architecture instead of a node based like Teradata and Hadoop commonly use. The scale-ability is obtained by Netezza's Asymmetric Massively Parallel Architecture (AMPP).

Quote from documentation:

SQL-92 (also called SQL/2), is the operative ANSI/ISO standard for relational databases today. While no vendor supports the complete SQL-92 standard, Netezza SQL conforms to all the commonly supported components of SQL-92. In addition, Netezza includes some SQL:1999 extensions and some SQL:2003 extensions. This publication describes the Netezza SQL language support.

If you have direct access to the Netezza appliance from a command shell, or if you have UNIX clients with the Netezza CLI tools, you can run SQL commands by using the nzsql command-line interpreter. You can also run Netezza SQL commands by using common SQL tools and applications that support ODBC, JDBC, and OLE DB data connectivity APIs.

You can find more information from IBM's product site: Data Warehouse Applicances Analytics

34 questions
9
votes
4 answers

What can speed up a SQL count query?

When doing a count (aggregate) SQL query, what can speed up the execution time in these 3 database systems? I'm sure many things could speed it up (hardware for one), but I'm just a novice DBA, so I'm sure I'll be getting a few answers here. I…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
6
votes
4 answers

Netezza: What schema contains all the system tables / views?

Is there a schema I can look in or a query that I can run to see all the Netezza system or metadata tables? I know about _v_table, _v_view, _v_relation_column, and _v_groupusers. I know there are many others and I would like the definitive…
CraigBoyd
  • 61
  • 1
  • 1
  • 2
2
votes
2 answers

How to obtain row counts for all tables in Netezza?

Is there a system table or view in Netezza that shows the number of records for each table?
user2462699
  • 121
  • 1
  • 1
  • 2
2
votes
1 answer

Installing Netezza 6.0.8 ODBC driver on Windows Server 2008

Below are four Netezza drivers that are available for Netezza 6.0.8. I installed the second one on Windows Server 2008, and it placed it into the system32 folder (64 bit folder). However, when I set up the System tab ODBC drivers, and used the…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
2
votes
0 answers

In nzsql, how can I determine the path of the current sql file being executed?

How can I run a script with nzsql that calls other scripts using \i with paths specified relative to the path of the calling script? The solution must work whether nzsql is being run interactively or non-interactively. For example suppose run.sql,…
2
votes
0 answers

What would be the rule for parsing parameterized sql for Netezza to be used with nzsql?

I have a bunch of legacy parametrized SQL templates that were used by nzsql utility for Netezza. See examples here: http://queforum.com/netezza/347918-parameterized-sql-file-input-nzsql.html What is the algorithm that nzsql command line utility is…
Leonid
  • 121
  • 3
2
votes
2 answers

How to increase ETL performance in Informatica for Netezza as a source and SQL Server as a target?

What settings or configuration on the Informatica server, in the Informatica software itself, or on the database servers can be changed to increase Informatica ETL throughput? What are some benchmarks we can set to troubleshoot performance? We are…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
1
vote
1 answer

How to generate a random character string of length 8 in Netezza?

I am trying to generate a random character string of length 8 in Netezza, any suggestions?
sumanth
  • 11
  • 2
1
vote
1 answer

how can I call nzsql or nzload from script without disclosing sensitive password?

I don't see this in the Netezza documentation. We have lots of Linux scripts where we do this: NZ_PASSWD_ENCRYPTED=29TY20T98= NZ_PASSWD_CLEAR=`DecryptFunc $NZ_PASSWD_ENCRYPTED` NzResult=$(nzsql -db ${NZ_DATABASE} -u ${NZ_USER} -pw $NZ_PASSWD_CLEAR…
Andrew Wolfe
  • 584
  • 5
  • 16
1
vote
1 answer

Netezza Equivalent to T-SQL ROWVERSION or PL/SQL ORA_ROWSCN

Is there a Netezza equivalent to the MSSQL ROWVERSION or the Oracle ORA_ROWSCN? Essentially I'd like to know if a record changed and be confident that it changed. Using a checksum isn't reliable 100% of the time.
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
1
vote
2 answers

How do I migrate varbinary data to Netezza?

I got a warning message while migrating DDL from SQL Server to Netezza: Warning: [dbo].[spec_binarymessage].[blobdata] data type [varbinary] is not supported the target system and will be scripted as VARCHAR(16000). I'm wondering whether this kind…
Jane
  • 11
  • 2
1
vote
2 answers

Obvious inefficiencies in this Netezza query?

Why might this query be taking nearly 2 hours to run when similar queries complete within a minute? CREATE TABLE T3 AS SELECT A.*, COALESCE(C.FIELD1,0) AS FIELD1A, COALESCE(B.FIELD2,0) AS FIELD2A, …
jl6
  • 815
  • 7
  • 15
1
vote
1 answer

Netezza migration to Azure Synapse - Stored Procedures?

I have looked everywhere for useful documentation that comprehensively gives me the differences between Netezza stored procedures and functions so I can find Azure Synapse equivalents. Is there any site or link that documents this sort of thing…
1
vote
1 answer

Table schema column data type equivalents for Netezza 6 to SQL Server 2008

I'm trying to find a data type equivalents for data types in Netezza when migrating table schema to SQL Server. Where can I find a complete list? When getting down to brass tacks, I am specifically looking for Netezza 6 & SQL Server 2008. Here is…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
1
vote
0 answers

Netezza Sequence error

I am new to Netezza and have a quick question. I do a simple select of next val from sequence SELECT NEXT VALUE FOR XX.XX.RUN_SEQ FROM _V_DUAL I ERROR [HY000] ERROR: Sequence 46339885 not properly initialized I get the above error, can some one…
1
2 3