How to Alter size of an existing Blob Column?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deepgun74@gmail.com - 07 Feb 2006 19:08 GMT

I have a blob column that is 4MB in length. I need to change it to
store a 3GIG binary.
1) What is the maximum size a BLOB column can support?
2) How do i alter the size of an existing BLOB column?
3) I have an another column that is of type LONG VARCHAR. I would like
to alter it to a CLOB as there is a size limit of 32KB on LONG VARCHAR.
What is the best way to approach this conversion?

Any help would be greatly appreciated.

Thanks,

Pradeep

Reply to this Message

Knut Stolze - 07 Feb 2006 21:35 GMT

> I have a blob column that is 4MB in length. I need to change it to
> store a 3GIG binary.

How about reading the manual as it explains which table alterations are
possible? http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp

> 1) What is the maximum size a BLOB column can support?

2GB: http://tinyurl.com/b4exa

> 2) How do i alter the size of an existing BLOB column?

Unfortunately, this can't be done. You have to add a new column with the
proper length restriction via ALTER TABLE: http://tinyurl.com/dfxna

> 3) I have an another column that is of type LONG VARCHAR. I would like
> to alter it to a CLOB as there is a size limit of 32KB on LONG VARCHAR.
> What is the best way to approach this conversion?

EXPORT + DROP TABLE + CREATE TABLE + IMPORT (see ALTER TABLE statement)

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Marco - 09 Feb 2006 09:00 GMT

Dear Knut,

as usual, almost every answer is written in the documentation... But,
since you're so smart answering unpolitely to easy questions, coming
from dummies, why don't you have a look to my thread?

http://groups.google.it/group/comp.databases.ibm-db2/browse_frm/thread/c8cf68f06
78a4f48

The IBM documentation is not as radical as the Bible is, most of the
times.

I will anyway appreciate your help, since a stable and clear solution
is quite mandatory, at this time.

Regards.

Reply to this Message