Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    2

    Unanswered: Problems when creating Capture Control Tables

    I am very new to DB2.
    Now I am trying to create SQL Replication on DB2 Express C Server.

    the DB2 message is like that

    IBM][CLI Driver][DB2/NT] SQL0289N Unable to allocate new pages
    in table space "TSASNUOW". SQLSTATE=57011



    Explanation:

    One of the following conditions is true on one or more database
    partitions:

    1 One of the containers assigned to this SMS table space has
    reached the maximum file size. This is the likely cause of the
    error.

    2 All the containers assigned to this DMS table space are full.
    This is the likely cause of the error.

    3 A rebalance is in progress, but has not progressed far enough
    to enable the newly added space to be used.

    4 A redirected restore is being done to containers that are too
    small.

    5 A rollforward is being done following a redirected restore and
    all the containers assigned to this tablespace are full.

    6 A rollforward skipping add containers is being done and all the
    containers assigned to this tablespace are full.

    7 An attempt was made to create a table space with less than 5
    usable extents.

    8 An auto-resize table space has reached its maximum size and all
    of the containers are full. Alternately, there is not enough
    space between the current size and the maximum size for
    containers to be extended or added so an automatic increase in
    space is not possible.

    9 An automatic storage table space is being created with a value
    for initial size that does not result in an equal distribution
    of container space. As a result, a higher value is being used
    but this value is larger than the maximum size specified.

    10 A DMS table space enabled for auto-resize has not reached its
    maximum size but one of the file systems on which the
    containers exists is full and the container cannot grow.

    11 A DMS table space enabled for auto-resize has not reached its
    maximum size and the file systems on which the table space
    resides are not full. However, a container operation (or a
    subsequent rebalance) is in progress and the auto-resize
    capability is suspended until it is complete.

    12 A table space with the auto-resize feature enabled that is
    managed by a database, or automatic storage, cannot increase in
    size because the table space is in a WRITE SUSPEND state.

    User response:

    Perform the action corresponding to the cause of the error:

    1 Either switch to a DMS TABLESPACE or recreate the SMS
    TABLESPACE with more directories (PATHs) such that: (number of
    directories) >= (max tablesize / maxfilesize). Note that
    maximum file size is operating system dependent.

    2 Add new container(s) to the DMS table space and try the
    operation again, after the rebalancer has made the new pages
    available for use.

    3 Wait for the rebalancer to finish.

    4 Perform the redirected restore again to larger containers.

    5 Perform the redirected restore again to larger containers.

    6 Perform the rollforward again allowing add containers, or
    perform a redirected restore to larger containers.

    7 Resubmit the CREATE TABLESPACE statement, ensuring that the
    table space has at least 5 usable extents.

    8 Increase the maximum size for the table space.

    9 Reduce the initial size or increase the maximum size for the
    table space.

    10 Add a new stripe set of containers to the table space. Existing
    containers will no longer grow, only those new containers in
    the last range of the table space are extended when an
    automatic resize occurs.

    11 Wait for the operation and subsequent rebalance to complete.

    12 The table space must be removed from the WRITE SUSPEND state
    before new pages can be allocated.

    sqlcode: -289

    sqlstate: 57011


    the problem is I don't know how to manage the SMS and DMS tablespace
    pls help me out

    Khin

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I suggest you read on this in the DB2 Administration Guide. Some basic knowledge of the administration concepts of DB2 can be expected when you work with such a system.

    Alternatively, have a look at automatic storage.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2008
    Posts
    2
    Thanks stolze for your advice

    Khin
    Internship Student
    Singapore

Posting Permissions

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