IC73142: MULTIPLE DBEXPORTS RUNNING CONCURENTLY WILL RESULT IN LOCKING ERRORS ON SYSHA_TYPE & SYSPTNKEY.

APAR status

• Closed as program error.

Error description

• Multiple dbexports running concurrently will result in locking
  errors on sysha_type and sysptnkey:
  
  in one session start dbexport
  
  in another session:
  
  $ dbexport test3
  -242 - Could not open database table
  (sysmaster:informix.sysha_type).
  -113 - ISAM error:  the file is locked.
  { DATABASE test3  delimiter | }
  
  grant dba to "informix";
  grant resource to "public";
  
  
  
  
  
  
  create row type 'informix'.address_t
          (
          address1 char(64),
          city char(32),
          state char(32),
          zipcode integer
          );
  
  
  
  
  
  
  -242 - Could not open database table
  (sysmaster:informix.sysptnkey).
  -113 - ISAM error:  the file is locked.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All platforms                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Multiple dbexports running concurrently, locking errors on   *
  * sysha_type & sysptnkey                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC9                                         *
  ****************************************************************
  

Problem conclusion

• Fix was checked in to 11.50.xC9
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP