List of Contributions

Cherry

Contact Details

My Content

1 to 20 of 23 total
Posted By Cherry Tue October 10, 2023 09:25 AM
Found In Egroup: Informix
\ view thread
Hello David, 2K bufferpool is only used for root, logical log and physical log dbspaces only. We have bigger databases(with higher loadd) are running fine with 90% cache in our environment with same setting. ------------------------------ Cherry ------------------------------
Posted By Cherry Tue October 10, 2023 09:21 AM
Found In Egroup: Informix
\ view thread
Hello Mike, I think it should at least show some number instead of 0. i see only default BUFFERPOOL is available in onconfig file. should i explicitly mention BUFFERPOOL for 2K as below in onconfig file? BUFFERPOOL default,buffers=10000,lrus=8,lru_min_dirty=50.00,lru_max_dirty=60.50 ...
Posted By Cherry Tue October 10, 2023 08:20 AM
Found In Egroup: Informix
\ view thread
Hello, i was just wondering why read and write caches are showing 0% utilization even though we allocated 20mb for this default bufferpool to one of our informix instances. And buffer turnover ration is around 950 for 2K page size. we have not seen this behavior in other instances. any thoughts? ...
Posted By Cherry Thu May 18, 2023 09:05 AM
Found In Egroup: Informix
\ view thread
Hello, I got little confused after going through installation documentation. Someone please clarify. https://www.ibm.com/docs/en/informix-servers/14.10?topic=installation-system-requirements Do we need to install Java 1.8 version(Licensed) in server before proceeding with installation of Informix ...
Posted By Cherry Mon May 15, 2023 02:46 PM
Found In Egroup: Informix
\ view thread
Hello Andreas, Yes, It worked. you saved my day. :) RSS is getting sync now. 20:04:00 Logical Recovery Started. 20:04:00 20 recovery worker threads will be started. 20:04:00 Start Logical Recovery - Start Log 16926, End Log ? 20:04:00 Starting Log Position - 16926 0x270a018 20:04:00 DR: ...
Posted By Cherry Mon May 15, 2023 12:04 PM
Found In Egroup: Informix
\ view thread
Hello, We have issue with comvault today and primary informix instance logical backup stopped which led to logical log full and stopped instance. As quick solution, i have taken manual log backup with ontape -a -d which backed up log files to local directory. server was bounced once to fix the issue ...
Posted By Cherry Tue February 22, 2022 06:54 AM
Found In Egroup: Informix
\ view thread
Hello, /etc/hosts.equiv is getting cached during Informix startup. when we make changes to this file on server, is there any way to load this file into Informix without bouncing the instance? ------------------------------ Cherry ------------------------------
Posted By Cherry Mon February 21, 2022 10:02 AM
Found In Egroup: Informix
\ view thread
Ok.. i found it is a good suggestion to add the ip, the host name and the FQDN to hosts.equiv file. ------------------------------ Cherry ------------------------------
Posted By Cherry Mon February 21, 2022 09:14 AM
Found In Egroup: Informix
\ view thread
Hello Paul, only host name is mentioned in hosts.equiv file and however it is matching with output of onstat -m. ------------------------------ Cherry ------------------------------
Posted By Cherry Mon February 21, 2022 08:54 AM
Found In Egroup: Informix
\ view thread
Hello, We are receiving err -956 error when we connect from one informix instance to another. It is working for long time and suddenly this error started showing up. No changes are made in any files(/etc/hosts.equiv or sqlhosts) by Unix or DBA teams. We fixed the issue once by bouncing one DB ...
Posted By Cherry Thu February 10, 2022 10:59 AM
Found In Egroup: Informix
\ view thread
Hello Art, Perfect. Your reply clarified my doubt. Now i can calculate and test increasing CPU VPs with your formula. CPU(s): 3 On-line CPU(s) list: 0-2 Thread(s) per core: 1 Core(s) per socket: 1 Socket(s): 3 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 79 Model name: ...
Posted By Cherry Thu February 10, 2022 09:41 AM
Found In Egroup: Informix
\ view thread
Hello Fabrice, Thanks for your reply. FYI, There are no other informix instance running on this server and It is VM with no multi threading(i checked with lscpu command). it has 3 CPU allocated. However i see CPU utilization is quite normal only(<10%) for most of the time. I understand KAIO is ...
Posted By Cherry Wed February 09, 2022 06:55 AM
Found In Egroup: Informix
\ view thread
Hello I see low efficiency for CPU VP for one of my production servers. I wonder what it does mean. 2 CPU VPs are sufficiently doing their job or more CPU VP is required. How does this number(Eff %) useful in calculating Instance performance? Although user is not complaining about any performance ...
Posted By Cherry Tue March 09, 2021 10:36 AM
Found In Egroup: Informix
\ view thread
Hello, I am configuring InformixHQ for my production databases. Informix instances are on running on v12.10FC8. We don't have separate Java 1.8 installed on the server. I cannot use the JRE1.7 that comes with Informix v12.10FC8. So I found Java 1.8 under available under Symantec software binaries ...
Posted By Cherry Mon June 22, 2020 11:03 AM
Found In Egroup: Informix
\ view thread
Test-NetConnection succeeded. PS> Test-NetConnection -ComputerName "dxxxxx" -InformationLevel "Detailed" -Port 1525 ComputerName : dcxxxx RemotePort : 1525 ............ TcpTestSucceeded : True ------------------------------ Cherry ------------------------------
Posted By Cherry Mon June 22, 2020 10:31 AM
Found In Egroup: Informix
\ view thread
Tried IP Address, but no luck. Could not connect to Informix: jdbc:informix-sqli://1x.xxx.xxx.xx:1525: sysmaster. Socket connection to server (1x.xxx.xxx.xx:1525) failed. ------------------------------ Cherry ------------------------------
Posted By Cherry Mon June 22, 2020 10:10 AM
Found In Egroup: Informix
\ view thread
Hello Rana, Issue was intermittent. I was able to add chunk on later run. issue may be related to network drop or RSS acknowledgement failure. ------------------------------ Cherry ------------------------------
Posted By Cherry Mon June 22, 2020 08:06 AM
Found In Egroup: Informix
\ view thread
Hello, I have installed informix 12.10.FC14 and created informix instance in windows 2016 server. This setup is to be used for InformixHQ Tool. I have logged into informixhq and tried to add same machine. After providing Informix server name, host name and port, the server status is showing offline ...
Posted By Cherry Tue April 28, 2020 02:34 PM
Found In Egroup: Informix
\ view thread
Yeah.. I doubt any network issues like packet drop/communcation failure at the moment, may be reason for that error ------------------------------ Cherry ------------------------------
Posted By Cherry Mon April 27, 2020 03:24 PM
Found In Egroup: Informix
\ view thread
Yes Art, Chunks are created with correct privileges on both primary and RSS server before I trigger the command. I did nothing in between onspace command runs... ------------------------------ Cherry ------------------------------