The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
116 views

Netezza Error Record size 120000 exceeds internal limit of 65535 bytes

I have a column PARAM that has JSON data that looks like this: JSON:{"Name":"RES_InformationalIssues","StepName":"Page_1","StepData":"f601e9fe-d68a-4ed7-bbaa-f40c9cbc4d12=General Product ...
0
votes
1answer
35 views

What does this error mean in IBM Netezza Administrator? - ERROR: Permission denied on “_VT_DISK_PARTITION”

What does this error mean when opening IBM Netezza Administrator? ERROR: Permission denied on "_VT_DISK_PARTITION"
0
votes
1answer
187 views

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 ...
0
votes
1answer
209 views

Netezza LIKE operator not finding subsequent backslashes

Netezza is able to find records when using the LIKE operator when the first character contains a backslash character. But when subsequent characters contain a backslash character, it cannot. How can ...
0
votes
0answers
794 views

How list of netezza system tables/views?

Is ther a system table/view in Netezza wich permits to show the number of records for each table ? Thanks
0
votes
1answer
265 views

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 ...
1
vote
0answers
308 views

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 ...
1
vote
2answers
574 views

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 ...
1
vote
2answers
569 views

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, ...
6
votes
4answers
3k views

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 ...
1
vote
1answer
5k views

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 ...
0
votes
2answers
3k views

How can primary keys in a Netezza table be indexed?

What is the best way to index a Netezza fact table with lots of primary keys. For now, let's suppose we have 10 primary keys. This table is mainly used to store meta data about our database. ...
0
votes
1answer
415 views

Tools for synchronizing database schema with Oracle, SQL-Server and Netezza databases

I'm looking for software tools to move database schema for Oracle, SQL Server and Netezza. We use Oracle for our ODS, Netezza for our Data Warehouse (for it's bulk loading capabilities) and SQL ...