Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Performance Informix encryption

    Posted 03/09/22 10:24 AM
    I wanted to ask you guys about your experience with performance degradation of enabled DB encryption in Informix.
    We have tables with 100 columns and 30 million records, does the activated inplace encryption of the Informix DB still play a big role or is it hardly measurable in terms of performance whether it is encrypted or not?

    Suggest we´re using 14.10FC7 with RHEL7 on some multicore CPU VMs

    ------------------------------
    Marc Demhartner
    ------------------------------

    #Informix


  • 2.  RE: Performance Informix encryption

    Posted 03/09/22 10:26 AM

    If you mean EAR then you won't notice it

     






  • 3.  RE: Performance Informix encryption

    Posted 03/09/22 10:43 AM
    Thanks for prompt reply - and the different option? in transit - so if only a few specific tables would be encrypted / decrypted during runtime ?

    ------------------------------
    Marc Demhartner
    ------------------------------

    Original Message


  • 4.  RE: Performance Informix encryption

    Posted 03/09/22 11:16 AM
    Marc:

    Encryption at Rest (EAR) is at the server level. All storage for the instance is encrypted on disk and in flight between the disk and the server instance. Data is only decrypted when it is accessed inside the server. It would be all data in all tables. Then, separately, you can encrypt the data in flight to clients using SSL and PAM connection types making the encryption end-to-end.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 5.  RE: Performance Informix encryption

    Posted 03/09/22 10:38 AM
    Marc:

    I agree with Paul. If you are thinking of use Informix Encryption at Rest there is no noticeable impact. CPU usage will be a little bit higher, but if you are not bumping up against 0% idle now it's no biggie.

    If, on the other hand, you are talking about column level encryption, that's a different animal. There will be an impact.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 6.  RE: Performance Informix encryption

    Posted 03/09/22 10:42 AM

    The 110% unofficial line I got from IBM was do not use column level encryption cos <quote>its crap</quote>

     




    Original Message


Related Content