IBM Support

IC76388: SQLJ.DB2_INSTALL_JAR AND SQLJ.DB2_REPLACE_JAR ARE NOT WORKING FOR LUW SERVER USING CLP.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQLJ.DB2_INSTALL_JAR and SQLJ.DB2_REPLACE_JAR work for local as
    well as remote LUW server using CLI for db2_v97fp3 client.
    
    CLP supports only those SQLJ.* procedures which are supported by
    sqleproc() API and these two sqlj.db2_* procedures are not
    supported by  sqleproc() API. For these two procedures, CLP
    should go through CLI. CLP should also support these procedures.
    Call for these procedures using CLI is working fine.
    
    Following CLP commands fails:
    db2 -v "call
    sqlj.install_jar('file:/home/hotelfvt05/bimaljha/test.jar',
    'TEST_JAR')"
    db2 -v "call
    sqlj.replace_jar('file:/home/hotelfvt05/bimaljha/test1.jar',
    'TEST_JAR')"
    

Local fix

  • Use CLI or JAVA or Optim.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All who uses CLP.                                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Following CLP commands fails with error for LUW server:      *
    *                                                              *
    * db2 -v "call                                                 *
    * sqlj.install_jar('file:/home/hotelfvt05/bimaljha/test.jar',  *
    * 'TEST_JAR')"                                                 *
    *                                                              *
    * db2 -v "call                                                 *
    * sqlj.replace_jar('file:/home/hotelfvt05/bimaljha/test1.jar', *
    * 'TEST_JAR')"                                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v97fp5.                                       *
    ****************************************************************
    

Problem conclusion

  • db2_v97fp5 contains fix. After fix, command executes
    successfully.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76388

  • 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-05-13

  • Closed date

    2011-12-12

  • Last modified date

    2011-12-12

  • 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

[{"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:
12 December 2011