|
Problem IC66013
|
Status: Closed |
THE ESTIMATED SIZE OF TABLESPACE LEVEL BACKUP IS CALCULATED FOR THE ENTIRE DATABASE INSTEAD OF THE GIVEN TABLESPACES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The "Estimated size of backup in bytes" in db2diag.log is
calculated based on the total size of database.
When the BACKUP command is run against one or more specific
tablespaces, this value supposed to be calculated based on the
size of selected tablespaces, instead of the entire database.
One example of db2diag.log could looks like the following
2010-01-14-22.01.09.802126-360 E36720A435 LEVEL: Info
PID : 2343156 TID : 1 PROC :
db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-387 APPID:
*LOCAL.db2inst1.100115040110
AUTHID : db2inst1
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl,
probe:1410
MESSAGE : Starting an online tablespace USERSPACE1...
backup.
2010-01-14-22.01.14.109346-360 E37156A446 LEVEL: Info
PID : 2343156 TID : 1 PROC :
db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-387 APPID:
*LOCAL.db2inst1.100115040110
AUTHID : db2inst1
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:842
MESSAGE : Estimated size of backup in bytes:
DATA #1 : unsigned integer, 8 bytes
411170349056
2010-01-14-22.01.14.109677-360 E37603A439 LEVEL: Info
PID : 2343156 TID : 1 PROC :
db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-387 APPID:
*LOCAL.db2inst1.100115040110
AUTHID : db2inst1
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:846
MESSAGE : Actual size of backup in bytes:
DATA #1 : unsigned integer, 8 bytes
61030400
2010-01-14-22.01.14.109907-360 E38043A379 LEVEL: Info
PID : 2343156 TID : 1 PROC :
db2agent (SAMPLE) 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-387 APPID:
*LOCAL.db2inst1.100115040110
AUTHID : db2inst1
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:852
MESSAGE : Backup complete. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* 2010-01-14-22.01.09.802126-360 E36720A435 LEVEL: Info *
* *
* PID : 2343156 TID : 1 PROC : *
* *
* db2agent (PENOMFP0) 0 *
* *
* INSTANCE: d2ipomp0 NODE : 000 DB : *
* PENOMFP0 *
* *
* APPHDL : 0-387 APPID: *
* *
* *LOCAL.d2ipomp0.100115040110 *
* *
* AUTHID : TWSPNDBM *
* *
* FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, *
* *
* probe:1410 *
* *
* MESSAGE : Starting an online tablespace *
* INF_D_PN_CNTR_IX04... *
* backup. *
* *
* *
* *
* 2010-01-14-22.01.14.109346-360 E37156A446 LEVEL: Info *
* *
* PID : 2343156 TID : 1 PROC : *
* *
* db2agent (PENOMFP0) 0 *
* *
* INSTANCE: d2ipomp0 NODE : 000 DB : *
* PENOMFP0 *
* *
* APPHDL : 0-387 APPID: *
* *
* *LOCAL.d2ipomp0.100115040110 *
* *
* AUTHID : TWSPNDBM *
* *
* FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:842 *
* *
* MESSAGE : Estimated size of backup in bytes: *
* *
* DATA #1 : unsigned integer, 8 bytes *
* *
* 411170349056 *
* *
* *
* *
* 2010-01-14-22.01.14.109677-360 E37603A439 LEVEL: Info *
* *
* PID : 2343156 TID : 1 PROC : *
* *
* db2agent (PENOMFP0) 0 *
* *
* INSTANCE: d2ipomp0 NODE : 000 DB : *
* PENOMFP0 *
* *
* APPHDL : 0-387 APPID: *
* *
* *LOCAL.d2ipomp0.100115040110 *
* *
* AUTHID : TWSPNDBM *
* *
* FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:846 *
* *
* MESSAGE : Actual size of backup in bytes: *
* *
* DATA #1 : unsigned integer, 8 bytes *
* *
* 61030400 *
* *
* *
* *
* 2010-01-14-22.01.14.109907-360 E38043A379 LEVEL: Info *
* *
* PID : 2343156 TID : 1 PROC : *
* *
* db2agent (PENOMFP0) 0 *
* *
* INSTANCE: d2ipomp0 NODE : 000 DB : *
* PENOMFP0 *
* *
* APPHDL : 0-387 APPID: *
* *
* *LOCAL.d2ipomp0.100115040110 *
* *
* AUTHID : TWSPNDBM *
* *
* FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:852 *
* *
* MESSAGE : Backup complete. *
****************************************************************
* RECOMMENDATION: *
* n/a *
**************************************************************** |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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
|
| Solution |
Problem is first fixed in Version 9.7 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.02.2010
23.09.2010
29.11.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
