IBM Support

IC85565: SQL0901N IS RETURNED WHEN MOVING A DATABASE THAT IS CREATED ON OR UPGRADED DIRECTLY TO V10.1 FP1 DOWN TO V10.1 GA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you create or upgrade directly a database to DB2 Version 10.1
    Fix Pack 1 without landing on DB2 Version 10.1 GA, you will
    receive SQL0901N when moving the database to DB2 Version 10.1
    GA.
    
    For example,
    
    connect to sample
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "Scan
    interface error".)
    SQLSTATE=58004
    
    2012-07-25-15.01.34.328999-240 I111805044E1779       LEVEL:
    Severe
    PID     : 20724                TID  : 46913063741760 KTID :
    20778
    PROC    : db2sysc
    INSTANCE: user              NODE : 000          DB   : SAMPLE
    APPHDL  : 0-7                  APPID: *LOCAL.user.120725190132
    AUTHID  : USER
    EDUID   : 16                   EDUNAME: db2agent (V98)
    FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::insert,
    probe:20
    DATA #1 : String, 20 bytes
    Scan interface error
    DATA #2 : String, 22 bytes
    Fields not fully setup
    DATA #3 : String, 11 bytes
    SYSVERSIONS
    DATA #4 : String, 11 bytes
    INDTABLES01
    DATA #5 : Catalog Scan, PD_TYPE_SQLRL_CATALOG_SCAN, 520 bytes
    # Key Fields requested: 0
    # Key Fields set up: 0
    # Fetch Fields requested: 4
    # Fetch Fields set up: 3
    # LOB Fields: 0
    # XML Fields: 0
    Scan type: Insert
    Lock intent: SQLD_SLI_IS_NS (7)
    Lock isolation: SQLZ_CSTAB
    Scan flags 1: 0x0000000000000008 SQLD_SCAN1_INDEX_FIXLATCH_OPT
    Scan flags 2: 0x00000000
    CALLSTCK:
      [0] 0x00002AAAACE021AA pdLog + 0x1D6
      [1] 0x00002AAAB076C549 _ZN16sqlrlCatalogScan13checkForErrorEv
    + 0x11B
      [2] 0x00002AAAB0774003 _ZN16sqlrlCatalogScan6insertEv + 0x42F
      [3] 0x00002AAAB086DA2C
    _Z20sqlrlGetVersionTimesP8sqlrr_cbbPP17sqlr_versionTimes + 0xCFC
      [4] 0x00002AAAAFE2A218 _Z15sqlrr_appl_initP8sqeAgentP5sqlca +
    0x2314
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users running DB2 Version 10.1 on Linux, Unix or Windows *
    * platform and moving a database that is created on or         *
    * upgraded directly to v10.1fp1 to v10.1 GA                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update the DB2 Version 10.1 Fix Pack 1.                      *
    ****************************************************************
    

Problem conclusion

  • This problem is first fixed in DB2 Version 10.1 Fix Pack 1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85565

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-26

  • Closed date

    2012-10-31

  • Last modified date

    2012-10-31

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 October 2012