Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    17

    Unanswered: Latest full backup size

    Hi All,

    Can any body please help me. How can we come to know latest full backup size in db2? Is there any way?

    Please can anybody help me?


    Thanks

  2. #2
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    no way,except you know where the backups are stored

  3. #3
    Join Date
    Jul 2011
    Location
    USA
    Posts
    80
    No direct way ...
    You can use : db2 -x "select location from SYSIBMADM.DB_HISTORY where operation='B' and SQLCAID IS NULL order by start_time desc fetch first 1 rows only with ur "

    it will give u path of backup from there you can check its size by du -g or du -m command.


    cd

Posting Permissions

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