Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: Create Tablespace error

    I am using DB2 v9.1 FP12 and am trying to create some tablespaces in one instance from another based on the output from db2look.

    This is the command syntax:

    CREATE REGULAR TABLESPACE "ASCTLTSP" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM using /db2webt/intralnk/asctltsp
    EXTENTSIZE 32
    PREFETCHSIZE 32
    BUFFERPOOL IBMDEFAULTBP
    OVERHEAD 24.100000
    TRANSFERRATE 0.900000
    FILE SYSTEM CACHING
    DROPPED TABLE RECOVERY OFF;

    This is the error:

    CREATE REGULAR TABLESPACE "ASCTLTSP" IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY SYSTEM using /db2webt/intralnk/asctltsp EXTENTSI
    ZE 32 PREFETCHSIZE 32 BUFFERPOOL IBMDEFAULTBP OVERHEAD 24.100000 TRANSFERRATE 0.900000 FILE SYSTEM CACHING DROPPED TABLE RECOVERY OFF
    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 "/db2webt/intralnk/asctltsp" was found following
    "AGED BY SYSTEM using". Expected tokens may include:
    "<sms_container_clause>". SQLSTATE=42601

    Not sure what I am doing wrong but I have been away from DB2 for quite some time now and would appreciate the help if possible

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    .. USING ('/home/db2inst1/db2inst1/NODE0000/SQL00007/wrapper1')..
    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

Posting Permissions

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