• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • 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.

  • 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

Bharanij

ADSM.ORG Member
#1
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

moon-buddy

ADSM.ORG Moderator
#2
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:

Bharanij

ADSM.ORG Member
#3
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

StiffBoard

ADSM.ORG Senior Member
#7
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
 

Bharanij

ADSM.ORG Member
#8
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
 

StiffBoard

ADSM.ORG Senior Member
#9
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
 

Bharanij

ADSM.ORG Member
#10
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?
 

StiffBoard

ADSM.ORG Senior Member
#11
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.
 

Bharanij

ADSM.ORG Member
#12
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 ?
 

StiffBoard

ADSM.ORG Senior Member
#13
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

ADSM.ORG Member
#14
"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
 

StiffBoard

ADSM.ORG Senior Member
#15
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

ADSM.ORG Member
#16
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
 

moon-buddy

ADSM.ORG Moderator
#17
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:

StiffBoard

ADSM.ORG Senior Member
#18
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. ;)
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 7 23.3%
  • Keep using TSM for Spectrum Protect.

    Votes: 16 53.3%
  • Let's be formal and just say Spectrum Protect

    Votes: 4 13.3%
  • Other (please comement)

    Votes: 3 10.0%

Forum statistics

Threads
30,889
Messages
131,422
Members
21,194
Latest member
jamesmacd40