Search Options
Skip to main content (Press Enter).
Login/Sign Up
Skip auxiliary navigation (Press Enter).
Contact Us
Terms and Conditions
Getting Started on MORE
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Groups
Maximo Open Forum
MxLoader
Maximo Users Group
Third-Party Maximo Solutions
Maximo Business News
All Groups
Application Suite
Maximo Application Suite Info
Documentation
Maximo Resources
Browse
Maximo 7.6 Training
Discussion Posts
Library Entries
IBM Maximo Certifications
Functional Content
Participate
Invite
Getting Started on MORE
Help/FAQs
Answer a Question
Events
Groups
Discussion
Topic Thread
Maximo Open Forum
View Only
Community Home
Threads
2.7K
Library
80
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
alter table to add partition if the data already exists
ilkadri il
10-13-2022 00:07
how to alter table to add partition if the data already exists? in db2 #Administration #Analytics ...
Prashant Sharma
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 ...
ilkadri il
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 ...
Prashant Sharma
10-17-2022 10:07
450 Million in each table is huge data. Use of Achieving and Purging unnecessary old data will always ...
ilkadri il
10-18-2022 07:20
okay great, i will try. thanks for the answer! ------------------------------ ilkadri il icon+ ------------------------------ ...
1.
alter table to add partition if the data already exists
0
Recommend
ilkadri il
Posted 10-13-2022 00:07
Reply
Reply Privately
Options Dropdown
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+
------------------------------
2.
RE: alter table to add partition if the data already exists
0
Recommend
Maximo Certified
Prashant Sharma
Posted 10-15-2022 06:41
Reply
Reply Privately
Options Dropdown
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
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+
------------------------------
3.
RE: alter table to add partition if the data already exists
0
Recommend
ilkadri il
Posted 10-17-2022 08:38
Reply
Reply Privately
Options Dropdown
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
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+
------------------------------
4.
RE: alter table to add partition if the data already exists
0
Recommend
Maximo Certified
Prashant Sharma
Posted 10-17-2022 10:07
Reply
Reply Privately
Options Dropdown
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
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+
------------------------------
5.
RE: alter table to add partition if the data already exists
0
Recommend
ilkadri il
Posted 10-18-2022 07:20
Reply
Reply Privately
Options Dropdown
okay great, i will try. thanks for the answer!
------------------------------
ilkadri il
icon+
------------------------------
Original Message
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+
------------------------------
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
About
About MORE
What's Next for MORE?
Contact Us
Membership
Join Community
Invite Colleagues
Learn More
Get Started on MORE
Privacy & Terms
About Us
Terms of Use
Copyright 2020. All rights reserved.
Powered by Higher Logic