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:

Set tables in memory
Posted by: rvilca@luzdelsur.com.pe (ROGER VILCA) - Thu, 18 Oct 2018 22:39:42 EDT
Hi,

I work with Informix Server and I'm looking for a way to put some tables of

much use in memory and I found this syntax in an old document:



set table <table> memory_resident



When I executed i get:



Memory resident status changed



But in manuals of 11.70 and 12.10 I didn't found this sintaxis.



Is it correct ?



Is there any other way to put some tables in memory ?



Please provide me any clues according your experience.



Thanks in advance.









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



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: [41365]



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

Informix Enterprise gateway Manager
Posted by: jluis.roca@hotmail.com (JUAN ROCA) - Thu, 18 Oct 2018 18:10:52 EDT
Good evening to everybody,



IHAC who claims that since he upgraded to ORACLE12 from ORACLE10, Informix

Enterprise gateway Manager 7.31 is not working.



Configuration:



Informix Dynamic Server 11.50 (32 bits) running on RedHAt Linux 6.9 (64 bits).



The question is:



Does IEGM 7.31 support connection to ORACLE12?



Many thanks in advance.



Juan.









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



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: [41364]



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

Re: IDS 11.70 - Archive detects that page is c....
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Wed, 17 Oct 2018 17:58:24 EDT
Hi,



You should contact IBM support, I have similar problems in the past and they

have recovered the information!



SP









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



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: [41363]



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

Re: IDS 12.10 - temporary dbspaces locked
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Wed, 17 Oct 2018 17:52:39 EDT
Hi Luis,



Thanks for your reply,



I am using this SQL code:



select owner, username, hostname, dbsname, tabname, type

from syssessions s, syslocks l

where sid = owner



and tabname not like "sys%"



it return this:

34015|bduser|joaomendes.dominio.local|tempdbs|TBLSpace|IX|

34015|bduser|joaomendes.dominio.local|tempdbs1|TBLSpace|IX|

36850|bduser|10.212.133.100|tempdbs1|TBLSpace|IX|

36850|bduser|10.212.133.100|tempdbs|TBLSpace|IX|

34015|bduser|joaomendes.dominio.local|tempdbs2|TBLSpace|IX|

36850|bduser|10.212.133.100|tempdbs2|TBLSpace|IX|

27898|bduser|pedrofernandes.dominio.local|tempdbs1|TBLSpace|IX|

27898|bduser|pedrofernandes.dominio.local|tempdbs2|TBLSpace|IX|

29044|bduser|nunobento1.dominio.local|tempdbs1|TBLSpace|IX|

27898|bduser|pedrofernandes.dominio.local|tempdbs|TBLSpace|IX|

29044|bduser|nunobento1.dominio.local|tempdbs|TBLSpace|IX|

29044|bduser|nunobento1.dominio.local|tempdbs2|TBLSpace|IX|



as I don't know much SQL, the instructions are correct?

this is normal? as my temporary dbspaces are empty?



Dbspaces

address number flags fchunk nchunks pgsize flags owner name

88b80028 1 0x4030001 1 1 2048 N BA informix rootdbs

8aba97b8 2 0x2001 2 1 2048 N TBA informix tempdbs

8aba99f8 3 0x2001 3 1 2048 N TBA informix tempdbs1

8aba9c38 4 0x2001 4 1 2048 N TBA informix tempdbs2

8aca5028 5 0x4030001 5 1 2048 N BA informix logdbs

8aca5268 6 0x4020001 6 1 4096 N BA informix dbspace1

6 active, 2047 maximum



Chunks

address chunk/dbs offset size free bpages flags pathname

88b80268 1 1 512 1500000 1445207 PO-B-- /dev/raw/raw1

8aca54a8 2 2 512 4000000 3999947 PO-B-- /dev/raw/raw2

8aca6028 3 3 512 4000000 3999947 PO-B-- /dev/raw/raw3

8aca7028 4 4 512 4000000 3999947 PO-B-- /dev/raw/raw4

8aca8028 5 5 512 4000000 149947 PO-B-- /dev/raw/raw5

8aca9028 6 6 512 37250000 28384458 PO-B-- /dev/raw/raw6

6 active, 32766 maximum



SP









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



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: [41362]



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

Re: IDS 12.10 - temporary dbspaces locked
Posted by: luis-silvestre-marques@telecom.pt (LUIS MARQUES) - Wed, 17 Oct 2018 08:55:09 EDT
Some examples of the "locks" you are seeing would be great.

From the online documentation, the sysmaster:syslocks has no field for

dbspace:



dbsname char(128) Database name

tabname char(128) Table name

rowidlk integer Real rowid, if it is an index key lock

keynum smallint Key number of index key lock

type char(4) Type of lock

owner integer Session ID of the lock owner

waiter integer Session ID of the user waiting for the lock.



Best regards,

Luis Marques









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



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: [41361]



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

IDS 12.10 - temporary dbspaces locked
Posted by: sergio.peres@airc.pt (SERGIO PERES) - Tue, 16 Oct 2018 14:09:44 EDT
Hi,



I have repaired that my systems have several locks over temporary dbspaces on

syslocks. I have seen some information about using RAMDISK to improve

performance. Can somebody give some help about this? How to do it and if it is

the case, how can I detect that kind of concurrency problems?



Thanks in advance,



SP









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



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: [41360]



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

Re: ONMODE -Y on the client side
Posted by: rugamu@hotmail.com (RUBéN GARCíA) - Tue, 16 Oct 2018 09:31:54 EDT
Hi Benjamin,



First of all thanks for the reply. My situation is a little bit different, i

have some proccess on the client side that they're executed when i can not

launch onmode -Y on the server side, some of them are giving problems, and i

want to give the person who launch all the proccess a script for tracing the

proccess he think that they're not running ok, sonm your solution doesn't fit

to me, because i just want to trace few minutes not all the session.



Best regards









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



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: [41359]



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

Re: ONMODE -Y on the client side
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Tue, 16 Oct 2018 04:57:25 EDT
"onmode -Y" turns on SET EXPLAIN for given session. "onmode" isn't distributed

with the client software and connects to an instance's shared memory so is

strictly server only.



Presumably you don't control what the client is doing otherwise the obvious

thing to do would be to run "SET EXPLAIN ON" inside the client's session. You

could instead create a "sysdbopen" procedure to do this when the client logs

on:

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1799.htm

This is the best and only solution I can think of.



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: [41358]



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

IDS 11.70 - Archive detects that page is corrupt
Posted by: fadzil@isianpadu.com (MOHD FADZIL JUSOH) - Fri, 12 Oct 2018 05:28:35 EDT
Hi,



Our database have error during backup. we find this message on af file.



Archive detects that page 11:2897308 is corrupt.



22:22:41 IBM Informix Dynamic Server Version 11.70.FC1 Software Serial Number

AAA#B000000



22:22:41 Assert Warning: Archive detects that page 11:2897308 is corrupt.

22:22:41 Who: Session(38, informix@faisone, 22587, c000000341d2af88)



Thread(80, arcbackup1, c000000341cf0fa0, 1)



File: rsarcbu.c Line: 4101

22:22:41 Raw hex dump of stack located in /tmp/af.438b9b1.rawstk

22:22:41 Stack for thread: 80 arcbackup1



base: 0xc00000034550c000

len: 102400



pc: 0x0000000000000000

tos: 0xc000000345524370

state: running



vp: 1



Archive detects that page 11:2897308 is corrupt.



3:21:32 Assert Warning: Archive detects that page 11:2897308 is corrupt.

23:21:32 Who: Session(252, informix@faisone, 3584, c000000341d30b10)



Thread(297, arcbackup1, c000000341cf5cf8, 1)



File: rsarcbu.c Line: 4101

23:21:32 Raw hex dump of stack located in /tmp/af.511c77b.rawstk

23:21:32 Stack for thread: 297 arcbackup1



base: 0xc00000034bc3a000

len: 102400



pc: 0x0000000000000000

tos: 0xc00000034bc52370

state: running



vp: 1



How to fix page corrupt? please advice.









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



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: [41357]



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

Re: Where Did the Doc Go?
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Fri, 12 Oct 2018 04:04:16 EDT
The HCL doc site is (I believe) the most up to date.



There are various web pages from April/May time last year you can find on the

internet about the announcement and explaining the new relationship, for

example:



http://www.iiug.org/en/2017/04/17/ibm-and-hcl-strategic-partnership-to-jointly-develop-and-market-ibm-informix/



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: [41356]



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

Re: Activate RSS Encryption?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Tue, 09 Oct 2018 13:43:37 EDT
We heard from HCL, today.



The tech apologized for the delay, and explained that he had not been alerted

to my online entries in the case notes since 9/28. (He was responding to a

personal email I sent outside of the online case management tool.)



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: [41355]



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

ONMODE -Y on the client side
Posted by: rugamu@hotmail.com (RUBéN GARCíA) - Tue, 09 Oct 2018 07:11:42 EDT
Hi everyone,



I'm interesting on making a script who emules the "onmode -Y" for one sessión,

but just in a machine which has only installed the IDS client(Version 12.10).

Does anyone know how to do it?



Best regards.









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



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: [41354]



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

Re: Where Did the Doc Go?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Mon, 08 Oct 2018 17:44:09 EDT
Is this more current than the IBM doc site (which still works for me)?



I really am uncertain about who now actually owns and is responsible for

Informix.



I now see product references to "HCL Informix".



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: [41353]



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

Re: Table extents differences on recreate
Posted by: jacques.renaut@hcl.com (JACQUES RENAUT) - Mon, 08 Oct 2018 16:48:59 EDT
Original post:



When I recreate a table using the 'create table....as select from...' syntax,

the new table gets created with the extent size/next size of 16/16. The

original table has 13 extents, however, the new table is in 2 extents. This

would not surprise me if the original table was small. In my case the original

table/new has 14 million records. Why is the new table in 2 extents and its

next size so large (see details below) despite the extent sizes being 16/16?



....<oncheck -pt output cut>...



Response:



Not sure when it was added, but at some time, if an extent gets added to a

table, and this new extent is contiguous with the current last extent of the

table, the newly added extent is merged with the previous last extent (so all

that needs to be done is increasing the size of the previous last extent to

include the newly added pages). This change was made to try and reduce the

number of extents on a table. So it seems like when this new table was built,

it went into a chunk without any other activity (or very little activity) so

after it got it's 2nd extent, all the new extent requests after that were

contiguous with the 2nd extent, so they were able to be merged. However,

because the initial extent size was default, I believe we are able to keep

track of new extent requests, so that extent size doubling was able to happen.

So that extent size doubling likely explains the resulting next extent size

from the oncheck -pT output. I believe there is an issue where partition page

next extent size being out of sync with system catalog next extent size is a

known issue when extent size doubling happens. Or at least I'm sure I've seen

that before.



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: [41352]



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

Table extents differences on recreate
Posted by: pmurali@ftportfolios.com (MURALI PAZHAYANNUR) - Mon, 08 Oct 2018 13:18:20 EDT
When I recreate a table using the 'create table....as select from...' syntax,

the new table gets created with the extent size/next size of 16/16. The

original table has 13 extents, however, the new table is in 2 extents. This

would not surprise me if the original table was small. In my case the original

table/new has 14 million records. Why is the new table in 2 extents and its

next size so large (see details below) despite the extent sizes being 16/16?



My colleague confirmed this with oncheck -pT



System Info: Informix 12.10.FC6, HP-UX 11.31.ia64



Here are the details (Sorry about the formatting mess here):



a. _fi_debt_price is fi_debt_price renamed.

b. fi_debt_price is created by:



create table dba.fi_debt_price_new as select * from dba._fi_debt_price;



rename table fi_debt_price_new to fi_debt_price;



_fi_debt_price (oncheck -pT)



TBLspace Report for evaluation:dba._fi_debt_price



Physical Address 25:3998735



Creation date 05/21/2011 12:35:11



TBLspace Flags 802 Row Locking



TBLspace use 4 bit bit-maps



Maximum row size 95



Number of special columns 0



Number of keys 0



Number of extents 13



Current serial value 1



Current SERIAL8 value 1



Current BIGSERIAL value 1



Current REFID value 1



Pagesize (k) 2



First extent size 30336



Next extent size 96256



Number of pages allocated 728192



Number of pages used 704305



Number of data pages 704130



Number of rows 14612101



Partition partnum 11534727



Partition lockid 11534727



Extents



Logical Page Physical Page Size Physical Pages



0 26:311298 222848 222848



222848 26:1983008 12032 12032



234880 26:2601949 12032 12032



246912 26:3228816 12032 12032



258944 26:4054671 12032 12032



270976 26:4887549 24064 24064



295040 32:1516317 48128 48128



343168 32:4448664 48128 48128



391296 25:946816 48128 48128



439424 39:461787 48128 48128



487552 39:3819044 48128 48128



535680 46:262467 96256 96256



631936 49:3008520 96256 96256



fi_debt_price (oncheck -pT)



TBLspace Report for evaluation:dba.fi_debt_price



Physical Address 49:4024583



Creation date 10/02/2018 13:15:18



TBLspace Flags 801 Page Locking



TBLspace use 4 bit bit-maps



Maximum row size 95



Number of special columns 0



Number of keys 0



Number of extents 2



Current serial value 1



Current SERIAL8 value 1



Current BIGSERIAL value 1



Current REFID value 1



Pagesize (k) 2



First extent size 8



Next extent size 131072



Number of pages allocated 786049



Number of pages used 730788



Number of data pages 730606



Number of rows 14612101



Partition partnum 11535665



Partition lockid 11535665



Extents



Logical Page Physical Page Size Physical Pages



0 54:1433687 4737 4737



4737 54:1454432 781312 781312









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



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: [41351]



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

Re: Activate RSS Encryption?
Posted by: david.grove@alaska.gov (DAVID GROVE) - Mon, 08 Oct 2018 12:39:43 EDT
This is becoming frustrating.



We opened a tech support case on 9/28, and HCL responded with a partial answer

the same day. They said they had to research the issue to find the real

answer. It is now Oct 8, and they have not responded any further.



They have not responded to an additional post I made.



They have not responded to a request to upgrade priority of the case.



The chat button produces an "agent unavailable" 100% of the time.



I do not know how to wake them up.



Their service is less than satisfactory.



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: [41350]



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

Replication (RSS) instance it not coming up
Posted by: mailtodeepakpatel@gmail.com (DEEPAK PATEL) - Mon, 08 Oct 2018 08:23:03 EDT
Hi All, I an new to the Informix anf getting below error. Please help



IDS version : 12.1 OS : SUSE Linux Host Name : Server1



Server1 is hosting 17 informix RSS replication instance. we have create 1

replication instance around 1 month back. it was running fine.

On one file day it went hung throwing below error in online log :



01:00:26 Dynamically allocated new virtual shared memory segment (size

32768KB)

01:00:26 Memory sizes:resident:24140 KB, virtual:363940 KB, SHMTOTAL:16777216

KB

01:22:18 Dynamically allocated new virtual shared memory segment (size

32768KB)

01:22:18 Memory sizes:resident:24140 KB, virtual:396708 KB, SHMTOTAL:16777216

KB

09:13:45 Dynamically allocated new virtual shared memory segment (size

32768KB)

09:13:45 Memory sizes:resident:24140 KB, virtual:429476 KB, SHMTOTAL:16777216

KB



When I restarted the replication instance, it is not coming up. I have

increased host memory but didn't work. Getting below error:



08:59:35 IBM Informix Dynamic Server Stopped.



08:59:41 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)

