Save 
Join IIUG
 for   
 

Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read


End of Support Dates

IIUG on Facebook IIUG on Twitter

RSS Feed: IDS Forum: IDS

More IIUG RSS Feeds

The IDS Forum is a discussion forum to communicate about all aspects of the Informix Dynamic Server (IDS) Engine


URL: http://www.iiug.org/rss/ids.rss

Below is the latest content available from this feed:

Re: Don't Understand Table's Space Requirement
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Fri, 25 May 2018 19:33:57 EDT
Original post:



Thank you, Mr. Renaut, for your helpful reply.



I did an 'oncheck -pt'. Here is the output for the table, itself. (You'll note

that my previous numbers were rounded to "nice" values for convenience.)



I don't understand the huge difference between the "Number of pages used" and

the "Number of data pages".



TBLspace Report for acoms:informix.cnote



Physical Address 1:3324981

Creation date 10/26/2016 16:28:07

TBLspace Flags 901 Page Locking

TBLspace contains VARCHARS

TBLspace use 4 bit bit-maps

Maximum row size 10039

Number of special columns 1

Number of keys 0

Number of extents 1

Current serial value 1376126

Current SERIAL8 value 1

Current BIGSERIAL value 1

Current REFID value 1

Pagesize (k) 2

First extent size 614400

Next extent size 122880

Number of pages allocated 829440

Number of pages used 826911

Number of data pages 174019

Number of rows 316470

.... some stuff cut out...



Response:



So the difference you are talking about would be cleared up more I believe if

you ran oncheck -pT. It scans all the pages and counts up the types. It holds

a 'S' lock on the partition while doing this so it can either run into locks

(and consequently not run) or could impact users on the table so it's best to

run at low usage times). So there's maybe 1 of 2 things happening. One would

be the other used pages that aren't data pages are remainder pages (which

would be where you would expect rows > 1 page to be split up upon). So if that

was happening, that could be a problem with the server reserving too much

space for the lvarchars. The second option would be the table was maybe much

larger at some point and rows were deleted. I believe in that case, we do not

decrement the number of pages used, so that's a record of how big the table

once was and 1 way to tell how many pages are really being used is to examine

the oncheck -pT output.



Here's the portion of oncheck -pT output you would be interested in:



TBLspace Usage Report for mydb:informix.systables



Type Pages Empty Semi-Full Full Very-Full



---------------- ---------- ---------- ---------- ---------- ----------



Free 1



Bit-Map 1



Index 6



Data (Home) 8



Data (Remainder) 0 0 0 0 0



----------



Total Pages 16



(eh bad formatting)



So for option 1 I mentioned I think you would see a large number of the "Data

(Remainder)" pages. For option 2, you would see a large number of "Free"

pages.



In option 2's case, those pages will be reused by the table, but it's a bit

harder to tell how much more data this table could hold before it tried to

extend, and it would seem like server studio is looking either at the number

of pages used or the number of pages allocated to determine it's size.



One way to reduce the number of pages used if they are "Free" would be to use

the table re-org sysadmin tasks. I think repack would move the rows to the

beginning of the table's extent and reduce the number of pages used.



Jacques Renaut

HCL Informix Advanced Support









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41119]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Upgrading from 12.10.FC3?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 25 May 2018 19:07:37 EDT
I'm thinking that it's about time to upgrade. In the recent year, I've run

into a couple things that tech support says are probably fixed in newer

releases, plus tech support told me that they do not have access to 12.10.FC3,

and, therefore, could not attempt to replicate an issue I had. (An example of

paying for tech support, but the tech support could not fully "deliver".)



I wonder... given that we've waited so long, am I about to upgrade to

12.10.XC10, only to have a major release, soon?



Of course, I realize that the folks here that really know are not at liberty

to say. But, I wonder if there are any "public" rumors floating around as to a

timeframe for a major release.



Speculation welcome.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41118]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Don't Understand Table's Space Requirement
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 25 May 2018 18:51:58 EDT
Thank you, Mr. Renaut, for your helpful reply.



I did an 'oncheck -pt'. Here is the output for the table, itself. (You'll note

that my previous numbers were rounded to "nice" values for convenience.)



I don't understand the huge difference between the "Number of pages used" and

the "Number of data pages".



TBLspace Report for acoms:informix.cnote



Physical Address 1:3324981



Creation date 10/26/2016 16:28:07



TBLspace Flags 901 Page Locking



TBLspace contains VARCHARS



TBLspace use 4 bit bit-maps



