List of Contributions

Kate Tomchik

Contact Details

My Content

1 to 11 of 11 total

Excessive logging in version 12.10

Posted By Kate Tomchik Tue April 11, 2023 12:32 PM
Found In Egroup: Informix \ view thread
Hey all, We recently upgraded from 11.70FC7 to 12.10FC13. During the upgrade I created new log space with logs that were twice as big as they were in 11.70. Despite that change, the amount of logging has increased on the server. Does anyone know of a feature in 12.10 that might be creating the additional ...

RE: shmget: [ENOSPC][28]: key 525f4802: The server could not allocate shared memory because an operating system limit was reached

Posted By Kate Tomchik Mon November 28, 2022 05:22 PM
Found In Egroup: Informix \ view thread
Share memory is running crazy /home/informix> onstat -g seg IBM Informix Dynamic Server Version 12.10.FC13 -- On-Line -- Up 3 days 06:55:28 -- 302260 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 1015815 525f4801 44000000 13893632 601096 R 3392 0 1048584 525f4802 ...

RE: shmget: [ENOSPC][28]: key 525f4802: The server could not allocate shared memory because an operating system limit was reached

Posted By Kate Tomchik Mon November 28, 2022 05:05 PM
Found In Egroup: Informix \ view thread
Redhat 6 and I have already confirmed we have all the Kernel paramaters set as the release notes say. -- Thanks, Kate Tomchik She/Her/Hers Principal Systems Engineer, Database Solutions The Home Depot Cell: 678-427-4914 (Text preferred) For non-urgent requests create a TICKET: ...

shmget: [ENOSPC][28]: key 525f4802: The server could not allocate shared memory because an operating system limit was reached

Posted By Kate Tomchik Mon November 28, 2022 04:04 PM
Found In Egroup: Informix \ view thread
Hey gurus, What do I need to increase to allow the database the ability to add additional virtual memory segments? HCL person could not answer my question when I opened the case and I have dozens of servers getting the same message. -- Thanks, Kate Tomchik She/Her/Hers Principal Systems ...

4GE 7.50 to 7.51.FC2

Posted By Kate Tomchik Mon May 09, 2022 05:02 PM
Found In Egroup: Informix \ view thread
Does anyone know if you can upgrade the Informix 4GE to 7.50.FC6 to 7.51.FC2 just by installing the binaries there? I know HCL said we had to recompile to go to 7.51.FC3 because it was build with 4.50 CSDK, but 7.51.FC2 was built with 4.10 CSDK. -- Thanks, Kate Tomchik She/Her/Hers Principal ...

RE: Smartblob spaces

Posted By Kate Tomchik Thu March 31, 2022 11:56 AM
Found In Egroup: Informix \ view thread
Yes I know which table is causing the problem (see details below). We can purge this table of old records, but it still shows the s001 dbspace as 100% full, so the clobs are either 1) not being removed or 2) not being reorged/repacked/shrinked (whatever it is for blobs) to show the space is now free. ...

RE: Smartblob spaces

Posted By Kate Tomchik Thu March 03, 2022 11:26 AM
Found In Egroup: Informix \ view thread
You working for Russia now Paul? ------------------------------ Kate Tomchik ------------------------------

Smartblob spaces

Posted By Kate Tomchik Wed March 02, 2022 12:10 PM
Found In Egroup: Informix \ view thread
Hey all, We have a smart blob space that has reached 100% for a vendor package TWS. We don't know what is in this space. If this was a data space, we would repack and shrink. If it was an index space we would drop and rebuild some of the larger indexes. Is there anything like this you can do to a ...

RE: Questions about the CVE-2021-44228 vulnerability

Posted By Kate Tomchik Mon December 13, 2021 03:09 PM
Found In Egroup: Informix \ view thread
What about OAT – can we still use that? We are still on 11.70 here (with extended support). -- Thanks, Kate Tomchik She/Her/Hers Principal Systems Engineer, Database Solutions The Home Depot Cell: 678-427-4914 (Text preferred) Strange, isn't it? Each man's life touches so many other ...

Warning in log file

Posted By Kate Tomchik Fri April 30, 2021 12:28 PM
Found In Egroup: Informix \ view thread
We just upgraded a system from 11.70 to 14.10 Informix on Redhat 7. We are getting a new warning in the log file: 10:56:17 Warning: update statistics low using sampling may generate inaccurate index statistics for index informix.x0prv08u due to data skew 10:56:41 Warning: update statistics low using ...

RE: Performance Issue with Informix 14.10 after migrating to LINUX

Posted By Kate Tomchik Wed March 04, 2020 01:49 PM
Found In Egroup: Informix \ view thread
Was the Solaris on physical hardware? VM performance is always worse than physical hardware. Thanks - Kate Tomchik, Principal Systems Engineer, The Home Depot, (770)437-4949 Home Depot Marietta Technology Center | 2211 Newmarket Parkway | Marietta, GA 30067 The best way to avoid being consumed ...