Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

size of column and row in DB2

 
Mike Yu
Ranch Hand
Posts: 175
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have two questions about size of column and row in DB2:
(1) The maxiumn size of a column depends on the pagesize. For pagesize =4K, the maximun size of a varchar cloumn is 4000. Is the size of the Long Varchar column limited by the pagesize?
(2) In DB2 7.2, when I check the help for adding new column, it is said that I can add up to 500 columns, and the total size of the columns must not be gretaer than 4005. Is there a size limit for a entire row in a table? If so, how to calculate the size of a column with data type long varchar, timestamp, and so on.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic