368 IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
IBMCATGROUP 3
IBMDEFAULTGROUP 303
TSNAME UPDATES INSERTS DELETES
-------------------------- ------- ------- -------
SMSDAT1 303
SYSCATSPACE 3
TABLE UPDATES INSERTS DELETES
-------------------------- ------- ------- -------
SYSIBM.SYSTABLES 3
VPS.CAR 303
TOTAL SUMMARY
-------------
TOTAL UPDATES : 3
TOTAL INSERTS : 0
TOTAL DELETES : 303
******************************** BOTTOM OF DATA
********************************
B.2 Excerpt of detailed report created by db2la
Example B-2 is an excerpt from the detailed report that was created by the db2la
command.
Example: B-2 Excerpt from the detailed report
DB2 LOG ANALYSIS - DETAILED REPORT
BUILT ON 2005/09/29 AT 16:41:07
*********************************
BASED ON PREVIOUSLY BUILT GENERAL REPORT
ADDITIONAL FILTERS
------------------
DATABASE : VPS
START DATE : 2005/09/29
START TIME : 00:00:00
END DATE : 2005/09/30
END TIME : 00:00:00
ACTION : U I D
TABLENAME : CAR
OPTIONS :
---------------------------------------------------------------------------
Appendix B. Log Analysis reports 369
ACTION DATE TIME URID LSN STATUS AUTHID
------ ---------- -------- ------------ ------------ -------- ----------
DELETE 2005/09/29 16:07:35 0000000044BA 00000ABE0038 COMPLETE DB2INSK1
NGNAME TSNAME TABLE OWNER TABLE NAME
------------------ ------------------ ------------ -------------------
IBMDEFAULTGROUP SMSDAT1 VPS CAR
ROW STATUS T_ID T_TYPE T_MODEL T_YEAR T_COLOR T_PACKAGE T_AC T_POWERWINDOWS
T_AUTOMATIC T_DOORS T_PRICE T_DATA
----------- ---- ------ ------- ------ ------- ----------- ---- --------------
----------- ------- -------- ----------------
POST-CHANGE - - - - - - - -
- - - -
PRE-CHANGE 4440 Sedan Boran 1973 Green Performance N Y
N 3 62843.00 Needs a tune up.
---------------------------------------------------------------------------
ACTION DATE TIME URID LSN STATUS AUTHID
------ ---------- -------- ------------ ------------ -------- ----------
DELETE 2005/09/29 16:07:35 0000000044BA 00000ABE00FC COMPLETE DB2INSK1
NGNAME TSNAME TABLE OWNER TABLE NAME
------------------ ------------------ ------------ -------------------
IBMDEFAULTGROUP SMSDAT1 VPS CAR
ROW STATUS T_ID T_TYPE T_MODEL T_YEAR T_COLOR T_PACKAGE T_AC T_POWERWINDOWS
T_AUTOMATIC T_DOORS T_PRICE T_DATA
----------- ---- ------ ------- ------ ------- --------- ---- --------------
----------- ------- -------- ----------------
POST-CHANGE - - - - - - - - -
- - -
PRE-CHANGE 5032 Wagon Boran 1973 Purple Off-Road N N N
5 87786.00 Needs a tune up.
---------------------------------------------------------------------------
ACTION DATE TIME URID LSN STATUS AUTHID
------ ---------- -------- ------------ ------------ -------- ----------
DELETE 2005/09/29 16:07:35 0000000044BA 00000ABE01BE COMPLETE DB2INSK1
NGNAME TSNAME TABLE OWNER TABLE NAME
------------------ ------------------ ------------ -------------------
IBMDEFAULTGROUP SMSDAT1 VPS CAR
ROW STATUS T_ID T_TYPE T_MODEL T_YEAR T_COLOR T_PACKAGE T_AC T_POWERWINDOWS
T_AUTOMATIC T_DOORS T_PRICE T_DATA
Get IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
