Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011

    Unanswered: SQL Error -286 while creating table

    What is wrong with this Create Statement?

    CREATE TABLE roomclient (roomclient_id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, avsettings VARCHAR(254), broadcast_id BIGINT, canDraw SMALLINT, chat_user_room_id BIGINT, connected_since TIMESTAMP, firstname VARCHAR(254), formated_date VARCHAR(254), isBroadcasting SMALLINT, is_chat_notification SMALLINT, is_mod SMALLINT,
    is_recording SMALLINT, language VARCHAR(254), last_login VARCHAR(254), lastname VARCHAR(254), mail VARCHAR(254), official_code VARCHAR(254), picture_uri VARCHAR(254), public_sid VARCHAR(254), room_enter TIMESTAMP, room_recording_name VARCHAR(254), room_id BIGINT, scope
    VARCHAR(254), streamid VARCHAR(254), swfurl VARCHAR(254), user_id BIGINT, usercolor VARCHAR(254), userip VARCHAR(254), username VARCHAR(254), userport INTEGER, userpos INTEGER, zombieCheckFlag SMALLINT, PRIMARY KEY (roomclient_id))

    The error is:
    Es konnte kein Standardtabellenbereich mit einer Seitengröße von mindestens "8192" gefunden werden, für den die Berechtigungs-ID "DB2ADMIN" eine Nutzungsberechtigung hat.. SQLCODE=-286, SQLSTATE=42727, DRIVER=3.62.56

    The SQL is produced by openJPA, our openJPA config looks like:
    db2_persistence.xml - openmeetings - Open-Source Web-Conferencing - Google Project Hosting

    Anybody an idea what the error 286 means or what is wrong with the create statement?
    Other tables are successfully created, it seems just this one fails constantly.

    Thank you very much.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    the pagesize of the tablespace is too small
    you need an 8k ts (and bufferpool and tempspace..)
    you can specify in create table ...... in tsname
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Sep 2011
    Thanks Guy,

    we will try on that one.


Posting Permissions

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