DB2 for z/OS is no longer about the traditional relational structured data only. The evolution brought us not only binary objects, or XML and JSON, but also other non-structured data living in a distributed file system such as HDFS.
Have you ever thought about using XML in DB2 for z/OS, but were afraid that you would need to study a lot of material before you could actually begin? Don’t worry! You do not need to know much before you start. You can get by with basic DB2 for z/OS knowledge.
April 2015 “Fun with SQL” third Challenge
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
Let’s speak today the database monitoring. DB2 is usually presented as a black box that stores and retrieves data for you. Usually we don’t care much about what is happening inside it. However as soon as a trouble arises, information about its internals becomes critical.
You know it. You’ve just successfully compiled, built, and bound your application program for DB2 for z/OS, but the execution fails with the SQL error code -805. What’s the problem? You’ve just got one of the most common errors each developer encounters. Let’s make a short overview of the -805.