(Willie Favero) We spend a lot of time talking about the really neat stuff like multi-row FETCH & INSERT and such because they give you some significant CPU back when you change your applications to take advantage of them. However, DB2 for z/OS Version 8 had a lot of SQL added and enhanced. So today
Tag: IBM
Geronimo Beans and the EJB Query Language
(Murali Vivekanandan) Enterprise JavaBeans (EJB) are the building blocks of Java Platform, Enterprise Edition (Java EE) applications, and the EJB Query Language (EJB QL) allows you to write queries without any knowledge of the relational schema governing the entity beans. This tutorial explains core
Perspectives on grid: An overview of WebSphere Extended Deployment
(Matt Haynos) There are many technologies that comprise grid computing. Organizations often struggle to integrate and deploy the various technologies. IBM WebSphere Extended Deployment, however, is an example of an integrated grid platform for virtualizing and managing Java 2 Platform, Enterprise Ed
Reminiscing with the DB2 catalog and directory
(Willie Favero) Do you know what the most important group of page sets are in all of DB2? More important than you most critical production table space? Yup, you guessed it; DB2’s catalog and directory.
Use Apache Derby to develop Eclipse plug-ins
(Ilya Platonov, Artem Papkov, Jim Smith and Terry Finch) Eclipse is a powerful IDE platform that supports numerous frameworks used for the creation of GUI components (such as SWT or JFaces) or for working with data (such as the Eclipse Modeling Framework). One of the most exciting features of Eclips
DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL
(K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Özcan, H. Pirahesh, N. Seemann, A. Singh, T. Truong, R. C. Van der Linden, B. Vickery, C. Zhang, and G. Zhang) Comprehensive and efficient support for XML data management is a rapidly increasi
Setting Up MSCS for DB2 Using VMWare
(Jack Xia, Anthony Corrente and Savio Pereira) DB2 Cluster running on MSCS is popular, but setting up MSCS requires expensive hardware, like shared disks, making it difficult to setup for test and education purposes. (pdf)
DB2 Version 8 CPU regression
(Willie Favero) You own a great car. It’s a nice 2 door, drives well, has had some maintenance issues, but overall runs pretty OK. However, it is over three years old and the warranty runs out in a year. While visiting the dealer, you find a great vehicle. It’s a diesel, a completely different engin
Use Rational Data Architect to define and enforce data object naming standards
(Wei Liu) Data object naming standards promote a common understanding of data, sharing of data across organizational boundaries, and reduction of data redundancy through the consolidation of synonymous and overlapping data elements. As organizations search for ever greater efficiency these days, the
Change Control for DB2 Access Paths
(Craig S. Mullins) An important aspect of efficient DB2 operation is the on-going analysis and management of DB2 access path changes. Whether you are implementing changes into your DB2 applications, upgrading to a new version of DB2, or simply trying to achieve optimum performance for existing appli
