DB2 - Problem description
Problem IT23804 | Status: Closed |
DB2 RESTORE MAY FAIL WITH ZRC=0X85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "MAP TOO BIG" | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Restore Failed with below error: Backup from source server , restore on target (different ) server. db2 backup database SAMPLE online to /bb/data/db2/logs/SAMPLE.bkp PARALLELISM 4 compress db2 restore database SAMPLE from /bb/data/db2/logs/SAMPLE.bkp to /bb/db/db2/data001/db2inst1 newlogpath /bb/db/db2/activelog/db2inst1/sample without prompting 2017-11-13 00:20:25 - ERROR - (SAMPLE) Error, restore completed with warning SQL2563W The restore process completed successfully. However, one or more table spaces from the backup image were not restored., rc: 2 DB2 Restore may fail due to error - ZRC=0x85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "Map too big" Diaglog: 2017-11-11-13.17.43.277821-300 I30668E671 LEVEL: Severe PID : 1579292 TID : 140734166460160 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-9 APPID: *LOCAL.db2inst1.171111181737 AUTHID : DB2INST1 HOSTNAME: fillnjpfildb01 EDUID : 320 EDUNAME: db2bm.20.0 (SAMPLE) 0 FUNCTION: DB2 UDB, buffer pool services, sqlbSetPoolCont, probe:1360 MESSAGE : ZRC=0x85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "Map too big" DATA #1 : A severe error was encountered while trying to set new table space containers for table space SHEET_DATA_2 (28) 2017-11-11-13.17.43.280575-300 E31340E592 LEVEL: Error PID : 1579292 TID : 140734166460160 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-9 APPID: *LOCAL.db2inst1.171111181737 AUTHID : DB2INST1 HOSTNAME: fillnjpfildb01 EDUID : 320 EDUNAME: db2bm.20.0 (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqludProcessSPCS, probe:4610 DATA #1 : Problem restoring table space SHEET_DATA_2 (28). Function return code: 0, container return code = -2063466460. SQL0259N - Container map for table space is too complicated. Explanation The map structure keeps a record of how the table space address space is mapped to the various containers. If this gets too complicated, it does not fit in the table space file. User response The table space may need to be rebalanced to more evenly distribute the data among the containers. This may simplify the mapping. If this does not work, try making as many containers as possible the same size. Existing container sizes can be changed by backing up the table space and then using the database administration utility to change the containers. Restore the table space to the new containers. Tablespace map shows lot of stripe sets. Tablespace ID = 28 Tablespace Type = Database managed space Tablespace Content Type = All permanent data. Large table space. Tablespace Page size (bytes) = 4096 Tablespace Extent size (pages) = 32 Tablespace State = 0x'00000000' Detailed explanation: Normal Total number of pages = 2109078400 Number of free pages = 536325536 High water mark (pages) = 1931537536 Current tablespace size (bytes) = 8638785126400 Number of containers = 231 Table space map: Range Stripe Stripe Max Max Start End Adj. Containers Number Set Offset Extent Page Stripe Stripe [ 0] [ 0] 0 13437456 429998623 0 312498 0 43 (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,2 4,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42) [ 1] [ 1] 312499 14687452 469998495 312499 624997 0 4 (43,44,45,46) [ 2] [ 2] 624998 15937448 509998367 624998 937496 0 4 (47,48,49,50) [ 3] [ 3] 937497 16756644 536212639 937497 1142295 0 4 (51,52,53,54) [ 4] [ 4] 1142296 17575840 562426911 1142296 1347094 0 4 (55,56,57,58) [ 5] [ 5] 1347095 18395036 588641183 1347095 1551893 0 4 (59,60,61,62) [ 6] [ 6] 1551894 19214232 614855455 1551894 1756692 0 4 (63,64,65,66) [ 7] [ 7] 1756693 20033428 641069727 1756693 1961491 0 4 (67,68,69,70) [ 8] [ 8] 1961492 20852624 667283999 1961492 2166290 0 4 (71,72,73,74) [ 9] [ 9] 2166291 21671820 693498271 2166291 2371089 0 4 (75,76,77,78) [ 10] [ 10] 2371090 22491016 719712543 2371090 2575888 0 4 (79,80,81,82) [ 11] [ 11] 2575889 23310212 745926815 2575889 2780687 0 4 (83,84,85,86) [ 12] [ 12] 2780688 24129408 772141087 2780688 2985486 0 4 (87,88,89,90) [ 13] [ 13] 2985487 24948604 798355359 2985487 3190285 0 4 (91,92,93,94) [ 14] [ 14] 3190286 25767800 824569631 3190286 3395084 0 4 (95,96,97,98) [ 15] [ 15] 3395085 26586996 850783903 3395085 3599883 0 4 (99,100,101,102) [ 16] [ 16] 3599884 27406192 876998175 3599884 3804682 0 4 (103,104,105,106) [ 17] [ 17] 3804683 28225388 903212447 3804683 4009481 0 4 (107,108,109,110) [ 18] [ 18] 4009482 29044584 929426719 4009482 4214280 0 4 (111,112,113,114) [ 19] [ 19] 4214281 29863780 955640991 4214281 4419079 0 4 (115,116,117,118) [ 20] [ 20] 4419080 30682976 981855263 4419080 4623878 0 4 (119,120,121,122) [ 21] [ 21] 4623879 31502172 1008069535 4623879 4828677 0 4 (123,124,125,126) [ 22] [ 22] 4828678 32321368 1034283807 4828678 5033476 0 4 (127,128,129,130) [ 23] [ 23] 5033477 33140564 1060498079 5033477 5238275 0 4 (131,132,133,134) [ 24] [ 24] 5238276 33959760 1086712351 5238276 5443074 0 4 (135,136,137,138) [ 25] [ 25] 5443075 34778956 1112926623 5443075 5647873 0 4 (139,140,141,142) [ 26] [ 26] 5647874 35598152 1139140895 5647874 5852672 0 4 (143,144,145,146) [ 27] [ 27] 5852673 36417348 1165355167 5852673 6057471 0 4 (147,148,149,150) [ 28] [ 28] 6057472 37236544 1191569439 6057472 6262270 0 4 (151,152,153,154) [ 29] [ 29] 6262271 38055740 1217783711 6262271 6467069 0 4 (155,156,157,158) [ 30] [ 30] 6467070 38874936 1243997983 6467070 6671868 0 4 (159,160,161,162) [ 31] [ 31] 6671869 39694132 1270212255 6671869 6876667 0 4 (163,164,165,166) [ 32] [ 32] 6876668 41332528 1322640927 6876668 7286266 0 4 (167,168,169,170) [ 33] [ 33] 7286267 42970924 1375069599 7286267 7695865 0 4 (171,172,173,174) [ 34] [ 34] 7695866 44609320 1427498271 7695866 8105464 0 4 (175,176,177,178) [ 35] [ 35] 8105465 46247716 1479926943 8105465 8515063 0 4 (179,180,181,182) [ 36] [ 36] 8515064 47886112 1532355615 8515064 8924662 0 4 (183,184,185,186) [ 37] [ 37] 8924663 49524508 1584784287 8924663 9334261 0 4 (187,188,189,190) [ 38] [ 38] 9334262 51162904 1637212959 9334262 9743860 0 4 (191,192,193,194) [ 39] [ 39] 9743861 52801300 1689641631 9743861 10153459 0 4 (195,196,197,198) [ 40] [ 40] 10153460 54439696 1742070303 10153460 10563058 0 4 (199,200,201,202) [ 41] [ 41] 10563059 56078092 1794498975 10563059 10972657 0 4 (203,204,205,206) [ 42] [ 42] 10972658 57716488 1846927647 10972658 11382256 0 4 (207,208,209,210) [ 43] [ 43] 11382257 59354884 1899356319 11382257 11791855 0 4 (211,212,213,214) [ 44] [ 44] 11791856 60993280 1951784991 11791856 12201454 0 4 (215,216,217,218) [ 45] [ 45] 12201455 62631676 2004213663 12201455 12611053 0 4 (219,220,221,222) [ 46] [ 46] 12611054 64270072 2056642335 12611054 13020652 0 4 (223,224,225,226) [ 47] [ 47] 13020653 65908468 2109071007 13020653 13430251 0 4 (227,228,229,230) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher * **************************************************************** | |
Local Fix: | |
1. Perform a redirected restore to reduce the number of containers for a tablespace ( 48 + ( NumContainers - 1 ) * 4 ) * 48 + 4096 49152 hence it is failing. Reducing the containers to 215 then as per above calculation it will be 43392 which is less than 49152. 2.db2inidb mirror copy restore. 3. Other ways could be alter the tablespace in source database to lower high water mar followed by drop the containers and then let the rebalance of the containers complete. Then take that backup and use for restore. | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT23803 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.01.2018 27.11.2018 27.11.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |