DB2 alias change



IBM's flagship relational database management system

DB2 alias change

Postby p19689 » Thu Feb 28, 2013 2:59 pm

Hi, I'm planning to delete 2 aliases refering to a base table and then create those aliases as another 2 base tables(with the same alias names and the original base table structure but with slightly different index ) to avoid space and few other issues. I have the impression that this need not want any compilation or re-bind ? DB2 will do the automatic rebind when packages relevant to these new tables get executed . Can somone advise please ? Thanks in advance.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 alias change

 

Re: DB2 alias change

Postby GuyC » Thu Feb 28, 2013 5:55 pm

Yes, automatic rebind should solve this.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post