ChannelDB2

March 2011 Blog Posts (2)

How to add IDENTITY column to existing table

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

Added by Radim Kolar on March 31, 2011 at 3:00pm — 2 Comments

Data Studio Health Monitor

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

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service