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 IC98515 Status: Geschlossen

RUN NNSTAT FAILED WITH SQL0134N OR SQL1131N WHEN THERE IS AN INDEX INCLUDE
LOB TYPE COLUMN

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
You may meet SQL0134N or SQL1131N when running NNSTAT on an 
nickname with an index inlcude lob type column. 
Here is the reproducing SQLs: 
 
db2 => describe table n1 
 
                                Data type 
Column 
Column name                     schema    Data type name 
Length     Scale Nulls 
------------------------------- --------- ------------------- 
---------- ----- ------ 
C1                              SYSIBM    CLOB 
32768     0 Yes 
C2                              SYSIBM    CLOB 
2097088000     0 Yes 
C3                              SYSIBM    BLOB 
2097088000     0 Yes 
 
  3 record(s) selected. 
 
db2 => CALL SYSPROC.NNSTAT( 
'TERASERV','DB2INST1','N1','C1',NULL,2,'/tmp/log1.txt::DIAG',?) 
SQL1131N  A stored procedure process has been terminated 
abnormally. Routine 
name: "SYSPROC.NNSTAT". Specific name: "NNSTAT_EXTENDED". 
SQLSTATE=38503 
 
or 
 
db2 => CALL SYSPROC.NNSTAT( 
'TERASERV','DB2INST1','N1','C1',NULL,2,'/tmp/log1.txt::DIAG',?) 
SQL0134N  Improper use of a string column, host variable, 
constant, or 
function "COUNT".
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fix Pack 4.                              * 
****************************************************************
Local-Fix:
Use NNSTAT method 1
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 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:
30.12.2013
10.09.2014
10.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList