I forgot to blog about this earlier. I was a presenter on DB2Night Show on 4th December. This topic was “DB2 LUW Tips, Tricks, SQL & Scripts for Lazy DBAs”. I appreciate DBI Software’s founder Scott Hayes for giving me this opportunity to be a presenter on his show.
Replay of this show is available at: http://www.dbisoftware.com/blog/db2nightshow.php?id=651
A copy of the presentation (that could be downloaded) is available in PDF format. Hope this helps.
In this blog post, I will share about few gotchas to look out for when backing up tablespaces in a DB2 DPF database. What is DPF? I wrote a detailed blog post on db2commerce.com.
Why Tablespace backups?
Why should we look into backing up tablespaces instead of the entire database? Below are couple of instances when we want to backup tablespaces:
- You just created a new tablespace; Before taking an incremental/delta backup, the newly created tablespace needs to be backed-up.
- Tablespace is in BACKUP PENDING state. This can happen when we perform a load operation for a recoverable database and specify the COPY NO parameter. We can remove the tablespace from the BACKUP PENDING state by backing up the tablespace.
- Is it practical to do database backups? A database backup for a multi-terabyte database (think Data Warehouse) is not practical all the time. It consumes too many resources (CPU, storage, lock contention etc.). If the recovery effort is well thought out, we can get away with performing tablespace level backups.
The ability to extract the ‘command that was used to create a database’ comes handy during database migration time. The option in question is: -createdb in the command db2look. This is a blessing for that DBA (I am in that boat) who does not want to remember all the options in the ‘CREATE DATABASE .. ‘ command that were originally used to create the database.
Similarly, the option -printdbcfg in db2look generates ‘UPDATE DATABASE CFG…’ commands for the database configuration parameters. This gives the ability to not only apply those values to another database but to save parameters as part of a recovery plan. Both these enhancements were originally announced in Fix Pack 4 for DB2 10.1. Here is the link for IBM Knowledge Center that published these enhancements in db2look.
I am delighted to share that I will be one of the speakers at International DB2 Users Group (IDUG) in Philadelphia, PA. This is going to be my 2nd IDUG and I am eagerly looking forward to not only share an important and challenging topic but also to meet and learn from DB2 gurus like Scott Hayes, Ember Crooks, Mike Krafick and many more.
In this blog post, I will make a case for why you should specify a DISTRIBUTION KEY clause for a table that is about to be created on a single partition in a DPF database. This doesn’t make sense.. Does it? For me, this idea did not make any sense at all.. However, when I started exploring more on this topic, it made some sense and when I did more research, I realized that there is a big benefit in taking this approach. Hence the blog post 🙂 Please read on …
I am thrilled and pumped up to share that I will be guest blogging on IBM Gold Consultant and IBM Champion Ember Crooks’ DB2 blog http://www.db2commerce.com. I will continue to blog on a regular basis on db2talk.
My first guest blog post on db2commerce got published today. The title of this post is: “Choosing the right distribution keys in a DB2 DPF database”. I am hoping that you will take few minutes to read the blog post. Please leave your comments. Thank you.
This is going to be a quick blog post..
2014 has been the best year so far to me in terms of learning and personal and career growth wise.
I am excited and honored to let you know that I was part of “The DB2Night Show #144: Annual Eggnog Party with Who’s Who of DB2!”. This episode was today (Friday Dec 19th). It is a very humbling experience to be on a show along with the movers and shakers in DB2 community. This show had audience from around the world.
Thank you Scott Hayes and Martin Hubel for giving me the opportunity to be part of the DB2Night Show.
Replay is available at: http://www.dbisoftware.com/blog/db2nightshow.php?id=533
I had the privilege of being on the show along with the following special guests from all around the world.
Cristian Molaro, Ember Crooks, Guy Lohman, Iqbal Goralwalla, Jim Reed, Kelly Schlamb, Klaas Brant, Melanie Stopfer, Michael Krafick, Steve Rees, Surekha Parekh, Susan Visser, Martin Hubel and Scott Hayes.