IBM Support

IT15950: UPGRADE TO 5.2.9 FAILS AT DB COMPONENT DUE TO SQLCODE=-572, SQLSTATE=51028, SQLERRMC=NULLID.SQLUAK20

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The installation logs shows the following errors:
    
     SQL statement: call admin_cmd('import from "C:\Program
    Files\IBM\TPC\config\install\data\sql\imports\GLOBALIZATION_LOOK
    UP_MASTER.csv" of DEL MODIFIED BY CODEPAGE=1208 replace into
    GLOBALIZATION_LOOKUP_MASTER')
         [java]                                      SQLSTATE:
    51028, Vendor error code: -572
    2016-03-31 16:19:21.184+0200 INFO
    SQLSTATE: 51028, Vendor error code: -572
         [java]                                      DB2 SQL Error:
    SQLCODE=-572, SQLSTATE=51028, SQLERRMC=NULLID.SQLUAK20,
    DRIVER=3.65.77
    

Local fix

  • db2 connect to TPCDB user administrator using
    <password_for_administrator>
    db2 rebind package NULLID.SQLUAK20
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Those upgrading to IBM Spectrum Control or TPC 5.2.x         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Upgrade fails when the DB2 package NULLID.SQLUAK20 is        *
    * inoperative.  See ERROR DESCRIPTION                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 5.2.11 fix maintenance when available instead.    *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is targeted for the following maintenance
    package:
    
    | refresh pack | 5.2-TIV-TPC-RP0011 - target august 2016
    
    Fixed in IBM Spectrum Control 5.2.11.
    
    http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
    
    The target dates for future refresh packs do not represent a
    formal commitment by IBM. The dates are subject to change
    without notice.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT15950

  • Reported component name

    TPC

  • Reported component ID

    5608TPC00

  • Reported release

    52A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-06-30

  • Closed date

    2016-08-05

  • Last modified date

    2016-08-05

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

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

Modules/Macros

  • INSTALL
    

Fix information

  • Fixed component name

    TPC

  • Fixed component ID

    5608TPC00

Applicable component levels

  • R529 PSY

       UP

[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"52A"}]

Document Information

Modified date:
22 February 2022