Get started Bring yourself up to speed with our introductory content.

Problems using local encryption for CRM database

I'm starting to test using local encryption for our CRM database. Many of our sales representatives have local copies. Updates can be done locally or on the server, and the changes replicated push/pull. When I test this though, any document I create or change on my encrypted local copy replicates to the server. But, the documents are not visible on the server version. I've checked that the 'do not send changes in local security property to other replicas' is checked on my encrypted database. The level of encryption is simple -- the server TCPIP port is set to encrypt and compress network data.
I think everything is working as it should, you just need to learn a bit more about what these options mean. There are three separate features you touched on:
  1. Whole database encryption, which prevents someone from reading a local database if they gain access to your laptop.

  2. The option "do not send changes in local security." This refers to the local encryption settings, not to the encrypted data itself.

  3. Port encryption, which relates to encryption of the bits over the LAN, rather than encryption of the data on-disk. This should have no effect on the other behavior you are observing.

Here are a couple things to look for. Are you also using field-level encryption with secret keys? This could explain documents sometimes being visible and sometimes not. Check the document properties of the docs on the server. Are the fields present, but encrypted, or not there at all? Can another user see the documents that you replicate up?

Do you have comments on this Ask the Expert question and response? Let us know.

Dig Deeper on Lotus Notes Domino Email Encryption

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...