IBM Mainframe Forum Index
Log In
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message

New User

Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Sun Nov 05, 2023 12:20 am
Reply with quote


I have a table with numpart 5.Below is the display from CA RC QUERY:

part l imitkey logical part
1 2023-6-30 1------oldest month
2 2023-7-31 2------oldest month
3 2023-8-31 3
4 2023-9-30 4
5 2023-10-31 5

I want the first two partitions(oldest months)to be removed,as well as to add two new partition/limitkey appearing at bottom. Expecting to look like the below:

After "ALTER TABLE ADD PART" executed:

part limitkey logical part
1 2023-8-31 1
2 2023-9-30 2
3 2023-10-31 3
4 2023-11-30 4------newly added
5 2023-12-31 5-------newly added

Is it possible to drop first two partition(6th & 7th month)from pbr table? If "YES" ,how can I change logical/physical part to be in sequence -1,2,3,.....after oldest partition gets deleted?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2


Similar Topics
Topic Forum Replies
No new posts Rotate partition-logical & physic... DB2 0
No new posts Alter User LOGON Script Parameters CLIST & REXX 11
No new posts VSAM Alter Command - Cylinder Extent ... JCL & VSAM 3
No new posts DB2 - row_number function - Need 1st ... DB2 5
No new posts OUTREC with ALter Command DFSORT/ICETOOL 1
Search our Forums:

Back to Top