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: 2285
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
This topic is locked: you cannot edit posts or make replies. Limit access to certain RACF group cvnlynn CLIST & REXX 5 Wed Aug 23, 2017 2:28 am
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am
No new posts Finding IMS resource blocker after se... Hooman24 IMS DB/DC 1 Wed Aug 16, 2017 9:17 pm
No new posts BI,TO=ZD Changing Values Tyler Dunbar DFSORT/ICETOOL 4 Tue Jul 25, 2017 12:12 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am


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