XML output: DBMS can generate a XML document which can be sent to other programs for processing who have the ability to process XML documents. By using this process XML output can be transmitted over an HTTP link using Simple Object Access Protocol (SOAP).
Author: SSWUG Research
Pretty printing XML and JSON files with PDI (1/2)
(Sergio Ramazzina) These days I’ve got into a stupid trouble with PDI. A customer asked me to build a process that produces an XML file as a result; the result I get was horrible from a presentation standpoint: the file wasn’t rightly pretty printed and that makes it very difficult to be read.
Missing index suggestion – Duplicate Index
(Ted Krueger) The missing index feature, while tuning or checking estimated and actual plans, is very helpful. Something that is key in that sentence is the word, helpful. Don’t run out and simply create all of them.
Mega Menus for SharePoint – Part 3 of 3
(Heather Solomon and Dustin Miller) The final post of a three part series, Heather Solomon and Dustin Miller are exploring the ever-popular “Mega Menu”, and how to create a powerful, styled and functional mega menu for use on your SharePoint sites.
Tuning the Oracle Connector performance in IBM InfoSphere DataStage, Part 2: Optimization of bulk load operation and considerations for reject links and data types
(Predrag Maksimovic) The Oracle Connector is a connectivity component in IBM InfoSphere Information Server. It is utilized by IBM InfoSphere DataStage and other products in the Information Server suite to perform extract, lookup, load, and metadata import operations on Oracle databases.
Serialization and Deserialization of JSON Data
(Sandeep Singh Shekhawat) JavaScript Object Notation (JSON) is an open and text-based data exchange format. In other words it is a text format for the serialization of structured data.
Where Is DB2 BLU Accelerator For IBM i?
(Timothy Prickett Morgan) IBM has created a neat new database feature for its DB2 database for Linux, Unix, and Windows operating systems that will hopefully make its way into the integrated DB2 for i database that resides inside the IBM i operating system.
Split mirror and db2relocatedb – powerful db2 recovery options
All of us are familiar with backup/restore commands and this is the most widely used method for db2 backup and recovery. But there are other ways you can use to backup and recover your data.
Diagnosing problems with SQL imports
(Maciej Dobrzanski) Importing a text file containing a list of SQL commands into MySQL is a straightforward task. All you need to do is simply feed the file contents through pipe into MySQL command line client. For example: mysql app_production < dump.sql. [membership level="0"] [pmpro_button level="14" text="Read More - Register for Free Membership"][/membership] [membership][standout-css3-button href="http://www.dbasquare.com/2013/04/17/diagnosing-problems-with-sql-imports/" opennewwindow=true]Read More[/standout-css3-button] (Community content) [/membership]
ASM AU Size And LMT AUTOALLOCATE
(Randolf Geist) When using Locally Managed Tablespaces (LMT) with variable, system managed extent sizes (AUTOALLOCATE) and data files residing in ASM the Allocation Unit (AU) size can make a significant difference to the algorithm that searches for free extents.