Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    40

    Unanswered: Increasing tablespace in db2

    Hi all,

    My problem is, when I tried to compile 60 tables, I ended up not compiling 4 tables. Following error was thrown,

    Error Description : [IBM][CLI Driver][DB2/NT] SQL0286N A default table space could not be found with a page size of at least "8192" that authorization ID "ADMINISTRATOR" is authorized to use. SQLSTATE=42727.

    I want to increase the table space of a database. How can I do this?.

    As a update of my previous post, I use System Managed Storage for this tablespace.

    Thanks,
    Kamesh
    Last edited by BKamesh; 08-02-04 at 12:07.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Kamesh,
    Your problem is that you need to create another tablespace with an 8K pagesize. See thr CREATE TABLESPACE command.

    Andy

Posting Permissions

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