Marin Komadina

Database security is no longer something that should be implemented, but is something that every serious company must have, to bring a certain level of reassurance to their clients. A DB2 DBA should know what is going on in his database. In addition, he should have a log of actions performed inside the DB2 database, […]

As it was demonstrated in my last article, an error free DB2 V7 to V8 migration procedure is compromised of database software and catalog tables migration. The user data was not migrated, leaving the user tables and indexes intact. The series of post migration tests have been done prior to database handover to production. This […]

A long line of applying database FixPaks has ended with number 11, the last FixPak V7, and a brand new line has begun with DB2 V8. Currently, a total of six FixPaks have been released for DB2 V8. Consequently, support for DB2 V7 has come to an end. This event triggered many DBAs to begin […]

IBM has provided us with an automated installation process. As a result, many DBAs do not have any overview of where DB2 has stored important configuration information. The DB2 configuration files contain security setting parameters, system resource allocation, backup environment variables and DB2 instance configuration settings. In the event of even a small problem with […]

The time problem occupied my attention, during a recent recovery situation. On the SUN Solaris machine, the system time jumped forward unexpectedly. This situation raised questions about system and database time interaction, the time drift influence on the backup and recovery and many others. For example, what happens in complex multi-partition DB2 database environments with […]

As a final word about Tivoli Storage Manager (TSM) database backup, here are a few tips I have found working with the TSM system. Only the most interesting tips are included since presenting all of them would be beyond the scope of this article. This article covers: Tips Using TSM Conclusion Tips Using TSM Tip […]

In my last article "DB2 Database and Tivoli Storage Manager," we prepared an entire backup system for performing a first TSM database backup. This article examines the procedure for making a database backup using Tivoli Storage Manager, (TSM). This article covers: Performing Database Backup using TSM DB2 Backup Control DB2 Archive Logs Control Conclusion Performing […]

My first DB2 article, "Who needs incremental delta backup" published on January 29, 2003 was an introduction to the DB2 backup and recovery technology on the SUN Solaris platform. Since then, I have been asked many times to write on some very interesting topics that are not covered in detail in the existing IBM documentation. […]

Managing DB2 Fast Communication Manager In the last article, we discovered the DB2 instance memory structure and fast communication manager, together with all of the DBM parameters influencing memory utilization. In this article we we will continue along those lines with an inside view of FCM tuning and troubleshooting techniques for DB2 running on SUN […]

The process of tuning an ESE DB2 database is almost automatic, at least according to the DB2 manuals and Web announcements. However, much of this tuning still requires human intervention. The Fast Communication Manager is one of the components that need hand tuning. FCM is used to control the information flow between database partitions as […]

Oracle Soft and Bug Corruption One block is soft corrupted when a block format is different from the Oracle default block format. Oracle soft data corruption (logical, software) is usually detected while reading some data from the disk to the database buffer cache. In the buffer cache, Oracle kernel investigate block content, reading block information […]

Applying Security Restrictions to the Public The first recommendation for the PUBLIC is to revoke an IMPLICIT_SCHEMA privilege to protect flooding of the user schemas. This will prevent an unknown user from creating a schema, but still allow regular users to create a private schema with the same name as the name of user on […]