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) |
