Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Issues with tablespace

    Hi all,

    In our setup db2 V9.7 with fixpack 4

    Facing issues with tables..

    create the table using this DDL:
    =======================

    CREATE TABLE "db2STG"."TIS_DA_ALDIS_SPD_DATA" (
    "ROW_NBR" INTEGER NOT NULL,
    "SRC_FILE_NM" VARCHAR(50) NOT NULL,
    "DATA_SRC_CD" CHAR(5) NOT NULL,
    "ETL_BATCH_ID" CHAR(14) NOT NULL,
    "DATA_TYP" VARCHAR(500),
    "TIS_DATA_RQST_ID" VARCHAR(500),
    "SITE_XN_ROUTE_NBR" VARCHAR(500),
    "LOC_LEG_NBR" VARCHAR(500),
    "SRVY_DT" VARCHAR(500),
    "SRVY_TM" VARCHAR(500),
    "TRVL_SPD" VARCHAR(500),
    "VEH_LGTH" VARCHAR(500),
    "INS_TMS" TIMESTAMP NOT NULL,
    "INS_USR" VARCHAR(30) NOT NULL,
    "UPD_TMS" TIMESTAMP,
    "UPD_USR" VARCHAR(30)
    )
    DATA CAPTURE NONE
    IN "ALTIS_SPD_TAB"
    DISTRIBUTE BY HASH ("ROW_NBR", "SRC_FILE_NM", "DATA_SRC_CD")
    COMPRESS NO;

    ALTER TABLE "db2STG"."TIS_DA_ALDIS_SPD_DATA" ADD CONSTRAINT "TIS_DA_ALDIS_SPD_DATA_PK" PRIMARY KEY
    ("ROW_NBR",
    "SRC_FILE_NM",
    "DATA_SRC_CD");



    By using the tablespace "ALTIS_SPD_TAB"


    Issues:
    ======

    I generate the DDL but I won't the tablepace name?? But select the tablespace clause..


    Thanks,
    laxman..

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I am sorry, I do not understand your question. Can you rephrase it?

    Andy

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by laxman babu View Post

    I generate the DDL but I won't the tablepace name?? But select the tablespace clause..
    Please clarify. You don't find tablespace ALTIS_SPD_TAB in db2look output? Do you see it in the list tablespaces output? What options did you use to generate db2look?

Posting Permissions

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