Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2016
    Posts
    20
    Provided Answers: 1

    Unanswered: DPF redistribute

    Hi,

    db2 V 10.5 fp 7

    Linux 6

    Have 5 logical partition, trying to drop partition 5 which is been used by database.

    Have created a partition map using db2gpmap.

    example output

    0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5
    0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5
    0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5
    0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5
    0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5 0 1 2 3 4 5


    Have edited to text file and removed 5

    example

    0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4
    0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4
    0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4
    0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4
    0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4
    0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4 0 1 2 3 4


    redistribute using this targetmap file give error

    db2 "REDISTRIBUTE database partition group IBMDEFAULTGROUP using TARGETMAP ibmdefaultgrp1.out "
    SQL6053N Error exists in file "ibmdefaultgrp1.out". Reason code = "1".
    SQLSTATE=00000

    Please suggest

    regds
    paul

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    110
    Provided Answers: 13
    Hi,

    Have you tried to read the description of this error code?
    db2 "? SQL6053N"

    You can't just remove some values from this map. The number of values must be the same.
    Regards,
    Mark.

  3. #3
    Join Date
    Aug 2016
    Posts
    20
    Provided Answers: 1
    yes,

    But its difficult to edit according to 32768, did with single record. Its working. But it shld be redistribute to all the partition expect the 5 one. Did a test with single partition its working

    regds
    Paul

  4. #4
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    110
    Provided Answers: 13
    Paul,

    You don't have to edit this file. You can easily generate such a map with the following sql statement:
    Code:
    with t(i) as (
    values 0
      union all
    select i+1
    from t
    where i<32767
    )
    select mod(i, 5)
    from t
    Regards,
    Mark.

Posting Permissions

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