Sybase encryption option and memory consumption

----------------------------------------------------------------------------

---- This is andkylee's personal originality. Please repost it with respect to the author's Labor achievements;

---- The original source must be specified for reprinting.
:
Http://blog.csdn.net/andkylee

---- Keyword: ASE 15.0.3 encrypted memory encryption memory

----------------------------------------------------------------------------

 

Configure encryption on the Sybase server today to test the new data encryption features.

Sp_configure "enable encrypted columns", 1

Go

Then, the error log shows:

========================================================== ====================================

00: 00000: 00026: 2010/01/18 11:09:51. 56 kernel sysam: checked out license for 1 ase_encryption (2009.1231/permanent/19b3 47bc 0b7e 8dc3 ).
00: 00000: 00026: 2010/01/18 11:09:51. 56 kernel checked out license ase_encryption
00: 00000: 00026: 2010/01/18 11:09:51. 67 kernel sysam: failed to obtain 2 license (s) for ase_encryption feature from license file (s) or server (s ).
00: 00000: 00026: 2010/01/18 11:09:51. 67 kernel sysam: ASE requires 2 'per-CPU 'licenses for use on this machine but only 1 cocould be obtained. check whether additional licenses are available at the Sybase product download center; or check whether the licensing terms allow you to partition the machine so that ASE can only use 1 CPU (s ).
00: 00000: 00026: 2010/01/18 11:09:51. 67 kernel sysam: License feature name: ase_encryption
00: 00000: 00026: 2010/01/18 11:09:51. 67 kernel sysam: License search path: D:/SYBASE // SYSAM-2_0/licenses/sybase_ase_de.lic
00: 00000: 00026: 2010/01/18 11:09:51. 67 kernel sysam: FlexNET licensing error:-73,125
00: 00000: 00026: 2010/01/18 11:09:51. 67 kernel sysam: For further information, refer to the Sybase Software Asset Management website at http://www.sybase.com/sysam
00: 00000: 00026: 2010/01/18 11:09:51. 73 server configuration file 'd:/Sybase/test. CFG 'has been written and the previous version has been renamed to 'd:/Sybase/test1_57 '.
00: 00000: 00026: 2010/01/18 11:09:51. 73 server the configuration option 'enabledledcolumns 'has been changed by 'sa' from '0' to '1 '.

========================================================== ====================================

 

After restarting the Sybase server, it cannot be started.

Errorlog is as follows:

0: 00000: 00000: 2010/01/18 15:11:26. 37 kernel sysam: Using licenses from: D:/SYBASE // SYSAM-2_0/licenses
00: 00000: 00000: 2010/01/18 15:11:27. 31 kernel sysam: checked out license for 1 ase_core (2009.1231/permanent/19b3 47bc 0b7e 8dc3 ).
00: 00000: 00000: 2010/01/18 15:11:27. 31 kernel this product is licensed to: ASE Developer Edition-for development and test use only
00: 00000: 00000: 2010/01/18 15:11:27. 31 kernel checked out license ase_core
00: 00000: 00000: 2010/01/18 15:11:27. 31 kernel Adaptive Server Enterprise (Developer Edition)
00: 00000: 00000: 2010/01/18 15:11:27. 48 kernel using config area from primary master device.
00: 00000: 00000: 2010/01/18 15:11:27. 53 kernel warning: Using default file 'd:/Sybase/test. CFG 'since a configuration file was not specified. specify a configuration file name in the runserver file to avoid this message.
00: 00000: 00000: 2010/01/18 15:11:27. 53 server illegal value '1' specified for configuration option 'max online engines '. The legal values are between '2' and '2 '.
00: 00000: 00000: 2010/01/18 15:11:27. 53 server the value specified for configuration option 'max online engines ''1' cannot be less than the sum of the configuration options 'number of engines at startup' and 'max online Q engines'. the current sum is '2 '.
00: 00000: 00000: 2010/01/18 15:11:27. 53 server 'max online engines 'has been modified from '1' to '2' by the Verification routine.
00: 00000: 00000: 2010/01/18 15:11:27. 56 kernel sysam: checked out license for 1 ase_partitions (2009.1231/permanent/19b3 47bc 0b7e 8dc3 ).
00: 00000: 00000: 2010/01/18 15:11:27. 56 kernel checked out license ase_partitions
00: 00000: 00000: 2010/01/18 15:11:27. 59 kernel sysam: checked out license for 1 ase_encryption (2009.1231/permanent/19b3 47bc 0b7e 8dc3 ).
00: 00000: 00000: 2010/01/18 15:11:27. 59 kernel checked out license ase_encryption
00: 00000: 00000: 2010/01/18 15:11:27. 59 server the value of the 'max memory 'parameter (39936) defined in the configuration file is not high enough to set the other parameter values specified in the configuration file. 'max memory 'should be greater than the 'total Logical Memory' '123 '.

========================================================== ====================================

 

The number of engines at startup and Max online engines parameters are temporarily ignored. Because I am a dual-core CPU.

 

For memory configuration, I have not adjusted Max memory. In the. cfg file, both are default. At startup, the system reports that the memory usage is 39936 insufficient. The memory size must be 68bytes. It indicates that the encryption option in Sybase consumes a certain amount of memory, and the encryption option does not know the impact on performance. Think about writing data to the disk every time the data is encrypted in the memory. This adds a burden to the processor. The impact on performance is coming soon.