DB2 - Problem description
Problem IC71202 | Status: Closed |
DAS SCHEDULER/TOOLSDB DOES NOT WORK WHEN DB2INSTDEF IS SET TO NON DEFAULT LOCATION | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Various errors may occur when using the DB2 Administration Server (DAS) on Windows Vista or Windows 7 and when the DB2INSTDEF db2set registry variable is set to a location other than the default location (C:\ProgramData\IBM\DB2\<copy name>). For example, when using the DB2 Task Scheduler from within the DB2 Control Center, the following error message could occur: SQL22221N The scheduler is not active. Reason code "1" Also, when trying to create and catalog the TOOLSDB, the following error message could occur: D:\>db2 create tools catalog SYSTOOLS CREATE NEW DATABASE TOOLSDB SQL22204N The DB2 Administration Server encountered a non-severe error while executing a request. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * This problem only applies to DB2 Windows running on Windows * * Vista/2008 or above. * **************************************************************** * PROBLEM DESCRIPTION: * * Various errors may occur when using the DB2 Administration * * Server (DAS) on Windows Vista or Windows 7 and when the * * DB2INSTDEF db2set registry variable is set to a location * * Upgrade product to DB2 v9.7, Fixpack 4. * **************************************************************** * RECOMMENDATION: * * Upgrade product to DB2 v9.7, Fixpack 4. * **************************************************************** PROBLEM CONCLUSION: Problem was first fixed in Version 9.7 Fix Pack 4 TEMPORARY FIX: Unset the DB2INSTDEF environment variable, so that the default Upgrade product to DB2 v9.7, Fixpack 4. | |
Local Fix: | |
Unset the DB2INSTDEF environment variable, so that the default location is used (C:\ProgramData\IBM\DB2\<copy name>). Stop and restart both the DAS and the DB2 instance after making the change. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.7 Fix Pack 4 | |
Workaround | |
Unset the DB2INSTDEF environment variable, so that the default location is used (C:\ProgramData\IBM\DB2\<copy name>). Stop and restart both the DAS and the DB2 instance after making the change. | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC72581 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.09.2010 24.05.2011 24.05.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |