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...
DataBase DataBase DataBase DataBaseDataBase DataBase DataBase DataBase
Porfessional Programmable Database Ver. 2.0
2.1 Million Record Capacity.
Search Rate: 2000/Records/Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Easy to Learn (Typically 30 Seconds)
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Email).
Easy Paypal Online Ordering. See Site Below.
http://www.vehiclerepair.org/dbPro/dbpro.html
Scott:
#DataBase...
DataBase DataBase DataBase DataBaseDataBase DataBase DataBase DataBase
Porfessional Programmable Database Ver. 2.0
2.1 Million Record Capacity.
Search Rate: 2000/Records/Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Easy to Learn (Typically 30 Seconds)
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Email).
Easy Paypal Online Ordering. See Site Below.
http://www.vehiclerepair.org/dbPro/dbpro.html
...
RE: [Informix][Informix ODBC Driver] Database locale information mismatchYou could try issuing the following statement and see what the engine is
configured for.
onstat -g env
This will give you the environment of the engine. I believe it is listed
there what the locale is set to.
David
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of bobkot@gmail.com
Sent: Tuesday, May 23, 2006 7:28 AM
To: informix-list@iiug.org
Subject: [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
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Version 10.00.UC4E is what I am running. How do I determine what the
database was created with ?
I have no customer support - that is me - so where to for the patches ?
Would that be for the IDS or the SDK
This is a multipart message in MIME format.
--=_alternative 0023D97D65257178_=
Content-Type: text/plain; charset="US-ASCII"
To find out what's the database locale in your environment go to the
server in...
RE: Do I have to have an Informix Database?
Bruce,
You have to buy a database from somewhere. But 4Js and Querix offer
versions of the Informix-4GL compiler that will work with other
databases. I think they both give the choice between Informix and
Oracle, and I think DB2. But visit their web-sites to find out the
latest info. Their compilers also work on Windows or UNIX thereby
giving even more flexibility.
Malcolm
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Bruce Truter
Sent: 15 February 2004 03:36
To: informix-list@iiug.org
Subject: Do I have ...
Benchmarking for Informix databaseDear all,
I was wondering if there are any benchmarking tool that I can use to
calculate TPM of an Informix database on a particular server?
Thanks, Peter
...
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.
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 ...
RE: [Maybe spam] Re: Relation of OS user to Informix database
Jonathan... am I correct in thinking that you can't revoke rights from a
user who has those rights because they're a member of public?
Ie, if they don't have the rights assigned with an explicit GRANT
statement, then you can't revoke their rights without revoking public's
rights and then granting permissions to all other users individually?
Cheers
Simon
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Jonathan Leffler
Sent: 25 August 2005 05:24
To: informix-list@iiug.org
Subject: [Maybe spam] Re: Relation of OS user to Informix database user
anupam.mukherjee@gmail.com wrote:
> I had just installed Informix Advanced Server version 10.0 for
> Windows and was checking out the security features. I created two
> operating system users, say A and B, gave both GRANT CONNECT and GRANT
> RESOURCE permissions from the informix DBA user.
First suggestion - don't make user 'informix' the DBA; the user already
has an incredible amount of power (it's God w.r.t IDS). However, this
wasn't a factor in your observations.
When you created the database, was a MODE ANSI database, or a logged or
an unlogged database. I am 95% sure it wasn't MODE ANSI...
> Now, I could access
> the entire database, including both A and B's tables by logging in as
> either of the users.
Yes. By default, in a non-ANSI database, public ...
Re: Start informix database
May be you have more than one Informix's instances
and your missed database was not created in the
instance where you are looking for it.
Send us the content of your sqlhosts file and
the result of :
echo $INFORMIXSERVER
Regards
----- Original Message -----
From: "madiego" <madiego@qf21.com>
To: <informix-list@iiug.org>
Sent: Tuesday, August 03, 2004 1:04 PM
Subject: Start informix database
> Hello,
>
> I had an informix database in the unix server. The server has been
> restarted and now I can't start the database.
&...
RE: Informix database creation
The Raw device of 17Gb will not be useful to you on 7.31.FD6. You need to
create then at 2Gb (maximum sizes are listed in your release notes), or
upgrade to 9.40.
Check onstat -d again...it suggests you have successfully created that
dbspace and are trying to create it again.
MW
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Seweryn
> Sent: Thursday, 7 August 2003 7:57 a.m.
> To: informix-list@iiug.org
> Subject: Informix database creation
>
>
> Hi all,
>
> I'm ...
RE: Rowids in Informix Databases
Vijay
All the tables will have rowids (they must !!), they are not visible
on a normal table view but can be returned by query.
If a table is fragmented (but only if (v7.31) ) it can be created WITH
ROWIDS which will create a separate rowid column.
Why do you need rowids? They tend to be a fudge to cover up poor or
inadequate database design. Don't you have lots of lovely, simple (single
column) primary keys to use to identify your records.
Keith=20
-> -----Original Message-----
-> From: Vijay Kumar [mailto:rudrappa@india.hp.com]
-> Sent: Tuesday, October 12, 20...
Database Database Database Database Software CheapDatabase Database Database Database Software Cheap
Great Datase Software See Website Below.
Ultra Easy to Learn (Typically 30 Seconds)
Professional Programmable Database Ver. 2.3
2.1 Million Record Capacity, (New cond).
Search Rate: 2000 / Records / Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Has Six Seperate Field Sets All Programmable.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Em...
Database Database Database Database Software CheapDatabase Database Database Database Software Cheap
Great Datase Software See Website Below.
Ultra Easy to Learn (Typically 30 Seconds)
Professional Programmable Database Ver. 2.3
2.1 Million Record Capacity, (New cond).
Search Rate: 2000 / Records / Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Has Six Seperate Field Sets All Programmable.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Email).
http://www.vehiclerepair.org/dbPro/dbpro.html
...
Database Database Database Database Software CheapDatabase Database Database Database
Great Datase Software See Website Below.
Ultra Easy to Learn (Typically 30 Seconds)
Professional Programmable Database Ver. 2.3
2.1 Million Record Capacity, (New cond).
Search Rate: 2000 / Records / Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Has Six Seperate Field Sets All Programmable.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Email).
http://w...
Database Database Database Database Software CheapDatabase Database Database Database Software Cheap
Great Datase Software See Website Below.
Ultra Easy to Learn (Typically 30 Seconds)
Professional Programmable Database Ver. 2.3
2.1 Million Record Capacity, (New cond).
Search Rate: 2000 / Records / Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Has Six Seperate Field Sets All Programmable.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Em...
Database Database Database Database Software CheapDatabase Database Database Database Software Cheap
Great Datase Software See Website Below.
Ultra Easy to Learn (Typically 30 Seconds)
Professional Programmable Database Ver. 2.3
2.1 Million Record Capacity, (New cond).
Search Rate: 2000 / Records / Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Has Six Seperate Field Sets All Programmable.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Em...
Database Database Database Database Software CheapDatabase Database Database Database Software Cheap
Great Datase Software See Website Below.
Ultra Easy to Learn (Typically 30 Seconds)
Professional Programmable Database Ver. 2.3
2.1 Million Record Capacity, (New cond).
Search Rate: 2000 / Records / Second.
DataBase Type: Random Access.
Can Create Unlimited Databases.
Programmable fields for any Application.
Has Six Seperate Field Sets All Programmable.
Build Time One Second, (Auto Creates DB).
Setup Time: Instantly, Just Enter DB Name.
Ultra Cheap Price, Special $20, Paypal Accepted.
Application Mailed Instantly (file Attached Em...
RE: [Maybe spam] Re: Relation of OS user to Informix database #2
You can only revoke a privilege that exists explicitly and you are the
GRANTOR, if a user's rights are part of "public" then you cannot prevent the
access unless you revoke connection privileges from public
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: "Gosney Simon" <GosneyS@axxia.com>
>To: "Jonathan Leffler" <jleffler@earthlink.net>, <informix-list@iiug.org>
>Subject: RE: [Maybe spam] Re: Relation of OS user to Informix database
>user
>Date: Thu, 25 Aug 2005 08:48:31 +0100
>
>Jonathan... am I correct in thinking that you can't revoke rights from a
>user who has those rights because they're a member of public?
>
>Ie, if they don't have the rights assigned with an explicit GRANT
>statement, then you can't revoke their rights without revoking public's
>rights and then granting permissions to all other users individually?
>
>Cheers
>
>Simon
>
>-----Original Message-----
>From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
>On Behalf Of Jonathan Leffler
>Sent: 25 August 2005 05:24
>To: informix-list@iiug.org
>Subject: [Maybe spam] Re: Relation of OS user to Informix database user
>
>anupam.mukherjee@gmail.com wrote:
> > I had just installed Informix Advanced Server version 10.0 f...
a database, is a database, is a err databaseHow many times can we see the same request from someone who wants to access
data from a 'pick' database through what has come to be 'standard' practices
(odbc, oledb)
and still get the same old sloppy ' buy this proprietary utility (and above
all, my services)' answer. I think most of these pick flavors should have
some sort of layer (by now!) to handle this; If someone needs to do this,
the service is really 'education' i.e to show them how. Lets cut the shit
now and stop with this tired and silly BS and sad marketing schlock.
Regards,
-Jim
Jim wrote:
> How many times can we see the same request from someone who wants to
> access data from a 'pick' database through what has come to be
> 'standard' practices (odbc, oledb)
> and still get the same old sloppy ' buy this proprietary utility (and
> above all, my services)' answer. I think most of these pick flavors
> should have some sort of layer (by now!) to handle this; If someone
> needs to do this, the service is really 'education' i.e to show them
> how. Lets cut the shit now and stop with this tired and silly BS and
> sad marketing schlock.
>
> Regards,
>
> -Jim
Jim who? I wonder?
What is this? An attack on capitalism? Providing services for those
who perhaps lack the time, skill, or knowledge to perform such tasks is
hardly a crime.
Maybe "standard" odbc and...
RE: change the owner of a database in informix
Don�t post HTML.
You do not have a choice on the owner of a database.
If you want to change the owner of a table, index, etc drop and recreate it.
MW
________________________________
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org] On Behalf Of
Muthana.AL-Temimi@tu-harburg.hamburg.de
Sent: Thursday, 3 February 2005 3:49 a.m.
To: informix-list@iiug.org
Subject: change the owner of a database in informix
Hello there,
i would like to change the owner of the database in Informix:
for example: I have the database called �SOSPOS�
and the owner of it the user �informix�. Now I would like to change
it to another name:
For example: �sosx�
Regards,
Muthana
-------------------------------------------------------------------
Muthana AL-Temimi TUHH - IuK-Referat
Schlo�m�hlendamm 32 21073 Hamburg
Email:
muthana.al-temimi@tu-harburg.hamburg.de
Tel.: 040 428 78 3294
EFax: 040 4279 35 160
sending to informix-list
The owner of a database is the user who created the database. So you
have to drop and recreate the database.
As user informix:
$ dbexport -ss sospos
then drop the database ($ echo 'drop database sospos|dbaccess -)
Change to user sosx (su sosx)
$ dbimport sospos
That's it!
Murray Wood (IList) wrote:
> Don�t post HTML.
>
...
Re: Informix database creation #3
Seweryn:
When you run "onstat -d" - it gives size in terms of blocks (pagesize). It
can be 2K or 4 K depending upon OS.
You can find out the page size using "onstat -b | grep 'buffer' | awk
'{print $10}' " - this will return page size in BYTES .
When you create the dbspace using onspaces - you need to mention the size
of the dbspace interms of "KBytes"
example: In your OS, if you have Page size 2K - then you need to start the
offset from 1200000, you can go only upto
800000 KB size of dbspace due to 2GB size limitation.
try thi...
[Informix][Informix ODBC Driver] Database locale information mismatchI 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...
Re: Informix database creation #4
Well I dont know! I was given this advice from Infomix Support Group only
Ravinder Bahadur
_________________________________________________________________
It's raining movies. Bollywood is flooded.
http://server1.msn.co.in/features/augustmovies03/index.asp August has
arrived!
sending to informix-list
...
Re: Storing password in informix database
If you are on 9.x versions (with the WEB Datablade installed) , you can use
a function called webpwcrypt which will encrypt your password and store it
in the database. Otherwise, I would assume you'll have to write your own
algorithm to do the same.
The usage is as follows:
select webpwcrypt(password,2194) from user
where the second parameter is some kind of a seed# to generate the
encrypted password.
HTH.
Thanx much,
Rajib Sarkar
Advisory Support Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
As long as you derive ...