Encrypting data Was: Securing tape backup drive

[rob@xxxxxxxxx]

You mean like:
> CREATE TABLE ROB/VICKER 
   (MYKEY INT AS IDENTITY, 
    MYSSN CHAR(32) for bit data not null
  PRIMARY KEY (MYKEY)) 
  Table VICKER created in ROB. 
// Notice the size on MYSSN? 
// Length of data + 16 bytes for encryption + 5 bytes to next 8 byte 
boundary.
> set encryption password = 'Ben123' 
> INSERT INTO ROB/VICKER (MYSSN) 
  VALUES(ENCRYPT_TDES('289-46-8832')) 
  1 rows inserted in VICKER in ROB. 
> select * from rob/vicker 
  SELECT statement run complete. 
....+....1....+....2....+....3....+....4....+...
        MYKEY   MYSSN 
            1      Ÿ  Nµ¾/Ø&?Ú| ðygÝ=üäŸ S í L¤I
********  End of data  ******** 
> select mykey, decrypt_char(myssn) as DisplaySSN
  from rob/vicker 
....+....1....+....2....+....3
        MYKEY   DISPLAYSSN 
            1   289-46-8832 
********  End of data  *******


http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstscale.htm#scaencrypt
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstscale.htm#scaencrypttdes
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstscale.htm#scadecrypt

Rob Berendt