1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

tsm db backup on file

Discussion in 'TSM Server' started by Bharanij, Mar 27, 2017.

  1. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    hi guys,

    iam going to take tsm db backup on file base

    i have created below file davcalss

    BACKUPSERVER> define devclass FILE devtype=file maxcapacity=200G shared=no
    ANR2203I Device class FILE defined.
    BACKUPSERVER> update devclass FILE directory=F:\DBBACKUP
    ANR2205I Device class FILE updated.
    BACKUPSERVER> set dbrecovery FILE numstreams=1 compress=yes protectkeys=no
    ANR2782I SET DBRECOVERY completed successfully and device class for automatic DB backup is set to FILE.
    BACKUPSERVER> ba db devclass=FILE type=full
    Process number 3 started.
    ANR2280I Full database backup started as process 3.
    BACKUPSERVER> ba db devclass=FILE type=incremental
    Process number 4 started.
    ANR2281I Incremental database backup started as process 4.


    But issue is when i see disk device iam getting critical

    is there any thing to update ?
     

    Attached Files:

  2.  
  3. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,758
    Likes Received:
    352
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    Did the backup complete? If you do a volhist of the DB backed up, do you see the devclass=file there?

    If the answer to the above is both yes, then there is nothing else to do. All is working. Critical may mean that you are filling up the allocated space beyond the threshold level.
     
    Last edited: Mar 31, 2017
  4. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    q volhistory type=dbbackup begindate=today-1
    Date/Time: 2017-03-31, 13:27:57
    Volume Type: BACKUPFULL
    Backup Series: 1
    Backup Operation: 0
    Volume Seq: 100,001
    Device Class: FILE
    Volume Name: /TSM/tsmdbbackup/90947077.DBV
    Volume Location:
    Command:
    Database Backup ID High: 0
    Database Backup ID LOW: 0
    Database Backup Home Position: 0
    Database Backup HLA:
    Database Backup LLA:
    Database Backup Total Data Bytes (MB) : 0
    Database Backup total Log Bytes (MB) : 0
    Database Backup Block Num High: 0
    Database Backup Block Num Low: 0
    Database Backup Stream Id: 1
    Database Backup Volume Sequence for Stream: 100,001

    Date/Time: 2017-03-31, 13:42:21
    Volume Type: BACKUPINCR
    Backup Series: 1
    Backup Operation: 1
    Volume Seq: 100,001
    Device Class: FILE
    Volume Name: /TSM/tsmdbbackup/90947941.DBV
    Volume Location:
    Command:
    Database Backup ID High: 0
    Database Backup ID LOW: 0
    Database Backup Home Position: 0
    Database Backup HLA:
    Database Backup LLA:
    Database Backup Total Data Bytes (MB) : 0
    Database Backup total Log Bytes (MB) : 0
    Database Backup Block Num High: 0

    still showing what should i need to check next?
     

    Attached Files:

  5. StiffBoard

    StiffBoard ADSM.ORG Member

    Joined:
    Mar 1, 2014
    Messages:
    28
    Likes Received:
    3
    Hi, just noticed devclass path doesn't match volume path?!
     
  6. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    just help me what to do ?
     
  7. DazRaz

    DazRaz ADSM.ORG Senior Member

    Joined:
    Jun 15, 2008
    Messages:
    128
    Likes Received:
    9
    Add more disk space?

    How much free space is there?
     
  8. StiffBoard

    StiffBoard ADSM.ORG Member

    Joined:
    Mar 1, 2014
    Messages:
    28
    Likes Received:
    3
    In which directories have you got the files?
    q devclass file f=d
    How much space on each of the disks where you have *.dbv files
     
  9. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    q devclass file f=d
    Device Class Name: FILE
    Device Access Strategy: Sequential
    Storage Pool Count: 0
    Device Type: FILE
    Format: DRIVE
    Est/Max Capacity (MB): 204,800
    Mount Limit: 20
    Mount Wait (min):
    Mount Retention (min):
    Label Prefix:
    Library:
    Directory: /TSM/tsmdbbackup
    Server Name:
    Retry Period:
    Retry Interval:
    Shared: No
    High-level Address:
    Minimum Capacity:
    WORM: No
    Drive Encryption:
    Scaled Capacity:
    Primary Allocation (MB):
    Secondary Allocation (MB):
    Compression:
    Retention:
    Protection:
    Expiration Date:
    Unit:
    Logical Block Protection:
    Last Update by (administrator): ADMIN
    Last Update Date/Time: 2017-03-27, 14:43:48


    it is 200 GB there is lots of free space in that drive
     
  10. StiffBoard

    StiffBoard ADSM.ORG Member

    Joined:
    Mar 1, 2014
    Messages:
    28
    Likes Received:
    3
    Are you referring to Est/Max Capacity (MB): 204,800 or do you actually have 200 GB on the disk where your dbv files are? Est/Max Capacity (MB): 204,800 is the size of database backup files.

    In your first post you mention that you updated your devclass

    update devclass FILE directory=F:\DBBACKUP

    But your output of q devclass shows Directory: /TSM/tsmdbbackup
     
  11. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    hi bro,

    iam doing it on aix server (forget BACKUPSERVER> update devclass FILE directory=F:\DBBACKUP what i post first time i change my tsm server to aix server)

    i have 200 GB mount point which is /TSM/tsmdbbackup

    "204,800 is the size of database backup files" <---- what is this mean am i taking 200gb db backup file ?

    i set a FILE devclass and assign 200GB Lun for taking backup so what did i made worng?
     
  12. StiffBoard

    StiffBoard ADSM.ORG Member

    Joined:
    Mar 1, 2014
    Messages:
    28
    Likes Received:
    3
    What is on that mount point? Is it empty at the moment? How large is your db backup?

    Update your devclass to 5 GB or something like that.

    update devclass FILE maxcapacity=5G

    MAXCAPacity
    Specifies the maximum size of any data storage files that are categorized by this device class. This parameter is optional.

    Specify this value as an integer followed by K (kilobytes), M (megabytes), G (gigabytes), or T (terabytes). The minimum size is 1 MB (MAXCAPACITY=1M). If you are defining a FILE device class for database-backup volumes, specify a value for MAXCAPACITY that is appropriate for the size of the database and that minimizes the number of database volumes.

    For example, MAXCAPACITY=5G specifies that the maximum capacity for a volume in this device class is 5 gigabytes. The value that is specified must be less than or equal to the maximum supported size of a file on the target file system.
     
  13. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    Hi i update as 10gb max capacity and it went to normal

    what ever max capacity size is the size of db backing up
    what iam thinking is that right ?
     
  14. StiffBoard

    StiffBoard ADSM.ORG Member

    Joined:
    Mar 1, 2014
    Messages:
    28
    Likes Received:
    3
    max capacity size is the file size of db backup devices. If your database backup is 15 GB there will be one 10 GB and one 5 GB file after backup is done. Next day, two more files, make sure you Clean up old backups.
     
    Bharanij likes this.
  15. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    "If your database backup is 15 GB"

    IPLTSM>
    q db format=detailed
    Database Name: TSMDB1
    Total Space of File System (MB): 2,606,080
    Space Used on File System(MB): 42,797
    Space Used by Database(MB): 1,280
    Free Space Available (MB): 2,563,283
    Total Pages: 102,408
    Usable Pages: 100,856
    Used Pages: 45,640
    Free Pages: 55,216
    Buffer Pool Hit Ratio: 99.97
    Total Buffer Requests: 32,932,910
    Sort Overflows: 0
    Package Cache Hit Ratio: 86.951
    Last Database Reorganization: 2017-04-05, 14:16:16
    Full Device Class Name: FILE
    Number of Database Backup Streams: 1
    Incrementals Since Last Full: 2
    Last Complete Backup Date/Time: 2017-04-04, 18:30:42
    Compress Database Backups: Yes
    Protect Master Encryption Key: No



    how to find in this? db size
     
  16. StiffBoard

    StiffBoard ADSM.ORG Member

    Joined:
    Mar 1, 2014
    Messages:
    28
    Likes Received:
    3
    Check the dbbackup files on filesystem. DB is only 1 GB, with compression your backups should med pretty small. If backup is larger than 10GB a second file will be created.
     
    Bharanij likes this.
  17. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    now i understand thank you and one more thing just now iam install one client and iam going to install 3 more clients my daily data backup will reach 160 to 500GB per day so should i need to increase db-backup size or let it be 10GB.

    Thank you in advance
     
  18. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,758
    Likes Received:
    352
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
    As mentioned, MAXCAPACITY is the maximum size a backup volume will use. If you have allocated 500 GB for the the entire directory that holds your backup volumes; and defined MAXCAPACITY=10GB, then you will be able to create up to 50 volumes on said directory (500 GB/10 GB=50).

    Now, if your DB is only 1 GB, it would be better to set MAXCAPACITY=5 to allocate for growth. This means that if the TSM DB grows, it can use 1 volume up to 5 GB in size. If the TSM DB grows to 7 GB, it will use 1 volume and continue on to another volume which will total 7 GB, and so on.

    The directory then fills up IF the total GB (not by volume count) in the volumes goes beyond 500 GB.
     
    Last edited: Apr 12, 2017
    Bharanij likes this.
  19. StiffBoard

    StiffBoard ADSM.ORG Member

    Joined:
    Mar 1, 2014
    Messages:
    28
    Likes Received:
    3
    eh bharanij...Community Tip: Please Give Thanks to Those Sharing Their Knowledge.If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful. ;)
     
    Bharanij likes this.
  20. Bharanij

    Bharanij ADSM.ORG Member

    Joined:
    Jun 18, 2016
    Messages:
    64
    Likes Received:
    2
    done
     
    StiffBoard likes this.

Share This Page