Threads from 2007
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Oracle University Turkey ... follow-up
I have become aware of some relevant information I thought I'd share as, unfortunately, this little drama is playing out here in c.d.i. Source: http://www.oracle.com/technology/software/popup-license/xe-license.html License Rights We grant you a nonexclusive, nontransferable li…
[Fwd: RE: IDS Features - MAX_PDQPRIORITY]
Just double checked. We're both wrong. With PDQPRIORITY zero no parallelism is enabled. PDQPRIORITY 1 or LOW enables parallel scans ONLY. PDQPRIORITY 2 or greater enables fragment elimination, parallel sorting, and MGM memory use. Art S. Kagel Oninit On Dec 28, 2007 10:47 AM, G…
RE: Kansas City, gateway to .....
> Date: Thu, 27 Dec 2007 23:28:06 -0600 > From: paul@oninit.com > Subject: Re: Kansas City, gateway to ..... > To: informix-list@iiug.org > > Never had a single problem with US immigration apart from the length of > the queues in O'Hare. I've done 15 minutes flight to flight vi…
Re: Attention Mark Townsend of Oracle Corp.
dcruncher4@aim.com wrote: > In article <mailman.170.1199067637.20610.informix-list@iiug.org>, Ian Michael > Gumby says... > >> Mark isn't Oracle Legal and no matter what he says, it has no legal bearing >> on anything concerning Oracle's licensing policies. >> That was a given. >…
Re: Attention Mark Townsend of Oracle Corp.
dcruncher4@aim.com wrote: > In article <477849ED.1080004@psoug.org>, DA Morgan says... > >> With respect to the posting it is important to remember we are >> seeing only one side of the issue, that of the person that posted >> it, and it may well be that he has misinterpreted wha…
What Is Linux?
Linux is a free operating system that was created by Linus Torvalds when he was a student at the University of Helsinki in 1991. Torvalds started Linux by writing a kernel - the heart of the operating system - partly from scratch and partly by using publicly available software. …
RE: Attention Mark Townsend of Oracle Corp.
> From: dcruncher4@aim.com > > In article <mailman.170.1199067637.20610.informix-list@iiug.org>, Ian Michael > Gumby says... > > >Mark isn't Oracle Legal and no matter what he says, it has no legal bearing > > on anything concerning Oracle's licensing policies. > >That was a giv…
M I.5 Persecut ion 22,54 4 + 837 = 23, 381
MI5 Persecution Update: Friday 7 April,. 2000 22,544 + 837. = 23,381 Last weekend I delivered. another 837 faxes to politicians and the media on the subject of the security service conspiracy which has. destroyed my life. This. brings the total in the last three years to at lea…
M-I,5`Persecution ` M I5 Ins ist th at t hese Fax es m ust Contin ue
MI5 Persecution Update: Friday 31. March, 2000 22,544 Faxes Delivered in. Three Years, and Still No Breakthrough In. the last three years I have sent at least 22,544 faxes to recipients in the UK,. of which at least 13,974 have gone to Westminster. Last weekend alone I sent 832…
M.I'5`Persecutio n ` MI 5 Wan t Me to Send Yo u the se Faxes
MI5 Want Me to. Send You these Faxes MI5 seem to Want to Spin this Business. out for as Long as Possible The MI5 persecution has now been going on, starting from. June 1990, for well over nine years. If I knew. how to put an end to it then I would do so. Of course MI5 have indi…
M-I 5.Persecu tion ` T hree Yea rs of M I5 Pe rsecution Fax es
Three. Years of "MI5 Persecution" Faxes Ten Thousand. Faxes, and Still No Breakthrough In the last three years. I have sent at least 5,301 faxes directly from my computer, and 4,478 faxes through. Demons extremely useful TPC.INT service, to. politicians and the media, in the su…
M I.5,Persecuti on , Harassmen t thr ough th e Ra dio
MI5 Persecution Update:. Friday 9 July, 1999 Harassment in. Poland, July 1999 And still it continues.... in my last fax I. said that provided MI5 made no attempts at. harassment during my two-week holiday this summer, or after I returned to England, then I would discontinue the…
M,I.5 Persecutio n , MI 5 Ha ve Syste matically Destroy ed My L ife
MI5 Have Systematically. Destroyed My Life This is getting depressing. From the feedback. Ive received, the recipients of these. faxes are tired of hearing my complaints, and in truth I am tired of sending. them. The reason I havent yet ceased sending faxes is because I cannot t…
M`I,5.Persecutio n . No Just ice for t he Vi ctims of M I5
MI5. Persecution Update: Friday 11 June, 1999 Harassment in a pub in. Clapham, Tuesday lunchtime Once. a month, or once every other month, I meet a Polish friends of mine who lives in Clapham North, and sometimes we go to. a particular pub near where he lives. The last time was…
M'I`5'Persecuti on ' M I5 a re A fraid to Admit T heyre Be hind t he Persecution
MI5 are Afraid to Admit They're Behind. the Persecution MI5 have issued a formal denial of any involvement in my life. to the Security Service Tribunal, as you might expect them to;. but, more importantly, the persecutors have. never denied that theyre from the Security Service,…
M`I,5-Persecut ion . Molesta tion durin g Trav el
MI5. Persecution: Molestation during Travel MI5s persecution of me varies in. intensity. Since 1990 it has been steady for. perhaps 80% of the time; there was a notable quiet period in 1993, and another quiet period in Jan-Feb 1995, as well as a hiatus in the first. two months o…
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
AGENCY WARNING: prospectus.co.uk
This agency is blacklisted by the confederation of multi-value systems professionals. They are known for large scale larceny and fraud. AVOID…
RE: Attention Mark Townsend of Oracle Corp.
> From: dcruncher4@aim.com> > In article <477849ED.1080004@psoug.org>, DA Morgan says...> > >With respect to the posting it is important to remember we are> >seeing only one side of the issue, that of the person that posted> >it, and it may well be that he has misinterpreted what…
Re: Attention Mark Townsend of Oracle Corp.
dcruncher4@aim.com wrote: > In article <6528j.24116$4V6.7387@newssvr14.news.prodigy.net>, Mark Townsend > says... > >> I do work for Oracle, I am an official spokesperson for Oracle >> (http://www.oracle.com/corporate/pressroom/html/mtownsend.html). >> >> I don't read newsgroups …
Long Transaction
Version: IDS 10 How can I track "tx" in following message: "Aborting Long Transaction: tx 0xc0000001f4b64938". Is "0xc0000001f4b64938" the user address that comes in onstat -u ? I am trying to track which process caused the long transaction. I have a script that runs every 15 mt…
urgent | | is inserted in text field with /
The goal is to insert a string containing | | in a column of text type when we try to insert a query containing pipe ||in a text field , the result of insertion shows that supplementary junk slash are added to pipe as indicated below for IDS version 9.4 1°/ sample of the begenn…
Memory Performance Tweak
These Settings will fine tune your systems memory, management -at least 512MB of ram recommended, go to start\\run\\regedit -and then to the following key http://software-hacks.blogspot.com/…
Re: JOIN issue
On Dec 28, 2007 3:39 PM, Kennedy, Randy <RKennedy@scottsdaleaz.gov> wrote: > I am trying to do a join in an SPL routine and it is not returning what I am > wanting so any help is appreciated: > Informix 9.4FC3 on HPUX > > I have a view created that joins 3 tables and that returns…
Can I know the last time when I run 'onstat -z' ?
Is ids server will record the timestamp when we run 'onstat -z' ? Can I get any information from sysmaster database or else ?…
JOIN issue
I am trying to do a join in an SPL routine and it is not returning what I am wanting so any help is appreciated: Informix 9.4FC3 on HPUX I have a view created that joins 3 tables and that returns a 27k row view. Within my SPL, I want to join this view to 3 tables, ensuring I ge…
RE: Kansas City, gateway to .....
Uhm, Do you really want to fly anything called "Skybus" ? :-) And yes, Cow-lumbus OH is their main hub. So you'll be spending the night at one of the "no tell motels" by the airport. If you try and practice a midwestern accent and say "How you doing?" to the guys at the immigr…
RE: Kansas City, gateway to .....
> From: neil.truby@ardenta.com > Subject: Re: Kansas City, gateway to ..... > Date: Thu, 27 Dec 2007 22:59:54 +0000 > To: informix-list@iiug.org > > >> You're already looking to the "next" event before the first event is even > >> off the ground. :-) The reason KC was chosen was…
Re: IDS Features - MAX_PDQPRIORITY
On Dec 27, 4:36 pm, Dave <In4Mix...@gmail.com> wrote: > Hello, > > Aside from fragment elimination, are there any other features that are > enabled by IDS that result from setting MAX_PDQPRIORITY to 1 (or > greater)?? > > Any help would be greatly appreciated. At PDQPRIORITY 1 o…
Informix Shared Library Trouble
I am trying to create a shared library written in C which is using lots of Informix functions such as `ibm_lib4gl_popQuotedStr'. Platform is Linux and compiler is GCC. But I am getting linker error, "undefined reference" for all the Informix functions that I use. LD_LIBRARY_PAT…
Difference between Physical and Logical Logs?
I am a new user of Informix. I would like to know the difference between physical and logical logs in informix dataserver?…
RE: dbaccess - return key does not work?
... and a good one to boot. j. -----Original Message----- From: Sebastian, Norma J. [mailto:NormaJean.Sebastian@tellabs.com] Sent: Thursday, December 27, 2007 9:25 PM To: Jack Parker; Andrew2006; informix-list@iiug.org Subject: RE: dbaccess - return key does not work? Jack, An…
RE: dbaccess - return key does not work?
Jack, Andrew, Could there be an stty setting in the way? I know on solaris sometimes my .profile (ksh) or .cshrc (csh) can have unexpected stty settings (unexpected for me, but perhaps good for some application or someone). An unexpected STTY setting can hose up my backspace key…
IDS Features - MAX_PDQPRIORITY
Hello, Aside from fragment elimination, are there any other features that are enabled by IDS that result from setting MAX_PDQPRIORITY to 1 (or greater)?? Any help would be greatly appreciated. --Dave…
Re: Kansas City, gateway to .....
Dallas? Try st. louis. St. Louis is the murder capital of the U.S... If you survive your connection through st. louis think of the stories you can tell the family when you get home... > --- Dirk Gunsth�vel <dirk@guncon.de> wrote: > > > Dallas is an option too... its only 30…
RE: Kansas City, gateway to nothing
The drive from st. louis to kansas shitty is only 3 and a half hours. > --- Ian Michael Gumby <im_gumby@hotmail.com> wrote: > > > > > Chicago is the closest. > > > > You may want to fly in and possibly switch > airlines > > on the US leg of your trip. > > > > > From: neil.truby@…
Which informix client to use
I am new to informix. I have installed IDS (version---IIF_et.10.00---)on my windows machine.I have some informix scripts which i want to run,can anyone please guide me which client tool to download and install in order to run informix statements.. It will be helpful for me if u c…
Re: myexport and Informix 11 compatibility
On Dec 26, 7:03 pm, Scott Newton <scott.new...@integralgroup.co.nz> wrote: > If I use myexport to export an Informix 11 database and then try to import it > with myimport or dbimport I get the following error: Scott, The problem's not in myexport itself but in myschema. It loo…
Re: Connect to IDS from Open Office 2.3.1
This is now working on another machine. Something hinky is definitely happening on this box. The only remaining problem is that it refuses to allow certain SQL standards. It doesn't like SQL80/Informix syntax queries and it won't allow EXECUTE FUNCTION/PROCEDURE statements. <s…
Re: upgrade ifx 10 to 11 via ontape L0
Yes, if you move the physical chunks to the new machine one way or another, you can just bring the engine up with the new version and it will perform an in-place upgrade. However, if that fails or there are any bugs or performance problems you can't get around you may want to do…
dbaccess - return key does not work?
Hi there, Can anyone recommend a tutorial for using dbaccess in menu mode? When prompted to hit return, e.g. "Select a server with the Arrow Keys, or enter a name, then press Return." I can move the cursor to highlight the database but hitting return causes the cursor to move f…
Re: Kansas City, gateway to .....
Dallas is an option too... its only 30 mls or something longer to Kansas City. I fly there often and never had any problem. And I dont think thats because they trust Germans a lot there ;-) Dirk "Paul Watson" <paul@oninit.com> schrieb im Newsbeitrag news:mailman.141.1198724183.…
RE: Performance Tuning of batch insert and batch update using JDBC API.
I think Marco hit the nail on the head. If you have the same table structure, same java application... your only differences are on the layout and tuning of the engine, and the jdbc driver. (Unless you're using DRDA....) The differences in the JDBC driver wouldn't cause this bi…
myexport and Informix 11 compatibility
If I use myexport to export an Informix 11 database and then try to import it with myimport or dbimport I get the following error: CREATE AGGREGATE 'informix'.genxml WITH ( INIT = init_aggrxml, ITER = iter_aggrxml, COMBINE = comb_aggrxml, FINAL = final_aggrxml, …
Re: Long fuzzy checkpoint
I think is unlikely that the problem is related to the fact this is a "fuzzy" checkpoint. If you don't see that the prolem is I/O, maybe th eproblem is that a thread is in critical section (look in onstat -u for a thread with the "X" flag). Then try to analyze what is this thread…
RE: Long fuzzy checkpoint
Omar, I don't know the exact details/science, but you could rid yourself of fuzzycheckpoints by just turning them off. Your regular checkpoints will still happen, just not the fuzzy's. In the environment of the user that starts informix, set NOFUZZYCKPT to 1, then stop/start In…
Long fuzzy checkpoint
Hi. I've seen on my site that sometimes a fuzzy checkpoint takes more than a minute to end. We have configured LRU limits in order to activate cleaners (2 and 1% for 384 LRUs. There are 950000 buffers of 2 Kb each) and 5 minutes of checkpoint interval. Problem persists, and i…
syslog
Hi, Curious to know if there is a way to reroute all informix messages to syslog instead of MSGPATH config parameter. 1st time posting..........…
Re: upgrade ifx 10 to 11 via ontape L0
Martin Fuerderer wrote: > Hi, > > backups are not to be used for restore in a different version of IDS. > Therefore they are not useable for upgrades. Right, thanks everybody. I just wanted to know if a server migration from one box to another with an ifx upgrade is possible wit…
Re: Connect to IDS from Open Office 2.3.1
Art S. Kagel wrote: > I am trying to connect to an IDS database > from Open Office v 2.3.1 using an ODBC connection. I once tried the same thing. It was OO version 2.1 maybe then. I got it to connect to the server I think, but it couldn't find any tables at all for some reason. …
Doubts about replication
Hello, folks!!! I´m in a hurry, testing a primary-target based replication using IDS 9.4. That´s all working fine, except that when my replicated db instance is down (offline), my sbspace fill so fast that I had to adjust it. After I resized it, I made several tests again, and it…
Javier Gomez Lopez/Spain/IBM no está en la oficina
I will be out of the office starting 24/12/2007 and will not return un= til 31/12/2007. Estar=E9 fuera de la oficina hasta el 31 de Diciembre.=…
How to get the DAY OF YEAR - IDS10 UC5
Hi All, Is there any built-in function in INFORMIX to get the day of year? I am using IDS10 UC5. For example, it should return 360 for the date 26-Dec-2007. Regards, Navaid Arif…
Re: HDR Problem, AIX5.2 IDS 9.40.FC5
On Dec 17, 4:04 pm, ruediger.pa...@t-online.de wrote: > Hi, > we have a strange HDR-Problem: > OS AIX 5.2 ml 4.0 > IDS 9.40.FC5 > > The system has been working without big problems for a long time. > For synchronisation we have a fast cross -link-connection seperated > from user…
Branding error while Installing informix on solaris
I got branding error while trying to install informix on solaris environment. Can anyone help me to fix this error????…
Medicine Assistance Is Donated To The Uninsured
As a counselor I am always looking for helpful programs. Here is a good one offered by American Consultants Rx at http://www.rxassistanceforfree.info .Free discount prescription cards with no enrollment or eligibility requirements as well as saving my clients up to 60% off of the…
Shopping Deals
Hey this site really helped me.I am always in search of the best deals online. Check out another site that I came across at http://www.justfordiscounts.com that I came across.Great onestop marketplace.…
Re: suppressing username and password prompts in dbaccess
On 19 дек, 16:47, skurlan...@yahoo.com wrote: > Hi, > > Our site is running Informix Dynamic Server 11 on Linux. Currently, > when connecting to a server using dbaccess the user is prompted for > his user name and password. What options are available so providing a > user name …
Performance Tuning of batch insert and batch update using JDBC API.
Hi All, I am trying to Insert as well as Update 1000,000 records to a table using JAVA JDBC Batch Update API's . Where my batch size is 10,000. Informix 10.0 is taking approx 350-400 secs for insertin of 1000,000 records. The same is taking 20-25 secs in DB2 9. Wanna tune…
Re: Kansas City, gateway to .....
Neil it should be 14 (ish) hours door to door unless you've moved house :-). I normally fly Continental and the flights are typical $600 - it cost me more to fly to Vienna for the European conference Cheers Paul Neil Truby wrote: > Has anyone involved in choosing Kansas City…
Re: Archive to disk to iSCSI device
On Dec 21, 10:33 am, dcrunch...@aim.com wrote: > In article <86b1697f-b6be-4392-a5d8-50e556f54...@l32g2000hsh.googlegroups.com>, > Art S. Kagel says... > > >> And if so, as far as I know, doing this still has to be in 2gb files > >> due to limitations on disk. If that is the case…
RE: Archive to disk to iSCSI device
What if you turn on large chunk support? I know you can do that in 9.4 but we didn't. Even with large chunk support the backup utility might be coded differently and choke you at 2GB. ============================================================ The information contained in this…
Myschema and myexport bug
Just an alert. There is a minor bug in myschema which also affects myexport. If you try to use the '-U statsfile' option of myschema to write update statistics statements recreating the current state of data distributions into a named file or the '-u' option of myexport it will…
Archive to disk to iSCSI device
Has anyone used an iSCSI connection on AIX 5.x to perform "archive to disk"? And if so, as far as I know, doing this still has to be in 2gb files due to limitations on disk. If that is the case, I would have 160 2gb files since our database is approx 320gb. Restore would be a ni…
Cannot drop stored proc after crash
I have got IDS version 9.40.HC4-HPUX-32 on hp-ux 11. While one of the stored procs has ran, IDS crashed with following error in online.log: Message Log File: /informix/logs/ncc.log Thread(392, sqlexec, 802e23a4, 1) File: mtex.c Line: 377 10:14:21 Action: Please notify IBM Info…
Adult Entertainment
Hot site to pass the time. I definitely will pass it on to my friends as well!Deborah--Free Sex For Dummies--http://www.freesexfordummies.net…
RE: Kansas City, gateway to .....
What you guys feel more comfortable wandering around erecting stuff? We're too prudish for that phrase. j. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Obnoxio The Clown Sent: Thursday, December 20, 2007 4:…
RE: Kansas City, gateway to .....
And here in the midwest we have this thing called weather.... BTW jgp you divide by 1.43 That is that the $1.43 USD gets you 1 Euro. As to driving... >From Boston to Chicago, you're between 14-18 hours depending on how fast you drive, number of breaks and weather. Chicago to …
Re: Connect to IDS from Open Office 2.3.1
An update: I haven't been able to get a JDBC connection setup at all, but that's most likely partly my aversion to all things Java ;-) and part my Windows blindspot. I still don't have the ODBC working in OO.o but it works everywhere else. However, this machine is a bit flaky.…
RE: Kansas City, gateway to .....
I try to work my boss paying for Kansas, so wish me luck. Jean: You need a german driver, you french guys also have a handicap named speed limit, we don´t ;-) regards, Joerg Volz > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-boun…
RE: Kansas City, gateway to .....
I guess I'll land in Boston, ask stuart to pick me up and we'll drive the Corvette to KC, with my driving, it'll take a few hours (of fun)... ;-) -----Original Message----- From: Sebastian, Norma J. [mailto:NormaJean.Sebastian@tellabs.com] Sent: Thursday, December 20, 2007 07:2…
RE: Kansas City, gateway to .....
You could fly to Chicago, rent a car and drive down (it's only about a 9 hr drive per mapquest). Might be about the same driving up from Atlanta. All sorts of fun options to get to the middle. ============================================================ The information contained …
RE: Kansas City, gateway to .....
Aaaah ce Neil alors... and you're always travelling biz class, so it's gonna be long but comfortable. it was chosen because it is in the middle of nowhere, sorry, the US... the worse thing is indeed that you need to fly from the Kansas City to Overland Park, it is sooooooo far a…
RE: suppressing username and password prompts in dbaccess
First .rhosts is user controlled and you as a system administrator lose control of securing your system. As to having the same password, you could have a central authentication system like OLAP since the Unix/Linux systems support PAM, you can us a common authentication system. …
Kansas City, gateway to .....
Has anyone involved in choosing Kansas City as the venue for the IIUG Conferene ever tried to travel there from "international"? I'll need to leave in early March to get there on time, having first arranged a mortgage to pay for the air-fare ... ;-)…
RE: suppressing username and password prompts in dbaccess
Geez! How many times does it take before the message sinks in. .rhosts BAD. VERY BAD. BAD IDEA FROM THE START. You should NEVER, EVER LET YOUR USERS use .rhosts since it effectively allows them to say that Machine A is a safe and trustworthy machine. Not a problem if Machine …
Ad Hoc Queries and Reports Software
AIX 5.2 IFMX 9.40 Does anyone know of a program (possibly web-based) that does not require VPN access to run but would allow, via an odbc connection, ad hoc queries and/or report generations against 9.40 / 10.0 IFMX database engines? Customer is currently using software named …
RE: suppressing username and password prompts in dbaccess
NO!!! NEVER USE .rhosts and or hosts.equiv. Ok, so that may be an overkill. As a systems administrator, I routinely sweep my systems for users who use .rhosts. This is a big security no no. With respect to hosts.equiv, you need to be careful and limit this to machines that ar…
suppressing username and password prompts in dbaccess
Hi, Our site is running Informix Dynamic Server 11 on Linux. Currently, when connecting to a server using dbaccess the user is prompted for his user name and password. What options are available so providing a user name and password is unnecessary, as the username and password…
Automation Basics and Advanced Courses Starting from December 24th.
Training Courses on : Automation Basics course: Automation Fundamentals, VB Scripts Basics, QTP Basics Fees: 1500 Rupees ++++++++++++ +++++++++ +++++++++ +++++++++ +++ Automaton Advanced course: QTP Advanced Features, Automation Frameworks, Project, Quality Center Fees: 2000 Rupe…
How to report suspected bug in Developer Edition
I've got the Developer Edition going on 32-bit Vista Ultimate and have run into what might just be a small bug. I'm struggling to wade through the IBM website to find out how I report it without taking out an expensive agreement. Can anyone point me in the right direction? The p…
Re: upgrade ifx 10 to 11 via ontape L0
Hi, backups are not to be used for restore in a different version of IDS. Therefore they are not useable for upgrades. You are adviced to take a backup before upgrade, but that is just for data safety. To restore it you'd first have to go back to the version with which the back…
Re: upgrade ifx 10 to 11 via ontape L0
On 18/12/2007, Aleksander Kamenik <aleksander@krediidiinfo.ee> wrote: > Hi, > > Is it possible to load the full ontape level zero backup from ifx 10 xC4 > on to a 11 xC2 version? Both would be running on 32bit linux boxes. > > Or is the only way for upgrade to install ifx 11 inst…
upgrade ifx 10 to 11 via ontape L0
Hi, Is it possible to load the full ontape level zero backup from ifx 10 xC4 on to a 11 xC2 version? Both would be running on 32bit linux boxes. Or is the only way for upgrade to install ifx 11 instead of ifx 10 and then give ifx 11 the path to the ifx 10 data on disk and just …
Mix in encoding...
Hi, I am running an engine which we want to be en-us.utf-8 (we want it that way to have the maximum flexibility over ANY character set, if we are wrong, please advice). Nevertheless, we have a couple of apps that uses it fine, setting DB_LOCALE and SERVER_LOCALE. Unfortunately…
Error message in the online log - CDR CDRDS
Hi, Below is an excerpt from my online log. There are a number of replicates set up through ER (around 80) and I'd love to know how to find out: 1. Are the aborted transactions a problem (have I lost data?) 2. Which replicate are they for? 3. What row did they relate to - do I ne…
Ease of moving from Informix 4GL to Progress 4GL
I have an opportunity to do some work with Progress 4GL for a client and wondered if anyone could give me some insight as to how easy it would be for me to pick up Progress 4GL given a decent background in Informix 4GL. My Informix DBA skills are very strong (about 5 years exper…
Solve any your Software problem
Find solution for any your problem with Windows XP http://windows-xp-tricks.blogspot.com/…
rstrdate() function problem
hello everyone im recentrly have an strange problem with rstrdate() i have a column A varchar 20,1 and i must compare it with a column B date to compare it, i use rstrdate() function and im very happy with that now my problem start when execute the query from a procedure. it h…
Fuzzy vs Full Checkpoints v10.00.UC6
All, I am stymied as to why we see our engine performing full checkpoints as opposed to fuzzy checkpoints. In looking at the Admin Guide I understand the scenarios under which each type of checkpoint should occur. In our situation, based on the scenarios described we should not …
basename C function on HPUX IDS misbehaving
Hi, I am having a problem with migrating some esql code from Informix 10 to Informix 11.10FC1. The OS is HPUX 11i. The code does a lot of file handling tasks & uses the basename function which is in the libgen library. However when rebuilt on 11, this function is behaving strang…
Upgrading from 7.23 to 11.10
We are upgrading from 7.23 to 11.10 and have came across an issue that I would appreciate some help with that does not occur on our current system: We have a process that checks a table exists (table X), opens a transaction, creates some indexes on the table and then renames the…
Connect to IDS from Open Office 2.3.1
My turn to need some help. I am trying to connect to an IDS database from Open Office v 2.3.1 using an ODBC connection. From this PC I can connect to the DB natively and I can also query the DB using RazorSQL connected via ODBC. I have created an ODBC connection in Open Office…
Does dynamic log allocation prevent a rollback?
If you have DYNAMIC_LOGS set to 2 and a transaction crosses the HWM, does the setting of DYNAMIC_LOGS avoid it being rolled back, or does that feature only exist to circumvent problems associated with long transaction rollback? System will be running 10, probably go to 11 next y…
HDR Problem, AIX5.2 IDS 9.40.FC5
Hi, we have a strange HDR-Problem: OS AIX 5.2 ml 4.0 IDS 9.40.FC5 The system has been working without big problems for a long time. For synchronisation we have a fast cross -link-connection seperated from user connections. Normal Checkpoint duration is some seconds. Sometimes …
Mix in encoding...
Hi, I am running an engine which we want to be en-us.utf-8 (we want it that way to have the maximum flexibility over ANY character set, if we are wrong, please advice). Nevertheless, we have a couple of apps that uses it fine, setting DB_LOCALE and SERVER_LOCALE. Unfortunately…
Re: SQuirreL and Informix
On Dec 14, 5:58 pm, "prich...@blm.gov" <prich...@blm.gov> wrote: > Thank you for answering so quickly. > > I tried "jumping" using the Catalog pull down, but I get the error: > > Error loading object type UDT Type. Error: java.sql.SQLException: > Another routine (mode_decode) wit…
FW: In-place upgrade IDS 10.0.FC3 -> 11.10.FC2
We have upgraded a development instance with approx 120 small databases total 10Gb. The actual upgrade took half an hour (to Informix process to upgrade System database and our 120 databases - excluding backup and onchecks). With only a couple of databases the upgrade would be …
MI5-Persecution: MI5 Have Systematically Destroyed My Life (31728)
MI5 Have Systematically Destroyed My Life This is getting depressing. From the feedback Ive received, the recipients of these faxes are tired of hearing my complaints, and in truth I am tired of sending them. The reason I havent yet ceased sending faxes is because I cannot think…
MI5-Persecution: No Justice for the Victims of MI5 (29545)
MI5 Persecution Update: Friday 11 June, 1999 Harassment in a pub in Clapham, Tuesday lunchtime Once a month, or once every other month, I meet a Polish friends of mine who lives in Clapham North, and sometimes we go to a particular pub near where he lives. The last time was som…
MI5-Persecution: MI5 are Afraid to Admit Theyre Behind the Persecution (27362)
MI5 are Afraid to Admit They're Behind the Persecution MI5 have issued a formal denial of any involvement in my life to the Security Service Tribunal, as you might expect them to; but, more importantly, the persecutors have never denied that theyre from the Security Service, des…
MI5-Persecution: Molestation during Travel (25179)
MI5 Persecution: Molestation during Travel MI5s persecution of me varies in intensity. Since 1990 it has been steady for perhaps 80% of the time; there was a notable quiet period in 1993, and another quiet period in Jan-Feb 1995, as well as a hiatus in the first two months of 19…
MI5-Persecution: BBC Newscasters Lie & Deny Theyre Watching Me (22996)
MI5 Persecution: BBC Newscasters Lie & Deny They're Watching Me Central to the persecution campaign waged against me for some nine years now by the Security Service is their use of the media, and in particular the broadcast media, to make clear to me that I am under surveillance…
MI5-Persecution: Four Years of MI5 Persecution Posts on Internet Newsgroups (20813)
Four Years of "MI5 Persecution" Posts on Internet Newsgroups For approximately the first three years of the MI5 persecution, from June 1990 until late 1992, I kept as quiet as possible, in the hope that by not reacting, MI5s interest in me would decrease and they would simply go…
MI5-Persecution: MI5 Waste Taxpayer Millions on Pointless Hate-Campaign (18630)
MI5 Persecution Update: Friday 30 April, 1999 If You Intend To Reply, Please Read This Please.... keep your response to one page!. Faxes over a page or two will be deleted without being read. Somewhere between 0 and 100% The last few days there have been no clear recordable in…
MI5-Persecution: Comparing the MI5 Persecution with German Final Solution (16447)
MI5 Persecution Update: Friday 16 April, 1999 If You Intend To Reply, Please Read This Please.... keep your response to one page!. Faxes over a page or two will be deleted without being read. BBC newscaster Nicholas Witchell cant stop himself laughing During 1990-91 there were…
MI5-Persecution: Browse the Website (14264)
MI5 Persecution Update: Friday 25 March, 1999 If You Intend To Reply, Please Read This Please.... keep your response to one page if you can!. Faxes over a page or two will be deleted without being read. The Usual Words The persecutors-who-wont-admit-theyre-MI5 have been active…
MI5-Persecution: How to Identify the Persecutors (12081)
MI5 Persecution Update: Friday 19 March, 1999 If You Intend To Reply, Please Read This Please.... keep your response to one page if you can! I have had several people faxing my article back to me, including one MP faxing back twenty pages. Faxes over a page or two will be delet…
MI5-Persecution: BBC Newscasters Spying on my Home (9898)
MI5 Persecution Update: Friday 13 November, 1998 If You Intend To Reply, Please Read This If you have any questions or observations you would like to share with me, then you are very welcome to reply to my fax number 0171-681-1190. But please.... keep your response to one page …
MI5-Persecution: .net Magazine Applauds my Website (7715)
MI5 Persecution: .net Magazine Applauds my Website The March 1998 issue (number 42) of .net Magazine reviews the MI5 Persecution website describing it as an "excellent site". The webpages describe in detail the nature of my persecution since 1990 by what are believed to be eleme…
MI5-Persecution: Why would they be doing this to you, sir? (5532)
MI5 Persecution Update: Friday 15 May, 1998 The persecution has been quite severe for the last week. It appears that my enemies are reacting to the steady stream of faxes making their way over the Atlantic to the fax machines of Westminster politicians and the media. Here is wha…
MI5-Persecution: Why do you think MI5 are responsible? (3349)
Why do you think MI5 are responsible? The question of who is ultimately responsible for this eight-year harassment is one which is very difficult to answer, as the persecutors have never clearly made their identities known to the persecutee. However, I believe I am correct in at…
MI5-Persecution: How Could It Be True? (1166)
MI5 Persecution: How Could It Be True? If you have the patience to read these articles you will be struck by how apparently fantastic the claims being put forward are. You may ask yourself why such seemingly nonsensical assertions are made. This matter has been discussed on the …
SQuirreL and Informix
All the competent people have left my work place and I'm stuck with administering Informix 940uc3. In my attempt to gain understanding I installed SQuirreL and have it working. However, my limited knowledge forces me to create an Alias for each database_name for each INFORMIXSE…
Single vs multi cpu ids
Can you guys help me build a list of funtionality that changes or is not available when you have a single cpu vs a multi cpu environment? Please send me your thoughts so I can compile a document on this. Thanks, Kate (Sent by Blackberry)…
VMWARE and Informix Databases
Hi all, I need to know what your experience has been with Informix v11 on VMWare with Linux. Has anyone tested whether we need to allocate two virtual CPUs to make the parallization work best as we did with previous versions, or is this useless since under the covers their is rea…
Encrypting onsoctcp / ODBC traffic
Good morning, Has anyone implemented encryption / secure communication at the SOCs level? I=B9m looking to secure traffic via onsoctcp to Informix 10.00.FC5. I assume that the SDK ODBC client will work with security encryption at the soc level. Any information, experience, or in…
Real basic oncheck onmonitor question
Hi everyone. Please pardon my basic generic question here-just trying to be careful. I want to 'play' around with oncheck and onmonitor in a dev environment a bit. So I have the Informix 9.4 admin manual that talks about these utuils. Here's my question..with oncheck it is safe t…
Re: IBM Informix Support Exchange Program
On Dec 5, 11:30 am, scottishpoet <drybur...@yahoo.com> wrote: > IDS 11.10 - Monitor and analyze recent SQL statements > Suma Vinod December 13th - 2007, 11am ET > > For Webcast and dial in details please see > > http://www.iiug.org/news/announcements/partner_training.php Suma ha…
Re: Where The Fuck is the Informix Developer Edition V11 Download?
dcruncher4@aim.com wrote: > In article <475F87A0.6060405@sbcglobal.net>, Mark Townsend says... >>>>> Madison - your are reading this wrong. I wrote the license for XE and >>>>> it does not 'inherit' restrictions from any other license. You can >>>>> use XE freely for whatever you…
paulm
Hi Paul, Another of those machines I cannot get to directly v210-11 (192.168.5.225) Is thers a routing table problem ? It's a bit of a pain in the butt.…
Usage WIN32PASS
Hi, there are several env variables for Informix and Microsoft Windows like: WIN32USER and WIN32PASS Is ist possible to fill WIN32USER and WIN32PASS with the Windows username and userpassword? Thanks Sven -------------------------------------------------------------------- S…
Requirement:PeopleSoft HRMS/Financials Consultant,Location:singapore
Dear Friends, KCOTS software, would like to forward exciting job opportunities available with our client in Singapore. Position:Peoplesoft Financial Consultant Location:singapore Requirements: Degree in Computer Science or equivalent. 3-6 Years of experience in Peoplesoft Finan…
RENAME TABLE ERROR
Hi. Recently I discovered in the production DB of the company some tables with OWNER different from INFORMIX. I decided to make a RENAME TABLE of the tables to change the such owner which indicates the documentation of IBM When executing "RENAME TABLE dbo.ct_rhhlaboralr5 TO infor…
Error in ontape
hi I am trying to replicate IDS10 in another system thru ontape. I took Level 0 backup of source IDS10 and trying to restore in destination IDS10. ontape -s -L 0-t STDIO>level-0 (In source IDS10) I copied this level-0 file into Destination IDS10 and run the following command 1)c…
Where is charming Afterburner when we need him?
134.1.210.107:1459 open socks4 proxy was used on 23 November for a Hipcrime attack on nanae. And I got the port number by Googling so it must have been open and was probably abused before that date. It was used late North American Monday for a Hipcrime attack on 24hoursupport.he…
ER question
HI, Folks, A question about ER update anywhere implementation. If a row update ( from site C) can not be completed on site B ( because the corresponding row does not exist at that time, it was originated at site A and has not arrived at B yet), can we allow the update at B to h…
Re: Moving a chunk - a related question
Hi, thanks very much for the responses. I did indeed re-link the down primary chunk to a new device and used onspaces to bring that chunk back online. (I had already tried that in the first place and got "Chunk does not exist" errors - which is why I thought I couldn't do it, but…
Extent DB
After reading a lot in the docs I did'nt find an answer and try to get an answer here. I have an IDS10 with one dbspace on a single disk with one database in it. What can I do if the disk is full ? As far as I know I can't resize a dbspace nor span a dbspace on more disks ? Is th…
assert failures
Hi, Any ideas on this assertion failures notised in message log of Informix on HP-UX 11i ( what kernel paramiters HP-UX are response for this sytuation ) IBM Informix Dynamic Server Version 7.31.FD9 10:43:51 Who: Session(769, upos604@ldfb010pr, 9407, -1123270840) Thread(7946, sq…
Single database backup using ontape
hi I am a newbie in informix. I am searching if there is any way of taking database level backup rather than whole system(-s) or dbspace wise backup? Any parameter to specify Database name. If it is so then what will be the backup and restore command?…
Unable to perform delete (error 12097)
sql that results in this error. DELETE FROM tc_cad_preload WHERE oid="a0dec1974db1f34c0114ba2129870000"; Results in: -12097 12097 Smart Large Objects: open: Bad smart-large-object address. Object might have been deleted. Object might have been deleted. I am running IDS 9.4 a…
Monitoring Physical logging
Informix Version 10: Does physical log have extents ? It may sound a dumb question, but what I am seeing is that in onstat -d physical log show 0 pages free but I don't see any errors. onstat -l report .05% used. So I am wondering, is it like other dbspaces where once the space …
Warning - Cannot retrieve ... ???
Hello, I'm using SSIS (SQL Server Integration Services) via Native Informix OLE DB provider to extract (ETL) data from Informix 7.3 to SQL Server 2005. I have following problem, when I try to connect to the Informix database I'm getting : Warning - Cannot retrieve the column …
informix-list <-> cdi link ...
.... seems to be broken yet again.…
Informix Development Webinar December 11, 2007
IBM is apparently hosting this event tomorrow: "Develop applications the fast and easy way with IBM and deploy them worry-free with IBM Informix Dynamic Server (IDS). The new IBM Data Studio can help you produce high quality data designs and allows you to easily view and modify …
IDS 7.31UD1 on Solaris8
Hello, A few months ago, I installed IDS 7.31UD1 on a Solaris8 server. Untill now the server was not used very often, but we are supposed to put it in production within a few weeks. Since a few days now, every morning at 06:30 the server crashes with the following messages: 06:…
Informix Profiling tool.
Hi, I would like to monitor all the SQLs executed or running in the Informix Engine. I can use "onstat -g sql ..." utility but this will show the active SQL's information, but i would like to see the history SQL's status as well. I heard that "onaudit" can be used to capture all…
Where The Fuck is the Informix Developer Edition V11 Download?
Maybe I'm dense but I cannot figure out how to download the fucking informix developers edition v11. Where the fuck is it? Is it so hard to just put a fucking link to get it? I've already been to http://www-306.ibm.com/software/data/informix/ids/developer/ and having tried e…
Online Porn
Good site that featured some interesting issues and viewpoints.Very entertaining and tons of free adult entertainment!Lisa--24 Hours Of Porn--http://www.24hoursofporn.com…
Re: 4GL debugger "use" command causing coredump
iiug@perrior.net wrote: > Yet another obscure weirdness here: > HP-UX11i, IDS9.30HC5, R4GL 7,20UD8, IDB (debugger) 7.20UD8 > > Our 4GLs all call general 4gl library functions which reside in a > different path; so to debug them we need to specify the "use <some > other path>" com…
Tuning Checkpoints
I need some help getting checkpoints durations lowered. We are running informix 9.4. I have been working with Informix Tech support and it has gotten some better but it is not as good as it should be. We have been adjusting BUFFERS, LRUS, CLEANERS, LRU_MAX_DIRTY, and LRU_MIN_DIRT…
Extent size of system catalogs
I am about to migrate an IDS instance which has severe extent fragmentation on some of the system catalogs. Is it good practice to run ALTER TABLE ... NEXT SIZE on these or is there another preferred way? We'll be going to IDS 10 (because the application hasn't been certified on…
ontape,onbar, HDR,ER-Which tool to use?
Greetings to ALL !!! I am new to this forum.Please forgive me for my poor english. We are planning to replicate 40 different IDS10.UC4 connected thru MPLS WAN with 128 kbps LL and central site having 4 mbps link. All these IDS were not connected and local DBA use to take backup …
Re: Connection problem to Informix from SQL Server 2005 with Unicode data
I found a solution. SQL Server uses UCS-2 encoding, but Informix Database Server - UTF-8. And I tried different ODBC and OLEDB drivers and they didn't converted from one encoding to another. But, I am lucky :), I found a solution. I am using CLR possibilities of SQL2005 and crea…
Re: Counting Sessions
On Dec 4, 2:04 pm, Nog <n...@gfm.co.uk> wrote: > On Dec 4, 12:23 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Dec 4, 7:14 am, Nog <n...@gfm.co.uk> wrote: > > > > Hi, > > > > I'm Using IDS V10.00.UC5 on SUSE linux. > > > > I want to keep a count the number of sessi…
Re: Select from multiple tables, date between 2 columns.
On Dec 6, 1:01 am, Jonathan Leffler <jleff...@earthlink.net> wrote: > jared.ha...@gmail.com wrote: > > 3 tables (retail_week, items, sales) > > Columns: > > -retail_week: week_num, week_begdate, week_enddate > > -items: item_num, item_vendor, item_category > > -sales: sale_date, …
Re: Pls Help: Cannot install IDS 7.30.UC7-1 on Fedora 8. Segmentation fault
jdu...@gmail.com wrote: > Hello good people, > > SElinux is disabled. After IDS rpm install: > cd /opt/informix > ./installserver #after entering the licence key produces the following > error: > > etc/install: line 197: 4956 Segmentation fault $BRAND -n -s > $SERNUM $KEY $…
SEQUENTIAL SCANS
Version IDS 10 I am running a query something like this: table A (column s, column t, column u, column v) table A has individual index on column s. table A has another individual index on column t. table A has another individual index on column u. Update stats have run as high …
Intermapper probes for IDS 10
Good morning, Are there any Intermapper experts here that have custom probes for IDS 10 status checks? If you're willing to share, I would be very grateful for any examples or copies of what you have. Thanks-in-Advance. Jonathan B. Smaby DBSA Pomona College, ITS-AISO Office -…
Re: tblsnum in onstat -k
Sounds good... select * from syslocks.... is easier.. Superboer way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_- _oerend_hard.html On 6 dec, 01:30, mohitanch...@gmail.com wrote: > Version IDS 10: > > Is following sql correct to retrieve associated table for that lock…
IDS debugging doc?
Hi everyone. I know of course that Informix db debugging is really different from debugging other databases in that it takes time and experience with the product along with logical debugging methods. That said does anyone know of any doc, articles, web sites, books that deal spec…
How to RENAME an INFORMIX database
Hi All, Can anyone help me in renaming my database. Let my database name is "mydb"? Thanks in advance. Regards, Navaid Arif…
Re: informix.com
\ …
Logical Logs
Hi All Gurus, I'm new to this forum and IDS. Please advise me how to remove/delete the logical logs No.1 till No.3 from onstat -l, i assume flag D indicates DELETE ( pls corret me if wrong) And would it possible to readjust LOGSIZE to smaller value say "16384" from any availabl…
Re: Guy Boewerman, IBM and SAP , and Informix.
On Oct 24, 6:58 pm, "Neil Truby" <neil.tr...@ardenta.com> wrote: > <da...@smooth1.co.uk> wrote in message > > news:1193178349.199962.122830@q5g2000prf.googlegroups.com... > > > On 22 Oct, 20:46, "Guy ." <gbower...@yahoo.com> wrote: > >> The blog entry states IDS 11.10 support is …
Pls Help: Cannot install IDS 7.30.UC7-1 on Fedora 8. Segmentation fault
Hello good people, SElinux is disabled. After IDS rpm install: cd /opt/informix ./installserver #after entering the licence key produces the following error: etc/install: line 197: 4956 Segmentation fault $BRAND -n -s $SERNUM $KEY $NAM Installation of Informix Dynamic Ser…
[ANN] Rails/Informix 1.1.0 released
Rails/Informix is the ActiveRecord adapter that enables Informix as a back-end for Ruby on Rails applications. Rails/Informix web site: http://rails-informix.rubyforge.org Ruby on Rails web site: http://www.rubyonrails.com Changelog: 1.1.0 12/5/2007 ------------------ Features:…
Select from multiple tables, date between 2 columns.
Hello, Here's the situation: 3 tables (retail_week, items, sales) Columns: -retail_week: week_num, week_begdate, week_enddate -items: item_num, item_vendor, item_category -sales: sale_date, sale_store, sale_item, sale_qty I'm having trouble writing the query to return the foll…
Error in update stats
Version IDS 10: When I run update statistics I get error 255 on different tables at different times. Could it be because inside update statistics we are trying to commit something to sysdistrib database and it's just failing.…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
tblsnum in onstat -k
Version IDS 10: Is following sql correct to retrieve associated table for that lock listed in onstat -k: select * from sysptnhdr where hex(partnum) = tblsnum; or select * from systabnames where hex(partnum) =tblsnum;…
OSTIME
Hello ... Does anyone know the amount of overhead added by setting OSTIME to 1 ... v9.40fc9, aix 5.32 From what I believe it is now minimal...just want some validation. Peter…
RE: Temp space for sorting?
I have a database with a table of 21 GB in size. I understand that for sorting it is recommended to have 2 or 3 times for temp dbspace. My question is should I use a very large file system, using the PSORT_DBTEMP environment parameter, or allocate at least 64 GB to a temp dbspace…
4GL debugger "use" command causing coredump
Yet another obscure weirdness here: HP-UX11i, IDS9.30HC5, R4GL 7,20UD8, IDB (debugger) 7.20UD8 Our 4GLs all call general 4gl library functions which reside in a different path; so to debug them we need to specify the "use <some other path>" command under the debugger. One of our…
looking for logical log data reconstruction utilit
Hi, Does anyone have a utility that they are willing to donate that can scan an IDS (10.0.FC6) logical log and reconstruct the original data for rows that were updated? A user used an UPDATE stmt to update 4 char and 2 SmallInt columns and forgot to include a WHERE clause, upda…
Connection problem to Informix from SQL Server 2005 with Unicode data
I have Informix 9.4TC6 and SQL Server 2005. DB_LOCALE in Informix DB is en_US.utf8 (en_US.57372). First, I created DSN to Informix. Then tried to get data with WinSql tool and it works fine. But when I created linked server in SQL Server 2005 I have problems with languages other…
IBM Informix Support Exchange Program
IDS 11.10 - Monitor and analyze recent SQL statements Suma Vinod December 13th - 2007, 11am ET For Webcast and dial in details please see http://www.iiug.org/news/announcements/partner_training.php…
USEOSTIME issue
We have the following: IBM Informix Dynamic Server Version 10.00.FC6 HP-UX om4db1 B.11.11 U 9000/800 4126011100 unlimited-user license We started the database with USEOSTIME 0 When you do a date on the system it says the time is Tue Dec 4 15:09:58 CST 2007 But if you do a s…
Informix 4.5 manuals/doc?
Hello everyone. I did poke around here a bit but did find anything. Some group in my company is having a prod issue with an ancient informix 4.5 database. Does anyone know where I can find manuals on 4.5? Or any usefull doc? Much appreciated. Thanks, Will…
What type of password hash is used by Informix Con
Hi, cause of missing SingleSignOn option from WinXP Client to Linux/Informix Database, I like to setup an automated Informix Connect File. So the Windows start scipts generates Informix Connect config file. But I need the password, so I want to write the password hash to config…
Counting Sessions
Hi, I'm Using IDS V10.00.UC5 on SUSE linux. I want to keep a count the number of sessions occurring hourly/daily on my instance. I was using a cron script to execute the following sql and store the result hourly; select DBINFO('sessionid') from systables where tabid = 99; Th…
ER - How to reset the replay position ?
Hi all, In ER (IDS 10.00.UC4), how to reset the replay position ? We have performed a 'cdr stop' on both root and leaf servers, leaving intentionally the leaf server going out of sync. A few day later, we intended to globally resynchronize the leaf server (dbexport on the root…
Onbar - performance
Dear Listers We are moving our Informix 10 instance to a new host and during backup and restore testing I have identified a problem with recovery performance. Maury Tiller wrote some tools to test various components of the onbar/XBSA interface which were available from http://…
utility like dbaccess
Version: IDS 10 Is there a utility that I can download and install which is like dbaccess that can run on solaris box and can connect to informix engine running on some other box.…
Maximum concurrent users threads
Can someone tell me the formula that produces the maximum concurrent number portion of the onstat -u command? Is this based on what is defined in NETTYPE? ----------------------------------------- This message and any attachments may contain confidential information or trade sec…
Javier Gomez Lopez/Spain/IBM no está en la oficina
I will be out of the office starting 03/12/2007 and will not return un= til 10/12/2007. Estar=E9 fuera de la oficina hasta el 10/12/2007.=…
Re: Moving a chunk - a related question
>I'd like to ask a question about this method (at the risk of appearing dim) there is only one dumb question and that is the one which is not asked . This may cause a huge disaster...... > 1. shutdown > 2. swap the links, ie. link the primary to the mirror device and the mirror…
DYNAMIC HASH JOIN and SEQUENTIAL SCAN
Hello All. I have two tables: one table is small and one table is big. I want to join their. Big table has index on column which will be joined. Optimizer wants to do DYNAMIC HASH JOIN. Does optimizer do SEQUENTIAL SCAN on big table?…
Urgent help is needed...
Hi Gurus, We are having issues with the database (IDS: 7.31 UD8 on Solaris 8) where we are seeing lots of waits on buffers "B" -- sometimes applications fail with something like "cannot position within table" -- some processes that hold exclusive locks do not release causing othe…
.NET TransactionScope -> ERROR [HY000] [Informix][Informix ODBC Driver]General error
Hi using Microsoft Enterprise Library Data access App Block i have this code using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { Database db1 = new GenericDatabase( ConnStringBuilder.ConnString…
MI5 Persecution: MI5 Waste Taxpayer Millions on Pointless Hate-Campaign (6419)
MI5 Persecution Update: Friday 30 April, 1999 If You Intend To Reply, Please Read This Please.... keep your response to one page!. Faxes over a page or two will be deleted without being read. Somewhere between 0 and 100% The last few days there have been no clear recordable in…
MI5 Persecution: How to Identify the Persecutors (2006)
MI5 Persecution Update: Friday 19 March, 1999 If You Intend To Reply, Please Read This Please.... keep your response to one page if you can! I have had several people faxing my article back to me, including one MP faxing back twenty pages. Faxes over a page or two will be delet…
MI5 Persecution: BBC Newscasters Spying on my Home (535)
MI5 Persecution Update: Friday 13 November, 1998 If You Intend To Reply, Please Read This If you have any questions or observations you would like to share with me, then you are very welcome to reply to my fax number 0171-681-1190. But please.... keep your response to one page …
Selecting DBSPACE when using DBEXPORT and DBIMPORT
Hi All, I have two dbspaces ROOTDBS (COOKED FILE) and TTSDBS (RAW). Previously, I had my database on TTSDBS. But when I took database backup using command "dbexport mydb" and after executing "oninit -i". I tried to restore it on the same dbspace "dbimport mydb", database start u…
convert IDS10UC5 to IDS11 UC1
HI, folks, we are doing conversion (migrate/upgrade..) from IDS10UC5 to IDS11 UC1. After we prepared, and oninit, it shows below. There should be not memory limit. AIX 5.3, 8G memory. Any idea? Thanks, Frank \\\\19:48:07 IBM Informix Dynamic Server Started. Fri Nov 30 19:48…
Check to see if column exists in table
Hi All, I need to poll a database to see if a given column exists in a table or not. I came up with two queries, and I am curious to know if one is more efficient than the other: Method A) SELECT * FROM systables,syscolumns WHERE systables.id = syscolumns.id AND systables.name …
Re: Informix Proves its worth
ibmsoftwarequestions@bellmicro.eu wrote: > Hello all, > > Please read the attached case study demonstrating Informix Dynamic > Server's great performance. > > > http://www.informixcity.com/downloads/Nomad%20Case%20Study.pdf 53 transactions per second? I think they need some ser…
IDS 10.0
Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…
Re: Informix Proves its worth
On 30 Nov, 13:44, dcrunch...@aim.com wrote: > In article <bc14e145-d38e-44f8-bdc5-cd1f7dcb0...@e10g2000prf.googlegroups.com>, > ibmsoftwarequesti...@bellmicro.eu says... > > > > >Hello all, > > >Please read the attached case study demonstrating Informix Dynamic > >Server's great …
Informix Proves its worth
Hello all, Please read the attached case study demonstrating Informix Dynamic Server's great performance. http://www.informixcity.com/downloads/Nomad%20Case%20Study.pdf…
generic question: update statistics low drop distr
Hi, why should anyone run update statistics low drop distributions ? (maybe except after database upgrades - and even there it is not possible if the database has serveral terabytes) What is the disadvantage of running only NEW update statistics commands: update statistics low …
MODERN GIRLS
DO YOU WANT TO BE HAPPY JION WITH OUR GROUP AND WE TAKE YOU TO HEAVEN http://rexmier.blogspot.com/…
on delete null and accessing optimiser costs
Hi, does anyone know: i) Is it possible to access optimiser costs for a select in statement without executing the select. In other words, the result of the select would be a cost rather than the result set. This would be useful where queries are built dynamically by a program, a…
VMWare and Informix databases
I'm looking for anyone who has done testing with Informix v11 (or v10) and VMWare. Is it still true that Informix performs much better with 2 CPUs, even when they are virtual CPUs? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Di…
How to insert TEXT/BLOB from ADO.NET Odbc Data Provider ?
Hi Anybody has succesfully inserted text in a informix TEXT field from ADO.NET ODBC Data provider ? I cannot find a way to do this... Please any help would be apreciated. Enrique…
update statistics low drop distributions
Hello, Last summer we updated Informix 7 to Informix 10. We installed both versions next to each other and did an im/export of the data by dumps through the "BaaN IV" application. We didn't migrate the data through Informix update. Our database is 80Gb large and runs on an IBM P…
Indetifying badly running sql
Hi All, I have a customer who is complaining of poor performance in IDS 9.40.FC7, my cache hit rates are very good, both at about 99% however. I see a lot of sequential scans, which leads me to want to trap what queries are causing this and may be running poorly, but how? 1 - W…
HPL Loading error with Fatal error in server row processing - SQL error -271 ISAM error -151
Hi All Seeking help on HPL loading. HPL loading gives Fatal error in server row processing - SQL error -271 ISAM error -151. However, exactly same project and job works fine in another INFORMIX installation with slight version different. Data gets converted from iso81 to utf8 u…
Why doesn't Informix support the simple position(str, str) returning int function?
This looks like a sql-92 standard. I know several work ways to around this discrepancy, but nothing as nice as the actual position function? I mean they implemented replace(str, str) for gosh sakes. You have to implement position in some fashion to do a replace, so it isn't that …