IT26025: INTERMITTENT DB21016E AND/OR DB21018E ERROR ON AIX.

APAR status

• Closed as fixed if next.

Error description

• Running Db2 V11.1 on AIX operating system you man encounter
  intermittent errors returned to CLP.  For example you may
  observe the following error messages : 
  
  DB21016E  The Command Line Processor encountered a system error
  while sending
  the command to the backend process.
  DB21018E  A system error occurred. The command line processor
  could not
  continue processing.
  
  In addition the following messages may be logged in the
  db2diag.log file 
  
  2018-08-05-09.00.11.071950-300 E146642A659          LEVEL: Error
  (OS)
  PID     : 27590832             TID : 1              PROC : db2
  INSTANCE: db2inst             NODE : 000
  HOSTNAME: hostname
  EDUID   : 1
  FUNCTION: DB2 UDB, oper system services, sqlowqueInternal,
  probe:40
  MESSAGE : ZRC=0x870F00BB=-2029059909=SQLO_QUE_NO_ACCESS
           "do not have the access right"
  CALLED  : OS, -, msgsnd
  OSERR   : EACCES (13) "The file access permissions do not allow
  the
  specified action."
  DATA #1 : system V message queue identifier.,
  PD_TYPE_SYSV_QUEUE_ID, 4 bytes
  0x29F000AA
  DATA #2 : Pointer, 8 bytes
  0x09001000a198c1e0
  DATA #3 : unsigned integer, 8 bytes
  4176
  
  2018-08-05-09.00.11.095089-300 E147302A656          LEVEL: Error
  (OS)
  PID     : 27590832             TID : 1              PROC : db2
  INSTANCE: db2inst             NODE : 000
  HOSTNAME: hostname
  EDUID   : 1
  FUNCTION: DB2 UDB, oper system services, sqlowqueInternal,
  probe:40
  MESSAGE : ZRC=0x870F00BB=-2029059909=SQLO_QUE_NO_ACCESS
           "do not have the access right"
  CALLED  : OS, -, msgsnd
  OSERR   : EACCES (13) "The file access permissions do not allow
  the
  specified action."
  DATA #1 : system V message queue identifier.,
  PD_TYPE_SYSV_QUEUE_ID, 4 bytes
  0x29F000AA
  DATA #2 : Pointer, 8 bytes
  0x09001000a198c1e0
  DATA #3 : unsigned integer, 8 bytes
  1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * AIX users running Db2 V11.1                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Db2 LUW Version 11.2.                              *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels