Threads from 2010
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
AUTO: Ankit Agarwal is out of the office (returning 01/04/2011)
I am out of the office until 01/04/2011. Note: This is an automated response to your message "Informix-list Digest, Vol 255, Issue 4" sent on 12/30/10 10:00:01. This is the only notification you will receive while this person is away.…
PAYPAL payment WATCH(ROLEX,OMEGA,CHANEL,LV,CARTIER,IWC,GUCCI,RADO AND SO ON)
Ebel Watch wholesale <free shipping paypal payment> (http:// www.supertradeonline06.com/) Bape Watch wholesale <free shipping paypal payment> (http:// www.supertradeonline06.com/) Bell&Ross Watch wholesale <free shipping paypal payment> (http:// www.supertradeonline06.com/) Br…
Error -19816: Cannot perform this operation on a
I get this error when I try to drop a table. Informix version 11.50.FC5 we have HDR setup. I have tried to stopping the replication "onmode -d standard", shutting down seconday server after stopping replication. -19816: Cannot perform this operation on a table defined for replic…
Quero ser seu amigo no Quepasa.com
[1]Quepasa.com [2]Clique aqui para cancelar a inscrio. Eu gostaria de ser seu amigo(a) no Quepasa.com. Voc gostaria de [3]adicionar-me como amigo(a)? [4]SIM [5]NO Obrigado! Andr Luiz Rufino Para evitar que continue recebendo notificaes em seu email por parte dos seus amigo…
Re: Merry Christmas!
On 25/12/2010 00:54, Obnoxio The Clown wrote: > Hope Santa's sack brings you what you want this year! > He emptied his sack and left ... I sort of expected more but he is not a real man…
Colon (:) as literal in a construt statement
Hi all, Is there anyway to make the construct statement use the input colon (:) as it is, instead of translating it into "between"?. Eg: if the value entered in the Query by Example as "01:02" the construct statement should not interpret as "between '01' and '02" but should be "=…
Fw: confirm 70ea559188ca1833020583eaa0134abe7ca41b
Hi all, I wondwer if this email is true? Thanks, Long Nguyen --- On Sat, 25/12/10, ids-request@iiug.org <ids-request@iiug.org> wrote: From: ids-request@iiug.org <ids-request@iiug.org> Subject: confirm 70ea559188ca1833020583eaa0134abe7ca41b4d To: longhuynguyen51@yahoo.com.au Rec…
Re: Introduction to the three designer handbags(Chanel,Coach,Prada)
What is a semaphore segment? Have you used 'ipcrm -s' instead of 'ipcrm -m'? You should only ever have to use the -m option, one for each remaining shared memory segment. No need to action on any semophores. And usually an 'onmode -ky' would be even more efficient, no need to f…
Update Stats not Table Owner
Hello, We are running Informix 11.50.FC6 and we have a daily process done by a user which truncates the table owned by user "informix" and loads the table with new data. We need to allow the user to update stats after the load. The user cannot update stats because they are not…
Shared memory segments
Don't have an answer for you off hand, but I did fix your subject line so it doesn't look like spam. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of qingchuntrade Sent: Monday, December 27, 2010 7:54 PM…
Informix RSS Issues - Slow apply of Logical Logs a
Has anyone came across this issue. When I first setup my RSS instance and turn it on "onmode -d RSS {primary}" it takes a long time to apply the logical logs from the primary (2 minutes per logical log) while the primary is generating a logical log every 30 seconds. I also noti…
Introduction to the three designer handbags(Chanel,Coach,Prada)
Due to an interrupted ontape restore, I was left with a down informixserver with its shared memory segments still being reported by ipcs. I carefully removed all the segments using ipcrm, being careful not to remove any used by the other two instances on the host, but when I rem…
index question
Current: O/S: HP/UX IDS: 9.4FC3 New (soon): O/S RHEL 5 IDS 11.1FC3 (can't go any newer) We are trying to get some 'expert' answers on creation of indexes and how they are actually used in our queries. The main indexes were setup by the app developers (not us) and we have added a…
wait on lock more than 30 seconds
If a session wait on lock more than 30 seconds then i want an alert.…
Re: Outsourcing that failed
Hello, How are you doing? We at Srujana Technologies have professionals who have expertize and practical experience on Informix applications. Let me know if you are looking for any Informix applications outsourcing to India. Thanks Regards, Ravi N ravi@srujanatech.com Projec…
Merry Christmas!
Hope Santa's sack brings you what you want this year! -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.…
DBD::Informix -1820
I'm using DBD::Informix and mod_perl and was having a problem with a -1820 error (-1820: Host variable type has been changed between fetches or puts) hitting a particular query on a second or subsequent execute of a prepared statement. So I decided to check the DBD build and run…
(paypal payment)( http://www.24hour-buy.com/) cheap wholesale ED hardy Christan Audigier,LV,BOSS etc. brand caps hat belts and other products free shipping
(paypal payment)(http://www.24hour-buy.com/) cheap wholesale puma hat <free shipping paypal payment> (paypal payment)( http://www.24hour-buy.com/) cheap wholesale,bape ,hat (paypal payment)( http://www.24hour-buy.com/) cheap wholesale, era NBA ,hat <free shipping paypal pay…
out of virtual shared memory
We are running IDS 11.5FC6 on Solaris. Today memory consumption started increasing on our production database and within few minutes it reached the shmmax limit. We found message in online log "out of virtual shared memory", so we restarted the database instance. There were a lot…
New System Config and DS8800
Hello Throwing out feelers on some questions regarding the setup of Informix OLTP systems on the new DS8800 Storage. We had drawn up a RAID 10 design for both data and logs and received feedback that RAID 5 would work out just fine. Through the years, the literature, conferences…
connecting Windows Mobile 6.1 Classic with IDS
Hi falks, IHAC who wants to connect IDS 11.50 Express Edition via windows Mobile 6.1 Classic. Anyone can tell me how to do it? Thank's a lot, Juan Luis Roca…
Imported restore on different server instance
Hi, I have 2 IDS11.10 servers A,B on windows. In Server A there is service instanse ol_a. In Server B there are service instanse ol_a and ol_b. Making imported restore from server A (ol_a) on server B (ol_a) all ok. How is possible to make imported restore from server A (ol_a) o…
free shipping PAYPAL payment wholesale brand HANDBAG bags travel bag(LV,GUCCI,CHANEL,PRADA,COACH,FENDI,CHLOE,BUBERRY,JUICY AND SO ON)http://www.24hour-buy.com/
(http://www.24hour-buy.com/) Discount VERSACE True leather AAA Discount Wholesale <free shipping paypal payment> (http://www.24hour-buy.com/)paypal payment Discount VERSACE bags Wholesale (http://www.24hour-buy.com/)paypal payment Discount Chanel Purse Wholesale (http://www.24ho…
cheap jordans,jordans shoes,jordans sneakers,nike shoes,NFL shoes
wholesale ugg boots,wholesale classic ugg boots,discount ugg baily boots. http://www.24hours-online.com UGG For Cheap,buy ugg boots,ugg boots store,ugg cardy,cheap ugg http://www.24hours-online.com Cheap Chukka Shoes,timberland mens shoes,timberland chukka shoes http://www.24hour…
create bts index long transaction
I am trying to setup and use bts on our dev sds primary psdev1. I know I could turn logging off but that would require taking the secondary offline and the solution I find must work when this is moved to production. There are 29341 rows in dev; about 3 times that number in prod. …
slowness of dbimport and serial queries
Hi all, I have a customer where dbimport operations or lot of updates in a database takes much longer then similar installations at other customers. What can be the reason? Identical operations are working fine at other installations. Platform: SuSe Informix: IDS 9.40. (I know …
INFOMRIX and multibyte scenarios
My company is looking at a new global mutibyte ERP soultion. I hope to use INFORMIX as I am very comfortable with it's stability and tools. One potential vendor is Infor. We have been told INFORMIX can not fully support multiple multibyte applications. Here is a part of their…
Re: Re: finding inplace alters
I made a mistake on the table name. It's "syssltdat" (just one "t" at the end). I've already received a report (directly to me - Thanks!) which states that it's present in 7.31.UD7. This is consistent to some searches I've made that returned very old cases where it's mentioned. …
Antw: Re: finding inplace alters
Hallo, in Version 7.31 the table syssltdatt is not present in sysmaster. Greetings Heinz >>> Fernando Nunes <domusonline@gmail.com> 22.12.2010 01:47 >>> On Tue, Dec 21, 2010 at 6:37 PM, Mark Scranton <mark@markscranton.com>wrote: > On Dec 20, 4:22 pm, PeterP <peterp...@gmail.…
Merge Statement not utilising index
Hi All, I'm experimenting with using a merge statement to insert data in from a temporary table into a large table (~12m rows). Sqexplain output below... QUERY: (OPTIMIZATION TIMESTAMP: 12-22-2010 11:45:38) ------ SELECT FIRST 1 * FROM stan:tagsamples INTO TEMP new_samples WIT…
dbexport slow exporting to ramdrive
Hey there, I'm doing an excercise running dbexport using RAMDRIVE as an output folder: dbexport -q -o $DIR $DB -ss $DIR is RAMDRIVE (/dev/ram0 5.7G 3.4G 2.4G 59% /tmp/dbexport) $DB is sei_copy_deal in this case, 3GB database) When running dbexport (which goes directly from eng…
Exciting Symposium: Marketing Professionals, Come learn from Industry Leaders (Jan 29th, 2011 Bangalore)
Hello, Siliconindia is organizing the Marketing Symposium on 29th Jan in Bangalore. This conference will explore major marketing challenges, impact of technology on communication with target audiences – current and prospective, low cost with major results, managing increasingly c…
Re: Re: finding inplace alters
Hi Art, the idea is walking all (or certain) dbspaces' tblspace tblspaces, relate partition header pages carrying a version pointer to their secondary partition pages (version pages + dependent alter descriptor pages), in correct order, then walk the contained alter descriptors …
JDBC connection error
I'm having a production base that is not currently accepting any JDBC connection, the only message returned: Unexpected Error occured Attempting to open an SQL connection. When made the connection via ODBC down normally in the same instance I have other database that supports no…
Re: Re: finding inplace alters
Andreas, you could probably rewrite it to use the sysmaster:syspaghdr table and then you may be able to release the source. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaim…
AUTO: Out for the Holidays (returning 01/03/2011)
I am out of the office until 01/03/2011. Note: This is an automated response to your message "OAT Tables??? [22258]" sent on 12/20/10 6:33:38. This is the only notification you will receive while this person is away.…
How to check for all tools installed on a server
How do I check for all the tools installed on a server ? I had a look at /usr/informix/etc/.snfile, but this file differs from the -cr files which seem to exist for every tool installed: -rw-r--r-- 1 informix informix 114 Oct 21 2005 ASF-cr -rw-r--r-- 1 informix informix 117 Oct…
OAT Tables???
Good Morning Informix-people, We are running 11.50.FC5 on AIX 5.3. WE recently upgraded to OAT version 2.70. Since then, I have some new sysadmin tables that are owned by the guy who initially installed and configured the new OAT. He then went into each system to test the connec…
Re: finding inplace alters
On Nov 18, 12:21 am, Fernando Nunes <domusonl...@gmail.com> wrote: > AFAIK there is no quick way to find pending inplace alters... Only a slow > process. Not sure if Panther changed this... There is a good document somewhere on the IBM web and it is slow, but it works, returns …
Re: Removing semaphore shared memory segment aborts other informixservers
On Dec 15, 11:22 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > On 14-12-2010 13:41, red_valsen wrote: > > > Due to an interrupted ontape restore, I was left with a down > > informixserver with its shared memory segments still being reported by > > ipcs. I carefully removed…
Re: Insights & trends
On Oct 23, 4:37 pm, Fernando Nunes <domusonl...@gmail.com> wrote: > You explicitly wrote that this were probably people using Informix and > trying to move away. > Naturally, as usual, when confronted with logic that shows you're wrong you > jump around like a lost rabbit, pickin…
Re: finding inplace alters
On Nov 17, 9:35 pm, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > Hi, > Running ids10.0.fc5 on aix5.3 and needing to upgrade to 10.0.fc11 to get a bugfix. > trying to find and fix inplace alters. The script ibm supplies doesn't work for mulitple reasons so far. It fails on so…
Re: Spatial DataBlade
On Nov 17, 2:26 pm, Tom Lehr <tomc...@gmail.com> wrote: > Hello, > > Looking on Passport Advantage, I do not see it listed specifically for > the Windows Server 2008 Platform. > There are three versions listed: > > Informix Spatial DataBlade 8.21 Multiplatform English > eAssembly…
Re: IDS GE license restriction limits warning messages...
You have two messages there. One is caused by SHMTOTAL=0. apparently the message doesn't make sense. But it's a fact that the version you have has memory limits. The other message is caused by IFX_LARGE_PAGES=1 and the engine was brought online with that in the environment (as t…
Re: IDS GE license restriction limits warning messages...
Output of onstat -g env IBM Informix Dynamic Server Version 11.70.UC1GE -- On-Line -- Up 21:42:09 -- 1164112 Kbytes Server start-up environment: Variable Value [values-list] DBDELIMITER | DBPATH . DBPRINT lp -s DBTEMP /tmp IFX_LARGE_PAGES 1 INFORMIXDIR /u/informix/11_7 [/u/inf…
TimeSeries
IBM Informix Dynamic Server Version 11.70.FC1IE Software Serial Number AAA#B000000 So I'm having a play with this and TS I can reliably cause the engine to AF 11:14:37 stack trace for pid 24588 written to /opt/IBM/informix/tmp/af.29de3252 11:14:37 Assert Failed: No Exception…
11.70, drda & ldap
Hello, did anybody install 11.70 with ldap authentication and connect client with drda? I installed 11.70, ldap and users can connect with "normal" sqli (with PAM), but I can't configure drda access. Does anybody have cookbook or something similar? Regards, Hrvoje…
Re: IDS GE license restriction limits warning messages...
Can you post the output of "onstat -g env"? Regards. On Thu, Dec 16, 2010 at 8:58 PM, June Nebab LKINY <jnebab@idealcut.com>wrote: > Good catch Art, fixed that but as you have stated it had nothing to do > with it. > > > > ----- Original Message ----- > From: "Art Kagel" <art.…
Re: IDS GE license restriction limits warning messages...
Good catch Art, fixed that but as you have stated it had nothing to do with it. ----- Original Message ----- From: "Art Kagel" <art.kagel@gmail.com> To: "June Nebab" <jnebab@idealcut.com> Cc: "jrenaut" <jprenaut@yahoo.com>, informix-list@iiug.org Sent: Thursday, December 16, 201…
Re: When did the latest SMI tables show up?
I believe sysfubpool is there since V10. sysactptnhdr appeared in version 11 AFAIK. But be careful, because there was a bug with it... Can't recall exactly, and I'm sure a formal bug was opened and I'm almost sure it's now fixed. If someone finds them in previous versions please…
Re: When did the latest SMI tables show up?
I believe sysfubpool is there since V10. sysactptnhdr appeared in version 11 AFAIK. But be careful, because there was a bug with it... Can't recall exactly, and I'm sure a formal bug was opened and I'm almost sure it's now fixed. If someone finds them in previous versions please…
Re: IDS GE license restriction limits warning messages...
June: This one setting, at least, is not correct: SHMNOACCESS cpu,num=1,noage This looks like your SHMNOACCESS and VPCLASS settings got combined somehow. Don't think this has anything to do with the warning you are seeing, but.... Art Art S. Kagel Advanced DataTools (www…
Re: IDS GE license restriction limits warning messages...
Jacques, After mistakenly admitting that this worked, I noticed the same error messages still appearing in the log whenever I startup the engine. IFX_LARGE_PAGES environment is already set to 1. cat /proc/meminfo shows the following HugePages settings: HugePages_Total: …
Re: When did the latest SMI tables show up?
Thanks. Not sure I trust the Information Center since I have three pages of notes on changes to the SMI database going from 11.50.xC7 to 11.70.xC1 and none are listed in the Information Center <sigh>. But thanks for the link, never dug deep enough into the Migration section the…
RE: When did the latest SMI tables show up?
Well, if this can be believed, sysbufpool appeared in 10.0: not sure about sysactptnhdr. http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.mig.doc/mig44.htm Changes for Dynamic Server 10.0 The sysdirectives system catalog table was added. The sysbu…
When did the latest SMI tables show up?
Does anyone remember in which releases the following SMI tables first appear: sysbufpool sysactptnhdr Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mi…
When did the latest SMI tables show up?
Does anyone remember in which releases the following SMI tables first appear: sysbufpool sysactptnhdr Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mi…
How to know the database name create on a dbspace?
I have lots of databases and dbspaces. How to know the database name created on a special dbspace except "oncheck -pe" and onmonitor? Do it has any SQL statement to do it? thanks.…
Using onsmsync to expire backup images
IDS V10.FC5 OS Solaris 10 11/06 I recently noticed that the root dbspace and associated chunks on our production database were filling up with our onbar activities (in the sysutils database). Rather than continue to add addition chunks (raw files) I have read that you can use th…
Page Size
Hi, All, Build Version: 11.50.FC7 Build OS: Linux 2.6.9-34.ELsmp We are setting up dbspaces for a new Instance. Root dbs must be the default system page size (2k here). We are going to use page size 8k for our data spaces. Any experience or comments on the page size of Physica…
Reading data on SQL server in Informix - help
IDS 11.50.FC6 HPUX 11.31 BL870c Integrity server MS SQL server 2005 on w2k3r2 server A short time ago our developers needed the ability to pull data from our Informix database while in SQL server and then manipulate the data there. After a little bit of a struggle I managed to s…
RE: Migration from IDS 9.4 on Solaris 8 to IDS 11.
Solaris 8 - 32-bit [IDS 9.4] to Linux Redhat 5 64-bit [IDS 11.7] Has anyone come up with a good, easy way to migrate a large database (2.5TB) from a 32-bit Solaris 8 server to a 64-bit Linux RedHat5 server? Larry…
listener-thread: err = -27001: network problem
hi falks, I wonder if anyone could help me in the matter: IHAC who if every 5 minutes having the same online message: listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. First I suggested to change the NETTYPE parameter to: NET…
Removing semaphore shared memory segment aborts other informixservers
Due to an interrupted ontape restore, I was left with a down informixserver with its shared memory segments still being reported by ipcs. I carefully removed all the segments using ipcrm, being careful not to remove any used by the other two instances on the host, but when I rem…
Re: proper way to create rawdevices in Red Hat Enterprise 5.5
Hi David. Sorry - I only just saw your last posting on this. We found bulk operations such as a level 0 "ontape" either unchanged or slower with raw compared to block devices on recent Linux versions. This surely is expected: with IO_DIRECT, block devices should be fine and ther…
hotsale jerseys,good quality and best price.
NFL jerseys 49ear 32 lewis 1 48 red and 1 48 white and 1 50 red and 1 50 white panthers team 17 del homme in black 1 in 48 and 1 in 50 mbl jerseys http://www.people-trade.com/JERSEYS/ Philadelphia Phillies 10 jenkisn white red bar 1 in 48 and 1 50 tiger detroit 14 jackson white …
select temp table in original order
We need to process a file after loading it into a temp table. Is there any way to select data from the temp table in original order? No field of the file can be used for 'order by'. IDS version is 11.50.UC5. Thanks in advance. Gary…
Updates to utils2_ak, ar2, and ratios_shr.ak
I've uploaded updates to these packages and they are available for download now. If you downloaded the November 17th version of utils2_ak (installed on Nov. 20), there is a fix to a runtime bug in this latest version of myschema. There is also a great new feature for users of 1…
Updates to utils2_ak, ar2, and ratios_shr.ak
I've uploaded updates to these packages and they are available for download now. If you downloaded the November 17th version of utils2_ak (installed on Nov. 20), there is a fix to a runtime bug in this latest version of myschema. There is also a great new feature for users of 1…
network errors
OS: HP/UX 11.11 IDS: 9.4FC3 (we are in the process of upgrading, but new server/db not ready for production yet) We started seeing these errors in our log Friday when users complained of not being able to connect. We checked back over time and there have been a few here and ther…
RSS Cheat Sheet???
Hello, Does anyone have a cheat sheet for initializing RSS for the 1st time? I have 2 instances that I can backup on one machine and restore to on another via ontape -r and -p so I think my config is there. I can connect to databases on 2nd machine from 1st so I think the connec…
error 38300 loading messages
Hi folks, hoping someone can help me out on this. Platform Solaris 9 Sparc, IDS 9.40 UC6 (old, I know) Can't backup logical logs, all I see is the error message in the subject. Any idea how to debug (or better solve this) ? Situation : due to a faulty remove, the OS had to be…
dostats IDS 11.70
Hello, dostats no longer seems to work in IDS 11.70. First there seems to be an issue with trusted contexts. informix@dbhostname:~> dostats -d isent98 FAILED: Cannot connect to SMI DATABASE (@ol_dbhostname); error=-28021, isam=2 DatabaseError: SQLCODE -28021 in CONNECT: A trus…
Cheap Wholesale Nike Air Max Skyline <http://www.people-trade.com />
Nike Air Max Cheap Wholesale Nike Air Max 87 <free shipping paypal payment> <http:// www.people-trade.com /> Cheap Wholesale Nike Air Max 89 <free shipping paypal payment> Cheap Wholesale Nike Air Max 90 <freeshipping paypal payment> <http:// www.people-trade.com /> Cheap Wholesa…
ON-Bar parallelization
Hello folks I am looking at using onbar to take advantage of the parallelization. Looking at the example at this address http://www.ibm.com/developerworks/data/library/techarticle/dm-0611sinha/index.ht ml the implication is onbar backs up the chunks in the dbpace in parallel. I…
Informix User Group Meeting and Free Informix 11.7 Hands on Lab
Folks, We had a very successful user group Tech Day in November. You may download the presentations from our Tech Day at our website http://www.waiug.org Our next event will be in March 2010. At the last Tech Day a number of you expressed interest in learning about the new eas…
dbaccess; insert in table2 depending to content of table1
Hallo, I have 2 Tables Table1 (our Articles with >30000 Records) ArtNr ABC ... Table2 (This Table is emty) ArtNr MGK1 MGK2 MGK3 ... I must fill Table2 for all Articles with the dollowing conditions ABC=A => MGK1=1 ABC=B => MGK1=2 ABC=C => MGK1=3 How do I have to create my s…
paypal payment Wholesale Coach Handbags,Cheap Jordans,Nike Dunks,Puma Shoes,Gucci
PAYPAL payment wholesale SHOES(UGG BOOTS, Timberland boots ,Munich shoes UGG5230 BOOT paypal payment) paypal payment Wholesale Coach Handbags,Cheap Jordans,Nike Dunks,Puma Shoes,Gucci Your questions are always answered at Australian Ugg Boots cheap gucci shoes, supra shoes and ch…
RE: HDR+Connection Manager in intermittent network scenario
Thanks for the advice, I'll give it a try. -Nate PS: I'm new to this list, and the Informix-list Digest emails I get say to include the message number in square brackets in the subject line. I don't see this number anywhere -- am I doing something wrong? ______________________…
RE: HDR+Connection Manager in intermittent network scenario
Cesar, I must have missed the FAILOVER_CALLBACK parameter in the docs. Thanks for pointing it out, I'll take a look. Speaking more generally to both you and Pravin, I must confess, I haven't experimented much with DRAUTO set to 0 or 1. The impression I got from the documentation…
Scheduler Error
IDS 11.50.FC5 I have just noticed that none of my scheduled tasks seem to have executed since 11-29-10, when about half of the AUS statements executed. I have the following entry in my informix log: 20:34:05 SCHAPI: thread dbWorker1 task post_alarm_message(15-160390) shutting d…
Error IX000 on select for update
Hello, i've have this problem: When i execute this query: EXEC SQL BEGIN WORK; EXEC SQL SET LOCK MODE TO WAIT; SELECT bdc_stato_ddt FROM informix.bolcli WHERE bdc_key_soc = '5' AND bdc_key_tipo_bol = 'V' AND bdc_key_num_bol = 168582 FOR UPDATE sometime i've receive an error wi…
paypal wholesale world cup 2010 football jersey South Africa
paypal wholesale world cup 2010 football jersey Brazil paypal wholesale world cup 2010 football jersey England paypal wholesale world cup 2010 football jersey France paypal wholesale world cup 2010 football jersey New Zealand paypal wholesale world cup 2010 football jersey Portu…
RE: Speeding HDR ontape archive-restore
> I forgot, the command will be something like: > > ontape -s -d -v -L 0 -t STDIO | pgiz -1c | \\ > ssh informix@otherserver ". myenvs.sh ; pigz -cd | ontape -p -t > STDIO" > > > On 12/08/2010 11:07 AM, Cesar Inacio Martins wrote: > > Maybe this isn't valid for your environmen…
creating users with upper lower case mixture
Folks Struck a problem I have never met before. I created a connection for a user JBoss - yes they insisted mixture of upper/lower case. This was accepted ok however when looking at sysusers table it had been converted to all lower case. So to get informix to accept the upper cas…
Re: HDR+Connection Manager in intermittent network scenario
I agree with Paul, especially if you have the CM managing failover, but even if not it's a very good idea! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep i…
RE: HDR+Connection Manager in intermittent network scenario
> On 12/03/2010 07:46 PM, Nate Woodward wrote: > > I'm trying to acheive high availability without data loss. I have an > HDR > > pair configured with a connection manager on each box for redundancy. > > Clients are pointed at an sqlhosts group with the connection managers > in >…
Tool to estimate the size of an index
Hi all I need a tool to estimate the size of an index based on key size and number of records. Does anyone know of any? Thank you very much…
About ERKEYs
Hi, I'm studying how the ERKEYs works. It's a very cool feature! Testing it, I identify: - There is no way to specify indexes parameters like, what dbspace the index should be create explicit name for the index (to keep easy the admin and identification) extent size create …
onunload dbspace handling
Does onunload/onload handle variations in dbspaces? That is: 1) If I onunload a database which resides in 2 dbspaces, can I onload it into another instance with differently named dbspaces? If so, what is the command line syntax? 2) Can I onload a database which resided in 2 d…
Re: HDR+Connection Manager in intermittent network scenario
Hi Nate, I guess the manual failover (DRAUTO=0) is the best configuration for HADR and CM environment for handling the conditions described by you in you mail below. (dealing with network issues) Hi Cesar, This look like a little different behavior than in the earlier version …
Re: HDR+Connection Manager in intermittent network scenario
Nate, you will found information about this on the manuals. Check for DRAUTO, FAILOVER_CALLBACK... Just sharing a issues what I got with IFX 11.50 FC7W1GE + CM 3.50 FC7, Linux. On environment with similar configuration, using HDR, I have trouble with CM FOC and DRAUTO configura…
Cannot add index
Hi all, we have a strange situation when creating a functional index. Following table is base for this index: CREATE TABLE crm_travels ( customer_id INTEGER NOT NULL, item_id INTEGER NOT NULL, supplier_id VARCHAR(32), booking_id VARCHAR(20), no_of_persons INTEGER, date_of…
validating locale of a DB
Does anyone know the table where one can determine the locale a database was created with .. Thanks in advance ... v11.50.fc7 Aix 6.1 Peter Logan Senior Database Administrator Phone: 616/878-8309…
Why RSS automatically becoms standard?
Hello, Our RSS server automatically become standard while its drauto value is 0 (mannual). Following are the messages which are in message log file. 19:33:17 RSS: Lost connection to ids_net_db91 19:34:31 RSS: Reconnected to ids_net_db91 19:34:35 This server is not registered wi…
Delete linking multiple table
Hi, I am trying to delete from a table linking multiple tables using the "USING" key word. But the informix server comes back saying syntax error. delete from nav1 using nav2 n2, nav1 n1 #^ # 201: A syntax error has occurred. # where n2.id = n1.id I am using the informix versi…
free shipping PAYPAL payment WATCH(ROLEX,OMEGA,CHANEL,LV,CARTIER,IWC,GUCCI,RADO AND SO ON) http://www.24hour-buy.com/
Ebel Watch wholesale <free shipping paypal payment> (http://www.24hour-buy.com/) Bape Watch wholesale <free shipping paypal payment> (http://www.24hour-buy.com/) Bell&Ross Watch wholesale <free shipping paypal payment> (http://www.24hour-buy.com/) Breit Ling Watch wholesale …
onstat -l
I'm seeing a couple of extra lines in the output of 'onstat -l', which I can't find documented in the 11.50 administrators guide and references. The lines in question look like this: Buffer Waiting Buffer ioproc flags L-1 0 0x1 0 L-2 0 0x1 0 The exact lines varies (L-1 through…
Perl:DBD compile with support for DRDA
Has anyone done this? We are working on this so that we can get our perl to support the new connection manager. David Link…
Speeding HDR ontape archive-restore
I am streaming an ontape archive from an HDR primary server over my network and restoring it to a secondary server to start replication. Do the onconfig file's TAPE-related parameters affect the speed of the transfer even though a physical tape isn't in use? Are there any other …
Problem in ontape -p
Hello IDS Group, i have the following problem: i want to setup a test environment for the database server, therefore i build a neu server with the same dbspaces like the real server in the test server. the i tried the to run ontape -p. of course i get the file (around 3GB) from…
informix dropping idle connections
Hello folks Looking for some advice/information IBM Informix Dynamic Server Version 9.40.HC5 (yes I know its not supported any more) HP-UX mafgis2 B.11.11 U 9000/800 SDE ArcSDE 9.2 for Informix Build 1254 max sde connections set at CONNECTIONS 64 Our development people have a s…
paypal payment NFL jerseys http://www.24hours-online.com/JERSEYS/
NFL jerseys 49ear 32 lewis 1 48 red and 1 48 white and 1 50 red and 1 50 white panthers team 17 del homme in black 1 in 48 and 1 in 50 mbl jerseys http://www.24hours-online.com/JERSEYS/ Philadelphia Phillies 10 jenkisn white red bar 1 in 48 and 1 50 tiger detroit 14 jackson whit…
Re: Not using Physical Log, why?
Original Post: Hi , I already identify this situation on v11.10 xC1 and since then I not found any answer. I just forgot about this and today the situation "popup" and again I not found the reason.... v11.70 UC1DE - OpenSuse 11.2 This is a very simple test environment. - Datab…
Re: Not using Physical Log, why?
Can you describe the sequence of events?... Was the table already loaded, or did you load it before the update? Was there any other operation on the table? How did you check that no physical log was used? On Sun, Dec 5, 2010 at 12:05 AM, Cesar Inacio Martins < cesar_inacio_marti…
Re: Not using Physical Log, why?
First, I don't know why you did not see any physical log pages being written during the updates. My own understanding is that you should have seen activity in the physical log. Is it possible that a checkpoint ran between the beginning of the transaction and the time that you che…
perl DBD::Informix and php pdo_informix with Apache
Hi, Has anyone tried to use perl's informix pm and php's pdo_informix under Apache successfully?…
paypal payment jordan shoes supra shoes timberland ugg boots nike
wholesale ugg boots,wholesale classic ugg boots,discount ugg baily boots. http://www.24hours-online.com UGG For Cheap,buy ugg boots,ugg boots store,ugg cardy,cheap ugg http://www.24hours-online.com Cheap Chukka Shoes,timberland mens shoes,timberland chukka shoes http://www.24hour…
HDR+Connection Manager in intermittent network scenario
I'm trying to acheive high availability without data loss. I have an HDR pair configured with a connection manager on each box for redundancy. Clients are pointed at an sqlhosts group with the connection managers in them, and the connection managers are configured to redirect the…
Foreign key issue
We have a table with one row only and it is referred in two tables through foreign keys i..e, two child tables. A stored procedure deletes a few record and insert some records on daily basis. For last couple od days we are getting below exception " Missing key in referenced table…
Re: OK Next step: ISM imported restore of onbar -w using disk-based backups
Hello Malc, yes have been there also with the real legato product, took back then longer then a week to recreate from device. In the end we copied the catalog from production to test and that worked. On windowze ism_catalog -recreate <from tapedev> does not work at all.... > L…
OT: To Art, Et. Al.
Happy Hanukkah!…
Is it possible to call web services from stored pr
I need to call Java based web services from stored procedure. The stored procedure resides in IDS v 11. Is it possible. Can anyone please suggest a way to achieve this?…
Re: Windows 7 64 bit SQL and Schema viewer for IDS 11.50
I quite like http://www.dbschema.com/ -- Clive On 02/12/2010 19:23, Gentian Hila wrote: > I will try that too. Actually I am having a tough time to get OAT > installed in 64 bit. > > > On Thu, Dec 2, 2010 at 1:22 PM, Plugge, Joe R. <JRPlugge@west.com > <mailto:JRPlugge@west.com…
Re: Windows 7 64 bit SQL and Schema viewer for IDS 11.50
I will try that too. Actually I am having a tough time to get OAT installed in 64 bit. On Thu, Dec 2, 2010 at 1:22 PM, Plugge, Joe R. <JRPlugge@west.com> wrote: > I am not quite sure OAT will give you the query ability that you are > looking for. DBViz may be a better bet. > …
Re: Windows 7 64 bit SQL and Schema viewer for IDS 11.50
Hello. You could install OAT - OpenAdmin tool, it´s free, it´s on a web front-end, and does much more than you said you need! Try it.... http://www.openadmintool.org/ Best regards. Em 02/12/2010 12:52, Gentian Hila escreveu: > Is there any utlity that I could use to run SQL and…
Re: IDS GE license restriction limits warning messages...
Thank you Jacques...that WORKED! June A. Nebab IBM Informix DBA/Linux System Admin Lazare Kaplan International Inc. 19 W 44th Street New York, NY 10036 800-554-3325 212-972-9700 "The World's Most Beautiful Diamond" www.lazarediamonds.com ----- Original Message ----- From: "jre…
RE: Windows 7 64 bit SQL and Schema viewer for IDS 11.50
Try this product .... http://www.dbvis.com/products/dbvis/doc/supports.jsp -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Gentian Hila Sent: Thursday, December 02, 2010 10:53 AM To: IIUG Informix List Subject…
IDS information center
Folks, Failed many times to access the sites, are they down or ...? http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp Thanks, Frank --0016e657b1527bb03d04967044ee…
Windows 7 64 bit SQL and Schema viewer for IDS 11.50
Is there any utlity that I could use to run SQL and see the schema on an IDS11.50 from windows 7 64 bit version either free or for little money. dbaccess is not good enough to see results I have had xp so far and used Winsql which is relatively cheap but it's not working anymor…
China paypal payment Shoes,Clothing,Handbags,Hats,Sunglasses,Jeans,Shirts
buy jeans wholesale online,buy men's jeans cheap onlinehttp://www.24hours-online.com Buy Jeans, online fashion store for jeans, trousers, tops, shirts, jackets & belts from Levi's, Wrangler, Lee, Dockers, Ben Sherman, Bench, Energie, http://www.24hours-online.com Jeans Clothing…
China paypal payment Shoes,Clothing,Handbags,Hats,Sunglasses,Jeans,Shirts
buy jeans wholesale online,buy men's jeans cheap onlinehttp://www.24hours-online.com Buy Jeans, online fashion store for jeans, trousers, tops, shirts, jackets & belts from Levi's, Wrangler, Lee, Dockers, Ben Sherman, Bench, Energie, http://www.24hours-online.com Jeans Clothing…
bar log message 43185
Hi All I have 11.5UC4 + TSM. L0 archives are scheduled weekly, and L1 Mon-Sat nightly. I'm seeing following error in bar log several times a week: 15335576 56099016 (-43185) A change in physical configuration has occurred. A level 0 backup of aimsdbs1 is being performed I know …
Re: IDS GE license restriction limits warning messages...
Hello. 1) Did you check if there´s any segment in use? (ipcs command) 2) I had similar troubles here, with no segment used by informix. I suggest you to take your whole *SHM* portion of the onconfig.std file, and paste it into your production one. That maybe some mispelling word…
IDS GE license restriction limits warning messages...
On a new install of IDS 11.70 UC1GE on Red Hat Enterprise 5 32 bit with 6GB RAM. I noticed the following messages in the online.log file: 14:07:32 Warning: The IBM IDS Growth Edition license restriction limits 14:07:32 the total shared memory size for this server to 0 KB. 14:07:…
Enterprise Replication slowness
Hi, I have 2 servers connected via Enterprise Replication. The master server OS : Solaris 10 IDS version: IDS 10.00.FC8X9 Slave server: OS: AIX 6 IDS version: IDS 11.50.FC5XI I have a table with 605 row size. It has a primary key and additional indexes. The table has 30 m…
Re: Creation of a replicate
Hello! Why don´t you try to run it using OAT? It´s easier, faster, and you don´t worry about command lines. Since you´re on 11.50 you already can do it. I suggest you to try it, certainly it´s better than using some huge command lines (old versions) ok? Best regards! Em 30/1…
CDR error unexplained
Hello, friends. Informix 11.70.FC1IE on linux_64, with ER active. (obs: there are no replicates active yet, just the ER server is started, and put into the ER domain) I need some help. My online log is showing: 11/30/10 13:07:54 Failed to perform quality of data operation. rqmO…
Creation of a replicate
We upgraded from 10.00.FC8 to 11.50.FC6. We had a replicate built on the following table: CREATE TABLE "informix".my_history ( mydate VARCHAR(20,0), user CHAR(20), program CHAR(20), recordtype CHAR(20), data CHAR(255), mykey CHAR(2…
Have you ever been to http://www.24hours-online.com what do you think of it?
Have you ever been to http://www.24hours-online.com what do you think of it? Hi dear friends, actually I am here to get some tips of shopping online, Recently, I am planning to open up a small fashion shop, when every thing is ready I?ve got to find a supplier. These day when I…
Lost chunk/dbspace space
Anybody have any ideas on this? Thanks, Randy -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kennedy, Randy Sent: Tuesday, November 23, 2010 10:44 AM To: ids@iiug.org Subject: Lost chunk/dbspace space [22024] We have moved from…
-26060 error
IDS 11.50.fc7w3 Aix 6,.1 When we moved from v11.50.fc5 to v11.fc7 we started getting a -26060 error on several of our procedures. All stats were dropped and recreated and the offending procedures dropped and recreated. Somewhere somebody told me this was a known defect and that …
534: Cannot open EXPLAIN output file.
Dear Informix Gurus, Need your advice & help in solving the below issues. I was trying to get the SQL Plan for some queries which is taking few minutes. But I am encountering with an error number:-534 I tried to sort out the issue using finderr utility. ---------------------…
WARNING! Physical Log size 140000 is too small.
Dear Sir, i have the following Warning becoming from Primary: WARNING! Physical Log size 140000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 160 times maximum concurrent user threads. and here is the output fr…
WARNING! Physical Log size 140000 is too small.
Dear Sir, I have got the following Warning from Primary: WARNING! Physical Log size 140000 is too small. Physical Log overflows may occur during peak activity. Recommended minimum Physical Log size is 160 times maximum concurrent user threads. Any help will be welcome Rega…
sql_runtime in syssqltrace
Hi Everyone. Can someone please tell me what unit of measure sql_runtime represents? The manual doesn't seem to say. I suspect it's seconds, but the times given don't seem to measure up to the application experience. Thanks, Tristan…
oninit -ivy error Warning: stat() failed for chunk
I have just installed informix 11.5.FC5 on a red hat enterprise 5 (64 bit) machine that is currently running a production version of informix 11.5.fc3 (it has been stable for 2 years) online log say 09:57:37 IBM Informix Dynamic Server Started. 09:57:37 Warning: The IBM IDS Wor…
Ontape -a
Dear Group IDS, i have the following problem: I have HDR Solution and in the Primary server when the one logical logs full, then will start ontape -a through alarm_log.sh file and the full logical log will be backup. But the job ontape -a still in the background and when the n…
imported restore problem using Netbackup
Hi All, I am trying to do an imported restore from our PROD to our DEV env... All settings are the same, dbspaces, ixbar, oncfg, onconfig. However i am getting this error.. 2010-11-26 01:52:03 1634434 643116 /home/informix/bin/onbar_d -r -p -t 2010-11-24 15:00:00 rootdbs00 phys…
UTF8 with Informix
Hello, I am relativly new to informix and must make a migration from the typical 8859 charset to UTF8. My database with the UTF8-locale is working, BUT because of multibyte chars (and char/varchar - columns store bytes not chars) all of my field lengths are corrupt. So I found t…
dbschema output don't show table's dbspace
Hi, I run dbschema on an 9.40 informix version instance. Unfortunately I have no indication of the dbspace where a table has been created. How can this be possible and how can I find this table location. Below is the dbschema command and it result : DBSCHEMA Schema Utility INF…
Sqlcode 100 On Fetch data in esql/c program but the rows are present
Hello. I have this problem: i've get sometimes sqlcode = 100 after fetch row, but the rows are present on db! This is my sample code: EXEC SQL BEGIN DECLARE SECTION; char statement[1000]; char bdc_stato_ddt; char bdc_user_prep[9]; char bdc_data_prep[…
RE: IDS 11.70
Hi, Just wanted to mention this. I had the same problem after upgrade to 11.70.UC1 from 11.50.UC7. listener-thread: err = -28021: oserr = 0: errstr = : A trusted connection was not established because a trusted context is not defined or enabled for the specified authorization I…
cdr define server issue
Hello, friends. I´ve already have an ER domain, funcional, primary instance is 11.50.FC6W1 on linux_64 machine. I´m trying to add a new ER node, leaf type, but the following command is not working right. The new node is 11.50.FC7IE on the same arch. cdr define server -c [new_no…
Error installing CSDK on Windows Italian locale
Hi all, I've got a user experiencing an error trying to install Informix CSDK 3.50 silently on Windows Server 2008 version 6.0.6006 with the server locale set to Italian. I would appreciate any information anyone has about how to resolve this. It's a default install and the co…
How to Monitor Open Connection Tiime???
Hi, I am having some issues in a new environment we just installed and would like to ask some tips to monitor the open connection time. Informix 1.50 FC7W1GE on Linux RedHat 5.5 Client 3.50 FC4 I am monitoring the transaction time for a transaction from the client perspective,…
clientSDK 3.70.TC1 on Windows 2000 - ODBC
Hello, my friends. IDS 11.70.FC1IE on linux_64 redhat machine. I have an old application on windows 2000 machine, and after an Informix upgrade, I couldn´t understand why, after the client installation, the "IBM Informix ODBC driver" is not listed on the ODBC sources list. On …
Re: MSGPATH x syslog
I have more or less what you want... My "relatively complex script" can be setup for what you want. The configuration file must be setup with a pattern that matches every thing, and you can configure it to call a function that calls the logger. The main script already accepts ar…
Re: MSGPATH x syslog
I have more or less what you want... My "relatively complex script" can be setup for what you want. The configuration file must be setup with a pattern that matches every thing, and you can configure it to call a function that calls the logger. The main script already accepts ar…
Re: MSGPATH x syslog
Hi Fernando, Thanks for your suggestion. I'm trying doing something more simple, something like, set and forget, just like Informix is... and easy to implement with any version of informix. As far I tested the logger command , they is very flexible.. so , at first I think try t…
Re: MSGPATH x syslog
Hi Fernando, Thanks for your suggestion. I'm trying doing something more simple, something like, set and forget, just like Informix is... and easy to implement with any version of informix. As far I tested the logger command , they is very flexible.. so , at first I think try t…
Re: MSGPATH x syslog
On Tue, Nov 23, 2010 at 11:01 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi, > > Anyone know if is possible redirect the output of the MSGPATH to > Linux/syslog ? > > I already think try use a pipe file + logger command... but , isn't > elegant and I …
Re: MSGPATH x syslog
On Tue, Nov 23, 2010 at 11:01 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi, > > Anyone know if is possible redirect the output of the MSGPATH to > Linux/syslog ? > > I already think try use a pipe file + logger command... but , isn't > elegant and I …
MSGPATH x syslog
Hi, Anyone know if is possible redirect the output of the MSGPATH to Linux/syslog ? I already think try use a pipe file + logger command... but , isn't elegant and I not sure if will work properly. Regards Cesar…
MSGPATH x syslog
Hi, Anyone know if is possible redirect the output of the MSGPATH to Linux/syslog ? I already think try use a pipe file + logger command... but , isn't elegant and I not sure if will work properly. Regards Cesar…
AUTO: Ankit Agarwal is out of the office (returning 12/14/2010)
I am out of the office until 12/14/2010. Note: This is an automated response to your message "Informix-list Digest, Vol 250, Issue 2" sent on 11/23/10 10:00:00. This is the only notification you will receive while this person is away.…
Lost chunk/dbspace space
We have moved from an HP/UX 9.4FC3, physical server/drive environment to a RHEL 5, 11.1FC3 (no option to go to 11.5 or 11.7) VM server/SAN storage environment. In HP/UX, I used SAM to create logical volumes of raw disk space and then used symbolic links to create the chunks for …
Re: DBEXPORT IN RSS NOT WORKS
I think it's a BUG. It will work if you use just one tempdbs. Set DBSPACETEMP=dbstemp1 on RSS secondary, then bounce engine (RSS secondary).…
Back up logical log in file IDS 10
Hi, Can anyone give me an idea to take logical log backup in file? IDS 10 on AIX I can take a level 0 backup by this command : ontape -s -L 0 0t STDIO > level0 but this command didn't work : ontape -a -t STDIO > logicallog Regards Ali…
IDS tcp listening port on RHEL 5
I tried different tcp port numbers (ex: tcp 6975; tcp 55001) for my new IDS 11.7 UC 1 GE to listen to on RHEL 5 but i'm not able to connect to it using OAT or even "telnet hostname portnum". service iptables is off /etc/services file entry looks good /etc/hosts file for machin…
Re: Details on Informix 4GL products
Jonathan, your answer is very clear, and very useful for me! I hope it can be useful also for other people of the Informix community. Thanks, Francesco…
How to change database instance name
Hello, I have done a search on this and I can find how to change the name of the database engine in Windows (theres even a tool to help), but how do you change the database instance name on a Linux setup? Thanks for your time and help. Sorry if this is already elsewhere.…
(paypal payment)( http://www.jialiuonline.com/) cheap wholesale ED hardy Christan Audigier,LV,BOSS etc. brand caps hat belts and other products free shipping
(paypal payment)(http://www.jialiuonline.com/) cheap wholesale puma hat <free shipping paypal payment> (paypal payment)( http://www.jialiuonline.com/) cheap wholesale,bape ,hat (paypal payment)( http://www.jialiuonline.com/) cheap wholesale, era NBA ,hat <free shipping payp…
TempDBSMonitor ay be in an infinite loop - execute
Hi, I'm trying to figure out what caused this problem on our HDR (secondary IDX version 9.40.UC6 on AIX 5)... I have no idea as i'm not the one maintaining the script. Do you have any idea what caused "infinite loop?" Here's the message i've got. PSL script TempDBSMonitor, COL…
SQLException on memory allocation
Hi, I am using IBM Informix Dynamic Server Version 11.50.FC6WE, RHEl 5 (18GB RAM, x64) and an application is continuously inserting into a table (around 10+ records per sec). After certain time getting memory allocation exception in application logs. But no issue found in online…
compatibilidad 9.40 con 11.50
Hola a todos. Espero puedan darme una mano con esto. Hemos migrado una BD q estaba en un motor Informix 9.40 a uno nuevo versión 11.50. Resulta que una de las bd (bd1) lanza un trigger que ejecuta un stored procedure que inserta registros en una tabla de otra base de datos (bd2).…
Re: Assert error last night :-(
Is the disk array set up as RAID0, RAID5, or RAID6? If so, then yes, it sounds like the partial media failure problem has begun to bite you. Time to get new drives. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http:…
paypal Jordan Shoes,discount prada Handbags: Shoes: Runner's World
Wholesale Jordan Shose|Wholesale Jersey|Wholesale UGG|Wholesale http://www.supertradeonline06.com/ wholesale jordon mens shoes - offers from wholesale jordon mens http://www.supertradeonline06.com/ wholesale jordon 8 jordan22 men s basketball http://www.supertradeonline06.com/ …
Assert error last night :-(
HI I got this error on our live database last night 17:54:41 Assert Failed: Page Check Error in phposition:isposition:bad page 17:54:41 IBM Informix Dynamic Server Version 9.40.UC7 17:54:41 Who: Session(35462, cs3@suze, 10771, 0x96e058f8) Thread(35871, sqlexec, 8f9823d8, 1) F…
Re: proper way to create rawdevices in Red Hat Enterprise 5.5
Any of those will get the job done. It just depends on what your site standard is. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opin…
proper way to create rawdevices in Red Hat Enterprise 5.5
I'm setting up a new IDS 11.7 instance on a new server. What is the proper way to create informix rawdevices in Red Hat Enterprise Linux 5.5 (32-bit X86)? method #1: ln -s /dev/cciss/cxdxpx /etc/udev/devices/dbsname add "informix" group and user ownership in /etc/udev/rules.d/50…
DROPPING BUFFERPOOL
HI FOLKS! I AM WONDERING IF I CAN DROP A BUFFERPOOL REMOVING ONLY THE BUFFERPOOL ENTRY FROM THE ONCONFIG FILE AND RESTARTING THE ENGINE? I CREATED A DBSPACE WITH A PAGE SIZE OF 4K, BUT ACTUALLY I WAS NEEDING ONE OF 8K .. BUT THE ENTRY OF 4K STILL IN ONCONFIG. I WILL THANK YOU …
Constraint Owner
Hi Folks, I have adopted some online instances (11.50.FC5 on AIX 5.3) in which the previous DBA had a bad habit of creating database entities as himself rather than informix. My question is... Can I simply update sysconstraints (owner column) to informix rather than dropping and…
Re: informix on windows
We use the local system account. Have for years. j. Nov 18, 2010 02:30:14 PM, tomcaml@gmail.com wrote: =========================================== Hi All Has anyone ever run Informix on Windows using an account other than the Informix account? It is being suggested that we …
How long should it take to drop a database?
Is it a database size/objects dependent factor? Does anyone know? (Assuming there's no user connecting to it of course). Our test database is about 3GB but it takes more than 30 strange minutes to drop. Thanks.…
New release of utils2_ak
I've just uploaded a new release of my utils2_ak package dated November 17, 2010 which will be online in a few days. There are a few bug fixes but the biggest reason to download it is if you are using or considering using Informix 11.70 (formerly known as Panther)! The latest rel…
New release of utils2_ak
I've just uploaded a new release of my utils2_ak package dated November 17, 2010 which will be online in a few days. There are a few bug fixes but the biggest reason to download it is if you are using or considering using Informix 11.70 (formerly known as Panther)! The latest r…
informix on windows
Hi All Has anyone ever run Informix on Windows using an account other than the Informix account? It is being suggested that we run it as a Windows Domain/System Account instead but I don't know if that will even work or not - We have always run Informix using the Informix accoun…
Re: finding inplace alters
You do have a way with words don't you Art ? ha. Yea I hear you totally. Thanks again ! ----- Original Message ----- From: art.kagel@gmail.com Sent: Thu, November 18, 2010, 6:48 AM Subject: Re: finding inplace alters Yes, Floyd. If there is even a single table that has pendi…
Re: OK Next step: ISM imported restore of onbar -w using disk-based backups
*Sigh*. I'm reading something wrong, here, surely? Or maybe I'm not expressing what the situation is and what we need to do? The imported restore procedure in the link mentioned is the one I'm already working from. I have set up a minimal instance on our live and development mach…
Re: finding inplace alters
Yes, Floyd. If there is even a single table that has pending alters the reversion will fail. Well, it's more like it will refuse to start. If that happens, any way that you can eliminate the pending alters is OK. So unloading the troublesome tables and reloading (either befor…
Re: finding inplace alters
Fernando, you are correct that you can properly upgrade without completing the in-place alters and they only matter if you have to revert to the previous version. At that time the alters all have to be complete or the reversion will fail. That said, since you have much more tim…
Re: finding inplace alters
On Wed, Nov 17, 2010 at 9:35 PM, Floyd Wellershaus <floyd@fwellers.com>wrote: > Hi, > Running ids10.0.fc5 on aix5.3 and needing to upgrade to 10.0.fc11 to get a > bugfix. > trying to find and fix inplace alters. The script ibm supplies doesn't work > for mulitple reasons so far.…
finding inplace alters
Hi, Running ids10.0.fc5 on aix5.3 and needing to upgrade to 10.0.fc11 to get a bugfix. trying to find and fix inplace alters. The script ibm supplies doesn't work for mulitple reasons so far. It fails on some oncheck -pp's and also when it builds a list of tables out of our 60k p…
rootdbs size
We are trying to initialize our 11.1FC3 install on RHEL 5 as part of an upgrade to a VMware server and from an existing HP/UX-9.4 environment. We are using raw devices for our chunks. Based on our 9.4 installed, I created chunks for rootdbs of 350MB and a chunk for physdbs of 10…
Merge statement, external tables ...
v11.50.fc7w3 Aix 6.1 Can an external table be used with a merge statement, or would the external table need to be loaded into a real table before being part of a merge statement ... In my case the external table would not be the updated table .. that I would think wouldn't work …
Spatial DataBlade
Hello, Looking on Passport Advantage, I do not see it listed specifically for the Windows Server 2008 Platform. There are three versions listed: Informix Spatial DataBlade 8.21 Multiplatform English eAssembly(CR5IFNA) Informix Spatial DataBlade 8.20 Multiplatform US English eAs…
Need Help- IDS 11.5 Stored procedures.
Hi, After migration from IDS 10. to IDS 11.5, It observed that the stored procedure with recursive/nested stored procedure calls working fine on IDS 10, is not releasing the memory on new Informix Engine IDS 11.5. Could you please help to resolve the issue. I am monitoring the o…
Re: ER out of sync
informix-list-bounces@iiug.org wrote on 11/15/2010 06:46:33 AM: > From: > > Cveja <nikomah@gmail.com> > > To: > > informix-list@iiug.org > > Date: > > 11/15/2010 06:50 AM > > Subject: > > Re: ER out of sync > > Sent by: > > informix-list-bounces@iiug.org > > On Nov 12, 7:51 pm, …
Re: Calculating extent sizes
I agree with Fernando. You SHOULD be able to run oncheck as user informix. Check the permissions and ownerships of your chunk files. They should all be owned by informix, group informix and permissions of -wr-wr---- or 0660 Art Art S. Kagel Advanced DataTools (www.advancedat…
Re: Calculating extent sizes
On 2010-11-15, JonnyTDI@Usenet-News.net <JonnyTDI@Usenet-News.net> wrote: > > Extent size "doubling" ... i.e. you loaded a table which had an initial > extent size of 131072 ... extent 1 filled up and then the server > allocated a new extent and as it was able to allocate contigu…
RE: Amazon EC2....
Hi Gumby, I don't have intention to use the "cloud resources" in EC2 . I choose try use it, because is the unique place, with "low cost" what I found to run Informix Innovator-C , where the instance can run 24x7 . Just run a single and small instance. --- Em ter, 16/11/10, I…
RE: Amazon EC2....
Amazon's EC2 is cost effective if you're doing a POC and are not ready to pull the trigger on building your own infrastructure. Using your example... you want to build your own site based on Drupal and IDS I-C. For a starter site... you can put Drupal and IDS on the same box. D…
IDS 9.4 VMWare and SAN
First off I know 9.4 is old and no longer supported. I am trying to convince my company to upgrade to the latest IDS 11 and not go to SQL server (sigh...) we currently have 9.4 on suze 8 with a dedicated external disk array and raw chunks. I have been told to evaluate 9.4 with …
any interest in jerseys pyapal wholesale from china ?
(http://www.jialiuonline.com ) I really got some useful information from your article. Are you also interested in cheap football jerseys? I want to introduce some great jerseys such as Santonio Holmes Jets Jersey(http://www.jialiuonline.com ) Jets Santonio Holmes Jersey Holmes…
tablas temporales en IDS 11.5
Estoy buscando informacion sobre donde se almacena la definicion de las columnas y tipos de datos que se obtienen al crear una tabla temporaria a partir de una sentencia sql tal como <select * from tabla... into temp t>, el nombre de la tabla se guarda en sysmaster:systabnames pe…
Logical Log Files are Full -- Backup is Needed
I have updated IDS to IBM Informix Dynamic Server Version 11.70.FC1. Unix OS - HP-UX B.11.31 - ia64 After update I am getting following message. IBM Informix Dynamic Server Version 11.70.FC1 -- On-Line (CKPT REQ) Up 04:53:11 -- 215824 Kbytes Blocked:CKPT 10:12:01 Maximum ser…
'Not enough memory' 'Physical restore failed ...
Hi, I'm facing the following problem. I have an AIX 5.3 box running an informix instance named pcoipcoi (see an excerpt of the onconfig below for memeory configuration ) : SERVERNUM 3 SHMBASE 0x700000000000000 SHMVIRTSIZE 1048576 BUFFERS 183500 PHYSBUFF 64 LOGBUFF 64 LOGSIZE 50…
Calculating extent sizes
Hi, I created a table using next command: create table "abba".water2009test ( awdate datetime year to minute, statnam char(6), statdev char(6), flags smallint, signs smallint, awertf smallfloat size 131072 lock mode page; ) in dynabbadbs extent size 131072 next size 131…
Details on Informix 4GL products
There are five different versions of Informix 4GL product, so how to check the products are really installed on my system? How to get version and serial number? - 4GL RDS Development - 4GL RDS Runtime - 4GL Compiler Development - 4GL Compiler Runtime - 4GL Interactive Debugger D…