IBM Support

JR35790: DB2 CONFIGURATION ASSISTANT CAN REPORT CCA3061N ERROR WHEN DISCO VERING REMOTE DB2 SERVERS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using the DB2 Configuration Assistant (CA) from a remote
    DB2 client, it might fail with a CCA3061N error:
    .
    CCA3061N - "Incomplete server configuration."
    .
    This would happen during discovery.   During discovery, the
    database administration server (DAS) on the remote server, will
    execute a program called db2genp.  db2genp is used to provide
    information about the remote instances that would be needed to
    properly discover the remote server.   Part of the process
    of db2genp is to load and execute functions from a library
    called libcatcp.a.   DB2 looks for libcatcp.a in sqllib/lib,
    however the library is located in sqllib/lib64.  If sqllib/lib
    is linking to sqllib/lib32 instead of sqllib/lib64, then
    db2genp will not find this library and fail.
    .
    This APAR will ensure that db2genp will look for the libcatcp.a
    library in sqllib/lib64 since it is a 64-bit library on
    64-bit instances.
    .
    The following error might be recorded in the server-side
    db2diag.log when this problem happens:
    .
    2010-02-25-15.46.51.442166-100 I2341C121          LEVEL: Error
    PID     : 39120                TID  : 3001943122451PROC :
    db2genp
    INSTANCE: db2inst1             NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqlecgen_getproinfo,
    probe:13
    MESSAGE : DIA7500E Error encountered in the Generator.  Return
    code from
              "caProIfInit" was "1".
    

Local fix

  • Copy libcatcp.a from sqllib/lib64 and place it in sqllib/lib32.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When using the DB2 Configuration Assistant (CA) from aremote *
    * DB2 client, it might fail with a CCA3061N error:CCA3061N -   *
    * "Incomplete server configuration."This would happen during   *
    * discovery.  During discovery, thedatabase administration     *
    * server (DAS) on the remote server,will execute a program     *
    * called db2genp.  db2genp is used toprovide information about *
    * the remote instances that would beneeded to properly         *
    * discover the remote server.  Part of theprocess of db2genp   *
    * is to load and execute functions from alibrary called        *
    * libcatcp.a.  DB2 looks for libcatcp.a insqllib/lib, however  *
    * the library is located in sqllib/lib64.If sqllib/lib is      *
    * linking to sqllib/lib32 instead ofsqllib/lib64, then db2genp *
    * will not find this library andfail.This APAR will ensure     *
    * that db2genp will look for thelibcatcp.a library in          *
    * sqllib/lib64 since it is a 64-bitlibrary on 64-bit           *
    * instances.The following error might be recorded in the       *
    * server-sidedb2diag.log when this problem                     *
    * happens:2010-02-25-15.46.51.442166-100 I2341C121             *
    * LEVEL:ErrorPID    : 39120                TID  :              *
    * 3001943122451PROC :db2genpINSTANCE: db2inst1            NODE *
    * : 000FUNCTION: DB2 UDB, base sys utilities,                  *
    * sqlecgen_getproinfo,probe:13MESSAGE : DIA7500E Error         *
    * encountered in the Generator.Return code from"caProIfInit"   *
    * was "1".                                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.5, Fixpak 6                                *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, Fixpak 6
    

Temporary fix

  • see LOCAL FIX
    

Comments

APAR Information

  • APAR number

    JR35790

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-26

  • Closed date

    2010-05-25

  • Last modified date

    2010-05-25

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

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

    IC66729 IC67990

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSN

       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":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 May 2010