placing tables in db based on user login
IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number AAA#B000000 we are using dbmoto to transfer data to sequal server. Dbmoto creates tables in the dbspace where the db is created. We cant configure dbmoto to create tables in space of our choice Is there a way in informix that we can get tables to be created in a dbpace based on the user ?
No. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 24, 2013 at 7:53 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number > AAA#B000000 > > we are using dbmoto to transfer data to sequal server. > Dbmoto creates tables in the dbspace where the db is created. > We cant configure dbmoto to create tables in space of our choice > Is there a way in informix that we can get tables to be created in a dbpace > based on the user ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c34f5cedcced04e729ec06
Hi KARL, Tables are created by default in the dbspace where the database was created unless you say differently when you create the table or an index for that matter. If you want to create your tables in dbspaces based on the user, you have to write your own script in a shell script for example with the user name as a parameter. I do not know if that is what you want. As far as your dbspaces, they have to exist before table creation. Then again, your script can do that job assuming that chunks have already been created at the OS level. You cannot however configure the engine to do it automatically. I do not know how dbmoto works but since dbmoto is a client to the database engine, how about using the sysdbopen function when the dbmoto tool opens the database; you can try to create the dbspace based on the user name using the task functions provided by the sysadmin database. This is an idea but will it answer your need, I do not know. Even if that works, you have to have chunks created for each user unless you want to group users in a preset number of dbspaces. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 25/09/13 01:53, KARL OLIVER a écrit : > IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number > AAA#B000000 > > we are using dbmoto to transfer data to sequal server. > Dbmoto creates tables in the dbspace where the db is created. > We cant configure dbmoto to create tables in space of our choice > Is there a way in informix that we can get tables to be created in a dbpace > based on the user ? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
What version of DBMOTO are you using? We use DBMOTO to replicate data from Informix to SQL Server. The newer versions of DBMOTO do not create tables on Informix. It uses Change data capture. Regards, Christine Bizukiewicz Shubert Ticketing -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Khaled Bentebal Sent: Wednesday, September 25, 2013 1:15 PM To: ids@iiug.org Subject: Re: placing tables in db based on user login [31511] Hi KARL, Tables are created by default in the dbspace where the database was created unless you say differently when you create the table or an index for that matter. If you want to create your tables in dbspaces based on the user, you have to write your own script in a shell script for example with the user name as a parameter. I do not know if that is what you want. As far as your dbspaces, they have to exist before table creation. Then again, your script can do that job assuming that chunks have already been created at the OS level. You cannot however configure the engine to do it automatically. I do not know how dbmoto works but since dbmoto is a client to the database engine, how about using the sysdbopen function when the dbmoto tool opens the database; you can try to create the dbspace based on the user name using the task functions provided by the sysadmin database. This is an idea but will it answer your need, I do not know. Even if that works, you have to have chunks created for each user unless you want to group users in a preset number of dbspaces. Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Président UGIF - User Group Informix France IIUG - Board of Directors Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 25/09/13 01:53, KARL OLIVER a écrit : > IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number > AAA#B000000 > > we are using dbmoto to transfer data to sequal server. > Dbmoto creates tables in the dbspace where the db is created. > We cant configure dbmoto to create tables in space of our choice Is > there a way in informix that we can get tables to be created in a > dbpace based on the user ? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.