WHITE PAPER - This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.
Posted: November 30, 2009 | Published: November 30, 2009


Topics:  Code Management | Data Centers | Database Design | Database Performance Management | DB2 | Network Performance | SQL | SQL Server | z/OS

WHITE PAPER - The ever present demand to maximise the value delivered by business-critical applications requires that we optimise the use of all the resources that execute and manage them. BMC Software is one of the major vendors offering such support and has a highly regarded set of solutions collectively called BMC SQL Performance for DB2.
Posted: November 20, 2009 | Published: November 20, 2009


Topics:  Database Administration | Database Management | DB2 | Midrange Server Hardware | SQL | z/OS

WHITE PAPER - DBA's have always been faced with the difficult task of maintaining a successful database environment, but recently new trends have come along to further challenge them.
Posted: September 10, 2009 | Published: September 10, 2009


Topics:  Capacity Planning | Database Administration | Database Architectures | Database Performance Management Software | DB2 | High Availability | SQL | Storage Capacity | Storage Management | Workload Automation

WHITE PAPER - This paper will take a look at some of the problems that project data and process architects face in working with other IT roles as well as seven easy and inexpensive steps they can take to ensure a collaborative team environment.
Posted: September 10, 2009 | Published: September 10, 2009


Topics:  Business Processes | Collaboration | Collaborative Master Data Management | Data Management | Database Administration | Database Administrators | Databases | DB2 | IT Management | Project Management | Project Portfolio Management | Regulatory Compliance

WHITE PAPER - This paper discusses how you can leverage existing Abend-AID capabilities to simplify problem resolution even in these increasingly complex systems. Read this paper to learn more about diagnosing DB2 and WebSphere MQ problems with Compuware Abend-AID.
Posted: September 4, 2009 | Published: September 3, 2009


Topics:  Application Development | Application Server Software | DB2 | Java | Mainframe Computers | Mainframe Operating Systems | Mainframe Server Hardware | Server Management | Server Software | Web Development | Web Development Tools | Web Services | WebSphere

WHITE PAPER - Because organizations are demanding 24x7 availability from their IMS, DB2®, and VSAM applications, it is imperative that those applications do not experience outages. Read this whitepaper to find out how BMC's Hybrid Copy techniques help for faster system recovery in the event of a local outage.
Posted: April 17, 2009 | Published: April 17, 2009


Topics:  Backup Software | Database Management | Database Security | DB2 | Disaster Recovery | High Availability | Imaging Software | Systems Management | Systems Management Software | Tape Backups | VSAM