Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: Alter Tablespace problem

    Hi

    I have installed the ECC 5.0 on db2 8.2 with fixpack 12 on AIX 5.3

    Tablespace is full for EL640D

    I have a problem in adding the container to table in db2

    due to this I am not able to execute any trasaction.

    Please help me to add the containter

    Regards
    sija
    Last edited by sija; 10-26-06 at 01:28.

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    ts

    what is the command and which is the error you get ?
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Sep 2006
    Posts
    2
    Hi, Guy
    I am getting below error through GUI

    Database error text........: "SQL0289N Unable to allocate new pages in table
    space "MSD#EL640D". SQLSTATE=57011 row=1"
    Triggering SQL statement...: "SAPLSDB6CCMS "
    Internal call code.........: "[REPO/*/CLBW/LOAD/SAPLSDB6CCMS ]"


    I am trying to add the container using below command at OS level after login using user ID db2sid

    "ALTER TABLESPACE MSD#EL640D ADD TO STRIPE SET 0 {FILE '/db2/MSD/sapdata6/NODE0000/MSD#EL640D.container001' 167936 K} ON PARTITIONNUM (0)"

    I am not able to execute this command at OS Level and tryed to execute the same connecting to DB2. But no luck.

    Regards
    Mohan

  4. #4
    Join Date
    Jun 2006
    Posts
    471

    ts

    anyhow : the syntax is NOT correct
    "ALTER TABLESPACE MSD#EL640D ADD TO STRIPE SET 0 {FILE '/db2/MSD/sapdata6/NODE0000/MSD#EL640D.container001' 167936 K} ON PARTITIONNUM (0)"
    it should be :
    "ALTER TABLESPACE MSD#EL640D ADD TO STRIPE SET 0 (FILE '/db2/MSD/sapdata6/NODE0000/MSD#EL640D.container001' 167936 K) ON PARTITIONNUM (0)"

    where the { becomes a ( and } becomes )
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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