Wednesday, June 17, 2020

Getting started with Db2 on Cloud Lite

Success in creating a table
It seems to me that during the COVID-19 pandemic there are more hackathons than usual. Great to see that IBM Cloud is the platform of choice for many solutions. Db2 on Cloud is used as database, often the free Lite plan to get started. That's the reason I published a quick guide on the IBM Cloud blog on how to use Db2 on Cloud Lite plan for hackathons.

In that blog post I touch on topics like mandatory reactivation after 30 days, the multi-tenant architecture and the impact on creating objects and some storage and compliance aspects. The blog concludes with links to programming resources for your language of choice like Python, Node.js, GoLang, ADO.NET and several more.

I want to add that you could also look into the SQL Query service and its ability to move data between Cloud Object Storage and Db2 using SQL statements. Furthermore, I recently blogged about some advanced SQL to analyze COVID-19 data. The SQL expressions in that article work with Db2 and might give you some inspiration on how to utilize the database system.

Have fun with Db2! If you have feedback, suggestions, or questions about this post, please reach out to me on Twitter (@data_henrik) or LinkedIn.