Db2

Db2

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.  Data Masking in Db2 - How to prevent your data for un-authorized viewing Webinar

    Posted Tue October 15, 2024 12:02 PM
    Edited by Kat Jarvis 6 days ago

    If you missed the webinar, you can find the recording here

    Join us for an insightful discussion on 29 October, 2024 at 11:00 AM ET. This session will cover new scalar function, data_mask which can be use to protect sensitive data. It allows partial redaction, format preserving masking, strong cryptographic obfuscation, and integrity preserving tokenization. The function produces masked data that can be used by analytics tools to create insights without revealing sensitive data. And it can provide additional layer of security when used with DB2 RCAC.

    Click here to register and add the event to your calendar.

    Where is the link to join? Check your email the day before the event!

     How to get the most out of this webinar:

    • Explore the Db2 Community.

    • Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Marhababanu Chariwala will be happy to answer your questions and share insights.

    • Check out upcoming Db2 events here.

    We look forward to seeing you there!



    ------------------------------
    Kat Jarvis
    ------------------------------



  • 2.  RE: Data Masking in Db2 - How to prevent your data for un-authorized viewing Webinar

    Posted Fri November 15, 2024 10:26 AM

    Just a suggestion, but perhaps trim the first 7 minutes of silence from the webinar recording?

    Thanks :)



    ------------------------------
    Greg Palgrave
    ------------------------------



  • 3.  RE: Data Masking in Db2 - How to prevent your data for un-authorized viewing Webinar

    Posted Tue February 04, 2025 02:43 PM

     I watched  your webinar  about Data Masking  and I am wondering where I can get the PowerPoint slides you used during your webinar.

     I am trying to mask a column on a table using CREATE MASK SIN_MASK_PERSON ON SIS.PERSON FOR COLUMN SIN RETURN  and I am getting following error when I try to activate the access control:

     ALTER TABLE  SIS.PERSON ACTIVATE COLUMN ACCESS CONTROL

    DB21034E  The command was processed as an SQL statement because it was not a

    valid Command Line Processor command.  During SQL processing it returned:

    SQL20469N  Row or column access control activation for table "SIS.PERSON" has

    failed due to reason code "37".  SQLSTATE=55019

    Do you know the cause of this error ?

    Thanks



    ------------------------------
    Jean-Bernard Ngomiraronka
    ------------------------------



  • 4.  RE: Data Masking in Db2 - How to prevent your data for un-authorized viewing Webinar

    Posted Tue February 04, 2025 03:56 PM

    Hi Jean-Bernard!

    Art of reading IBM Error codes:


    In short:

    Table SIS.PERSON has defined trigger which is not defined secure.



    ------------------------------
    Jan Nelken
    +48 783 109 863
    ------------------------------