Maximum row size 10039



Number of special columns 1



Number of keys 0



Number of extents 1



Current serial value 1376126



Current SERIAL8 value 1



Current BIGSERIAL value 1



Current REFID value 1



Pagesize (k) 2



First extent size 614400



Next extent size 122880



Number of pages allocated 829440



Number of pages used 826911



Number of data pages 174019



Number of rows 316470



Partition partnum 1053310



Partition lockid 1053310



Extents



Logical Page Physical Page Size Physical Pages



0 1:14554511 829440 829440









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41117]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Don't Understand Table's Space Requirement
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Fri, 25 May 2018 16:13:51 EDT
Original post:



IDS 12.10.FC3

Solaris 10 1/13



Consider a table with 11 columns. 10 of the columns are various "usual"

datatypes, and those 10 columns take 39 bytes. The eleventh column is type

LVARCHAR(10000).



The table contains 300,000 rows. In 99.9% of the rows (299,700), the LVARCHAR

column has LENGTH < 1,950, meaning that the entire row should fit on a single

page (using default page size = 2K, and have MAX_FILL_DATA_PAGES = 1) the

overwhelming majority of the time.



Only 300 rows have the LVARCHAR column greater than 1,950, and only 3 rows

exceed LENGTH 5,000.



The SUM( LENGTH( <the_lvarchar_col> ) ) for the whole table is 30 MB (.03GB),

and the remaining columns (39 bytes) should take up roughly .01MB.



Yet, as shown in Server Studio, the table requires >1.5GB (approx 1,500MB).



This seems like basic DBA material, but I don't understand why the table is

taking up 50 times more space than it seems like it should.



Might anyone offer an explanation?



Thank you.



DG



Response:



It sounds like a bug. I did a quick test on 12.10.FC11 using using a 2 column

table, a char(39) and a lvarchar(10000) and I inserted like 15 rows, and

according to oncheck -pT all my rows are still on a single page (as expected,

I used small lvarchars). For your table to be 1.5Gb it almost seems like

server studio is taking max row size (so like a bit over 10k) and just

multiplying that by the number of rows. I don't know how server studio is

getting it's size...but what does oncheck -pt say for the number of pages

allocate/used/number of data pages? As I don't know if it is a server defect

or something odd that server studio is doing.



Jacques Renaut

HCL Informix Advanced Support









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41116]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Don't Understand Table's Space Requirement
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 25 May 2018 15:16:48 EDT
P.S. About 2% of the LVARCHAR values are between 1K and 5K, and 98% less than

1K.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41115]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Don't Understand Table's Space Requirement
Posted by: david.grove@alaska.gov (DAVID GROVE) - Fri, 25 May 2018 13:38:00 EDT
IDS 12.10.FC3

Solaris 10 1/13



Consider a table with 11 columns. 10 of the columns are various "usual"

datatypes, and those 10 columns take 39 bytes. The eleventh column is type

LVARCHAR(10000).



The table contains 300,000 rows. In 99.9% of the rows (299,700), the LVARCHAR

column has LENGTH < 1,950, meaning that the entire row should fit on a single

page (using default page size = 2K, and have MAX_FILL_DATA_PAGES = 1) the

overwhelming majority of the time.



Only 300 rows have the LVARCHAR column greater than 1,950, and only 3 rows

exceed LENGTH 5,000.



The SUM( LENGTH( <the_lvarchar_col> ) ) for the whole table is 30 MB (.03GB),

and the remaining columns (39 bytes) should take up roughly .01MB.



Yet, as shown in Server Studio, the table requires >1.5GB (approx 1,500MB).



This seems like basic DBA material, but I don't understand why the table is

taking up 50 times more space than it seems like it should.



Might anyone offer an explanation?



Thank you.



DG









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41114]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

12.10.xC11 release notes
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Fri, 25 May 2018 10:35:37 EDT
Hi,



Does anyone have or have a link to the 12.10.xC11 release notes?



Looking in the usual places, the links on the IBM site seem to be in need of

an update since they only go up to xC9:

http://www-01.ibm.com/support/docview.wss?uid=swg27014361

and



https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.relnotes.doc/relnotes_ifx.htm



However the 12.10.xC10 notes can be found here:

http://www-01.ibm.com/support/docview.wss?uid=swg27049837



Ben.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41113]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: SHARED MEMORY ALLOCATION
Posted by: lpolicarpio2009@yahoo.com (LESTER POLICARPIO) - Fri, 25 May 2018 03:26:53 EDT
Hi Benjamin,



