Tags » Netezza

Netezza: 'abstime' datatype conversion

Error generated:

/* ERROR ERROR:  Type ‘abstime’ not supported by IBM Netezza SQL or has invalid size */

CREATE TABLE NZ_V_TABLE_ONLY_STORAGE_STAT AS SELECT CREATEDATE  FROM _V_TABLE_xdb; 97 more words

Netezza: get database names into a Bash shell variable

Set a variable DATABASES to loop through later in a for loop:

DATABASES=`nz_get_database_names`

then loop like this

for DATABASE in $DATABASES; do 
    export NZ_DATABASE=\"$DATABASE\"
    # Get the INITIAL list of table names (or schemaname.tablenames)
    if [ "$MultiSchema" = "" ]; then 
           export period_delimiter=$DELIMITER ; 
           unset NZ_SCHEMA ; 
    fi
    TABLES=`nz_get_table_names`
    unset period_delimiter
... 41 more words

Netezza: change number of plan history files

Change default 2000 number of plan history files to 10,000.

Put line the following line into

/nz/data/config/system.cfg
host.planHistFiles=10000

Refer to IBM documentation:  Plan file archives and host resources

Netezza Code Generation Failure

ERROR:  256 : Code generation failure

In my experience this error means “I can’t figure out how to execute your query” or “The plan I created to execute your query failed.” 551 more words

Netezza

Netezza: Groom a Table Without a Backup

In case you ever need to, it is possible to groom a table without taking a backup first. 70 more words

SQL

ERROR: “Each input of Joiner Joiner_XXX must originate from different Source Qualifier, Joiner or VSAM Normalizer “ when validating a mapping in PowerCenter

Reason for this error:-

This issue occurs when you join data that comes from a single source, without selecting the option Sorted Input.

Solution:- 14 more words

Netezza

Netezza/PureData – Which to Run First--Statistics or Groom?

Now, I know, this seems like a simple question, but for folks new to netezza, this question has come up more than a few times.  Also, this choice ultimately impacts how performant Netezza will be  once you complete you maintenance operations. 15 more words

IBM