Threads from 2001
Re: HPL
U�ytkownik "Robin" <robertw@szczecin.pekao.com.pl> napisa� w wiadomo�ci news:96ktk0$6k$1@news.tpi.pl... > Hello! > Why I can't use HPL if I have 7.31 IDS? (WinNT IDS 7.31)? > > > Projects > This feature is not available for this server version. > > > > In ..informix/…
Re: Development Tools
Brett Geer wrote: > > RDS is the Rapid Development System (the one where you spend more > time setting up program compiles than actually codiing)... You must be doing it all wrong (or writing very small apps :)! Besides, it takes the same time to set up as 4GL. > You use it if…
Re: Informix free
Paul Mosser wrote: > > "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> wrote in message > news:96fl45$en4$1@news.xmission.com... > > > > All Informix need is to hire a decent marketing agency. It's simple I > > know, but it beats trying to hire the right people. > > > > Oh, maybe…
RE: Update Statistics question
This may help you . . . select tab.tabname, col.colname, dist.* from systables tab, syscolumns col, sysdistrib dist where tab.tabid = dist.tabid and tab.tabid = col.tabid and col.colno = dist.colno order by 1, 2, dist.seqno -----Original Message----- From: Jack Maso…
Re: Update Statistics question
If you are creating data distributions you can look at the constructed column in the sysdistrib table. Here's the query: select systables.tabname,syscolumns.colname,sysdistrib.constructed,mode from sysdistrib,systables,syscolumns where systables.tabid > 99 and systables.tabid = …
Re: Owner changes
Scott One way to do this is to have either informix or a "application-super" user own all your tables and to GRANT various permissions to other users or roles as appropriate. HTH Sujit Scott Fendley <dsf@uark.edu> on 02/15/2001 03:45:42 PM Please respond to Scott Fendley <dsf…
RE: PDQ Woes
PDQPRIORITY sets the amount of PDQ resources that will be used by a query. When you set it to 75 it means that it will use 75 percent of PDQ resources (Memory, Threads, etc.). When you run onstat -u you saw multiple threads not multiple sessions. If you run onstat -g sql <sid> fo…
Re: problem with HPL
Yep that'll break it too Yours -- Earle A Long (Senior DBA) SinglePoint Limited "Robin" <robertw@szczecin.pekao.com.pl> wrote in message news:96jcsq$hgj$1@news.tpi.pl... > U�ytkownik "Earle A Long" <earle@btclick.com> napisa� w wiadomo�ci > news:JH8j6.18219$bP4.31687@NewsReader…
Re: error 710 - help - help -help
I'm having the same problem with 7.31.UC6. For seemingly no reason, a program which has been running for hours, sometimes days, will start getting -710 errors every time it opens a particular cursor. The schema for the table has not changed. I found a defect against 7.24 regard…
Update Statistics question
7.x Is it possible to know somehow when the last time update statistics was run? Thanks…
Enterprise replication problem
Hi all, I am running enterprise replication between two servers, one in India and one in Belgium. When I delete one replicate and re-create that replicate, I am getting the following messages in the message logs of two servers: messages on India server -------------------------…
RE: I NEED A TOOL FOR Database Management
Extract from e-mail sent by Rick Bernstein - Sent: Wed 1/24/2001 1:35 AM "You are probably referring to IECC. Now, Informix ships two products that "might" be considered a GUI-like version of dbaccess. 1) DB Administrator runs on Windows and contains: a) Table Editor and …
RE: Side Effects of Setting Tables Memory Resident
A rule I use for myself, is to only set tables that are being read from, memory resident, and not tables that are being written to (inserts / updates/ deletes). Regards Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-info…
RE: Downgrade infx 64 to 32... is it possible ?
I'm not even sure if you can restore. As far as I know backup and restore is supported when it is on the same platform / database version. You will probably have to export / import or something similar. *** or check your release notes. There might be an easier way to revert ba…
FW: error 710 - help - help -help
Is update statistics running when you get this error. This has happened to me before. In my case 1) the program started running, opening cursors 2) then update statistics ran on the tables which were being referenced in the already open cursors If this happens, you will get th…
****SPECIAL REPORT****
--_NextPart_0000904A-000004C2-0387A384-4608 Content-Type: text/plain Content-Transfer-Encoding: 7bit Get a brand new, clean, credit file in 15 days or less... Get the credit you deserve... For more info, send a email to wilsoncredit@email.com with "INFO" in the subject line... -…
Dbexport on tape drive
I have Informix 7.31 on SCO Unix 5.0.5. I want to take a dbexport and save it directly to the tape because I don't have enough disk space to save the export. How can I direct the dbexport to the tape? Thanks, Vasilis…
RE: Problem with ontape -r
During the execution of "ontape -r", it would prompt you whether you want to restore the logical logs. You should answer "yes" if you do have logical logs to restore. Respond with "no" if you don't have any logical logs to restore, you will just basically do a physical restore of…
PDQ Woes
OK, so a user job has been running now (we joke not), 2 days on one little select, ok its lots of data. So I kill it, my box was grinding. I run it with MAX PDQ at 10, it crawls, my box crawls. I set PDQPRIORITY=75 (I know, but I'm the admin and no-ones gonna …
Re: Side Effects of Setting Tables Memory Resident
To add onto Andrew's comments, we set a good deal of smaller tables resident, he's right, the buffers are running low which is causing the writes. Solution, remove some of these puppies from the cache or just shove thier indexes in there. Or of course, increase your buffers. Wha…
Re: Development Tools
RDS is the Rapid Development System (the one where you spend more time setting up program compiles than actually codiing)... You use it if you use r4gl, fglpc or suchlike brett > Hi! > A question: what is RDS? > Wasn't it the first name of the firm with a product called inform…
Re: Views
Without the source that created it you are kinda screwed. Do a dbschema and edit that, then recreate it. I'm not sure if you can alter them with an alter table command, never tried. brett Martyn Shiner wrote: > > I have a db that has several views (virtual tables) set up. How d…
RE: Available Consultants -- Informix/Oracle/C++/Unix/CORBA
I Agree, sounds like they are desperate for work. -----Original Message----- From: obnoxio@hotmail.com [mailto:obnoxio@hotmail.com] Sent: Thursday, 15 February, 2001 3:40 PM To: informix-list@iiug.org Subject: Re: Available Consultants -- Informix/Oracle/C++/Unix/CORBA I would …
RE: Downgrade infx 64 to 32... is it possible ?
Yes. It is posible. Check the release notes it should give instructions on how to revert back from 64 to 32(SERVERS_9.2). GOOD LUCK! >From: "Christian Kondo" <christian_hk@hotmail.com> >To: informix-list@iiug.org >Subject: Downgrade infx 64 to 32... is it possible ? >Date: Thu,…
Threads and ESQL/C under LINUX
Hi all, the documentation of esql/c describes the settings that must be used to build multithreaded applications using the DCE-library (aka POSIX pthread...). Only two settings are needed. First the environment variable THREADLIB must be set to DCE and second, the command line sw…
Re: Side Effects of Setting Tables Memory Resident
Dave Thacker wrote: > > In an effort to cut down on disk I/0, I have set 8 of our most heavily used > tables to memory resident. The checkpoints have gone through the roof. I > was averaging 1-3 seconds and am now stuck at 8-9, with spikes to 15. > Checkpoint interval is 300 s…
RE: Owner changes
Dont do it. You dont need to do it. We have lots of fictious names as owners of tables -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Scott Fendley Sent: Friday, February 16, 2001 12:46 PM To: Informix U…
Owner changes
I was curious if someone had a nice little method to go through and change a large number of tables in a database to be owned by someone else. We recently lost one of our lead developers, and the remaining developers are getting the various products/projects divided among themse…
RE: Downgrade infx 64 to 32... is it possible ?
No this is a 1 way migration. Restore from your archive prior to migration or dbexport / dbimport. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Christian Kondo Sent: Friday, February 16, 2001 7:26 A…
RE: Problem with ontape -r
1. After the restore did you bring the engine online (after the restore went into quescient)? 2. Any messages in the messages log? MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Fabio Srednik Sent: Fr…
RE: Update Statement
The EXISTS causes a hash join, the in causes a 'nested loop' type behaviour. Use what is optimal for you. cheers j. > -----Original Message----- > From: Stefan Weideneder [mailto:stefan@weideneder.de] > Sent: Thursday, February 15, 2001 3:19 PM > To: informix-list@iiug.org > Su…
RE: Update Statement
Have you tried this? update admin.subc set admin.subc.deal_key = "NVD" where admin.subc.chas_key = (select chas from dblog1.eire) -----Original Message----- From: Kirk Davis [mailto:kirk.davis@volvo.com] Sent: Thursday, February 15, 2001 8:39 AM To: informix-list@iiug.org Subje…
RE: 4GL: Characters for Window Borders
Simple way to test is is trap the output before it gets to the screen. If the output from one site does not match the output at another site, then you have potential network issues. Or create your own 'will work' output to draw graphics and cat it to the screen. A simpler answ…
Easy creation of database driven web sites.
Looking for an open source web development tool that supports commercial as well as open source databases? Check out http://www.openbedrock.org <sqlconnect> <table> <sqlselect "select * from customers"> <tr> <td><var $name></td> <td><var $address></td> <td><var $phone><…
Re: Update Statement
This is a multi-part message in MIME format. --------------454467EE8C9FEC5B3110BB5A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Kirk. If you need to update *all* the rows in the admin.subc table, then try: UPDATE admin.subc SET admin…
Re: update performance
On Thu, 15 Feb 2001, Martin A. Marques wrote: >El Mar 13 Feb 2001 16:53, Jonathan Leffler escribi�: >> I don't fully understand the question, but I'll take a stab at it >> anyway. >> >> UPDATE YourTable SET BoolColumn = 1 >> WHERE BoolColumn = 0 AND ...whatever other conditions…
RE: Update Statement
Is this something like what you are trying to do: update table@database set column_name = 'somevalue' where table@database:column_name = column_name; UPDATE sunc@admin SET deal_key = "NVD" WHERE eire@dblog1:chas = CHAS_KEY; Wayne E Martin Informix Database Administrator Kmart …
Re: 4GL: Characters for Window Borders
Well, the vt220 entries in the termcap files are identical at the two sites, but one displays the windows line-drawing chars and the other doesn't. And while I don't find any vt220 entries in the $(INFORMIXDIR)/etc/termcap file, our gs, ge and gb codes( :gs=\\E(0:ge=\\E(B:gb=lmkj…
Side Effects of Setting Tables Memory Resident
In an effort to cut down on disk I/0, I have set 8 of our most heavily used tables to memory resident. The checkpoints have gone through the roof. I was averaging 1-3 seconds and am now stuck at 8-9, with spikes to 15. Checkpoint interval is 300 seconds. onstat -F says: Fg W…
test
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_01C0977E.D859C850 Content-Type: text/plain; charset="iso-8859-1" test please ignore Dale Gilbert - Mission Solutions …
Downgrade infx 64 to 32... is it possible ?
Hello people ! I did an informix upgrade 7.31.UC7XB to 7.31.FC7X2, but I have to back to 32 bits ... Is it possible without restore ? TIA Chris. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://w…
Locales, ODBC and SPL
Hi, I am using VB6 (RDO20.dll) and the newest Informix ODBC driver (3.32 .0000 2.50 tc2) to connect to Informix.2000 on Windows 2000. The client workstation is running NT4(sp5) The database was created with the default locale (en_US.CP1252) Client Settings: ODBC Driver setup,…
I NEED A TOOL FOR Database Management
Hi guys, I�m a DBA informix in a bank of brazil, I�m needing know a tool to management of informix. Monitoring, Tables defrag, etc. Is there anyone to do it? Andr� Macedo DBA Informix Zogbi-Promovel Fone: 55-11-3038-3333 ramal 3375 amacedo@zogbi-promovel.com.br…
Update Statement
Hi All, Hope someone out there can help me with this one, it's driving me mad! Does anyone have any idea, why the statement below would not work, I just get the error " 522: Table (dblog1.eire) not selected in query." I've tried also making the first line UPDATE admin.subc, …
Any info about OfficeConnect 2.0
Hi Informix Users, are there anybody of you using, or have infos about the Informixproduct OfficeConnect 2.0? We are interested for Win98(FE/SE). What does meen: DCOM is needed? What is it, where to get it? Thanks a lot Cheers Peter…
RE: large chkpoints with update program running
(DSS talking) You should also point out that checkpoint writes are more efficient than LRU writes. While it may give the impression that the machine is slow, if you have a single update process (and no users you're trying to run around), then you want checkpoint writes. Of cou…
Problem with ontape -r
I have problem to restore databases on a RM300 rebuild with DSSI. The version of Informix is 7.14. After restoring the entire instance (all dbspaces) with the ontape -r command, they become inconsistent ( Status PI ) and there's no way to change their condition. Trying to perfor…
Re: update performance
El Mi� 14 Feb 2001 19:48, escribiste: > In the year of Our Lord Tue, 13 Feb 2001 09:32:10 -0300, "Martin A. > Marques" > > > >Don't worry, my friend Obnoxios, with a par of programing (external) > > tricks fixed it. > > > >But if you want to know: > >Lets say I pass to a user a l…
Re: update performance
El Mar 13 Feb 2001 16:53, Jonathan Leffler escribi�: > > I don't fully understand the question, but I'll take a stab at it > anyway. > > UPDATE YourTable SET BoolColumn = 1 > WHERE BoolColumn = 0 AND ...whatever other conditions you need... > UPDATE YourTable SET BoolColumn = 0 …
Re: Using onunload command in shell script
Its the << redirect. brett Muhammad Usman wrote: > > Hi! > > My shell script contains: > > #!/bin/sh > # > mt -f /dev/rmt/1 rewind > # > # Stores7 Database Tables. > onunload -t /dev/rmt/1n -b 1024 -s 68157440 stores7:call_type << @ 2>&1 > echo '\\n' > onunload -t /dev/rmt/1n -…
RE: system hangs during accessing a particular table
On sober second thought - DON'T post onstat -a output to the list. They tend to be rather large and folks using a phone line to read the group will be unhappy. But you can send it here if you like. cheers j. > -----Original Message----- > From: Parker, Jack > Sent: Thursday, …
problem with HPL
Hello! I have problem with executing HPL jobs from ISA (IDS 2000 on WIN2000) output of ISA window: Command Output onpladm run job robertw.state -p robwol -fu -l "/tmp/robertw.state.log" Cannot execute stored procedure start_onpload SQL ERROR -668 onstat -m: 12:54:27…
RE: I4GL 7.30 HC5 problem using comments
I must be having a slow-week (i.e. I'm slow), has it been a month already? cheers j. > > You don't run into compilation errors as the OP did when > recompiling is > not an option :-) > >…
Views
I have a db that has several views (virtual tables) set up. How do I find out what the SQL statment is that created the view? Can I edit this or do I have to drop the table and set it up again? Informix version is 7.20.UE2 Regards Martyn…
large chkpoints with update program running
The system is going v v slow and it is most likely due to an update progrm than has been running for over 2 hours. The following is the results from onstat -u | grep paladm, every 10 secs which shows it is doing a lot of writes. This has increased the checkpoint interval. Is this…
temp tables
does anybody know, how to get the names of all temp tables ordered by the according sessionids using a sql-statement ? Jan…
error 710 - help - help -help
My client (unix server, Informix 7.2) is getting error -710 almost daily. They run Update Statistics which resolves the problem temporarily and until the next day or two days later where it reoccurs. We ran oncheck -pT and no table has version problems. Please help, thanks…
data replication on linux9.20 errors.
This is a multi-part message in MIME format. --------------EE626B64EF05E473BA0BEF7E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit hi , Has any one seen these errors on secondary and primary servers? I haven't - and i can't find out what's wrong (i s…
Using onunload command in shell script
Hi! My shell script contains: #!/bin/sh # mt -f /dev/rmt/1 rewind # # Stores7 Database Tables. onunload -t /dev/rmt/1n -b 1024 -s 68157440 stores7:call_type << @ 2>&1 echo '\\n' onunload -t /dev/rmt/1n -b 1024 -s 68157440 stores7:catalog << @ 2>&1 echo '\\n' onunload -t /dev/rm…
RE: 4GL: Characters for Window Borders
Which termcap/terminfo are you using? We use vt220 with a modified termcap and have no problems IF THE RIGHT TERMCAP ENTRY is used. Check out ${INFORMIXDIR}/etc/term* - appropriate files used to be in the distributions - they also used (past tense) to be "not quite right". Fai…
Re: Development Tools
I remember reading something a few years ago that said that the RDS image in memory was not shared by the users running it, so a big RDS file was a dog, though the runner was shared. Well, thats the theory anyway, tell all this to AIX Aways, we find that the RDS compiled stuff …
Re: Informix IDS 7.30.UC7-1 on AIX
Check your environment setup. Look at: INFORMIXDIR INFORMIXSERVER brett Adam Hanel wrote: > > When trying to install and run Informix on IBM AIX 4.3 I get this message > when I run "onmonitor" > "Unable to load locale categories." > > So when I tried to run "oninit" I got thi…
Re: Backing up tables
At 01:30 01/02/14 -0500, Muhammad Usman wrote: Hi Muhammad. Please try following this. 1. select database stores_demo. 2. unload to "/dev/rmt/0n" select * from state; 3. mt -f /dev/rmt/0n rew 4. execute a.out e.g) % cat o.c #include <stdio.h> #include <fcntl.h>…
RE: raw device on IDE hard disk on RedHat Linux?
>[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of bob >Sent: Wednesday, February 14, 2001 8:43 PM >[This followup was posted to comp.databases.informix and a copy was sent >to the cited author.] >Excusing my ignorance, but we found that NT Informix was ugly slow on IO >as…
Re: FW: Numbers of Locks
At 16:37 01/02/13 +0200, Dirk Moolman wrote: Hi Dirk. My understanding was an error. I am sorry. Regards. > >-----Original Message----- >From: owner-informix-list@iiug.iiug.org >[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Tsutomu Ogiwara >Sent: Tuesday, February 1…
Re: oninit -i: "Cannot find message file"- Error Messages
At 19:20 01/02/13 +0100, news.aon.at wrote: Hi. I think DBLANG is not correct. Please set the correct DBLANG It is the extract of a Informix Guide to GLS Functionality. 1. If DBLANG is set to a full_path: the directory that full_name indicates 2. If DBLANG is set to a relative…
Re: dbload - memory fault
At 08:51 01/02/13 -0500, Mark Oberfield wrote: Hi Mark. FYI. > Clown> Hint: don't go to UD1 if your app uses serials. > >Hmm. We are planning to upgrade to UD1 as well Clown. Can you be >more helpful and tell us the problem with serial columns? Its is >a "showstopper"? Did…
Cross-platform 'dbschema'
This is a multi-part message in MIME format. --------------3A45BBE428DCC445771B7D27 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Greetings all! I've installed IDS 2000 on my PC and am trying to get a dbschema of a database on a remote UNIX machine …
RE: dbload - memory fault
Product defects 146052 145598 We are (sorry were) about to install UD1 at a client. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Obnoxio The Clown Sent: Wednesday, February 14, 2001 3:11 AM To: in…
Myschema options
Are there any options within myschema to create any views / synonyms associated with recreating a table? John Carlson Informix Database Administrator EDS - WHSmith USA 3200 Windy Hill Road, Suite 1500 West Atlanta, GA 30330…
oracle?
<laughing> So I just went to the oracle.com site looking for some info that is supposedly there re: the reference implementation of sqlj. When I hit the "Search" link I got: Database Log In Failed TNS is unable to connect to destination. Invalid TNS address supplied or…
Download or free copy of Informix
Hello All, Where on the net can I download a free copy (trial) of the Informix Database. Or is there someone who can send me a copy (on CD) to me (belgium? ) Thanks, Christof…
"Million Dollar Gaurantee"
Just caught an Oracle ad. 'Our software will run your web site 3x faster than IBM or Microsoft, or we'll give you a million dollars'. Intrigued because I didn't see them claiming to run faster than Informix I went and read the details. What a riot. You have to convert your si…
Limitations of LINUX/INFORMIX Evaluation Products
What if any are the limitations of evaluation products downloaded from Informix website? I am currently have a problem with "set explain on", 581, error which indicates error loading message file. I was attempting to determine how much work it would be to convert our current ap…
MSC Vp taking up memory
Hi All, A small question. We are running IDS 7.30 UC8 on HP 9000 (HP-UX 10.20 and 1 GB RAM) and I have noticed that the MSC Vp is taking up a lot of memory as compared to other Vp (100+ Mb as compared to the other Vp's which take up 13-15 Mb). What exactly does the MSC Vp do ? …
MSC Vp taking up memory
Hi All, A small question. We are running IDS 7.30 UC8 on HP 9000 (HP-UX 10.20 and 1 GB RAM) and I have noticed that the MSC Vp is taking up a lot of memory as compared to other Vp (100+ Mb as compared to the other Vp's which take up 13-15 Mb). What exactly does the MSC Vp do ? …
Resolution on dbexport is wrong
I use Informix Online 7.22 UC3 on SCO OS 5.0.4. After transfer from NLS to GLS an dbexport ´dbname´ -ss bring on statistics update a resolution 050000. But it must be 0.50000. What is wrong? Can anyone help me, Please ? Thanks, jush…
Informix 4gl Version 7.30: INPUT ARRAY
Hello! I use Informix 4gl version 7.30 / Linux 2.2.16. INPUT ARRAY: "SCROLL ... UP/DOWN BY ..." doesn't work! Could someone help me? Thanks!…
Unicode for Chinese Font
An Employee of Us wants to insert Chinese Letters into an Informix Database. Our Software is built on esql/c. Are there any experiences with this ? Just now the Customer uses Informix 7.30TC7 on Windows NT, will he require an Update ? I think i saw already some guys from Singapor…
SMI-Tables: Performance messaurements - l2datetime convert the Informix internal time to datetime
Hallo, I've 2 questions for useing the SMI/onstat for performance messaurements. 1.) Whar is the unit of the memory usage in onstat -g ses (bytes ??) 2.) How can I convert the Informix internal time in long in a datetime-representation, as is done with the SP l2date create proc…
4gl and stored procedures
Hello! Maybe this question is rather stupid... but I did not find an answer in docs.. As far as I understand applications that interact with db can be easyily developed with 4GL. But is there any way to write a function in 4GL and use it in a stored procedure-like way? I mean com…
RE: SHMBASE Address - From Gigi
Sorry, I missed this from 3 weeks ago - I hope you've found a solution by now! If you HAVEN'T, this is usually a symptom of not setting the kernel parameters. You can leave the SHMBASE setting as it is supplied. My $ONCONFIG file shows 0x10000000 so I'm not sure where you got 0 …
Backing up tables
Hi Is there a way to backup selected tables on Tape using no rewind? Usman musman@iffco.com ------------------------------------------------------------ Get your FREE web-based e-mail and newsgroup access at: http://MailAndNews.com Create a new mailbox, or a…
Backing up tables on tape
Hi I would like to know if there is a way to backup selected tables using Informix Utility on tape? Can we use onunload command with norewind tape and how can we restore it? regards Muhammad Usman ================================== Posted via http://nodevice.com Linux Program…
Database-related sessions, joint BCS and XML UK Meeting (XML DevCon 2001, London)
Below is a list of the database-related sessions that will be running at XML DevCon 2001 in London (21-23 February, http://www.xmldevcon2001.com). There is also an open meeting (XML UK and British Computer Society) on 22 February to discuss "The Importance of XML, e-Government a…
Re: database modelling tools
Have you ever heard of System Architect? It has support for Informix data types. Hope it helps. ----- Original Message ----- From: "Twaddell, Ronald" <Ronald.Twaddell@nexigent.com> To: <informix-list@iiug.org> Sent: Monday, February 12, 2001 10:19 PM Subject: RE: database mode…
[jdbc] Redbrick jdbc driver
hi, I have some problems with a program in java and pure-jdbc driver of Rebrick. The error message is: "unable to set locale" and I have not connection to the DB.... With Odbc-Jdbc is all right..... Thank You Gian…
Re: Informix free
Tom Grenier wrote: > > I really like Informix as a technical product, and prefer to work with it. But > I am realistic also, which I am scurrying as fast as I can to come up to speed > with Oracle. I can tell you horror stories about Informix sales and marketing > from when I w…
Available Consultants -- Informix/Oracle/C++/Unix/CORBA
Dear Partners, Available Consultants: Sajeesh Nair Over 3 years of experience Expert in Using Various Informix related tools and Utilities. As a DBA worked on creating databases, storage management, back up and recovery Plans, user roles, privileges, Exporting and Importing da…
4GL: Characters for Window Borders
We support a site that uses a vt220 terminal emulator called QVT/Net 5.0 (by QPC.com) to make telnet connections from PCs over a LAN using an NT server to an Informix database on an RS6000 AIX machine. The termcap entry for vt220 includes the gs, ge, and gb capabilities, but the…
can't "set explain on" on ISQL/Linux
When I do a "set explain on" using ISQL . I get this error. I have tried various combinations of DBLANG, so I don't think this is the problem. I have not found any install problems. msg/en_us/0333 exists with message files in it. Anybody have a clue? 581 Error loading message…
oninit -i: "Cannot find message file"- Error Messages
Hallo! I have a problem during initialisation of IDS 7.31 on SCO OpenServer 5.0.5 platform. When I dry oninit -i the message "Cannot find message file" appears. The installed IDS on SCO around 10 time on other machine and I had no problems. So I think the enviroment and also th…
Development Tools
Hey gang! There's been a big discussion at work recently about the differences/advantages of using 4GL in RDS mode or compiled mode. The information from Informix was either off of their web site or was a document 8+ years old. My experience with Online 5.X was that compiled cod…
*Informix 4GL Developers Needed in FLORIDA*
PLEASE PASS THIS MESSAGE TO ANYONE INTERESTED AND QUALIFIED Tired of Winter? Ready to move to the beach? Today it is 85 degrees down here! We have some openings with one of our clients in Jacksonville, FL for Informix/4GL Developers. Looking for Developers with 2-4 years experi…
Informix IDS 7.30.UC7-1 on AIX
When trying to install and run Informix on IBM AIX 4.3 I get this message when I run "onmonitor" "Unable to load locale categories." So when I tried to run "oninit" I got this error message "Message 1502 not found." Has any one expierenced these problems? Have any solutions? P…
FW: Numbers of Locks
-----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Tsutomu Ogiwara Sent: Tuesday, February 13, 2001 7:43 AM To: Tham Huei Hwan Cc: informix-list Subject: Re: Numbers of Locks >At 09:56 01/02/13 +0800, Tham Hu…
UPDATE STAT.- DISTRIBUTION & PERFORMANCE
Hi Folks, I've noticed that dropping Distributions before running the UPDATE STATISTICS on a table (with Distribution) helps to improve the Performance on that table by more than 60%. UPDATE STATISTICS FOR TABLE MyTable DROP DISTRIBUTIONS; UPDATE STATISTICS FOR TABLE MyTable; …
FW: Numbers of Locks
You can try - a) onstat -k (which also shows the owner of the lock, which can be traced to onstat -u) b) database sysmaster; select * from syslocks HTH Dirk -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On…
Posting from the Informix-list
--=====_9820735436334=_ Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Hello All: I have a situation that I don't think I understand. I have a fairly small= application written in C-ISAM. The application vendor said that they used= …
FW: Diff between 9.21.UC3-1 and 9.21.HC3-1
UC is complete 32 bit, where HC is 32bit code that was compiled in a 64bit enviroment Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Craig Haarmeyer Sent: Saturday, February 10, 2…
RE: System copy/retore via ontape
Make sure that the ontape backup is done over the correct device read the manuals ... It should NOT be a "no rewind" type !! yours > N. Daniel Bonesana > SIEMENS-ITRON BUSINESS SERVICES S.A. > Balcarce 683, (C1064AAM) Buenos Aires, Argentina. > * 54 (11) 4320-5456 * Daniel.Bone…
Re: update performance
El Lun 12 Feb 2001 19:15, escribiste: > In the year of Our Lord Mon, 12 Feb 2001 18:26:49 -0300, "Martin A. > Marques" > > <martin@math.unl.edu.ar> spake, saying: > >I have to make a query that will update a field of type smallint (a bool > >really), and I have a big amount of va…
Replication Vs Mirroring
I have two Unix servers with SCO 5.0.5 and IDS 7.31. Instead of installing Data Replication can I set up mirroring? What I mean is that I will have two identical servers and their disks will be replicated. What conserns me is how Informix will behave under this configuration. Th…
system hangs during accessing a particular table
hello, we have informix 7.3 dynamic server on SCO unix open server 5.0.5 while running sql statement on a particular table .system hangs. while we gave oncheck -cD dbname ,no error has been reported. due to this dbexport,dbscehma also hangs the system. pls send a solution as soon…
Table locking problem.
Hello! I have a table with a single serial8 column.Lock mode is row. When several threads try simultaneously insert values in the table, the exception raises. Is there any way to get rid of it. Thanks! Artem Goncharuk java.sql.SQLException: ISAM error: the file is locked. at …
Convert
How can I convert a Float to and Integer?…
Installing 7.23
Hi all, has anyone an idea, why installing informix 7.23 on an windows NT 4.0 SP5 breaks when it is about initializing informix?? I tried it several times with allways the same result. Any hint will be helpful! Roger (r.thaens@ts-informationssysteme.de)…
Re: Numbers of Locks
At 09:56 01/02/13 +0800, Tham Huei Hwan wrote: Hi Tham. Probably LOCKS parameter in $INFORMIXDIR/etc/$ONCONFIG Regards. >Hi all, > >How to find out how many locks is hold by particular users / process ? > >Thanks and Regards, >Tham > -- Tsutomu Ogiwara Technical Group & Red …
Re: Modem Login
Exactly what do you mean informix limits you? A uid is a uid is a uid on UNIX, is this a problem running interactive apps? brett "David A. Olson" wrote: > > Hi, > I am new to this group. I have an old Server running SCO Open Server 5.0.2 > with a similarly older version of Inf…
RE: SP Question: System Command
informix user runs all system commands, and on the database server, and with no environment. Does informix have execute permission to the script? and does the script set the required environment? MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:own…
What's wrong with onbar-config to ADSM.
Dear Experts !! I tried to config "ONBAR util" with ADSM. but I met following Error "ERROR: The installed XBSA library is not compatible with version 1 of On-BAR." Circustums : AIX : 4.3.1 ( Informix 9.14.UC5) ADSM : Client Version(3.1.20) , Server Version (3.7) $INFORMIXDIR/et…
raw device on IDE hard disk on RedHat Linux?
Last time I posted a message about raw device on Linux, the conclusion I got was that is's availabe on Redhat Linux 7 but only supports SCSI hard disk. Is there any way to make it work on IDE hard disk? "raw" is available on Redhat 6 as well, is there any major imporvement on Red…
Re: ontape -s -L 0 failed
At 00:06 01/02/07 -0800, K.Hong Lee wrote: Hi. I had a similar experience. Please try this. TAPESIZE 2048000 in your $ONCONFIG parameter. Regards. >hi all, > >I have tried several attempts to perform the db backup >but in vain. Error msg on the terminal shown as below. > >Pl…
Re: Modem Login
Check your environment variables TERM, INFORMIXDIR, INFORMIXTERM, PATH, and possibly INFORMIXSERVER. LO Luis Carlos Diaz Otero wrote: > It looks like an OS problem. > > Did you look at your termcap file and/or at your > /etc/ttytype file? > > ----------------------------------…
Useful not on Crystal and Informix ODBC
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Hi, <p>Just thought I'd post another useful article on Crystal. If anyone uses Crystal with Informix ODBC then they may have run across the problem with outer joins. There is an undocumented feature…
Solution on MS Access and Informix Sorting
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Hi All, <p>Here after 2 years we finally have a solution with MS Access and infromix sorting problems. This is a reference from a technet cd from mirosoft. I posted this problem a while back but did…
Numbers of Locks
Hi all, How to find out how many locks is hold by particular users / process ? Thanks and Regards, Tham…
ISM - GUI
I am looking for a GUI in order to configure ISM (Informix Storage Manager). I have Informix 7.31FC7X1 on HPUX 11.0 and 7.24UC8 on HPUX 10.20 By RTM, it seems I would need IECC (Informix Enterprise Command Center) with the ISM server running on HP and ISM Admin on Windows NT, but…
msg during start up of memory and shmem
Hello all, I have a question about a msg in online.log during start up. My shvirtsize is 491520 and onstat - reports memory allocation of 1,292,456. The hp-ux 11.00 shmmax is 1.6 gig and maxtsize_64 (code space) is 1.6 gig. I would think I have enough mem allocated in unix a…
update performance
I have to make a query that will update a field of type smallint (a bool really), and I have a big amount of values (one per row in the table) which are 0 or 1. Now, I could make an update of all the column, but maybe only 5% of the columns have been changed. What should I use to…
thread memory allocation
Hi all, I have a weird memory usage issue. Here is the problem: on IDS 2000 running on Sun Solaris 8 we have a number of application servers connecting to the informix instance called 'contentdb1'. Most of the threads are JDBC. Somehow one of the application boxes ( app02) requ…
RE: dbload - memory fault
Never had a problem with dbload. But I dont think anyone else would still be using 7.10. Upgrade! -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of iig@mail.ru Sent: Monday, February 12, 2001 10:41 PM To: …
FW: Virus alert!
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_001_01C0952F.366CB2CE Content-Type: text/plain; charset="iso-8859-1" FYI - John F Di Misa SAP Administration / Informix DB…
Rowids: How do younow when the associated record is actually available???
Hello, I don't know if this is the correct newgroup for this. If not, please disregard. I've written a temporary (expected daemon life - 3wks) replication daemon, in Informix 4GL, using Tools 7.20, to read a table from x to end and insert each row into a "like" table on a remot…
Re: Using MATCHES or LIKE on non-character columns ?
select emp_no from tabname where emp_no||" " like "12%" "Bernd Steinhauer" <bernd.steinhauer@dpd.d To: informix-list@iiug.org e> cc: Sent by: …
RE: Informix free
Last time I called Oracle tech support, it took three days for some clueless tech to get back to me with a lame suggestion followed by a recommendation that we upgrade. Sorry, life is too short for that. I've never had that sort of problem with Informix. Sure they suggest upgr…
581 error on Linux system
When I do a "set explain on" using ISQL . I get this error. I have tried various combinations of DBLANG, so I don't think this is the problem. I have not found any install problems. msg/en_us/0333 exists with message files in it. 581 Error loading message file. This SET EXPLA…
RE: Informix alternate menus
Informix D4gl/ Four Js will allow that in GUI mode. Paul Sergeant. -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Earle A Long Sent: 12 February 2001 14:53 To: informix-list@iiug.org Subject: Re: Informi…
RE: Using MATCHES or LIKE on non-character columns ?
select emp_no from table where emp_no || "" matches "12*" -----Original Message----- From: Bernd Steinhauer [mailto:bernd.steinhauer@dpd.de] Sent: Monday, February 12, 2001 11:23 AM Posted To: informix Conversation: Using MATCHES or LIKE on non-character columns ? Subject: …
System copy/retore via ontape
We are trying to create a copy of a database on a new machine using ontape, but the retore is hanging. onstat - reveals the following message: Informix Dynamic Server Version 7.31.UC2XA -- Fast Recovery (CKPT REQ) -- Up 00:05:38 -- 1065144 Kbytes Blocked:CKPT Is there something…
RE: Stored Procedure
Care to post the code?? Paul Watson # WF Software Ltd # All answers are +44 1435 674629 # pure fantasy +44 1436 678693 # www.wfsoftware.com/informix # > -----Original Message----- > From: Javier Barrachina [mailto:jb…
Backup script? "ontape" utility?
Hi all .. I am new to Informix but an Oracle DBA (7, 8, 8i). I don't have a lot of time to get up to speed on configuring our local Informix server for backups so I am hoping there is a quick and dirty way of backing up this database (so I can come back to it later). We are run…
Using MATCHES or LIKE on non-character columns ?
Hello, I need a query that selects all numeric ids that start with the same number. For example I want to select all rows where emp_no starts with 12, but emp_no is a integer field. emp_no ------- 12 123 120003 123434434 Any help would be appreciated ! Thanks in advance -- *…
RE: Informix free
>Last I checked, they weren't going to fix the PAM "bug" in 7.30 for > >Linux. Solution? Charge me for 9.21. 4GL-7.20 for Linux shipped > >with bugs, too. Solution? Charge me for 7.30. Informix > also insists > >on me purchasing *three* copies of 4GL-7.30... Their QA sucks…
Modem Login
Hi, I am new to this group. I have an old Server running SCO Open Server 5.0.2 with a similarly older version of Informix. I am able to log on to the system via modem but find that Informix severely restricts my capabilities even if I log on as root. Where do I change permission…
RE: database modelling tools
You might want to look into "Power Designer 7.5" by Sybase. It has support for conceptual model, object model and the physical database model. It also has support for Typed tables. Erwin works well, however, does not support long table names or extended data types. Ronald Twa…
Mail list
--=====_98198305731101=_ Content-Type: text/plain; charset="us-ascii" I would like to re-join your mail list. --=====_98198305731101=_ Content-Type: text/html; charset="us-ascii" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/h…
Stored Procedure
Hi everybody, I have a problem using Informix with JavaScript, I can't access to the returning values of a stored procedure when I call it. The ResultSet return always NULL. Could someone help me. Thanks Javier…
Number of LOCKS
Hi all, Is there anyway to limit numbers of locks per user or per process on informix 7.31 Thanks and Regards, Tham…
dbload - memory fault
Hi, we have trouble with dbload utility (Informix ODS 7.10 on SCO OpenServer 5.0.4). Execution of dbload is abnormally terminated with some values of -n key (and with default value). We've seen the message "Memory fault - core dumped". Execution of dbload is finished successfu…
RE: Random number generator
There's one at www.iiug.org or just make an external call to C Paul Watson # WF Software Ltd # All answers are +44 1435 674629 # pure fantasy +44 1436 678693 # www.wfsoftware.com/informix # > -----Original Message---…
RE: Random number generator
There's other relevant stuff at that URL - JL produced something based (AFIK) on the same algorithm used in 'C' libraries. -----Original Message----- From: brown_p_g@my-deja.com [mailto:brown_p_g@my-deja.com] Sent: 11 February 2001 21:15 To: informix-list@iiug.org Subject: Re: R…
RE: Any good informix periodicals/magazines/online ezines?
You mean this stuff comes form off-planet? -----Original Message----- From: Andrew Hamm [mailto:ahamm@sanderson.net.au] Sent: 11 February 2001 22:47 To: informix-list@iiug.org Subject: Re: Any good informix periodicals/magazines/online ezines? Neil Truby wrote in message <964kv…
Re: Installing IDS 7.30.UC7-1
In the release notes it states: Portable Streams Environment (PSE) can be loaded using /usr/sbin/strload command and Asynchronous IO (AIO) device can be enabled (loaded) using either the 'smit' interface or using the command /usr/sbin/mkdev -l aio0. For further informa…
Re: Informix AppPage Editor and Site Manager with Proxyserver
Which proxy is this, are the web and informix servers on the same segment or they separated by the proxy? brett mike@directforce.nl wrote: > > Situation: > > 1 proxyserver > internal network > Web(informix)server Co-located > > And I would like to connect to the webserver thru …
Re: Configuring and starting IDS2000
OK, you`re right. I had in ONCONFIG file erased one char of NETTYPE (onsoctc instead of onsoctcp). ______________________________________________________________ > Od: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > Komu: Marek Novotn� <marek.novotny@centrum.cz> > CC: informix…
Washington Area (DC) Informix Users Group - Training Day 3/21/2001
Washington Area (DC) Informix Users Group ----------------------------------------- Training Day For Informix Database and SQL Users ------------------------------------------------ Wednesday, March 21, 2001 Sponsored by the GMU Department of Information and Software Engineering…
Re: I4GL 7.30 HC5 problem using comments
ramanu@vsnl.com wrote: > > I have read about @ even in the Informix-4GL by Example Ver 4.10 Manual (pg > 622) where it is used to identify a column name of the table instead of a > program variable with the same name. I started using this since 93-94 or so. > I use it on SCO box.…
RE: Diff between 9.21.UC3-1 and 9.21.HC3-1
It is documented in the Informix Guide to SQL Syntax and the Informix FAQ at http://www.smooth1.demon.co.uk/ifaq06.htm#6.44: 6.44 What is a .FCx release of Online? On 21st Oct 1998 com@netinfo-moldova.com (Octav Chiriac) wrote:- The IDS 7.3 SQL Documentation (I don't remember …
RE: Informix free
Informix is a superior product, therefore it requires less servicing/consulting..... -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Ronald Cole Sent: Saturday, February 10, 2001 11:23 PM To: informix-list…
IDS 9.21 FC4
HP-UX 11.0 We have been directed by Tech Support to this release of IDS as containing a fix to an optimiser bug that has caused us recent grief. Does anyone have any views on this release, or any of the releases subsequent to IDS 9.20 FC4, our current version? thanks Neil…
Random number generator
Hi there, I need to create a random number generator in IDS7.31 using SPL. Any ideas, preferably without having to store the 'seed' somewhere and without having to make OS calls? Thanks Ioannis Demetriades…
informix-4gl-uc1 & ids2000 9.2.fc2-1 for tru64
Hello, we will try informix-4gl-uc1 (compiler version) and ids2000-9.2fc2-1 in our digital tur64 server. But I think that informix-4gl-uc1 is 32 bit, and ids2000-9.2fc2-1 is 64 bit, can we use them together? and which compile flag must be set for this kind of 32-64 bit combina…
Re: loading a table more efficiently...
Yes, we notice about a 30% performance hit by using dbspaces for this, but then, raid5 (don't shoot me anyone, it managers policy), zip on the temp disk I wrote to. Problem is that the O/S takes a big hit aswell writing to a filesystem, my recommendation, take the performance hi…
Re: php client --> Informix server
Hi Luigi, I have a similar configuration , and additional, the NewEra runtime package. Here is the required dll. HTH Sorin Ifrim ----- Original Message ----- From: Luigi Casiraghi <lcasi@tiscalinet.it> To: <informix-list@iiug.org> Sent: Friday, February 09, 2001 11:07 PM S…
Posting from the Informix-list
This is a multi-part message in MIME format. ------=_NextPart_000_0026_01C09408.75993D00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi, this would be some fundamental question.... I need some info? What are the differences bet…
SP Question: System Command
What can be my problem if a system command cannot be executed from within an SP on some servers, but it can on others? SE7x, SCO5 One server creates a 668 and 1 error, another creates a 668 and 2 error, a third works fine... with what is designed to be the same config on each s…
Stored Procedure System Command Failure
Any help offered would be greatly appreciated... I'm having a problem with stored procedures running system commands. I get a -668 error (system command cannot be executed) and 1 (Not owner) or 2 (file or directory not found). On one system, I have no probs. Another, I get 66…
Informix free
One little questions...Were i found an Informix release for Linux..free ?…
multiuser application(please help)
sory for my html version, this is text version of my question my question is about data integrity in the client/serveur environnement. My client is a visual basic application and my serveur is nformix 7.30. What is the best way to manage multiuser application. Actually the comp…
Posting from the Informix-list
This is a multi-part message in MIME format. ------=_NextPart_000_002B_01C09372.23BE4200 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable does any know an existing (either a production system or a test system) = installation of Develop…
Posting from the Informix-list
This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C09371.2031DC60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Are there any known issues in using an cursor for INSERT in Informix-4GL = 7.3? ( I am using on …
Re: I4GL 7.30 HC5 problem using comments
I have read about @ even in the Informix-4GL by Example Ver 4.10 Manual (pg 622) where it is used to identify a column name of the table instead of a program variable with the same name. I started using this since 93-94 or so. I use it on SCO box. i really doubt if they are igno…
RE: audit trail suggestion?
The Informix "Trusted Facility" will give you what you want, and a whole lot more! For version 7.3x, check out: http://www.informix.com/answers/english/docs/73ids/4348.pdf The same thing is available for IDS 9.2x. HTH, Paul Mosser -----Original Message----- From: Rafael Padil…
RE: I4GL 7.30 HC5 problem using comments
I've always found sed to very useful in situations like this where you need to make the same basic change to n programs - umm, err provided recompiling is an option. cheers j. > -----Original Message----- > From: Mark D. Stock [mailto:mdstock@mydas.freeserve.co.uk] > Sent: Frid…
Re: Installing IDS 7.30.UC7-1
Adam Hanel wrote: > > Hi All, > > Im trying to install IDS 7.30.UC7-1, on an IBM RS6000 running AIX 4.3. > > after I run the install program and enter in the serial number I go into the > /informix/bin directory to run either "monitor" or "oninit" However this is > all I get. > …
Re: Configuring and starting IDS2000
"Marek Novotn�" wrote: > > Hi, > > I have the big problem. I upgraded Informix SE to IDS 9.2 and I can`t start > it. After configuration of onconfig file and sqlhosts I enter on prompt > following command: > $ oninit -iy > and I get this error message: > $ oninit: Fatal error in …
Re: I4GL 7.30 HC5 problem using comments
ROBERT B VORBROKER wrote: > > Extremely Curious. Did they tell you what --@ was used for in I4GL and > with what version. I've been using Informix 4GL since 1986 and this > is the first I've heard of it. I think you'll find Simon has upgraded to D4GL. These comments are used t…
Installing IDS 7.30.UC7-1
Hi All, Im trying to install IDS 7.30.UC7-1, on an IBM RS6000 running AIX 4.3. after I run the install program and enter in the serial number I go into the /informix/bin directory to run either "monitor" or "oninit" However this is all I get. exec(): 0509-036 Cannot load progr…
php client --> Informix server
Dear all, I have a question for you. Given the following configuration: - One NT machine with Apache 3.14 and php4 (from www.php4.de) installed (the one that should act like client) - One Sco_SV system Release 3.2v5.0.5 with INFORMIX-SE Version 5.10.UD1 (the server) Are …
table space usage
Can someone show me how to find out how big space was allocated for a table and how much has been used? Thanks. Thanh Ngo…
RE: Onmode -F . . . oops!
Thanks for being the bearer of good news. . . . Hopefully not the same version . . . 8-) -----Original Message----- From: William Rice [mailto:ricew@operamail.com] Sent: Friday, February 09, 2001 11:45 AM To: informix-list@iiug.org Subject: RE: Onmode -F . . . oops! I have seen…
CURRENT on AIX
I have IDS 7.31 on AIX 4.3. Does anyone know how to get the CURRENT function to return fractions of seconds. CURRENT year to fraction(5) always returns 00000 as the fraction part.…
RE: chunk / controller mapping on hpux11
I might have something . . . you're looking for something like: Info for /dev/rawspace1 ------------------------- System-level data: Logical layout info: Volume group: vg01 Logical volume number: lvol1 Total size: 2000 Physical layout…
Fwd: multiuser application(please help)
This is a multi-part message in MIME format. ------=_NextPart_000_66e1_10d1_310c Content-Type: text/plain; format=flowed sory for my html version, this is text version of my question my question is about data integrity in the client/serveur environnement. My client is a visual…
building perl DBD::Informix on 9.21
I'm trying to build perl DBD::Informix 1.00.PC1 and it fails to pass tests: perl Makefile.pl make make test t/t83oconn..........ok t/t90ius............Null pointer for lvarchar at /usr/lib/perl5/site_perl/5.005/i386-linux/DBI.pm line 1105. ok t/t91udts...........DBD::Informix::…
Cursor
This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C092F2.BDC63B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi I am using Informix SE 7.24 UC10 and Informix 4GL 7.30 UC1 on SCO = OpenServer 5.0.4 I have …
How to manage the versions of databases ?
Hello, In my company, we sell a huge software that uses huges databases, and we modify the scheme of the databases almost every 3 months. This is very complex to manage for our customers, and we have to manually make big changes in their databases. We are looking for a way to m…
I4GL 7.30 HC5 problem using comments
Hello CDI, hope someone can help with the following problem/opportunity/feature(* delete as appropiate). We have just upgraded one of our test environments to use I4GL 7.30.HC5, and now the I4GL compile fails because we have the following comment line in all our source files (ar…
audit trail suggestion?
Hi, I'm looking for an advice in order to implement an audit trail in INFORMIX. We want to audit who inserts, updates and deletes records in a database. We want to know operation date, user name, table name and record which is afected. Like a reference we are using DELPHI like…
Re: regarding concept of physical logging??
Of course, physical logging becomes close to unused in 9.2 + except in special situations, which of course makes everything clearer :) Will In article <3a81e8e5$1@news.iprimus.com.au>, "Andrew Hamm" <ahamm@sanderson.net.au> wrote: > Mark D. Stock wrote in message <95sktn$s2m$…
wow $10 for each referals and get paid for reading emails make money
hay guys check this out this is so cool u can make so much money just by referals and reading emails its owsome its easy money very easy money all u have to do is take out 5 mins daily and start makeing money http://www.inboxcash.com/$10/referral.asp?id=521016…
Re: unloading a table more efficiently...
Hi Phillip, It took an additional 2 hours to create the indexes for the table with 1 million+ rows and about 500Mb of data. Of course, I ran this on a SPARC5 with 64MB RAM and one 170MHz Sparc processor. You said: > load table from file > change lock mode if needed and create p…
Can Install IDS 9.21 on Windows 2000 Server?
Can I install the IDS.2000 9.21 on Windows 2000 Server? Thank you Alejandro Delu. Sent via Deja.com http://www.deja.com/…
Fw: Connection type for transaction...
I'm posting again because I did not see it on the forum. Perhaps I selected a different "To" address. > > > > > Hi Listers, > > > > I was executing a restore script that drops the target table and the loads > > the records from an ascii file 300 at a time using dbload. > > This i…
Diff between 9.21.UC3-1 and 9.21.HC3-1
This is probably an easy question. Whats the difference between 9.21.UC3-1 and 9.21.HC3-1? Is there a resource somewhere that explains what each character (after the major and minor version numbers) mean? thanks Allen…
RE: equiv to onstat -P in systables?
sysprofile > -----Original Message----- > From: Big Swifty [mailto:kevin_burdish@timeinc.com] > Sent: Thursday, February 08, 2001 1:29 PM > To: informix-list@iiug.org > Subject: equiv to onstat -P in systables? > > > Hey all! > > Is there an equivalent to onstat -P in systables …
chunk / controller mapping on hpux11
All... Just had a quick look in the iiug archive before I reinvent the wheel but nothing, has anyone written anything to dig into hpux11 and report the hardware mapping (controller and channel) for a particular chunk ? Regards Robin Marquis Sent via Deja.com http://www.deja.com…
Database sessions!
Is there a way to close idle database sessions after a certain time?We have too many open database sessions concurrently which most of them are not used by any users anymore.And this causes additional Virtual segments because of a large session pool..I know it has to do with the …
Informix AppPage Editor and Site Manager with Proxyserver
Situation: 1 proxyserver internal network Web(informix)server Co-located And I would like to connect to the webserver thru the proxyserver, but there are no settings in Setnet or anything where I can fill out the proxy. The proxyserver is a normal Windows machine with a cheap …
Re: Informix database (SE on AIX) with Microsoft GUI
Hi Wayne, We have just done a little project doing exactly that (don't ask why). Microsoft Access on Windows 95 onto Informix server (IDS 7.23.UC11, AIX 4.3, RS/6000). Main data table 3 million rows - performance very good. All I needed in addition to what we had was Informix …
Obtain number of Index/Data pages for a table on sysmaster
Hi, Where can I find this Data on SMI or sysmaster. Thanks for your help. Glenn Cummings Saint-Gobain Glass Deutschland ( oncheck -pT <DB>:<Table> ) . . . Type Pages Empty Semi-Full Full Very-Full ---------------- ---------- ---------- --…
Re: informix on Linux 2.4.1
Yes , I have succeeded Using raw device on Redhat 7.0 . because many engineers says Redhat 7.0 is not stable , they recommend Using Redhat 6.2 . thus, I upgrade kernel 2.4 from kernel2.2.16(Redhat6.2) . of course , i read shared memory bug in kernel archive. at kernel 2.2.1…
FW: ON-BAR
Make sure you understand "onbar" before you start testing - when can you do this, when can you do that - eg. physical and logical restores, how they work, etc. There is no easy way out. RTFM. -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-info…
Posting from the Informix-list
How can I subscribe to Tech Note ( Informix Magazine ) ?…
Any good informix periodicals/magazines/online ezines?
Hi all, I was wondering if there are any periodicals out there for Informix like Oracle Magazine ( www.oramag.com ), SQL Server Magazine ( www.sqlmag.com ), and DB2 Magazine ( www.db2mag.com )? Preferably online, but paper is OK. Thanks Fuzzy :-)…
RE: Space on tape
You could try ... use dd to copy from your tape to /dev/null with input block size the same as your archive (tapeblk in onconfig). dd will tell you the number of blocks, hence the volume of data on the tape. MW (Disclaimer - Never done this) -----Original Message----- From:…
multiuser application(please help)
<html> <P>Hi all,</P> <P><FONT style="BACKGROUND-COLOR: #ffffff">my question is about data integrity in the client/serveur environnement. My client is a visual basic application and my serveur is nformix 7.30. </FONT></P> <P><FONT style="BACKGROUND-COLOR: #ffffff">What is the bes…
Actual free space by Chunk/dbspaces
--------------8746F29EEE2D58099CED7F45 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, If anyone out there can let me know the sql syntax that can be use to find out the actual free space by chunk / dbspaces after the data purging (instead of …
Informix JDBC Driver
I am trying to access an Informix database on an Alpha DS10 running Compaq TRU64 v5.0A. I am using Informix's JDBC driver v2.10 JC1 and I am getting segmentation faults whenever I try to make a database connection. Has anyone else come across this problem and if so how did you …