- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- doing backups on db2 database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 06:22 AM
тАО10-02-2003 06:22 AM
Getting a new system to support AIX with db2.
I know very little about db2 database. Is there a special procedure to doing backups?
Example, for Oracle I put the tables into backup mode.
What special procedures is/are required for db2?
Many thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 07:06 AM
тАО10-02-2003 07:06 AM
SolutionI'm sorry but only DP5.1 supports DB/2 online backup integration and not DP5.0.
Check :
http://ovweb.external.hp.com/lpe/doc_serv/
select 'storage data protector', '5.0', 'hp-ux integration' or 'unix integration' guides, DB/2 is not listed...
select 'storage data protector', '5.1', 'hp-ux integration' or 'unix integration' guides, DB/2 is listed...
Check also to get more details on which DB/2 backup types are possible with DP5.1 :
http://openview.hp.com/sso/ecare/getsupportdoc?docid=OV-EN013111
You may nevertheless perform an offline db/2 backup if needed (outside db/2 but only if db/2 is stopped).
Hope this helps,
Bye.
Francis DERDEYN - HP-UX ASCE.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 08:18 AM
тАО10-02-2003 08:18 AM
Re: doing backups on db2 database
Can I do the same with DB2?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2003 11:57 PM
тАО10-04-2003 11:57 PM
Re: doing backups on db2 database
Sorry but since this question is not Omniback/DataProtector related, you should maybe raise this question in an IBM DB/2 forum.
If you succeed setting DB/2 in backup mode (as Oracle does), for sure you will be able to backup the database as a regular filesystem.
Hope this helps, Bye.
Francis DERDEYN - HP-UX ASCE.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2003 01:50 AM
тАО10-05-2003 01:50 AM
Re: doing backups on db2 database
OFFLINE :::::
set DB2INSTANCE=
db2start
db2 backup db
The timestamp for this image is 20021006213640, and the image is located in D:\
ONLINE ::::::::
For this the database must be in Archive log mode,The Parameters LOGRETAIN must be YES, and also USEREXIT must be set.
db2 "backup database DBNAME ONLINE to dir/dev [ {,dir/dev} ... ]"
(Finde the simple ONLINE keyword added to that ).
For a simple solution we can create a TEMPLATE in DP for copying.
But A Well documented and proffessional guidence is required while configuring for Online Backup.
U can get more information from
redbooks.ibm or the Online answer books of DB2.