+ New Ticket

Is anyone looking at the new Netezza offering from IBM?

Comments

11 comments

  • Avatar
    George L'Heureux

    Hi Chris,

    Thanks for your question. Yes, we're aware of IBM Cloud Pak for Data SPS. Our initial review suggests that our products should work for IBM Cloud Pak for Data wherever they work for Netezza; however, we haven't yet had an opportunity to fully test on IBM Cloud Pak for Data.

    Thanks!

    George

    0
    Comment actions Permalink
  • Avatar
    Daniel

    It is my understanding that IBM Cloud Pak for Data System (IBM Performance Server) is fully compliant with Netezza since it still use the same DB-engine underneath, also based on PostgreSQL like Netezza.

    It was also my understanding that even drivers (jdbc/odbc) should be fully compliant with Netezza. So a migration with nzmigrate or similar should make this far less cumbersome than e.g. Sailfish+DB2 or other alternatives would have been.

    0
    Comment actions Permalink
  • Avatar
    Rodgers, Chris

    Yes, Daniel, those understandings are correct. IBM suggests using the most current 7.2* version of driver. It is Netezza behind the scenes.

    I was wondering if anyone is testing on it yet.  Soon I should be comparing timing between Striper and the new Cloud Pak for Data Performance Server (new Netezza).  The architecture is very different between the two.

    0
    Comment actions Permalink
  • Avatar
    Mark Lambier

    We are looking at the IBM Cloud Pak with Performance Server option. Although we have yet to have anything to test with. We have twinfin (EOS), Striper (soon to be EOS) and Mako Netezza Appliances. Nothing significant happening with IBM and our Tech leads as of yet for us to see and feel to test, etc. 

    0
    Comment actions Permalink
  • Avatar
    Rodgers, Chris

    Mark - The database interface (nzsql, etc) is all the same, so same statements like create table as ... ... distribute on...  Aginity Pro functions the same as on a striper, etc (I have striper, migrating to ICP4D PS).  The *physical* architecture is significantly different and administration from that point of view is a bit different.  Message me if you want an overview of what is different from what I have seen in a POC.  We have a base + 4 we are migrating production to.

    0
    Comment actions Permalink
  • Avatar
    Mark Lambier

    Thanks Chris for the information. I would be interested in an overview. We still use the free version of Aginity workbench for Netezza and I was just inquiring about Aginity Licensing and support before we consider budget implications for our users for Aginity Pro. Also the physical architecture will be dramatically different for us in the future. Currently all our appliances are in one data centre. Going forward if and when we do get this new IBM Cloud Pak plus Performance Server it will be physically located in a data centre half way across the country in a different city. Currently I have complete control for admin work on the software and hardware but that will totally change someday soon. When I do not know. So yes, administration of this environment and platform will radically change for me.

    0
    Comment actions Permalink
  • Avatar
    Rodgers, Chris

    Several years ago we ran our own data center.  I have been administering across the wire to another town for years... servers locked in a cage that only a few people get in to see when they are doing physical changes... thinking about it, it really is not different than when I used to administer in the office... the servers were in another room that I never needed to go into except when upgrading.  The big difference between NZ Striper series and ICP4D is the architecture of the hardware components.  

    I though Aginity Workbench was gone?  Well, maybe no more updates and you can still live on the last version you installed?  Aginity Pro was free for a while, not only for less than 5 seats in a company.  Handy pricing if you are an independent contractor.  We used WinSQL Pro several years ago at one employer I was at.  It has quite a few features, but not the code sharing functionality that the Aginity team has put into Aginity Teams.

    0
    Comment actions Permalink
  • Avatar
    Rodgers, Chris

    I do not see a way to connect to folks in this community.  Look for me on Linkedin

    0
    Comment actions Permalink
  • Avatar
    Mark Lambier

    will do. I am on LinkedIn and like you did not see a way to connect through this community

    0
    Comment actions Permalink
  • Avatar
    Mark Lambier

    oh my.. lots of Chris Rogers on LinkedIn.. Did not find anyone matching profile pic on here. As for me, I pretty easy to find.. 

    0
    Comment actions Permalink
  • Avatar
    Rodgers, Chris

    Spelling... i'll find you.

    0
    Comment actions Permalink

Please sign in to leave a comment.