Category: DB2

Feed: Databasejournal.com - Feature Database Articles. Author: . News Via RSS Feed Featured Database Articles Posted April 19, 2018 By Lockwood Lyon 5 New Features for Db2 12 for z/OS SQL Pagination Syntax In the past, on-line applications provided search capabilities to users by permitting the entry of key subsets or wildcards on the screen. For example, one could request a search for customers with a last name of “Smith*”, where the asterisk indicated any combination of zero or more letters. The results would include names like Smith, Smithe and Smithson. Typically, the application would present these results in alphabetical ... 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: 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: Data Henrik; Author: Henrik Loeser (data_henrik); As you might remember, I have been using the IBM Watson Conversation service and DB2. My goal was to write a database-driven Slackbot, a Slack app that serves as chat interface to data stored in Db2. I will write more about that entire Slackbot soon, but today I wanted to share some chatbot tricks I learned. How to gather input data, perform checks and clean up the processing environment. Slots ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Db2 access via IBM Cloud Functions Recently, I have been experimenting with the IBM Watson Conversation service and Db2. With a new feature in the conversation service it is possible to perform programmatic calls from a dialog node. Why not query Db2? I implemented both a Db2 SELECT and INSERT statement wrapped into actions of IBM Cloud Functions. It is quite easy and here is what you need ... Read More

Feed: Data Henrik; Author: Henrik Loeser (data_henrik); Db2 User Group Happy New Year! I hope you had a great start into 2018. How about meeting in person soon? I am going to speak next week at the German Db2 User Group (DeDUG) meeting in Karlsruhe. It will be hosted by Fiducia GAD IT AG. You can find out about the details and register for the Db2 user group event here. Topics include database security using trusted contexts, the Db2 catalog and ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . As many enterprise applications mature, the increases in customers, functions, features and transaction rates require scaling up. Several alternatives for maintaining acceptable performance include installing or upgrading hardware resources such as CPU speeds, disk volume and computer memory. Of these, adding memory can sometimes be the cheapest and most convenient. In this article we review how features in Db2 for z/OS version 12 can use additional real memory to reduce transaction times and more efficiently use CPU and other resources to meet critical application needs. Understanding Mainframe Resource Constraints Running applications under ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Version 12 of IBM’s Db2 for z/OS (Db2 12 for z/OS) contains many new features and functions for DBAs and application developers. This latest Db2 version emphasizes performance enhancements across a wide variety of areas, including enhanced on-line transaction performance, improved efficiency for analytical query access paths, removal of some size limitations and exploitation of operating system and storage hardware characteristics. Exploiting Large Real Memory It is not uncommon to have mainframe hardware configured with multiple terabytes of memory, with several hundred gigabytes allocated to each Db2 subsystem. This is due to ... Read More