IBM Support

IC78013: SQLJ.*_JAR AND SQLJ.DB2_*_JAR STORED PROCS CANNOT BE CALLED REMO TELY AGAINST HOST DATABASES (ZOS, ISERIES, ETC.) FROM NON-JCC CL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When customer attempts to execute SQLJ.*_JAR or SQLJ.DB2_*_JAR
    stored procedures from a DB2 LUW client against a host database,
    the error that is returned is not very informative. An example
    of such an uninformative error is:
    
    SQL30073N "0x2113" Parameter value "0x0000" is not supported.
    SQLSTATE=58017
    
    This error gives the impression that one of the input parameters
    passed in the stored procedure is not supported. These errors
    have been altered to provide a more informative error:
    
    SQL1325N  The remote database environment does not support the
    command or one of the command options.
    
    This is because the calling of SQLJ.*_JAR stored procedures
    against host databases is not supported regardless of the
    connection
    type used. SQLJ.DB2_*_JAR stored procedures on the other hand
    can
    be called via JCC clients against host databases.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users connecting to host databases                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SQLJ.*_JAR and SQLJ.DB2_*_JAR stored procedures cannot be    *
    * called remotely against host databases (zOS, iSeries, etc.)  *
    * from non-JCC Clients. If called, the error returned is not   *
    * very informative.                                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7 fp6                                          *
    ****************************************************************
    

Problem conclusion

  • The error messages have been altered so that the following,
    
    more informative error is dumped:
    
    SQL1325N  The remote database environment does not support the
    command or one of the command options.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78013

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-09

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

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

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 June 2012