Db2

 View Only
Expand all | Collapse all

DB2 11.5 Developer-C : restore fails with "The total size of the table space is too big"

  • 1.  DB2 11.5 Developer-C : restore fails with "The total size of the table space is too big"

    Posted Wed November 20, 2019 11:02 AM
    Hi to all,

    In DB2 11.5 Developer-C edition, I need to restore a previosly created database (that I use as a prototype to start my guest).
    The newer limitation of database size is 100 GB is not reached because the database size I restore was so bigger (about 5GB).
    I've also try to cancel also DMS large tablespace that have parameters :
    AUTORESIZE YES
    MAXSIZE NONE
    They have transformed in AUTOMATIC STORAGE tablespaces.
    In detail : 
     [db2inst1@d833 ~]$ db2 RESTORE DATABASE COPIA833 FROM "/store2/backups/salva_Mon" ON "/store2/db2/DB_833" into db_833

     SQL1139N The total size of the table space is too big. SQLSTATE=54047

     [db2inst1@d833 ~]$

     [db2inst1@d833 ~]$ db2 connect to copia833

     Database Connection Information

     Database server = DB2/LINUXX8664 11.5.0.0

     SQL authorization ID = DB2INST1

     Local database alias = COPIA833

    [db2inst1@d833 ~]$ db2 "CALL GET_DBSIZE_INFO(?, ?, ?, -1)"

    Value of output parameters

     --------------------------

     Parameter Name : SNAPSHOTTIMESTAMP

     Parameter Value : 2019-11-20-15.32.56.784454

     Parameter Name : DATABASESIZE

     Parameter Value : 5083533312

     Parameter Name : DATABASECAPACITY

     Parameter Value : 591448993792

     Return Status = 0

    [db2inst1@d833 ~]$
    Someone has experienced this situation ?
    How can I solve this ?
    Note : if I use the trial license (that expire in 90 days), I can restore it well. Then, after the restore I will return to DEVELOPER-C free license.

    Thanks

    ------------------------------
    Adriano Mari
    ------------------------------

    #Db2


  • 2.  RE: DB2 11.5 Developer-C : restore fails with "The total size of the table space is too big"

    Posted Fri November 22, 2019 12:35 AM

    Hi Adriano,
    You probably wanted to post that in the Db2 community, not the Data Server Manager community.  But here is your answer:

    https://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1IT28320

    https://www-01.ibm.com/support/docview.wss?uid=swg1IT30796

    This is also present in 11.5.  Should be fixed in the next fixpack, but I don't know if Dev-C will get that.



    ------------------------------
    Luke Numrych
    ------------------------------

    Original Message


  • 3.  RE: DB2 11.5 Developer-C : restore fails with "The total size of the table space is too big"

    Posted Fri November 22, 2019 02:25 AM
    Yes ... i've probably do a mistake in the choice of group (i'm newer to community and I don't understand very well how we may move). I think that now is too late to change ..

    Thanks for the info about 11.1 same problem.
    I knew that the same issue was in 11.1 (that had been resolved with a newer fixpack, at the epoch).
    Also, we can avoid to try to transform in AUTOMATIC STORAGE (nor eliminate MAXSIZE NONE etc.).
    That don't works ...
    I have a novice. Yesterday, local IBM presales support, give me an update.
    The problem "The total size of the table space is too big" is well known by IBM DB2 group and we are proud to try the issue in the next fixpack (now Community edition has the ability to execute a fixpack without reinstalling it).

    I hope so, and, in the meantime, to overcome the problem, I done this :
    - remove the db2dec license
    - license a "trial license" (we are correct for 90 days ... but we use it for about 1 hour)
    - do a normal RESTORE
    - remove the "trial" and return to "db2dec" license
    We can do this because in the same pack of the community, now, we have various trial that can be activated without incurring in license problem has we respect firmly the license limit.

    Thanks to all

    ------------------------------
    Adriano Mari
    ------------------------------

    Original Message