IT'S ALL ABOUT THE DATA.
 Follow us on Twitter! Add us on Facebook! Add our RSS feed!

5 Steps for Migrating Data to IBM DB2 with BLU Acceleration

Easily optimize data from an existing data warehouse for big data analytics

By

  • Gerald

    Hi,
    when will BLU be finally availabe for Windows? We are waiting already for months…

  • Nishant Bhardwaj

    Hi Mohan,
    Thanks again for another wonderful article. While there are many articles on BLU technology on internet, I really like this one because it is crisp and concise, in form of cookbook. Now I understand why IBM states BLU technology as super easy and super fast!

  • Naveen Somayaji K N

    Hi Mohankumar, I’m Naveen from IBM software labs. There has been a change in functionality post beta for DB2 10.5 BLU where when you set DB2_ANALYTICS=WORKLOAD, it will not automatically set INTRA_PARALLEL (DBM) as YES. We have to manually set it to YES instead. Can you please modify the blog to avoid discrepancy in the document? You can refer DB2 10.5 Info center on latest DB2_WORKLOAD settings: http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.admin.regvars.doc/doc/r0005658.html#r0005658__S_DB2_WORKLOAD

    • Mohan

      Thanks Naveen for letting me know, I will change this document to reflect the same.

  • Mohan

    Paul,

    The db2convert utility is to convert the table from ROW ORGANIZE to COLUMN ORGANIZE. The source database was ROW organized and now converting it to COLUMN organized to take the benefit of BLU acceleration for analytic workload.

  • Paul

    The numbered list order is 1, 1, 2, 3, 1 with no apparent reason for going back to 1 two times. Are these different processes or is the numbering just wrong and should be 1-5?

    It not clear why you would convert tables using the db2convert utility (3rd #1 in the list) when it seems that you have already created the row based tables (2nd #1 in the list) and loaded them (#2 in the list).

    • http://tdagroup.com Terry O’Donnell

      An HTML issue caused the numbering to be off. Should be fixed now. Thanks.