|
Re: [ADSM-L] Where is the missing 38GB?
2008-12-02 14:50:18
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Tuesday, December 02, 2008 1:04 PM
To: ADSM-L AT VM.MARIST DOT 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" <Robert.Clark AT PROVIDENCE DOT ORG>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
12/02/2008 01:17 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Zoltan Forray/AC/VCU
Sent: Tuesday, December 02, 2008 9:20 AM
To: ADSM-L AT VM.MARIST DOT 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.
|
|
|
