IT35908: SCHAPI: SQL ERROR -530, ISAM ERROR 0 IN $INFORMIXDIR/ETC/SYSADMIN/UPGRADE_PH_TASK.SQL AT LINE 817 WHILE MIGRATING < 12.10.XC10

APAR status

• Closed as program error.

Error description

• When migrating from previous 12.10.xC10 to 14.10.xC5
  
  15:41:20  processing sysadmin
  15:41:20  *** entity_ver=35  targetVersion=39  indexVersion= 0
  ***
  15:41:20  *** FromVersion=30  ToVersion=31 entity_ver=35
  targetVersion=39 indexVersion=0 ***
  15:41:20  *** FromVersion=31  ToVersion=32 entity_ver=35
  targetVersion=39 indexVersion=1 ***
  15:41:20  *** FromVersion=32  ToVersion=33 entity_ver=35
  targetVersion=39 indexVersion=2 ***
  15:41:20  *** FromVersion=33  ToVersion=34 entity_ver=35
  targetVersion=39 indexVersion=3 ***
  15:41:20  *** FromVersion=34  ToVersion=35 entity_ver=35
  targetVersion=39 indexVersion=4 ***
  15:41:20  *** FromVersion=35  ToVersion=36 entity_ver=35
  targetVersion=39 indexVersion=5 ***
  15:41:20  *** SQL 4 12.10.xC8 ***
  15:41:20  Converting database sysadmin ...
  15:41:20  The database sysadmin has been converted successfully.
  15:41:20  *** FromVersion=36  ToVersion=37 entity_ver=36
  targetVersion=39 indexVersion=6 ***
  15:41:20  *** SQL 4 14.10.xC1 ***
  15:41:20  Converting database sysadmin ...
  15:41:20  The database sysadmin has been converted successfully.
  15:41:20  *** FromVersion=37  ToVersion=38 entity_ver=37
  targetVersion=39 indexVersion=7 ***
  15:41:20  *** SQL 4 14.10.xC2 ***
  15:41:20  Converting database sysadmin ...
  15:41:20  The database sysadmin has been converted successfully.
  15:41:20  *** FromVersion=38  ToVersion=39 entity_ver=38
  targetVersion=39 indexVersion=8 ***
  15:41:20  *** SQL 4 14.10.xC2 ***
  15:41:20  The dummy updates succeeded while converting database
  sysadmin.
  ......
  
  15:41:31  Updating Low Memory Manager to version 11
  15:41:31  Installing patch to Low Memory Manager code.
  version(11.01)
  15:41:31  SCHAPI: SQL Error -530, ISAM Error 0 in file
  /External/prods/14.10/FC5/etc/sysadmin/upgrade_ph_task.sql at
  line 817
  15:41:31  SCHAPI: 'sysadmin' database setup is incomplete.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 14.10.xC6.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 14.10.xC6 (when available).       *
  ****************************************************************
  

Problem conclusion

• Upgrade to Informix Server 14.10.xC6 (when available).
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels