f



informix databases (dbaaccess)(Informix-SE)

How to get the informix databases. i tried to get from net but i didnot
get . the ibm site is asking for password. how can we get it . i am
asking this because we can de database acess from unix shell scrpting
using informix databses. do any one know how to install and download
the dbaaccess or informix SE.

0
uday
9/10/2004 7:02:07 AM
comp.unix.shell 15484 articles. 2 followers. Post Follow

2 Replies
923 Views

Similar Articles

[PageSpeed] 44

uday <kariudaykiran@yahoo.co.in> wrote:
> How to get the informix databases. i tried to get from net but i didnot
> get . the ibm site is asking for password.

Type your password.

> how can we get it . i am asking this because we can de database acess
> from unix shell scrpting

So can you with MySQL, PostgreSQL, SQLite, etc.

> using informix databses. do any one know how to install and download
> the dbaaccess or informix SE.
0
William
9/10/2004 12:52:59 PM
On 10 Sep 2004 00:02:07 -0700, uday wrote:

> How to get the informix databases. i tried to get from net but i didnot
> get . the ibm site is asking for password. how can we get it . i am
> asking this because we can de database acess from unix shell scrpting
> using informix databses. do any one know how to install and download
> the dbaaccess or informix SE.

http://www-306.ibm.com/software/data/informix/howtobuy/
0
Adam
9/10/2004 7:24:35 PM
Reply:

Similar Artilces:

How to copy a sun-database in one informix database to another informix database?
Hi, Sorry I am not an informix dba, and I was faced to copy a sub-database(sorry I don't know the clear name of such concept, as informix is like sql-server, which used multiple database) from one informix database system to another informix database. I know in oracle, we can use transportable tablespace, copy the datafile and transport the metadata, and do something else. How can I do it in informix then? Is there document which talk about the detail step? Thanks It would really help if you knew the versions of the Informix databases. Assuming Informix IDS 7.x or IDS 9.x If the two systems are binary compatible the fastest method is to use onunload/onload. If the systems are not binary compatible the easiest way is to use dbexport/dbimport. Everything is well documented in the manual "IBM Informix Migration Guide". This manual covers all Informix databases from Standard Engine and Online to IDS and XPS. See http://www.ibm.com/informix/pubs zhu chao wrote: > Hi, > Sorry I am not an informix dba, and I was faced to copy a > sub-database(sorry I don't know the clear name of such concept, as > informix is like sql-server, which used multiple database) from one > informix database system to another informix database. > I know in oracle, we can use transportable tablespace, copy the > datafile and transport the metadata, and do something else. How can I > do it in informix then? Is there...

RE: Moving Data from Informix SE 4 to Informix SE 7 #3
> > > > Great, I did not know this could be done, thanks. Every > minute could > > be important, and this will make the RCP transfer between > the servers > > finish much more quickly. > > > To save more time - unload | compress | rcp | uncompress > And another possibility, which may be even faster than this, is to use Art's "dbcopy" utility. It copies data directly from one database table in one to another (different databases / instances / hosts), without going thru intermediate flat files or tape. Multiple tables can be copied in concurrently. I've used this many times successfully. Because there are no flat files, there is no need to worry about file size limits. As many others have already stated, the data should be loaded (copied) into the new tables *before* indexes and constraints are rebuilt. You may need to verify with Mr. Kagel that his utility will work OK from SE4 to SE7 (I'd be very surprised if it doesn't). "dbcopy" is part of Art's utils2_ak package available on the www.iiug.org site. HTH, Paul Mosser sending to informix-list ...

