As many other I got challenged to set up a database architecture. Not only database objects related, describing the different environments was also asked and there was an urgent need for a decent security setup to support rollouts in general.
In Part 1, I talked about some of the first steps that a developer should go through when it comes to tuning queries. In this article, I will go through the initial steps in evaluating a SQL query using the Db2 explain output.
Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session from IDUG NA 2016, Steve Rees goes through a step-by-step, decision tree-based approach for tackling performance problems.
The concepts in this article were incorporated into the DB2 Native SQL stored procedures from my own experience in using the log4net utility with several C# applications. My logging examples consist of 3 basic components, and an example on how to add the logging to a DB2 Native SP.
IBM Cloud Data Services Introduces Infrastructure Flexibility with On-Premises Accessibility with IBM DB2 on Cloud, a Scalable Multi-Workload Relational Database
The IBM Cloud Data Services team is happy to announce the introduction of IBM DB2 on Cloud, a hosted version of IBM’s famous multi-worklo