SDS & update statistics performance
Hi
My situation:
1. I use MACH11 with IDS 11.50FC5W2 on Sun Solaris
On Secondary server UPDATABLE_SECONDARY 0.
2. On SDS server assert and server stop:
15:56:34 Rollforward of log record failed. iserrno = 126
15:56:34 Log Record: log = 4807652, pos = 0x105558, type =
OLDRSAM:HDELETE(41), trans = 2553
15:56:47 Assert Warning: Chunk 5 is being taken OFFLINE.
15:56:47 IBM Informix Dynamic Server Version 11.50.FC5W2
15:56:47 Who: Session(36, informix@bart, 0, 466145ff8)
Thread(120, xchg_1.21, 460b42a68, 1)
File: rsmirror.c Line: 1794
15:56:47 Results: Dynamic Server will block at next checkpoint
15:56:47 Action: Shutdown (onmode -k) or override (onmode -O)
15:56:47 stack trace for pid 7614 written to /var/log/informix/tmp/af.460e681
15:56:47 See Also: /var/log/informix/tmp/af.460e681
15:56:48 Chunk 5 is being taken OFFLINE.
15:56:48 Rollforward of log record failed. iserrno = 126
15:56:48 Log Record: log = 4807652, pos = 0x105558, type =
OLDRSAM:HDELETE(41), trans = 2553
15:56:48 Rollforward of log record failed. iserrno = 101
15:56:48 Log Record: log = 4807652, pos = 0x10d310, type =
OLDRSAM:DELITEM(29), trans = 2553
15:56:48 Rollforward of log record failed. iserrno = 101
....
15:58:08 Checkpoint blocked by down space, waiting for override orshutdown
15:59:09 SDS: Received Shutdown request from elids3, Reason: The SDSserver was shut down because the timeout period, set by the
SDS_TIMEOUT configuration parameter, was exceeded.
15:59:09 DR:Shutting down the server.
15:59:10 IBM Informix Dynamic Server Stopped.
3. Start SDS server.
4. I have performance problem with run update statistics
SQL operator
update statistics high for table ord_l
(comp_line_num,comp_line_num,est_pick_date,fully_allocated,fully_committed,
fully_on_pps,item_num,line_num,line_status,ord_id,ord_l_id,reqst_recpt_date
,shp_acc_id,whse_code)
with SDS - ~ 12 hours
without SDS - ~ 6 hours
Before SDS down - with and without run ~6 hours.
I not created query plan for update statistics.
Please, comment my situation with time of run update statistics.
Thanks