Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2014
    Posts
    3

    Unanswered: Partition map size

    Hello, I already posted a topic on IBM DB2 forum, but in order to get more answer, I am going to post here.
    (just in case, I paste the link https://www.ibm.com/developerworks/c...4ab0a30e&ps=25)

    I work on a Linux system and I have two separate installations of DB2 (V10.5 and V9.5).

    The db2level result of the first one is :
    DB21085I Instance "i9510" uses "64" bits and DB2 code release "SQL0905A" with
    level identifier "060B0107".
    Informational tokens are "DB2 v9.5.0.10", "s120809", "IP23364", and Fix Pack
    "10".
    Product is installed at "/opt/ibm/db2/V9.5".

    and the db2level result of the second one is :
    DB21085I This instance or install (instance name, where applicable: "i1053")
    uses "64" bits and DB2 code release "SQL10053" with level identifier
    "0604010E".
    Informational tokens are "DB2 v10.5.0.3", "s140513", "IP23551a", and Fix Pack
    "3a".
    Product is installed at "/opt/ibm/db2/V10.5".

    What I am trying to do, is to use the db2gpmap command on both DB2 versions.
    On the V10.5 version, the generated file (db2split.map) has 32768 entries.
    On the V9.5 version, the generated file (db2split.map) has 4096 entries.

    I wanted to know if it is possible to get a file with 4096 entries with the V10.5 version ?

    I tried to set the DB2_PMAP_COMPATIBILITY environment variable to ON just to be sure, but it still not work, the generated file has 32768 entries.
    On the IBM DB2 documentation site, the description for this environment variable is (extract) : "The default setting, ON, indicates that the distribution map size remains 4 096 entries (the pre-Version 9.7 behavior)."

    After reading the DB2 documentation part above, I thought the V10.5 give the same results as V9.5.

    Any ideas ?

    Thanks and regards,
    Stéphane

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    The v10.5 db2gpmap command uses the new API db2GetDistMap which currently returns a map with 32K entries. Older versions of db2gpmap (such as your V9.5 version) used the old API instead.

    The V10 documentation is clear that the registry variable DB2_PMAP_COMPATIBILITY relates to the API behaviour, which is a different thing than the behaviour of user level commands. It would have been helpful if the doc page for the db2gpmap command also mentioned that db2gpmap uses db2GetDistMap instead of the deprecated sqlugtpi.

    If ,for some reason, you are dependent on a map with 4096 entries then you must write a program that uses the deprecated API sqlugtpi *and* also ensure the DB2_PMAP_COMPATIBILITY is set to ON.

  3. #3
    Join Date
    Oct 2014
    Posts
    3
    Okay, thank you for your answer! I will take into account your remarks.

Posting Permissions

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