IBM Support

IC85127: SQL0901N MAY BE RETURNED WHEN DECREASING THE LENGTH OF A VARCHAR TYPE COLUMN VIA ALTER TABLE STATEMENT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When trying to shrink the length of a VARCHAR type column, you
    may receive a SQL0901N.
    
    For example,
    create table t(c1 varchar(10))
    
    insert into t(c1) values ('abcde     ')
    
    alter table t alter column c1 set data type varchar(5)
    DB21034E  The command was processed as an SQL statement because
    it was not a valid Command Line Processor command.  During SQL
    processing it returned:
    SQL0901N  The SQL statement failed because of a non-severe
    system error. Subsequent SQL statements can be processed.
    (Reason "Unexpected data partitioning PD version number".)
    SQLSTATE=58004
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users running DB2 Version 9.7 on Linux, Unix or Windows  *
    * platform and decreasing the length of a varchar              *
    * type column via alter table statement                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update the DB2 Version 9.7 Fix Pack 7.                       *
    ****************************************************************
    

Problem conclusion

  • This problem is first fixed in DB2 Version 9.7 Fix Pack 7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85127

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-05

  • Closed date

    2012-10-20

  • Last modified date

    2012-10-20

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

    IC84980

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

    IC88306

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7"}]

Document Information

Modified date:
20 September 2021