Maintaining encryption consistency accross databases

[p***@virgin.net]

Has anyone ever needed to use DB2 encryption and generate the same results accross multiple databases? I do and I'm not getting it! The results are close but there is a subtle difference in the encryption output (seems to be always in characters 10&11 of the internal string, byte positions 12&13 of the total string), does anyone know what causes this? I'm wondering if there is something embedded in the algorithm that is picking something up from the environment and using this in the encryption process?

The databases reside on the same physical AIX box and are created form the same code base, some share the same instance some don't, data to be encrypted is the same, datatypes are the same, passwords used are the same etc.

[Blair Kenneth Adamache]

Post by p***@virgin.net
Has anyone ever needed to use DB2 encryption and generate the same results accross multiple databases? I do and I'm not getting it! The results are close but there is a subtle difference in the encryption output (seems to be always in characters 10&11 of the internal string, byte positions 12&13 of the total string), does anyone know what causes this? I'm wondering if there is something embedded in the algorithm that is picking something up from the environment and using this in the encryption process?
The databases reside on the same physical AIX box and are created form the same code base, some share the same instance some don't, data to be encrypted is the same, datatypes are the same, passwords used are the same etc.

Can you create all of these objects within one database, and use the
concept of a schema to make it look like separate databases to your users?