Maximo Open Forum

 View Only

Related Content

  • 1.  alter table to add partition if the data already exists



  • 2.  RE: alter table to add partition if the data already exists

    Posted 10-15-2022 06:41
    Add Partition and then move tables or indexes to that partition - 

    https://www.ibm.com/docs/en/db2/9.7?topic=ranges-adding-data-partitions

    Go to Maximo > database configuration > update tables's partition name on all tables which you have moved to newly created partition and then do ConfigDb.

    ------------------------------
    Prashant Sharma
    Sedin Technologies
    Connect with me @ https://www.linkedin.com/in/psharmamaximo/

    #IBM Champion 2022
    ------------------------------



  • 3.  RE: alter table to add partition if the data already exists

    Posted 10-17-2022 08:38
    great. thanks for the answer.

    I have the average data of 450 million rows on every table. If I move the table, it can make the transaction log database full. Is there any other solution?

    ------------------------------
    ilkadri il
    icon+
    ------------------------------

    Original Message


  • 4.  RE: alter table to add partition if the data already exists

    Posted 10-17-2022 10:07
    450 Million in each table is huge data. Use of Achieving and Purging unnecessary old data will always be recommended.

    Anyways you can refer to this and try after taking DB backup-

    https://www.ibm.com/support/pages/how-temporarily-turn-logging-operations-modifying-table

    ------------------------------
    Prashant Sharma
    Sedin Technologies
    Connect with me @ https://www.linkedin.com/in/psharmamaximo/

    #IBM Champion 2022
    ------------------------------

    Original Message


  • 5.  RE: alter table to add partition if the data already exists

    Posted 10-18-2022 07:20
    okay great, i will try. thanks for the answer!

    ------------------------------
    ilkadri il
    icon+
    ------------------------------

    Original Message