IBM Support

IC77917: VALID KEYWORDS OF DB2DSDRIVER.CFG FILE APPEAR IN UNKNOWN SECTION OF DB2CLI VALIDATE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The following valid keywords of db2dsdriver.cfg file appear as
    unknown in the UKNOWN section on doing a db2cli validate.
    These keywords should not appear under the UNKNOWN section
    during db2cli validate.
    
    
    
      [ Keywords UNKNOWN for Database : name1 ]
        Keyword                                      Value
        --------------------------------------------------
        tcpipConnectTimeout                          2
        MemberConnectTimeout                         1
        KeepAliveTimeout                             1
        enableDirectXA                               FALSE
        ClientProgramID                              newton12
        ClientProgramName                            newton12
        ConnectionLifetimeInPool                     1
        DisableDTCEnlist                             1
        DisablePooling                               1
        EnableConnectionReset                        1
        EnableSecurityInfoPersistence                1
        MaxPoolSize                                  100
        MinPoolSize                                  100
        RetrieveXmlInBinaryFormat                    1
        SecurityTransportMode                        1
        ServerType                                   UNIDATA
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The following valid keywords of db2dsdriver.cfg file appear  *
    * as                                                           *
    * unknown in the UKNOWN section on doing a db2cli validate.    *
    *                                                              *
    * These keywords should not appear under the UNKNOWN section   *
    *                                                              *
    * during db2cli validate.                                      *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *   [ Keywords UNKNOWN for Database : name1 ]                  *
    *                                                              *
    *     Keyword                                      Value       *
    *                                                              *
    *     --------------------------------------------------       *
    *                                                              *
    *     tcpipConnectTimeout                          2           *
    *                                                              *
    *     MemberConnectTimeout                        1            *
    *                                                              *
    *     KeepAliveTimeout                            1            *
    *                                                              *
    *     enableDirectXA                              FALSE        *
    *                                                              *
    *     ClientProgramID                              newton12    *
    *                                                              *
    *     ClientProgramName                            newton12    *
    *                                                              *
    *     ConnectionLifetimeInPool                    1            *
    *                                                              *
    *     DisableDTCEnlist                            1            *
    *                                                              *
    *     DisablePooling                              1            *
    *                                                              *
    *     EnableConnectionReset                        1           *
    *                                                              *
    *     EnableSecurityInfoPersistence                1           *
    *                                                              *
    *     MaxPoolSize                                  100         *
    *                                                              *
    *     MinPoolSize                                  100         *
    *                                                              *
    *     RetrieveXmlInBinaryFormat                    1           *
    *                                                              *
    *     SecurityTransportMode                        1           *
    *                                                              *
    *     ServerType                                  UNIDATA      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v97fp5 or later releases.                     *
    ****************************************************************
    

Problem conclusion

  • db2_v97fp5 contains this fix. After this fix, the valid
    db2dsdriver.cfg keywords does not appear under UNKNOWN section
    in the output of db2cli validate command.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77917

  • 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-08-04

  • 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



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77917

Modified date: 12 December 2011