IBM Support

IC81685: MIGRATIONUTILITY DIALOG BOX CREATES db2dsdriver.cfg FILE IN THE INSTALL PATH AND NOT IN THE APPLICATION DATA PATH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2dsdriver.cfg is created in the installation path ("C:\Program
    Files\IBM\sqllib\cfg") and not in the common application data
    path ("C:\Documents and Settings\All Users\Application
    Data\IBM\DB2\DB2COPY1\cfg")
    

Local fix

  • db2dsdriver.cfg can be manually copied from install path
    ("C:\Program Files\IBM\sqllib\cfg") to Common application data
    path  ("C:\Documents and Settings\All Users\Application
    Data\IBM\DB2\DB2COPY1\cfg")
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2Connect Users                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * MigrationUtility dialog box creates cfg file in the install  *
    * path directory and not in the application data path          *
    * directory with dsdriver                                      *
    *                                                              *
    * 1) Install dsdriver on a machine where already client        *
    * package or RTCL is being installed                           *
    * 2) Have some db's cataloged                                  *
    * 3) When the MigrationUtility dialog box  " Create catalog    *
    * configuration file from existing DB2 default copy" screen    *
    * will popup, In that select the option "Create configuration  *
    * file"                                                        *
    *                                                              *
    *                                                              *
    * Observations:                                                *
    *                                                              *
    * After installing dsdriver we can observe that the cfg file   *
    * is created is in the install path directory and not in the   *
    * application data path directory. Since the utility calls     *
    * db2dsdcfgfill internally and with db2dsdcfgfill if we are    *
    * not specifying the /o ( output=path) option then cfg it will *
    * be created in the application data path                      *
    *                                                              *
    * Snippet from db2dsdcfgfill from info centre                  *
    *                                                              *
    * -o output-path                                               *
    *     The path where the db2dsdcfgfill command creates the     *
    * db2dsdriver.cfg configuration file.                          *
    *                                                              *
    *     If you do not specify a value for this parameter, and    *
    * you have a copy of the db2dsdriver.cfg file from Version 9.7 *
    * Fix Pack 2 or earlier, that copy is replaced. Otherwise, if  *
    * you do not specify a value for this parameter, the           *
    * db2dsdriver.cfg configuration file is created in a directory *
    * that depends on your driver type and platform. For           *
    * information about the location of the db2dsdriver.cfg file,  *
    * see the topic about that file.                               *
    *                                                              *
    * http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.j *
    * sp?topic=%2Fcom.ibm.swg.im.dbclient.config.doc%2Fdoc%2Fr0054 *
    * 557.html&resultof=%22db2dsdcfgfill%22                        *
    *                                                              *
    * The same behavior is observed with both GUI install as well  *
    * as silent install of dsdriver.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * To get the fix customers can upgrade to v97fp6               *
    ****************************************************************
    

Problem conclusion

  • There is no harm if cfg file is created in install path since
    back ward compatibility is supported. Customers can copy the
    db2dsdriver.cfg file from install path to the Common application
    data path.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81685

  • 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

    2012-02-28

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

    IC84441

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:
05 June 2012