|
Problem IC64568
|
Status: Closed |
ADD ADDITIONAL DETAILS ABOUT LOAD UTILITY OPERATION TO THE LIST-HISTORY ENTRY. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Every time the Load utility is invoked, an entry is added to the
history file (which is available using the List History
operation).
The information contained in this entry only describes a few
aspects of the Load, and does not give any detailed information
about
what options the Load executed with.
The current output looks like:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log
Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
L T 20081005211209001 I S0000000.LOG S0000000.LOG
---------------------------------------------------------------
-------------
"DSCIARA2"."T1" resides in 1 tablespace(s):
00001 USERSPACE1
---------------------------------------------------------------
-------------
Comment: DB2
Start Time: 20081005211209
End Time: 20081005211211
Status: A
---------------------------------------------------------------
-------------
EID: 2 Location: /home/dsciaraf/myfile.del
This APAR addresses this lack of information by adding
additional information 'DDL:' token to the list-history output
that contains additional information about the Load.
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log
Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
L T 20081005211209001 I S0000000.LOG S0000000.LOG
---------------------------------------------------------------
-------------
"DSCIARA2"."T1" resides in 1 tablespace(s):
00001 USERSPACE1
---------------------------------------------------------------
-------------
Comment: DB2
Start Time: 20081005211209
End Time: 20081005211211
Status: A
---------------------------------------------------------------
-------------
EID: 2 Location: /home/dsciaraf/myfile.del
DDL: <update apar description to include sample of what this
line will actually look like> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* Every time the Load utility is invoked, an entry is added to *
* the *
* history file (which is available using the List History *
* *
* operation). *
* *
* The information contained in this entry only describes a few *
* *
* aspects of the Load, and does not give any detailed *
* information *
* about *
* *
* what options the Load executed with. *
* *
* *
* *
* The current output looks like: *
* *
* Op Obj Timestamp+Sequence Type Dev Earliest Log Current *
* Log *
* Backup ID *
* *
* -- --- ------------------ ---- --- ------------ ------------ *
* *
* -------------- *
* *
* L T 20081005211209001 I S0000000.LOG S0000000.LOG *
* --------------------------------------------------------------
* ------------- *
* *
* "DSCIARA2"."T1" resides in 1 tablespace(s): *
* *
* *
* *
* 00001 USERSPACE1 *
* *
* --------------------------------------------------------------
* ------------- *
* *
* Comment: DB2 *
* *
* Start Time: 20081005211209 *
* *
* End Time: 20081005211211 *
* *
* Status: A *
* *
* --------------------------------------------------------------
* ------------- *
* *
* EID: 2 Location: /home/dsciaraf/myfile.del *
* *
* *
* *
* This APAR addresses this lack of information by adding *
* *
* additional information 'DDL:' token to the list-history *
* output *
* that contains additional information about the Load. *
* *
* *
* *
* Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log *
* *
* Backup ID *
* *
* -- --- ------------------ ---- --- ------------ ------------ *
* *
* -------------- *
* *
* L T 20081005211209001 I S0000000.LOG S0000000.LOG *
* --------------------------------------------------------------
* ------------- *
* *
* "DSCIARA2"."T1" resides in 1 tablespace(s): *
* *
* *
* *
* 00001 USERSPACE1 *
* *
* --------------------------------------------------------------
* ------------- *
* *
* Comment: DB2 *
* *
* Start Time: 20081005211209 *
* *
* End Time: 20081005211211 *
* *
* Status: A *
* *
* --------------------------------------------------------------
* ------------- *
* *
* EID: 2 Location: /home/dsciaraf/myfile.del *
* *
* DDL: <update apar description to include sample of what *
* this *
* line will actually look like> *
****************************************************************
* RECOMMENDATION: *
* Ungrade to V9.7 Fixpack 2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in V9.7 Fixpack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.11.2009
15.06.2010
15.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
