Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Category Archives: Commands
Can we have columns larger than 60K characters in Netezza?
Netezza has a couple of limitations regarding column and row length, being a column maximum of 64K and a row maximum of 65535K, not to mention the column limit of 1600 in a table. How can we store longer text … Continue reading
Obtaining Netezza table size information.
On Netezza, with a large loading process, you cannot see the size of the table growing expect with the nzadmin tool. However, there’s a means to know it is running.
Netezza stats collection.
If you require to ensure all table statistics are up to date, you can run nz_genstats which will check and perform the collection as required. You can simple schedule this from the crontab.
Posted in Commands, Netezza
Tagged Analyze, Collecting, Netezza, nz_genstats, statistics
Comments Off
What is nzsqlrc ?
~/.nzsqlrc is the startup script read by netezza everytime you execute nzsql, unless you use the -X switch. This means you can place settings in there which you want implemented every time you log in to nzsql.
What’s quicker ? nzload, external tables or insert into select from ? And how about processing in parallel ?
Here we can test. We’ll create a table with 100,000,000 rows in and see how long it takes to use nzload or external tables to read the data back into another table.
Posted in Commands, Netezza, nzload
Tagged data loading, external tables, Netezza, nzload, skimmer
Comments Off
Netezza Authentication and Ldap.
Posted in Configuration, Netezza, nzsql
Tagged auth local, authentication, Ldap, Netezza, password, user
6 Comments
Grooming a Netezza Database.
The groom function can be used to reclaim space from deleted records on the Netezza system. However, the rows require to be backed up prior to grooming, else they will not be deleted.
Netezza, renaming columns.
Netezza allows the renaming of columns. This is relatively simple assuming no other user is accessing the table at the time.
Using Netezza’s sendMail for nzevents
The simplest method of sending alerts through nzevents is netezza’s sendmail utility. Here’s the setup.
Unloading from oracle to load into Netezza.
Found a very useful utility to unload information from oracle in flatfile format. This makes it simple to load into Netezza. I’ll complete this when I can.
