By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,778 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,778 IT Pros & Developers. It's quick & easy.

Get db2 backup size from TSM in Windows environment

P: n/a
Hello Folks

I'm having some trouble getting the backup size for our current
databases from TSM
The environment is Windows
Here is the dsmc command that lists the filespaces

tsmquery files -detail
# Last Incr Date Type fsID Unicode File Space Name
--- -------------- ---- ---- ------- ---------------
1 00-00-0000 00:00:00 API:DB2/NT 8 No /ERPDES
12 00-00-0000 00:00:00 API:DB2 5 No \ERPDES

No matter what i do, i cant get a list like this one (found on
http://www.thescripts.com/forum/thread181354.html)

db2 "backup databae sample use tsm"
Output from "dsmc query backup /SAMPLE/*":

* * * * * * *Size * * *Backup Date * * * *Mgmt Class A/I File
* * * * * * *---- * * *----------- * * * *---------- --- ----
API *82.710.528 B *09.02.2004 12:09:15 * *MC48 * * * *A
/SAMPLE/NODE0000/FULL_BACKUP.20040209120800.1

Someone have some knowledge to share about this?

Thanks

Oct 23 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Oct 23, 11:06 am, alexhguerra <alexhgue...@uol.com.brwrote:
Hello Folks

I'm having some trouble getting the backup size for our current
databases from TSM
The environment is Windows
Here is the dsmc command that lists the filespaces

tsmquery files -detail
# Last Incr Date Type fsID Unicode File Space Name
--- -------------- ---- ---- ------- ---------------
1 00-00-0000 00:00:00 API:DB2/NT 8 No /ERPDES
12 00-00-0000 00:00:00 API:DB2 5 No \ERPDES

No matter what i do, i cant get a list like this one (found onhttp://www.thescripts.com/forum/thread181354.html)

db2 "backup databae sample use tsm"
Output from "dsmc query backup /SAMPLE/*":

* * * * * * *Size * * *Backup Date * * * *Mgmt Class A/I File
* * * * * * *---- * * *----------- * * * *---------- --- ----
API *82.710.528 B *09.02.2004 12:09:15 * *MC48 * * * *A
/SAMPLE/NODE0000/FULL_BACKUP.20040209120800.1

Someone have some knowledge to share about this?

Thanks
You can get the size of backup from db2diag.log.

Oct 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.