Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016
    Posts
    1

    Unanswered: Create LOB tablespace failed

    EDIT:
    DB2 LUW dont support the expression "LOB" it just work for z/OS.

    Sry for the stupid question ...



    Hallo togther,

    I'm not able to create LOB tablespaces for my tables

    db2 "CREATE LOB TABLESPACE LOB_TB IN MYDB LOG NO"

    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0104N An unexpected token "LOB" was found following "CREATE ". Expected
    tokens may include: "JOIN <joined_table>". SQLSTATE=42601

    DB2 Version:
    DB2 LUW v10.5.0.5 ESE



    see Example

    Any ideas for the error?

    Thanks in advance

    Kai
    Last edited by Kailo; 06-09-16 at 10:43. Reason: Solution

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Because it is not supported in DB2 for LUW.

    http://www.ibm.com/support/knowledge.../r0000929.html

    Andy

Tags for this Thread

Posting Permissions

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