Db2는 여러 관계형 데이터베이스 관리 시스템 제품을 중심으로 IBM의 정보 관리 부서에 있는 관계형 데이터베이스 관리 시스템 제품군입니다. 이 섹션에서는 Linux 환경에서 백업 및 DR을 사용하여 Db2 애플리케이션 일관성 데이터베이스 데이터를 보호하는 방법을 설명합니다.
보호 방법
Db2는 Compute Engine 인스턴스의 기본 및 보조 Db2 데이터베이스에 모두 WRITE SUSPEND 및 WRITE RESUME (영구 디스크 스냅샷 백업)를 사용하여 애플리케이션 일관성을 유지하면서 영구 디스크의 데이터 및 로그 볼륨을 증분 방식으로 백업합니다.
백업 및 DR은 데이터 무결성을 보장하는 자동 체크섬을 사용하여 각 스냅샷의 복사본 여러 개를 여러 위치에 저장합니다.
다음은 백업 및 DR에서 사용하는 Db2 백업 API입니다.
대기 (HADR) 데이터베이스: Db2 database deactivate 및 Db2 database activate API는 동결 및 해동에 사용됩니다.
Db2 로그 백업: Db2 archive log for database를 사용하여 로그가 플러시됩니다.
로그 백업 중에 로그 세그먼트의 페이로드는 로그 영역에서 logarchmeth1 매개변수로 지정된 위치로 복사됩니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-09-04(UTC)"],[[["\u003cp\u003eThis guide outlines how to use Backup and DR to protect Db2 databases in Linux environments, focusing on data backup and recovery procedures.\u003c/p\u003e\n"],["\u003cp\u003eBackup and DR utilizes specific Db2 APIs for different backup methods, including volume-level backups with CBT and LVM snapshots, standby database backups using HADR, and full/incremental file-based backups.\u003c/p\u003e\n"],["\u003cp\u003eVolume-based backups use a Changed Block Tracking (CBT) mechanism to track only the changed blocks, involving database freezing, LVM snapshot creation, and the copying of changed blocks to a backup appliance.\u003c/p\u003e\n"],["\u003cp\u003eFile-based backups involve deploying an agent, mounting a staging disk, invoking full or incremental backups via a dump backup command, and using the staging disk to restore.\u003c/p\u003e\n"],["\u003cp\u003eThe Db2 log backups are done by flushing them using \u003ccode\u003eDb2 archive log for database\u003c/code\u003e, and the payload of the segments is copied to the location specified by the parameter logarchmeth1.\u003c/p\u003e\n"]]],[],null,["# Backup and DR Service for IBM Db2\n\nDb2 is a is a family of relational database management systems within\nIBM's Information Management division that is centered on several\nrelational database management system offerings. This section explains\nhow to protect Db2 application consistent database data with Backup and DR in\nLinux environments.\n\nProtection method\n-----------------\n\nDb2 uses `WRITE SUSPEND` and `WRITE RESUME` (Persistent Disk snapshot backup) for both primary\nand secondary Db2 databases on a Compute Engine instance to incrementally back\nup data and log volumes from your Persistent Disks with application consistency.\n\nBackup and DR stores multiple copies of each snapshot across multiple\nlocations with automatic checksums to ensure the integrity of your data.\n\nThe following are Db2 backup APIs used by Backup and DR:\n\n- **Standby (HADR) database** : The `Db2 database deactivate` and\n `Db2 database activate` API are used for freeze and thaw.\n\n- **Db2 log backup** : Logs are flushed using `Db2 archive log for database`.\n During a log backup, the payload of the log segments is copied from\n the log area to the location specified by the parameter logarchmeth1.\n\nProtect IBM Db2 databases\n-------------------------\n\nTo get started protecting your Db2 databases, go through the Db2 procedures in\n[Protect and recover an IBM Db2 database running in Compute Engine](/backup-disaster-recovery/docs/quickstarts/db2-on-gce-backup-recovery)\n\nBackup and DR uses Persistent Disk snapshots to incrementally back up data\nand log volumes from your persistent disks with application consistency.\nBackup and DR stores multiple copies of each snapshot across multiple\nlocations with automatic checksums to ensure the integrity of your data.\n\nWhat's next\n-----------\n\n[Prepare the database for Backup and DR](/backup-disaster-recovery/docs/configuration/otherdb-prep-database)\n\nOther documentation for Backup and DR for IBM Db2\n-------------------------------------------------\n\nThis page is one in a series of pages specific to protecting and recovering\nIBM Db2 databases with Backup and DR.\nYou can find additional information at:\n\n- [Backup and DR for Db2](/backup-disaster-recovery/docs/concepts/db2-intro)\n- [Prepare the database for Backup and DR](/backup-disaster-recovery/docs/configuration/otherdb-prep-database)\n- [Add a Db2 database host and discover databases](/backup-disaster-recovery/docs/configuration/otherdb-add-host)\n- [Define policy templates and resource profiles](/backup-disaster-recovery/docs/create-plan/create-template)\n- [Set application details and settings](/backup-disaster-recovery/docs/backup/app-details-settings-otherdb)\n- [Check staging disk format and backup method](/backup-disaster-recovery/docs/backup/backup-method-staging-disk-otherdb)\n- [Protect the Db2 database and its logs](/backup-disaster-recovery/docs/backup/otherdb-protect)\n- [Mount a Db2 database](/backup-disaster-recovery/docs/access-data/otherdb-mounts)\n- [Recover a Db2 backup image to another location](/backup-disaster-recovery/docs/restore-data/otherdb-mount-and-migrate)\n- [Restore Db2 backups](/backup-disaster-recovery/docs/restore-data/otherdb-restore)"]]
