166 IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
Useable pages = 97
Accessible = Yes
[db2insl1@lead db2insl1]$ db2 list tablespace containers for 4 show detail
Tablespace Containers for Tablespace 4
Container ID = 0
Name = /data1/newcartdb/DMS/space1
Type = File
Total pages = 25600
Useable pages = 25568
Accessible = Yes
Container ID = 1
Name = /data2/newcartdb/DMS/space2
Type = File
Total pages = 25600
Useable pages = 25568
Accessible = Yes
6.6 Point-in-time recovery with referential integrity and
DB2 Grouper
DB2 Recovery Expert V2 now has integration with the IBM DB2 Grouper
component. DB2 Grouper allows you to discover and define relationships
between database objects. DB2 RE can use this knowledge during recovery to
detect the relationships and to recover related objects automatically.
For information about how to install the DB2 Grouper component, see
Chapter 10, “Installing and using the DB2 Grouper component” on page 305.
While DB2 RE now provides a smoother recovery for related objects, it does not
free you completely from thinking about your recovery strategy. For example,
there might still be triggers in place that can be affected by running undo or redo
SQL. This section shows a simple scenario to introduce the mechanism for how
DB2 RE uses DB2 Grouper during a recovery.
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.