[Informix][Informix ODBC Driver] Database locale information mismatch
I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server This is a multipart message in MIME format. --=_alternative 0046812965257177_= Content-Type: text/plain; charset="US-ASCII" I am guessing that you are using 10.00.xC4 or the version where you have fix for 171156 IDS defect. Basically this bug fix will enforce the correct database locale setting from client (i.e. ODBC etc). If you supply the (default is en_US.1252) correct database locale(that is actually the database created with) in ODBC DSN(or your connection string) then your connection should go through. However in ODBC side as well we have the corresponding fix in place. Ask your customer support to get the patch of ODBC defects 175110 and 175746. These ODBC fixes will automatically take care of getting the correct database locale value for the given database (through DSN). Thanks & Regards -Shesh bobkot@gmail.com Sent by: informix-list-bounces@iiug.org 05/23/2006 05:58 PM To informix-list@iiug.org cc Subject [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.T...

Error executing remote system command on an AIX Informix database from an NT Informix Server
Dear All, I realise there are many queries and answers already posted on a similar topic, but none seem to be able to get this working. I have two informix servers, one on Windows NT and one on AIX 4.3. Informix NT (7.31) Informix AIX (7.xx) I have a stored procedure on the unix box with a system command SYSTEM '/usr/bin/ksh /usr/bin/env > /tmp/mylog' I have set up the trust, so that I can connect to the AIX instance as informix from the NT server. I connect from the NT server to the AIX instance as informix and execute the procedure. I get the following error - 668 Command cannot be executed 127 No Primary Key I think that the 127 error number is from the shell execution. The /tmp/mylog file is created but with no values. Even if I replace it with an echo hello command I get an empty file. Having read one of Jonathan Leffler's responses, the SHELL environment variables needs to be set to the the Shell of the remote system. In my case that is 'set SHELL=/usr/bin/ksh' . I did this and it still didn't work. Am I missing further environment variables as I am executing the procedure from NT. Has anyone managed to do this? Many thanks in advance, Nick Have you tryed it on aix itself?? does that work?? try: SYSTEM "(/usr/bin/ksh /usr/bin/env 2>&1) > /tmp/nonexistingfile"; -- check what is in nonexistingfile or SYSTEM "(/usr/bin/ksh ...

How to keep an Informix database connection open in a shell script?
Using dbaccess I am trying to keep a database connection open in a shell script until I want to close it. It may be easiest to explain what I'm trying to do with a simple shell script which works fine for DB2. db2 -v "connect to $DATABASE" db2 -v "set current schema dba" db2 -v "create table test (col1 int not null) in userspace1" while [ $i -le 10 ] do db2 -v "insert into test(col1) values($i)" (( i=i+1 )) done db2 -v "commit work" db2 -v "connect reset" db2 -v "terminate" If I try similar logic with informix, the database is repeatedly opened and closed: echo "database $DATABASE;" |dbaccess Database selected. Database closed. echo "insert into test(col1) values($i);" | dbaccess -e $DATABASE Database selected. insert into test(col1) values(1); 1 row(s) inserted. Database closed. With Informix's dbaccess, is there a way I can open the database once, perform the inserts, and then close the database, similar to the way I can for DB2? Thanks. --_10ba0c1c-0ac1-4468-a373-57b4eafed8fb_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Try using the sqlcmd suite of tools available from the iiug repository. Signature > Date: Wed=2C 29 Aug 2012 00:05:43 -0700 > Subject: How to keep an Informix database connection open in a shell scri= pt? > From: davies...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312314407)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312314407) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312314407. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312357781)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312357781) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312357781. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45311750142)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45311750142) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45311750142. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313257603)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313257603) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45313257603. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312614408)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312614408) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312614408. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312357781)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312357781) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312357781. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312957609)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312957609) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312957609. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312014404)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312014404) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312014404. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312657606)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312657606) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312657606. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313214402)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313214402) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45313214402. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312357781)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312357781) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312357781. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312057604)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312057604) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312057604. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312632404)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312632404) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312632404. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313214402)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313214402) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45313214402. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45311750142)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45311750142) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45311750142. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312914404)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45312914404) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45312914404. ...

US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313214402)
US-TX-Dallas: Informix DBA, Informix DBA (certification preferred), Unix; 18 wee (45313214402) ============================================================================================== Position: Informix DBA Reference: JGG00093 Location: Dallas TX Duration: 18 wee Skills: Informix DBA (certification preferred), Unix Scope: Support the administration of Informix in a Unix environment Please send your current resume in confidence to "Jimmy Goolsby" <JGoolsby@EuroSoft-Inc.Com> ..45313214402. ...

Informix 7.25 SE on Digital Unix 5.1
Hi all, We testing in order to migrate to Informix 7.25 SE (yes, a bit old) on a Dec Tru64 5.1 and found some performance issues. The previuos instante was running in a DecUnix 4.0d with Informix 7.24 SE in a less powerful machine. Testing the same query on both boxes, in the 7.25-Tru5.1 one it takes about 20 secs to complete and in the old one results are almost inmediate. DB has been imported from unload recently and should have no degradation. We have some issues with 7.25 and C2 security and seemed to be resolved, turning it off for informix user. We have no idea of what can be causing this delay. No disk bottleneck is found (no I/O traffic or swapping) The only strange thing is that kernel activity raises more (20% or so) than the old version on 4.0d Any ideas for this performance issue? Regards Carlos Carlos Alonso wrote: > Hi all, > > We testing in order to migrate to Informix 7.25 SE (yes, a bit old) > on a Dec Tru64 5.1 and found some performance issues. The previuos > instante was running in a DecUnix 4.0d with Informix 7.24 SE in a less > powerful machine. > > Testing the same query on both boxes, in the 7.25-Tru5.1 one it takes > about 20 secs to complete and in the old one results are almost > inmediate. DB has been imported from unload recently and should have > no degradation. > > We have some issues with 7.25 and C2 security and seemed to be > resolved, turning it off f...

Informix Informix :: Rumors and other tales
Rumor has it that the latest upcoming download of IDS at the IIUG website will not have a timebomb... very cool. This is something that IIUG President Stuart Litel has apparently pulled off for all the versions..."They are a 5 process limit and will be available for Linux, Windows, AIX, SUN and HP (Itanium 64 bit)" ... ( I don't know any more than that don't ask me... :-) No - this is something that Carolyn Woods pulled off when she was the IBM Liason to the IIUG, and then Christine Normile continued when she was product manager. They both were vetoed by the President of the IIUG himself. Carolyn finally gave up (I've known Carolyn since the beginning of time - she doesn't "give up" on anything). He didn't want users to have to fill out a form to get the download - we'll see if that has to happen or not when 10.5 comes out. DE - you should run for President of the IIUG this year...you have knack for stating rumor as fact ("...something that SL pulled off apparently...."). Too bad someone from the current board that knows all the details of these "events" doesn't speak up - the story is pretty clear and simple. Mark Scranton Informix 1995-2006 Double Echo wrote: > Rumor has it that the latest upcoming download of IDS at the IIUG website will not have a timebomb... very cool. This is something that IIUG President Stuart Litel has apparently pulled off for all the versions......

Web resources about - informix databases (dbaaccess)(Informix-SE) - comp.unix.shell

Resources last updated: 3/16/2016 11:41:01 PM