Category: IBM

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); If you are reading my blog regularly, you are aware of the entries on cloud security. Today, I want to point you to some newer reading material at the Cloud Security Alliance. They now have up-to-date self-assessment security questionnaires for the IBM Cloud. The three available security documents cover IBM Cloud Infrastructure (IaaS), IBM Cloud Platform (PaaS), and the IBM Watson Services with ... Read More

Feed: Hadoop Dev. Author: Juanjo Marron. The Inspect Files tool presented in this blog allows users to improve the query performance in IBM Db2 Big SQL tables by optimizing the file layout and size. Query performance can suffer when file layout is fragmented into multiple small files. The Inspect Files tool will detect when this condition exists and recommends corrective action. Introduction A good practice to resolve the small files issue is to run compaction on the directories containing many small files that logically belong together. The merge of these files improves the Big SQL read performance, by minimizing the metadata to be ... Read More

Feed: Hadoop Dev. Author: Bharath_D. Summary Big SQL High Availability (HA) refers to providing high availability for the meta data of the Big SQL database (the Big SQL Metastore ) and for the Big SQL Scheduler component. The Big SQL database is used by Big SQL applications to access Hadoop tables. Introduction In this article we will look at steps to recover BigSQL HA in scenarios where resource group is showing up in offline state and HA is not being established. For example, when lssam command is run, db2_bigsql_bigsql_BIGSQL-rg resource group shows up as offline, lssam Online IBM.ResourceGroup:BigSQLScheduler_bigsql-rg Nominal=Online '- ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); It's already two months since the last Db2 User Group meeting, time to point you to the next one. The German Db2 user group, DeDUG (Deutsche Db2 User Group) is going to meet next month, April 20th, in Munich. Henrik Loeser has all the details. DeDUG: Db2 User Group If you clicked the previous link, you should have gotten back to this blog entry. At the meeting, I am going to present on SQL ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Slackbot Architecture Last week, I introduced you to a new tutorial for a database-driven Slackbot. Today, I am going to discuss details of how the IBM Watson Conversation service is accessing a Db2 Warehouse service from within a dialog. It uses a serverless setup with IBM Cloud Functions. All the necessary credentials to execute the code and to access the Db2 database are automatically bound ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Ever wanted to build a Slackbot, a chatbot integrated into Slack, on your own? I am going to show you how easy it is to integrate Slack or Facebook Messenger with the IBM Watson Conversation service. As a bonus, the bot is going to access a Db2 database to store and retrieve data. The solution is based on IBM Cloud Functions and entirely serverless Slackbot Architecture . Overview Today ... Read More

Feed: Hadoop Dev. Author: Nagapriya Tiruthani. The details on product lifecycle for support are listed below: IBM Db2 Big SQL Releases: Product Release Date End of Full Support End of Technical Guidance IBM Big SQL v5.0 7/13/17 7/13/19 7/13/20 IBM Db2 Big SQL with Hortonworks Data Platform Releases: Product Release Date End of Full Support End of Technical Guidance IBM Big SQL with Hortonworks Data Platform 10/31/17 10/31/19 10/31/20 IBM Db2 Big SQL with Hortonworks DataFlow Releases: Product Release Date End of Full Support End of Technical Guidance IBM Big SQL with Hortonworks DataFlow 12/4/17 12/4/19 12/4/20 Hortonworks Data Platform ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Serverless Slackbot with Db2 A tutorial I wrote, featuring a database-backed Slack chatbot, is now live. It uses Db2 as database system to store event data. The client accessing the database is written in Node.js and is implement with IBM Cloud Functions in a serverless way. During the development of that tutorial I faced the question on how to perform the database setup. Should I guide users ... Read More

Feed: Hadoop Dev. Author: Nailah Bissoon. by Nailah Bissoon Big SQL Senior Technical Architect – Introduction Big SQL workload management (WLM) offers the capability to monitor and control statements executing on the cluster to make efficient use of cluster resources, ensuring that the cluster is not over or under utilized. At a high level, a certain number of concurrent queries can be executed so as not to over saturate the cluster resources. When this threshold is exceeded, incoming work is queued until some of the earlier queries have completed. It is recommended to first implement the performance tips described in ... Read More

Feed: Hadoop Dev. Author: Nailah Bissoon. by Nailah Bissoon Big SQL Senior Technical Architect The needs of the business may dictate that certain queries or workloads should be prioritized higher than others. Prioritizing of workloads must be done at the CPU and memory level. In this blog, we will show how to map applications to workloads and how to assign CPU and memory resources to them such that one workload is prioritized higher than the other. Recall that workloads are mapped to service classes and resources are controlled at the service class level. More details can be found in Big ... Read More