Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Conflicting tablespace size 128 and 18 in same database

30 views
Skip to first unread message

Sivaswami Jeganathan

unread,
Oct 4, 2009, 7:22:56 AM10/4/09
to
C:\Documents and Settings\Administrator>db2 create tablespace
testspace_11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111
pagesize 8K
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0107N The name
"testspace_11111111111111111111111111111111111111111111111111111111"
is too
long. The maximum length is "128". SQLSTATE=42622

C:\Documents and Settings\Administrator>db2 create tablespace
testspace_11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111
pagesize 8K
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0107N The name
"TESTSPACE_111111111111111111111111111111111111111111111111111111111"
is too
long. The maximum length is "18". SQLSTATE=42622

C:\Documents and Settings\Administrator>db2 create tablespace
testspace_111111111111111111111111111111111111111111111111111111111111111111111111111
pagesize 8K
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0107N The name
"TESTSPACE_111111111111111111111111111111111111111111111111111111111"
is too
long. The maximum length is "18". SQLSTATE=42622

hsn_

unread,
Dec 2, 2009, 5:43:12 PM12/2/09
to
> C:\Documents and Settings\Administrator>db2 create tablespace
> testspace_11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111
> pagesize 8K
> DB21034E  The command was processed as an SQL statement because it was
> not a
> valid Command Line Processor command.  During SQL processing it
> returned:
> SQL0107N  The name
> "testspace_11111111111111111111111111111111111111111111111111111111"
> is too
> long.  The maximum length is "128"  SQLSTATE=42622

in 9.7.1 all reported max length are 128

0 new messages