I know that these parameters need tuning and analysis before we can give a

definitive value for them but I appreciate the time and effort you gave to

post you experience since this is what I've been looking for. We have a same

specs server of the production used for testing but I guess I can never really

achieve the output we receive from the prod to the testing server that is why

I need a baseline to check that I am on the right path on this.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41112]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: SHARED MEMORY ALLOCATION
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Thu, 24 May 2018 06:44:10 EDT
It's not really possible to give answers to your questions in anything other

than general terms.



SHMTOTAL limits the size of the instance and the only restriction is that it

must be greater than the size of the instance at start up. I certainly thinks

it makes sense to set it (rather than leave it at 0) since it can avoid

Informix allocating more memory than is available on your server. If this is a

dedicated Informix server you might be able to push SHMTOTAL to 10 GB in your

case as 2 GB ought to be sufficient for the OS. The initial size of your

instance would be smaller of course.



On the systems I run I try to avoid any dynamic virtual segment allocation: it

is often difficult/impossible to ever reclaim space added without an instance

restart or disconnecting most/all sessions. SHMVIRTSIZE only needs to be as

big as you need to support your applications. The only way to know what you

need is to monitor it and see what is actually used over time and then add a

safety margin on top.



BUFFERPOOLs: make them as large as possible. Knowing how big SHMVIRTSIZE needs

to be for your system helps a lot in this regard.



Do you use PDQ a lot? DS_TOTAL_MEMORY can be 50% of SHMVIRTSIZE if you want. I

don't think the engine reserves this memory. Someone might correct me on this.



Your DS_NONPDQ_QUERY_MEM is quite aggressive IMHO as every session not using

PDQ (or doing a non-parallel operation) can potentially use up to this amount

of memory. There is no limit on sessions running concurrently, unlike with PDQ

queries which can use the memory grant manager. It may be suitable for your

system however, if you don't have many sessions or it is a warehouse system.



HTH. Ben.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41111]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: row limit for fragment table with rowids
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Wed, 23 May 2018 15:33:26 EDT
Original post:



Hi,



What is number of rows limit for fragmented table created with rowids option?

I'm using IDS 11.50FC.



Regards,

Direk



Response:



The documentation states that the with rowid option is using an extra 4 bytes

of storage, so I'm going to assume integer. Based on that, I would expect the

limit to be 4294967295 rows and once you go above 2147483647 rows, the rowids

could possibly flip to be printed as negative numbers (I'm not sure if it's

going to be treated as a signed or unsigned integer). But since it's backed up

by a unique index, that would be the limit to the number of rows you could

have total in the fragmented table.



Jacques Renaut

HCL Informix support









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41110]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

JDBC
Posted by: aguilar_95@hotmail.com (RAFAEL AGUILAR) - Wed, 23 May 2018 12:03:44 EDT
Hi.



I need you help.



Where I can get these packages ? :



IBM_Informix_GLS_InstallLog

IBM_Informix_JDBC_Driver_InstallLog

IBM_Informix_Software_Bundle_InstallLog



Are they in the iconnect or SDK?

but then, as they are called to look for them.



thansk in advance for your help.



from mexico.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41109]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

row limit for fragment table with rowids
Posted by: direk@intelligence.co.th (DIREK PHAISITWANITKUL) - Tue, 22 May 2018 23:56:54 EDT
Hi,



What is number of rows limit for fragmented table created with rowids option?

I'm using IDS 11.50FC.



Regards,

Direk









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41108]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

SHARED MEMORY ALLOCATION
Posted by: lpolicarpio2009@yahoo.com (LESTER POLICARPIO) - Tue, 22 May 2018 02:20:17 EDT
Hi,



Can I ask your opinion regarding memory allocation in informix 12.10 running

on AIX 7?



Total Server Memory is 12 Gig

I was planning on leaving 4 Gig on the server and 8 Gig to be put in Shared

Memory



SHMTOTAL = 8192000

BUFFERPOOL (50% of SHMTOTAL) = 4096000

SHMVIRTSIZE (25% of the remaining available in SHMTOTAL) = 2048000

DS_TOTAL_MEMORY (50% of SHMVIRTSIZE) = 1024000

DS_NONPDQ_QUERY_MEM (50% remaining of SHMVIRTSIZE) = 1024000



so I still have 25% remaining on SHMTOTAL do I still need to configure this

space on other config or just put it equally on above parameters? Or is this a

