Threads from 2008
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
defer updating indexes on inserts
Is there any way to postpone updating indexes when doing a large # of inserts until all of the inserts are done without dropping & recreating the indexes?…
RE: {Spam?} RE: Is Open Office dying?
> Date: Wed, 31 Dec 2008 16:02:52 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Re: {Spam?} RE: Is Open Office dying? > > Ian Michael Gumby wrote: > > > > Yet I digress. > > No shit!? > Well he started it and you jumped in! :-) Getting back on to…
Re: {Spam?} RE: Is Open Office dying?
Ian Michael Gumby wrote: > > Yet I digress. No shit!? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
How to Trap Informix error
Hi, I wanted to trap the Informix 'Error in field' how to do this in Informix 4gl program..? Thanks Krishnan…
Re: Location of physical and logical logs [SOLVED]
On Wednesday 31 December 2008 10:34, Scott Newton wrote: > This may seem like a bit of stupid question but how do I find out in which > dbspace the logs are on a system I didn't set up? Thanks to Neil, Pamela and June for answering: Either: Run 'onstat -d/-D' and focus on the '…
Location of physical and logical logs
This may seem like a bit of stupid question but how do I find out in which dbspace the logs are on a system I didn't set up? Thanks -- Regards Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd 95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Sh…
9905 error with varchar in a multiset
Hello, On random occurrences when a database is first created or updated and a procedure containing a multiset with varchars is loaded I get the following error: 9905: [Internal] No extended type information for domain. This is a random and seldom occurrence, but happens e…
RE: {Spam?} RE: {Spam?} RE: {Spam?} RE: Is Open Office dying?
> Date: Mon, 29 Dec 2008 21:48:46 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: {Spam?} RE: {Spam?} RE: {Spam?} RE: Is Open Office dying? > > Ian Michael Gumby wrote: > > Sigh. > > > > Ok, lets put it this way... > > > > With the Open Source mo…
Re: {Spam?} RE: {Spam?} RE: {Spam?} RE: Is Open Office dying?
Ian Michael Gumby wrote: > Sigh. > > Ok, lets put it this way... > > With the Open Source movement around MySQL starting to fragment, its > future is called in to question. Sun Microsystems now owns the code > stream and can do with it what it wants. While there is a code stream …
RE: help with perl please?
Hello, FYI for the kind folks who were interested and tried to help me with my perl script. The timeout setting appears to work, but not for the reason I needed it. I followed some other workaround examples and the script is timing out now. Thanks much, Norma Jean The …
RE: {Spam?} RE: {Spam?} RE: Is Open Office dying?
Sigh. Ok, lets put it this way... With the Open Source movement around MySQL starting to fragment, its future is called in to question. Sun Microsystems now owns the code stream and can do with it what it wants. While there is a code stream that is open sourced, it doesn't mean…
Re: {Spam?} RE: {Spam?} RE: Is Open Office dying?
Ian Michael Gumby wrote: > > > > Date: Mon, 29 Dec 2008 13:38:08 +0000 > > From: obnoxio@serendipita.com > > CC: informix-list@iiug.org > > Subject: Re: {Spam?} RE: Is Open Office dying? > > > > This is why IDS, sans marketing, has a better future as MySQL as an OS > > > pr…
RE: {Spam?} RE: Is Open Office dying?
> Date: Mon, 29 Dec 2008 13:38:08 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: {Spam?} RE: Is Open Office dying? > > This is why IDS, sans marketing, has a better future as MySQL as an OS > > project. > > I'm feeling a little slow today, IBM …
Re: {Spam?} RE: Is Open Office dying?
Ian Michael Gumby wrote: > > > > Date: Mon, 29 Dec 2008 10:06:07 +0000 > > From: obnoxio@serendipita.com > > To: informix-list@iiug.org > > Subject: Is Open Office dying? > > > > http://obotheclown.blogspot.com/2008/12/is-open-office-dying.html > > > > And it took you this…
RE: Is Open Office dying?
> Date: Mon, 29 Dec 2008 10:06:07 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Is Open Office dying? > > http://obotheclown.blogspot.com/2008/12/is-open-office-dying.html > And it took you this long to figure this one out? Why do you think IBM's…
Re: What's new feature for i4gl 7.50
i ask something similar http://groups.google.com.ar/group/comp.databases.informix/browse_thread/thread/7130ffdb3f74d4f9/2faa98a9545a7142?hl=es&lnk=gst&q=enrique#2faa98a9545a7142 .......…
Is Open Office dying?
http://obotheclown.blogspot.com/2008/12/is-open-office-dying.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Lottery hit by computer glitch
http://www.independent.co.uk/news/uk/home-news/lottery-hit-by-computer-glitch-1213854.html The National Lottery's system for selling tickets online and in shops went down yesterday, leaving would-be gamblers unable to play. Camelot, which runs the National Lottery, said it had …
Re: Retrieve 3o minutes [395]
Sorry, I always get the INTERVAL constants wrong, it should be: select ... from mytable where ..... and insert_time BETWEEN (CURRENT - INTERVAL (30) minute(2) to minute) and CURRENT .... ; -OR I could have used the UNITS as you did: select ... from mytable where ..... an…
Re: Holiday Greetings
On Dec 26, 5:15 pm, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Did you forget to mention the fact that the Eastern Orthodox (Greek and I believe Russian) celebrate X-mas a week or so later? Some parts of the Eastern and Greek Orthodox churches still adhere to the old Juli…
Re: {Spam?} RE: MySQL not doing so well in Sun's hands
Ian Michael Gumby wrote: > > > > Date: Sat, 27 Dec 2008 12:20:29 +0000 > > From: obnoxio@serendipita.com > > To: informix-list@iiug.org > > Subject: MySQL not doing so well in Sun's hands > > > > http://www.theregister.co.uk/2008/12/27/mysql_slowing_down/ > > > [SNIP] > >…
RE: MySQL not doing so well in Sun's hands
> Date: Sat, 27 Dec 2008 12:20:29 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: MySQL not doing so well in Sun's hands > > http://www.theregister.co.uk/2008/12/27/mysql_slowing_down/ > [SNIP] > Ironic really, because it looks to me that lately IDS …
MySQL not doing so well in Sun's hands
http://www.theregister.co.uk/2008/12/27/mysql_slowing_down/ MySQL, the lovable little database engine that could - for reasonable values of could - is starting to feel the pain of being an open source project distributed by a large company. With a slower release cycle, communit…
Re: Holiday Greetings
DA Morgan wrote: > Obnoxio The Clown wrote: > >> The thing is, being "the Christ" has a very specific meaning and since a >> (serious) Jew doesn't believe "the Christ" has come yet, a Jew can't >> wish someone "Merry Christ-mas". > > So if it isn't your birthday you can't say "Ha…
RE: Holiday Greetings
Now you see what you've done Art? :-) You've even upset some of the cluckers* ... Did you forget to mention the fact that the Eastern Orthodox (Greek and I believe Russian) celebrate X-mas a week or so later? (Hey! What do I know, my degree was in engineering and not religious s…
RE: Holiday Greetings
> Date: Fri, 26 Dec 2008 19:33:55 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: Holiday Greetings > > DA Morgan wrote: [SNIP] > I, on the other hand, have no problem calling you a pompous cunt. It's > well within *my* religion. > Festivus? htt…
machine notes for IDS 10 FC9 AIX
Hi everyone. I read the machine notes for IDS 10 FC9 on AIX. There is no mention of any need to be concerned with kernel parms. However, for every other operating system the machine-specific notes have specific kernel parm recommendations. I would assume this implies that there i…
machine notes for IDS 10 FC9 AIX
Hi everyone. I read the machine notes for IDS 10 FC9 on AIX. There is no mention of any need to be concerned with kernel parms. However, for every other operating system the machine-specific notes have specific kernel parm recommendations. I would assume this implies that there i…
Selective columns for creating synonym
Hi, I wanted to create a synonym only for specfic columns from a table. Is it possible..? Thanks Krishnan…
Re: Holiday Greetings
Clive Eisen wrote: > Obnoxio The Clown wrote: >> Captain Pedantic wrote: >> >>> "InDeep" <indeep@indeep.com> wrote in message >>> news:4952ef34$0$5678$6c36adad@news.usenetserver.com... >>> >>>> Happy Holidays Art! >>>> >>> For my own interest's sake, why not simply, "Happy Christ…
Re: Holiday Greetings
Obnoxio The Clown wrote: > Captain Pedantic wrote: > >> "InDeep" <indeep@indeep.com> wrote in message >> news:4952ef34$0$5678$6c36adad@news.usenetserver.com... >> >>> Happy Holidays Art! >>> >> For my own interest's sake, why not simply, "Happy Christmas"? >> > > I know he hides …
RE: Holiday Greetings
Froehliche Weihnachten! Joerg ----------------------------------------------------------------------------- ________________________________ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Art Kagel Sent: Thursday, December 25, 2008 …
RE: Holiday Greetings
Froehliche Weihnachten! Joerg ----------------------------------------------------------------------------- ________________________________ From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Art Kagel Sent: Thursday, December 25, 2…
Holiday Greetings
To the entire Informix community: Happiest of holidays to you all, whatever and however you celebrate. If you don't celebrate any special holiday this time of year, then just enjoy the weather! ;-) And to all: A good year! Art -- Art S. Kagel Oninit (www.oninit.com) IIUG Boa…
Holiday Greetings
To the entire Informix community: Happiest of holidays to you all, whatever and however you celebrate. If you don't celebrate any special holiday this time of year, then just enjoy the weather! ;-) And to all: A good year! Art -- Art S. Kagel Oninit (www.oninit.com) IIUG B…
Bah humbug!
And all that crap to you! -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
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…
Re: Help with order by clause
Jonathan Leffler wrote: > On Mon, Dec 22, 2008 at 11:22 AM, loc <c320sky@gmail.com> wrote: >> create temp table t1 (date date, invoice integer, type char(30)); >> insert into t1 values ("020107", 181192, "Sale"); >> insert into t1 values ("020207", 78940, "Sale"); >> insert into …
Problem with ER replication
Hello, We are using IDS 7.31.UD1 with Enterprise Replication. We added 4 columns to a table that is replicated, and now got the error "CDR:23 (Error: Internal error (buffer too small for stored procedure arguments))". Is there a limit in the row size of replicated tables? Thank…
Washington Area Informix User Group - Next Meeting on Enterprise Replication
Happy Holidays and Best Wishes for the coming year! Washington Area IBM Informix Database User Group- http://www.iiug.org/waiug/ Next Meeting - Wednesday January 28, 2009 - What's New in Informix and Enterprise Replication -------------------------------------------------------…
What's new feature for i4gl 7.50
In ibm web site, there is new version 4gl 7.50. What made me confuse is that all manual are old 4gl version 7.32. I did'nt see anything new. check this site: http://www-01.ibm.com/software/data/informix/pubs/library/4gl_750.html…
Re: help with perl please?
> > > I would be happy to send more of the script to someone, I am at my > wits end… and I don’t have many wits J > > Thanks for any help, > > Norma Jean Have you actually timed the failure, (Say with 'time script.pl' ), or ar you ballparking the number? Since you didn't mentio…
btree invalidation
I have the following line in the output of onstat -g mem btree inval V c000000054330028 1745338368 149991704 1704431 213054 I'm care about that because the last week the number of memory segments (onstat -g seg) has increased and onmode -F has no efect. I've noticed that …
Help with order by clause
create temp table t1 (date date, invoice integer, type char(30)); insert into t1 values ("020107", 181192, "Sale"); insert into t1 values ("020207", 78940, "Sale"); insert into t1 values ("020307", 181190, "Sale"); insert into t1 values ("022007", 181192, "Receipt"); select * fr…
Re: informix unloads converting the data
On Dec 19, 10:47 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Hi, > > This is on ids10.0 and aix5.3 > > We're trying to convert > some data over to another database. When unloading certain fields that > have encrypted data inserted into them ( not informix encryption ), …
Informix Roundup: 21 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-21-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 21 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-21-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
RE: informix unloads converting the data
Outch! Doesn't the LOAD/UNLOAD commands understand or allow for a binary data field? I guess you could write an ESQL/C program or even a Python/Perl script to do the unload and subsequent load for you. Or you might be able to modify one of Art's utilities over on the IIUG site.…
Re: Using ER for Migration from 10.0 to 11.5
> Davorin, > > HPL over named pipes is definintely how I got the data over there in the first place, so no problem there. But letting transactions > spool on the source server while I transfer data and build indexes and constraints scares my boss. Mostly because we had problems…
FAQ - editing Informix unload files
Floyd Wellershaus wrote: > Hi, > This is on ids10.0 and aix5.3 > > We're trying to convert some data over to another database. When > unloading certain fields that have encrypted data inserted into them ( > not informix encryption ), we noticed that the data is getting converted …
Re: informix unloads converting the data
On Fri, Dec 19, 2008 at 2:47 PM, Floyd Wellershaus <floyd@fwellers.com> wrote: > Hi, > This is on ids10.0 and aix5.3 > > We're trying to convert some data over to another database. When unloading > certain fields that have encrypted data inserted into them ( not informix > encryp…
Re: help with perl please?
On Fri, Dec 19, 2008 at 10:50 AM, Norma Jean Sebastian <nsebastian@flinnsci.com> wrote: > I know this isn't really the forum for this, but I am hoping some kind soul > who knows perl can help me. > > I am very new to perl, actually so new that I am simply trying to hack a > scrip…
Re: Using ER for Migration from 10.0 to 11.5
On Dec 19, 9:41 am, "Andrew Ford" <af...@networkip.net> wrote: > We are in the process of migrating from one server running IDS 10.00.UC5 32 bit Red Hat Linux 3 to another running IDS 11.50.FC3 64 > bit Red Hat Linux 5. > > I would like to us ER to keep the new server in sync wit…
informix unloads converting the data
Hi, This is on ids10.0 and aix5.3 We're trying to convert some data over to another database. When unloading certain fields that have encrypted data inserted into them ( not informix encryption ), we noticed that the data is getting converted a bit. For instance, an \\F in the…
RE: dirty read isolation in views
> Date: Fri, 19 Dec 2008 17:24:25 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: dirty read isolation in views > [SNIP] > > What about OfficeConnect? > I believe you'd still run in to the same problem. However... why can't the user just issue a…
help with perl please?
Hello all, I know this isn't really the forum for this, but I am hoping some kind soul who knows perl can help me. I am very new to perl, actually so new that I am simply trying to hack a script I inherited. The script has statements as follows (url was changed): my $user…
Re: dirty read isolation in views
Ian Michael Gumby wrote: > Ok, so the issue is that clients using PC open excel and want to get > refreshed data from the database. > How accurate does the data in the database have to be? > > Does it have to be real time? Does it have to be within 5 minutes of the > last change?…
RE: dirty read isolation in views
Ok, so the issue is that clients using PC open excel and want to get refreshed data from the database. How accurate does the data in the database have to be? Does it have to be real time? Does it have to be within 5 minutes of the last change? 10 minutes? The simplest solution …
Re: Using ER for Migration from 10.0 to 11.5
informix-list-bounces@iiug.org wrote on 12/19/2008 09:41:13 AM: > [image removed] > > Using ER for Migration from 10.0 to 11.5 > > Andrew Ford > > to: > > informix-list > > 12/19/2008 09:43 AM > > Sent by: > > informix-list-bounces@iiug.org. > > We are in the process of migratin…
Basic trouble on ER - primary/target based
Hello! I have made a primary/target ER on IDS 11.50.FC2, for testing purposes. My groups are named g_primary and g_target. I started the 2 servers just fine. Then I created 2 replicates, based on a "select * from" statement. When I activate the replicate, my problem is: on server…
RE: dirty read isolation in views
The issue is we have a few client pc's that have pivot tables in spreadsheets that refreshes data thru an odbc connection to an IDS 9.4. The pc's run windows informix csdk v3.50. Whenever table they query on is locked during refresh, windows vb gives a generic error msg. Reg…
Using ER for Migration from 10.0 to 11.5
We are in the process of migrating from one server running IDS 10.00.UC5 32 bit Red Hat Linux 3 to another running IDS 11.50.FC3 64 bit Red Hat Linux 5. I would like to us ER to keep the new server in sync with the old server until we actually migrate. I have unloaded the data …
Pam Authincation using the Centrify
OS is Solaris 10 IDS is 9.4.FC9 I was wondering if anyone has used DirectConnect from Centrify for PAM authentication to AD. If so issues or problems they have had. Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (31…
RE: dirty read isolation in views
You might be able to establish a trigger on the view that sets the isolation level prior to the query being run and resets it after the query? It would have to be a SPL command, as I don't believe that a view can take an isolation level - it is dependant on the client session. J…
dirty read isolation in views
Is it possible to create views with dirty read default isolation -or- run views in dirty read isolation? IDS 9.4UC8 Redhat Enterprise Linux 3 AS DISCLAIMER This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments theret…
RE: Migration from Informix
With regards to migrating SAP to something other than Informix, check your licensing costs if you are concerned about your bottom line. In the migration I was involved with in 2007, DB2 licensing through SAP (not IBM) was more favorable than Oracle through SAP. I have forgotten…
Difference between 32bit Informix and 64bit Inform
What are the difference between 32bit Informix and 64bit Informix version?…
Re: Migration from Informix
Ian Michael Gumby wrote: > Eric, > > Janet made the decision to talk with SAP and to convince them to drop > IDS support and favor DB2 support after it was known that IBM's adoption > of 'project arrowhead' wasn't going to work. Informix had XPS which was > killed outright. (One …
script equivalent to i4gl program
Hi Masters, Is there any script or simple way to compile 4gl modules equivalent with i4gl program (syspgm4gl). I know i4gl provide syspgm4gl to construct compilation of 4gl modules, but in situation where we need to compile hundreds of module, it is not simple task to write using…
Miles Davis - Bye Bye Blackbird
http://uk.youtube.com/watch?v=qzpSIJpq11c&feature=related…
urgent - onmonitor and ontape eror
Hi i am getting this error in onmonitor Dynamic Server: Status Parameters Dbspaces Mode Force-Ckpt Archive Logical-Logs Exit Status menu to view Dynamic Server. ** WARNING: Network Down **--On-Line------- Press CTRL-W for Help. -------- onstat is working fine but when i run o…
Using Informix syntax in SQL2000 DTS packages
Good day, We have a Business Intelligence system in SQL Server that uses data from our Informix-base OLTP system. I need to extract data from the Informix database into SQL Server using an Informix dirty read, because the OLTP system is being used constantly so we can't wait fo…
Error compile using c4gl
Hi Masters, I try to compile script below using c4gl, but retun weird error like this /?ld: Unsatisfied symbol "eficb"........../ Here is the script ====================================================== #include "sqlfm.h" #define MODIFIED 1 /* To determine if record in an arr…
RE: garbage after unsintall BTS 1.10
Hi César I am the principle developer or Basic Text Search DataBlade and I just had a look at this issue and I hope I can offer some suggestions to help with this process. Regarding bts objects left behind after bts.1.10 is unregistered.: I am concerned that you are seeing …
Override automated update statistics
While I find the automated update statistics feature and great addition to 11.5 I have a specific need to control or override the update statistics commands that are generated by the evaluator for certain tables. I've searched the documentation for customization paramaters that …
Informix Users
I want to know about Informix Users. I created informix OS-user & group. It is used for Informix installation. So Informix is an Administrative user for all instances.. right..?? In oracle, SYS, SYSTEM..etc users will be created as part of Oracle installation. Similarly, How do …
Informix Roundup: 16 December 2008
The Yet Another Award edition: http://obotheclown.blogspot.com/2008/12/informix-roundup-16-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 16 December 2008
The Yet Another Award edition: http://obotheclown.blogspot.com/2008/12/informix-roundup-16-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
RE: Attach fragment to index not atomic - FIXED
Wherever we ran into slowness of that nature, we added the fragdate to the index in question. We're handling 14 largish tables in under a second on a daily basis. j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- From: informix-list-bounces@iiu…
RE: Attach fragment to index not atomic - FIXED
Indeed - the BEFORE part of the fragmentation clause was the killer. Take that off and it runs in a second or two. Much better! Thanks for the help - odd it affected the indexes and not the table. Jack - Yes the unique index is forming part of the primary key constraint. I was …
Re: Question re. sysptprof
Not related with sysptprof but to your intended idea of checking index usage. Starting on version 10 you can monitor your index activity with "onstat -C part" It shows the statistics used by BTScanner to decide when an index must be cleaned. Everytime the index is accessed the …
infcfgcheck -a warning
All, During the infcfgcheck -a execution we are getting the following warning: parameter -- origin class... ALLOC_PAGES_TABLE_cosb -- DBGENERAL performance check?.......... N expected.................... <= 11744050 (70.0 perc) FOUND value................. 13479989 (80.3 perc…
Fragmentation
( Okay all, I have officially given up on trying to respond from work. Here is what I tried to write. ) You are fragmenting the index with this statement, but you said it is the primary key of your table. Can't you just fragment the table this way? The index will get created imp…
Fragmentation question
(Sorry all, big brother encrypted my last response again=2E Retrying)=0D= =0A=0D=0A=0D=0A=0D=0AYou are fragmenting the index with this statement, but= you said it is=0D=0Athe primary key of your table=2E Can't you just fragm= ent the table this=0D=0Away? The index will get create…
IDS 10 FC9 compatability question...
Hi everyone. I have a UNIX AIX 5.2 box to use for this. The machine notes for IDS 10 FC9 state.... "================================= MACHINE SPECIFIC NOTES FOR IBM INFORMIX Dynamic Server 10.00.FC9 PRODUCT RELEASE ON IBM AIX 64bit DATE: 22 Aug 2008 =======================…
Migration from Informix
As everybody know IDS is not supported to SAP Kernel 7.0 and later, so I would like to know What is your next DB engine you choose?... Any experience in migrations from Informix?? Thanks!…
FW: Attach fragment to index not atomic
bçëj اØ^w^Ç Øb²ËZµéÖî·*.±¨Ø¬…
RE: Attach fragment to index not atomic
Get rid of the 'BEFORE', otherwise there is indeed an insane re-reading of the data to ensure that it fits the fragmentation clause and that no migration is necessary. The minimal performance benefit you gain from having the index show up earlier in the frag clause isn't worth t…
Update statistics filling up too much logical logs
Hi Forum guys, some time ago, I already posted this topic but didn't get a clear answer, yesterday the topic was actual again. OS : Solaris 8, Informix 9.40 UC3 On a new database (in "unbuffered logging") I performed the update statistics. Method based on performance guide and…
How to create multiple instances
Hi, I have a HP-UX box and demo_on instance is running there. I wanted to create an another instance "newone". So, i copied the demo_on instance's onconfig and sqlhosts file and made the below changes. 1) onconfig.newone DBSERVERNAME newone SERVERNUM 2 2) sqlhosts.newone ne…
Fatal error
Dear Friends, When i am try to onlining the informix i got this messages informix@DBSERVER> oninit -v -y Checking group membership to determine server run modesucceeded Reading configuration file '/export/home/informix/IDS0/etc/onconfig.voms'...succeeded Creating /INFORMIXTMP/.…
Attach fragment to index not atomic
Hi, IDS11.10.UC2W2 on RHEL4 We have the index (and a few more like it) below. It is used for the primary key of a table. When I attach a new fragment to the system it reads every page of the index. So adding 12 fragments, one for each month is a pain. alter fragment on index…
Re: Food for thought...
Ian Michael Gumby wrote: > Its always good to think outside the box. Informix has survived the > attempted purge by Janet, albeit, enough damage was done. > > So the question of growth depends on being able to maintain the > existing customers while attracting new growth. > > Cle…
Re: Food for thought...
On Dec 14, 1:29 pm, Obnoxio The Clown <obno...@serendipita.com> wrote: > Ian Michael Gumby wrote: > > > It also put IBM in an interesting position. Does IBM's IM reach out to > > Sun because they will need to port to Rock for their existing Informix > > customers on Sun or do the…
Onconfig tuning parameters for large onload jobs
Good morning, I have, hopefully, a simple question. I have a HPUX test/development box with IDS 10.00.FC5. I drop and reload copies of my databases from files generated by onunload on a weekly basis. It takes quite some time to onload each of the databases (roughly 40Gb in 1 of …
Re: Food for thought...
On Dec 14, 1:29 pm, InDeep <ind...@indeep.com> wrote: > Ian Michael Gumby wrote: [SNIP] > > Sun is a bit more interesting. In purchasing MySQL for a billion, > > they've essentially bought the rights to the software that millions of > > site use in LAMP and have put unlicensed in…
Regarding Informix Administrative user
Hi, I have installed IDS on my HP-UX box and the demo_on instance is running on the box. I have created "informix" user and "informix" group for Informix installation. Here, "informix" is an administrator user. If i want to create few more users with administrative privileges, …
Re: Food for thought...
> > So thinking outside of the box means to look for opportunities that > wouldn't regularly exist. Two of such areas are Apple and Sun > Microsystems (JAVA). Apple is slowly integrating in to the business > community. There's some software that allows one to create a windows > …
Re: Food for thought...
Obnoxio The Clown wrote: > InDeep wrote: > >> well for them ( and notice Obama used the same strategy? ). > > Ah, the delights of marketing: > http://obotheclown.blogspot.com/2008/12/deconstructing-one.html > > Obama�s campaign did receive an unprecedented number of small donat…
Re: OTC and Timeseries...
Ian Michael Gumby wrote: > While OTC points out a neat hack using Timeseries... > Terry Ralph long ago thought of other applications where Timeseries > could be applied. > > What would really be cool is for the power company to do the > timeseries tracking for you. > In the areas…
OTC and Timeseries...
While OTC points out a neat hack using Timeseries... Terry Ralph long ago thought of other applications where Timeseries could be applied. What would really be cool is for the power company to do the timeseries tracking for you. In the areas where they have the computer controll…
Food for thought...
Its always good to think outside the box. Informix has survived the attempted purge by Janet, albeit, enough damage was done. So the question of growth depends on being able to maintain the existing customers while attracting new growth. Clearly you're not going to see as much …
RE: Informix Roundup: 12 December 2008
The sole source contract with the US Army is to provide licenses in case their role out of Oracle slips. In essence, the US Army is replacing Informix with Oracle. > Date: Sat, 13 Dec 2008 07:58:59 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org; ids@iiug.org…
Informix Roundup: 12 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-12-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 12 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-12-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
ignore
One more test. Thanks, Kate Tomchik, IT Architect 770-433-8211 X 10922 kate_tomchik@homedepot.com (with high priority to page) ------------------------------------------------------------------------ ------------ Previous email: > -----Original Message----- > From: ids-bounces@…
RE: 2008 Survey
She has corrupted the whole network now=2E=0D=0A=0D=0A=0D=0A---------------= --------------------------=0D=0AThe information contained in this e-mail an= d any attached documents=0D=0Amay contain information that is confidential = or otherwise protected=0D=0Afrom disclosure=2E If…
A car driver speaks.....
http://news.bbc.co.uk/sport1/hi/motorsport/formula_one/7777566.stm "Lewis Hamilton says he does not expect Formula One to introduce a standard engine as part of plans to cut costs." (Thanks to a colleague, Simon Dolding, for pointing this out to me) Malc…
1984 (george orwell)
The Lottery, with its weekly pay-out of enormous prizes, was the one public event to which the proles paid serious attention ... It was their delight, their folly, their anodyne, their intellectual stimulant ... the prizes were largely imaginary. Only small sums were actually pai…
please tell me
how many years do you have to waste on a subject before you are considered for a guild?…
Very useful reference sheet for Informix 11.5 onco
Hey all, Found this on the wire this morning. It's a reference card for all onconfig.std parameters for IDS11.5 It's an example of IBM providing easy to read tidy documentation that fits on a page! Even if it is double sided. Laminated copies are appearing in my office as we s…
Modify the "IBM INFORMIX ODBC DRIVER" Data Source
How can I modify the "IBM INFORMIX ODBC DRIVER" Data Source - Database Locale value from en_US.CP1252 to en_US.CP819 via a DOS batch script (preferably) and/or VB script. Thanks, *************************************** Ernie Knox Sears Holding Co. IT Database Administrator S…
2008 Survey
Hey everyone, I wanted to get some input from anyone who did not fill out our 2008 survey on new feature requests. Can anyone who missed the survey comment on why? I'm trying to analyze why we got over 100 less users to fill it out than we did in 2007. If you haven't read the in…
RE: Web Datablade
Hi, To complement the option that Manoj just gave, I just wanted to add something, if it's of any help: I think that, even if you have a security check/query to be performed in a dynamic tag called in this page, you could still use this dynamic tag to query the security level o…
IDS 11 System Admin Certification
Hi All, I am currently preparing to sit the IDS 11 System Admins exam and was wondering if anyone knew where i could get hold of some sample/practice questions or even some old exam papers so i could practice, Thanks in advance Mitesh Patel…
Re: 4GL oddity query
On Dec 10, 2:52 am, i...@perrior.net wrote: > Nothing major, not causing us any problems, just a 'by the way has > anyone seen this before' kind of question, really. > IDS9.30HC5, i4gl 7.20 UD8, HP-UX 11i > > We have a program that creates an explicit temp table: > "CREATE TEMP T…
cancel key(control-c) scramble the screen
redhat AS4,ids 9.4, 4gl 7.32uc2 while open form in 4gl program, It will scramble the screen if press control-c to cancel and some unknown character will display on it till I press control-R to clear screen. The same situation happen that run 'dbaccess' and press 'control-c' sev…
update statistics high/medium and performance
I found when I execute update statistics high for the index columns, the performance is better than medium,but the execute plan is the same, do anybody know the same SQL executed more quickly when using high mode for update statistics?…
temporary table display problem in 'onstat -g sql'
could anyone help to answer the question ? 1) the customer execute the sql "select * from pobms into temp objtmptbl with no log" in instance 73mcbs without exit dbaccess , this instance justly has on temporary dbspace. a) onstat -c |grep TEMP return the following informationA…
Re: IDS10 stability VS IDS11 features (aka "for IBM")
Davorin Kremenjas wrote: > Right, > > probably a very lame try to imitate Gumby, but I'll give it a try :) > > I'd like to hear you opinions on this topic, here is mine. > > IDS11.50 is around for a good deal time now, _loads_ of new features. > I can see a lot of them making my …
RE: Web Datablade
Sorry, the MISQL code would be something like this: <?misql sql="select usersec_level from user_table where user_id=$uid> $(SETVAR, $usersec,$1) <?/misql> where usersec is a variable you defined earlier, probably using MIVAR. Thanks! Veronica. From: vgomesn@hotmail.com To…
RE: Web Datablade
Hi Klaus, Maybe something like this could work for you? If the users' levels are stored in a table, and you receive the user id as a variable for the web page, then maybe you could query (using MISQL tag) your users table to find out what security level the user who logged into…
Re: LIKE WHAT ARE YOU GOING TO WALK INTO PROSPECTUS INFORMIX? VB?
On Tue, 9 Dec 2008 14:03:57 -0800 (PST), Symeon <symeonb@gmail.com> wrote: >On Dec 5, 3:26�pm, Adrian C <em...@here.invalid> wrote: >> Tronic wrote: >> >www.prospectus.co.uk >> >> > ^ these people owe me �10,000 >> >> > ignore these bastards or be cursed >> >> If you are a L…
Re: Web Datablade
When you say user, is the user maintained through webdatablade? If so there is a security option on the page that lets you set various security levels(basically a number) and you define a user to have a particular security level. By doing so a user can only view pages equal to an…
*<8o) Season's Greetings!
A wish for all of you to have a happy holidays! *<8o) http://www.metacafe.com/watch/901844/dallas_cheerleaders_skydiving2/ Keep it light!…
Very useful reference sheet for Informix 11.5 onconfig file
Hey all, Found this on the wire this morning. It's a reference card for all onconfig.std parameters for IDS11.5 It's an example of IBM providing easy to read tidy documentation that fits on a page! Even if it is double sided. Laminated copies are appearing in my office as we s…
Re: 4gl 'error' gives reverse video on entire screen
On Dec 8, 7:23 am, Ian Goddard <godda...@hotmail.co.uk> wrote: > loc wrote: > > On Dec 7, 7:02 pm, Ian Goddard <godda...@hotmail.co.uk> wrote: > >> loc wrote: > >>> I'm using Informix 4GL 7.32.UC4 on Slackware Linux 12.1 and any time > >>> the 4gl 'error' command is executed the …
RE: Web Datablade
The appropriate list to post this question is the datablade list. Each web datablade page is considered a transaction. The possible solution if you want to commit the changes is redirect the error to another page. Guillermo. -----Mensaje original----- De: informix-list-bounces@…
RE: Informix Connection Errors
Locally on the db server Regards Colin There are 10 types of people in the world, those that understand binary and those that don't > From: captinformix@googlemail.com> Subject: Re: Informix Connection Errors> Date: Wed, 10 Dec 2008 07:06:54 -0800> To: informix-list@iiug.org> >…
Problems using Informix .NET provider
I installed IDS 11.50 using all defaults for the installer. Then I tried to connect to the service that has been created by default through the .NET provider. I used the following connection string: host=localhost;server=ol_ids_1150_1;service=turbo;database=sysmaster;uid=informi…
Informix Connection Errors
OS: Solaris 9/10 IDS 9.40.FC8X3 After having application connection problems we ran a script on a test instance to simulate a connection to the port. If I run the below script in a loop after approximately 5 mins I get the error:- 11:58:42 listener-thread: err = -25571: oserr …
Re: 4GL oddity query
can not remember the details sorry but if i recall correctly there was a bug out there which describes your symptoms. or... maybe you forget to close stuff; maybe an onstat -g stm reveals something???? maybe you can close your current session??? as a workaround... Sorry nothin…
Re: IDS10 stability VS IDS11 features (aka "for IBM")
Davorin Kremenjas wrote: > Right, > > probably a very lame try to imitate Gumby, but I'll give it a try :) > > I'd like to hear you opinions on this topic, here is mine. > > IDS11.50 is around for a good deal time now, _loads_ of new features. > I can see a lot of them making my …
Re: 4GL oddity query
Sorry about the typos in that last post - I'm on some SERIOUS medication for a disrupted sacro-iliac joint and the fingers just ain't behaving........…
4GL oddity query
Nothing major, not causing us any problems, just a 'by the way has anyone seen this before' kind of question, really. IDS9.30HC5, i4gl 7.20 UD8, HP-UX 11i We have a program that creates an explicit temp table: "CREATE TEMP TABLE temp_printer (printer_name CHAR(20), printer_desc …
IDS10 stability VS IDS11 features (aka "for IBM")
Right, probably a very lame try to imitate Gumby, but I'll give it a try :) I'd like to hear you opinions on this topic, here is mine. IDS11.50 is around for a good deal time now, _loads_ of new features. I can see a lot of them making my DBA life easier so I'm looking to upgr…
Web Datablade
Hello I'm new to informix web datablade programming and needs a possibility to stop the generation of a page, if the user has no permission for it. Because actually it's only done by javascript, which is not really secure. My current solution is to throw an error at the "misql"-…
Informix Roundup: 09 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-09-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 09 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-09-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
trim on unload or onpload
We are doing a data migration and have a need to trim trailing spaces out of some of our fields ( varchar and char ). Is there a way in hp loader to create a function to trim all fields during the unload ? Also is there a way to do it with unload ? Thanks, floyd…
index usage
Hi, I have a table with at least 16 indices. I need to identify all the ones that are being used or identify the ones that are not being used by the application. Is there a script or any other method to determine the indices usage? Please let me know Thanks! Informix Dynamic Se…
Password Errors Flood
Application servers are used in our environment to provide database connections to the informixservers. When the application universal connection account's password is changed, the Informix message log will be flooded with "password is not correct for the database server" messag…
Logo on report
Hi All, I want to print picture/logo on report header how can I do it in 4gl. Thanks & regards Abdul Qadir…
edison
"Opportunity is missed by most people because it is dressed in overalls and looks like work." Thomas A. Edison…
databases
are the most efficient invention of man they are extremely important if something recognises us from the other realm it will be through an invention of a database and categorisation…
=?ISO-8859-1?Q?the_big_question_Inside_Guant=E1namo_Bay_=2815_pictures?= =?ISO-8859-1?Q?=29?=
http://www.guardian.co.uk/world/gallery/2008/dec/04/guantanamo-bay?picture=340338257…
performance issue with REL 4 hugemem kernel
Informix: IDS 10.00.UC7 Operating Systems: Red Hat Enterprise Linux Release 4 Update 6 (standard) Red Hat Enterprise Linux Release 4 Update 6 (hugemem) I'm running a pretty basic query in java using the JDBC driver. The query is: select a.column1, b.column2, from a, b where a.c…
Washington Area Informix User Group meeting and Informix Enterprise Replication Lab - January 28,29 2009
Washington Area IBM Informix Database User Group Next Meeting - Wednesday January 28, 2009 - What's New in Informix Date: Wednesday January 28, 2009, Time: 9:00-12:00pm Location: IBM E-Gov Institute 1301K STREET NW WASHINGTON, DC 20005 Please note the location of this meeting, …
Re: When worlds collide...
Mark Townsend wrote: > OTC - for some undisclosed reason was browsing youtube today - came > across this gem, thought you may be amused - > http://www.youtube.com/watch?v=ohDEd14_NUo Just returned from B'ham where for the second time in two years OTC wimped out and was a no show…
Re: Installing IDS 11.5 on Solaris x86
2008/12/8 Parker, Peter A Mr CTR USA USAMEDCOM <peter.a.parker@us.army.mil>: > Hello all, > I downloaded the 'Solaris 32 bit - iif.11.50.UC1DE.SOL-9.tar' file from the IIUG website for testing. I installed it on a x86 Intel Dell machine that is running Solaris 10 for x86, however…
Disabling Constraints and stuff
IDS 10.00.UC8 Solaris 2.8 I am trying to redo a script(s) that we use to disable table objects (indexes, triggers and constraints). I need to be able to: 1. Disable objects for all tables that are only children - i.e. these tables are not referenced by any other tables via a fo…
Installing IDS 11.5 on Solaris x86
Hello all, I downloaded the 'Solaris 32 bit - iif.11.50.UC1DE.SOL-9.tar' file from the IIUG website for testing. I installed it on a x86 Intel Dell machine that is running Solaris 10 for x86, however when I try to launch onmonitor, dbaccess or any other IDS programs I get an "Inv…
Check the lock mode of a table.
Hi, guys! I'm interested is there any tool/SQL stament that can tell me what is the lock mode of a given table or the lock mode of all the tables in a certain database? Thanks in advance.…
Changing TAPEDEV from script
Hello all, IDS 11.10.FC2W4 on solaris 10 I run a shell script to Restore (ontape) one for my test servers every week with level 0 of prod server. Is is possible to change the onconfig parameter TAPEDEV with in the shell script before starting the restoration and after finishin…
Informix Roundup: 07 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-07-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 07 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-07-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
4gl 'error' gives reverse video on entire screen
I'm using Informix 4GL 7.32.UC4 on Slackware Linux 12.1 and any time the 4gl 'error' command is executed the entire screen goes reverse video. It only does this if I set INFORMIXTERM=terminfo. I need this because function keys don't work unless I use terminfo. It also does the…
IBM Informix Object Interface for C++
I am using the IBM Informix Object Interface for C++...or I suppose I should say that I am "trying to use" it. I'm on Windows XP and I have version 3.5. I have no problem with building the example programs I can connect to a database and in a very basic sense I can send queries…
Unexpected error registering BTS 2.00 datablade
Has anyone else encountered this error when trying to register the BTS datablade? We're trying this in IDS version 11.50.FC3 on Linux. We've recently migrated from version 11.50.FC2 and we first unregistered the BTS database before migrating. # blademgr local_on>register bts.2.0…
Equivalent of OAT for IDS 10 ?
Sorry if I'm re-posting, email problems in previous send. Well, I'm sure this question has been asked many times, but couldn't find much relevant on the list archive. Has anyone had experience, or know if, an equivalent to OAT for IDS 10 engines? Short of forking out lots of $$$…
Equivalent of OAT for IDS 10 ?
Well, I'm sure this question has been asked many times, but couldn't find much relevant on the list archive. Has anyone had experience, or know if, an equivalent to OAT for IDS 10 engines? Short of forking out lots of $$$ for Sentinel or DB-Sonar and spending hours crawling throu…
2 gig file limit on solaris 2.7 IDS 7.3 ontape?
Hi everyone. I have heard nasty rumours (unsubstantiated) that there are 'issues' when writing IDS 7.3 ontape backups to disk and the file gets larger than 2 gig, and the trying to restore from the disk file. This is on a Solaris 2.7 machine. My question is...is this just another…
Problema con logs
buenas tardes necesito saber si se puede salvar esta base de datos. tengo el siguiente problema: # oninit -vp # onstat -m 13:20:52 Onconfig parameter VP_MEMORY_CACHE_KB modified from 21822020 to 5455505. 13:20:52 Dataskip is now OFF for all dbspaces 13:20:52 Logical Log Files ar…
LIKE WHAT ARE YOU GOING TO WALK INTO PROSPECTUS INFORMIX? VB?
www.prospectus.co.uk ^ these people owe me £10,000 ignore these bastards or be cursed…
Installing IDS 10 FC9-cleaned up bad english....
Sorry-prior post was sloppy...Long day. This one should be better. I have some basic IDS 10 FC9 install kind of general questions... I have tried finding answers on this and believe it or not have not been able to.... Has anyone installed IDS 10 FC9 on any unix machine? If so do…
general IDS 10 FC9 install questions?
Hey everyone. I have some basic IDS Fc9 install kind of general questions... I have tried finding answers on this and believe it or not have not been able to.... Has anyone installed IDS 10 FC9 on any unix machine? If so do know what the size of the informix install tar file is? …
Install ESQL/C Informix
Hi team Somebody have good knowladge about how to install and configure ESQL-C connections ? Can you confirm that this ESQL/C connections is used in C programming language applications ? Thanks in advice. Roberto FERRONATO ______________________________________________________…
Question re. sysptprof
Morning all from a damp, squally, dreary, grey, shabby little seaside town on the south coast! Just a quick ask regarding sysptprof; I'm using evidence from this to try to reduce the number of indexes on a round-robin fragmented table with 51 Million rows and 23 indexes, via the …
Repost: UK Informix DBA contract
Due to several new service customers coming on-stream shortly - and one very large, completely new, customer to Informix going live yesterday - Ardenta also requires a contract Informix DBA for 3 months, starting immediately. We require strong IDS 10 or 11 skills, good communic…
Repost: UK Informix DBA role
Ardenta is looking for an experienced Informix administrator to be based at its offices in Sunbury, SW London. The essential skill sought are strong (many years) experience in IDS 10 or 11 based on UNIX or Linux systems, allied to strong inter-personal skills and the ability to …
Re: many databases with the same name
Thanks for that suggestion Art, yes, I think that is the way to go. We have ACE reports and PERFORM screens too, but we can run those with the "-d DBNAME" options. Cheers, Rob…
Informix Roundup: 03 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-03-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 03 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-03-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
sysadmin database v11.50
Just wondering if anyone has moved the sysadmin database out of the root dbspace ... If so, is it basically just and dbexport and dbimport? Thanks ..... Peter Logan Senior Database Administrator Phone: 616/878-8309…
Re: sqldetach not returning
> What is the stack for the thread calling sqldetach and the output of > onstat -g stk <tid> for the corresponding IDS thread? i´ll try to collect this information when the problem happens again.…
Re: sqldetach not returning
On 26 Nov., 19:20, "Jonathan Leffler" <jleffler.i...@gmail.com> wrote: > Sounds like there might be a problem...which o/s are you using, and > which version of CSDK? O/S: ei93253.gll.ads.niedersachsen.de >uname -a OSF1 ei93253.gll.ads.niedersachsen.d V5.1 2650 alpha CSDK: ei…
Warnings after change 9.40 FC2 to FC9
Hi everybody. I will appreciate your comments and advice about this: After changing release from IDS 9.40 FC2 to IDS 9.40 FC9 on some Sparc Solaris 9 servers, I just realize some tables affected. when I oncheck -cD database:table , it responses with TBLspace data check for siad:…
two separate versions of IDS on same UNIX machine?
Hi everyone. Another one of my basic questions.....I did poke around a little for an answer before posting :) Very simple question..........Oracle allows for multiple version of it's database engine to be installed on the same UNIX (or windows) BOX at the same time.....Does Info…
RE: Informix Roundup: 28 November 2008
> Date: Tue, 2 Dec 2008 21:35:16 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: Informix Roundup: 28 November 2008 > > Well now, have you looked at this blog post: http://tinyurl.com/8xb ? > > -- > Cheers, > Obnoxio The Clown > Is the word F …
Informix Roundup: 2 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-02-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 2 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-02-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
doing unloads with trim function ?
Does anyone know if there is any environment variable or something that can cause unloads and or exports to trim fields of excess spaces ? Thanks, floyd…
Informix Workgroup & LPAR's
I have a question. I have a client who wants to use Informix 11.50 Workgroup Edition with 3 LPAR's with 4 cpu's, 2 cpu's and 2 cpu's on the LPAR's (All below the limit of 4 CPU's for workgroup). Is it supported? Is anyone using this type of configuration? I did see under the d…
Connection Pool
Hello everybody! I have been looking for this issue for some hours and I wasn't able to find anything. How can I use the connection pool for IDS 9.4? I'm developing in C# of Visual Studio .NET. Until now I have been using Oracle. And to use the connection pool, I only had to u…
Re: Checkpoint durations
On Nov 28, 7:45 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > IDS 10.0FC8W2 on HP-UX 11.31 > > I'm tuning IDS on quite a large system (18 cpus, 65g memory, Tier One SAN). > > I have BUFFERS set to 10,000,000 (ie 20g), and lru_max_dirty to 0.5%.(ie > 50,000 pages or 100m). l…
Informix Roundup: 01 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-01-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
Informix Roundup: 01 December 2008
http://obotheclown.blogspot.com/2008/12/informix-roundup-01-dec-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
many databases with the same name
Hi Forum, We've been using Informix SE for many years and are starting to move to IDS11. For our inhouse development and testing, we have setup many databases, one per customer. All these DBs have the same name, because we have a lot of 4GL programs, and 4GL needs the DB name t…
Sanity check on ontape lev0/1 restore?
Hi everyone. I'd like to do a sanity check on a restore from ontape for an IDS 9.4 database if that's ok.....I have an IDS 9.4 database that has level 0's done on Sunday 1AM EST, and then subsequent level 1 backups Mon-Sat 1AM EST.... I need to restore the database to it's state…
slow connections
IDS 10.00.FC7 on AIX 5.3 on IBM P550 server Greetings fellow IIUGgers, I'm getting sporadic slowness establishing connections OR complete connection timeouts. Not sure what could cause such behavior, the server is 95% idle. Any recommendations where to look? I can provide other …
Automatic Update Statistics
I am using IDS 11.10.UC2 on Linux and would like to start using the AUS feature. Do you have to use OAT to use this feature? I can not find any documentation about this feature in the Information Center. If you know of any links or presentation please respond. Thanks Roy…
Re: In place alter issue
On Nov 26, 5:43 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > bozon wrote: > > On Nov 26, 12:25 pm, "Fernando Nunes" <domusonl...@gmail.com> wrote: > >> You don't need to fix it... > >> You'll only see the second output after recreating the table. > > >> This is why it's no…
Re: Checkpoint durations
2008/11/28 Neil Truby <neil.truby@ardenta.com>: > IDS 10.0FC8W2 on HP-UX 11.31 > > I'm tuning IDS on quite a large system (18 cpus, 65g memory, Tier One SAN). > > I have BUFFERS set to 10,000,000 (ie 20g), and lru_max_dirty to 0.5%.(ie > 50,000 pages or 100m). lru_min_dirty is e…
Change the informix database to read only
Dear All, I want to put one of my informix database to read only mode. Can anybody provide the solution to change the database to read only mode. Thanks, Gulshan…
Re: Will ontape backup to disk damage the disks?
Neil Truby wrote: > <roger@star2000.com.tw> wrote in message > news:7ae423ab-44fc-4411-8497-f900f500b8b4@t26g2000prh.googlegroups.com... >> 3 instance on AIX 5.2 ids 9.4 box. >> I do label 0 backup and compress to disk file daily >> and then tar all the disk files to tape in c…
Format integer to "00" in store procedure
How can I convert or format an variable that will contain a number (let's say 4) as "04" in informix store procedured Here are more examples: initial value desired value 1 01 6 06 9 09 13 13 Thanks…
ODBC connection failing
Hi All We just migrated to a new unix server from an old one with Infiormixv7.3 installed. But while we were able to connect to the old database server we are not able to do the same in the new. I am getting this message [INTERSOLV][ODBC Informix Driver][Informix] user's pass…
Informix Roundup: 30 November 2008
http://obotheclown.blogspot.com/2008/11/informix-roundup-30-nov-2008.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…