Every DB2 admin discovers sooner or later that DB2 can not add identity column to existing table easily. Following statements fails due to syntax error: alter table public.clicks add column id integer generated always as identity
But i have good news for everyone. It can be still done, but it requires more steps.
1. Add not null integer column
You need to provide default value for it otherwise db2 will refuse it to make not…Continue
Data Studio product family (freeware database development/administration suite) has new member - Data Studio Health Monitor. This new product is replacement for Data Studio Administration Console and in DB2 10 LUW will probably replace builtin health monitor with db2 control center client.
Problem with DSAC was - big memory overhead on monitored database, not easy to setup due to numerous bugs and memory leaks after installation. On other end, it…Continue
Added by Radim Kolar on March 11, 2011 at 10:55am — No Comments