DB2 BACKUP OF THE DATABASE

Sometimes a backup of the Database is required,

with this in mind, Imgoing to show you the steps to do a DB2 backups in DB2

step 1

you need to execute the following query, adapting  to your database and the filesystem to do the backup

CONNECT TO ECMDB;

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

CONNECT RESET;

BACKUP DATABASE ECMDB TO "D:\DB2 Backup\240615" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

CONNECT TO ECMDB;

UNQUIESCE DATABASE;

CONNECT RESET;CONNECT TO ECMDB;

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

CONNECT RESET;

BACKUP DATABASE ECMDB TO "D:\DB2 Backup\240615" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

CONNECT TO ECMDB;

UNQUIESCE DATABASE;

CONNECT RESET;