Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Chennai, India

    Unanswered: Different page size table space in one database

    When creating a table with 20K size in a database having 4K size pages, get the following error.

    HTML Code:
    begin quote
    db2 "create table t(name varchar(20480))"
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0286N A default table space could not be found with a page size of at
    least "32768" that authorization ID "DB2INST1" is authorized to use.
    HTML Code:
    end quote
    Can I create a 32k page size tablespace and a corresponding buffer pool for this requirement? Does this have any impact on the performance of the database? What are the pros & cons of having different page size (4K, 8k, 32K) table spaces in a single database?


  2. #2
    Join Date
    Feb 2004

    Arrow Pagesize

    DB2 cannot divide records between pages, thus if you
    mant to create a varchar that big, you will have to create
    a tablespace with a pagesize larger than the maximum recordsize
    and put the table there.

    With characters that long, you migth want to look into the
    CLOB or long varchar data types.

    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts