IBM Support

IC85503: ACCESSING DB2/Z OS WITH CLI MAY ENCOUNTER -904 ERROR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 client has a chance to use QRYBLKSZ basing on ASLHEAPSZ(max
    here is 10MB) when accessing DB2 z/OS  with CLI. However, DB2
    for z/OS has a limitation of supporting the QRYBLKSZ up to 10MB,
    256K is currently the max supported, if the max size is
    exceeded, SQLCODE -904 or -246 will be generated.
    
    The issue can be reproduced with a Federation case:
    
    1. Create DRDA wrapper
    2. Create a server pointing to a DB2/z OS databse, set server
    option DB2_TWO_PHASE_COMMIT to 'Y'
    3. Create an user mapping
    4. Create a nickname pointing to a table on DB2/z OS
    
    The last steps will end up with following error:
    
    DB21034E  The command was processed as an SQL statement because
    it was not a valid Command Line Processor command.  During SQL
    processing it returned:
    SQL1415N  The statement was compiled for diagnostic purposes
    only and has not been executed.
    
    The fix will limit the QRYBLKSZ up to 256K on the client.
    

Local fix

  • Reduce DBM CFG ASLHEAPSZ to a value less than 2560.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * The users are accessing DB2 z/OS via DRDA nickname with      *
    * DB2_TWO_PHASE_COMMIT = 'Y'.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Server v97fp7 or later.                       *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed at v97fp7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC85503

  • 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-25

  • Closed date

    2012-10-24

  • Last modified date

    2012-10-24

  • 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

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC85503

Modified date: 24 October 2012