anyone with IBM DB2 experience?

[Net Llama!]

Thanks, that looks good enough to take care of the backup/restore side of
things.  do you have anything for regular maintanence?

On Fri, 28 Feb 2003, Federico Voges wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Fri, 28 Feb 2003 15:32:17 -0300, Federico Voges wrote:
>
> >On Fri, 28 Feb 2003 10:36:47 -0500 (EST), Net Llama! wrote:
> >
> >>I've just inherited a DB2 server (on linux) that has never been backed up,
> >>or had any maintanence performed on it.  I'm fairly green in the DB2
> >>realm, and was wondering if anyone had any pointers on the easiest means
> >>of dumping/backing-up the DB (and then how to restore from said dump), and
> >>also if there are any maintanence or performance improvements that i could
> >>institute as well?  URLs will be good too.
> >>
> >>thanks!
> >>
> >
> >I haven't used DB2 for about 5 years. And that was DB2/2.... but it
> >used to have good online docs. If you have the install CDs, then you
> >should have all the info you need there.
> >
> >If not, I have a couple of trial CDs from developerWorks. I can tar the
> >docs direcotries and send it to you if you like.
> >
>
> Just grabbed one of the CDs and found this:
>
> |42.37 Online Help for Backup and Restore Commands
>
> |Incorrect information appears when you type db2 ? backup. |The correct
> output is:
>
> |BACKUP DATABASE database-alias [USER username [USING password]]
> |[TABLESPACE (tblspace-name [ {,tblspace-name} ... ])] [ONLINE]
> |[INCREMENTAL [DELTA]] [USE TSM [OPEN num-sess SESSIONS]] |
> |TO dir/dev [ {,dir/dev} ... ] | LOAD lib-name [OPEN num-sess
> SESSIONS]]
> |[WITH num-buff BUFFERS] [BUFFER buffer-size] [PARALLELISM n]
> |[WITHOUT PROMPTING]
>
> |Incorrect information appears when you type db2 ? |restore. The
> correct output is:
>
> |RESTORE DATABASE source-database-alias { restore-options | CONTINUE |
> ABORT }";
> |
> |restore-options:";
> |  [USER username [USING password]] [{TABLESPACE [ONLINE] |";
> |  TABLESPACE (tblspace-name [ {,tblspace-name} ... ]) [ONLINE] |";
> |  HISTORY FILE [ONLINE]}] [INCREMENTAL [ABORT]]";
> |  [{USE TSM [OPEN num-sess SESSIONS] |";
> |  FROM dir/dev [ {,dir/dev} ... ] | LOAD shared-lib";
> |  [OPEN num-sess SESSIONS]}] [TAKEN AT date-time] [TO
> target-directory]";
> |  [INTO target-database-alias] [NEWLOGPATH directory]";
> |  [WITH num-buff BUFFERS] [BUFFER buffer-size]";
> |  [DLREPORT file-name] [REPLACE EXISTING] [REDIRECT] [PARALLELISM n]";
> |  [WITHOUT ROLLING FORWARD] [WITHOUT DATALINK] [WITHOUT PROMPTING]";
>
> You should be able to backup to a tape using the db2 command
>
> Federico Voges
> Socio gerente
>
> Intrasoft
> Malabia 2137 14 A
> (1425) Buenos Aires
> Argentina
>
> Te/Fax: 54-11-4833-5182
> e-mail: fvoges at intrasoft.com.ar
> Web: http://www.intrasoft.com.ar
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP SDK 3.0
>
> iQA/AwUBPl+sEhRcJRaVKt4XEQJ9fwCfXJJefJkFRUJpC3k6lZTULjm7o+IAnivb
> 6eWGxPrCKtv/nw+TAaBecOA6
> =N8xG
> -----END PGP SIGNATURE-----
>
>
>
> _______________________________________________
> Linux-users mailing list
> Linux-users at linux-sxs.org
> Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users
>

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman				netllama at linux-sxs.org
Linux Step-by-step & TyGeMo		     http://netllama.ipfox.com