(Jurgen Holtz and Robert Vaupel) The zSeries platform and z/OS can run multiple, concurrent workloads within one z/OS image or across multiple images that share the same physical processor. The dynamic workload management function, implemented in the workload manager (WLM) component of z/OS, makes t
Tag: IBM
Recompile after reorg?
(Craig Mullins) Is it necessary to recompile and/or rebind a program after doing a reorg on a table that is used by the program to take advantage of the reorg? (R)
BUG: Four-part Name Linked Server Queries Fail Against DB2 for OS/390
When you run a four-part name query such as the following SELECT * FROM LinkedServer name.Catalog.Schema name.Table name using the Microsoft OLE DB Provider for DB2 from a linked server to DB2 on OS/390, the following error might be reported by the SQL Server: Server: Msg 7314, Level 16,
Preparing for DB2 Near-Realtime Business Intelligence
(Chuck Ballard, Roopa MS, Olaf Mueller, Zhi Yuan Pan, Andy Perkins and Pagadala J. Suresh) In this IBM Redbook we discuss primary processes and various alternatives that prepare you in implementing a DB2 near-realtime business intelligence environment. We discuss architectural alternatives and inclu
IBM DB2 Records Manager and Record-Enabled Solutions
This paper by Cohasset Associates, Inc. assesses several IBM products against a set of functional requirements. (R,pdf)
IBM plans to ‘double’ new Las Vegas division
(Valerie Miller) Las Vegas a tech Mecca? The people who scoffed at that notion just a few short months ago might be eating a little crow right about now. The acquisition of local software developer SRD by IBM has sparked renewed hope that the Las Vegas Valley can attract high-technology industries.
Modernizing iSeries Application Data Acess – a Roadmap Cornerstone
(Hernando Bedoya, Daniel Cruikshank, Birgitta Hauser, Sharon Hoffman, Rolf Andre Klaedtke and Warawich Sundarabhaka) In 1978 IBM introduced the System/38 as part of its midrange platform hardware base. One of the many outstanding features of this system was the built in Relational Database Managemen
Tune SQL procedures
(Serge Rielau) Do you want to learn some tricks for tuning SQL PL? If so, this article describes common examples for tuning SQL procedures in IBM DB2 Universal Database (UDB) V8.2 for Linux, UNIX, and Windows, with a special focus on procedures ported from other database management systems.
Mass deployment of DB2 Universal Database Version 8.2 on Microsoft Windows operating systems
(Rory A.A. Hinton, Andrew Hilden and Louisa Ford) The distribution and installation of any database software across large numbers of clients and servers can be a daunting task. However, DB2 Universal Database (UDB) Version 8.2 has features and tools that allow both servers and clients to be deployed
Backup and Recovery with Unicenter Database Management r11 for DB2 for z/OS
This is the final of four technical updates for Unicenter Database Management r11 for DB2 for z/OS. We will discuss how the enhancements in this release can benefit the backup and recovery plan for your DB2 for z/OS environment. (R)