dbexport

I ran this command and got database name is missing in the .out file Any ideas? dbexport -s <database name> &

Database name is not part of the export file normally. You provide all the options for creating the database on the command line to dbimport. dbimport -d <database> Of course it will be looking for the directory <database>.exp and the file within it <database>.sql cheers j. > On Feb 1, 2018, at 4:36 PM, BENJI LONG <ruggedmouse@hotmail.com> wrote: > > I ran this command and got database name is missing in the .out file > > Any ideas? > > dbexport -s <database name> &> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

How do I find out if it worked properly?

You should have a <database>.exp folder. In that should be a <database>.sql file and a <tabna>999.unl for each table in the database. The file name will = have the first 4 or 5 letters of the table name the end of the filename = will be the tabid for the table. The number of records in each unl file should match the number of rows = in each table. You should check out the doc on dbimport - for the database create = options, specifically, what dbspace to create the database in, but = logging mode is also important. dbimport <database> [-X] [-c] [-q] [-d <dbspace>] [-l [{ buffered }] [-ansi]] [-ci] [-nv] [-D] [{ -i <dir> | -t <tapedev> [ -b <blksz> -s <tapesz> ] [-f = <script-file>] }] arguments to dbimport are order independent cheers j. > On Feb 1, 2018, at 4:44 PM, BENJI LONG <ruggedmouse@hotmail.com> = wrote: >=20 > How do I find out if it worked properly?=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

Ok, thanks I will have a look tomorrow

I'm sure that it just errored out. I think you meant to run this: dbexport -d database -ss If you really intended to run it in the background, try this: dbexport -d database -ss > thisexport.out 2> thisexport.err & That would create a file with the standard output and one with any error messages. For myself, I would run it in the background, unless I can only have one terminal session on my server. --EEM For more information on the dbexport command: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.mig.doc/ids _mig_116.htm -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Thursday, February 1, 2018 3:36 PM To: ids@iiug.org Subject: dbexport [40623] I ran this command and got database name is missing in the .out file Any ideas? dbexport -s <database name> & ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

The sentence below should say "wouldn't." That would create a file with the standard output and one with any error messages. For myself, I would run it in the background, unless I can only have one terminal session on my server. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Everett Mills Sent: Thursday, February 1, 2018 4:15 PM To: ids@iiug.org Subject: RE: dbexport [40628] [This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing at http://aka.ms/LearnAboutSpoofing] I'm sure that it just errored out. I think you meant to run this: dbexport -d database -ss If you really intended to run it in the background, try this: dbexport -d database -ss > thisexport.out 2> thisexport.err & That would create a file with the standard output and one with any error messages. For myself, I would run it in the background, unless I can only have one terminal session on my server. --EEM For more information on the dbexport command: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.mig.doc/ids _mig_116.htm -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of BENJI LONG Sent: Thursday, February 1, 2018 3:36 PM To: ids@iiug.org Subject: dbexport [40623] I ran this command and got database name is missing in the .out file Any ideas? dbexport -s <database name> & ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

I think '-d database' is dbschema syntax, not dbexport, -d there means (meant actually): don't unload optical blobs and put blob descriptors instead.

thank you. I was too lazy to look it up. j. > On Feb 2, 2018, at 3:23 AM, Andreas Legner1 <Andreas.Legner1@de.ibm.com> wrote: > > I think '-d database' is dbschema syntax, not dbexport, -d there means > (meant actually): don't unload optical blobs and put blob descriptors > instead. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

dbimport <database> -d <dbspace> Mit freundlichem Gruß Reinhard Habichtsberg Dienstleistungsverantwortlicher IT-Rechenzentrum Solaris- und Datenbanksysteme --203 -----Ursprüngliche Nachricht----- Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Im Auftrag von Jack Parker Gesendet: Freitag, 2. Februar 2018 13:27 An: ids@iiug.org Betreff: Re: dbexport [40636] thank you. I was too lazy to look it up. j. > On Feb 2, 2018, at 3:23 AM, Andreas Legner1 > <Andreas.Legner1@de.ibm.com> wrote: > > I think '-d database' is dbschema syntax, not dbexport, -d there means > (meant actually): don't unload optical blobs and put blob descriptors > instead. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

my command doesn't seem to work. Reading the documentation...

I got this one figured out. My command was wrong. I had: nohup dbexport –s <database> & Supposed to be: nohup dbexport –ss <database> &