|
Problem IT34100
|
Status: Closed |
REDIRECT RESTORE FAILS AFTER SET TABLESPACE CONTAINERS USING AUTOMATIC STORAGE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
A redirect restore can fail after running SET TABLESPACE
CONTAINERS USING AUTOMATIC STORAGE if the table space is already
an automatic storage table space, automatic resize is disabled,
and there are few free pages. SET TABLESPACE CONTAINERS USING
AUTOMATIC STORAGE will re-stripe containers over the assigned
storage group. If the storage group has been modified during the
redirect restore with SET STOGROUP PATHS such that more paths
are added than in the backup image, the automatic storage table
space will need to allocate an additional extent per new storage
path. This will cause the total size of the table space to grow,
which resize will disallow and prevent the restore from
succeeding. A message similar to the following will be found in
db2diag.log:
2020-08-20-07.05.14.323841-240 I133136E892 LEVEL: Warning
PID : 191974 TID : 140736834037504 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-33574 APPID: *LOCAL.db2inst1.200820110507
AUTHID : DB2INST1 HOSTNAME: test.ibm.com
EDUID : 30 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities,
sqludCheckRedirectedStatus, probe:1155
DATA #1 :
Insufficient space in tablespace SAMPLE_TS; you must have at
least 7872
usable pages. (The "usable pages" total does not include pages
used
internally by DB2, so the value specified on the SET TABLESPACE
CONTAINERS operation should be increased by one extent per
container.
Based on the latest SET TABLESPACE CONTAINERS values specified,
the
tablespace should have 8064 pages in total.)
Restore should allow the table space's total pages to grow in
this case as the usable page count (the table space's usable
space) is not growing, which adheres to automatic resize no. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* REDIRECT RESTORE FAILS AFTER SET TABLESPACE CONTAINERS USING *
* AUTOMATIC STORAGE *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* First fixed in v11.5 m4fp6 *
**************************************************************** |
| Local Fix: |
1) If doing a redirect restore for a table space which is
already an automatic storage table space, do not run the SET
TABLESPACE CONTAINERS USING AUTOMATIC STORAGE command. The table
space will automatically be striped across storage group's
paths, even if running SET STOGROUP PATHS.
2) Enable auto resize for table spaces prior to backup
3) Ensure there are sufficient free pages in each table space to
accommodate an extent per new storage path |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* REDIRECT RESTORE FAILS AFTER SET TABLESPACE CONTAINERS USING *
* AUTOMATIC STORAGE *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* First fixed in v11.5 m4fp6 *
**************************************************************** |
| Comment |
First fixed in v11.5 m4fp6 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.09.2020
18.06.2021
26.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
