By "heavy" QA tests I meant complex functional SQL testing...
It's only single user connection (we do not have workload tests)
About the amount of data that is processed, I can't tell for now:
Our tests create tables on the fly, populate and then drop the test tables when test is done.
Is there any Netezza diagnostic command to see how much disk / storage resource was used recently?
A kind of history of data load?
Or maybe just a "du <path>" command to the storage location?
Assuming that once Netezza has allocated disk space, it's kept for future use, by reusing data blocks that were used by dropped tables.
I found the --dropdata option of nzbackup, but I assume that it gives the size for current data in the database:
[nz@netezza ~]$ nzbackup -db test1 -dir /tmp -dropdata -v
[Backup Server] : Starting the backup process
[Backup Server] : Backing up to base directory '/tmp'
[Backup Server] : Backing up libraries
[Backup Server] : Backing up functions
[Backup Server] : Backing up aggregates
[Backup Server] : Start retrieving the schema
[Backup Server] : Backing up metadata to /tmp/Netezza/netezza/TEST1/20210112074032/1/FULL/md
[Backup Server] : Retrieving host key information
[Backup Server] : Retrieving user information
[Backup Server] : Backing up schemas.
[Backup Server] : Backing up sequences
[Backup Server] : Backing up table schema.
[Backup Server] : Backing up External Tables.
[Backup Server] : Backing up External table settings.
[Backup Server] : Backing up External table zone settings.
[Backup Server] : Backing up Table Constraints
[Backup Server] : Backing up synonyms
[Backup Server] : Backing up stored procedures
[Backup Server] : Backing up materialized views
[Backup Server] : Backing up view definitions.
[Backup Server] : Backing up scheduler rule definitions.
[Backup Server] : Retrieving group information
[Backup Server] : Retrieving group members
[Backup Server] : Backing up ACL information
[Backup Server] : severity=3 source=3 errCode=0 otherErrCode=0 : Number of bytes dropped (-dropData) : 22016
[Backup Server] : severity=3 source=3 errCode=0 otherErrCode=0 : Number of bytes dropped (-dropData) : 22016
[Backup Server] : Start retrieving the data.
[Backup Server] : Backing up table ADMIN.DBIT1
[Backup Server] : Backing up table ADMIN.DBIT2
[Backup Server] : Backing up table ADMIN.DBIT3
[Backup Server] : Backing up table ADMIN.SERIALREG
[Backup Server] : Backing up table ADMIN.T144
[Backup Server] : Backing up table ADMIN.T168
[Backup Server] : Backing up table ADMIN.T185
[Backup Server] : Backing up table ADMIN.T240
[Backup Server] : severity=3 source=3 errCode=0 otherErrCode=0 : Number of bytes dropped (-dropData) : 22279
[Backup Server] : Operation committed
Backup of database test1 to backupset 20210112074032 completed successfully.
------------------------------
Sebastien FLAESCH
------------------------------
Original Message:
Sent: Tue January 12, 2021 01:22 AM
From: Pawan Powar
Subject: Support Netezza Performance Server with FOURJS Genero
Can you elaborate heavy QA tests? How data you populate? What is nature of workload? For PDA, what size of system you used for running same workload?
> run our heavy QA tests every night and guarantee that our product and NPS 11.2 work together correctly. Seems that if the resources of the developer edition are limited, there are good chances that some of our tests don't even pass.
------------------------------
Pawan Powar
Original Message:
Sent: Mon January 11, 2021 11:26 AM
From: Sebastien FLAESCH
Subject: Support Netezza Performance Server with FOURJS Genero
Thank you Adam for your suggestions, very appreciate.
But we need a clear statement from IBM.
This is not just to play a bit with NPS to see if some SQL executing: We want to setup a reliable testing environment, so we can run our heavy QA tests every night and guarantee that our product and NPS 11.2 work together correctly. Seems that if the resources of the developer edition are limited, there are good chances that some of our tests don't even pass.
We have such test setup for all database engines we support, namely: ORACLE DB, MS SQL SERVER, MS AZURE Database, IBM/HCL INFORMIX, IBM DB2 LUW, IBM NETEZZA 7, POSTGRESQL, ORACLE MYSQL, MARIADB, SAP HANA Database.
We will wait for IBM to provide a proper, stable and minimum scalable on-premise solution for developers.
Until then, no NPS 11 support with Genero BDL, period.
------------------------------
Sebastien FLAESCH
Original Message:
Sent: Mon January 11, 2021 09:35 AM
From: Adam Matusewicz
Subject: Support Netezza Performance Server with FOURJS Genero
Hi Sebastian
Not as IBM support :) - but fellow engineer...
So this OVA is for virtual box only :/ For me also was a bit of problem... have installed this stuff on desktop and make it working . Ignore all manual there. Don't configure networking and stuff...
Next thing - is to get to disk image on this box -> convert it to VMDK to VM Ware workstation
Copy this thing (coverted vmdk) to ESXi (have tried on 6.7 and 7.0u3) and theer vovert once more.
Then setup empty VM, withoiut disk , assign RAM you want and CPU (although machine is so limited that what was in Virtual BOX is sufficient).
Then you need to choose SATA controller and not default SAS/SCSI.
Many many articles there are how to convert Virtual Box to ESXi (try to google through ESXi rather then vSphere). ESXi for home use is free - so just convert some workstation to it (I used HP z800).
But as in other post of mine (you already mentioned): this machine is very limited. Besides checking if SQL is working not much anything else you can do.
To be honest for those pusposes old style emulator (v7.2) was far much better. And if you don't need to test new features - would advise to go for it from the beginning.
Additional thing: on premise is pure VM - no docker or anything like this. So hard to say what you can test there in terms of CP4D.
also is limited to 16G of DB size (close to nothing). 10x more would be acceptable for testing (and that people would not use it as production).
------------------------------
Adam Matusewicz
Original Message:
Sent: Mon January 11, 2021 08:18 AM
From: Sebastien FLAESCH
Subject: Support Netezza Performance Server with FOURJS Genero
Hello,
For the platform appliance we'll require an OVA running on VMware vsphere 7
Is it possible ?
------------------------------
Sebastien FLAESCH
Original Message:
Sent: Fri January 08, 2021 07:53 AM
From: Pawan Powar
Subject: Support Netezza Performance Server with FOURJS Genero
Please use below link -
https://www-01.ibm.com/marketing/iwm/platform/mrs/assets?source=swg-im-ibmndn
------------------------------
Pawan Powar
Original Message:
Sent: Fri January 08, 2021 07:07 AM
From: Nicolas Rafael Ascanio Pena
Subject: Support Netezza Performance Server with FOURJS Genero
Hello Guys,
The link not working.
Saludos,Regards
___________________________________
Nicolás Rafael Ascanio Peña
IBM Professions and COGNITIVE CLASS (30) badges
Information Management Software Lab Services
IBM Software Group
Cell phone: +58 4241406472
Tie-Line: 777-8685
e-mail: nascanioo@ve.ibm.com
Original Message:
Sent: 1/8/2021 5:34:00 AM
From: Sebastien FLAESCH
Subject: RE: Support Netezza Performance Server with FOURJS Genero
This link brings me nowhere.
I get an empty page with title "MRS"...
Seb
------------------------------
Sebastien FLAESCH
Original Message:
Sent: Fri January 08, 2021 04:57 AM
From: Pawan Powar
Subject: Support Netezza Performance Server with FOURJS Genero
Here is link for Netezza Developer Edition 11.2.0.0
https://mrs-ux.mrs-prod-7d4bdc08e7ddc90fa89b373d95c240eb-0000.us-south.containers.appdomain.cloud/marketing/iwm/platform/mrs/assets/packageList?source=swg-im-ibmndn&lang=en_US
Choose "Netezza Performance Server Developer Edition V11.2.0.0". And on downloading page you will find "NPSOnVirtualBoxInstallationInstructions.pdf" (which has instructions) along with artifact.
------------------------------
Pawan Powar
Original Message:
Sent: Fri January 08, 2021 04:19 AM
From: Sebastien FLAESCH
Subject: Support Netezza Performance Server with FOURJS Genero
Pawan,
Any news on this?
Where will we find the instructions to install a NPS developer edition on a VM?
In a blog post?
Seb
------------------------------
Sebastien FLAESCH
Original Message:
Sent: Mon January 04, 2021 12:33 AM
From: Pawan Powar
Subject: Support Netezza Performance Server with FOURJS Genero
> Where can we find information to install NPS 11.2 on premise?
https://www.ibm.com/support/knowledgecenter/SS5FPD_1.0.0/com.ibm.ips.doc/postgresql/admin/upgrd.html
>
I have seen another post here about NPS v11 Emulator from Adam M.
Where is the link corresponding to the picture with download items?
Do we need an "Emulator" ?
we will publish detailed information about that this week. Artifact will have all the instructions about setting up environment.
------------------------------
Pawan Powar
Original Message:
Sent: Sat January 02, 2021 10:17 AM
From: Sebastien FLAESCH
Subject: Support Netezza Performance Server with FOURJS Genero
Hello,
I have seen the blog announce:
https://community.ibm.com/community/user/hybriddatamanagement/blogs/pawan-powar1/2020/12/20/netezza-11200-is-generally-available
Where can we find information to install NPS 11.2 on premise?
What is the "container" file? (nps-container-v11.2.0.0-unpack)
Can this be used on premise with the client packages for developers?
I have seen another post here about NPS v11 Emulator from Adam M.
Where is the link corresponding to the picture with download items?
Do we need an "Emulator" ?
We want to install an NPS server from scratch, no upgrade.
------------------------------
Sebastien FLAESCH
Original Message:
Sent: Sat October 24, 2020 06:10 AM
From: Rajshekar (Shekar) Iyer
Subject: Support Netezza Performance Server with FOURJS Genero
Unless your application looks for specific version, the drivers from PDA will work with NPS.
You can download latest 11.x drivers from IBM fix central. Those drivers are forward compatible with future NPS versions and backwards compatible with PDA.
A developer edition is being worked on. We will post a blog here once its generally available. Hopefully later this year or early next year.
------------------------------
Rajshekar (Shekar) Iyer
Original Message:
Sent: Sat October 24, 2020 05:10 AM
From: Sebastien FLAESCH
Subject: Support Netezza Performance Server with FOURJS Genero
Hello,
Today our product FOURJS Genero (Informix 4GL compatible compiler/runtime) can be used to implement applications that can connect to IBM PureData System for Analytics 7.2 ...
We would like to support Netezza Performance Server as well in our future major version.
Our product provides a DB client module based on the ODBC client for PDA / Netezza.
1) What ODBC client software can we use to connect to NPS? Is it the same ODBC client as for PDA?
2) For development and QA testing purpose, we would like to setup an "on premise" NPS installed on our dev/QA platform.
Where can we download both ODBC client and NPS server on premise packages?
Is there a "developer edition" with limited capabilities (we will not be in production)
We just want to develop and do functional testing as we do for PDA today.
Best regards,
Seb
------------------------------
Sebastien FLAESCH
------------------------------
#NetezzaPerformanceServer