Results 1 to 4 of 4
  1. #1
    Join Date
    May 2015
    Location
    Korea
    Posts
    54
    Provided Answers: 1

    Unanswered: How to check backup image size?

    How to check the correct backup image size on TSM?
    Due to size, we cannot move it to disk and do "ls" or "db2ckbkp"

    Backup done with:
    db2 backup database sample incremental use tsm.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Study the DB2 documentation for topic db2adutl

  3. #3
    Join Date
    May 2015
    Location
    Korea
    Posts
    54
    Provided Answers: 1
    Thanks, couldn't find the exact option of db2adutl which can show the filesize.
    Can someone plz help?

  4. #4
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    108
    Provided Answers: 13
    Hi,

    You can use dsmadmc utility.
    Find OBJECT_ID of your backup with a query like:
    select * from BACKUPS WHERE ...
    then run a query with object_id found:
    select FILE_SIZE as fs_in_bytes from CONTENTS WHERE OBJECT_ID=...
    Regards,
    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •