Encrypts SPD Server
tables on disk. Encryption is a security mechanism that protects
table contents from users who have system access to raw SPD Server
tables. Access to tables is normally controlled by SPD Server ACLs.
The S
AS Scalable Performance Data (SPD) Server 4.5: Administrator's
Guide contains detailed information about using SPD Server
ACLs to control access to tables.
When the ENCRYPT= option
setting is set to YES, SPD Server encrypts newly created tables by
blocks. To control the amount of encryption per block, use the table
option IOBLOCKSIZE=. The IOBLOCKSIZE= option specifies the number
of rows to be encrypted in each block.
encrypts the data set.
The encryption method uses passwords. At a minimum, you must specify
the READ= or the PW= data set option at the same time that you specify
an ENCRYPT=YES option setting.
no table encryption
is performed. NO is the default setting for the ENCRYPT= option.
-
Depending on your query
patterns, increasing or decreasing the block size can affect performance.
-
SPD Server does not
encrypt table indexes or metadata. Only table row data are encrypted.
-
To encrypt SPD tables
with Pass-Through SQL, use only the READ= or PW= table option. With
Pass-Through SQL, ENCRYPT=YES is implied with these options.
-
To access an encrypted
table, the user must have appropriate ACL permissions to the table
and must provide the encryption key via the READ= or PW= table option.
-
Encrypting an SPD Server
table provides security from users that have system access to dump
raw SPD Server tables. The section on Security in the
SAS
Scalable Performance Data (SPD) Server 4.5: Administrator's Guide contains more information about how to control system access to
SPD Server tables.