IBM Support

IC90708: A PRECOMPILER GIVES OUT THE ERROR -1024 EVEN IF CONNECTION IS SU CCESSFULLY MADE, WHEN CUSTOMER USE "WLB TAG" IN DB2DSDRIVER.CFG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Environment
    Customer is using z/OS for host server and DB2 Connect as a
    client.
    Version infomation is as follows
    
     (host)
    <--------------------------------------------------------->
    (client)
      z/OS
    AIX 64bit 6.1.0.0
    DB2 v10.1.5 for z/OS
    DB2 CONNECT v9.7.0.7 for LUW
    
    When customer use "WLB tag" in db2dsdriver.cfg file, the
    precompiler give out the error even though connection is
    successfully made
    
    $ db2 connect to dsnzloc user DB2LUW using DB2UDB
    
       Database Connection Information
    
    Database server        = DB2 z/OS 9.1.5
    SQL authorization ID   = DB2LUW
    Local database alias   = DSNZLOC
    
    $ db2 precompile $1.sqc bindfile LONGERROR NO COMPATIBILITY_MODE
    ORA
    
    LINE    MESSAGES FOR test.sqc
    ------
    ----------------------------------------------------------------
    ---
            SQL0060W  The "C" precompiler is in progress.
            SQL1024N  A database connection does not exist.
            SQL0095N  No bind file was created because of previous
                      errors.
            SQL0091W  Precompilation or binding was ended with "2"
                      errors and "0" warnings.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * who use "WLB TAG" IN DB2DSDRIVER.CFG under db2 z and db2 luw *
    * environment                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * remove the wlb tag in the db2dsdriver.cfg                    *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC90708

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-07

  • Closed date

    2013-10-13

  • Last modified date

    2013-10-13

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

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

Fix information

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"9.7","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 June 2020