This series of six free tutorials is designed to help you prepare for the DB2 Version 8 DBA (Exam 701) certification exam. These tutorials provide the solid base knowlege needed to attain the certification “IBM Certified Database Administrator – DB2 UDB V8.1 for Linux, and UNIX.”
Tag: IBM
IBM Ships ‘Invisible’ Database
By Lisa Vaas – IBM released DB2 Express, a no-click, quiet-as-a-mouse, self-installing version of its DB2 UDB (Universal Database) that’s aimed at small to medium-sized businesses.
Data Miner – Are You Really in the Know?
By Keith Hermiz – Without data mining, you shouldn’t bet the business on what you think you know.
IBM Unveils New DB2 Software to Further Automate & Optimize Information Analysis
IBM introduced DB2 Cube Views, new software that better prepares complex information for analysis by a large spectrum of third-party business intelligence applications, helping them perform 10% – 70% more efficiently, and enabling them to share information more easily with one another.
DB2 regular expressions for the SQL-challenged
By Jim Keohane – Fans of MySQL and mSQL taunt DB2 users about DB2’s lack of support for the non-standard RLIKE/REGEXP facility in SELECT and other SQL statements.
Access DB2 with Web services
By Quentin Presley – Web services enable you to quickly integrate applications across multiple platforms, systems and even across businesses. This tutorial demonstrates how easily you can make your DB2 data accessible through Web services. It shows how to use the Application Developer configuration
Express Your Business with IBM DB2
By Patricia Fusco – Dubbed DB2 Universal Database Express, IBM’s new full-function database for the mid-market is designed to install itself with no mouse clicks required and is priced 30 percent less than other database management systems.
J2EE Development with DB2 Information Integrator: Digging into the Details
This second in a three-part series focuses on the details of our authors’ experiment in writing code to access Oracle, DB2 UDB, and Microsoft Excel data sources. Get the details here.
BMC, Quest Tackle DB2
By Lisa Vaas – Users of IBM’s DB2 software can turn to tools from BMC Software Inc. and Quest Software Inc. to manage the enterprise DBMS.
Using LOBs and extenders in DB2
In today’s enterprise, unstructured data — video files, sound files, picture files, and even large text files — is increasingly common. Nonetheless, database management systems have only recently been able to effectively deal with this data type. This tip from author Susan Lawson, provided by Info