good or bad approach?









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41107]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: informixhq agent start problem
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Mon, 21 May 2018 07:54:48 EDT
Here the informixhq-agent is trying to create a web socket to the

informixhq-server. This is configured via the server.host and server.port

parameters. This should be straightforward and will work if the

informixhq-server is listening on this port, which it will be if it is running

and parameter httpPort or httpsPort is set to 1526.



I suspect you may have misconfigured the agent by mixing up the parameters -

apologies if not - and you creating a web socket (ws) to your Informix

instance and not your informixhq-server. The agent needs three connections

(Informix instance to be monitored, Informix metrics repository and

informixhq-server) and there are separate parameters for each.



If this isn't the case I'd check network connectivity by trying to open a

socket yourself from the machine on which the agent is running using "telnet",

"curl" or similar.



HTH



Ben.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41106]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Recovery mode stucked
Posted by: john.tran@fortsol.com (JOHN TRAN) - Mon, 14 May 2018 15:21:13 EDT
Hi All Informix experts.



I am just starting to work with Informix.



Our Informix was undergoing a reboot and I am trying to bring it up. I am

running into the errors below, where the server is stuck in Recovery mode.



Can someone please let me know what I would need to do to overcome the errors

below.



Any suggestions, would be greatly appreciated.



Thank you very much..



Thanks,

John



11:54:26 Event alarms enabled. ALARMPROG =

'/opt/SGA316-H4-00/informix/etc/no_log.sh'

11:54:26 Booting Language <c> from module <>

11:54:26 Loading Module <CNULL>

11:54:26 Booting Language <builtin> from module <>

11:54:26 Loading Module <BUILTINNULL>

11:54:31 Requested shared memory segment size rounded from 368KB to 1024KB

11:54:31 IBM Informix Dynamic Server Version 9.30.FC6X9 Software Serial Number

AAD#J370876

11:54:32 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.



11:54:32 DR: Logs already cleared

11:54:32 Physical Recovery Started at Page(2:1263).

11:54:32 Physical Recovery Complete: 112 Pages Examined 112 Pages Restored.



11:54:33 DR: Trying to connect to primary server = dr_tlia

11:54:33 Dataskip is now OFF for all dbspaces

11:54:33 Restartable Restore has been ENABLED

11:54:33 Recovery Mode









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41105]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: listener-thread@soc_be.c:3073: err = -25582:
Posted by: karthikrajan1983@gmail.com (KARTHIK RAJAN) - Mon, 14 May 2018 07:12:59 EDT
Hi Ben,



The issue was a repeating query in rollback state which caused the network

broken error.



Thanks for your support.



Regards,

Karthik Rajan









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41104]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: informixhq agent start problem
Posted by: mukeshbt1328@gmail.com (Mukesh) - Fri, 11 May 2018 03:08:46 EDT
The following e-mail was sent to you via IDS Forum from Mukesh (mukeshbt1328@gmail.com) at IP address 183.82.101.158 (broadband.actcorp.in).







Re: informixhq agent start problem



Hello

Did the issue is solved?

informixHQ agent start







* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: []



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: listener-thread@soc_be.c:3073: err = -25582:
Posted by: karthikrajan1983@gmail.com (KARTHIK RAJAN) - Fri, 11 May 2018 02:33:30 EDT
Thanks Ben .









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41103]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: listener-thread@soc_be.c:3073: err = -25582:
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Thu, 10 May 2018 12:19:41 EDT
The message will be seen whenever something connects to your Informix listener

and disconnects without following the Informix SQLI protocol. This could be

more or less anything like the telnet or curl client utilities or any program

that opens a socket and disconnects.



Whether telnet-server is running/blocked on your server is not relevant.



Ben.









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41102]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: listener-thread@soc_be.c:3073: err = -25582:
Posted by: karthikrajan1983@gmail.com (KARTHIK RAJAN) - Thu, 10 May 2018 10:28:44 EDT
Thanks Ben for your response .



But telnet is blocked on our server is any other way we get this error.



Regards,

Karthik Rajan









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41101]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Thanks Ben for your response .



But telnet is blocked on our server is any other way we get this error.



Regards,

Karthik Rajan









* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *



To post a response via email (IIUG members only):



1. Address it to ids@iiug.org

2. Include the bracketed message number in the subject line: [41101]



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

 
Subscribe to this feed
You can subscribe to this RSS feed in a number of ways, including the following:

Drag the orange RSS button into your News Reader

Drag the URL of the RSS feed into your News Reader

Cut and paste the URL of the RSS feed into your News Reader v