Topic
  • 3 replies
  • Latest Post - ‏2012-06-11T08:37:51Z by SystemAdmin
SystemAdmin
SystemAdmin
301 Posts

Pinned topic Masking sensitive information in a DB2 XML column

‏2012-06-08T15:09:38Z |
Hello Optim users,

Does anyone had to mask information inside xml data type columns? Is there any supported way to do it, any hack or workaround?

Thanks!
Updated on 2012-06-11T08:37:51Z at 2012-06-11T08:37:51Z by SystemAdmin
  • Ducatiman
    Ducatiman
    58 Posts

    Re: Masking sensitive information in a DB2 XML column

    ‏2012-06-08T15:42:58Z  
    I ran into this a long time ago.

    I output the xml elements to a flat file and loaded temporarily into a staging table and finally pointed Optim to the temp table and masked the elements. I then put the elements back into the XML column.
    I did this for 2 million xml docs.
    It went faster than it sounds
    I leveraged Column Map Procedures.

    There may be an easier way these days.

    Good luck
  • SystemAdmin
    SystemAdmin
    301 Posts

    Re: Masking sensitive information in a DB2 XML column

    ‏2012-06-08T16:08:53Z  
    • Ducatiman
    • ‏2012-06-08T15:42:58Z
    I ran into this a long time ago.

    I output the xml elements to a flat file and loaded temporarily into a staging table and finally pointed Optim to the temp table and masked the elements. I then put the elements back into the XML column.
    I did this for 2 million xml docs.
    It went faster than it sounds
    I leveraged Column Map Procedures.

    There may be an easier way these days.

    Good luck
    Thanks Ducatiman!!!
  • SystemAdmin
    SystemAdmin
    301 Posts

    Re: Masking sensitive information in a DB2 XML column

    ‏2012-06-11T08:37:51Z  
    You might want to consider using a custom column map exit also though it will need writing 'C' code.