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

DB2 upgrade may hit error SQL1762N even though there is sufficient disk
space for upgrade

Produkt:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problembeschreibung:
DB2 upgrade may hit error SQL1762N even though there is 
sufficient disk space for upgrade. 
 
   Here is the specific error message: 
   $ db2 upgrade database MYDB 
   SQL1762N Unable to connect to database because there is not 
enough 
   space to allocate active log files. SQLSTATE=08004 
 
The diaglog will show the following: 
 
 
 
2017-03-01-16.13.45.142221-420 I70744A944           LEVEL: Error 
PID     : 17367116             TID : 4628           PROC : 
db2sysc 0 
INSTANCE: tsminst1             NODE : 000           DB   : MYDB 
APPHDL  : 0-7                  APPID:  MYAPPID 
AUTHID  : MYAUTH             HOSTNAME: MYHOSTNAME 
EDUID   : 4628                 EDUNAME: db2agent (TSMDB1) 0 
FUNCTION: DB2 UDB, data protection services, sqlpgReallocLogs, 
probe:970 
MESSAGE : ZRC=0x85100084=-2062548860=SQLP_NO_SPACE_FOR_LOG 
          "Not enough space to create primary logs" 
DATA #1 : String, 37 bytes 
Log path / Re-Usable space (bytes) / 
DATA #2 : String, 48 bytes 
Free space (bytes) / Log space required (bytes): 
DATA #3 : String, 49 bytes 
/tsm/server/aLog1/IVTalog/NODE0000/LOGSTREAM0000/ 
DATA #4 : unsigned integer, 8 bytes 
537927680 
DATA #5 : unsigned integer, 8 bytes 
11259609088 
DATA #6 : unsigned integer, 8 bytes 
 
 
.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Fix Pack 1                               * 
****************************************************************
Local-Fix:
Add more disk space
verfügbare FixPacks:
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

Lösung
First Fixed in DB2 11.1 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
14.03.2017
09.05.2017
09.05.2017
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version