(Cynthia M. Saracco, Don Chamberlin and Rav Ahuja) Services Oriented Architectures (SOA) are an integral part of building an agile enterprise capable of making decisions quickly, and responding rapidly to new products and services opportunities, as well as to competitive threats. The explosive growt
Tag: IBM
Back to basics: Scripting Apache Derby’s ij tool
(Nicholas Chase) Everybody’s building Web applications these days. But what if you just want a little bit of data? Do you really need to go to the trouble of creating a whole application? Doesn’t Derby provide a tool for that? Well, of course it does. Derby’s main command line tool, ij, is designed
The incredible shrinking data: DB2’s Compression – Part
(Willie Favero) It sometimes seems like we just recently (around December, 1993) added this “new function” to DB2. Some of you may have heard of it or maybe even read about it. After all, it was in all the announcements and discussed in the latest documentation. It was this little thing called data
Create customized views for line data reports
(Debbie Wagner) IBM DB2 Content Manager OnDemand is an automated archival and retrieval system that stores printed output such as reports, statements, invoices, and image documents. It processes printed material and stores it on various types of storage media including hard disks, optical platters,
DB2 9 DBA certification exam 731 prep, Part 1: Server management
(Dwaine Snow) Learn skills that help you to properly manage your DB2 database servers. This is the first in a series of seven DB2 9 DBA certification prep tutorials that you can use to help prepare for the DB2 V9 for Linux, UNIX, and Windows Database Administration (Exam 731). (R)
New leading 10TB TPC-H result for DB2
(Chris Eaton) On Friday July 14th, IBM delivered a new leading 10TB TPC-H benchmark result. This latest result with DB2 was run on a cluster of 16 8way p5 575s and delivered 180,108 QphH@10000GB with a price performance of $47/QphH (system available Aug 30, 2006).
Introducing DB2 9: Application development enhancements
(Rav Ahuja) DB2 9 (formerly codenamed “Viper”) provides numerous enhancements that simplify database application development, reduce development time, and improve developer productivity. In addition to providing a platform for robust enterprise applications, DB2 9 is also optimized for rapidly build
Monitoring DB2 Activity
Tuning and configuring a DB2 database can be a complex process that sometimes overwhelms new DBAs. There are, however, a great number of tools, functions, and applications included with DB2 that make this task much simpler. The release of DB2 Universal Database V8.1 includes new tools and informati
Integration of SQL and XQuery in IBM DB2
(F. Özcan, D. Chamberlin, K. Kulkarni and J.-E. Michels) Since the introduction of the first relational database systems in the early 1980s, the commercial database field has seen mostly evolutionary changes. Most large-scale commercial database systems introduced since that time have been based on
Document-level security using DB2 9 pureXML and LBAC
(Brian M. Williams) DB2 9 pureXML provides native XML storage and retrieval. In addition, DB2 9 provides a new security protection mechanism called Label Based Access Control (LBAC). Combining these two features can produce a Native XML data store that can protect XML documents at the document level
