IBM Support

IC74750: COMPILING A SQL STATEMENT IN DB2 CAN FAIL WITH SQL0901N

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Compiling a SQL statement can fail with SQL0901N if the SQL
    statement is compiled with both Intra-Partition Parallelism and
    Inter-Partition Parallelism.
    
    The SQL0901N error message contains the following text:
    
    SQL0901N The SQL statement failed because of a non-severe system
    error. Subsequent SQL statements can be processed. (Reason
    "sqlno_smp_create_tq [100]:rc( 0) ".) SQLSTATE=58004
    

Local fix

  • Disable Intra-Partition Parallelism by using one of the
    following methods:
    
    
    Set database configuration parameter DFT_DEGREE to 1. This has
    database-wide effect.
    Set special register CURRENT DEGREE to 1. This affects the
    current connection for dynamic SQL.
    Use the bind option DEGREE. This affects the application for
    static SQL.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See above.                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 5                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC74750

  • 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

    2011-02-28

  • Closed date

    2011-12-16

  • Last modified date

    2011-12-16

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

    IC74745

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74750

Modified date: 16 December 2011