(Sean McCown) With the latest release of DB2, IBM is poised to reshape the database landscape. Big Blue speaks very proudly and boldly about its new adaptive technology. In Version 8.2, IBM has realized some of the promise adaptive technology has to offer, but the company still has a way to go befor
Tag: IBM
Recording every change made in a database
(Craig Mullins) We are building a new database (UDB v8) and our users have asked us, the DBAs, if it is possible to record every change made in the database in a logging table. This logging table would contain the following fields : an identity column, the table creator, the table name, the column n
DB2 Basics: How to get useful information from the DB2 UDB system catalog
(Roman B. Melnyk) IBM DB2 Universal Database (UDB) maintains a set of special tables called the system catalog. These tables, which contain the metadata that describes database objects, have two sets of views defined on them: read-only views under the SYSCAT schema and updatable views under the SYSS
How Suite It Is
(Timothy Hahn) Using on demand environments to make their services more available requires businesses to coordinate systems management. IBM* Tivoli* Security product suite is designed to help enhance perimeter-defense monitoring and reaction, centralize access-control policy administration, coordina
IBM’s autonomic database poised to impact SA skills shortage
The launch of the latest version of IBM’s DB2 Universal Database, code-named Stinger, is set to have a major positive impact on the shortage of database administration skills in South Africa. DB2 is the industry’s first autonomic database software solution, enabling it to automatically self-manage a
Active Server Pages with ODBC driver for DB2 creates more than 7,000 threads
Microsoft Internet Information Server (IIS) enters a recursive loop and creates more than 7,000 threads under the following circumstances: • A Microsoft Active Server Pages (ASP) program uses ActiveX Data Objects (ADO) and Microsoft ODBC Driver for DB2 to retrieve data. -and- • The ASP pag
Database Performance Tuning on AIX
(Budi Darmawan, Gary Groenewald, Allan Irving, Sergio Henrique Soares Monteiro and Keirnan M. Snedeker) This IBM Redbook is designed to help system designers, system administrators, and database administrators design, size, implement, maintain, monitor, and tune a Relational Database Management Syst
Double Take
(Paul C. Zikopoulos) When IBM donated the code for its Cloudscape database software to the open source community last summer, the press and the developer community took notice. It’s easy to see why. At the same time it released a technology preview of the commercial offering, called Cloudscape v
DB2 II: Performance Monitoring, Tuning and Capacity Planning Guide
(Nagraj Alur) This IBM Redbook provides an overview of DB2 Information Integrator V8.2 key performance drivers; best practices to achieve optimal performance; and guidelines for monitoring a DB2 Information Integrator environment for capacity planning, problem diagnosis, and problem resolution.
Managing Engineering Information
(Chris Randles) It’s virtually axiomatic: technology innovations first boost personal productivity then group productivity. The PC, for example, first helped individuals automate writing, accounting and personal organization functions, then spawned group productivity through networks, the Internet a