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

    Unanswered: Facing issues with update the table through datastage

    Hi all,

    In our setup db2V9.7 with fixpack 4

    Facing issues with update the table through datastage.

    Tablespace with the name of STG1 with 32k pagesize

    Bufferpool with the name of stg with 32k pagesize..

    Trying to update the column(SRC_FLE_NAME) for all table under tablespace

    it's throwing an error with:

    A system temporary table space with sufficient page size does not exist.. SQLCODE=-1585, SQLSTATE=54048, DRIVER=4.12.79


    Anyhow table contains with the 17columns max 6800 bytes only

    But for 32k pagesize max col limit upto 32677


    Not able to update the column? Could you please give me the suggestion over this?



    Thanks,
    laxman..

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated by message
    A system temporary table space...
    you indicate :
    Tablespace with the name of STG1 with 32k pagesize
    Bufferpool with the name of stg with 32k pagesize..
    and temp ??
    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

  3. #3
    Join Date
    Sep 2012
    Posts
    177
    Sorry guy,

    Temspace looks like this:
    ==================
    Tablespace ID = 1
    Name = TEMPSPACE1
    Type = System managed space
    Contents = System Temporary data
    State = 0x0000
    Detailed explanation:
    Normal
    Total pages = 1
    Useable pages = 1
    Used pages = 1
    Free pages = Not applicable
    High water mark (pages) = Not applicable
    Page size (bytes) = 4096
    Extent size (pages) = 32
    Prefetch size (pages) = 32
    Number of containers = 1


    Thanks,
    laxman.....

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    as indicated by message : .. with sufficient page size does not ..
    you indicate : Page size (bytes) = 4096
    the needed page for this operation might be different...
    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

  5. #5
    Join Date
    Sep 2012
    Posts
    177
    Hi guy,

    Can i create the system temporary tablespace and assign the bufferpool over to this?


    Thanks.
    laxman....

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Quote Originally Posted by laxman babu View Post
    Can i create the system temporary tablespace and assign the bufferpool over to this?
    Yes, you can.

Posting Permissions

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