Oninit® Archive
Results for “onstat -g rss”
onstat -g seg reveals several virtual segments many show a pool summary of 17184.H.sd
This system is running one 14.10.FC11X8 standard server with two RSS servers. For some time onstat -g seg shows an increasing number of virtual segments - we have an alert for a threshold of 10 or more: IBM Informix Dynamic Server Version 14.10.FC11X8AEE -- On-Line -- Up 5 days 2…
Install IBM Informix 15 on openSUSE 16 (Leap) and default java install ... and permissions not set
(Thanks Art ... all good) Got me two clusters up and running across 8 VMs informix@leap16-1-a:~> onstat -g dri IBM Informix Dynamic Server Version 15.0.1.0DE -- On-Line (Prim) -- Up 00:24:31 -- 301120 Kbytes 2026-04-06 19:04:16 -- Infrastructure Version: 1 Data Replication at 0x…
Informix 11.50.FC9W3 assert failed question
Hi, I use Informix 11.50.FC9W3 , it's the newest version on 11.50 . today the RSS SERVER is abnormal terminated. blow are some information from online.log and af file. 1) online.log 00:06:51 Maximum server connections 65 00:06:51 Checkpoint Statistics - Avg. Txn Block Time 0.00…
Resync RSS server
Hello I need to re-initiate synchronization between a primary server and the RSS. They re currently connected, active prim :/prod/dbown>onstat -g cluster ... Server ACKed Log Applied Log Supports Status (log, page) (log, page) Updates ids_tlv_rss 0,0 0,0 No ASYNC(RSS), Connected,…
RSS slowing down
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Today we have a RSS replication slowed down. I mean not froze but just applying logs slower than the primary filling them. That has not happened ever in working hours. Filling pace was not any unusual for the time. After restart…
What prevents a RSS to roll forward as fast as its primary?
David, (a) I was checking `onstat -l | grep C-` while the replica lagging, it showed almost same values as `onstat -g rss verbose`. (b) Could the apply contention be an issue if a single thread performs 99.99% of apply job when lagging? ------------------------------ Sincerely, D…
Ifx 14.10xc8 - ISAM error: operation illegal on a DR Secondary
Hello, I need help for : IBM Informix Dynamic Server Version 14.10.FC8DE -- Updatable (RSS) we are testing an hdr/rss (updatable) configuration and we are getting systematic errors like this on rss : 229: Could not open or create a temporary file. 140: ISAM error: operation ille…
IFX 14.10xc8 Updatable RSS and CPU Usage
Hello, In dev env. i've configured a pimary with 2 rss. there is no user activity and i see a high usage of CPU when a do a onstat -z followed by onstat -g smx i've notice a very high number at #scheds onstat -z; onstat -g cpu | grep smx IBM Informix Dynamic Server Version 14.10.…
Potentially Serious HDR Bug 14.10.FC7W1
All: I wanted to make you aware of something we've hit a couple of times and also find out if someone else has encountered it. Twice in the past few months, I've had DR Ping faliures on our HDR primary which seem to have left the cluster in an unstable state. It's as if the prima…
ontape error
Sorry Sergio, I was away from the keyboard. I haven't read the entire thread so apologies if I type something that's already been discussed. Run this on the node implied in the command prompt... [RSS]$ onclean -ky [RSS]$ onclean -ky [RSS]$ ipcs If you still see any Shared Memo…
Repliction Checking
Dan, IMO not really much you can do other than rely on HDR/RSS faith along with instance monitoring (onstat -g dri , DRLOSTANDFOUND and ALARMPROGRAM). If really concerned consider periodic HDR refreshes if feasible. CDR has cdr check, maybe a feature request for something simil…
Not sure if I have a problem with CKPs
IDS 12.10.FC12 Solaris 10 1/13 I sometimes observe a period of very frequent checkpoints. The system is a primary and there is one RSS. Here is an example of what I observe: informix@ifmx-prod-anc>onstat -g ckp IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 1 …
Take Primary and RSS down and up, w/o reinitialize
David, You should be ok taking either one offline to do non-database work. Before taking them down run onmode -c norm on the primary to force the checkpoint so they are in sync. Also check onstat -g rss verbose on the primary to make sure the RSS server is not way behind. Look …
Updatable Secondary (RSS)
Informix 12.10.C3 Solaris 10 1/13 I would like to make a read-only RSS updatable, so I can do a dbexport. I have done this in the past. However, this time, I can't seem to make it updatable. I do the following: 1) Take the read-only RSS offline. 2) Edit UPDATABLE_SECONDARY par…
Checkpoints statistics
Hello. What kind of cluster do you have? HDR? SDS? RSS? Seems you might be facing lag on primary because of misconfigured cluster. Is this a new installation, or an old one? Was it recently upgraded? Please send us some outputs: 1) onstat -g cluster 2) onstat -c What is your…
New RFE entry needs votes
Does the problem exist with buffered logging or only with unbuffered logging? If only with unbuffered logging, then that implies that the risk of the problem occurring increases as the efficiency of the log flush decreases. By efficiency, I mean the number of log records per log …
RSS sync problem 3 pages left in rootdbs
Dear All, Running a production db IDS11.7FC4 on AIX 7.1 Have 2 RSS servers one of them real time the other with 1/2h delay Today I had a problem, I ended up on the production site with 3 free pages on the production server. The RSS sync that has no delay was stopped. I did re…
RSS does not apply logs
hello, I have the following situation. I would be very pleased if somebody could put a light into this. Thanks a lot, JUAN Primary: amc1_rss RSS server: amc4_rss RSS DeLAY_APPLY 5M Why does RSS secondary not apply logs up to 116024, having long past the 5 minutes delay config…
LOGBUFF Setting
Since you are running unbuffered logging, in all probability you are not performing IO on a full log buffer. That means that a larger log buffer size does not impact either the risk or IO performance. The only impact would be memory. You can see this by running onstat -l. Chances…
Rss impacting performance
The rss_flow control is disabled and the backlog is 0 from onstat -g rss verbose, is there any way to diagnose thats the problem is coming from the rss even if when I disconnect the rss server evrything is normal now, and my IIS is working perfect no more pages are quued in IIS …
RSS server is not active / Can not establish RSS -
In the ONCONFIG file on the secondary set LOG_INDEX_BUILDS to '1' and try again. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are m…
Informix RSS Monitoring
Hi, We are running Informix 11.70.FC7W2 on Solaris. We are setting up a read-only RSS node to our primary. We want to setup some monitoring to see if the RSS node is keeping up the with primary. Any way to get some of the information via a query that is similar to the onstat -g …
RSS not working
I have RSS running on other instances same ids ver, and aix. -bash-4.2$ onstat -g rss verbose IBM Informix Dynamic Server Version 11.50.FC9 -- Read-Only (RSS) -- Up 8 days 00:49:44 -- 1200896 Kbytes RSS Server control block: 0x700000031591cb8 Local server type: RSS Server Stat…
Mutex - guard ?
Hi David , I've checked my history of emails and this is what I have : - There is no FIX , only a suggestion for workaround. - The problem occur with exclusive with Power7 processors using SMT-4 configuration What they was explained , this is because of internal architecture…
Checkpoints slowing down the insert on Primary
Hello. A good starting point to your checkpoint perfomance investigation, would be the output of onstat -g ckp command, could you post it here? Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Tech…
Identifying and clearing table lock in a cluster
Hi, My standard query for identifying table locks looks like this: select ss.sid, ss.username, ss.hostname, ss.tty, trim(dbsname), trim(tabname), keynum, type, owner, sum(waiter) as waiters, count(*) as count from sysmaster:syslocks sl, sysmaster:syssessions ss where ss.sid = s…
DR: Needed to send a ping message but failed. 1
Hi All, I am running IDS 11.70 FC7 on AIX server. I am running primary, HDR (async) and RSS server, I have noticed an increase in the frequency of following messages: DR: Needed to send a ping message but failed. 1 I have checked the network connectivity between primary and s…
DR: Needed to send a ping message but failed. 1
Hi All, I am running IDS 11.70 FC7 on AIX server. I am running primary, HDR (async) and RSS server, I have noticed an increase in the frequency of following messages: DR: Needed to send a ping message but failed. 1 I have checked the network connectivity between primary and s…
syslock on missing session
We resolved the issue. onstat -g ses 31 -> came back with no results on any of the servers. onmode -z 31 -> came back with cannot kill session It appears to us that session 31 is the session from the secondary HDR/RSS to the primary HDR. Looking in the OAT report 'Lock List' we…
Enterprise Replication recovery slow on Solaris
What is the output on the target of onstat -g ath onstat -g rcv full If there was a large backlog on the source node, then most of the transactional backlog would be in stable storage so there could be an i= ssue with reading the replicated transactions from disk. What is the on…
Efficiency of the Informix Virtual Processors
Hi Jason, No Affinity. The configuration what we work the lasts months is 2 CPU VPs for each CORE (where have 4 smt), so... 50% of the virtual AIX CPUs. My change is exactly over this, I try work with 1 CPU VPs for 1 CORE CPU, but I not seen effect over the efficient (onstat -g …
onstat g opn - lockmode
Hi , Ifx 11.50 FC9X6 , AIX 6.1 (with 1 RSS read-only synchronized) Monitoring the instance , I'm trying figure out why one stock historical table persists keep 60% of the table size into buffer pool a few days (checking with onstat -P) (60% = 10GB). So, I'm looking some histori…
RSS with DELAY_APPLY is dog slow!
On Nov 10, 2:52 pm, Nick <milesnmi...@gmail.com> wrote: > Hello, > > Does anyone have experience with RSS and the DELAY_APPLY feature? > > I am running tests, with the end goal to find the best HDR or RSS > setup that will minimize the performance impact on my primary db > server…
HDR & RSS
Hi I have 'installed' primary [ol_xxxx] & an RSS [ol_xxxx02] IDS servers. I was successfully established [add the RSS server] The following 2 lines from primary online.log RSS Server ol_xxx02 - state is now connected Can not send log 6848 After that I gave onbar -r -l on the R…
VPCLASS cpu on sun/oracle M4000 machine
Hi Art, both of them: VPCLASS cpu,num=16,aff=(1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31),noage VPCLASS cpu,num=32,aff=(1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31),noage work (as I told Dave, I understand what I was doing wrong with the VPCLASS syntax). But despite of the fact th…
Problem with HDR
number of cpuvps, value of OFF_RECVRY_THREADS and LOGBUFF output of onstat -l ??? M.P. From: "KHURRAM SHAHZAD" <kshahzad02@i2cinc.com> To: ids@iiug.org Date: 02/20/2011 07:09 AM Subject: Problem with HDR [22840] Sent by: ids-bounces@iiug.org I have upgraded my database …
Why RSS automatically becoms standard?
It is complaining that when it reconnects to the primary that the primary doesn't know that it is an RSS secondary. I suspect you were trying to test RSS reconnection by running onmode -d delete rss on the primary. Wrong test. You should be testing this by either shutting down th…
RE: Failover question (Solved)
In case anyone else wants to know how to do this: When the primary server server1 goes down: 1. Change server2 (the RSS secondary) to a standalone server – onmode -d standard. Once server1 (the old primary) is fixed do the following: 1. (Optional) Stop the connection ma…
DBEXPORT IN RSS NOT WORKS
HELLO!!! We have an environment RSS with IDS 11.50.FC7 on HP-UX 11.11. We want to do our backup method a dbexport on RSS side.. but appears the following message, after set STOP_APPLY=1, we run dbexport database command: "The operation cannot be performed on this RS secondary s…
Backup from RSS server
I am testing on a RSS server setup for the first time. The RSS server will be used to backup the Production databases so that we can restore any one of 4 distinct instances we have on our Development box. Currently we use 'onunload/onload' process to backup/restore Production dat…
How to find out 'mode' of IDS through sysmaster
Hello, Is it possible to find out the mode of the Informix database I have connected to through sysmaster? I have some stored procedures and they need to know what mode the server is in (Primary/Secondary/RSS). Obviously I can do this with 'onstat -' but I need to find this ou…
11.50FC6W1 RSS failed with "Can not send Initial R
onstat -l Check your logical logs. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of Chin, Paul (TSG-OSDO) Sent: Sunday, March 28, 2010 8:03 PM To: ids@iiug.org Subject: 11.50FC6W1 RSS failed with "Can not send Initi.... [19438]…
RSS Appears to stall ?
Lello, Nick wrote: > Here�s an odd one� > > > > We have 4 servers, all Solaris Sparc 64bit --- 2 in site A, 2 in site B > > > > Site A contains a Standalone Server S1 and RSS node S2 > > Site B contains RSS nodes S3 and S4 > > > > S2 and S4 stay nicely in sync with S1 ; S3 RS…
SQLTRACE on HDR Secondary
On Jun 11, 9:42 am, informixdba <informix...@gmail.com> wrote: > Is there a trick to get SQLTRACE to work on the HDR Secondary. > We use our secondary for some read only applications and would like to > be able to analyze the queries with SQLTRACE. This is for HDR, but > also w…
Connection Manager Cluster
Hi, We are facing a couple of problems with Connection manager cluster. We are runing two Connection Manager instances on different machines. And both are grouped in the sqlhosts file of Connection Manager. like g_oltp group - - e=oltp2 oltp ontlitcp 192.168.0.16 9991 g=g_oltp o…
connect through java using group_name con mgr
Kamran: If you want to access all nodes as a group, you could modify and add a mach_group to the oncmsm's sqlhosts as below. g_mach group - - e=ids_net_RSS ids_net_primary ontlitcp 192.168.0.16 sql_net_primary g=g_mach ids_net_secondary ontlitcp 192.168.0.15 sql_net_secondary g…
How to conect Java Aplication using Connection Mgr
Hello, I am unable to connect database using connection manger, setting for connection manager is as follows. Values in password file. ------------------------ ids_net_mcp_test02 - informix informix ids_net_mcp_test_rep02 - informix informix ids_net_mcp_rss1 - informix informix…
SDS_ENABLE - error rootchunk
Hi gurus, I'm using VMWARE with RED HAT 4.4 in a notebook with 2 GB of RAM - Win XP Professional. All of these VMW is builting with 512 MB of RAM. I prepared a teste instance with IDS 11.10.UC2 and in one of the VMW I executed the steps: ontape -s -L 0 (TAPEDEV to disk in a "s…
Re: HDR recommendations
On Aug 25, 3:41 pm, Madison Pruet <mpru...@verizon.net> wrote: > mohitanch...@gmail.com wrote: > > On Aug 25, 4:12 am, Madison Pruet <mpru...@verizon.net> wrote: > >> mohitanch...@gmail.com wrote: > >>> On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: > >>>> mohitan…
HDR recommendations
mohitanchlia@gmail.com wrote: > On Aug 24, 4:15 pm, Madison Pruet <mpru...@verizon.net> wrote: >> mohitanch...@gmail.com wrote: >>> On Aug 24, 9:59 am, Madison Pruet <mpru...@verizon.net> wrote: >>>> mohitanch...@gmail.com wrote: >>>>> On Aug 23, 8:45 pm, Madison Pruet <mpru...@v…
RE: Swap Space on DEC ALPHA with 7.30FC10 Engine
The virtual memory segment is sized so there is no segment allocations, we only have our resident (Buffers) and a single virtual segment. As for the size of swap space, this is a engine only server with 2GB of ram, the entire engine runs within 875MB. This should allow close t…
RE: Swap Space on DEC ALPHA with 7.30FC10 Engine
The Primary Server has 2GB, the Secondary has 1GB, neither has /sbin/swapdefault, so we believe this means we use deferred mode. Also, they are both running Digital UNIX 4.0D, not 4.0G as originally stated. Both boxes have 4 processors, Primary box is a 4100 and the Secondary bo…