dbimport

Hi All, While importing the database using dbimport, How we can specify new DBspace location for import? Thx,

Tell us Operational System, version ... IDS version... Well .... if you type: dbimport --- you'll see the 'help' of the command... You can see ' -d dbspace ' to redirect the catalog of that database to specific database. BUT , if you have a create table (col1, col2.... coln) in DBSPACE, the table (and indexes) will reside in that dbspace. IF "in dbspace" is not mentioned in create table statement, the table will be created in the same dbspace as the database. If the statement "create <unique> | <cluster> index .... on .. table ... in dbspace, the index will use pages in the "dbspace" specified (detached indexes) ... if not, the indexes will be in the same dbspace as the table or sure, the same as the database if not specified in create table. BR R Ferronato > To: ids@iiug.org > From: djoshih@hotmail.com > Subject: dbimport [17374] > Date: Tue, 6 Oct 2009 10:48:38 -0400 > > Hi All, > > While importing the database using dbimport, How we can specify new DBspace > location for import? > > Thx, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social- network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_3:092010

dbimport database_name -d new_dbpace João Ricardo Oliveira ----- Original Message ----- From: "DEEPAK JOSHI" <djoshih@hotmail.com> To: <ids@iiug.org> Sent: Tuesday, October 06, 2009 10:48 AM Subject: dbimport [17374] > Hi All, > > While importing the database using dbimport, How we can specify new > DBspace > location for import? > > Thx, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

dbimport -d new_dbspace .... Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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, Oct 6, 2009 at 10:48 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote: > Hi All, > > While importing the database using dbimport, How we can specify new DBspace > location for import? > > Thx, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747beea1e5a3c047545db9a

2009/10/6 DEEPAK JOSHI <djoshih@hotmail.com>: > Hi All, > > While importing the database using dbimport, How we can specify new DBspace > location for import? > > Thx, > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Deepak You really do need to either start reading some manuals or get some training, the vast majority of the questions you have posted over the past two or three weeks could have been answered by reading the manuals, by googleing existng answers on c.d.i. use list or (as in this case) by typing -? as a paramenter and getting the program help line :- Usage: dbimport <database> [-X] [-c] [-q] [-d <dbspace>] [-l [{ buffered | <log-file> }] [-ansi]] [{ -i <dir> | -t <tapedev> [ -b <blksz> -s <tapesz> ] [-f <script-file>] }] NOTE: <log-file> must be a complete path arguments to dbimport are order independent People will start to get upset if you prevail on their good auspices too much (especially with an ID version that is so so old and unsupported !!). Keith

Hi, You can edit the SQL file inside the yourdb.exp directory. You can add "in dbspacename", there dbspacename, is your preferred dbspace your table will be written. Once done, you can do the dbimport, check the parameters posted earlier. Thank you.