By Barbara Darrow – IBM filled another slot in its Express lineup with the debut of DB2 Universal Database Express last week.<Br><br>The database, retailing for $499 per server plus $99 per named user (without support) offers partners an inexpensive and easy-to-install database for small and mid-siz
Tag: IBM
Embarcadero Technologies Announces DBArtisan Workbench for Managing Complex Enterprise Database Environments
Embarcadero Technologies, Inc., a provider of application and database lifecycle management solutions, announced Embarcadero® DBArtisan. Workbench for managing complex databases across the enterprise. DBArtisan Workbench combines Embarcadero’s flagship database management solution, DBArtisan, with E
New DB2 UDB Fastpath DBA course for V8
Are you an experienced relational database administrator who’d like to learn DB2? Then this updated self-study course is for you — at no charge. The DB2 Universal Database Administration Fastpath course helps experienced database administrators gain DB2 UDB V8.1 skills quickly and easily.
Multiple sorts without using dynamic SQL
By Jim Haire – Have you ever wanted the order of your data sorted differently based on some condition? You could do it by coding multiple cursors or creating dynamic SQL. Here is a way to do it with static SQL and only one cursor.
IBM Expands Tivoli Risk Manager Support
By Lisa Vaas – IBM’s Tivoli Risk Manager now automatically monitors and protects all the big databases from security threats, malicious users and other vulnerabilities, the company announced Tuesday.Tivoli Risk Manager 4.1 now supports IBM’s own DB2 Universal Database, Oracle Corp.’s 8i and
Ascential Software and IBM DB2 Cube Views Maximize the Performance of Business Intelligence Solutions
Ascential Software Corporation (Nasdaq: ASCL), the enterprise data integration leader, announced full support for IBM’s new DB2 Cube Views software. The Ascential(TM) Enterprise Integration Suite combines with Cube Views to accelerate the development and lower the total cost of ownership for online
Just the Stats, Ma’am
By Robert Catterall – Statistics reports can reveal surprising facts about the subsystem you thought you knew well.
Denormalization of DB2 tables
by Craig Mullins – Speeding the retrieval of data from DB2 tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize DB2 tables. The opposite of normalization, denormalization is the process of putting one fact in many places. This speeds data r
BMC Hones Data Management Tools for DB2
By Lisa Vaas – BMC Software Inc. is rolling out support for IBM DB2 Universal Database in its SmartDBA data management software family of products, the company announced at the International DB2 Users Group conference, in Las Vegas.
SQL Bible
Book by Alex Kriegel and Boris M. Trukhnov – Covers the latest version of the ISO SQL standard (SQL-99) and gives readers information they need to know about the differences in vendor-specific SQL implementations including Oracle, Microsoft SQL Server, and IBM DB2