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: Netezza architecture
Download Netezza (not really!!)
** Netezza Simulator is available on IBM site and may require special privileges to login. I did not try that out, any comments are appreciated ** Lots of us tried to download Netezza and try out for free. No software of that sort exists as it is entirely based on hardware. Closest one [...]
Continue reading
Netezza Query Monitoring
Netezza query monitoring Netezza twinfin uses a little different architecture compared to old Mustang. Each node maps to eight disks with 1 TB on each disk on TwinFin 12 system. That is, if we have a TwinFin 12, total capacity is 12 x 8 = 96TB. Here are steps that I used for monitoring purpose; [...]
Continue reading
Netezza Explain Plan
Each query that is submitted to Netezza results in a corresponding query plan. These plans are kept under /nz/data/plans and the archived ones are located under /nz/kit/log/planshist on the Netezza host. Archived files are kept up to a certain number and are purged; something like 5000 files. To save them on a permanent basis, [...]
Continue reading
Netezza data types and functions
Here is a list of data types along with associated info. Note that this is generated by “SQuirrel” tool using Netezza JDBC. These data types are likely applicable to both 5.x and 6.x. TYPE_NAME DATA_TYPE PRECISION NULLABLE CASE_SENSITIVE MAXIMUM_SCALE NVARCHAR -9 [NVARCHAR] 16000 true true 0 NCHAR -8 [ROWID] 16000 true true 0 BOOLEAN -7 [BIT] 1 [...]
Continue reading
Posted in Architecture, Netezza, Netezza architecture, Netezza data types
Tagged Netezza
Comments Off
