-----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: [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 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/VThRcJRaVKt4XEQITzQCgwmHoYXn8IOT1AHrqBX/WTY0LxpcAniaf QmEP6gN1wi3C7E/eAjv1LDoG =NdFD -----END PGP SIGNATURE----- _______________________________________________ Linux-users mailing list [EMAIL PROTECTED] Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users
