Dataset Passwords

The ability to provide security via dataset passwords was a little-used feature of DB2. Using the DSETPASS keyword of the CREATE TABLESPACE and CREATE INDEX statement, it was possible to password protect DB2 datasets.

This feature disappeared with DB2 V6. If you need to protect your DB2 datasets outside of DB2 security, you can use RACF, ACF2, Top Secret, or whatever security package you have installed at your site to accomplish this.

To find datasets that are password protected using DSETPASS , issue the following SQL statement:

 SELECT   'INDEX ', CREATOR, NAME FROM     SYSIBM.SYSINDEXES WHERE    DSETPASS <> '        ' UNION ALL SELECT   'TSPACE', DBNAME, NAME FROM     SYSIBM.SYSTABLESPACE WHERE    DSETPASS <> '        '