IT32303: DB2JDBCBIND COMMAND GENERATES FODC_APPERR FOLDERS

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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

• RB10 PSN

     UP