Threads from 2009
Browse by month: Jan · Feb · Mar · Apr · May · Jun · Jul · Aug · Sep · Oct · Nov · Dec
Happy New Year!
Hope 2010 brings you lots of Informix goodness! -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and…
Data Dbs suddenly went Full
Hi, We've faced an issue where the dbspace kept on reducing and suddenly it reaches dead level. Then we've added space, but after adding space into it, the old space is being shown as well, as it never being used. After monitoring log file, we've found "temporary DBspace tempdbs_…
isql run error after upgrade
isql version : 7.32fc2 ids version: 11.5FC3 upgrade to 11.5FC5 After upgarading to 11.5fc5. Running isql select form -> compile . It will not list all the *.per source file. isql version not change. Install steps: 1. create a new directory 2. install isql 3. install ids …
Online Backup is Failing------WebKitFormBoundaryBg
Hi All, My onbar -b -L 0 sometimes fail due to netbackup congestion. Given the problem, i always initiate a manual backup. Q: is there someone who have done a script that once the backup failed, it will save the backup status into a table and from there, an automatic trigger is…
IDS 11.50.xC6 is out...
Hello, IDS version 11.50.xC6 is currently available. It has become usual for these fixpacks to bring a lot of new functionality, besides the usual bug fixing. From the release notes: 1.5 What's New in Version 11.50.xC6 of IBM Informix Dynamic Server 1.5.1 External Bac…
odbc connection pooling settings (in windows client)
Hello, in the odbc control panel in windows, i go to the connection pooling tab (not sure in english how it shows to you), i double click on IBM INFORMIX ODBC DRIVER and there there is a window with an entry for the amount of seconds for keep a connection in the pool. There is a…
Indexes usage
Hi People !! Please, a need some help how to find in my database the indexes with high percent of usage. Anybody knows if exist a function or if I have to develop a query ? Thanks, Best Regards, Eduardo…
paypal wholesale cap (paypal payment)( www.brandshoes08.com)
paypal wholesale brandtrad(Jersey,ugg boots,shoes,clothes,handbag,watch,jeans,eyeglass,cap,T- Shirt,shawl,wallt and so on.) paypal wholesale UGG BOOTS (5225,5325,5245,5359,5812,5815,5825,5831,5854,5509,5511) (paypal payment)( www.brandshoes08.com) paypal wholesale d&g shoes (pay…
preteen models in panties kids naked naturist nude nudist illegal underage girls bbs list teen loli young naked kids
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** young children nude underage teen girls nude young nymphets art pre teen models little lolita models celebrities who did underage nudity in film non nude preteen models child pornography preteen nudist pics lolita portals…
kids naked hot young preteens lolita underage models preteen boys masturbating anime kid porn
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** lolita sex young preteen russian porn preteen little nymphets legal child porn preteen nudes russian preteen sex bbs teen webcam top 50 preteen art models links loli girls bbs nude naturist preteens photos underage bbs il…
female child pornography ls magazines free underage porn kid sex stories underage nudity pictures
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** underage preteen lolitas thumbnails lolita mpegs nymphets preteen nudist very young preteens nude lolitas child sex preteen lolita preteen nudists nude preteen boys preteen lolita pics preteen underwear models free nude p…
free preteen lolita girls preteens young preteen nudes lolita nude models preteen naked girls
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** young naked preteens underage teens nude child sex education lolitas underage young preteen blonde sex russian nude children lolita bbs sun hidden cams on naked kids lolita sex teen lolita models panties pics nude girl ch…
russian lolitas underage sex lolita illegal sun loli bbs free young lolita preteen models in panties
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** little nude lolitas underage nudist child lolita nude underage pre teen underwear model loli nude bbs young kids nude preteen boy art lolitas bbs lolita art naked preteens in panties child lolita preteen naked preteen gir…
preteen models top pedo love nymphet models nude lolita art little preteen girls naked
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** little innocent lolita girls bbs hussyfan hot young girls preteens preteen nudists art pages illegal teen sex tiny preteen lolitas and boys nudist preteen girls naked preteen pics pedo girls pre teen models having sex und…
preteen girl model galleries naked children sex nude preteen boys preteen boys sex pre teen porn
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** lolita nude little innocent lolita girls non nude preteen bbs guide ranchi zeps nude preteens preteen girls wearing thongs children naked pics illegal sex pics nude kids gallery naked preteens preteen virgin lolita nudist…
underage little girls underage preteen lolita nudists pedo stories underage nudity underage preteen girls
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** preteen nude models porn preteen russian preteen porn naturist preteens nude preteen models hussyfan bbs lolita art model, lolita model young russian lolitas underage girl porn lolitas illegal, underage nude preteens nude…
cap d'agde naked children teenagers art lolita bbs and ranchi and lolita cp illegal videos kids nude pics
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** young underage teen models preteen nudes preteen lolita pics free russian lolita naked preteen girls naked preteens best preteen pussy preteen lolitas bbs nudist underage preteen nudists nude preteen boys little lolitas i…
preteen naturist video nude preteen model preteen girls in bikinis nudist loli bbs angels preteen teen underage nudist naturist beach
** ** ** Lolita Porn ===>> http://beam.to/xxxvids ** ** ** ranchi zep bbs preteen girls posing in panties nymphet lolita naked preteen loli ranchi bbs young lolita school girls hot young girls preteens pussy lolita underage preteen little nymphets young lolita preteen underage, u…
Re: Restoring a dataspace
Warning: Shameless, self-promoting plug below. ];-) On 2009-12-17 3:16 AM, HFS wrote: > Hi, > > I have two identical database installations in two identical machines. > Is it possible restore one dbspace from one machine to another with > ontape? I'd like to load a database to t…
Database Migration from DAS to SAN (VMAX)
We have our Informix Database ( version 11.x) running on our Primary Server and replicating the same to our Secondary and Remote Shard Secondary servers in Linux Platform. ( RHEL5). Currently these databases are using the DAS storage and we are planning to migrate from DAS to EMC…
Merry Christmas!
Hope "yule" all have a great holiday! ;o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is be…
Turning on Logging in a Smart Blob Space
IDS 11.50.UC5 Linux [Don't you just hate typos .... trying again ...] IDS 11.50.UC5 Linux We are converting byte fields to blob fields as we move data to smart blobs, as seen below: ALTER TABLE images MODIFY b_image_byte BLOB, PUT b_image_byte IN (images01sbs, images02sbs) (E…
Turning on Logging in a Smart Blob Space
IDS 11.50.UC5 Linux We are converting byte fields to blob fields as we move data to smart blobs, as seen below: ALTER TABLE images MODIFY b_image_byte BLOB, PUT b_image_byte IN (images01sbs, images02sbs) (EXTENT SIZE 4, NO LOG, KEEP ACCESS TIME); ALTER TABLE images MODIFY b_im…
A Surprise Gift for you by Project Drive!!
Have you ever think that you also can be able to get A Free Project Management Software provided at http://www.project-drive.net/ Yes, Project Drive is offering Free Project Management Software and tools special on Christmas to celebrate with the http://www.project-drive.net/. .…
You heard it hear first...
Dynamic Master/Slave Relationship within a Peer/Peer Network. As cryptic as that sounds, it will be significant in the near term future. To Jerry K: Just a little X-Mas gift. What you do with it, is up to you. Ignore it, and I'll lose what little respect I still have for you. …
WWW.PETBED-CATTREE.COM Cat Tree,China Cat Scratcher,Cat Pet Beds Manufacturer,China Cat Tree Supplier,China Cat Tree Exporter
WWW.PETBED-CATTREE.COM ( Pet Beds, Cat Trees, Iron Dog Beds Factory, China Cat Scratcher, Car Boat Air Plane Dog Beds Exporter, Pet Bed Cat Tree Wrought Iron Metal Pet Beds, China Pet Dog Cat Furniture Pet Products Manufacturer & Exporter ) . Hi there, This is China Beijing Diose…
connecting IDS on different machines
Hi experts! I can use dbaccess to make a connection to another database on another machine. But what do I need to put in my 4GL program to make this connection?? connect to dbsname@ol_othermachine gives a syntax error Any idea?? Thanks! Danny…
Re: report printing problem informix
Check what the number of lines value define with page length at the output section in the 4gl program On Dec 24, 2009, at 12:39, Art Kagel <art.kagel@gmail.com> wrote: > Print the report to a file and examine the contents. Probably there > is an embedded formfeed character in …
report printing problem informix
Hi All, I am new to informix and I am struggling with a bug for quite a few days. Whenever I send a report to a printer The last line of every page stretches to the next page. I even tried using skip to top of page after grouping of sort value. But it does not work.…
Re: Obituary
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.402.1261508531.6236.informix-list@iiug.org... > All that and no mention of the indexed access method he created... > http://www.telegraph.co.uk/news/obituaries/religion-obituaries/6867538/The-Right-Revere…
Re: trigger on insert: updating one value of the same table
On 11 дек, 18:57, Gentian Hila <genti.t...@gmail.com> wrote: > I did a test on this as the whole SQL is a long thing and has other > parts in there that would simply make it more confusing. > > 1) Create a test table > > create table test1 > (cust_num CHAR(10), > desc CHAR(30), >…
NETTYPE for 11.5 in Redhat EL 5
Hi, I did setup yesterday a new box using 11.5 and RHEL 5. I had a problem on setting up the correct nettype parameter... I was able to use "onipcshm" but i'm having problem on setting up the "ontlitcp"... Any suggestion? thanks,…
RE: {Spam?} RE: Obituary
> Date: Tue, 22 Dec 2009 20:24:59 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: {Spam?} RE: Obituary > > Ian Michael Gumby wrote: > > > > > > Nor of his spamming activities. Assuming that this is the same 'The > > Right Reverend Colin James II…
Re: {Spam?} RE: Obituary
Ian Michael Gumby wrote: > > > > Date: Tue, 22 Dec 2009 19:01:33 +0000 > > From: obnoxio@serendipita.com > > To: informix-list@iiug.org > > Subject: Obituary > > > > All that and no mention of the indexed access method he created... > > > http://www.telegraph.co.uk/news/ob…
RE: Obituary
> Date: Tue, 22 Dec 2009 19:01:33 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Obituary > > All that and no mention of the indexed access method he created... > http://www.telegraph.co.uk/news/obituaries/religion-obituaries/6867538/The-Right-Rever…
Obituary
All that and no mention of the indexed access method he created... http://www.telegraph.co.uk/news/obituaries/religion-obituaries/6867538/The-Right-Reverend-Colin-James.html ;o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself …
Internal Communications Error: internal inconsistency detected
getting the following message on the online.log listener-thread: err = -27003: oserr = 0: errstr = : Internal Communications Error: internal inconsistency detected. the server has 3 aliases: shared memory local connections, onsoctcp with PAM LDAP authentication onsoctcp with SS…
Will ifx_row_version incremented via ER?
Hi, gurus! Will ifx_row_version incremented when row was updated via enterprise replication? With best regards, Victor…
ontape problem on IDS9.4FC5 for AIX
Hello, I want to backup the instance through ontape, but IDS report error when the backup target file large than 2Gb, I have change the following property of the informix user to -1 through smitty . 1) hard limit; 2) soft limit; any suggestion will be welcomed.…
space alerting
Hi, Has anyone had any experience(or idea)on enabling alert against space in Informix? With OAT or a automated query, I can find the space used and ..., But I need an alert like alarm program. Regards…
How do I determine and fix the db_locale.
This is a Windows 2008 and IDS 11.50.FC5 server with Client SDK 3.50: Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (8…
Auto Update Statistics Evalution
Hi, I'm running 11.50.FC5 and I am getting the following messages in my online log when the "Auto Update Statistics Evalution" is running: 12/20/09 01:00:05 SCHAPI: Error -242 Could not open database table (informix.aus_work_info). 12/20/09 01:00:05 SCHAPI: Type: TASK, Name: Aut…
OLE DB drivers and SSIS packages
I am trying to make sure that some SSIS packages can run on a server that requires the OLE DB drivers to be installed. The servers with the SSIS packages are SQL Server machines running Windows trying to connect to a Windows 2000 machine with Informix 7.31.TD5 on it. I have run t…
Re: Table extentsize query
But that's a different question, with a different answer. The queries to see the size of each extent and the number and other stats of the extents are: select dbsname, tabname, size from systabnames st, sysextents se where st. partnum = se.partnum ; select dbsname, tabname, co…
RE: Table extentsize query
Sorry, for me the query isn't much meaningful, though. The problem is that you will see the first extent size only, the next extent size, which is set dynamically is - in some cases - much more important. Unfortunately you cannot see how much extents of which size exist. If you b…
RE: C-SDK: Connection with DBDATE-Parameter
May be it's possible to use GPO to prevent users to modify setnet32 configurations and the registry? > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of Martin Thole > Sent: Friday, December 18, 2009 3:18 PM >…
Errors in online.log
SCHAPI: Error -245 Could not position within a file via an index. SCHAPI: Type: SENSOR, Name: mon_profile, Location: NULL. SCHAPI: Error -103 ISAM error: illegal key descriptor (too many parts or too long). SCHAPI: Type: SENSOR, Name: mon_profile, Location: NULL. SCHAPI: Error -2…
Compression
Hey all, do you have to pay an additional cost to use the data compression in 11.5.FC4? And does anyone have an opionion on how well XML data compresses? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets y…
invalid schema or catalog from MS SQL linked serve
Hi, I have the following databases (Informix = DNS 10.00FC8 on Linux RedHat , MS SQL server= Version 2008 EXPRESS running on Windows 2003R2 SP2, I am using IBM Client version 3.5 TC4 to connect from Windows server to Linux). I setup the Informix database as a linked server on MS…
C-SDK: Connection with DBDATE-Parameter
When opening a connection, you can specify a lot of parametesr: Server, Database, Host, UID, DBLOCALE ... But can we set the environment variables (from SETNET32) from the appliction ? How can we set DBDATE oder DBMONEY ? Example: DSN=IFXODBC;SERVER=ifx_vmsles;Host=vmsles11;Da…
RE: {Spam?} The future of databases?
> Date: Thu, 17 Dec 2009 22:21:02 +0000 > From: obnoxio@serendipita.com > Subject: Re: {Spam?} The future of databases? > CC: informix-list@iiug.org > > Ian Michael Gumby wrote: > > Ok, > > > > Here are two articles that came up in a google search that happen to > > have caught m…
Re: {Spam?} The future of databases?
Ian Michael Gumby wrote: > Ok, > > Here are two articles that came up in a google search that happen to > have caught my eye. > http://www.networkworld.com/news/2009/121709-big-three-database-vendors-diverge.html?page=1 > http://www.itworldcanada.com/news/big-three-database-vendo…
The future of databases?
Ok, Here are two articles that came up in a google search that happen to have caught my eye. http://www.networkworld.com/news/2009/121709-big-three-database-vendors-diverge.html?page=1 http://www.itworldcanada.com/news/big-three-database-vendors-disagree-on-hadoop/139613-pg2 If…
Table extentsize query
Does anybody have a query that returns tablename and extentsizes? I haven't quite gotten one to work vs. sysmaster -- it will return 2 rows per table: select tabname[1,24], hex(syspt.partnum), fextsiz, nextns from sysptnhdr syspt, systabnames systab where dbsname = "<target_dat…
Error when inserting in functional index
Hi guys, about 2 weeks ago i made a new post about an error 206 when using a functional index in our 4GL application. We are using IDS 10.FC9 on AIX 5.3 4GL 7.32 We have a 4GL which was returning the error 206 when was trying to do this select: select * from edc_det where cod…
IDS 11.5 Procedures slow at seemningly random time
Hello all, I have been spending a bit of time investigating a problem I have with a couple of my SPL procedures. To give you some background. I have two SPLs that are invoked through a Perl script every 10 min. Three to seven times every 24 hour period (at seemingly random times…
2010 IIUG Informix Conference Update
Join us on April 25th - 28th, 2010, for the largest gathering of Informix users, developers and all around enthusiasts. This is the best opportunity on earth for Informix training, presentations and insights with access to consultants, experts and IBM Informix management and exec…
Error : 930 Cannot connect remote database
Hi, we had a migration of our development server ( thru imaging ). The O/S and informix version remains the same. Only the IP and hostname got changed. Informix 5.11 / HP-UX B.11.00 U After a little configuration change in /etc/hosts, /etc/hosts.equiv its up and running and the…
Online Computer Training Courses with Beyourownit.com
Are you looking for education, training and tutorials in computer such as: • Computer Repair Course • Laptop Repair Course • Start Your Own Repair Business Course We offer you Online Computer Training Courses and tutorials at http://www.beyourownit.com/. Access our Online Compu…
error 25588 app. process can't connect server
Dear friends, I encountered the above error when more than 32 users accessing the application. My onconfig.abc file has the following parameters: DBSERVERNAME abc DBSERVERALIASES abc_tcp NETTYPE ipcshm,1,64,CPU NETTYPE tlitcp,1,64,CPU MULTIPROCESSOR 1 NUMCPUVPS 1 SINGLE_CPU_VP …
Restoring a dataspace
Hi, I have two identical database installations in two identical machines. Is it possible restore one dbspace from one machine to another with ontape? I'd like to load a database to this dbspace in one machine and then move it over to another machine afterwards. Thank you for a…
ids developer edition-11.5 -unbuntu karmic koala
Hi Please let me know if these two (ids developer edition-11.5 -unbuntu karmic koala 32 bit) are compatible? When i tried to install it exited giving me ld-linux.so.2 not available error. I checked the /lib and it was not available. Please let me know how can i fix the error. …
IDS 11.5
I'm trying to run performance tests. However, I need to be able to repeatedly run a query without it being cached in the buffer. For example, I run query1 and it takes 6 seconds, I don't change anything... run query1 again and it takes sub second. I want to be able to run as thou…
IDS 7.3 help needed ASAP
Hi , Here is the problem in detail : We have an informix 7.x database and users connect to it through a c++ application written way back in 1998. The issue is thats ,i have granted myself DBA role,resource and connect privs and i am still unable to connect to the database using t…
Free Project Management Software and Tools
Free Project Management Software and Tools "Which Free Project Management Software Provider will come in your mind after the listening Online Project Management Software"? What do you think? Are you familiar with the word Project Management Software and http://www.project-driv…
How to create web service in 4GL 7.50.UC3?
I installed this version in a server with IDS 11.50.UC2. Any sample for me create a web service in SOA? Thanks.…
chunk offline
Hi All, We had a situation were a non-critical chunk went offline. This was a cluster setup and during some testing/disk alignment by Unix, this chunk went offline. It was marked PD. This chunk contains only a portion of one Index.( Checked before using oncheck –pe ). Used onspa…
dbschema : 100 - ISAM error: duplicate value for
Hi Folks, running IDS 9.40 on Solaris. During dbschema, th ejob was interrupted with the message above. Any idea how I can easily determine the table with the problem ? Here are the last lines of the output of dbschema : { TABLE "cti".acth row size = 56 number of columns = 6…
Moving IDS 10 from PA-RISC to Itanium
Hi I am trying to restore a full HP Data Protector 6.1 backup of an IDS 10.00.FC9 database on a PA-RISC server running HP-UX 11i v1 to the same informix version on an Itanium server running HP-UX 11i v3. I am getting the following error: [Normal] From: RSM@brglb2 "" Time: 15/1…
Free Project Management Software and Tools
Are you looking for a Free Project Management Software? Then, stop your search at http://www.project-drive.net/ . They provide Web Based Project Management Software, Web Based Project Management Tools, Free Online Project Management Software and much more for your business at ht…
V10, PDQ, Business Objects and ODBC
Hello All, I am using Informix V10 on Sun Solaris ( different versions ). I would like to use PDQ for queries coming from Business Objects. I gather they use ODBC connections. Is there a way I can include PDQPRIORITY directives within ODBC definitions, BO configuration files et…
9.40 Patch and Support Level
I am trying to find out the current situation for Informix 9.40 for one of our customers and would be grateful if you could please let me know the following: 1. I noticed that the last fix pack was in 2007. Are there any plans for further patches? 2. When will support for 9.40 …
Connecting to Informix DB on another UNIX server
Hi, I am trying to connect to a Informix DB instance on another UNIX server, but am not sure what are the exact steps to be taken. I am aware that we can connect to another instance on the same UNIX server and I am trying to implement the same logic to connect to another instan…
C Shared Library function in IDS 10
In a piece of software that I use a custom version of soundex exists. I've split this function into its own shared library and tested it to show that calling the function works as such from a regular C program: #include <stdio.h> char *cx_soundex(char in_buffer[32]); main (arg…
Re: Resident Memory larger then expected
"Art Kagel" <art.kagel@gmail.com> wrote in message news:mailman.377.1260535600.6236.informix-list@iiug.org... >> I haven't yet overrun SHMTOTAL on an 11.50 instance since I always set >> SHMTOTAL to zero (unlimited) now, but in the past, if the engine wanted >> more virtual memor…
Help Needed: Recover Data after failed HPL job
Hello, I am in a bit of a jam after trying to use the AGS Server Studio to run a table reorg in HPL express mode. The job failed when trying to load data into a table with a blob field but after the table was dropped an recreated. So now i have an empty table in the database w…
SugarCRM and Informix
Hi everybody, does anyone know if is it possible to connect the SugarCRM with Informix Dynamic Server? Thanks, Thierry MOREL QUINTESS --0015175cfa1e82e07d047a81c223…
WWW.PETBED-CATTREE.COM Pet Bed,China Dog Beds,Car Boat Plane Pet Bed Manufacturer,China Pet Bed Supplier,China Pet Bed Exporter
WWW.PETBED-CATTREE.COM ( Pet Beds, Cat Trees, Iron Dog Beds Factory, China Cat Scratcher, Car Boat Air Plane Dog Beds Exporter, Pet Bed Cat Tree Wrought Iron Metal Pet Beds, China Pet Dog Cat Furniture Pet Products Manufacturer & Exporter ) . Hi there, This is China Beijing Diose…
Re: trigger on insert: updating one value of the same table
Have an external program that opens a cursor on the staging table, processes whatever it finds then loops and starts again. If the cursor finds no work to do, sleep for a reasonable time and try again. That way the worst case delay is during quiet periods and is the sleep time,…
Garbage collection and session limit for JDBC to I
Good afternoon, We are using a web based search tool that uses a JDBC connection to my Informix IDS 10.00 server. I would like to know if there is something I can set in the connection string in JDBC or a setting in JDBC that I will close an Informix session if there is no activ…
arithmetic function
Hi, Can someone please help. Is there a way to retrieve the value of some column before/after the curent column matching some 'where clause'. My goal is to retrieve in one shot, with one 'select statement', for instance the value of the current row and the difference (for the sa…
Re: trigger on insert: updating one value of the same table
I have IDS 9.40 ( we will upgrade soon to 11.50). However, here it is what documentation on ibm site says for v.10: If the trigger has an INSERT event, the trigger action can be an UPDATE statement that references a column in the triggering table, but this column cannot be a co…
Re: trigger on insert: updating one value of the same table
I am sorry, I do not understand this part: > insert into x values ( 1,"c=1+6=7",6); Can you explain a little bit more please? Thank you, On Fri, Dec 11, 2009 at 5:38 AM, Superboer <superboer7@t-online.de> wrote: > Dono if it is legal... should read the manual better however:…
Re: trigger on insert: updating one value of the same table
On Thu, Dec 10, 2009 at 5:46 PM, Art Kagel <art.kagel@gmail.com> wrote: > Insert a row from the INSERT TRIGGER into another staging table containing > the keys to the inserted row. Then a separate task can run or loop every N > seconds that extracts new rows from the staging tab…
db_locale mismatch
Hi, I'm reposting this under a different heading in case there's someone out there with some idea what's going on. I'm connecting to IDS 10 on hp-ux from a .NET app and getting the following error ERROR [HY000] [Informix .NET provider][Informix]Database locale information mismat…
RE: Resident Memory larger then expected
Correction: I wanted to say: Accordingly SHMTOTAL is set ... I have a machine with only 4 GB of memory and I want to run two instances of IDS. It' s a Datawarehouse test installation. And I have to use HPL to load rather large tables. So I limited the kernelparamter for shared …
RE: Resident Memory larger then expected
I have a machine with only 4 GB of memory and I want to run two instances of IDS. It' s a Datawarehouse test installation. And I have to use HPL to load rather large tables. So I limited the kernelparamter for shared memory that is granted to one "project" to 1 GB (a quarter of …
Re: Resident Memory larger then expected
I haven't yet overrun SHMTOTAL on an 11.50 instance since I always set SHMTOTAL to zero (unlimited) now, but in the past, if the engine wanted more virtual memory and SHMTOTAL was exhausted, the instance shutdown or hung. I know that there was an old feature request for the inst…
Re: Resident Memory larger then expected
The RESIDENT segment is more than just the buffer cache. For example, the lock table and the data dictionary, data distribution, stored procedure, statement and other static caches are all stored in the resident segment. Also if you have set RESIDENT to a value other than zero o…
RE: Resident Memory larger then expected
Hello Superboer, good hint! I changed LOCKS from 4,000,000 to 10,000 and now only 49152 KB for the resident portion were allocated. What happens if the server allocates more locks in 1,000,000 portions as I have seen before and memory is limited to e.g. 1024000 KB (SHMTOTAL)? R…
Resident Memory larger then expected
Hi all, in onconfig I set BUFFERPOOL size=2K,buffers=20000,lrus=8,lru_min_dirty=20.000000,lru_max_dirty=30.000000 . In the message log I see: Memory sizes:resident:570368 KB In earlier versions of IDS the formular was BUFFERS x 2 = Size in KB. I had expected memory size resid…
sysprocplan index corrupt/inconsistent
Hi all, OS: SUNOS xxxx 5.8 Generic_117350-31 IDS : 9.30FC6X1 Hi all, Snip from the af file: 12:04:20 bfcheck: bad page: pg_flags 0x90 != type 0x1 buffer header 0000000115998888: 00000000 00000000 00000000 00000000 ........ ........ 0000000115998898: 00000001 0d6fc0d0 00000001…
security question
IDS 10.00.FC9 on HPUX B.11.23 U ia64 I've been asked if the following is possible security wise in Informix by my boss from our lawyer. We have a employee or potential employee that needs special restricted access to our IDS databases, and this is the way it was explained to me…
Re: trigger on insert: updating one value of the same table
Insert a row from the INSERT TRIGGER into another staging table containing the keys to the inserted row. Then a separate task can run or loop every N seconds that extracts new rows from the staging table, performs the update, and deletes the staging row. Art Art S. Kagel Onini…
External Restore Issue
IDS 11.50.FC5 AIX 5.3 (4K Page Size) I am attempting to bring up an instance from one server onto another server without using an archive. Instead, I brought the "from" server down with onmode -ky, then ftp'd (bin) the flat files from one SAN to the SAN on the "to" server. On t…
trigger on insert: updating one value of the same table
I have a program that is closed to us. It inserts a new row, every column of the table. I want one to update the value of one column on the inserted row. I tried a INSERT on trigger but since the column is included on the insert it gives me the error: "table or column matches …
RE: email question
Thanks Stuart, That was all that I was asking for. Just a simple clarification. Except for one small detail. The IIUG says that they don't share the e-mail list with anyone. Looks like you have to amend your privacy statement. You do have a privacy statement, right? Also by CC…
RE: Featured White Papers from Database Trends and Applications December 2009
Art, I just had an interesting phone call with someone from emedia. They said that they usually provide the information to the IIUG to send, however that if they sent it, they sent it to a list that they received from the IIUG. So, if the IIUG sent them the email list, then it…
RE: Featured White Papers from Database Trends and Applications December 2009
Thanks for the quick response Art. If what you said is true, then you do have some recourse. Outside of litigation, you can talk to their ISP (one above the company) and get them bounced for violation of their TOS. You can talk with IBM and with their cooperation, 'freeze out' …
Re: Featured White Papers from Database Trends and Applications December 2009
Speaking as member of the IIUG Board of Directors: It's SPAM dude! More reprehensible than most I think since it's from what's supposed to be a reputable source (meaning emedia Pro). Pretending to be from the IIUG - it is not BTW, the BOD did not authorize any email to go to i…
Re: Record of Table Changes
IB my point was that if one has already licensed prior Suite releases of SS/Sentinel - which has some change management features - then upgrading to v7.0 is free and includes the extended change management feature. If you have a lower level SS license, the upgrade to the CMO or …
Re: Featured White Papers from Database Trends and Applications December 2009
Ian Michael Gumby wrote: > > I'm sure I'm not the only one getting this. > But here's the interesting thing. The from was identified as the IIUG. > > So can someone explain this to me? > Did Stuart et al lease out the list? %>< Yup, I got the same thing - headers as per your oth…
RE: Record of Table Changes
Not to knock AGS, but why pay for something when you can get it for free? I mean what are you paying your DBAs or Sysadmins for? Yeah that's the ticket. Informix DBAs, the new prop winders in the jet age.... ;-) From: art.kagel@gmail.com Date: Thu, 10 Dec 2009 10:14:11 -0500 Su…
4gl debugger
The debugger available from IBM seems to be rather complicated to use. Looks like you have to recompile everything to use it. Is there a debugger available that doesn't require all this work? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group …
Record of Table Changes
Does the DBMS keep a persistent record of data structure changes to tables in a format that is humanly accessible? For example, if a table has 4 different versions, how would I be able to determine what each of those changes was? Yes, this has been posted before (but not answer…
Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
Hi, The RA_PAGES parameter is the same in version 11.10 and 11.50? What is the definition of your DBSPACE ? Did you try 8KB? This issue is interesting, where is the bootleneck? Do you have WSTATS parameter enabled? Run your query and sysmaster:sysseswts for your session. Vagn…
ROLE FOR USERS
I am trying to set up role based access to user on certain table privilege , I have created the roles , granted specific table level privilege to role and granted the role to users , but the user needs to give SET ROLE role_name every time after he logs in to dbaccess , HOW to ma…
Db_locale / SQL_INFX_ATTR_LOCALIZE_DECIMALS error
Hi, I have a .NET application that works successfully except on one particular box. I get the message "Database locale information mismatch" when trying to connect to the Informix 10 database. The server db_locale is en_US.819, the db_locale set in SETNET32 is en_US.819, the cli…
ontape -a "this tape contains no log data"
Hello, informix gurus today, to do "ontape -a", the system show me the follow message: "this tape contains no log data" Program over. This are my settings . Red hat linux 5.1 . IDS 11.10.UC1 The online.log do not show nothing. the log file is empty before to do ontape. I onl…
RE: Long Checkpoints IDS 11.50
onstat -g ckp doesn't report any blocking: IBM Informix Dynamic Server Version 11.50.FC5W4 -- On-Line -- Up 5 days 01:06:34 -- 8329216 Kbytes AUTO_CKPTS=On RTO_SERVER_RESTART=600 seconds Estimated recovery time 568 seconds …
Why benchmarks are important....
While those IBM sock puppets who defend IBM at any cost (Hi Serge) keep saying that Benchmarks don't sell databases, the truth is quite the opposite. Sure, no one buys a machine based on a benchmark. But its the benchmark that puts the solution on the customer's radar. Its also …
IDS Updatable RSS on different platforms
I've been asked a question by my sup. Under IDS 11.50.xC4 or better.. if I had an RSS Primary running on HP-UX, could I have a Linux RSS updatable secondary? I know that standard HDR replication isn't cross-platform, but how about RSS? My goal is not to have to purchase another v…
IDS, BTS datablade and HDR
In the BTS requirements section it states that HDR is not supported. I understand the explanation about why the BTS cannot be replicated, it writes the indexes to file, but what is not clear is if the addition of the BTS datablade will *prevent* HDR. http://publib.boulder.ibm.co…
Long Checkpoints IDS 11.50
Hi all, last Friday and yesterday we had checkpoints with duration of 290 and 135 seconds. All writing applications were blocked. Typically the duration of checkpoints is 0 to 2 seconds. Didn't I understand right that blocking checkpoints shouldn't occur any more in this releas…
JDBC 3.5
Hi All, Informix-Server: IBM Informix Dynamic Server Version 10.00.FC8 since upgrading from Informix JDBC-Version 2.21 to 3.5, we somtimes get the following curious error, when fetching data from an IDS 10 FC8 (Linux). java.lang.IllegalStateException: Current state = RESET, ne…
RE: Change next extentsize for indexes
> Date: Tue, 8 Dec 2009 13:58:13 +0000 > From: obnoxio@serendipita.com > CC: informix-list@iiug.org > Subject: Re: Change next extentsize for indexes > > pow wrote: > > Hi, > > > > Is there a way to change the next extent size for indexes similar like > > for tables? For tables t…
Change next extentsize for indexes
Hi, Is there a way to change the next extent size for indexes similar like for tables? For tables the syntax is 'alter table <tablename> modify next size <newsize>' Regards! -POW…
Business Intelligence on Mobile devices
The Yellowfin BI team have produced a new paper on "Business Intelligence on Mobile devices". Anonymous Download Link Here http://yellowfin.com.au/Document.i4?DocumentId=99556 * No signup or email handover required Extract With the advent of the mobile phone a fundamental sh…
Update query with table reference in subquery
Hi All, I have update query which uses the base table in subquery, it gives error: "360: Cannot modify table or view used in subquery" UPDATE PSCIREF_tmp SET REF_CINAME = 'x' WHERE REF_CINAME = 'y' AND BCNAME IN (SELECT DISTINCT BCNAME FROM PSCIREF_tmp REF WHERE REF.REF_CINAME…
DR: Ping Timeout
Hello, We are frequently receiving below mentioned messages in online logs of primary and secondary instances. This problem suddenly started to occur a few days ago and before that every thing was going fine. We didn't change anything (either in onconfig file or any other setting…
IDS random slow down
I will apreciate any help. I have instaled Informix dynamic server 10.00 UC6 on RedHat Enterprise Linux 3 and I have the following situation. Aparently with out any reason and at random times of the day suddenly the engine becomes very unresponsive, this episodes can last for a…
RE: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
I have to agree that the issue is interesting. The fact that regardless of the query, the performance was relatively consistent. Writing a query to join itself against itself performs at the same speed as if it was just querying from a single table, or changing the query to use …
"AT TIME ZONE"
In PostgreSQL 8.x I can view a time or date value in a specified time zone with the following syntax: SELECT start_date AT TIME ZONE 'GMT' FROM date_x WHERE date_id = 18850; I've searched around and around and been unable to find any equivalent syntax for Informix? Isn't there …
Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
Fernando Nunes wrote: > fandelau wrote: >> Hello to all! >> I think I've found a nasty bug in IDS 11.xx on Solaris (SunOS 5.10) >> (yes I got the same results in both 11.10.FC3 and 11.50.FC3)... here >> are the details: >> >> I got a table 402 bytes wide, 78 columns all but 1 are…
Crazy talk?
10.00.UC8 Solaris 10 6-1, 182 Scorpio I am tired of messing with Commvault settings and their lame support and docs etc. The admin dude and I finally got our onbar backups hauling to the tune of ~90 meg per second. Restores are still lame, lagging around 10 meg per second if we …
Help with debugging Queries
Hello all, I am having an SPL that on occassion (once every other day) take 10 to 20 min to complete at seemingly random times. I am wondering if there is any way I can see what kind of locks exist in the db for a particular table--even better is there a history kept on the type…
ARCHIVE ERROR: init_archive()/alloc_sb_preimage()
Hi All, IDS 11.50.FC4 Redhat Linux 2.6.9-42.ELsmp #1 SMP x86_64 NetBackup-RedHat2.6 6.5.4 We use onbar with NetBackup (storage manager). Unfortunately, media server ran out of disk space and onbar Level 0 archive had been aborted with the following error in OnLine message log. S…
Freeing up extents in a chunk
I have an IDS 11 instance on an AIX 5.3 platform. IBM Informix Dynamic Server Version 11.10.FC2 chunk/dbs size free pathname 1 1 24000 18821 /ids/rootdbs1 2 2 65286 1233 /ids/plogdbs1 3 3 163590 38537 /ids/ll…
System Table SYSCONSTRAINTS
IDS 11.50.FC5 AIX 5.3 (4K Page Size) I am trying to interpret the sysconstraints table in order to write a routine that will, in effect, build an "ALTER TABLE xxx DROP CONSTRAINT yy" line for every primary and foreign key constraint defined within a database. Using the informati…
Help!!! syntax error
Hi everybody, Im trying to create a simple store procedure but I get an error when I define the variables. Code: CREATE PROCEDURE scope() DEFINE x,y,z INT; LET x = 5; LET y = 10; LET z = x + y; --z is 15 BEGIN DEFINE x, q INT; DEFINE z CHAR(5); LET x = 100; LET q …
RE: Index creation progress
> Varchar 254? There's no polite way to say this, so I'll just come > straight out with it: > > Are you fucking mad? > > -- > Cheers, > Obnoxio The Clown > No, He asked first. The second question you should have asked is why is the integer the *third* column and not the first? (…
Re: Transaction log when populating a raw table with rowids?
If the allocations were spread from the first logical log used during the 'transaction' to the log comprising the LTXHWM percentage of the logs, it would indeed trigger a long transaction. You have to break up the many insertions into multiple smaller transactions as dbload does…
Index creation progress
Hi all, How could I determine how much time it would take to create this index? Table has row = 128 million records This one Index is on 3 columns ( col1 char(20), col2 varchar(254) , col3 integer) Please let me know. Thanks. Regards, Jose…
Tables in a dbspace : how to find
Hi, How can I find the list of tables that are residing in a particular dbspace so that if the dbspace becomes full I can identify and choose only those tables that can be purged (ie, not any application critical config/master table). Informix V7.31 ud8/ Sun 5.7 Thanks in adva…
Transaction log when populating a raw table with rowids?
Hi, everybody. I got an 'aborting long transaction' when copying a 64GB non fragmented table (600 million records) to a RAW table fragmented by round-robin over three dbspaces, with rowids. I used a "insert into table1 select * from table2" statement. I would like to know the rea…
Problem with ontape -s -L 0
We are using IDS on RH Linux. We take the backups with the following command on the Hard drive itself. $ ontape -s -L 0 recently we are getting the following message. after 90% message displayed is Tape is full ....... insert another tape. kindly help us. Thanks.…
Re: Silly question about IIUG release of IDS...
Its an as-is offering i.e., no official Technical Support with the following restrictions: - 1 CPUVP - 1 GB max shared memory - 8 GB of database server storage - 20 concurrent sessions - Allowed use: test purposes only Hope it helps. Sundar Art Kagel <art.kagel@gmail.com> Sent …
Long Transaction Despite DYNAMIC_LOGS = 2
IDS 11.50.FC5 AIX 5.3 (4K Page Size) The following $ONCONFIG parameters were established: LTXHWM 70 # Long Transaction Low Water Mark LTXEHWM 80 # Long Transaction High Water Mark LOGFILES 100 # Number of logical log files LOGSIZE 33000 # Logical log size (Kbytes) DYNAMIC_LOG…
locale in Spanish
Good morning. We have a problem with the locale when we use the order by in Spanish. We are running IDS 11.50.UC1 on RedHat Linux 4 and we are using DB_LOCALE=es_es.cp1252@rae <mailto:DB_LOCALE=es_es.cp1252@rae> . If we create a table as this create table javi (apellido1 nchar…
Re: Silly question about IIUG release of IDS...
Gumby, AFAIK, the IIUG release includes all enterprise and optional features. There are limits on the number of CPU VPS (one?), concurrent users (2...4? don't remember), and shared memory (4GB I believe). There is no time-bomb and no other limitations. Art Art S. Kagel Oninit…
Silly question about IIUG release of IDS...
Ok, So its *free* (with some restrictions), what are the limits? Is there a hard count on the number of physical cpus (cores) or a soft count? (Soft count meaning that you can only create x number of virtual cpus regardless of hardware cores?) What 'enterprise' features are not…
wholesale cheap nike air jordan shoes, Nike Jordan Shoes,Nike dunks,Nike Max,air force one,Nike shox
vipshoeshop Co.,Ltd(www.vipshoeshop.com) wholesale nike jordan sneakers big cheap air jordan sneakers for sale.discount china nike dunk sb shoes,nike exclusive jordan sneakers,custom nike air force one sneakers,nike dunk cheap,nike jordan sneakers wholesale,discount supra shoes w…
Cheap authentic nike dunks, wholesale Air Jordans, Cheap Kicks, Cheap Air Force 1 sheos,New Air force ones
vipshoeshop Co.,Ltd(www.vipshoeshop.com) wholesale nike jordan sneakers big cheap air jordan sneakers for sale.discount china nike dunk sb shoes,nike exclusive jordan sneakers,custom nike air force one sneakers,nike dunk cheap,nike jordan sneakers wholesale,discount supra shoes w…
Re: Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
Just out of curiousity, why are you using floats and not the DECIMAL data types? Not that it matters, but when you say 402 bytes wide is that your calculation or what the engine tells you the width is? The reason I ask is that its an 'odd' number to have as an actual width. I wa…
roblem with stored procedure after migration
Hello, After the migration (dbimport) from Informix 7.31 11.5 we have trouble with stored procedures. Every time we starts the stored procedure with our application the procedure crash with error code 674 Routine (pi_stellen) can not be resolved!!! The fault is that, every pro…
Re: How to secure ODBC connection
On Nov 20, 2:57 pm, LIGHT SCANS <light_sc...@yahoo.com> wrote: > Sorry. You cannot encrypt ODBC. For internal systems you can > restrict access to your company's internal network or use your > company's network hardware to do encryption. For both internal and > external (i.e. …
Just FYI...
http://www.theregister.co.uk/2009/11/30/ibm_guardium/ :-P -G _________________________________________________________________ Windows 7: I wanted simpler, now it's simpler. I'm a rock star. http://www.microsoft.com/Windows/windows-7/default.aspx?h=myidea?ocid=PID24727::T:WLM…
Migration from 9.2 to 11.5 and using 4js
We are wotrking by engine ver 9.2 and using 4js ver 3.2 as interface what is needed when we migrate to IDs 11.5 in application -- it is 4gl code application . Are we going to change in the code or we can recompile in the new enviorment ? Or we have to mobve to another 4'js versi…
Determining non-default IDS instal location
Hello, What's the best way to find where IDS is installed on a non-windows system if IDS isn't installed in the default install location? Short of grepping the system for oninit, is there any means of figuring out where Informix is installed? Thanks, Emile. -----------/…
How to Insert a CR-LF in a Varchar column
Hello Forum How to insert a CR-LF pair of characters in a varchar column? Regards Sorry for my bad english Gustavo Echenique…
Product Tracking System Defect installed
Hi, I want to know if a particular PTS defect has been installed on the version of Informix I am running. How would I go about finding that information?…
error 201 when using functional index
Good afternoon, we are having a rare problem when we are using a functional index. There is a 4GL which gives error 201 when there is create a functional index. We are using IDS 10.FC9 on AIX 5.3 and 4GL 7.32 The 4GL application get broken if this functional index is created: …
RSS Appears to stall ?
Here's an odd one... We have 4 servers, all Solaris Sparc 64bit --- 2 in site A, 2 in site B Site A contains a Standalone Server S1 and RSS node S2 Site B contains RSS nodes S3 and S4 S2 and S4 stay nicely in sync with S1 ; S3 RSS applies seem to 'stall' --- the drift varies …
RSS Appears to stall ?
Here's an odd one... We have 4 servers, all Solaris Sparc 64bit --- 2 in site A, 2 in site B Site A contains a Standalone Server S1 and RSS node S2 Site B contains RSS nodes S3 and S4 S2 and S4 stay nicely in sync with S1 ; S3 RSS applies seem to 'stall' --- the drift v…
audit log
I'm runing a IDS 9.40 on a HP-ux 11i platform, is there a logging that can be turned on so I can track which user has connected to the server and accessed what table? Thanks! Chushia…
Found a possible bug in IDS 11.x... and a nasty one at that... has anyone suffered this?
Hello to all! I think I've found a nasty bug in IDS 11.xx on Solaris (SunOS 5.10) (yes I got the same results in both 11.10.FC3 and 11.50.FC3)... here are the details: I got a table 402 bytes wide, 78 columns all but 1 are either integer or float/decimal, with 13.1 million recor…
Missing data
I would like to know if someone ever met such a strange behavior: I recently transferred all the data of my 9.40 production instance to a newly prepared 9.40 instance. The goal was to reduce the number of extents that was above 200 for the biggest tables. We used scripts to in…
Fatal error in server row processing - SQL error -
IDS 11.50.FC5 AIX 5.3 (4k Page Size) We did a HPL unload from a table using the schema below: create table "ifxrept".rptrepositoryfile ( i_reportfile_id serial not null , i_repository_id integer, i_filetype_id integer, b_file_byte byte in reportsblob, c_process_user char(8…
RE: Error building 'sysmaster' database
Was there a fix for this issue? We are running into this on a new 11.5 FC5 Windows 64bit 2003 server. John A. Chauvin Sr. Technical Consultant MEDIWARE INFORMATION SYSTEMS Office: (913) 307-1029 Mobile: (913) 489-1054 Fax: (913) 307-1111 John.Chauvin@mediware.com Customer Sati…
JDBCProxy "No database connection" on 'SELECT *'?
Hello, We've kind of hit a wall again with the IfxJDBCProxy around here. Last week, our tests worked find (or at least seemed to), and all of a sudden we have problems with any 'SELECT * FROM table' we try on the damned thing. At the same time, the tomcat (5.5) log throws: """ …
(-9791): ERROR: Routine execution trap -- procname
We have migrated IDS Version 11.50.FC3W1 to IDS Version 11.50.FC5X1 . After version migration we got errors frequently (-9791): ERROR: Routine execution trap -- procname=<procname> procid=1924 reason: mem . We have recreated all procedures and run update statistics too but issue…
IDS 11 Compression question
We do large scale loads and unloads of tables - i.e. unload Table A on Instance A and load all the data into Table B on Instance B. When peforming an unload from a compressed table the data is in compressed format right? So a subsequent load using that data would need to be load…
Where do dynamic logs get created? Speculation on DYNAMIC_LOGS parameter
This is something I may have missed trying to read all that now doc in a short time. Question: When you set your server to dynamically create logs (rather than risking having them fill), in which dbspace do they get created? I don't recall seeing any control over where the lo…
data comparison between two IDS 9.4 servers?
Hi, I have a banking application porting from non mid-ware to Tuxedo based. In this regard, we changed the communication protocol and some of the public function in order to adapt to Tuxedo based programming. We would like to test the application porting through transactions as…
I need some expertise
Two quick questions (using HP 11.23 and Informix 11.5.FC3) we are trying to improve the speed of inserts into a table. If we split it into two dbspaces, would it be better to distribute the data using round robin or mod2 of a date time field? I was favoring the mod2 strategy to…
Simple question about log
Hi! I have this record in log file. 15:29:32 Maximum server connections 132 15:29:32 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 50241, Llog used 32703 15:29:39 Explain file for session 15085 : /root/sqexplain.out 15:30:17 Explain file fo…
SUBSCRIPT of a CHAR column gives error -201
We are using Informix subscript, COL[:1,:2], in ESQL/C program to get the substring of data. This works fine with TEXT datatype but it gives error -201 (Syntax error) when used for a CHAR column, It seems bind variables (COL[:1,:2]) are causing the error as it might not be suppo…
HA (HDR) Replication Question
IDS 11.50.FC5 AIX 5.3 (4K Page Size) I am trying to determine how replication will work under this scenerio: Server A (my future primary) has multiple databases which contains tables which are actually located on other servers and are accessed through the use of synonyms. Inser…
Restricting Connection to Informixservers
Because of enhanced network security requirments, I have an informixserver for which I've configured a dbserveralias running onsocssl for users of developed applications which require access to the database, but strictly through the developed application. I'd like to restrict th…
Re: is possible multiple instances with the same dbspace?
EIther interpretation works. Guess it's up to the OP which of us he thinks 'got it'. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oni…
Re: is possible multiple instances with the same dbspace?
Art Kagel wrote: > If you are running IDS 11.50 you can set up Shared Disk Secondary > Servers (SDSS) using the optional MACH11 feature available since 11.10. > Under IDS 11.50 these servers can all be writable (they were read-only > under 11.10). As long as your IO subsystems c…
is possible multiple instances with the same dbspace?
Hello, I have 5 different servers replicating in other server. I would like to have only this root server and other instances running together and sharing the root dbspace. I can run different instances with differents dbspaces, but i would like not to duplicate data. Is it p…
MACH 11 questions
Hi, Greatly appreciated if someone can be of assistance in a couple of questions I was recently asked on MACH 11 running IDS 11.50. 1) is it possible to have an SDS node against an HDR or RSS node? The reason this is being requested is to have a physical DR site consisting of a…
2010 IIUG Informix Conference Update - Registration is open
2010 IIUG Informix Conference Update April 25-28, 2010 REGISTRATION IS OPEN! Many people ask why the IIUG conference is in Overland Park, KS (just outside of Kansas City). Although there are several good reasons, one of the most important is its close proximity to the IBM Infor…
The fundamental problem with Open Source
http://www.devilskitchen.me.uk/2009/11/fundamental-problem-with-open-source.html -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect…
How to secure ODBC connection
Hi, how can i implement secure (encripted) odbc connection from windows clients to informix dynamic servers 11.5 ? I read something about client supports SSL but no idea how to implement or use it. The big problem is some sniffer catching odbc users and passwords, and of course…
OAT Access Deined (policy_denied)
I am again trying to get OAT working on my laptops. Since I am a consultant on permament assignment to Krogers, I have two laptops. One from Kroger, one from CSC. Both are running Windows XP professional Service Pack 2. I have installed Client-SDK 3.50 on both and can get Ilogin…
Select user table privileges
Could you tell me the statement to do the following: Select all tables and privileges that a user has…
a brand new query tool is out on beta, we need feedback, so you get a free copy
We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the above web page, but basically, its a very ambitious project to create what we call 'the query tool to end all query tools': every…
HA (HDR) Replication and Synonym'd Databases
IDS 11.50.FC5 AIX 5.3 My client is looking to go to HA (HDR) Replication consisting of one primary and one secondary. However, I have now learned, within the current server, there are multiple databases consisting of nothing but synonyms referencing tables physically located on…
Ontape Backup Problem
I am getting following error message. Archive Failed - ISAM error: cannot allocate memory. The entry in online.log file. 03:17:43 Checkpoint loguniq 606145, logpos 0x232018, timestamp: -1361032356 03:17:43 Maximum server connections 505 03:17:43 shmat: [ENOMEM][12]: out of av…
Compression and Smart Blobs
IDS 11.50.FC5 AIX 5.3 (4K Page Size) Smart blobs here default to 4k dbspaces (not allowed to specify a size when creating the smart blob space). From Admin Guide, page 10-48: Dynamic Server can compress any combination of data types, because it treats all data to be compressed…
Problemas con los acentos
Buenos Días. Tengo un problema con el IDS 11.50. Al sacar los listados alfabeticos de la B.D. salen mal ordenados,las palabras acentuadas siempre salen en último lugar. Por ejemplo Sánchez despues de Santos. La entrada de datos se hace a través de una aplicación Java. Sabeis si…
informix query header
Hi Is there a way in informix SQL where i can print the header (column names) in my report output. just like oracle has set header on or off. i know it is not there in ids7.3 or 9.4. but after that has informix introduced any solution for this? something like unload to filena…
Re: {Spam?} RE: {Spam?} RE: Something all DBAs should see!
Ian Michael Gumby wrote: > > > > From: obnoxio@serendipita.com > > > > This will, I predict, bite them severely in the arse, if it hasn't > > > > already. But you'll never hear about it. It would fuck their IPO or > > > > share price. > > > > > > > LOL. > > > > > > Spoken…
RE: {Spam?} RE: Something all DBAs should see!
> Date: Tue, 17 Nov 2009 18:47:33 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Re: {Spam?} RE: Something all DBAs should see! > > Ian Michael Gumby wrote: > > > > > From: obnoxio@serendipita.com > > > > > > Ian Michael Gumby wrote: > > > > > >…
Performance of CPU/Core.
Redhat Linux 4 running on Sun 4600 Servers, IDS 11.50.FC5 (6) when GA. We are currently using 8-Dual Core, 2.5 GHz AMD Opteron 8218. We are planning to purchase two new servers, but the only option is 4- Quad Core, 2.9Ghz AMD Opteron 8389 Just wondering if anyone has experience…
RE: id10t error
I should follow this up. I was under the impression that my INFORMIXDIR had been exported because my .bashrc file does so and I could in fact echo INFORMIXDIR, and run dbaccess (which could only be found if the PATH (which includes INFORMIXDIR/bin) were ok). Granted I am "su -"…
Re: {Spam?} RE: Something all DBAs should see!
Ian Michael Gumby wrote: > > > From: obnoxio@serendipita.com > > > > Ian Michael Gumby wrote: > > > > http://www.cloudera.com/blog/2009/11/11/hadoop-world-rethinking-the-data-warehouse-with-hadoop-and-hive-from-ashish-thusoo/ > > > > > > You may not believe in Hadoop/HBase,…
RE: Something all DBAs should see!
> Date: Tue, 17 Nov 2009 16:07:15 +0000 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: Re: Something all DBAs should see! > > Ian Michael Gumby wrote: > > http://www.cloudera.com/blog/2009/11/11/hadoop-world-rethinking-the-data-warehouse-with-hadoop-and-h…
Doubt in Update statistics, resolution and confide
Hi all, We are having some performance issues running queries in a huge table, we did some tests. When we run update statistics with distributions the performance is worse than without distribution using the default parameters of resolution and confidence. We need distribution f…
Re: Something all DBAs should see!
Ian Michael Gumby wrote: > http://www.cloudera.com/blog/2009/11/11/hadoop-world-rethinking-the-data-warehouse-with-hadoop-and-hive-from-ashish-thusoo/ > > You may not believe in Hadoop/HBase, but here's a good presentation on > building a world class large scale data warehouse. …
OAT Error
OAT version 2.26 on Windows XP SP3 IDS 11.50.FC5DE…
Something all DBAs should see!
http://www.cloudera.com/blog/2009/11/11/hadoop-world-rethinking-the-data-warehouse-with-hadoop-and-hive-from-ashish-thusoo/ You may not believe in Hadoop/HBase, but here's a good presentation on building a world class large scale data warehouse. This is why IBM should look at p…
id10t error
Creating infos file ""...FAILED Happened on my sandbox, I'd been ignoring it because IDS started and worked just fine - just that onstat/onmode commands didn't work. Finally decided to fix it, googled all over the place - there's this one guy with my name who suggests exporting…
Re: Interesting article for developers ...
Obnoxio The Clown wrote: > ... and for those of us who have to tidy up their mess: > http://bit.ly/4apP8o > > Remember this article the next time a project kicks off! And another one: http://www.dadhacker.com/blog/?p=1132 -- Cheers, Obnoxio The Clown http://obotheclown.blogs…
Re: RE: Informix Warehouse Installation Issue
Regards, Mr. Kasi: I´m installing IWF client to acess a linux 64 machine with IDS 11.50.FC5W3 I´m having exactly the same error, and I´m totally lost until now. Did you solve your issue??? If so, could you post it here for all??? Because I think several users will have the sam…
When table was dropped?
I want to know the time when a table was dropped. This will help to restore point of time. online.log file doesn't store table level information. Where can i look for this information? Thanks DJ...…
Interesting article for developers ...
... and for those of us who have to tidy up their mess: http://bit.ly/4apP8o Remember this article the next time a project kicks off! -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been …
connecting IDS on different machines
Hi all, I want to access different databases on different machines. Is this possible? I read long time ago something about this but I can't remember me. Damm!! I thought it was something about mentionning both machines in the sqlhost file... Thanks for any help!! I have. IDS 9…