Is re-bind required after a column is resized?



IBM's flagship relational database management system

Is re-bind required after a column is resized?

Postby kerembenli76 » Thu Feb 14, 2013 5:35 pm

Hi,

i have DB2 table to which i added a new column as CHAR(01) instead of CHAR(02) by mistake, in PROD environment.

Now i want to increase the size of this column using ALTER command:
ALTER TABLE PXNA.XNA_TMFS_MAIN
ALTER COLUMN XNA_MFS_ACTIMIZE_STATU SET DATA TYPE CHAR(02);

The DCLGEN definition of the column is correct since it was migrated from TEST where the column size is already CHAR(02)
XNA_MFS_ACTIMIZE_STATU CHAR(2) NOT NULL,

My question is this:
1) This new field is referred just in 2 online programs. Are they to be re-bind in order to change take effect?

2) Also there are some other programs which are not referring to this new column (XNA_MFS_ACTIMIZE_STATU). Are they also have to be re-bind?
I didn't bind them after i inserted this column, so i don't think it is required after resize, either.. Can you please confirm?

Thanks for your precious replies in advance.
Kind regards.

Kerem
kerembenli76
 
Posts: 5
Joined: Mon Jan 30, 2012 9:09 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Is re-bind required after a column is resized?

Postby pmartyn » Fri Mar 29, 2013 11:08 pm

the rule of thumb is that if you make a structural change to a database, you need to rebind the programs that are going to use the change.

I hope this helps
pmartyn
 
Posts: 42
Joined: Thu Feb 28, 2013 7:11 pm
Has thanked: 5 times
Been thanked: 3 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post