Threads from 1998
Browse by month: Dec
Tracing sql statements
I've used the "onstat -g sql xxx' statement to view the last sql statement issued by a user. Does anyone have a suggestion or know of a way to run a complete trace on a specific user? -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.co…
RE: more then 80 columms output
If you do not want to do an unload, you can also do this: echo "select {columns} from {table}" | dbaccess {database} - Tim Sellars The Home Depot From: Kate Tomchik on 12/31/98 10:49 AM To: Paul McMahon/IS/SSC/THD, Tad Possenti/IS/SSC/THD, Frank Parrish/IS/SSC/THD, Ti…
Re: dbspace full
JianJun UPDATE STATISTICS will not release unused pages, if that is what you are asking. You would need to either drop/recreate the table(s), or use ALTER INDEX indexname TO CLUSTER to free unused pages. HTH Sujit ______________________________ R…
IUS memory corruption issues
stats: ====== INFORMIX-Universal Server Version 9.14.UC4 Solaris 2.5.1 web.3.32.UC1 This week I was designing/writing our own local flavor of memory checking routines wrapped around mi_alloc and mi_free to be used in C UDRs written here. To test it I would purposely write pass …
RE: more then 80 columms output
On UNIX, you can do the following: unload to '/dev/tty' delimiter ' ' select * from table -----Original Message----- From: guianla@rs2.ru [mailto:guianla@rs2.ru] Sent: Wednesday, December 30, 1998 3:22 PM To: "informix-list" <informix-list@iiug.org> at -FABRIK/Internet Subject…
update statistics
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BE34C1.ECD08A98 Content-Type: text/plain Can I run 'update statistics' against a database while users are ac…
Re: Problem connecting clients to SE 7.1 on SCO
Thanks for your help Shannon, I was not able to reach you through your e-mail, so I am re-posting to the list, hope you see it. Is it possible for you to tell me what version of Informix-connect and what ODBC driver you are using ? That could be helpful to me, as I am not sure…
dbspace full
Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimp…
what's Baan driver?
Hi every body, what's Baan driver on OnLine engine. can we use it with OnLine 5.08 UD1? thanks in advance, Babak-IRAN (dba) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Informix on NT
Does Informix tech. support ask every user of Informix products on NT to run ps -ef or just us. Does anyone know if Informix has any plans to train thier tech support staff on thier NT products. Hind site is 20/20. Shannon…
Review for DDVB(3.0 or 3.5)
Hi, What has been your experience with DDVB(3.0 or 3.5) with VB5.0 or VB6.0? Any views will be appreciated. Thanks in advance. Ankur Wadehra awadehra@hotmail.com *** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ***…
Error 534 & onlinefiles
While looking for an answer to why I'm getting an error 534, "Can't create explain file", I saw that it was possibly caused by informix file permissions (& maybe the permission of the oninit file in particular), and that all the files and their permissions are listed in the 'onli…
Perform Screens
Any ideas or suggestions on conversion of some old PERFORM screens. Old app was on SCO with character mode screens. Clients insist on Windows desktops / indifferent on backend. Any ideas????…
Question about onbar & omniback
Environment: IDS 730UC3 HP/UX 11.0 Omniback (should be current but not sure of specific version) The Informix backups for the dbspaces and logical logs are setup & configured. Things run fine from the omniback gui component. (I know we need to use Bar_Debug_log an…
esql/c on remote machine
hi all: I am running solaris 2.6 with online 7.23 as the server. Client is solaris 2.6 with client sdk installed. I did a script using perl DBD stuff on the client machine to access my sever, everything is fine. Now I am trying a esql/c program as following: #include <stdio.…
Re: Paging Results Sets (Next 10 records)
Michael E. Lucas wrote: > > Hi Gang, > > I'm looking for a way to page the results of a SELECT statement into > many pages. I have a database will x number of records and what to only > return 10 records at a time. I'm trying to do the web search engine > thing where I can give…
Re: more then 80 columms output
> I know none of those are as easy as just having DBAccess look at > the stty settings, but since when has Informix been known for > doing things in a straightforward manner? > I would be happy if dbaccess could just do an "unload" to the standard output. Just something like: "u…
Re: Use memory better
Brian One way to do that is to increase the BUFFERS to be 20% of physical memory for OLTP systems. For pure OLTP I believe you could probably go as high as 50%. However before doing that look at the %rcache and %wcache in onstat -p. If these rates are al…
Use memory better
I have the feeling that we aren't using all the memory that we could be in our system (actually, I KNOW we aren't using all our memory), and would like to possibly speed up our ONLINE DS 7.2 system by maybe using memory more, if it might help. What stats should I be looking at? …
Where is Artinsoft?
I read about a company called Artinsoft at the beginning of the year. They had a product/service to convert Informix 4GL to Java. Are they still around? I get no response from their web server (http://www.artinsoft.com). Any info would be appreciated. -- Todd Breiholz Sr Techn…
Re: week no. for a date
Roland Wintgen wrote: > > >Octav Chiriac schrieb: >> >> Girish Kagrana wrote: >> >How Can I find WEEK NO. for a given date. >> > >> >For eg. >> > >> >Date is in MM/DD/YY format >> > >> >Date WEEK NO. for the YEAR >> >----- ------------ >> >01/04/98 - 1 >> >01/05/98 …
Re: Connecting Win95/WinNT clients to Informix database
Christian Allaire wrote: >I need to connect windows95 applications (using ODBC) to a Informix-SE >v7.10 database server running on SCO. > >I have downloaded from the Intraware site the Client SDK wich contains >Informix-connect and the Intersolv 3.10 32 bit ODBC driver. >The inst…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
slow informix queries in a large database? try this
If you have been experiencing slow sql queries after loading large amounts of data into your informix database(over 100 thousand rows per table) try this sql statement to once again speed up the query as if there are 10 rows in the table: UPDATE statistics; My development effor…
Re: more then 80 columms output
> > When running an sql as : dbaccess dbname mysql.sql > out > > The rows becomes columns, if the text is more then 80 columns wide. ( > > see below) How do I change this limit. I have tried to play with the > > stty ROWS in my env. > There is no way to change this limit! >…
RE: Referential Constraint
Mr/Ms m00n321 wrote: > What part is a bug? Nulls should not be present in referential > columns. By > definition, the data must be present in the controlling tables primary > index > which must be unique and, unless RI is a hobby, won't contain nulls. > > > Well, that was a gr…
unload command
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BE33FC.4E3C7434 Content-Type: text/plain Is there any way to include the field names as the first row of output …
unload command
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BE33FC.4E3A11DA Content-Type: text/plain Is there any way to include the field names as the first row of output …
Connecting Win95/WinNT clients to Informix database
I need to connect windows95 applications (using ODBC) to a Informix-SE v7.10 database server running on SCO. I have downloaded from the Intraware site the Client SDK wich contains Informix-connect and the Intersolv 3.10 32 bit ODBC driver. The installation went fine. The proble…
Re: i4gl talk to database over network
En Wookie va escriure el dia 28 Dec 98, a les 14:54: > > Hi, > > I want to put together a database system where a 4GL program running on an > SCO UNIX machine can talk "over the network" to an Informix database which > is running on an NT server. > > Can anyone tell me if every…
SPL call from ODBC returning more than one value
Hi folks, is there any possibility to call a SPL via ODBC if the Procedure returns more than one value. If it returns just one, it can be included into a "SELECT <proc> FROM systable where tabid = 1". How can I get around this problem? Any ideas? Thanks for your answers. Bye …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
HP-UX 10.20/IDS7.30UC crashes machine
Hello, we have some problems with the following configuration: HP-UX 10.20 IDS7.30UC cooked files on a RAID-LEVEL-5 We initialized (oninit -i) the online system and added some dbspaces. But now we have a big problem after startup (oninit). After typing oninit (between 0 se…
Re: week no. for a date
Girish Kagrana wrote: >How Can I find WEEK NO. for a given date. > >For eg. > >Date is in MM/DD/YY format > >Date WEEK NO. for the YEAR >----- ------------ >01/04/98 - 1 >01/05/98 - 2 >12/29/98 - 53 > >TIA > >Girish > > > DEFINE d DATE; DEFINE w SMALLINT; LET w …
Re: Product installation order
ackerbau@us.ibm.com wrote: > Assuming TEN (tools, engine, network), development products first, or > runtime? For the engine, it doesn't really matter. For the frontend tools, you must install runtime before development versions, otherwise the "crippled" runtime binaries will o…
Re: "On-Demand?" Replication
This is what Enterprise Replication supports. Shannon Sellers wrote: > I'll try to keep this short. > > We have a system that consists of 18 remote database servers and 1 > headquarters server. All modifications to the "Vehicle" file are replicated > to the headquarters server…
Re: INPUT ARRAY problem
options insert key control-a, delete key control-a Because control-a is an editting command 4gl interprets it as an editing command. The sequence never executes the insert or delete function beause it is always interpreted as an editing command. Pa366 section 21 o…
Re: SE; Linux; ODBC
Why not use Informix Dynamic Server Linux Edition (that just published on Dec 24,98) and JDBC driver. During software deployment, you dont need anything on the client side other than browser.I am currently doing a project using IDS/JDBC. david trisna (dtt@ifgf.org) in Houston Ro…
Re: VB 5 and Blobs - Very Slow
We had similar problems with Informix-DataDirector for VB, but we resolved by configuring correctly the BLOBSPACE, we had to increase the page size for the blobspace, sot that our blob data could fit in one single page, thus informix only needed to perform one page-read, increasi…
Re: SELECT BETWEEN DIFFERENT SERVERS
In article <75ss67$scs$1@ntd.co.ru>, dimam@olma.co.ru (Makunin Dmitry) wrote: > Hi > I want make this query : > SELECT * FROM appdb@mfcinf:t_1 ; > But it do'nt work . Well, that depends.. If the server you acre conected to has a different logging mode (yes, no, ANSI) than …
Re: Transactions using the C/C++ API?
Yes. If you use ESQL/C with INET. Or you can use CLI. Christoph Borowski wrote in message <3687876A.271BF2@uni-paderborn.de>... >Hi there, > >is it possible to use transactions while accessing the Informix database >from a C/C++ program? > >ciao Christoph…
Informix IDS on Informix
Informix has released IDS Linix Suite and is available for download (or in CD) from either RedHat or Intranetware. This is a try and buy version with 30 days eval period. I am not sure what happens after 30 days. Anyone?? Enjoy..... Happy New Year..... Idiot…
Data Modeling Tools (EVALUATION INFORMATION REQUEST)
Does anybody know where I can find a comparison about Data Modeling Tools. I am looking to standardize on one tool for my team, but would like to complement our own research with industry feedback. Any info would be greatly appreciated. Please reply to me directly at joel.reyes@…
RE: week no. for a date
The following expression treats Sunday as the beginning of the week. TRUNC((dates+6-MDY(1,1,YEAR(dates))-WEEKDAY(dates))/7,0)+1 You can adjust it accordingly if you want Monday to be the first day of the week. -----Original Message----- From: Girish Kagrana [mailto:girishk@in…
Re: Loading 4gl
In article <768qkk$pmj$1@news.xmission.com>, PCrompton@CLERK-OF-COURT.co.lee.fl.us (Paul Crompton) wrote: > > For a short week I am having lots of troubles loading 4gl. We are > currently > running Informix > online version 7.30.UC5 on an HP9000 with HP-UX version 10.20. > > My …
Re: Version IDS 7.xx for AIX 4.2.1
Doris: I have 7.3 UC3 running on AIX 4.2.1 I did not find any problem, it works great. HTH Tino Willaert Doris wrote: > > We recently ordered IDS version 7.xx for AIX version 4.2.1 and we received > IDS 7.24.UD6-1. Is this the best latest version for our platform ? What > abo…
Referential Constraint
Hi, I've come across a problem in the Informix implementation of "referential integrity constraint". According to Informix's SQL manual, foreign key columns in a referencing table are allowed to have null (and duplicate) values (whereas "referenced" columns should be non-null a…
Re: "On-Demand?" Replication
Shannon: You might want to visit http://www.peerdirect.com. Our company specializes in database replication and synchronization. We have developed a replication system for Informix that offers the kind of functionality you have described in your posting. Any questions, plea…
week no. for a date
How Can I find WEEK NO. for a given date. For eg. Date is in MM/DD/YY format Date WEEK NO. for the YEAR ----- ------------ 01/04/98 - 1 01/05/98 - 2 12/29/98 - 53 TIA Girish…
RE: Version IDS 7.xx for AIX 4.2.1
Doris, We are running IDS 7.30.UC3X3 on AIX 4.2.1. This version works great for us. We have set the following environment variables in /etc/environment to circumvent known problems. 1. NO_SUBQF=1 2. LIGHT_SCANS=off The NO_SUBQF variable is a workaround for defect 95376 which is …
How can i un-scriber this maillist?
________________________________________________ ��ӭ��ʹ�ù����Ӵ���ѵ�������http://www.163.net…
Adding DBSpaces to Workgroupserver
Yall's I'm running a SunSolaris Server Version 2.6 with the Informix Workgroupserver. Actually I have a "rootdbs" on raw-device ln -s /dev/rdsk/c0t1d0s6 /export/home/informix/dbspace/rootdbs and I want to add a dbspace for performanceoptimizing with ln -s /dev/rdsk/c0t1d0s5 /…
Re: SELECT...FOR UPDATE
I doubt whether you would ever be able to use a FOR UPDATE clause over ODBC because it cannot be prepared, at least not by an Informix engine. That clause is for 4GL only. Also you cannot use FOR UPDATE if you have an ORDER/ GROUP BY, expressions, aggregates or a join in the que…
more then 80 columms output
Hi When running an sql as : dbaccess dbname mysql.sql > out The rows becomes columns, if the text is more then 80 columns wide. ( see below) How do I change this limit. I have tried to play with the stty ROWS in my env. Thanks Isaac Loven dt 11/10/1998 omc 1 mm 1 …
Re: Problem connecting to SE 7.1 on SCO
Is in Setnet32 the "sesoctcp" protocol ? Try it. Kind Regards, Octav Christian Allaire wrote: >Hi, > >I want to connect windows applications (using ODBC) to a Informix-SE >v7.10 >database server running on a SCO/Intel platform. > >The problem is: > >The communication protocol …
Product installation order
You have to look at the individual versions of each product and install them in order from least to greatest number. EX. 7.20 4gl and 7.30 server, install the 4gl first. The esqlc should match the server, and isql should match the 4gl. Kate To: informix-list @ iiug.org cc:…
RE: How to get difference in two dates. Please HELP
Have you tried, Date1 - Date2 UNITS MONTHS? > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of John H. Frantz > Sent: Tuesday, December 29, 1998 9:45 AM > To: informix-list@iiug.org > Subject: Re: How to get diff…
RE: Product installation order
Yes, but what if I have more runtime licenses than development, and intend for this to be a multi-user system? -mka Michael Ackerbauer SP System Test Soumya Das <sdas@informix.com> on 12/29/98 10:06:20 AM If you are installing development version of 4gl products, you need not …
Informix 7.30/ODBC 3.11/ColdFusion Connexion problem
Hi, Could somebody help me with following problem : ENVIRONNMENT 2 NT 4.0 servers with servicepack 3.0 rdc008 is the primary DNS rdc009 is a free standing database (Informix IDS workgroup 7.30) server but in a domain. Netscape Navigator Netscape enterprise server 3.5.1 Coldfus…
Version IDS 7.xx for AIX 4.2.1
We recently ordered IDS version 7.xx for AIX version 4.2.1 and we received IDS 7.24.UD6-1. Is this the best latest version for our platform ? What about version 7.3 ? Could you give me your opinion ? TIA Doris Willaert Suzuki Belgium sdwilla@suzuki.be…
exporting db w/pseudo tables
Hey folks, first time posting. Thanks for existing. I used Informix 7.1 extensively two years ago and it has come back to haunt me in my new job. Using your excellent search engine on the newsgroup, I answered my "unable to attach to shared memory" by adding the appropriate /e…
Product installation order
All -- I am setting up a 7.3 server at home with the following products: 4gl - dev and runtime rds - dev and runtime idb - dev and runtime ods 7.3 The question is, in what order is it recommended I install all the products? Assuming TEN (tools, engine, network), development p…
Re: How to get difference in two dates. Please HELP
Try: DEFINE numMonths INTERVAL MONTH(9) TO MONTH; ^^^ Imran Hussain wrote: > > Hi, > I need to subtract two dates from each other and get the difference in > MONTHS not DAYS. So lets say I have the following: > > dt1 = '12/1/1998' > dt2 = '7/1…
Problem connecting to SE 7.1 on SCO
Hi, I want to connect windows applications (using ODBC) to a Informix-SE v7.10 database server running on a SCO/Intel platform. The problem is: The communication protocol used by the DBMS on the SCO machine is "setlitcp" (That's what I have in the sqlhosts file). But the Info…
Re: Informix Stored Procedures (16-bit ODBC Driver)
In article <769egj$5j1$1@Nntp1.mcs.net>, "Jeff Smith" <jeff@mcs.com> wrote: > Is there a 16-bit Informix ODBC Driver available that supports calls to > Stored Procedures? > > The EXECUTE PROCEDURE command goes to the server just fine with the driver > I'm using. It's just that…
Re: How to get difference in two dates. Please HELP
Hi, You were absolutely close to the solution!!! Just enter the precision of the Month to Month variable by typing MONTH (4) to MONTH which provides You with four digits! Happy New Year Imran Hussain wrote: > Hi, > I need to subtract two dates from each other and get the dif…
Re: Need FREE ODBC driver for SE on Linux
Hi Try www.openlinksw.com or www.openlinksw.co.uk. They provide a free non-expiry 2 user copy of their drivers In article <7684k9$60c1@cns.compuware.com>, "compuware.com" <1@1.1> wrote: > Can anyone help? > > The only think I've seen is the CLI that is a cost item. > > -----…
Re: ODBC Problem
Hi Phillipe 1. Does this problem happen with any other application other than VS60 2. Are you using the ST drivers that rely on the Informix Connect or are using our MT drivers which are installed on both the Client & Server. If you are using the MT drivers, I believe you can c…
Re: Loading 4gl
How about: mount -r /dev/dsk/c3t2d0 /mnt ls /mnt There should be a file named like "informix4gl.cpi" or something. Try to run the cpio command using this file as your standard input. Hope it helps, Octav Paul Crompton wrote: >For a short week I am having lots of troubles loa…
Trying to use Stored Procedures with Virtual Tables using DDVB(3.5) with VB-6.0 - Please Help
I am trying to use Stored Procedures to perform update, delete and store with Virtual tables using Data Director for Visual Basic ver 3.5 and VB 6.0 as the front end. Everytime I try to set a parameter for the procedure using SetParam I get the error "Invalid parameter index '1'…
Re: C-Isam files
Hallo chris, as the other "anserer" said, you can 'connect' the isam files to INFORMIX SE database engine by creating the appropriate tables and put the cisam files instead of the original created one's below. This way you get ODBC access to the cisam originated data. Yours Kl…
Re: INFORMIX INTERNET PORTING STATUS
Hello chuck, the named website will be able to give you a hint - not more. It's as predictable as a weather forecast - often correct, sometime hopeless far away from reality ! Klaus Nonne nsi001@aol.com…
Please help with using Stored Procuedures, Virtual Tables
I am trying to use stored procedures to perform update, insert an delete using a virtual table. Everytime I try to set a parameter using SetParam I get an error "Invalide parameter index '1' for table <tablename> - SetParam failed". Where am I going wrong? *** Posted from Remar…
Informix Stored Procedures (16-bit ODBC Driver)
Is there a 16-bit Informix ODBC Driver available that supports calls to Stored Procedures? The EXECUTE PROCEDURE command goes to the server just fine with the driver I'm using. It's just that the procedure is not being executed. I'm able, however, to execute the procedure dire…
Re: Question
I'm not certain that the name of the administrator group is the problem. I've never worked with the Spanish language version of NT, though, so I could be mistaken. However, assuming that DS 7.3 is not looking for the actual group name 'Administrator' this is what you can do: …
"On-Demand?" Replication
I'll try to keep this short. We have a system that consists of 18 remote database servers and 1 headquarters server. All modifications to the "Vehicle" file are replicated to the headquarters server. As the saying goes, even "I" can get this part to work. Where I run into a p…
Re: INPUT ARRAY problem
laustop@club-internet.fr wrote in message <7601gu$jqb$1@front7.grolier.fr>... >Hello everyone, >I have a proble mwith an INPUT ARRAY to inhibate the insert key >I have write OPTIONS INSERT KEY F36, but on my keyboard when i type the END >key , this key insert a record in my ARRAY…
Re: INFORMIX INTERNET PORTING STATUS
> Today I've sent this e-mail to the Informix web-master alias. I've tried > for two hours to find an available porting on the -Informix web. Product Query in the TechInfo Center is what you're looking for.…
Informix, VB 5, Text, Blob, SLOW, Help!
We are experiencing horrendous access times with VB 5 and RDO using CLI (ODBC) and text or blob fields. Does anyone have the same problem? Better yet does anyone have a solution? I repeated this message because on the laset one I entered my wrong email dwalden@mailexcite.com t…
Re: SELECT...FOR UPDATE
the statement is : UPDATE table-name SET { column_name = expression [,...] | { (col_list) | * } = (expr_list) } [ WHERE condition ] marianat@my-dejanews.com wrote in message <768l0…
Re: How to get difference in two dates. Please HELP
Assuming you meant to write "dt3 = dt1 - dt2" . . . . Why not try the following: create procedure month_diff(d1 date, d2 date) returning decimal; return abs((d1 - d2) / 30); end procedure -mka Michael Ackerbauer SP System Test Imran Hussain wrote: >I need to subtract two d…
VB 5 and Blobs - Very Slow
We are experiencing horrendous access times with VB 5 and RDO using CLI (ODBC). Does anyone have the same problem, better yet does anyone have a solution?…
Re: SELECT...FOR UPDATE
That is correct. Both of those options are illegal with "for update". In general, both of those can require temp tables, which don't work well with "for update". Vic marianat@my-dejanews.com wrote: > I'm working with an Informix OnLine Dynamic Server 7.30, and an ODBC driver…
SELECT...FOR UPDATE
I'm working with an Informix OnLine Dynamic Server 7.30, and an ODBC driver. I need to know if it is possible to have a SQL query like this: select * from <table> order by <field> for update; According to the messages I'm getting, this is not possible: the "select...for update…
Logical Log Sizing issues
We are developing Standards for our Informix Instances. Our current discussion is how big do we make the logical logs for a specific instance. We currently us a standard of 10MB log files and keep enough logs to hold 24 hours worth of transactions. We have 7.24 and 7.30 on HPUX 1…
Re: i4gl talk to database over network
One more problem I can see here is the User Equivalence issue. How to set it up on NT ? The only way I can see is to use the netrc file on SCO to set the user name and password. Kind Regards, Octav ackerbau@us.ibm.com wrote: >Unless something drastic has changed with 4GL versi…
Re: How to get difference in two dates. Please HELP
Imran I remember that this issue has been addressed before. What you need to do is change the declaration of the numMonths like so: DECLARE numMonths INTERVAL MONTH(3) TO MONTH; to get numMonths more than 99 and less than 999. HTH Sujit __…
Re: i4gl talk to database over network
Unless something drastic has changed with 4GL version 7.x, you can't use ODBC in 4GL. What release of Informix for NT? Having not used Informix on NT much, I'm assuming A) it is at least 7.x, and B) it comes bundled with I-STAR. Ditto SCO. If you have a pre-7.x version, you'…
Re: INPUT ARRAY problem
> I have a proble mwith an INPUT ARRAY to inhibate the insert key Hello, some time ago I had the same problem. I solved it using the following trick: ...DEFINE dummy_variable SMALLINT --- ON KEY(INSERT) LET dummy_variable = dummy_variable Hope this helps, Chris…
Re: Has Informix SE on Linux a limit date of use?
Hola Juan, Informix tiene un sistema de becas que permite que dispongas de todo el software gratuitamente y sin limite de tiempo para las universidades y centros de ense�anza. Actualmente est� vigente en la Universidad Polit�cnica de Catalu�a, Ram�n Llull (La Salle), Universidad…
HowTo: buffer keystrokes while statement executes
Hi, We have a 16 bit (Borland C++) Windows client using I-Net PC. During Statement execution all Windows messages are lost. Therefore all keybord input is lost. How do I buffer those keystrokes until after the current SQL statement completes ? The hook function installed with …
US-TX-DFW ___ Informix DBA's / Developers (C, Perl, Korn Shell: a plus) ____________
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Informix DBA's / Developers Salary: $53,000 - $64,000 + full benefits package. Location: Dallas / Ft.Worth , TEXAS area ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Requirements: At least 1 year of work experience wi…
How to get difference in two dates. Please HELP
Hi, I need to subtract two dates from each other and get the difference in MONTHS not DAYS. So lets say I have the following: dt1 = '12/1/1998' dt2 = '7/15/1998' dt3 = dt1 - dt3 dt3 should be 5 How do I do that. I wrote a stored procedure to do this but it only wo…
Re: 7.30 on Solaris x86
Don't worry IDS for Solaris 2.6 works fine on Solaris 2.5.1. I have not encountered any issue and I've some customers with this architecture. Anyway, you can try it before putting on a production environment!!! V.Salvador DEISTER, S.A. (SPAIN) Micha Meier wrote: > Hi, > we wo…
INFORMIX INTERNET PORTING STATUS
Today I've sent this e-mail to the Informix web-master alias. I've tried for two hours to find an available porting on the -Informix web. Please, help all informix user comunity to force them to improve this issue. It's a shame (Informix: The database company) MAIL SENDED: It…
Question
Hello everybody! We have installed Informix IDS 7.3 on NT. Our first problem was: "Not a member of the Adminitrators group". We have an Spanish version of NT and the Administrators group is not "Adminstrators", it is "Administradores". We only could install it using Custom instal…
Re: C-Isam files
Your release must be quite old no ? Perhaps a 2.10.03k or even older. You can ask Informix for an SE engine (which works with C-Isam files) for NT (I'm not sure it really exists). If your old system is still Chris Verleye wrote: > At this moment our company uses an Iformix > d…
Re: ASF_INIT_DATA error in linux
What's your sqlhosts file look like? It is probably a problem with it. Also check the release notes for which protocols are supported on linux (I'm not sure which ones). Jacques mdevlin8648@my-dejanews.com wrote: > I downloaded online dynamic server for linux and have instal…
Re: ASF_INIT_DATA error in linux
mdevlin8648@my-dejanews.com wrote: > > I downloaded online dynamic server for linux and have installed it > but when i attempt to initialize it i get an error that reads > Initializing ASF ...oninit: Fatal error in initializing ASF with > 'ASF_INIT_DATA' flags; asfcode = '25507'.…
i4gl talk to database over network
Hi, I want to put together a database system where a 4GL program running on an SCO UNIX machine can talk "over the network" to an Informix database which is running on an NT server. Can anyone tell me if everything I need to do this comes with Informix-4GL? Do I need to run Inf…
Need FREE ODBC driver for SE on Linux
Can anyone help? The only think I've seen is the CLI that is a cost item.…
Re: JDBC - URL string settings?
Hi, are you using an applet or an application? I have the same problem with an applet, but it works fine as an application. I guess, this is a Java security problem? As far as I can see, your URL seems to be OK. If you have a solution, I would be thankfull to hear it from you. …
Transactions using the C/C++ API?
Hi there, is it possible to use transactions while accessing the Informix database from a C/C++ program? ciao Christoph…
Loading 4gl
For a short week I am having lots of troubles loading 4gl. We are currently running Informix online version 7.30.UC5 on an HP9000 with HP-UX version 10.20. My problem is that the: tar xvf /dev/dsk/c3t2d0 does not do anything. The cd light flashes and then the system prompt is r…
Re: Usermanagment for Informix on NT
Mark Stuurman <marks@xs4all.nl> schrieb in Nachricht MPG.10ea300b5b72b83f989680@news.xs4all.nl.../// >In article <914259012.886087@bach.all.de>, ks@condat.de says... >> Yes I have the same problem.. I'am developing a ISAPI Extension for >> Microsoft IIS.. and the IUSR_<computerna…
Re: Problem installing IDS 7.23TC6 on NT4 with SP4
In article <368487D6.D8CD0E2D@txdirect.net>, donh@txdirect.net (Don Hartshorn) wrote: [cutting] Not directly related to Informix but I believe relevant. I recently upgrade our NT servers to SP4, no choice really 'cos I need them to work in the year 2000. To the best of my kno…
Re: Oracle positions
In article <19981225041111.03239.00001516@ng133.aol.com>, m00n321@aol.com (M00n321) wrote: > Does this mean you want to run the slide projector? That is the > preferred Oracle platform, afterall. > Well it is the most stable platform for it Paul Watson # I don't …
Re: raw database
On 27 Dec 1998, Immanuel Litzroth wrote: Hi ! > Hi, > A question about using the raw database device under linux. I am using > the new IDS release for Linux (Thank You, Informix) and have a little > trouble in grasping the concept of "raw disk". Can I just use the > device corre…
Re: blademgr problem
������ <balbari@bflysoft.co.kr> wrote in message 766l7j$6cv$1@news.kornet.nm.kr... > > >Hi! > >I have IDS9.14.TC4-1 and Web datablade module. >My OS is NT4.0 >I installed DBServer and I tested connection to server with ilogin and >SQLEditor. >It was successful, but wblademgr.exe(…
blademgr problem
Hi! I have IDS9.14.TC4-1 and Web datablade module. My OS is NT4.0 I installed DBServer and I tested connection to server with ilogin and SQLEditor. It was successful, but wblademgr.exe(blademgr.exe) does not find server list with error message "Could not get list of servers". I…
blademgr problem
Hi! I have IDS9.14.TC4-1 and Web datablade module. My OS is NT4.0 I installed DBServer and I tested connection to server with ilogin and SQLEditor. It was successful, but wblademgr.exe(blademgr.exe) does not find server list with error message "Could not get list of servers". I…
C code in D4gl apps: How do you do it on NT? Where is fglmkrun?
Just how do you really link C code into Dynamic 4GL applications under NT4? I've installed all the main components but I don't seem to have fglmkrun anywhere. So I can't make any custom runners. Also, when I try to unzip the GNU software from the CD I just get errors. So I don't…
raw database
Hi, A question about using the raw database device under linux. I am using the new IDS release for Linux (Thank You, Informix) and have a little trouble in grasping the concept of "raw disk". Can I just use the device corresponding to a harddisk partition to get the db to use thi…
C-Isam files
At this moment our company uses an Iformix database. The software has originally been developed on a German CTM-mainframe (ITOS). Currently everything (data and software) has been transferred on a Windows NT network. We are not using a client/server environment, just file shari…
Re: Data Warehousing
Data Warehousing is a process that lets business users create adhoc/customized reports to suit their own needs. It is a new trend in IS industry. To business users such reporting facility provides information needed for decision making. Narkinsky, Pat <Pat.Narkinsky@rivhs.com> w…
Re: Informix SE LINUX Byte, Text ???
Albert Steiner ����� � ��������� <7624on$hm$1@Falco.INDISoft.at> ... >I have SE running under LINUX and it work's well, but >i can't create a Byte or Text Field, he says it is not allowed ? >is this the limitation for informix se linux ? You must read release notes! In SE this ty…
informix se and row locking via odbc ?
can anyone explain me how do to that ? Salve Albert…
Informix SE LINUX Byte, Text ???
I have SE running under LINUX and it work's well, but i can't create a Byte or Text Field, he says it is not allowed ? is this the limitation for informix se linux ? Salve Albert…
Re: Problem installing IDS 7.23TC6 on NT4 with SP4
When NT SP4 released a few weeks ago, we sacrificed one of our test servers to see what would happen if we took the plunge and installed it. We installed SP4 on a server that already had Informix 7.23 running (well) on SP3; the database never initialized after rebooting from the…
Re: Has Informix SE on Linux a limit date of use?
[Posted and mailed] Juan Riera claimed: %I have been told that the free Linux version of Informix SE that you can %download from Intraware is limited as free use to end december 98 %Is it true? No, this isn't true. Initially, the free download was set to expire at the end of D…
onion up her ass 3254
The sex gallery ! It's all FREE here ! FREE xxx memberships, passwords,pic,thumbnails,and much more ! Now featuring live hott erotic talk ! Cum by today ! WE'RE WAITING ! http://www.thesexgallery.com/ neuhdogiehxwxwpurhulhkxvfjcnwkucgnlmgbffgtfyyyxkewti…
US-VA-Annandale - Informix DBA/Developer Wanted
Subject: US-VA-Annandale - Informix DBA/Developer Wanted I apologize in advance to all who prefer not to deal with job postings but we need someone good! - Lester Tasks ----- We have a new Web enabled Data Warehouse Project getting started. We need developers to build the data …
US-CO-Denver - Informix DBA/Developer Wanted
Subject: US-CO-Denver - Informix DBA/Developer Wanted I apologize in advance to all who prefer not to deal with job postings but we need someone very good! - Lester Tasks ----- - Develop Web enabled Informix Database Financial Applications - Develop and support a Web enabled In…
INPUT ARRAY problem
Hello everyone, I have a proble mwith an INPUT ARRAY to inhibate the insert key I have write OPTIONS INSERT KEY F36, but on my keyboard when i type the END key , this key insert a record in my ARRAY. What can i do . I change the OPTIONS with INSERT KEY F64, this is the same probl…
Has Informix SE on Linux a limit date of use?
I have been told that the free Linux version of Informix SE that you can download from Intraware is limited as free use to end december 98 Is it true? I will appreciate all information concerning the seemly free use question on this edition for corporate use (we are not planning …
Re: Oracle positions
Does this mean you want to run the slide projector? That is the preferred Oracle platform, afterall.…
ASF_INIT_DATA error in linux
I downloaded online dynamic server for linux and have installed it but when i attempt to initialize it i get an error that reads Initializing ASF ...oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '25507'. what is this and where fo i look to dorrect …
Re: Informix SE on RedHat 5.2
Using recycled bits, Jim DeLude blurted out: %After following the HOWTO at %http://www.iiug.org/techinfo/linux/Howto_SE_ESQLC.html. I'm receiving %ISAM locking errors when I try to do something as simple as create a new %database. I'm new to Informix but I just can't seem to wo…
Re: Set Term question
Using recycled bits, Robert S. Moore blurted out: %It has been a long time since I messed with Unix but I'm needing to run %DBACCESS on a Sun box so I can get some table descriptions and an export. % %I feel pretty stupid about this question but when I get to the bin directory %a…
Re: Oracle positions
Sandra Ward wrote in message <75qmsq$ivi$1@news.xmission.com>... > >Hi everyone, >on the offchance, I just wondered what kind of oracle positions there = >are out there particularly in Europe. Does anybody know of any = >interesting job prospects? >Thanks > I understand that th…
Re: How to prevent dead locks ???
Venky9970@aol.com wrote: : We are getting dead lock errors in our production system, I looked at : informix manual for any hints on preventing it. It was mentioned that : by using certain algorithms dead lock can be prevented. : Can anybody let me know how to prevent dead locks…
Re: JDBC drivers and Browser
> I�d like to know if it is possible to use direct connections (without rmi) > included in an applet that runs in a browser with Informix jdbc drivers, > with my Web Server and my applet classes in the same host. I think so... assuming the following: 1. You don't have any proh…
Re: Informix-4GL & Java
> Does anyone have some ideas about linking up Informix-4GL & Java? > Has anyone done it? In version 3.1 of NewEra, they added a feature to communicate with Java. NewEra is kinda like 4GL. If your goal is to have the 4GL act as a server to the Java client, then you will not be …
Followup: Re: Error While Compile ESQLC
In a followup to this post: While the esql script properly handles the combination of -static and -thread if the -static option comes first it does not have any provision for -thread to come first and does not properly link the tread safe libraries if you supply both options in …
Re: SE; Linux; ODBC
Roland Kruggel wrote: > > hi, > > i have informix SE for linux (RedHat 5.2). it warks fine, but i search an > odbc-driver. how can help. many thanks The Informix I-Connect package contains an ODBC client driver which communicates with Informix engines natively so it does not nee…
Re: SELECT BETWEEN DIFFERENT SERVERS
Makunin Dmitry wrote: > > Hi > I want make this query : > > SELECT * FROM appdb@mfcinf:t_1 ; > > But it do'nt work . > Help Saying "But it don't work" isn't telling us much to go on is it? What version is the local server? The remote server? Platforms (remote & local)? W…
Re: Informix 5.0x Y2K Readiness
Ali Azarkar wrote: > > Hi, > Are Informix products 5.0x, 4.1x and 6.0x Y2K compliant? Does this > products support DBCENTURY? Where can I find more info? Thanks. Complete information about Y2K compliance is available on the Informix WEB Site, but here is the quick and dirty: …
Re: Informix 5.0x Y2K Readiness
These products do not support DBCENTURY. They are not currently released, either. In fact, they are all Informix LifeCycle Category 4, which means they have more problems than Y2k readiness. Ali Azarkar wrote: > > Hi, > Are Informix products 5.0x, 4.1x and 6.0x Y2K compli…
Re: looking for a database:
If you're into Delphi development check out FlashFiler at http://www.turbopower.com -- Please remove the nospam from my email address when replying to messages yrparent@nbnet.nb.ca yrparent@nbtel.nb.ca Yves.Parent@NewNorthMedia.ca…
Re: Error While Compile ESQLC
M.Syafi'i wrote: > > When I tried to compile esqlc file, there is error : > > $ esql -c varchar.ec > cc: -lixsql: linker input file unused since linking not done > cc: -lixasf: linker input file unused since linking not done > cc: -lixgen: linker input file unused since linking n…
Re: Can DBAccess display more that 80 cols
I second this request. It would be nice for the display to be greater than 80 characters, like maybe even 132 characters! Julien Art S. Kagel wrote in message <368147FB.50FD@bloomberg.net>... >Porcello, John wrote: >> >> I have a select statement I am running from DBAccess at t…
RE: connection problem
This error is usually caused by an incorrect PATH setting. Make sure that your current $INFORMIXDIR/bin directory is listed in the Windows NT PATH system variable. (Settings -> Control Panel -> System -> Environment) Also ensure that the location of the INFORMIXDIR directory is p…
Re: looking for a database:
There are only two that I can think of that come close. Microsoft Access Sybase SQL Anywhere I believe that both have royalty free runtime distrubution, at least for single user database files. The text search capability is the rub. I don't think either have really str…
Re: looking for a database:
Guy, You certainly crossposted to enough groups to get answers. There probably are others that I am not as familiar with, but Access will handle all of your requirements. You'll need the Office Developer's Edition, in order to do runtime distribution. But you have not included …
Re: looking for a database:
In article <75te29$302$1@news.netvision.net.il>, Guy <guy@aisys.co.il> wrote: >Please help us: > >We are currently looking for a database management system, which meets the >following requirements: > >? Royalty free for distribution. Rules out the otherwise free Linux-servers fr…
looking for a database:
Please help us: We are currently looking for a database management system, which meets the following requirements: ? Royalty free for distribution. ? Editable. ? Easily contain HTML and its content (images, links) and other document. ? Has Text search capabilities + Includes su…
Oracle positions
Hi everyone, on the offchance, I just wondered what kind of oracle positions there = are out there particularly in Europe. Does anybody know of any = interesting job prospects? Thanks…
Re: connection problem
In article <75s491$1a8$1@baikdu.kaist.ac.kr>, "Sun-Kyong, Lee" <sklee@gauri.co.kr> wrote: > Hello~ > > I want to connect to INFORMIX-Universal Server Version9.13.UC3 on > SunOS5.5.1 from ASP Server winNT4.0 with NT Services Pack3.0 and > Option Pack4.0 > > I am using INTERSOLV …
Re: Indexing & data warehousing
Thank you Billy, Tim, Art & Doug for your responses. A merry season to all. I'm off... -- /* ----------------------------------------------------- * * Willem Roos wroos@shoprite.co.za * * roosj@mweb.co.za * * 0(+27)21 9…
SE; Linux; ODBC
hi, i have informix SE for linux (RedHat 5.2). it warks fine, but i search an odbc-driver. how can help. many thanks regards roland kruggel... germany…
notifying clients ?
I have several client applications running on Windows NT using Informix-Cli for connecting with Online 7.3 on Solaris. My question is the next one : Is Online able of notifying by itself that something has changed in the data base ? May I do it with Triggrers ? How ? I would l…
Re: Running Dynamic 4GL Applications
You can't set such a PATH to your 42rs. You must call them explicitely. Andy Kent wrote: > Can anyone tell me how D4GL locates .42r files? I've tried setting DBPATH, > FGLLDPATH and PATH, but fglrun only finds my .42rs when they're in my > current directory. > > Thanks, > > -An…
SELECT BETWEEN DIFFERENT SERVERS
Hi I want make this query : SELECT * FROM appdb@mfcinf:t_1 ; But it do'nt work . Help…
Informix 5.0x Y2K Readiness
Hi, Are Informix products 5.0x, 4.1x and 6.0x Y2K compliant? Does this products support DBCENTURY? Where can I find more info? Thanks. -- Regards, -- Ali Azarkar. _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at htt…
Error While Compile ESQLC
--------------6C5D67298931726C20724F68 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit When I tried to compile esqlc file, there is error : $ esql -c varchar.ec cc: -lixsql: linker input file unused since linking not done cc: -lixasf: linker input fil…
Re: Oracle positions
Probably a lot, migrating to Informix..... Sandra Ward wrote: > Hi everyone, > on the offchance, I just wondered what kind of oracle positions there = > are out there particularly in Europe. Does anybody know of any = > interesting job prospects? > Thanks…
Re: Database size
Kutts Mike wrote: > Hi Admins, > > I have three database is one chunk.(Informix 7.30UC6X1) > I would like to know how much space is occupied by each database. > > Is there any standard command in Informix ? It's not exactly standard, but how about using the sysmaster database:…
Re: Informix 5.05 kernel parameters
Carlos Aviles wrote: > The initialization is failing with the error: > > shmat: [EINVAL][22]: shared memory base address illegal > using 0xC3ABE0, needs 0xC0058000 More often than not, this error means your shared memory kernel parameters are insufficiently configured. Tr…
Re: Subscripting in SPL
> Boris wrote... > >Well, I know that you can use constants as subscripts, but my question was > >about using variabales. I'd like to do something like this: > > > > FOR i = 1 TO max_i > > IF str[i] = certain_character THEN > > LET str[i] = another_character; > > …
Need advanced SQL statement
I'm looking for an advanced SQL statement that will work with any ASCII compliant database engine. Also the pre-parser to set the string up to be searched. If you have seen http://www.DejaNews.com in action, much like that. Looking for anything like this or where I may find it …
connection problem
Hello~ I want to connect to INFORMIX-Universal Server Version9.13.UC3 on SunOS5.5.1 from ASP Server winNT4.0 with NT Services Pack3.0 and Option Pack4.0 I am using INTERSOLV 3.10 32-BIT INFORMIX 9 ODBC Driver. ILogin Demo works well... When I tried DB open, IE4.0 displayed fo…
Re: Running out of shared memory
In article <366E7D08.C219D263@uk.ibm.com>, Danny Williams <danny@uk.ibm.com> writes >Hi There! > >I have an Informix instance that ran out of shared memory during a >transaction:- > >AIX 4.2.1 >Informix 7.22.UC1 >SHMVIRTSIZE=64Mb >SHMADD=32Mb > >So I increased SHMVIRTSIZE to 256 …
Re: SQL Question: Update Syntax
I'm unsure which version of the engine you're using but if it's 7.3 or 8.x then you also have the option to use update joins. Sample syntax would be: UPDATE table_a SET table_a.column_1 = table_b.column_1 FROM table_a, table_b WHERE table_a.column_2 = table_b.column_2 AND table…
Re: onstat -d flag
Jacques is correct 0x1000 means a table in the dbspace was dropped since the last checkpoint. This flag affects physical logging. In case you did not know, 0x0001 means Dbspace is not mirrored, so flag 1001 means that a table was dropped in a non-mirrored dbspace. Jacques P Ren…
Re: Oracle positions
In article <75qmsq$ivi$1@news.xmission.com>, sandraw@peregrine.ie (Sandra Ward) wrote: > > Hi everyone, > on the offchance, I just wondered what kind of oracle positions there = > are out there particularly in Europe. Does anybody know of any = > interesting job prospects? > Th…
Re: Database server: Why Windows NT does not support command-line option???
We might be able to help. http://home.att.net/~enterprisesystems Dev_Al wrote in message <367E8F5B.E3618C55@yahoo.com>... Why Windows NT does not support command-line option? This could be ideal for servers like database servers, Web servers, email servers, news servers, file se…
Re: Online command to get status
In article <367EC431.ED304417@calva.net>, "J.-M. Gimenes H. Zalkind" <jmg-hz@calva.net> wrote: > Hi, > > I am running Informix 7.23 UC5 on Solaris 2.6 > > I need to know an Informix command (quick online command I can include > in a script) to get status of Informix server (Qui…
Re: DB performance : 45 seconds for a query ?
Sean Kelsey wrote in message <3680e843.0@145.227.194.253>... >What do you get if you ( cross an elephant with a giraffe ?? ) run UPDATE >STATISTICS on the tables ?? > >Do you have any referential integrity or constraints on any of the tables ?? > >Sean > I am not sure, but as far…
Re: KAIO: out of OS resources
In article <75lggq$nm$1@nnrp1.dejanews.com>, benhen@hotmail.com wrote: > Hi, > > Thanks already to everyone for the answers. > Sorry, but I forgot to mention that our Unix box is a Siemens RM 600 who runs > Reliant Unix v 5.43 > Unfortunately, it seems that these kernel setting…
Re: creating databases with GLS ??
Jerry A. Van Zant wrote: > When I create a database either with dbaccess or dbimport, it looks > like the system is ignoring the environment variables. I have the > following set: > DB_LOCALE=en_us.8859-1 > CLIENT_LOCALE=en_us.8859-1 > But the database is created with en_us.8…
Re: creating databases with GLS ??
On Wed, 23 Dec 1998 20:24:28 +0100, Dragi Raos <draos@4mate.hr> wrote: >Jerry A. Van Zant wrote: Yep > >Well, it works for me (AIX and IDS 7.23). Stupid question: have you >exported your variables? > >Dragi "Bonzi" Raos…
Re: creating databases with GLS ??
Well, I'll not claim to be any GLS expert, but what you did should be all you need to do. I played around with it a bit and discovered the following, on solaris anyway (on 7.24 and 7.30). Like you when I used the en_us.8859-1 setting for DB_LOCALE and CLIENT_LOCALE in the syste…
Re: Dynamic 4GL
Mike Segel wrote: > > Dave McNight wrote: > > > > When ever we upgrade Online Dynamic Server, we are recommended or > > required to upgrade the tools (4GL, ISQL, RDS, ID) for compatability > > reasons unless we use the relay module functionality (not recommended > > normally). Al…
Re: Can DBAccess display more that 80 cols
Porcello, John wrote: > > Hi all, > > I have a select statement I am running from DBAccess at the UNIX command > line, the select statement is more that 80 Columns, is there a way to > instruct DBAccess to print this in the single line format verses record by > record? > > On tha…
Re: DB performance : 45 seconds for a query ?
Michel Dalle wrote: > > Hi, > > I have a frustrating question concerning Informix performance (on a UNIX > system). > > The basic database structure is pretty simple : there is 1 type of table with > 6 (significant) fields : > - reference nr. > - date > - from > - to > - amount >…
Re: Database Size
Art S. Kagel wrote: > [...] > > No there is not, but there was a question yesterday about how many > extents live in each chunk by table. I responded with an SMI query > and later someone else corrected a typo there and enhanced the query > to provide additional information. Y…
Re: creating databases with GLS ??
Jerry A. Van Zant wrote: > > First off the system > > Online 7.24.UC6 > HP/UX 10.10 > > When I create a database either with dbaccess or dbimport, it looks > like the system is ignoring the environment variables. I have the > following set: > > DB_LOCALE=en_us.8859-1 > CLIENT_LO…
Re: Large System
Blacker, Herb wrote: > > I'm looking for general performance characteristics (and any > tips/tricks) for anyone running a system similar to this one: > > Four (or more) 12-way 4GB S/70's (AIX 4.3) running OLTP (IDS 7.3x) with > 4000 max (1200-1500 concurrent) users. > We estimate…
Re: Req. solve for Lock error
dengelsen@my-dejanews.com wrote: > > Hello, > > How can I solve this error: > > 09:50:26 Process exited with return code 127: /bin/sh /bin/sh -c > /informix/ONLINE/etc/alarm.sh 3 21 "OnLine resource overflow: 'Locks'." "Lock > table overflow - user id > > Greetings, > > Ditmar …
Re: Database size
Kutts Mike wrote: > > Hi Admins, > > I have three database is one chunk.(Informix 7.30UC6X1) > I would like to know how much space is occupied by each database. > > Is there any standard command in Informix ? > > Thanks > Mike No, AFAIK. I usually do oncheck -ptT (if I remeber …
Re: Database Size
Kutts Mike wrote: > > Hi Gurus, > > onstat -d shows the space left out in each chunk. > But I would like to know how much space is ocuppied by each database > in that particular chunk > > Thanks again > > With warm regards > Mike > > > >Sean Kelsey wrote: > >onstat -d or -D > > >…
Re: Performance problems with Informix 7.x
Henrik Lie-Nielsen wrote: > > Hi. > > I am currently working on a project to convert data from delimited ASCII > files > into an Informix 7.x database. > > We're writing an app in VB 6.0 and are using several ODBC drivers. > (ADO as data access) > > We are experiencing severe per…
creating databases with GLS ??
First off the system Online 7.24.UC6 HP/UX 10.10 When I create a database either with dbaccess or dbimport, it looks like the system is ignoring the environment variables. I have the following set: DB_LOCALE=en_us.8859-1 CLIENT_LOCALE=en_us.8859-1 But the database is created…
Re: DB performance : 45 seconds for a query ?
Michel You may want to check out the output of EXPLAIN for the query to see if your indexes are being used properly. To run the EXPLAIN, type "SET EXPLAIN ON;" in the line preceding your query. The output of the explain will be contained in a file sqexpl…
Re: Req. solve for Lock error
Ditmar You are running out of LOCKS, whose maximum limit is set in the ONCONFIG file. You may want to increase this parameter and restart the database engine, or reallocate your jobs so that lock usage is more evenly distributed. You could also look to y…
Re: Database size
Mike Here is a script I use to sum the oncheck -pe through awk. The script reads as follows: $DBNAME=$1 # pass your db name in as a command line argument oncheck -pe | grep "$DBNAME" | awk '{ space+=$3 } END { printf("%s - %…
Re: What flag to set?
Rich Moldovan wrote: > > Running two side by side Informix 7.23 servers. On one if I issue > the dbschema command for a specific view it will return field names > that consist of certain key words (such as "text", "global", "buffered") > enclosed in quotations. > On the other se…
Informix SE on RedHat 5.2
After following the HOWTO at http://www.iiug.org/techinfo/linux/Howto_SE_ESQLC.html. I'm receiving ISAM locking errors when I try to do something as simple as create a new database. I'm new to Informix but I just can't seem to work through this. Any clues or suggestions would …
Re: illegal character error with INSERT statement and &BIND
maroof_ahmed@peoplesoft.com wrote: > > Why do I get Informix error [-202] "An illegal character" at pos 00013 in the > following INSERT line: > > INSERT INTO &BIND ( > TAO_GROUP,NOQUOTES) > > Is it because I have an empty space between &BIND and the left parenthesis? Or > I have …
JDBC drivers and Browser
Hi! I�d like to know if it is possible to use direct connections (without rmi) included in an applet that runs in a browser with Informix jdbc drivers, with my Web Server and my applet classes in the same host. Regards Thank you.…
Can DBAccess display more that 80 cols
Hi all, I have a select statement I am running from DBAccess at the UNIX command line, the select statement is more that 80 Columns, is there a way to instruct DBAccess to print this in the single line format verses record by record? On that note, is there a way to make the fol…
Re: Please Help w/ SMI Query
Peter Wang wrote: > > I wish to point out two minor errors in Art's SQL statement (as marked > by "^^") and the correct sql should be: > > > select tabname, trunc((te_physaddr / 1048576)) chunk, count(*) [SNIP] Thanks for catching the typo in the divisor, Peter. A particularly n…
Re: Assert Failures
This has been entered as a bug already. The bug number is 102835. Jacques willie@my-dejanews.com wrote: > It seems that if a user (HP UX 10.20) has a password which is more than 32 > characters (encrypted), the database (IDS 7.30UC3) crashes with an Assert > Failed every time…
Re: Informix SE for Linux
Juan Riera wrote: > > Do you know if the Linux version of Informix SE has any drawbacks and/or > limit date of use? Is there any OLAP tool that could be used on Linux? No. No limits. The only problem is the Caldera/SUSE version leaves zombies when network connections terminate…
Problem installing IDS 7.23TC6 on NT4 with SP4
Hi all, the DB initialization at the end of the install process seems to hang = ("Dynamic server is being initialized ..."); the "Dynamic = Server"-Service is started, the Message Service seems to be the problem. = Anybody any idea? Thanks for your help, Arno Arno A=DFmann Co…
Re: Database server: Why Windows NT does not support command-line option???
Tony Rogerson (tonyrogerson@compuserve.com) wrote: : On the times where I've had to work 15 - 20 hours fixing a system and had to : do most of the work on the server I'm incredibly grateful for the GUI. Personally, GUIs get in my way to fix many problems, but to each his or her …
Re: onarchive and remote tape devices
hi, my rhosts and Tape Devices seem fine here is the error message I get --BEGIN-- ARC-E-01121, Undefined device type (see CONFIGURATION file). Archive request 00000017 failed. --END-- DEVICE TAPE = machinename:/dev/rmt/0 DEVICE RTAPE = machinename:/dev/rmt/0 DEVICE…
Re: Req. solve for Lock error
Hallo Ditmar, if it's possible you might a) increase the number of locks ( OS + ONCONFIG ) b) do a exclusive table lock c) split the transaction to more than one d)... . Klaus Nonne…
Re: Recovery from a disk failure on a mirrored drive
I'm with David on this one... Effectively, if you are using hardware mirroring ( not Informix ) then Informix shouldn't even know that anything has happened if the main chunk in the mirrored pair goes down. I've configured a server using hot swappable disks, mirrored at the OS …
Re: Req. solve for Lock error
If you do an onstat -p you will get the profile for the instance. In this profile you should get something like this:- INFORMIX-OnLine Version 7.24.UC5 -- On-Line -- Up 16:01:19 -- 939624 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 148…