IBM Support

IT23804: DB2 RESTORE MAY FAIL WITH ZRC=0X85020024=-2063466460=SQLB_TBLSPC_MAPS_TOO_BIG "MAP TOO BIG"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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 : <preformatted>
    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 : <preformatted>
    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)
    

Local fix

  • 1. Perform a redirected restore to reduce the number of
    containers for a tablespace
    
    
    ( 48 + ( NumContainers - 1 ) * 4 ) * 48 + 4096 <= 48KB (49152
    Bytes)
    
    So in this case = (48 + (231-1)*4 )*48+4096 = 50560 > 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.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23804

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-22

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

  • APAR is sysrouted FROM one or more of the following:

    IT23803

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
27 November 2018