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

BACKUP DB COMMAND RETURNS A BLANK IN SQLSTATE IN SQLCA STRUCTURE

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
The backup db command returns a blank in sqlstate in sqlca 
structure as below. 
  And it can be a workaround to check "sqlcode" value instead of 
"sqlstate" in SQLCA in order to verify if the backup database 
operation ends successfully or not. 
 
$ db2 -a backup database TESTDB 
Backup successful. The timestamp for this backup image is 
:     20090916090620 
 
SQLCA Information 
 
sqlcaid : SQLCA     sqlcabc: 136   sqlcode: 0   sqlerrml: 0 
sqlerrmc: 
sqlerrp : SQL09053 
sqlerrd : (1) 0         (2) 0      (3) 0 
          (4) 0         (5) 0      (6) 0 
sqlwarn : (1)    (2)     (3)      (4)       (5)   (6) 
          (7)    (8)     (9)      (10)      (11) 
sqlstate:
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Backup db command returns a blank in sqlstate in             * 
* sqlcastructure.                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.5 FixPak 6                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.5 FixPak 6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC63579 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
06.10.2009
24.06.2010
24.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.
Problem behoben lt. FixList in der Version