Skip to main content


developerWorks  >  Information Management  >  Products  >

DBA Central

developerWorks
Resources for IBM Information Management database administrators

Updated 19 Nov 2009

IDS 11.5 Fundamentals Exam 555 certification preparation, Part 5
IDS 11.5 Fundamentals Exam 555 certification preparation, Part 5
Get an introduction to SQL, and learn how Informix Dynamic Server uses SQL to manipulate data in a relational database.  More

Search technical library
All articles
All tutorials and online courses

For a comprehensive selection of troubleshooting documents, search the IBM technical support knowledge base.

Downloads, CDs, DVDs
Select a download:
Download: Data Studio Developer
Download: Data Studio Administration Console
Trial: DB2 for Linux, UNIX, and Windows
DB2 Express-C
Informix Dynamic Server
Learning resources
Select product or component documentation:
New to IBM Information Management
Certification
DB2 9 for Linux, UNIX, and Windows Information Center
IDS Information Center
DB2 UDB V8 for Linux, UNIX, and Windows DBA Certification Guide
DB2 9 Fundamentals certification 730 prep tutorials
Information Management training
Information Management books
Access Safari's e-reference library
Role-based skills roadmaps
Advanced DBA Certification Guide for DB2 UDB for Linux, UNIX, and Windows
DB2 9 DBA 731 certification prep tutorial series
Support
Select product support page:
ISV Resources
Porting to DB2 for Linux, UNIX, and Windows
Migration station
Redbooks technotes
Community
Optim Database Administrator forum
IBM Business Partners
International DB2 Users Group (IDUG)
developerWorks blogs
Susan Visser's blog on skills
International Informix Users Group (IIUG)
Information Management forums
Information Management community
dW Weekly Edition newsletter
More product information
DB2 for Linux, UNIX and Windows product page
DB2 for z/OS product page
Informix product page
DB2 for Linux, UNIX and Windows page on developerWorks
DB2 for z/OS page on developerWorks
Informix page on developerWorks
About dW  |  dW newsletter  |  Build custom feeds |  Submit content


 logo

Spotlight
Virtual tech briefing: Performance Management 101 for DB2 for Linux, UNIX, and Windows (8 Dec)
Demo: A day in the life of a DBA
On-demand webcast: Improve data security with Rational Data Architect V9.5
On demand webcast: Developing and managing transaction-intensive solutions for your industry

Latest content
Use Technology Explorer for IBM DB2 to manage user and group authentication for DB2 for Linux, UNIX, and Windows
Learn about the db2auth plug-in and how to use it in Technology Explorer for easier user and group authentication.
Copy your SAP ERP system across platforms using DB2 redirected restore
Use this step-by-step guide to perform a cross-platform heterogeneous system copy of an existing SAP ERP system across different platforms using a DB2 for Linux, UNIX, or Windows redirected restore operation.
Using DB2 incremental backup
Learn how incremental backup works, when you might want to use it, and strategies for ensuring smooth database recoveries. This article has been updated for DB2 9.5.
Best practices for DB2 for Linux, UNIX, and Windows: Cost reduction strategies with DB2
Reduce the costs associated with DB2 maintenance by using the Configuration Advisor, the Design Advisor, and autonomic features such as the self-tuning memory manager.
Get started with Informix Dynamic Server user interface tools
Learn about the user interface utilities that can help you access, administer, and monitor IDS, including DB-Access, AGS Server Studio, Open Admin Tool, and Informix Server Administrator.
How to identify unused indexes in DB2 for Linux, UNIX, and Windows
These four methods for identifying DB2 LUW indexes that are never or rarely used can come in handy for DBAs who want to get the optimal performance from their database.
Building efficiencies into a DBA 's day
Achieve greater efficiency and accuracy with Optim Database Administrator content assist templates. Sample templates are provided along with instructions on how to build your own.
IDS 11.5 Fundamentals Exam 555 certification preparation, Part 7
Learn about the tools and utilities available in Informix Dynamic Server that make monitoring and administering IDS easier.
Automated instance failover using db2haicu
Guarantee the availability of your DB2 data using a shared disk topology. This article introduces DB2 high availability technology and takes you through two scenarios using the db2haicu utility to configure HA solutions.
DB2 for Linux, UNIX, and Windows backup in an SAP environment
In this article, you'll get the information you need to make sure you have a secure strategy for database backup and recovery in the context of an SAP system.
IDS 11.5 Fundamentals Exam 555 certification preparation, Part 9
Explore the different replication and high availability technologies available in Informix Dynamic Server. Learn how to set up an IDS server for replication and high availability.
More content

Editor's picks
Best Practices for DB2 for Linux, UNIX, and Windows
DB2 9 self-tuning memory management

Special offers
DB2 pureScale:  Unlimited capacity for your data
Optim Development Studio trial
Download the IBM pureXML developers e-Kit at no charge

More offers