(Paolo Bruni, Mark Anders, KyengDong Park, Mark Rader and Judy Ruby-Brown) DB2 for z/OS takes advantage of data sharing technology in a z Parallel Sysplex to provide applications with full concurrent read and write access to shared DB2 data. Data sharing allows users on multiple DB2 subsystems, memb
Tag: IBM
Import COBOL copybooks in IBM Rational Data Architect
(Davor Gornik) Since Fix Pack 1, Rational Data Architect has been able to import COBOL copybooks as a logical data model. Importing as a physical model is not possible because physical data models in Rational Data Architect require database specification, which is not part of the copybook specificat
IBM touts Linux-based data warehouse package
(Robert Jacques) IBM has unveiled an integrated data warehouse offering for Linux that combines software, server and storage technologies.
Building an ASP.NET 2.0 Master/Detail Application with DB2
(Anil Mahadev) Back in the old days, connecting two data grids to enable master/detail relationships wasn’t that easy. Now, with Visual Studio 2005 and ASP.NET 2.0, building master/detail relationship apps is just a matter of using the right controls for the job. This tutorial describes using DB2 wi
Analyze DB2 deadlocks for DB2 for z/OS Web applications
(Zi Yan Tu and Li Shun Yang) This article describes how developers and testers can determine the causes of deadlocks in complex Web applications running in DB2 for z/OS environments.
SQL statement error
(Kent Milligan) I am running the following SQL statement but getting an error as “Position 1 Null values not allowed in column or variable VC_EST_PAYMENT UPDATE UARSLSDET AS A SET (VC_EST_PAYMENT, FEE) = (SELECT IFNULL(EST_PAYMENT*100,0), IFNULL(FEE*100,0)
In predicate performance problem
(Omer Brandis) In this post I’ll tell you about two limitations of the DB2 optimizer (DB2 for z/os v8) in regard to “in” predicate processing.
Leverage MySQL skills to learn DB2 Express, Part 4: DB2 versus MySQL data movement
(Allan Tham) If you’re a DBA with responsibilities across both MySQL and IBM DB2 Express-C, you need to understand how the capabilities of these two database servers compare. This article is the fourth in a series of articles designed to assist DBAs coming from a MySQL background learn how to admini
Developing JDBC Applications with DB2’s pureXML
(Anson Kokkat) The combination of XML features and JDBC has provided Java developers with more powerful choices for manipulating data within their applications. Meanwhile, the evolution of Java has spawned many JDBC drivers—interfaces for connecting with a database and manipulating data within a Jav
A formally published white paper on zIIP measurements is available
(Willie Favero) This is just a very short post to let you know that there is a new white paper available from the folks at SVL that discusses bunches of measurements using zIIP. If you have any interest in the zIIP specialty engine at all, or if you just had one installed or are about to have one in
