Tag: Database

IBM Express-C

I was introduced by another work colleague to IBM Express-C. The reason for this introduction is that I needed a free version of DB2 which could be installed on Windows and/or Linux for a test environment. i.e. I wanted to simulate an environment where I could install the Commvault Simpana DB2 iDA to see how it’s configured, in addition perform backups and restores.

So if your in a situation like myself, I can highly recommend it.

IBM Express-C can be downloaded from here. In addition you can obtain a copy of a free e-book for it called “Getting started with Express-C” from here. The later item probably only of use if you want to develop on the database platform. Forums also exist as linked here.

Commvault Simpana 9 DB2 iDA documentation is found here.

Output of the commands below against a DB2 client are handy for troubleshooting purposes (command in bold);

  • db2level – obtain db2 revision/version information
  • db2ilist
  • db2 get instance – list current instance
  • db2 list db directory – list all DB’s in current instance (as defined in OS environment variable DB2INSTANCE)
  • db2 get dbm cfg – list all database manager configuration file values
  • db2 get db cfg for <DB> – list all DB parameters for <DB> and shows values.

Recover MySQL root password

Last week I found myself in one of those situations where a machine I setup nearly 2 years ago required some additional MySQL databases created and for the life of me I couldn’t find where I had recorded the MySQL root password.

I figured setting a new one should be possible, however I’ve never had to do it. After about literally one search on Google and a few short clicks later I had found what I needed. I ended up at the following site here.

Process looked easy enough so I scheduled an outage window, since the MySQL server in question was being used for a Confluence Wiki.

Sure enough the process worked fine, I now had set a new MySQL root password and brought the services back online.

I of course immediately added the password into my password safe, so I don’t have to do it ever again.