IBM Support

IC90016: DB2CLI VALIDATE IS GIVING IMPROPER ERROR MESSAGE WHEN DB2DSDRIVER.XSD FILE DOESN'T EXISTS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The below problem with occurring because we cannot see
    db2dsdriver.xsd in the desired location -- hence I believe the
    error is thrown. Yes, error message is not accurate and should
    be fixed.
    
    db2dsdriver.cfg (for all instance)
    
    <configuration>
        <dsncollection>
           <dsn alias="DB9G" name="DB9ALOC" host="host1.ibm.com"
    port="50000">
              <parameter name="DisableAutoCommit" value="TRUE"/>
           </dsn>
        </dsncollection>
        <databases>
           <database name="DB9ALOC" host="host1.ibm.com"
    port="50000">
              <wlb>
                 <parameter name="enableWLB" value="true" />
              </wlb>
          </database>
        </databases>
     </configuration>
    
    DB2 connect 9.7 fixpack 6 (db2inst1)
    
    $ db2cli validate -dsn db9g -connect -user XYS -passwd XYS
    IBM DATABASE 2 Interactive CLI Sample Program
    (C) COPYRIGHT International Business Machines Corp. 1993,1996
    All Rights Reserved
    Licensed Materials - Property of IBM
    US Government Users Restricted Rights - Use, duplication or
    disclosure restricted by GSA ADP Schedule Contract with IBM
    Corp.
    
    ----------------------------------------------------------------
    -----------
      [ CLI Driver Version  : 09.07.0000 ]
      [ Informational Tokens: "DB2
    v9.7.0.6","s120629","IP23414","Fixpack  6" ]
      [ CLI Driver Type     : IBM Data Server Runtime Client ]
      [ db2diag.log Path    :
    /home/db2inst1/sqllib/db2dump/db2diag.log ]
    
    ----------------------------------------------------------------
    -----------
    
    db2dsdriver.cfg Schema Validation :
    Note: The validation operation utility could not find the
    configuration file named db2dsdriver.cfg.
    The file is searched at
    /home/db2inst1/sqllib/cfg/db2dsdriver.cfg
    
    db2cli.ini Validation :
    Note: The validation operation utility could not find the
    configuration file named db2cli.ini.
    The file is searched at /home/db2inst1/sqllib/cfg/db2cli.ini
    
    
    db2dsdriver.cfg Validation :
    
    ----------------------------------------------------------------
    -----------
      [ DB2DSDRIVER_CFG_PATH env var : /home/db2inst1/sqllib/cfg ]
      [ db2dsdriver.cfg Path         :
    /home/db2inst1/sqllib/cfg/db2dsdriver.cfg ]
    
    ----------------------------------------------------------------
    -----------
      [ List of keywords used for DSN : db9g ]
        Keywords                  Valid For     Value
        -------------------------------------------------------
        DATABASE                  CLI,.NET,ESQL DB9ALOC
        HOSTNAME                  CLI,.NET,ESQL host1.ibm.com
        PORT                      CLI,.NET,ESQL 50000
        DISABLEAUTOCOMMIT         CLI           TRUE
    
    ----------------------------------------------------------------
    -----------
    
    Connection Section :
    
    ----------------------------------------------------------------
    -----------
      Connecting to: db9g
      [IBM][CLI Driver] SQL30061N  The database alias or database
    name "DB9ALOC           " was not found at the remote node.
    SQLSTATE=08004
    
      Connect Status: failure
      End Connection Section
    
    ----------------------------------------------------------------
    -----------
    
    Error: The validation operation failed.
    
    DB2 client 9.7 (fixpack 6)
    
    $ db2cli validate -dsn db9g -connect -user XYS -passwd XYS
    IBM DATABASE 2 Interactive CLI Sample Program
    (C) COPYRIGHT International Business Machines Corp. 1993,1996
    All Rights Reserved
    Licensed Materials - Property of IBM
    US Government Users Restricted Rights - Use, duplication or
    disclosure restricted by GSA ADP Schedule Contract with IBM
    Corp.
    
    ----------------------------------------------------------------
    -----------
      [ CLI Driver Version  : 09.07.0000 ]
      [ Informational Tokens: "DB2
    v9.7.0.6","s120629","IP23414","Fixpack  6" ]
      [ CLI Driver Type     : IBM Data Server Client ]
      [ db2diag.log Path    :
    /home/db2inst2/sqllib/db2dump/db2diag.log ]
    
    ----------------------------------------------------------------
    -----------
    
    db2dsdriver.cfg Schema Validation :
    Note: The validation operation utility could not find the
    configuration file named db2dsdriver.cfg.
    The file is searched at
    /home/db2inst1/sqllib/cfg/db2dsdriver.cfg
    
    db2cli.ini Validation :
    Note: The validation operation utility could not find the
    configuration file named db2cli.ini.
    The file is searched at /home/db2inst2/sqllib/cfg/db2cli.ini
    
    
    db2dsdriver.cfg Validation :
    
    ----------------------------------------------------------------
    -----------
      [ DB2DSDRIVER_CFG_PATH env var : /home/db2inst1/sqllib/cfg ]
      [ db2dsdriver.cfg Path         :
    /home/db2inst1/sqllib/cfg/db2dsdriver.cfg ]
    
    ----------------------------------------------------------------
    -----------
      [ List of keywords used for DSN : db9g ]
        Keywords                  Valid For     Value
        -------------------------------------------------------
        DATABASE                  CLI,.NET,ESQL DB9ALOC
        HOSTNAME                  CLI,.NET,ESQL host1.ibm.com
        PORT                      CLI,.NET,ESQL 50000
        DISABLEAUTOCOMMIT         CLI           TRUE
    
    ----------------------------------------------------------------
    -----------
    
    Connection Section :
    
    ----------------------------------------------------------------
    -----------
      Connecting to: db9g
      Connect Status: success
      End Connection Section
    
    ----------------------------------------------------------------
    -----------
    
    The validation completed.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 Connect users how are using db2cli validate and      *
    * doesn't have dn2dsdriver.xsd file.                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V9.7 FP9                                      *
    ****************************************************************
    

Problem conclusion

  • DB2 V9.7 FP9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90016

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-04

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

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

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

    IC91774

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC90016

Modified date: 16 December 2013