Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57

    Unanswered: SQL0104N Error while setting table space containers

    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
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    the size is not specified
    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

  3. #3
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57
    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)"
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by singhipst View Post
    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...

  5. #5
    Join Date
    Apr 2010
    Location
    USA
    Posts
    10
    It is the string ")" ,try mask ")"

Posting Permissions

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