Move sysadmin database

Posted in 2015

Topics: Installation, Setup & Upgrades, Logging & Checkpoints, Cloud, Docker & Containers, Versions, Editions & End-of-Life

FRANK — Mon, 26 Oct 2015 18:47:23 — source: IIUG Forums & Mailing Lists

Folks, IBM Informix Dynamic Server Version 12.10.FC4W1XU Was testing moving sysadmin database out of root dbs, and saw the following errors( detailed attached), 18:39:37 ERROR(gettab) Estimate FAILED for index 'stores_demo:"informix".raw_container' - rc -1 iserrno 111. 18:39:37 ERROR: admin_fragment_command('fragment estimate_compression ','1049193') failed Any comments? Thanks Frank 18:29:37 Checkpoint Completed: duration was 0 seconds. 18:29:37 Mon Oct 26 - loguniq 189591, logpos 0x37d018, timestamp: 0x5557ac94 Interval: 454606 18:29:37 Maximum server connections 0 18:29:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 8, Llog used 2 18:39:24 SCHAPI: thread dbWorker2 task mon_iohistory(26-5) shutting down 18:39:24 SCHAPI: thread dbWorker1 task Low Memory Reconfig(45-3) shutting down 18:39:25 SCHAPI: thread dbScheduler(80) shutting down 18:39:34 SCHAPI: 'sysadmin' database will be moved to 'dberdata00'. See online message log. 18:39:34 Building 'sysadmin' database ... 18:39:37 Checkpoint Completed: duration was 0 seconds. 18:39:37 Mon Oct 26 - loguniq 189591, logpos 0x1295018, timestamp: 0x55588557 Interval: 454607 18:39:37 Maximum server connections 2 18:39:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 264, Llog used 3864 18:39:37 'sysadmin' database built successfully. 18:39:37 SCHAPI: Started dbScheduler thread. 18:39:37 Checkpoint Completed: duration was 0 seconds. 18:39:37 Mon Oct 26 - loguniq 189591, logpos 0x1389018, timestamp: 0x5558931f Interval: 454608 18:39:37 Maximum server connections 2 18:39:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 158, Llog used 244 18:39:37 Auto Registration is synced 18:39:37 Updating Low Memory Manager to version 11 18:39:37 Installing patch to upgrade ph_task code. version(13.04) 18:39:37 SCHAPI: Started 2 dbWorker threads. 18:39:37 SCHAPI: Re-starting 1 dbWorker threads. 18:39:37 SCHAPI: Started 1 dbWorker threads. 18:39:37 SCHAPI Estimate Compression for stores_demo:"informix".raw_container started 18:39:37 ERROR(gettab) Estimate FAILED for index 'stores_demo:"informix".raw_container' - rc -1 iserrno 111. 18:39:37 ERROR: admin_fragment_command('fragment estimate_compression ','1049193') failed 18:39:37 SCHAPI Estimate Compression for noaa:"informix".file_receipt_info started 18:39:40 SCHAPI Estimate succeeded for table 'noaa:"informix".file_receipt_info' partnum a00003. 18:39:40 admin_fragment_command('fragment estimate_compression ','10485763') succeeded 18:39:40 SCHAPI Estimate Compression for noaa:"informix".ds_np_gran_nv_idx1 started 18:39:44 SCHAPI Estimate succeeded for index 'noaa:"informix".ds_np_gran_nv_idx1' partnum b00004. 18:39:44 admin_fragment_command('fragment estimate_compression ','11534340') succeeded 18:39:44 SCHAPI Estimate Compression for noaa:"informix". 917_2520 started --001a114879e228dcbc0523066441

↪ replying to FRANK

Paul Watson — Mon, 26 Oct 2015 19:06:16 — source: IIUG Forums & Mailing Lists

By the name raw_container I am guessing you some TS stuff in the demo. You can't compress containers, this is a known issue, and apart from being irritating nothing to worry about. AFAIK still in FC5 Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Monday, October 26, 2015 1:47 PM To: ids@iiug.org Subject: Move sysadmin database [35948] Folks, IBM Informix Dynamic Server Version 12.10.FC4W1XU Was testing moving sysadmin database out of root dbs, and saw the following errors( detailed attached), 18:39:37 ERROR(gettab) Estimate FAILED for index 'stores_demo:"informix".raw_container' - rc -1 iserrno 111. 18:39:37 ERROR: admin_fragment_command('fragment estimate_compression ','1049193') failed Any comments? Thanks Frank 18:29:37 Checkpoint Completed: duration was 0 seconds. 18:29:37 Mon Oct 26 - loguniq 189591, logpos 0x37d018, timestamp: 0x5557ac94 Interval: 454606 18:29:37 Maximum server connections 0 18:29:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 8, Llog used 2 18:39:24 SCHAPI: thread dbWorker2 task mon_iohistory(26-5) shutting down 18:39:24 SCHAPI: thread dbWorker1 task Low Memory Reconfig(45-3) shutting down 18:39:25 SCHAPI: thread dbScheduler(80) shutting down 18:39:34 SCHAPI: 'sysadmin' database will be moved to 'dberdata00'. See online message log. 18:39:34 Building 'sysadmin' database ... 18:39:37 Checkpoint Completed: duration was 0 seconds. 18:39:37 Mon Oct 26 - loguniq 189591, logpos 0x1295018, timestamp: 0x55588557 Interval: 454607 18:39:37 Maximum server connections 2 18:39:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 264, Llog used 3864 18:39:37 'sysadmin' database built successfully. 18:39:37 SCHAPI: Started dbScheduler thread. 18:39:37 Checkpoint Completed: duration was 0 seconds. 18:39:37 Mon Oct 26 - loguniq 189591, logpos 0x1389018, timestamp: 0x5558931f Interval: 454608 18:39:37 Maximum server connections 2 18:39:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 158, Llog used 244 18:39:37 Auto Registration is synced 18:39:37 Updating Low Memory Manager to version 11 18:39:37 Installing patch to upgrade ph_task code. version(13.04) 18:39:37 SCHAPI: Started 2 dbWorker threads. 18:39:37 SCHAPI: Re-starting 1 dbWorker threads. 18:39:37 SCHAPI: Started 1 dbWorker threads. 18:39:37 SCHAPI Estimate Compression for stores_demo:"informix".raw_container started 18:39:37 ERROR(gettab) Estimate FAILED for index 'stores_demo:"informix".raw_container' - rc -1 iserrno 111. 18:39:37 ERROR: admin_fragment_command('fragment estimate_compression ','1049193') failed 18:39:37 SCHAPI Estimate Compression for noaa:"informix".file_receipt_info started 18:39:40 SCHAPI Estimate succeeded for table 'noaa:"informix".file_receipt_info' partnum a00003. 18:39:40 admin_fragment_command('fragment estimate_compression ','10485763') succeeded 18:39:40 SCHAPI Estimate Compression for noaa:"informix".ds_np_gran_nv_idx1 started 18:39:44 SCHAPI Estimate succeeded for index 'noaa:"informix".ds_np_gran_nv_idx1' partnum b00004. 18:39:44 admin_fragment_command('fragment estimate_compression ','11534340') succeeded 18:39:44 SCHAPI Estimate Compression for noaa:"informix". 917_2520 started --001a114879e228dcbc0523066441 **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

checkpoint