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

setting new limit Key values for index controlled partition.

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

New User

Joined: 02 Apr 2009
Posts: 16
Location: chennai

PostPosted: Fri Feb 10, 2017 9:24 pm
Reply with quote

I am using db2 v7.I have a partitioned table which is index controlled.
Now I have to change the limit key values for the all partitions.
I think i have two options.As i dont have any tool which can do directly alter for me and create the required job itself, i am doing it manually !

1.alter the index , run reorg and runstats.
2.Unload the table,Drop.]]Then create the table with changed limit key values.Then load the table.

But i have dependent packages on the I am preferring for 1st option.But after alteration of index key values, Is it required to bind the package ?Or Rebind ?

Or it is better to go for 2nd option ?Here also I need to bind ?

My concern is about not to loose any Data and Packages.anyone please help.

Thanks in advance !
Back to top
View user's profile Send private message
Arun Raj


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Sat Feb 11, 2017 2:27 am
Reply with quote

At most of the shops I have worked with, activities such as ALTER/REBIND/DROP.. are performed/authorized in production only by/to the DBA group. Do you have such a team available? If yes, they should be able to assist depending on the volume of data/other parameters specific to your application.
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 Secondary index error while loading d... IMS DB/DC 2
No new posts DB2 - row_number function - Need 1st ... DB2 5
No new posts a copybook getting improper values in... COBOL Programming 7
No new posts Any limit on usage of cursors ? DB2 1
No new posts DSNTEP2 - setting exception DB2 2
Search our Forums:

Back to Top