08:59:41 IBM Informix Dynamic Server Started.

08:59:41 Warning: The IBM IDS Workgroup Edition license restriction limits

08:59:41 the total shared memory size for this server to 16777216 KB.

08:59:41 The maximum allowable shared memory was reset to this size to start

the database server.

08:59:41 Requested shared memory segment size rounded from 23428KB to 24140KB



Mon Oct 8 08:59:42 2018



08:59:42 Requested shared memory segment size rounded from 22459KB to 22460KB

08:59:42 Successfully added a bufferpool of page size 2K.



08:59:42 Requested shared memory segment size rounded from 210629KB to

210632KB

08:59:42 Successfully added a bufferpool of page size 4K.



08:59:42 Event alarms enabled. ALARMPROG =

'/home4/informix12/etc/alarmprogram.sh'

08:59:42 Booting Language <c> from module <>

08:59:42 Loading Module <CNULL>

08:59:42 Booting Language <builtin> from module <>

08:59:42 Loading Module <BUILTINNULL>

08:59:42 SQLTRACE: SQL History Tracing set to 1000 SQL statements.

08:59:47 DR: DRAUTO is 0 (Off)

08:59:47 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)

08:59:47 Event notification facility epoll enabled.

08:59:47 Trusted host cache successfully built:/etc/hosts.equiv.

08:59:47 CCFLAGS2 value set to 0x200

08:59:47 SQL_FEAT_CTRL value set to 0x8008

08:59:47 SQL_DEF_CTRL value set to 0x4b0

08:59:47 IBM Informix Dynamic Server Version 12.10.FC8WE Software Serial

Number AAA#B000000

08:59:47 requested number of KAIO events (32768) exceeds limit (2313). using

2313.

08:59:48 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.



08:59:48 Started 1 B-tree scanners.

08:59:48 B-tree scanner threshold set at 5000.

08:59:48 B-tree scanner range scan size set to -1.

08:59:48 B-tree scanner ALICE mode set to 6.

08:59:48 B-tree scanner index compression level set to med.

08:59:48 Physical Recovery Started at Page (3:731360).

08:59:49 Physical Recovery Complete: 270 Pages Examined, 135 Pages Restored.

08:59:49 smx creates 1 transports to server <replication_instance>



Thanks,









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



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: [41349]



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

Re: Where Did the Doc Go?
Posted by: benjamin.thompson@skybettingandgaming.com (BENJAMIN THOMPSON) - Fri, 05 Oct 2018 05:01:58 EDT
I don't know what's happened to your links but the most up to date

documentation for Informix is at:

http://informix.hcldoc.com/help/index.jsp









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



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: [41348]



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

RAID10 vs RAID60
Posted by: jrubin@midwestern.edu (JIM RUBINSTEIN) - Thu, 04 Oct 2018 17:39:08 EDT
I am working with my network team to replace some 5+ year old hardware for my

Informix/Webserver environment. We are running IDS 12.10 on SLES 11 in a

virtual (VMWare) environment. Our dbspace is approximately 250GB and accessed

pretty heavily from a cluster of load balanced Apache servers. I know that

RAID5 isn't recommended

(https://www.askdbmgt.com/why-raid5-should-be-avoided-at-all-costs.html), but

my networking team and hardware vendor (Tegile) is recommending RAID60. I am

hesitant to use any RAID level that utilizes parity, but this is way beyond my

area of expertise, and I'm curious to hear recommendations from the community.









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



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: [41347]



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

Where Did the Doc Go?
Posted by: ddmueller@west.com (DAN MUELLER) - Thu, 04 Oct 2018 15:26:04 EDT
Folks,



All of my links to IBMs knowledge base where they kept the Informix family

documentation now come up as empty pages. Can someone please point me to the

doc set?



thanx,

dan









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



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: [41346]



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

Folks,



All of my links to IBMs knowledge base where they kept the Informix family

documentation now come up as empty pages. Can someone please point me to the

doc set?



thanx,

dan









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



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: [41346]



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

 
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