(Allan Tham) This guide is intended for a fast/easy migration of Content Manager version 8.2 from one Windows machine to the other. Screenshots for both step by step installation and migration are provided to ease the entire process.
Tag: IBM
Utility to generate DSN1COPY jobs using the REXX DB2 interface
(Jaiwant K Jonathan) DSN1COPY is an IBM utility that is very useful in recovering dropped tablespaces. When a tablespace is dropped, all references to it are removed from the catalog tables, including the SYSCOPY entries. However, if the DDL of the table, before it was dropped, is available, then, u
Its Not Fair! It’s Not a Level Playing Field for DB2 Backup and Recovery
(Jim Mulkey and Nancy Lilly) In the world of DB2 utilities, great emphasis is placed on the contrasts between one vendor’s performance benchmark and another’s performance benchmark. But benchmarks no longer tell the whole story. The requirements for backup and recovery, as well as the method us
When We Think That the Optimizer Doesn’t Get It Right
(Alexander Kuznetsov) IBM DB2 Universal Database comes with a very intelligent optimizer, yet sometimes its choices may seem off the mark. The optimizer, however complex it might be, is still a program. It processes input data, such as physical database structure and statistics, and generates execut
The Secret Texts of DB2 Connect
(Leon Katsnelson and Paul C. Zikopoulos) Much of the world’s data is managed on IBM* z/OS* and OS/390* servers running DB2* Universal Database* (UDB) (DB2 for z/OS) software. Several products that allow distributed applications to access DB2 for z/OS data typically provide one or more standard d
Risky Business, Part 1
(Dorian Pyle) Those who “learn” from the past may be condemned to faulty risk predictions. Risk is everywhere. Business risk takes many forms: risk of business failure, risk of lawsuits, risk of regulatory action, risk of disaster, and so on.
How is NULL internally stored in DB2?
(Craig Mullins) In DB2, a NULL is stored using a special one-byte null indicator that is “attached” to every nullable column. If the column is set to NULL, then the indicator field is used to record this. Using NULL will never save space in a DB2 database design – in fact, it will always add an extr
DB2 parallel operations and query performance
(Eric Garrigue Vesely) Parallelism can be employed in static and dynamic queries, local and remote data access, queries using single table scans and multi-table joins, access via an index or table scan, or list prefetch, sort, and inserts. Most parallel operations can be used on either partitioned o
IBM’s Stinger Pokes Holes in Oracle’s Open-Source and Grid Ambitions
(Lisa Vaas) IBM recently released the beta of “Stinger,” the next version of its DB2 database. With the move, IBM lobbed yet another volley in the battle over which major enterprise vendor will provide the database of choice for the open-source Linux operating system.
DB2 UDB Stinger Enhancements on Linux
(Rav Ahuja, Dan Behman and John Keenleyside) DB2 Stinger is the code name for an upcoming release of IBM DB2 Universal Database (DB2 UDB). DB2 Stinger includes exciting new features to improve application programmer productivity and lower total cost of ownership for our customers so that they can ga