This tutorial introduces skills you must have to properly manage a DB2 server. This is the first tutorial in a series of six that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Database Administration Certification (Exam 701).
Other News
IBM Builds Bridge for DB2
By Dennis Callaghan – IBM has developed a metadata product that will help enterprises that use a variety of third-party reporting tools access data from its DB2 database.
Quest Software Releases New Version of SharePlex, Delivering Broadest Oracle Database Support Available
Software, Inc. has announced the availability of SharePlex(R) 4.5. The new version of SharePlex is the first available database replication product to support both Oracle9i Real Application Clusters (RAC) and Oracle Parallel Server (OPS), as well as providing enhanced support for the Oracle E-Busine
So You Want to Use Oracle’s SPFILE
By James Koopmann – Oracle’s traditional method of storing parameters in the INIT.ORA file has given way to a more robust method– the server parameter file (SPFILE). Learn what truly works in converting and maintaining your parameters without ever having to use an editor again.
Data Discovery
By Russ Whitney – When you’re choosing between relational reporting and OLAP for data analysis, remember that the two tools are different. Relational reporting can provide solid data for decision makers, but OLAP addresses the human side of the equation.
Improved Web Connectivity in Microsoft SQL Server 2000 Analysis Services
Learn about the installation, implementation, and behavior of HTTP connectivity in SQL Server 2000 Analysis Services Service Pack 3.
Shrink Database Size
by Naresh Awasthi – This database procedure can be used to shrink tablespaces by passing two values: 1. Tablespace_name 2. Freespace_keep_pct It’s specially useful if you are refreshing a dev instance from prod and you don’t want to occupy the same size RBS, TEMP, an
IBM smartens up business intelligence
By Ed Scannell – To enhance the analytical capabilities of DB2, IBM on Monday rolled out software that better prepares and shares complex information for analysis by third party business intelligence applications. Called Cube Views, formerly code named Aurora, the new software reportedly uses
DB2 XML Extender
DB2 XML Extender provides new data types to store XML documents in DB2 databases and new functions to work with these structured documents. Managed by DB2, these documents are stored as character data or external files. Retrieval functions enable you to retrieve complete documents or individu
Microsoft Pushes Back ‘Yukon’ Release
(Peter Galli) Microsoft Corp. has pushed back the release of the next version of SQL server, code-named Yukon, which will now ship in the second half of 2004 rather than the first half as previously expected. Paul Flessner, the senior vice president of Microsoft’s Windows Server division, told se