DB2 Version 9.7 for Linux, UNIX, and Windows

sqlugtpi API has been deprecated

The sqlugtpi API, which gets table distribution information, has been deprecated and might be removed in a future release.


The sqlugtpi API is designed to work with distribution maps containing up to 4096 (4 KB) entries.

In Version 9.7, the distribution map size has been expanded to 32 768 (32 KB) entries. The sqlugtpi API cannot be used in conjunction with larger distribution maps that make use of more than 4096 entries. For information about enabling larger maps, see the "Distribution maps" topic.

User response

If the sqlugtpi API encounters a distribution map that it cannot process due to the larger size, it returns SQL2768N. Use the DB2GetDistMap API, which supports all distribution map sizes.