tsm db backup on file

Bharanij

ADSM.ORG Member
Joined
Jun 18, 2016
Messages
159
Reaction score
2
Points
0
PREDATAR Control23

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 ?
 

Attachments

  • file dev.jpg
    file dev.jpg
    59.3 KB · Views: 22
PREDATAR Control23

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:
PREDATAR Control23

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?
 

Attachments

  • file dev war.jpg
    file dev war.jpg
    64.8 KB · Views: 8
PREDATAR Control23

Hi, just noticed devclass path doesn't match volume path?!
 
PREDATAR Control23

Add more disk space?

How much free space is there?
 
PREDATAR Control23

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
 
PREDATAR Control23

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
 
PREDATAR Control23

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
 
PREDATAR Control23

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?
 
PREDATAR Control23

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.
 
PREDATAR Control23

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 ?
 
PREDATAR Control23

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.
 
PREDATAR Control23

"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
 
PREDATAR Control23

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.
 
PREDATAR Control23

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
 
PREDATAR Control23

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

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:
PREDATAR Control23

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. ;)
 
Top