Simplify the DB2 9.7 security model

Starting in DB2 9.7, the DB2 security model was changed. Security administration (SECADM) was split off from database administration (DBADM), and users with SECADM permissions could no longer peek at data, at least not by default. Secure by default is a great practice. It’s fantastic when deploying a production database at a financial institution. However, … Continue reading Simplify the DB2 9.7 security model

Going from DB2 Enterprise to DB2 Express-C

Downgrading from DB2 Enterprise to DB2 Express-C is a fairly straightforward process. Stop DB2. db2stop force Uninstall DB2 Enterprise. sudo su - db2inst1 /opt/ibm/db2/V9.7/install/db2_deinstall -a exit Install DB2 Express-C without creating any users, etc. sudo ./db2_install Update the instance with the new edition information. sudo /opt/ibm/db2/V9.7/instance/db2iupdt db2inst1 You might encounter this error. db2inst1@vhost0074:~> db2start SQL5043N … Continue reading Going from DB2 Enterprise to DB2 Express-C

Going from DB2 Enterprise to Express-C

Downgrading from DB2 Enterprise to DB2 Express-C is a fairly straightforward process. Stop DB2. db2stop force Uninstall DB2 Enterprise. sudo su - db2inst1 /opt/ibm/db2/V9.7/install/db2_deinstall -a exit Install DB2 Express-C without creating any users, etc. sudo ./db2_install Update the instance with the new edition information. sudo /opt/ibm/db2/V9.7/instance/db2iupdt db2inst1 You might encounter this error. db2inst1@vhost0074:~> db2start SQL5043N … Continue reading Going from DB2 Enterprise to Express-C