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: [EMAIL PROTECTED]
> 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
> [EMAIL PROTECTED]
> Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lonni J Friedman [EMAIL PROTECTED]
Linux Step-by-step & TyGeMo http://netllama.ipfox.com
_______________________________________________
Linux-users mailing list
[EMAIL PROTECTED]
Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users
