That is kind of interesting, of the 15,694 used DB pages, you backed up 68,561. Here we have only been able to backup the used pages once per run.
Andy Huebner -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Tuesday, December 02, 2008 1:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Where is the missing 38GB? No change............... 12/2/2008 1:53:43 PM ANR2017I Administrator ZFORRAY issued command: BACKUP DB dev=FILEDEVCLASS typ=Full scr=Yes 12/2/2008 1:54:49 PM ANR0984I Process 2 for DATABASE BACKUP started in the BACKGROUND at 01:54:50 PM. 12/2/2008 1:54:49 PM ANR2280I Full database backup started as process 2. 12/2/2008 1:54:49 PM ANR8340I FILE volume /tsmpool/filedirs/28244090.DBB mounted. 12/2/2008 1:54:49 PM ANR0513I Process 2 opened output volume /tsmpool/filedirs/28244090.DBB. 12/2/2008 1:54:49 PM ANR1360I Output volume /tsmpool/filedirs/28244090.DBB opened (sequence number 1). 12/2/2008 1:56:41 PM ANR4554I Backed up 34048 of 68561 database pages. 12/2/2008 1:57:11 PM ANR4554I Backed up 57024 of 68561 database pages. 12/2/2008 1:57:41 PM ANR4554I Backed up 61952 of 68561 database pages. 12/2/2008 1:58:11 PM ANR4554I Backed up 67392 of 68561 database pages. 12/2/2008 1:58:17 PM ANR1361I Output volume /tsmpool/filedirs/28244090.DBB closed. 12/2/2008 1:58:17 PM ANR0515I Process 2 closed volume /tsmpool/filedirs/28244090.DBB. 12/2/2008 1:58:17 PM ANR4550I Full database backup (process 2) complete, 68561 pages copied. 12/2/2008 1:58:17 PM ANR0985I Process 2 for DATABASE BACKUP running in the BACKGROUND completed with completion state SUCCESS at 01:58:18 PM. ------------------------------------------------------------------------------------ 1:59:53 PM TSMTEST : q db f=d Available Space (MB): 56,336 Assigned Capacity (MB): 53,264 Maximum Extension (MB): 3,072 Maximum Reduction (MB): 14,360 Page Size (bytes): 4,096 Total Usable Pages: 13,635,584 Used Pages: 15,694 Pct Util: 0.1 Max. Pct Util: 0.1 Physical Volumes: 6 Buffer Pool Pages: 131,072 Total Buffer Requests: 34,826 Cache Hit Pct.: 61.80 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 0 Changed Since Last Backup (MB): 0.04 Percentage Changed: 0.07 Last Complete Backup Date/Time: 12/02/2008 13:54:50 Estimate of Recoverable Space (MB): 0 Last Estimate of Recoverable Space (MB): 12/02/2008 12:41:54 ------------------------------------------------------------------------------- 2:01:02 PM TSMTEST : q dbv Volume Name Copy Volume Name Copy Volume Name Copy (Copy 1) Status (Copy 2) Status (Copy 3) Status ---------------- ------ ---------------- ------ ---------------- ------ /opt/tivoli/tsm- Sync'd Undef- Undef- /server/bin/db- ined ined .dsm /tsmpool/db/db2- Sync'd Undef- Undef- .dsm ined ined /tsmpool/db/db1- Sync'd Undef- Undef- .dsm ined ined /home/tsmdb/db3- Sync'd Undef- Undef- .dsm ined ined /tsmpool/db/db4- Sync'd Undef- Undef- .dsm ined ined /tsmpool/db/db5- Sync'd Undef- Undef- .dsm ined ined "Clark, Robert A" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 12/02/2008 01:17 PM Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Where is the missing 38GB? I would try doing a full DB backup. Can you send "q dbv" output too? [RC] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Tuesday, December 02, 2008 9:20 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Where is the missing 38GB? I have a test TSM server (5.5.1) which is producing some strange DB statistics. ************************************************** *** ---> Q DB F=D ************************************************** Available Space (MB): 56,336 Assigned Capacity (MB): 53,264 Maximum Extension (MB): 3,072 Maximum Reduction (MB): 14,360 Page Size (bytes): 4,096 Total Usable Pages: 13,635,584 Used Pages: 15,676 Pct Util: 0.1 Max. Pct Util: 0.1 Physical Volumes: 6 Buffer Pool Pages: 131,072 Total Buffer Requests: 249 Cache Hit Pct.: 100.00 Cache Wait Pct.: 0.00 Backup in Progress?: No Type of Backup In Progress: Incrementals Since Last Full: 4 Changed Since Last Backup (MB): 211.15 Percentage Changed: 344.82 Last Complete Backup Date/Time: 08/20/2008 09:49:38 Estimate of Recoverable Space (MB): Last Estimate of Recoverable Space (MB): With an assigned capacity of 52GB yet only 0.1% utilized (52MB?), it says I can only reduce the DB by 13GB ???? So, where is the remaining 38GB of DB usage ? There are 5-Disk STG volumes (empty/0% utilized), 2-Nodes with NO filespaces, defined. "Q STG" shows: 12:15:11 PM TSMTEST : q stg Storage Device Estimated Pct Pct High Low Next Stora- Pool Name Class Name Capacity Util Migr Mig Mig ge Pool Pct Pct ----------- ---------- ---------- ----- ----- ---- --- ----------- ARCHIVEPOOL DISK 0.0 M 0.0 0.0 90 30 BACKUPPOOL DISK 123 G 0.0 0.0 90 30 COPYPOOL-I- IBM3583-1 0.0 M 0.0 BM3583-1 COPYPOOL-I- IBM3583-2 0.0 M 0.0 BM3583-2 IBM3494-35- 3592E05 0.0 M 0.0 0.0 90 70 92 I did a "DSMSERV AUDITDB FIX=YES" and the only thing it complained (and fixed) about was old schedules for non-existing nodes. Also did an "EXPIRE INVENTORY". DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.