anyone with IBM DB2 experience?

[Federico Voges]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

All I have is one of those developerWorks CDs. And it has DB2 v7, not
v8.

Just found this on IB
web:

http://www14.software.ibm.com/webapp/download/product.jsp?s=c&id=TDUN-49
EVGU&sb=r&cat=data&fam=&rs=&S_TACT=&S_CMP=&q=Enter+search+text&k=any&pf=
Linux&x=14&y=12&dt=&v=

- From there, you can download v8.1 (registration required). From the
size of the downloads, the should include the docs.

Otherwise, I have installed the docs in my home server:
http://www.shadowsun.com.ar/~fvoges/db2/doc/en/

Send me a private mail when you're done so I can remove those files ;)

Those are v7.2 docs, but should still apply for v8.x.

On Fri, 28 Feb 2003 15:47:26 -0500 (EST), Net Llama! wrote:

>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
>_______________________________________________
>Linux-users mailing list
>Linux-users at linux-sxs.org
>Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users

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/VThRcJRaVKt4XEQITzQCgwmHoYXn8IOT1AHrqBX/WTY0LxpcAniaf
QmEP6gN1wi3C7E/eAjv1LDoG
=NdFD
-----END PGP SIGNATURE-----