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

    Unanswered: Issues with tablespace state 0x10000000

    Hi all,

    In our setup db2 v9.7 with fixpack 4

    Facing issues with tablespace

    Tablespace went to State 0x10000000

    How to set backup to normal state, user's are not able to fetch the records.

    Could you please help me to get rid of this issue?



    Thanks,
    laxman..

  2. #2
    Join Date
    Dec 2010
    Posts
    123
    If your before v8 up to FixPak 3 , Restart of instance will resolve issue.

  3. #3
    Join Date
    Sep 2012
    Posts
    177
    Ravi thanks for your rply..

    Our environment is running in db2 v9.7 fixpack 4..

    Please help me to get rid of this issue.

    Thanks,
    laxman..

  4. #4
    Join Date
    Jan 2010
    Posts
    207
    DMS Rebalance in Progress

    0x10000000 This is a transient state that is only in effect during a data rebalancing operation. When new containers are added to a table space that is defined as database managed space (DMS), or existing containers are extended, a rebalancing of the table space data might occur.

    Rebalancing is the process of moving table space extents from one location to another in an attempt to keep the data striped. An extent is a unit of container space (measured in pages), and a stripe is a layer of extents across the set of containers for a table space. Given load input file staffdata.del with a substantial amount of data (for example, 20000 or more records):

    connect to sample;

    create tablespace ts1 managed by database using (file '/home/melnyk/melnyk/NODE0000/SQL00001/ts1c1' 1024);

    create table newstaff like staff in ts1;

    load from staffdata.del of del insert into newstaff nonrecoverable;

    alter tablespace ts1 add (file '/home/melnyk/melnyk/NODE0000/SQL00001/ts1c2' 1024);
    select varchar(tbsp_name, 30) as tbsp_name, varchar(tbsp_state, 40) as tbsp_state from table(mon_get_tablespace('',-2)) as t;
    connect reset;

    Information returned for TS1 shows that this table space is in DMS Rebalance in Progress state.

Posting Permissions

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