db2

1. 
   

2. 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.

   Reply With Quote
3. 09-29-11, 04:22#2

   przytula_guy 

   Registered User
   

   Join Date

   Apr 2006

   Location

   Belgium

   Posts

   2,504

   Provided Answers: 10

   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
   http://www.infocura.be

   Reply With Quote
4. 
   
5. 
   
6. 
   
7. 09-29-11, 04:27#3

   seba.wagner 

   Registered User
   

   Join Date

   Sep 2011

   Posts

   2

   Thanks Guy,
   
   we will try on that one.
   
   Sebastian

   actually this is my error
    saneSqlExec] Executing resource: C:\opt\repository\scripts\EFrame_TableChanges.sql
   [saneSqlExec] Failed to execute:  CREATE TABLE YFS_PAYMENT ( PAYMENT_KEY CHAR (24)  DEFAULT ' '  NOT NULL ,ORDER_HEADER_KEY CHAR (24)  DEFAULT ' '  NOT NULL ,PAYMENT_TYPE VARCHAR (20)  DEFAULT ' '  NOT NULL ,BILL_TO_KEY CHAR (24)  DEFAULT ' '  NOT NULL ,CHARGE_SEQUENCE INTEGER  DEFAULT 0  NOT NULL ,CUSTOMER_ACCOUNT_NO VARCHAR (40) ,DISPLAY_CUST_ACCT_NO CHAR (4)  DEFAULT ' '  NOT NULL ,CUSTOMER_PO_NO VARCHAR (100)  DEFAULT ' '  NOT NULL ,CREDIT_CARD_TYPE VARCHAR (32)  DEFAULT ' '  NOT NULL ,CREDIT_CARD_NAME VARCHAR (300)  DEFAULT ' '  NOT NULL ,FIRST_NAME VARCHAR (300) ,MIDDLE_NAME VARCHAR (300) ,LAST_NAME VARCHAR (300) ,CREDIT_CARD_NO VARCHAR (1000) ,DISPLAY_CREDIT_CARD_NO CHAR (4)  DEFAULT ' '  NOT NULL ,CREDIT_CARD_EXP_DATE VARCHAR (30)  DEFAULT ' '  NOT NULL ,SVC_NO VARCHAR (1000) ,DISPLAY_SVC_NO CHAR (4)  DEFAULT ' '  NOT NULL ,DEBIT_CARD_NO VARCHAR (1000) ,DISPLAY_DEBIT_CARD_NO CHAR (4) ,PAYMENT_REFERENCE1 VARCHAR (100)  DEFAULT ' '  NOT NULL ,PAYMENT_REFERENCE2 VARCHAR (100)  DEFAULT ' '  NOT NULL ,PAYMENT_REFERENCE3 VARCHAR (100)  DEFAULT ' '  NOT NULL ,DISPLAY_PAYMENT_REF1 CHAR (4)  DEFAULT ' '  NOT NULL ,CHEQUE_NO VARCHAR (100)  DEFAULT ' '  NOT NULL ,CHEQUE_REFERENCE VARCHAR (100)  DEFAULT ' '  NOT NULL ,EXTENDED_FLAG CHAR (1)  DEFAULT ' '  NOT NULL ,PAY_METHOD_OVERRIDE CHAR (1)  DEFAULT ' '  NOT NULL ,MAX_CHARGE_LIMIT DECIMAL (15,2)  DEFAULT 0  NOT NULL ,TOTAL_AUTHORIZED DECIMAL (15,2)  DEFAULT 0  NOT NULL ,TOTAL_CHARGED DECIMAL (15,2)  DEFAULT 0  NOT NULL ,REQUESTED_AUTH_AMOUNT DECIMAL (15,2)  DEFAULT 0  NOT NULL ,REQUESTED_CHARGE_AMOUNT DECIMAL (15,2)  DEFAULT 0  NOT NULL ,REQUESTED_REFUND_AMOUNT DECIMAL (15,2) ,TOTAL_REFUNDED_AMOUNT DECIMAL (15,2)  DEFAULT 0  NOT NULL ,TOTAL_ALT_REFUNDED_AMOUNT DECIMAL (15,2)  DEFAULT 0  NOT NULL ,INCOMPLETE_PAYMENT_TYPE CHAR (1)  DEFAULT ' '  NOT NULL ,SUSPEND_ANY_MORE_CHARGES CHAR (1)  DEFAULT ' '  NOT NULL ,PLANNED_REFUND_AMOUNT DECIMAL (15,2) ,UNLIMITED_CHARGES CHAR (1)  DEFAULT ' '  NOT NULL ,CASH_BACK_AMOUNT DECIMAL (15,2) ,PAYMENT_REFERENCE4 VARCHAR (100) ,PAYMENT_REFERENCE5 VARCHAR (100) ,PAYMENT_REFERENCE6 VARCHAR (100) ,PAYMENT_REFERENCE7 VARCHAR (100) ,PAYMENT_REFERENCE8 VARCHAR (100) ,PAYMENT_REFERENCE9 VARCHAR (100) ,CREATETS TIMESTAMP  DEFAULT CURRENT TIMESTAMP  NOT NULL ,MODIFYTS TIMESTAMP  DEFAULT CURRENT TIMESTAMP  NOT NULL ,CREATEUSERID VARCHAR (40)  DEFAULT ' '  NOT NULL ,MODIFYUSERID VARCHAR (40)  DEFAULT ' '  NOT NULL ,CREATEPROGID VARCHAR (40)  DEFAULT ' '  NOT NULL ,MODIFYPROGID VARCHAR (40)  DEFAULT ' '  NOT NULL ,LOCKID INTEGER  DEFAULT 0  NOT NULL ) 
   C:\opt\properties\entityDeployer.xml:881: The following error occurred while executing this line:
   C:\opt\properties\entityDeployer.xml:861: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;DB2ADMIN, DRIVER=4.13.80
   at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:497)
   at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:401)