Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC67303 Status: Closed

HANG WHEN SCHEDULING DB2 COMMAND SCRIPT THROUGH TASK CENTER

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Hang when scheduling DB2 command script in Task Center on 
Windows. 
 
For example the script which contains below lines hangs when 
executed using Task Center: 
 
db2 connect to sample 
db2 load from c:\load\table1.ixf of ixf .... 
... 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Task Center                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See ERROR DESCRIPTION.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 3.                                   * 
****************************************************************
Local Fix:
1) Place the commands into a DB2 script such as loadscript.db2 
 
loadscript.db2 
--------------- 
connect to sample; 
load from file of ixf ...; 
connect reset; 
 
2) Use the Windows Scheduler to schedule the script to be run.
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in v9.7 Fixpack 3.  At minimum this fix 
should be applied on the system where Task Center is running.
Workaround
See LOCAL FIX.
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC67355 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.03.2010
23.11.2010
23.11.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.