DB2: To check backup status

 Two ways:


(1) check the backup file, this will take long and you can control C out of it when buffers are being processed:

[dev2ins2@dev601  dev2ins2]

$ db2ckbkp -h WCDEV2.0.dev2ins2.DBPART000.20220124030003.001



=====================

MEDIA HEADER REACHED:

=====================

        Server Database Name           -- WCDEV2

        Server Database Alias          -- WCDEV2

        Client Database Alias          -- WCDEV2

        Timestamp                      -- 20220124030003

        Database Partition Number      -- 0

        Instance                       -- dev2ins2

        Database Configuration Type    -- 0 (Non-shared data)

        Sequence Number                -- 1

        Database Member ID             -- 0

        Release ID                     -- 0x1500 (DB2 v11.5.5.1)

        AL version                     -- V:11 R:5 M:5 F:1 I:0 SB:0

        Database Seed                  -- 0xF611A4F0

        DB Comment's Codepage (Volume) -- 0

        DB Comment (Volume)            --

        DB Comment's Codepage (System) -- 0

        DB Comment (System)            --

        Authentication Value           -- 255 (Not specified)

        Backup Mode                    -- 1 (Online)

        Includes Logs                  -- 1 (Yes)

        Compression                    -- 1 (Compressed)

        Backup Type                    -- 0 (Database-level)

        Backup Granularity             -- 0 (Non-incremental)

        Merged Backup Image            -- 0 (No)

        Status Flags                   -- 0x20

                                          LOGARCHMETH1 is set

        System Catalogs in this image  -- 1 (Yes)

        Catalog Partition Number       -- 0

        DB Codeset                     -- UTF-8

        DB Territory                   -- US

        LogID                          -- 1623876382

        LogPath                        -- /rd300/db2logs/dev2ins2/NODE0000/LOGSTREAM0000/

        Backup Buffer Size             -- 16781312 (4097 4K pages)

        Number of Sessions             -- 1

        Platform                       -- 0x1E (Linux-x86-64)

        Encrypt Info Flags             -- 0x0


 The proper image file name would be:

WCDEV2.0.dev2ins2.DBPART000.20220124030003.001



[1] Buffers processed:  #############################################################################################################^C




(2) check the log:

This is the backup file:

-rw------- 1 dev2ins2 db2iadm1 3087794176 Jan 24 03:08 WCDEV2.0.dev2ins2.DBPART000.20220124030003.001



[dev2ins2@dev601  dev2ins2]

$ db2 list history backup since 20220124030003 for db wcdev2


                    List History File for wcdev2


Number of matching file entries = 1



 Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID

 -- --- ------------------ ---- --- ------------ ------------ --------------

  B  D  20220124030003001   N    D  S0000457.LOG S0000457.LOG

 ----------------------------------------------------------------------------

  Contains 5 tablespace(s):


 00001 SYSCATSPACE

 00002 USERSPACE1

 00003 TAB8K

 00004 TAB16K

 00005 SYSTOOLSPACE

 ----------------------------------------------------------------------------

    Comment: DB2 BACKUP WCDEV2 ONLINE

 Start Time: 20220124030003

   End Time: 20220124030812

     Status: A

 ----------------------------------------------------------------------------

  EID: 667 Location: /usr/opt/app/dbdump/dev2ins2


Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more