List of Contributions

Adam Matusewicz

Contact Details

My Content

1 to 20 of 42 total
Posted By Adam Matusewicz Wed March 13, 2024 10:09 AM
Found In Egroup: Netezza Performance Server
\ view thread
It is postgresql.conf setting: https://www.ibm.com/docs/en/psfa/7.2.1?topic=extents-enabling-random-chunk-distributions The default value of the system.enableRandomDistributionChunkSize registry variable is no (off). But again: this is for 7.X (old Netezza). I believe that this setting is ON by ...
Posted By Adam Matusewicz Tue March 12, 2024 12:00 PM
Found In Egroup: Netezza Performance Server
\ view thread
Hi Andrea If system will reach 100% on single dataslice: it will stop (as Huw wrote in other post). Check output of nz_skew and redistribute table(s) with large skew to random or choose better distrubution keys. As for 3MB: when table have distribution it is by default allocated 3MB extent on every ...
Posted By Adam Matusewicz Tue March 12, 2024 08:08 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi As far I'm aware there was no limit to Database/Data size in Netezza systems: except physical storage capacity. Since NPS / (CP4D) share vast majority of the code with Netezza: I presume it's the same. That is why is so important to keep your data "clean": - groom tables (with proper backup/groom ...
Posted By Adam Matusewicz Fri December 15, 2023 09:16 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi Andrea What version of NPS is this system that's reporting the corruption running please (NPS 7.X or 11.X)? Have you experienced any blade/DAC failures recently? Or unexpected power outages, or database crashes? Because it's important to establish the root cause of the corruption in order to prevent ...
Posted By Adam Matusewicz Fri December 15, 2023 05:14 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi Based on OS version (CentOS) seems like you are running emulator, which doesn't have any physical SPU/blade etc. ------------------------------ Adam Matusewicz ------------------------------
Posted By Adam Matusewicz Wed October 04, 2023 09:30 AM
Found In Egroup: Netezza Performance Server
\ view thread
Try emulator: https://www-01.ibm.com/marketing/iwm/platform/mrs/assets?source=swg-im-ibmndn ------------------------------ Adam Matusewicz ------------------------------
Posted By Adam Matusewicz Wed October 04, 2023 07:48 AM
Found In Egroup: Netezza Performance Server
\ view thread
Here is a link to the client kits that does not require a license. https://www.ibm.com/support/fixcentral/swg/selectFixes?product=ibm%2FWebSphere%2FIBM+Cloud+Private+for+Data+System&release=NPS_11.2&platform=All&function=fixId&fixids=11.2.1.0-WS-ICPDS-NPS-fp7614 This is under IBM Cloud Pak ...
Posted By Adam Matusewicz Wed July 12, 2023 08:51 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi In our application to migrate data to, from and between Netezzas (and other systems) we want to use external tables. Problem seems to be with NULL values and NULLVALUE option . This option doesn't seem to work via ODBC nor NZSQL. Tried both on 7.X and 11.X. ODBC on 7.X # isql NZSQL ...
Posted By Adam Matusewicz Thu May 25, 2023 07:04 AM
Found In Egroup: Netezza Performance Server
\ view thread
Ok - so you might have HA1 malfunctioning.... First of all: make sure hosts rescue wheels are available (IMMs) If you don't have access to IMM: ask somebody in DC to configure it for you. https://www.ibm.com/docs/pt-br/i/7.1?topic=ssw_ibm_i_71/rzahq/configimm.html Skip DNS, NTP, LDAP etc... IP, netmask ...
Posted By Adam Matusewicz Fri May 12, 2023 07:38 PM
Found In Egroup: Netezza Performance Server
\ view thread
Howdy Correct link is: https://www.ibm.com/docs/en/psfa/7.2.1?topic=procedures-powering-off-puredata-system-analytics-n200x-system Before you decomission Netezza appliance make sure data has been securely erased. If it hasn't been done already - contact us @ https://smart-associates.biz/company/contact.php ...
Posted By Adam Matusewicz Tue May 02, 2023 04:09 AM
Found In Egroup: Netezza Performance Server
\ view thread
Yes. You can use multipath on Netezza linux hosts (Redhat 5/6 based) - ust when you set it up be aware about configuring it properly: https://www.ibm.com/support/pages/enabling-multipath-model-3561-n3000-001 Br, Adam ------------------------------ Adam Matusewicz ------------ ...
Posted By Adam Matusewicz Fri April 28, 2023 02:31 AM
Found In Egroup: Netezza Performance Server
\ view thread
Just one more thing for multipath: https://www.ibm.com/support/pages/enabling-multipath-model-3561-n3000-001 Basically: block internal RAID controller from being "multipathed" ------------------------------ Adam Matusewicz ------------------------------
Posted By Adam Matusewicz Fri April 28, 2023 02:29 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi Under the hoods Netezza (PureData for Analuytics) is just RedHat. For SAN connections you can simply: 1. Connect Netezza hosts (remember to do on both of them) to brocade/SAN switch 2. Present LUNs to Netezza hosts 3. Scan LUNs 4. Create PV->VG->LV-> format FS ...
Posted By Adam Matusewicz Tue July 26, 2022 02:22 AM
Found In Egroup: Netezza Performance Server
\ view thread
Howdy In general Netezza doesn't like single row inserts/updates it was designed to work on queries for millions/bilions of rows. Many times those single row insert will take as much as inserting 1000 rows... If you are running it in separate sessions it will take even longer. Those ...
Posted By Adam Matusewicz Wed March 09, 2022 02:03 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi Some might find this blog / manual interesting: https://smart-associates.biz/blog/converting-cp4d-to-vmware-vsphere-nps-v11-2-1-4 ------------------------------ Adam Matusewicz ------------------------------ #NetezzaPerformanceServer
Posted By Adam Matusewicz Wed March 09, 2022 02:01 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi John (and all) Have made manual on how to convert VirtualBox emulator into ESXi and upgrade it with newest NPS kit https://smart-associates.biz/blog/converting-cp4d-to-vmware-vsphere-nps-v11-2-1-4 Will check if same is possible for 11.2.2.X Br, Adam ------------------------------ ...
Posted By Adam Matusewicz Thu February 24, 2022 08:19 AM
Found In Egroup: Netezza Performance Server
\ view thread
Hi John Thank you for quick reply. I was able to convert 11.2.1.0 VM into ESXi and then with use of NPS packages upgrade to 11.2.1.4 . Are there any plans to release emulator with NPS 11.2.2.0 (which seems to be CP4D 2.X, while the others are ment for 1.X)? Or if you can provide entry ...
Posted By Adam Matusewicz Tue February 22, 2022 09:05 AM
Found In Egroup: Netezza Performance Server
\ view thread
How to enable MinIO connector in CP4D 2.X? Wanted to follow up on: AWS S3, MinIO, and IBM Cloud Object Storage connectors In description can see: Starting from version 11.2.2.0, MinIO Object Storage is supported. [nz@localhost sbin]$ nzrev Release 11.2.1.4 [Build 37] [nz@localhost ...
Posted By Adam Matusewicz Fri January 14, 2022 04:35 AM
Found In Egroup: Netezza Performance Server
\ view thread
Howdy Jeff Basically it's like comparing apples and oranges.. (your words ;) ) . Hard to compare stuff from HW perspective and entire topology, configuration etc is changed... Mako: baremetal OS, CP4D/Cloud: container Mako: dedicated fabric links, CP4D: shared fabric (with external net), ...
Posted By Adam Matusewicz Mon January 10, 2022 03:35 PM
Found In Egroup: Netezza Performance Server
\ view thread
Hi Sebastien I have made 11.2.X emulator running on vSphere (same as earliers ones). Basically: 1. convert disk image from virtual box to vmware 2. Create empty VM (no disk): 4 CPUs, 8G of RAM 3. Upload converted image to ESXi 4. With CPU settings set option "Expose hardware assisted ...