IBM DB2 - The Ultimate Database for Cloud, Analytics & Mobile
With Db2 for z/OS continuous delivery model, new Db2 for z/OS features/enhancements are continuously delivered in service stream when they are ready. LISTAGG is one of first set of functions delivered in function level 501 since Db2 adopted continuous delivery model.
Added by Jane Man on November 24, 2017 at 6:34pm — No Comments
Python is one of the most commonly used programming language. Its interactive mode is ideal for prototype development and ad-hoc tasks. There is also a development GUI. Both are free to download or use under open source license. In the following article, I am going to show you how to use Python to connect to DB2 11 for z/OS and perform some basic database operations.…Continue
Added by Jane Man on March 11, 2017 at 2:00am — No Comments
DB2 for z/OS delivered native REST services support in the end of 2016. I wrote 2 white paper on how to create a DB2 REST service and how to consume this service from a mobile device. I start getting enquiries on how to consume a DB2 REST service from a node.js application. In the following blog, I am going to share my…Continue
Added by Jane Man on March 5, 2017 at 6:25pm — No Comments
Using machine learning features in Spark and an easy to follow example, learn how you can build/train/test a machine learning model using data from DB2 for z/OS.
Machine Learning using DB2 for z/OS data and Spark Part 1…
Added by Jane Man on January 2, 2017 at 6:00am — No Comments
Want to share my recent research on this topic:
Spark Analytics for XML data in DB2 for z/OS – Part 1 : scala.xml.XML
Spark Analytics for XML data in DB2 for z/OS – Part 2 : databricks XML package – on a single XML document
Spark Analytics for XML data in DB2 for z/OS – Part 3 : databricks XML package – on XML data in…
Added by Jane Man on November 11, 2016 at 9:00pm — No Comments
Applications focused around mobile devices are becoming increasingly important in large enterprises. RESTful APIs pay an important role in this area. From the following whitepaper, learn how you can expose DB2 functionality through RESTful APIs that are fully integrated in the DB2 distributed data facility (DDF) and how you can consume a DB2 REST service to build a DB2 for z/OS mobile application using IBM MobileFirst.…Continue
Check out my latest post on how to build a DB2 for z/OS application to leverage cognitive APIs provided by Watson:
Added by Jane Man on October 22, 2016 at 1:00am — No Comments
Check out my latest article on JSON in IBM developerWorks:
http://ibm.co/2ejxSDC ; - Advanced JSON SQL interface in DB2 for z/OS
If you are new to JSON in DB2 for z/OS, you may want to read my other article first:
Use a SQL interface to handle JSON data in DB2 11 for…Continue
APIs is the buidling blocks for apps. JSON and XML are two commonly used output in REST calls. The following articles describe how DB2 for z/OS invokes a REST service and how it utilizes the REST output.
DB2 for z/OS as a REST Service Consumer – Part 1: JSON output…
Added by Jane Man on October 14, 2016 at 4:02pm — No Comments
The following article written by 2 key DB2 for z/OS developers
discusses the key concepts and capabilities of DB2 Archive Transparency functionality and how it can be used to simplify application logic. With the built-in global variables, DB2 uses SQL to provide basic capability for data archiving and transparent access to archive data via queries. It is a…Continue
Added by Jane Man on October 11, 2016 at 9:00pm — No Comments
Added by Jane Man on October 5, 2016 at 9:30pm — No Comments
Just come back from an XML bootcamp in France. During the bootcamp, I demo how to use CLP to register XML schema in my Window machine. Attendees got an impression that I was using the CLP that delivered with DB2 LUW. In fact, I was using the CLP delivered with DB2 for z/OS. Since it is a jar file, so I ftp it to my Window machine to use.
DB2 for z/OS CLP is designed to run in USS. The clp.jar I used for…Continue
Added by Jane Man on May 20, 2016 at 8:19pm — No Comments
A few days after my whitepaper for DB2 Adapter for z/OS Connect Part 1 was online, I have people asking me for Part 2
Eventually, Part 2: Build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect, Part 2: Consume a DB2 Adapter service is online…
Added by Jane Man on March 17, 2016 at 9:19pm — No Comments
To create effective, enterprise-ready mobile applications, you need to make the back-end data easier to consume. APIs in IBM® DB2® Adapter for z/OS expose DB2 for z/OS functionality to applications. See an easy-to adapt example to learn how you can build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect and IBM MobileFirst Developer Edition. In In Part 1 of the following complimentary whitepaper, discover how to expose DB2 for z/OS functionality by using DB2 Adapter for…Continue
Added by Jane Man on March 2, 2016 at 1:27am — No Comments
DB2 11 for z/OS offers document storage support for JSON. The JSON data is stored internally as BSON (Binary-encoded Serialization of JSON) in inline BLOB column.
DB2 11 for z/OS provides the following SQL APIs to manipulate JSON data:
Added by Jane Man on February 19, 2016 at 7:00pm — No Comments
In DB2 for z/OS, we can use LIKE predicate to do pattern matching, in which we use
the underscore character(_) represents any single character
the percent sign(%) represents a string of zero or more…
Added by Jane Man on January 15, 2016 at 10:30pm — No Comments
In this post, we'll show you how to use a stored procedure to call a standard DB2 for z/OS utility, RUNSTATS, from within a mobile app. You can apply the steps in this post to call other DB2 for z/OS utilities as well.
Before you begin, make sure that you've completed part 1 and…Continue
Added by Jane Man on October 28, 2015 at 5:10am — No Comments
Before you begin, make sure that you've set up your IBM MobileFirst Platform environment by completing the steps in part 1 of this tutorial.
In this post, we'll retrieve a string from SYSIBM.SYSXMLSTRINGS. SYSIBM.SYSXMLSTRINGS is a catalog table that contains mappings between the…Continue
Added by Jane Man on October 28, 2015 at 5:00am — No Comments
Because of its quality of service, high availability, security, and performance, many organizations rely on DB2 for z/OS to store their critical transactional data. We've entered a new era in which we increasingly use our phones and tablets for all types of transactions -- everything from shopping and banking to social interaction and research -- mobile access to DB2 for z/OS transactional data is more critical than ever.
IBM MobileFirst Platform is an ideal platform for…Continue
Added by Jane Man on October 28, 2015 at 4:30am — No Comments
You don't need to be a PhD to do predictive analytics on data stored in DB2 for z/OS. The complimentary whitepaper below illustrates
how to use the SPSS Modeler workbench to create predictive models with in-database mining, SQL push-back, and UDF scoring. The whitepaper walk through the steps for integrating in-database real-time scoring for DB2 for z/OS into an OLTP application.…Continue
Added by Jane Man on October 22, 2015 at 5:54pm — No Comments