This article starts a serial devoted to Db2 for z/OS System Profiles. Profiles are still not widely used and known while they represent a strong capability allowing to automatically tune the system. This introductory article discusses how you can define and activate a system profile.
Did you know that you can issue SQL statement to Db2 for z/OS using File Transfer Protocol (FTP)? If not, make sure you read this new brand article!
Do you need to switch between managing databases in the different DB2 instances frequently? In this blog you will learn how you can easily manage multiple instances and simplify the switch.
Today we will introduce the XQuery language and cover a basic subset of this language, including constructor and FLWOR expressions. Both expressions will be useful in SQL/XML functions in DB2 for z/OS.
We are getting back on track how to access and manipulate XML documents in DB2 for z/OS. But this time, with focus on more complex XML data manipulation techniques than just selecting/inserting/updating, or deleting the whole XML document.