SQL0104N Error while setting table space containers

singhipst · #1 (**permalink**) 05-12-10, 01:35

Hi,

Can any one help me to find out the syntax issue in below command.

Code:

db2 "set tablespace containers for 4 using (FILE '/vol01/IBM/db2home/db2inst1/NODE0000/TEST/T0000004/TESTTBS_4K.dat')" 
SQL0104N An unexpected token ")" was found

przytula_guy · #2 (**permalink**) 05-12-10, 05:24

the size is not specified

singhipst · #3 (**permalink**) 05-12-10, 06:52

even i tried with size also when i specified size say 100M then it shows same error showiing 100M not expected.

Code:

db2 "set tablespace containers for 4 using (FILE '/vol01/IBM/db2home/db2inst1/NODE0000/TEST/T0000004/TESTTBS_4K.dat' 100M)"

n_i · #4 (**permalink**) 05-12-10, 08:47

Quote:

Originally Posted by singhipst

even i tried with size also when i specified size say 100M then it shows same error showiing 100M not expected.

May be this is a good time to look at the syntax diagram in the manual and check how exactly container size should be specified...

yyt030 · #5 (**permalink**) 05-12-10, 12:05

It is the string ")" ,try mask ")"

Internet Services

Web Development

Digital Marketing

Consumer Tech