home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC77859 Status: Geschlossen

SQL0501N ENCOUNTERED WHEN EVMON_FORMAT_UE_TO_TABLES IS EXECUTED AGAINST A
VERY LARGE UNFORMATTED EVENT TABLE.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
You may encounter SQL0501N when executing 
EVMON_FORMAT_UE_TO_TABLES in parallel through multiple sessions 
(each on a different data set) of a very large unformatted event 
table. 
 
$ db2 -stvf session1.sh 
call EVMON_FORMAT_UE_TO_TABLES ( 'UOW', NULL, NULL, NULL, NULL, 
NULL, NULL, 10000, 'SELECT * FROM EVMON.UOWEVENTS WHERE 
event_timestamp > ''2011-07-01-17.53.00.000000'' and 
event_timestamp <=''2011-07-01-17.53.05.000000''') 
 
$ db2 -stvf session2.sh 
call EVMON_FORMAT_UE_TO_TABLES ( 'UOW', NULL, NULL, NULL, NULL, 
NULL, NULL, 10000, 'SELECT * FROM EVMON.UOWEVENTS WHERE 
event_timestamp >''2011-07-01-17.53.05.000000'' and 
event_timestamp <=''2011-07-01-17.53.10.000000''') 
SQL0501N  The cursor specified in a FETCH statement or CLOSE 
statement is not 
open or a cursor variable in a cursor scalar function reference 
is not open.SQLSTATE=24501
Problem-Zusammenfassung:
You may encounter SQL0501N when executing 
EVMON_FORMAT_UE_TO_TABLES in parallel through multiple sessions 
(each on a different data set) of a very large unformatted event 
table. 
 
$ db2 -stvf session1.sh 
call EVMON_FORMAT_UE_TO_TABLES ( 'UOW', NULL, NULL, NULL, NULL, 
NULL, NULL, 10000, 'SELECT * FROM EVMON.UOWEVENTS WHERE 
event_timestamp > ''2011-07-01-17.53.00.000000'' and 
event_timestamp <=''2011-07-01-17.53.05.000000''') 
 
$ db2 -stvf session2.sh 
call EVMON_FORMAT_UE_TO_TABLES ( 'UOW', NULL, NULL, NULL, NULL, 
NULL, NULL, 10000, 'SELECT * FROM EVMON.UOWEVENTS WHERE 
event_timestamp >''2011-07-01-17.53.05.000000'' and 
event_timestamp <=''2011-07-01-17.53.10.000000''') 
SQL0501N The cursor specified in a FETCH statement or CLOSE 
statement is not 
open or a cursor variable in a cursor scalar function reference 
is not open.SQLSTATE=24501
Local-Fix:
Set LOCKTIMEOUT to -1, but this will slow down the execution.
verfügbare FixPacks:
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

Lösung
First fixed in DB2 Version 9.7 Fixpack 5.
Workaround
Set LOCKTIMEOUT to -1, but this will slow down the execution.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.08.2011
12.12.2011
12.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList