Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2013
    Posts
    2

    Unanswered: Temp Tablespace is getting full

    Hi all

    I am trying to update partitioned table in db2 v9.7 fp 3 using datastage


    ADM6017E The table space "TSTEMP_32" (ID "4") is full. Detected on
    container "/misnbtdb/temp/temp_32K" (ID "0"). The underlying file
    system is full or the maximum allowed space usage for the file system
    has been reached. It is also possible that there are user limits in
    place with respect to maximum file size and these limits have been
    reached.



    Any body have any idea . Why it is getting filled up ..

    it is consuming 105gb space and getting fail . On working envoirment it is consuming only 4 gb temp teblespace . Even No success after running RUNSTATS WITH DISTRIBUTION AND DETAILED INDEXES . Explain plans ,indexes , configurations are same in failed and working envoirment .

    working envoirment where we are running query directly on db2 database . And failed evnoirment is where we are running the query using DATASTAGE .

    Any sugestion ?
    Last edited by SukhbirDeol; 04-03-13 at 11:48.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by SukhbirDeol View Post
    working envoirment where we are running query directly on db2 database . And failed evnoirment is where we are running the query using DATASTAGE .
    Have you tried running the query from the command line in the failing environment? Is datastage using static sql / packages? Maybe you need to rebind them after performing the runstats.

  3. #3
    Join Date
    Apr 2013
    Posts
    2
    Thanks to get back .
    Yes I have tried the query running from the command line too after it failed from datastage side . It didnot work . I also tried rebind after runstats . That didnot work too .

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Please collect db2exfmt from working and non-working environment (when the query is run from the command line).

Posting Permissions

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