Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC94545 Status: Geschlossen

IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT M
AY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Here you have an example of such behave. 
 
When one directly executes SQL statement in CLP: 
 
?db2 -v "select routineschema, routinename, specificname, 
fenced, owner, implementation, create_time, alter_time from 
syscat.routines order by routinename asc? 
 
time-out issue doesn't occur and statement returns some results, 
which is expected, but calling above command via user-specified 
profile(example below) won't return any results, and time-out 
appear. 
 
<COLLECTION> 
<NAME>USER SCRIPT: SQL TO RUN</NAME> 
<CMD>db2 -v "select routineschema, routinename, specificname, 
fenced, owner, implementation, create_time, alter_time from 
syscat.routines order by routinename asc" </CMD> 
<OUTFILE>outputFile</OUTFILE> 
<TIMEOUT>200</TIMEOUT> 
</COLLECTION> 
 
The issue is related to size of the output produces by CMD 
command.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* db2support users                                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Plese See Error Description.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Plese See Error Description.                                 * 
****************************************************************
Local-Fix:
N/A
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.08.2013
02.10.2013
02.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList
10.1.0.4 FixList