JR32193: TABLE TRUNCATION FAILURE DUE TO LOCK ON CATALOG TABLE SYSFRAGMENTS.

APAR status

• Closed as program error.

Error description

• Jobs loading to Informix fails with following message.
  This happens mainly when there are many loading jobs running
  concurrently.
  
     Item #: 38
     Event ID: 803
     Timestamp:: 2008-12-16 17:08:00
     Type: Fatal
     User Name: dsadm
     Message:: O1: ExecuteImmediate failed for:
  truncate  adm_tb_ah_susin.
  
     Item #: 39
     Event ID: 804
     Timestamp:: 2008-12-16 17:08:00
     Type: Fatal
     User Name: dsadm
     Message:: O1: An Informix call failed: sqlcode
  = -211, sqlstate = IX000
  message: Cannot read system catalog (sysfragments).
  .
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Information Server 8.0.1 fp1a on AIX 5.3
  ****************************************************************
  PROBLEM DESCRIPTION:
  table truncation failure due to lock on catalog table
  sysfragments.
  ****************************************************************
  RECOMMENDATION:
  Installed the patch and export the env varibale
  INFX_LOCK_MODE_WAIT.
  patch_JR32193_server_aix_801.tar
  ****************************************************************
  

Problem conclusion

• Fixed. Implemented the code to export environment variable
  called INFX_LOCK_MODE_WAIT
  

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:

Modules/Macros

• INFXEE
  

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R801 PSN

     UP