Leo on Tech

Powered by
WordPress

  • Blog dehacked

    I apologize if you saw any strange malware warnings last Friday. Someone exploited a hole in my rather old installation of WordPress and added a nasty Javascript scriptlet to every post. They also published every one of my drafts and also truncated every post title to a single word. Google Webmaster Tools alerted me to…

  • 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,…

  • Cataloging databases after reinstalling DB2

    On Windows, uninstalling DB2 will remove the instance but keep the databases in place. After you reinstall, you’ll want to recatalog these databases. This is fairly straightforward. Find out their names: db2 list db directory on C: Map each of the databases that you want: db2 catalog db SAMPLE on C: You can also catalog…

  • 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…

  • Enable NFS services for HADR

    You might need to enable network file system (NFS) services when configuring the High Availability Disaster Recovery (HADR) or Database Partioning (DPF) DB2 features. For example, with HADR, you might want to set up a slave database that shares a backup with the master database through NFS. These commands should enable NFS services on most…

  • Simplify DB2 Express-C security

    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,…

  • Cataloging local DB2 databases

    On Windows, uninstalling DB2 will remove the instance but keep the databases in place. After you reinstall, you’ll want to recatalog these databases. This is fairly straightforward. Find out their names: db2 list db directory on C: Map each of the databases that you want: db2 catalog db SAMPLE on C: You can also catalog…

  • 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…

  • Get your hands off me, you damn dirty bloggers

    “I don’t want to see us descend into a nation of bloggers.” – Steve Jobs Steve Jobs went on to scream “You maniacs! You blogged it up! Ah, damn you! God damn you all to the blogosphere!”

  • Enable NFS for DB2 DPF or HADR

    You might need to enable network file system (NFS) services when configuring the High Availability Disaster Recovery (HADR) or Database Partioning (DPF) DB2 features. For example, with HADR, you might want to set up a slave database that shares a backup with the master database through NFS. These commands should enable NFS services on most…