IBM Support

IT32303: DB2JDBCBIND COMMAND GENERATES FODC_APPERR FOLDERS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Running command listed below finishes successfully but generates
    a lot of FODC_AppErr folder.
    This happens only in 11.1.4.5, new installations or databases to
    this version FP.
    db2jdbcbind -url jdbc: db2: // localhost: 51050 / testdb -user $
    ABS_USER -password $ ABS_PW -collection NULLID -size 30
    
    db2diag.log shows:
    2020-03-02-07.41.33.358887+060 I121501E626           LEVEL:
    Severe
    PID     : 53276                TID : 140734049019648 PROC :
    db2sysc 0
    INSTANCE: db2ref               NODE : 000            DB   :
    TESTDB
    APPHDL  : 0-1042               APPID:
    127.0.0.1.44504.200302064130
    AUTHID  : UDBADM               HOSTNAME: sla20042
    EDUID   : 2105                 EDUNAME: db2agent (TESTDB) 0
    FUNCTION: DB2 UDB, access plan manager, sqlra_cache_fill_pkg,
    probe:60
    DATA #1 : Pointer, 8 bytes
    0x00007ffedb2a1780
    DATA #2 : String with size, 8 bytes
    NULLID
    DATA #3 : String with size, 8 bytes
    SYSLH103
    DATA #4 : unsigned integer, 8 bytes
    0
    
    2020-03-02-07.41.33.359491+060 E122128E803           LEVEL:
    Error
    PID     : 53276                TID : 140734049019648 PROC :
    db2sysc 0
    INSTANCE: db2ref               NODE : 000            DB   :
    TESTDB
    APPHDL  : 0-1042               APPID:
    127.0.0.1.44504.200302064130
    AUTHID  : UDBADM               HOSTNAME: sla20042
    EDUID   : 2105                 EDUNAME: db2agent (TESTDB) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:30
    MESSAGE : ADM14005E  The following error occurred: "AppErr".
    First Occurrence
              Data Capture (FODC) has been invoked in the following
    mode:
              "Automatic".  Diagnostic information has been recorded
    in the
              directory named
    
    "/home/db2ref/sqllib/db2dump/FODC_AppErr_2020-03-02-07.41.33.359
    376_5
              3276_2105_000/".
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.6.                                         *
    ****************************************************************
    

Problem conclusion

  • Problem fixed in 11.1.4.6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32303

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-25

  • Closed date

    2020-05-07

  • Last modified date

    2020-05-07

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 May 2020