IC89618: DBSCHEDULER AND WORKER THREADS FAIL TO START WHEN SYSADMIN IS MOVED TO ITS OWN DBSPACE USING TASK(RESET SYSADMIN) FUNCTIO

APAR status

• Closed as program error.

Error description

• dbScheduler and dbWorker threads fail to start when sysadmin is
  moved to its own dbspace using execute function task("reset
  sysadmin", "<dbspace>");
  
  When the server is initialized sysadmin is built successfully
  and scheduler and worker threads start just fine but when you
  move the
  sysadmin database to its own dbspace it the threads fails to
  start, you will following messages in online.log:
  
  14:02:24  Space 'sadmin' added.
  14:03:46  SCHAPI: thread dbWorker1 task mon_config_startup(3-1)
  shutting down
  14:03:46  SCHAPI: thread dbWorker2 task mon_sysenv(4-1) shutting
  down
  14:03:46  SCHAPI: thread dbScheduler(41) shutting down
  14:03:47  SCHAPI: 'sysadmin' database will be moved to 'sadmin'.
  See online message log.
  14:03:47  Building 'sysadmin' database ...
  14:07:48  Checkpoint Completed:  duration was 0 seconds.
  14:07:48  Fri Dec 14 - loguniq 9, logpos 0x3b6018, timestamp:
  0x2b5a3 Interval: 29
  
  14:07:48  Maximum server connections 1
  14:07:48  Checkpoint Statistics - Avg. Txn Block Time 0.000, #
  Txns blocked 0, Plog used 19, Llog used 4
  
  14:07:48  Increasing # of AIO VPs to 3
  
  14:08:48  SCHAPI: SQL Error -349, ISAM Error 0 in file
  /usr2/support/vijayl/CISCO/1170UC7/etc/sysadmin/db_install.sql
  at line 28
  14:08:48  Error building 'sysadmin' database.
  
  
  you can confirm that the threads didn't start by running onstat
  -g ath
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User who has a server which is running                       *
  * 'sch_init_INFORMIXSERVER.sql' script and also 'reseting      *
  * sysadmin' to a new dbspace at the same time                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC8                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC8
  

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