Maximo Open Forum

how to alter table to add partition if the data already exists? in db2
#Administration
#Analytics
#Architecture
#Assets
#CivilInfrastructure
#Customizations
#EndUser
#EverythingMaximo
#HSE/OilandGas
#Infrastructure
#Integrations
#Inventory
#IoT
#LifeScience/Calibration
#Linear
#MaximoApplicationSuite
#MaximoForAviation
#MaximoUserGroups
#Mobility
#Nuclear
#Procurement
#Reporting
#Scheduling
#Security
#ServiceProvider
#Spatial
#Transportation
#Utilities
#WorkCenters
#WorkManagement

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

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

Original Message:
Sent: 10-12-2022 23:24
From: ilkadri il
Subject: alter table to add partition if the data already exists

how to alter table to add partition if the data already exists? in db2
#Administration
#Analytics
#Architecture
#Assets
#CivilInfrastructure
#Customizations
#EndUser
#EverythingMaximo
#HSE/OilandGas
#Infrastructure
#Integrations
#Inventory
#IoT
#LifeScience/Calibration
#Linear
#MaximoApplicationSuite
#MaximoForAviation
#MaximoUserGroups
#Mobility
#Nuclear
#Procurement
#Reporting
#Scheduling
#Security
#ServiceProvider
#Spatial
#Transportation
#Utilities
#WorkCenters
#WorkManagement

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

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:
Sent: 10-15-2022 06:40
From: Prashant Sharma
Subject: alter table to add partition if the data already exists

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

Original Message:
Sent: 10-12-2022 23:24
From: ilkadri il
Subject: alter table to add partition if the data already exists

how to alter table to add partition if the data already exists? in db2
#Administration
#Analytics
#Architecture
#Assets
#CivilInfrastructure
#Customizations
#EndUser
#EverythingMaximo
#HSE/OilandGas
#Infrastructure
#Integrations
#Inventory
#IoT
#LifeScience/Calibration
#Linear
#MaximoApplicationSuite
#MaximoForAviation
#MaximoUserGroups
#Mobility
#Nuclear
#Procurement
#Reporting
#Scheduling
#Security
#ServiceProvider
#Spatial
#Transportation
#Utilities
#WorkCenters
#WorkManagement

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

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:
Sent: 10-17-2022 07:50
From: ilkadri il
Subject: alter table to add partition if the data already exists

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:
Sent: 10-15-2022 06:40
From: Prashant Sharma
Subject: alter table to add partition if the data already exists

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

Original Message:
Sent: 10-12-2022 23:24
From: ilkadri il
Subject: alter table to add partition if the data already exists

how to alter table to add partition if the data already exists? in db2
#Administration
#Analytics
#Architecture
#Assets
#CivilInfrastructure
#Customizations
#EndUser
#EverythingMaximo
#HSE/OilandGas
#Infrastructure
#Integrations
#Inventory
#IoT
#LifeScience/Calibration
#Linear
#MaximoApplicationSuite
#MaximoForAviation
#MaximoUserGroups
#Mobility
#Nuclear
#Procurement
#Reporting
#Scheduling
#Security
#ServiceProvider
#Spatial
#Transportation
#Utilities
#WorkCenters
#WorkManagement

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

okay great, i will try. thanks for the answer!

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

Original Message:
Sent: 10-17-2022 10:07
From: Prashant Sharma
Subject: alter table to add partition if the data already exists

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:
Sent: 10-17-2022 07:50
From: ilkadri il
Subject: alter table to add partition if the data already exists

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:
Sent: 10-15-2022 06:40
From: Prashant Sharma
Subject: alter table to add partition if the data already exists

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

Original Message:
Sent: 10-12-2022 23:24
From: ilkadri il
Subject: alter table to add partition if the data already exists

how to alter table to add partition if the data already exists? in db2
#Administration
#Analytics
#Architecture
#Assets
#CivilInfrastructure
#Customizations
#EndUser
#EverythingMaximo
#HSE/OilandGas
#Infrastructure
#Integrations
#Inventory
#IoT
#LifeScience/Calibration
#Linear
#MaximoApplicationSuite
#MaximoForAviation
#MaximoUserGroups
#Mobility
#Nuclear
#Procurement
#Reporting
#Scheduling
#Security
#ServiceProvider
#Spatial
#Transportation
#Utilities
#WorkCenters
#WorkManagement

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