Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap
News Via RSS Feed


follow us on Twitter

Database Journal |DBA Support |SQLCourse |SQLCourse2

DB2 management, tutorials, scripts, coding, programming and tips for database administrators

DB2

Database Backup and Recovery in the Age of Big Data 09/19/2013

Big data is the latest craze. Hardware and software vendors have overwhelmed IT departments with high-speed analytical software, proprietary high performance hardware, and columnar-based data stores promising quick access, promising lightning-fast answers to ad hoc analytical queries. Forgotten in this blast of technology are the database administrators' most important responsibilities: backup and recovery.

The Database Administrator's Back-to-School Checklist 08/19/2013

To meet the upcoming 'Peak Season' demands on IT systems, database administrators (DBAs) need to prepare the database and its supporting infrastructure for increased resource demands. Being proactive now can pay big dividends by maintaining service level agreements (SLAs), avoiding outages and resource shortages, and ensuring a positive overall customer experience.

The Big Data DBA 07/18/2013

Many IT enterprises are starting pilot projects to implement big data solutions. As a DBA, are you ready to support these efforts, and integrate them into your current architecture, processes, and standards?

Performance Tuning in the Age of Big Data 06/17/2013

Big Data is here, or will soon be here for the majority of IT enterprises. Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis.  If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.

Managing the Transition to Big Data 05/16/2013

Articles and advice on Big Data hardware and software solutions abound. The most popular topic is the role to be played by new analytics solutions such as analytical appliances, NoSQL database management systems (DBMSs) and Apache Hadoop software. How can the IT enterprise plan such implementations? What are the first steps?

Application Design: Where the DBA Fits In 04/18/2013

The design requirements of an application usually determine the most effective database design and database administration support processes. If, however, the database administrator (DBA) is not present during the requirements definition process, sub-par performance can result.

The Trouble with SQL Tuning 03/28/2013

Database administrators tend to think of SQL tuning as necessary, important, even critical. The reality is that the savings realized by tuning SQL, usually manifested in saved CPU time and decreases in elapsed times, may offset the costs incurred in time and resources.

Managing the Database Administrator 02/25/2013

Many database administrators (DBAs) function as a team supporting multiple corporate applications on a variety of hardware platforms using several database management systems (DBMSs). Managers struggle with priorities and must juggle user requirements and deadlines against staff availability and expertise. Here is one way to manage DBA tasks based on the makeup of the team.

Techniques for Analyzing Historical DB2 Application Performance Data 01/17/2013

Despite extraordinary advances in the speed and capacity of disk storage CPU performance  and available memory, application performance tuning remains as one of  the core tasks of the database administrator. What strategies are available for gathering and analyzing performance information?

Tuning an IBM DB2 for z/OS Application: Transaction Times 12/17/2012

Many applications have Service Level Agreements (SLAs) that promise quick turnaround or acceptable on-line response time. Lengthened transaction elapsed times are a cause for concern. Here are several methods the database administrator can use to alleviate these issues.

The DB2 Database Administrator's Christmas Wish List 11/26/2012

Budgets are shrinking and management's eyes are clearly on the bottom line. Under these conditions, what would a DB2 database administrator (DBA) want on their holiday wish list?

Database Recovery Options 10/22/2012

Both application designers and database administrators sometimes take the simplistic view that regular backups of application data are sufficient for any recovery needs--a strategy that can easily backfire! Backup methods that meet the application’s and enterprise’s needs start with a sound recovery strategy that starts with database design.

DB2 Archives