Discussion:
Complete Newbie
(too old to reply)
Jeremy Smith
2015-09-23 07:08:43 UTC
Permalink
Raw Message
Hello, i'm an Oracle DBA and have just been given a Linux Server with dan Informix database on.

I haven't a clue how to access it. Can anyone tell me how.
Ultimately I need to extract the data.

For now i'd just like to do a select query or something!!
I haven't bee given any passwords but i'm thinking you might be able to use OS authentification like Oracle

I've Googled a lot but can't find anything remotely helpful.

I found these commands and here is the output

[***@webdad /]# dbaccess -V
DB-Access Version 7.25.UC6R1

[***@webdad /]# isql -V
IBM INFORMIX-SQL Version 7.32.UC3


thanks for your help.

Jeremy
Mike Walker
2015-09-23 13:49:46 UTC
Permalink
Raw Message
Hi Jeremy,

You will likely be using OS authentication, but you do need a user that has
privilege to get to the database.

First off, try running dbaccess (with no options). Choose Query, then
Database.

Select a database that you want to use (hopefully you can see one you are
looking for).

Go to Use-Editor, or New and type in something like:

select * from systables;

Exit out of the editor and choose "Run".

If that went well, you should be looking at some information on tables.

There are different ways to do unloads. For small, simple tables just use
SQL:

unload to mytable.unl select * from mytable;

This will unload the records to a pipe-delimited ASCII file.

For larger tables you will want to use High Performance Loader or External
Tables.

To unload the entire database look into the "dbexport" command (note that
this does lock the database while it runs).

Also to check on things, take a look at the "onstat" command. Run onstat -?
To see the options.

For example:

onstat - : will show if the instance (a collection of
databases/memory/etc) is On-Line or not
onstat -u : will show connections
onstat -m : will show the end of the Informix log file

There's a bit much to cover in a list post, but hopefully this will get you
started!

Mike
Advanced DataTools



-----Original Message-----
From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org]
On Behalf Of Jeremy Smith
Sent: Wednesday, September 23, 2015 1:09 AM
To: informix-***@iiug.org
Subject: Complete Newbie

Hello, i'm an Oracle DBA and have just been given a Linux Server with dan
Informix database on.

I haven't a clue how to access it. Can anyone tell me how.
Ultimately I need to extract the data.

For now i'd just like to do a select query or something!!
I haven't bee given any passwords but i'm thinking you might be able to use
OS authentification like Oracle

I've Googled a lot but can't find anything remotely helpful.

I found these commands and here is the output

[***@webdad /]# dbaccess -V
DB-Access Version 7.25.UC6R1

[***@webdad /]# isql -V
IBM INFORMIX-SQL Version 7.32.UC3


thanks for your help.

Jeremy
Jeremy Smith
2015-09-24 00:08:04 UTC
Permalink
Raw Message
Hey Mike,
thanks for your reply.

so it looks like I have a problem getting into dbaccess ..

[***@webdad ~]# dbaccess
Termcap entry too long
Termcap entry too long
Segmentation fault

I'm using putty.
I read an article that said switch scrolling off, so I changed it to zero. No luck.

I've also tried VNC and that doesn't work either.
I've tried the terminal in VMWare Vsphere (this is a virtualized copy of the actual environment) - still same error

Any ideas?

thanks
Jeremy
Post by Mike Walker
Hi Jeremy,
You will likely be using OS authentication, but you do need a user that has
privilege to get to the database.
First off, try running dbaccess (with no options). Choose Query, then
Database.
Select a database that you want to use (hopefully you can see one you are
looking for).
select * from systables;
Exit out of the editor and choose "Run".
If that went well, you should be looking at some information on tables.
There are different ways to do unloads. For small, simple tables just use
unload to mytable.unl select * from mytable;
This will unload the records to a pipe-delimited ASCII file.
For larger tables you will want to use High Performance Loader or External
Tables.
To unload the entire database look into the "dbexport" command (note that
this does lock the database while it runs).
Also to check on things, take a look at the "onstat" command. Run onstat -?
To see the options.
onstat - : will show if the instance (a collection of
databases/memory/etc) is On-Line or not
onstat -u : will show connections
onstat -m : will show the end of the Informix log file
There's a bit much to cover in a list post, but hopefully this will get you
started!
Mike
Advanced DataTools
-----Original Message-----
On Behalf Of Jeremy Smith
Sent: Wednesday, September 23, 2015 1:09 AM
Subject: Complete Newbie
Hello, i'm an Oracle DBA and have just been given a Linux Server with dan
Informix database on.
I haven't a clue how to access it. Can anyone tell me how.
Ultimately I need to extract the data.
For now i'd just like to do a select query or something!!
I haven't bee given any passwords but i'm thinking you might be able to use
OS authentification like Oracle
I've Googled a lot but can't find anything remotely helpful.
I found these commands and here is the output
DB-Access Version 7.25.UC6R1
IBM INFORMIX-SQL Version 7.32.UC3
thanks for your help.
Jeremy
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Mike Walker
2015-09-24 01:30:52 UTC
Permalink
Raw Message
Jeremy,

Try setting:

export INFORMIXTERM=terminfo

and trying again.

If that doesn't work, you may need to try different values for TERM,

E.g.:

export TERM=vt100 or export TERM=vt220

Hopefully you find an entry that works with your terminal and doesn't have a
long termcap entry.

Mike

-----Original Message-----
From: informix-list-***@iiug.org [mailto:informix-list-***@iiug.org]
On Behalf Of Jeremy Smith
Sent: Wednesday, September 23, 2015 6:08 PM
To: informix-***@iiug.org
Subject: Re: Complete Newbie

Hey Mike,
thanks for your reply.

so it looks like I have a problem getting into dbaccess ..

[***@webdad ~]# dbaccess
Termcap entry too long
Termcap entry too long
Segmentation fault

I'm using putty.
I read an article that said switch scrolling off, so I changed it to zero.
No luck.

I've also tried VNC and that doesn't work either.
I've tried the terminal in VMWare Vsphere (this is a virtualized copy of the
actual environment) - still same error

Any ideas?

thanks
Jeremy
Post by Mike Walker
Hi Jeremy,
You will likely be using OS authentication, but you do need a user
that has privilege to get to the database.
First off, try running dbaccess (with no options). Choose Query, then
Database.
Select a database that you want to use (hopefully you can see one you
are looking for).
select * from systables;
Exit out of the editor and choose "Run".
If that went well, you should be looking at some information on tables.
There are different ways to do unloads. For small, simple tables just use
unload to mytable.unl select * from mytable;
This will unload the records to a pipe-delimited ASCII file.
For larger tables you will want to use High Performance Loader or
External Tables.
To unload the entire database look into the "dbexport" command (note
that this does lock the database while it runs).
Also to check on things, take a look at the "onstat" command. Run onstat -?
To see the options.
onstat - : will show if the instance (a collection of
databases/memory/etc) is On-Line or not
onstat -u : will show connections
onstat -m : will show the end of the Informix log file
There's a bit much to cover in a list post, but hopefully this will
get you started!
Mike
Advanced DataTools
-----Original Message-----
On Behalf Of Jeremy Smith
Sent: Wednesday, September 23, 2015 1:09 AM
Subject: Complete Newbie
Hello, i'm an Oracle DBA and have just been given a Linux Server with
dan Informix database on.
I haven't a clue how to access it. Can anyone tell me how.
Ultimately I need to extract the data.
For now i'd just like to do a select query or something!!
I haven't bee given any passwords but i'm thinking you might be able
to use OS authentification like Oracle
I've Googled a lot but can't find anything remotely helpful.
I found these commands and here is the output
DB-Access Version 7.25.UC6R1
IBM INFORMIX-SQL Version 7.32.UC3
thanks for your help.
Jeremy
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
s***@t-online.de
2015-09-24 17:18:15 UTC
Permalink
Raw Message
Hello Jeremy

Do not know if your env is setup correctly. Assume user informix should have the correct stuff. so a su - informix should do. If not kick your predecessor where it hurts.

anyway

which dbaccess
this will tell where it is installed.

eq /opt/informix/bin/dbaccess
you have to make sure INFORMIXDIR is set in this case
export INFORMIXDIR=/opt/informix

Then you can either have a look in $INFORMIXDIR/etc/termcap or
export TERM=vt100
export TERMCAP=$INFORMIXDIR/etc/termcap

cd $INFORMIXDIR/etc



If INFORMIXSERVER env var is set then you can start dbaccess
if not then
have a look in a file called sqlhosts

In there there should be a line which has the hostname or ip adress of your machine. The first word of this line is an INFORMIXSERVER.

so
export INFORMIXSERVER=<theonefound>



now you should be able to start dbaccess.

have a look at dbexport to extract the data. (Hopefully not to migrate away from informix.)

also dbschema to dump the sql, and within dbaccess unload to select * from


Superboer.
Post by Mike Walker
Jeremy,
export INFORMIXTERM=terminfo
and trying again.
If that doesn't work, you may need to try different values for TERM,
export TERM=vt100 or export TERM=vt220
Hopefully you find an entry that works with your terminal and doesn't have a
long termcap entry.
Mike
-----Original Message-----
On Behalf Of Jeremy Smith
Sent: Wednesday, September 23, 2015 6:08 PM
Subject: Re: Complete Newbie
Hey Mike,
thanks for your reply.
so it looks like I have a problem getting into dbaccess ..
Termcap entry too long
Termcap entry too long
Segmentation fault
I'm using putty.
I read an article that said switch scrolling off, so I changed it to zero. No luck.
I've also tried VNC and that doesn't work either.
I've tried the terminal in VMWare Vsphere (this is a virtualized copy of the
actual environment) - still same error
Any ideas?
thanks
Jeremy
Post by Mike Walker
Hi Jeremy,
You will likely be using OS authentication, but you do need a user
that has privilege to get to the database.
First off, try running dbaccess (with no options). Choose Query, then
Database.
Select a database that you want to use (hopefully you can see one you
are looking for).
select * from systables;
Exit out of the editor and choose "Run".
If that went well, you should be looking at some information on tables.
There are different ways to do unloads. For small, simple tables just use
unload to mytable.unl select * from mytable;
This will unload the records to a pipe-delimited ASCII file.
For larger tables you will want to use High Performance Loader or
External Tables.
To unload the entire database look into the "dbexport" command (note
that this does lock the database while it runs).
Also to check on things, take a look at the "onstat" command. Run onstat
-?
Post by Mike Walker
To see the options.
onstat - : will show if the instance (a collection of
databases/memory/etc) is On-Line or not
onstat -u : will show connections
onstat -m : will show the end of the Informix log file
There's a bit much to cover in a list post, but hopefully this will
get you started!
Mike
Advanced DataTools
-----Original Message-----
On Behalf Of Jeremy Smith
Sent: Wednesday, September 23, 2015 1:09 AM
Subject: Complete Newbie
Hello, i'm an Oracle DBA and have just been given a Linux Server with
dan Informix database on.
I haven't a clue how to access it. Can anyone tell me how.
Ultimately I need to extract the data.
For now i'd just like to do a select query or something!!
I haven't bee given any passwords but i'm thinking you might be able
to use OS authentification like Oracle
I've Googled a lot but can't find anything remotely helpful.
I found these commands and here is the output
DB-Access Version 7.25.UC6R1
IBM INFORMIX-SQL Version 7.32.UC3
thanks for your help.
Jeremy
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Loading...