• 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 commands help

seekerTSM

Active Newcomer
#1
hi,

i am a HP data protector for almost 10 years. this is the first time handling TSM. can you kindly help me on this

we have a failed backup then when i rerun the backup, i cant see the details of the rerun backup in the q event command.

is there a command where i can see all the backup runs, scheduled and re-run?

can i also now how to check start/end of the backup(ELAPSED time)

ur assistance is much appreciated
 

ABrion

ADSM.ORG Senior Member
#2
Hi,

Could you please explain what exactly you mean with "rerun" a backup ? How do you initiate this ?

You have to understand that "q event" command will only return information about scheduled backups (means there must be a schedule defined in TSM server, and this schedule has to be associated with some client node existing on he TSM server. To find these, try following commands : "q sched * * f=d" and "q assoc * *").
Thus, if you did not make use of a schedule to initiate your backup "rerun", the command will not provide any information.
Note as well, that you might use "q event * * f=d" to get details on the start and end time for a given backup schedule.

For your information, there's a table in TSM database, named "summary", which, you guessed it, is summarizing most of the operations executed on the TSM server. This includes of course backup as well as archive operations.
It is possible to execute SQL queries against this table, to extract the information you're needing.
Following example would provide you with backup/archive activity for each node during the last 24 hours :

SELECT entity as "NODE", number as "SESSION", activity, -
TO_CHAR(CHAR(start_time),'YYYY-MM-DD HH24:MI:SS') as START_TIME, -
TRANSLATE('a bc:de:fg', DIGITS(end_time-start_time), '_______abcdefgh_____',' ') as "ELAPTIME (D HHMMSS)", -
CAST(bytes/1024/1024 AS DECIMAL(8,2)) as "MB", -
CAST(bytes/TIMESTAMPDIFF(2,CHAR(end_time-start_time))/1024/1024 AS DECIMAL(8,2)) AS "MB/s" -
FROM summary WHERE ( activity='ARCHIVE' OR activity='BACKUP' ) AND -
start_time>=current_timestamp - 24 hours

You just have to copy-paste the whole text (exactly as is) into TSM server command line interface to get the data !

Cheers.

Arnaud
 

seekerTSM

Active Newcomer
#3
thanks for the reply sir!

for example, the schedule backup is failed, and i rerun it. i didnt see the session of my rerun on the q event
 

seekerTSM

Active Newcomer
#5
for example, we have a failed 12. i just go to the server and open cli then i type i -absolute.

but when i check q event, i cant see any details of my rerun
 

ABrion

ADSM.ORG Senior Member
#6
OK, things are getting clearer now !
In such a case, there will indeed be no information to be found in the output of "q event", as this was not a scheduled backup.
In this case, the "summary" table will be your best friend if you would like to check your backup jobs from a centralized location.
 

seekerTSM

Active Newcomer
#7
thanks Mate!

do you happen to know how to properly backup a drive?

in data protector, if you select drive C for example, all drive C will be backup.

so if i want to backup all the files in drive C is this the right command inc -absolute C: ?

also, if i backup the whole drive, will it also backup the file or path that is excluded in the dsm.opt? will it backup all even the excluded?

thank mate for your answer.
 

seekerTSM

Active Newcomer
#11
Will it back up even the excluded?

So if i run inc -absolute c: all of the file, folder, subfolder and everything will be backup? I mean everything?

By default there are some folder and file thats excluded in drive C. If i run that command, is the excluded will also run?
 

marclant

ADSM.ORG Moderator
#15
I'm curious, do you have a requirement to backup everything everyday? Typically, most people use an incremental forever approach, takes less processing time and less storage. If there's a requirement to keep monthly/quarterly/yearly backups longer, that can be achieved with retention sets while still only doing daily incremental backups. No need to do additional backups.
 
#16
I'm curious, do you have a requirement to backup everything everyday? Typically, most people use an incremental forever approach, takes less processing time and less storage. If there's a requirement to keep monthly/quarterly/yearly backups longer, that can be achieved with retention sets while still only doing daily incremental backups. No need to do additional backups.

thanks for the reply. no, its just a want time backup. i am just confuse if that command will backup everything even the excluded. i just got the answer that it will not backup the excluded files by default.
 

marclant

ADSM.ORG Moderator
#17
thanks for the reply. no, its just a want time backup. i am just confuse if that command will backup everything even the excluded. i just got the answer that it will not backup the excluded files by default.
I meant everything as in a full backup versus an incremental backup, excluded files are still excluded.
 

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: 16 18.8%
  • Keep using TSM for Spectrum Protect.

    Votes: 52 61.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.8%
  • Other (please comement)

    Votes: 7 8.2%

Forum statistics

Threads
31,448
Messages
133,969
Members
21,548
Latest member
cburns
Top