DB2 Backup Question - Post CMOD 9.0

[waytec]

Good morning all,

12/15/2013 we migrated from Windows CMOD MP 8.4.1 to CMOD MP 9.0.0.1(Windows 2008R2)and we have been running well until this past saturday 1/25/2013 where we completed this last phase of the migration, top off our TSM to 6.3.2.   Whoa!!!  Big difference.  TSM now controls the DB2 instances -- weird..  My problem is now that TSM 6.3.2 is the boss of DB2 we no longer have the luxury of using DB2 9.7 UDB's TOOLSDB functionality, according the TSM Support.  So how do I automate my DB2 Offline and Online backups?  I don't mind using a script kicked of with Windows ask Scheduler but the below scripts stops after opening the db2 command window.  Any idea's guys?


DB2CMD
DB2 CONNECT TO ARCHIVE
DB2 BACKUP DATABASE ARCHIVE ONLINE TO G:\OnlineDB2Backups WITH 3 BUFFERS BUFFER 1024 PARALLELISM 1 INCLUDE LOGS WITHOUT PROMPTING


 

[Alessandro Perucchi]

Hello waytec,

Wooow... stop... CMOD and TSM server in the same Windows box?

Because of TSM new architecture, you simply cannot have both on the same physical/virtual server anymore. You MUST separate them in separate servers.
Otherwise you happens to have this kind of problems.

This is very specific to Windows.

On Unix, there are tricks to allow having both server to coexists in the same server (even if this is not yet documented).

So my suggestion is ASAP to migrate TSM in another box, otherwise you'll have only problems, since this configuration is absolutely not supported.

Here is the link: http://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/topic/com.ibm.itsm.srv.install.doc/r_srv_knowfirst.html
And here is the excerpt :

WINDOWS: Restriction: You cannot install and run the Version 6.3 or later server on a system that already has DB2 installed on it, whether DB2 was installed by itself or as part of some other application. The Version 6.3 or later server requires the installation and use of the DB2 version that is packaged with the Version 6.3 or later server. No other version of DB2 can exist on the system.

Sincerely yours,
Alessandro

[Justin Derrick]

Yup, while it's possible to have TSM 6.3.x and CMOD 8.x or 9.x co-exist on the same system under the UNIX platforms (AIX, Solaris, Linux, etc.) Alessandro is right -- you can't do this in Windows.

-JD.

[waytec]

Thanks for the response guys.  IBM Professional Services actually performed the Migration for us.  You think they would have known not to do so.  Know we must battle to get IBM Services fix this mistake without charge.