Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

setting new limit Key values for index controlled partition.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
srilata83

New User


Joined: 02 Apr 2009
Posts: 16
Location: chennai

PostPosted: Fri Feb 10, 2017 9:24 pm    Post subject: setting new limit Key values for index controlled partition.
Reply with quote

Hi,
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.
or
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 tables.so 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

Moderator


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

PostPosted: Sat Feb 11, 2017 2:27 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts Replacing same string with different ... vickey_dw DFSORT/ICETOOL 6 Wed Feb 22, 2017 10:44 pm
No new posts Limit CICS CPU resource vasanthz CICS 0 Tue Jan 31, 2017 7:09 am
No new posts Remove junk values in a file and rite... KP1125 DFSORT/ICETOOL 2 Wed Jan 25, 2017 9:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us