Hi,
I am trying to create a table in db2 named "test".
The table contains the following information
Name (30 Characters)
Department (30 Characters)
Answer 1 to 30 (each 30 Characters)
Comments 1 to 30 (each 1000 Characters)
Here is the command
create table db2inst1.test (name varchar(30),email varchar(30),q1Answer varchar(30),q1Comment varchar(1000),q2Answer varchar(30),q2Comment varchar(1000),q3Answer varchar(30),q3Comment varchar(1000),q4Answer varchar(30),q4Comment varchar(1000),q5Answer varchar(30),q5Comment varchar(1000),q6Answer varchar(30),q6Comment varchar(1000),q7Answer varchar(30),q7Comment varchar(1000),q8Answer varchar(30),q8Comment varchar(1000),q9Answer varchar(30),q9Comment varchar(1000),q10Answer varchar(30),q10Comment varchar(1000),q11Answer varchar(30),q11Comment varchar(1000),q12Answer varchar(30),q12Comment varchar(1000),q13Answer varchar(30),q13Comment varchar(1000),q14Answer varchar(30),q14Comment varchar(1000),q15Answer varchar(30),q15Comment varchar(1000),q16Answer varchar(30),q16Comment varchar(1000),q17Answer varchar(30),q17Comment varchar(1000),q18Answer varchar(30),q18Comment varchar(1000),q19Answer varchar(30),q19Comment varchar(1000),q20Answer varchar(30),q20Comment varchar(1000),q21Answer varchar(30),q21Comment varchar(1000),q22Answer varchar(30),q22Comment varchar(1000),q23Answer varchar(30),q23Comment varchar(1000),q24Answer varchar(30),q24Comment varchar(1000),q25Answer varchar(30),q25Comment varchar(1000),q26Answer varchar(30),q26Comment varchar(1000),q27Answer varchar(30),q27Comment varchar(1000),q28Answer varchar(30),q28Comment varchar(1000),q29Answer varchar(30),q29Comment varchar(1000),q30Answer varchar(30),q30Comment varchar(1000));
but when I execute this command it throws the following error.
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.
SQLSTATE=42727
but if I reduce the column size to 1 & 100 respectively it works fine, the working command is shown below
create table db2inst1.test (name varchar(30),email varchar(30),q1Answer varchar(1),q1Comment varchar(100),q2Answer varchar(1),q2Comment varchar(100),q3Answer varchar(1),q3Comment varchar(100),q4Answer varchar(1),q4Comment varchar(100),q5Answer varchar(1),q5Comment varchar(100),q6Answer varchar(1),q6Comment varchar(100),q7Answer varchar(1),q7Comment varchar(100),q8Answer varchar(1),q8Comment varchar(100),q9Answer varchar(1),q9Comment varchar(100),q10Answer varchar(1),q10Comment varchar(100),q11Answer varchar(1),q11Comment varchar(100),q12Answer varchar(1),q12Comment varchar(100),q13Answer varchar(1),q13Comment varchar(100),q14Answer varchar(1),q14Comment varchar(100),q15Answer varchar(1),q15Comment varchar(100),q16Answer varchar(1),q16Comment varchar(100),q17Answer varchar(1),q17Comment varchar(100),q18Answer varchar(1),q18Comment varchar(100),q19Answer varchar(1),q19Comment varchar(100),q20Answer varchar(1),q20Comment varchar(100),q21Answer varchar(1),q21Comment varchar(100),q22Answer varchar(1),q22Comment varchar(100),q23Answer varchar(1),q23Comment varchar(100),q24Answer varchar(1),q24Comment varchar(100),q25Answer varchar(1),q25Comment varchar(100),q26Answer varchar(1),q26Comment varchar(100),q27Answer varchar(1),q27Comment varchar(100),q28Answer varchar(1),q28Comment varchar(100),q29Answer varchar(1),q29Comment varchar(100),q30Answer varchar(1),q30Comment varchar(100));
Here is a snapshot of the command line through DB2 Command Line Processor
==========================
==========
==========
==========
========
[db2inst1@test db2inst1]$ db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 SDK 8.2.0
You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd
For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.
To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
db2 => connect to pilot
Database Connection Information
Database server = DB2/LINUX390 8.2.0
SQL authorization ID = DB2INST1
Local database alias = PILOT
db2 => create table db2inst1.test (name varchar(30),email varchar(30),q1Answer varchar(30),q1Comment varchar(1000),q2Answer varchar(30),q2Comment varchar(1000),q3Answer varchar(30),q3Comment varchar(1000),q4Answer varchar(30),q4Comment varchar(1000),q5Answer varchar(30),q5Comment varchar(1000),q6Answer varchar(30),q6Comment varchar(1000),q7Answer varchar(30),q7Comment varchar(1000),q8Answer varchar(30),q8Comment varchar(1000),q9Answer varchar(30),q9Comment varchar(1000),q10Answer varchar(30),q10Comment varchar(1000),q11Answer varchar(30),q11Comment varchar(1000),q12Answer varchar(30),q12Comment varchar(1000),q13Answer varchar(30),q13Comment varchar(1000),q14Answer varchar(30),q14Comment varchar(1000),q15Answer varchar(30),q15Comment varchar(1000),q16Answer varchar(30),q16Comment varchar(1000),q17Answer varchar(30),q17Comment varchar(1000),q18Answer varchar(30),q18Comment varchar(1000),q19Answer varchar(30),q19Comment varchar(1000),q20Answer varchar(30),q20Comment varchar(1000),q21Answer varchar(30),q21Comment varchar(1000),q22Answer varchar(30),q22Comment varchar(1000),q23Answer varchar(30),q23Comment varchar(1000),q24Answer varchar(30),q24Comment varchar(1000),q25Answer varchar(30),q25Comment varchar(1000),q26Answer varchar(30),q26Comment varchar(1000),q27Answer varchar(30),q27Comment varchar(1000),q28Answer varchar(30),q28Comment varchar(1000),q29Answer varchar(30),q29Comment varchar(1000),q30Answer varchar(30),q30Comment varchar(1000))
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.
SQLSTATE=42727
db2 => create table db2inst1.test (name varchar(30),email varchar(30),q1Answer varchar(1),q1Comment varchar(100),q2Answer varchar(1),q2Comment varchar(100),q3Answer varchar(1),q3Comment varchar(100),q4Answer varchar(1),q4Comment varchar(100),q5Answer varchar(1),q5Comment varchar(100),q6Answer varchar(1),q6Comment varchar(100),q7Answer varchar(1),q7Comment varchar(100),q8Answer varchar(1),q8Comment varchar(100),q9Answer varchar(1),q9Comment varchar(100),q10Answer varchar(1),q10Comment varchar(100),q11Answer varchar(1),q11Comment varchar(100),q12Answer varchar(1),q12Comment varchar(100),q13Answer varchar(1),q13Comment varchar(100),q14Answer varchar(1),q14Comment varchar(100),q15Answer varchar(1),q15Comment varchar(100),q16Answer varchar(1),q16Comment varchar(100),q17Answer varchar(1),q17Comment varchar(100),q18Answer varchar(1),q18Comment varchar(100),q19Answer varchar(1),q19Comment varchar(100),q20Answer varchar(1),q20Comment varchar(100),q21Answer varchar(1),q21Comment varchar(100),q22Answer varchar(1),q22Comment varchar(100),q23Answer varchar(1),q23Comment varchar(100),q24Answer varchar(1),q24Comment varchar(100),q25Answer varchar(1),q25Comment varchar(100),q26Answer varchar(1),q26Comment varchar(100),q27Answer varchar(1),q27Comment varchar(100),q28Answer varchar(1),q28Comment varchar(100),q29Answer varchar(1),q29Comment varchar(100),q30Answer varchar(1),q30Comment varchar(100))
DB20000I The SQL command completed successfully.
db2 =>
==========================
==========
==========
==========
========
System Information:-
DB2 is running on Linux and the version is DB2 8.2.0
How can I create a table with the above information.
I would be happy even it allows me to create comments with 500 characters also instead of 1000 characters.
Any help is highly appreciated.
Start Free Trial
