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 number
IC89618
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B70
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-01-17
Closed date
2014-05-08
Last modified date
2024-09-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 September 2024