You can download IBM's DB2 run-time client here:

http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html

The run-time client includes the DB2 ODBC driver.

If the DB2 database is on z/OS or AS/400, you'll need to use DB2 Connect...

You can only change the PHYSICAL file name using restore with move option.

Use this to change the LOGICAL file name:

ALTER DATABASE <db_name> MODIFY FILE (NAME = current_name_Data, NEWNAME = new_name_Data)

Since each varchar column requires an additional 2 bytes to store the column length, I would recommend using char on any column that has a maximum length of 2 bytes or...

This KB article applies to Windows service packs.  However, you only need to apply SQL Server service packs on one cluster node.

If you log on to the virtual server and install SP4, it will be installed onto both cluster nodes...you don't have it install it on each node.

or try this:

ALTER DATABASE <db_name> SET OFFLINE WITH ROLLBACK IMMEDIATE

I'm guessing that the maintenance plan job is failing when it attempts to put the database into single-user mode and is unable to because there are database connections.

If you have...

The base table names are sysibm.systables and sysibm.syscolumns, but IBM recommends you use the catalog views - syscat.tables and syscat.columns.

You should be able to use DBCC UPDATEUSAGE WITH COUNT_ROWS to update the row count in the sysindexes table.

try this:

SELECT convert(char(20),serverproperty('productversion')) Version, convert(char(20),serverproperty('productlevel')) ProductLevel, convert(char(25),serverproperty('edition')) Edition

Did you update statistics (exec sp_updatestats) after migrating the database?

sounds like you have the "auto close" database option set. With this option set, anytime the database is used, you will see this message in the SQL Server log.

...