PK15741: GEN,DDL AND LKEY COMMANDS DO NOT HANDLE DEFAULT LIMIT KEYS VALUES CORRECTLY RESULTING IN SQLCODEN104 -104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration tool GEN, DDL and LKEY line commands do
  not produce the correct results for objects which have default
  limit keys resulting in DDL which have a VALUES clause of
  x'FF' or x'00'. This can result in an SQLCODEN104 -104 if the
  DDL is executed.
  .
  Additional symptoms: sqlcode104
  

Local fix

• Correct the limit key manually
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  DB2  Administration Tool are      *
  *                 affected, if  use  GEN  CREATE TABLE in      *
  *                 a partitioned tablespace when the table      *
  *                 has  been   converted  from  index-  to      *
  *                 talbe-controlled partitioning.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running in DB2 Version 8 environment,   *
  *                      when  a   partitioned  tablespace  is   *
  *                      converted  from   index-controlled to   *
  *                      table-controlled   partitioning,  the   *
  *                      limitkey  for  the last  partition is   *
  *                      converted  to  the  highest  (lowest)   *
  *                      values.  Currently,  DB2 places X'FF'   *
  *                      for  each key value in case the index   *
  *                      key   is  ascending.   GEN   was  not   *
  *                      correctly producing this value in the   *
  *                      case the  key column was a TIMESTAMP,   *
  *                      DATE or TIME column.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    ADBH1TAV ADB2REG  ADB21TAV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK11419

     UP06/02/10 P F602

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.