Move sysadmin database
Folks, Build Version: 12.10.FC4W1X1 Build Number: N028 Build Host: lxvm-l172 Build OS: Linux 2.6.18-128.el5 We moved the sysadmin database to an new db space(non-rootdbs) for two instances. Seems it got moved just fine. But, both logs showed some errors ( see details in two logs below) What do you think of these errors? Concerned or not ? Thanks Frank ------------Instance 1 02:38:35 SCHAPI: thread dbWorker2 task post_alarm_message(15-1473587) shutting down 02:38:35 SCHAPI: thread dbWorker1 task mon_iohistory(64-4522) shutting down 02:38:35 SCHAPI: thread dbScheduler(70) shutting down 02:38:44 SCHAPI: 'sysadmin' database will be moved to 'dbdw00'. See online message log. 02:38:44 Building 'sysadmin' database ... 02:39:03 'sysadmin' database built successfully. 02:39:03 SCHAPI: Started dbScheduler thread. 02:39:03 Auto Registration is synced 02:39:04 Updating Low Memory Manager to version 11 02:39:04 Installing patch to upgrade ph_task code. version(13.04) 02:39:04 SCHAPI: Started 2 dbWorker threads. 02:39:04 SCHAPI Estimate Compression for stores_demo:"informix".raw_container started 02:39:04 Checkpoint Completed: duration was 1 seconds. 02:39:04 Mon Jun 29 - loguniq 97765, logpos 0x21c96340, timestamp: 0xbc49f010 Interval: 438413 02:39:04 Maximum server connections 214 02:39:04 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 9, Plog used 26160, Llog used 33177 02:39:04 ERROR(gettab) Estimate FAILED for index 'stores_demo:"informix".raw_container' - rc -1 iserrno 111. 02:39:04 ERROR: admin_fragment_command('fragment estimate_compression ','1049158') failed 02:39:05 SCHAPI Estimate Compression for noaa:"informix".file_receipt_info started --------------instance 2 02:30:14 Maximum server connections 119 02:30:14 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 18, Llog used 10 02:34:59 SCHAPI: thread dbWorker2 task Low Memory Reconfig(35-16262) shutting down 02:34:59 SCHAPI: thread dbWorker1 task mon_iohistory(68-3756) shutting down 02:34:59 SCHAPI: thread dbScheduler(72) shutting down 02:35:08 SCHAPI: 'sysadmin' database will be moved to 'dbdw00'. See online message log. 02:35:08 Building 'sysadmin' database ... 02:35:14 Checkpoint Completed: duration was 0 seconds. 02:35:14 Mon Jun 29 - loguniq 6806, logpos 0x1003a018, timestamp: 0x6c7cdd3f Interval: 427790 02:35:14 Maximum server connections 119 02:35:14 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 19, Llog used 8 02:35:22 'sysadmin' database built successfully. 02:35:22 SCHAPI: Started dbScheduler thread. 02:35:22 Auto Registration is synced 02:35:22 Updating Low Memory Manager to version 11 02:35:22 Installing patch to upgrade ph_task code. version(13.04) 02:35:22 SCHAPI: Started 2 dbWorker threads. 02:35:22 Checkpoint Completed: duration was 0 seconds. 02:35:22 Mon Jun 29 - loguniq 6806, logpos 0x11047018, timestamp: 0x6c7dc6bf Interval: 427791 02:35:22 Maximum server connections 119 02:35:22 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 325, Llog used 4277 02:35:22 SCHAPI: [mon_table_profile 10-1] Error -1215 Value exceeds limit of INTEGER precision 02:35:22 SCHAPI Estimate Compression for dwh:"informix".fact_order_delivery_idx1 started 02:35:23 SCHAPI Estimate succeeded for index 'dwh:"informix".fact_order_delivery_idx1' partnum 400047. 02:35:23 admin_fragment_command('fragment estimate_compression ','4194375') succeeded ......................... 02:42:11 admin_fragment_command('fragment estimate_compression ','14680084') succeeded 02:42:11 SCHAPI Estimate Compression for dbsbdata00:"informix".LO_hdr_partn started 02:42:11 Unable to find locale, attempting locale en_US.819. 02:42:11 ERROR(ddopendb) Estimate FAILED for table 'dbsbdata00:"informix".LO_hdr_partn' - rc -1 iserrno 111. 02:42:11 ERROR: admin_fragment_command('fragment estimate_compression ','19922949') failed --001a1135d796d6818705199f36d3