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

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

WEBCAST - The process of SQL "tuning" involves finding the absolute fastest route to answer your query. In this webcast, discover how SQL tuning brings down your CPU costs and lowers response and run times. Also find out answers to pressing SQL tuning questions including "how do you find the SQL to tune" and "which SQL must be tuned and why?"
Posted: November 11, 2009 | Premiered: November 11, 2009


Topics:  Application Development | Application Performance Management | Database Management Software | DB2 | Microprocessors | Multi-core Processors | Software Architectures | SQL | SQL Server

CASE STUDY - Learn how Key Energy Services, Inc., the largest rig-based oil well services company in the industry, is using Robot/SCHEDULE - the automated, job scheduler and batch management software across multiple platforms.
Posted: October 19, 2009 | Published: October 19, 2009


Topics:  Compliance (Systems Operations) | DB2 | Job Control Language | Job Scheduling Software | Operating Systems | OS/400 | System i

CASE STUDY - Read this case study to see how FCBT used Robot/ SCHEDULE to connect and coordinate their job scheduling needs across multiple systems.
Posted: October 19, 2009 | Published: October 19, 2009


Topics:  Compliance (Finance) | Database Management | DB2 | Job Control Language | Job Scheduling Software | Reporting Software | SQL Server | System i | Systems Management

PRESENTATION TRANSCRIPT - When developing a security strategy, it is critical for businesses to consider their System i platform in order to protect themselves from data breaches. In this presentation transcript, learn how to control network access on System i and protect your organization from data loss.
Posted: October 16, 2009 | Published: October 16, 2009


Topics:  Data Centers | Data Security | Database Management | DB2 | File Transfer Protocols | FTP | ODBC | Operating Systems | OS/400 | System i

EDITORIAL RESOURCE GUIDE - In this expert E-Guide, brought to you by SearchDataCenter.com and BMC, you will discover how to best maintain your mainframe infrastructure in light of the current economic climate. Explore the biggest challenges encountered by mainframe users today and gain insight into the distinct vulnerabilities and risks associated with mainframes.
Posted: October 9, 2009 | Published: October 9, 2009


Topics:  Applications Management | Authentication | Data Center Infrastructure Efficiency | Data Center Management | Data Centers | DB2 | Mainframe Operating Systems | Mainframe Server Hardware | Software Migration

TRIAL SOFTWARE - IT organizations are trying to support an increasing number of databases and database platforms. Meanwhile, database vendors are adding more features and updating their technology. DBAs must meet zero downtime requirements, and strict SLAs.
Posted: September 10, 2009 | Published: September 10, 2009


Topics:  Database Administration | Database Management Software | Database Performance Management | Database Security | DB2 | Downtime | High Availability | Productivity | Service Level Management | SLA | SQL Server

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

WHITE PAPER - Authored by Ron Ben Natan, Ph.D., author of "HOWTO Secure and Audit Oracle 10g and 11g" (CRC Press, March 2009), this white paper describes 8 essential best practices that provide a holistic approach to safeguarding databases and achieving compliance.
Posted: April 3, 2009 | Published: April 3, 2009


Topics:  Data Security | Database Security | DB2 | Oracle (Product) | Security | Security Best Practices | Security Management | SQL Server