(Guy Galil, Yaacov Lacher, Oded Sofer and Kathy Zeidenstein) Organizations that use InfoSphere Guardium for data security and compliance can take advantage of a rich set of APIs to automate processes and maintain their systems very efficiently.
Tag: IBM
Using LISTAGG to Turn Rows of Data into a Comma Separated List
(Ember Crooks) This is a topic I have to look up from time to time, and I always go straight to Serge Rielau’s blog. He has a number of good articles on LISTAGG, the similar XML specific functions, and much more.
TechTip: JSON and XML Conversion in DB2 for i
(Michael Sansoterra) As I noted in my article on SOA and REST, JavaScript Object Notation (JSON) is an important data format in today’s world of RESTful service offerings. Whether your apps are publishing or consuming data, you may be asked to work with JSON.
Creating multi-instance queue managers for WebSphere MQ Managed File Transfer
(Alex Au) This tutorial shows you how to set up WebSphere MQ Managed File Transfer High Availability using the WebSphere MQ Multi-Instance Queue Manager, so that you can automatically recover from file transfer errors when queue managers switch over from active to standby instances.
DB2 for z/OS: How Low Can Synchronous Read Wait Time Go?
(Robert Catterall) Short answer: lower than I’d previously thought.
What’s the Big Deal About Query Optimization? Part 1
(Suresh Sane) From the early days of SQL, database administrators (DBAs) have specified the what without worrying about the how. The prevailing assumption was that query optimization takes care of the how. A lot has changed since the days of relational databases, and SQL queries have become increasi
IT Budget Planning for Big Data
(Lockwood Lyon) Big data software, hardware, application suites, business analytics solutions … suddenly, it seems, IT enterprises are deluged with vendor offerings that solve problems it didn’t know it had. Competitors are gathering data to determine customer needs, define new product categories,
The DB2Night Show z53: Altering objects and the impact it has
(Martin) 96% of our studio audience learned something! Some alters are a piece of cake and can also reverted. Others are more complex and have a (big) impact.
Data Access on IBM i: Is It Time to Upgrade from Query/400?
For over 30 years, Query/400 has been the data access tool to generate reports easily from DB2 data—allowing access to insight like never before. While it continues to be sufficient for basic reporting functionality, most organizations are beginning to be challenged with the need to access and repor
Row and Column Access Support in IBM DB2 for i
(Jim Bainbridge, Hernando Bedoya, Rob Bestgen, Mike Cain, Dan Cruikshank, Jim Denton, Doug Mack, Tom McKinley and Kent Milligan) This IBM Redpaper publication provides information about the IBM i 7.2 feature of IBM DB2 for i Row and Column Access Control (RCAC). It offers a broad description of the
