anyone with IBM DB2 experience?

[Federico Voges]

-----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-----