Re: query occupancy command - file names

2016-08-07 Thread Richard Cowen 
Paul,

First, get a list of volumes that have data from that filespace in that stgpool.

(use the table volumeusage)

Then for each volume (say, volid), issue the SELECT with volume_name=volid.
This will break the select into manageable chunks.
The output can still be very large.
One goal of proper storage pool design is to keep the number of volumes with 
data from a given node/filespace to a reasonable number (for recovery 
efficiency.)

Richard

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Paul_Dudley
Sent: Sunday, August 07, 2016 7:40 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] query occupancy command - file names

Hi,

Tried that but it failed after 18 hours with the following memory failure:

ANS8000I Server command: 'select file_name from contents where volume_name in 
(select volume_name from volumes where stgpool_name='B KPLTO6POOL' )'
ANR0163E tbnsql.c(789): Database insufficient memory detected on 47:1.
ANR0162W Supplemental database diagnostic information:  -1:57011:-1218 
([IBM][CLI Driver][DB2/NT64] SQL1218N  There are no pages currently available 
in bufferpool "1".  SQLSTATE=57011 ).
ANR0516E SQL processing for statement select file_name from contents where 
volume_name in ( select volume_name from volumes where st gpool_name = 
'BKPLTO6POOL' )  failed.


Thanks & Regards
Paul



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Ullrich Mänz
Sent: Thursday, 4 August 2016 6:29 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] AW: query occupancy command - file names

Hi Paul,

try out that:

select file_name from contents where volume_name in (select volume_name from 
volumes where stgpool_name='BKPLTO6POOL')

Because data is taken out of contents table, this query may run very long.

Regards
Ulli Maenz

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von 
Paul_Dudley
Gesendet: Donnerstag, 4. August 2016 02:11
An: ADSM-L@VM.MARIST.EDU
Betreff: [ADSM-L] query occupancy command - file names

The query occupancy command below shows 283 files in the bkplto6pool storage 
pool for this filespace. Is it possible to get a list of the file names?



tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup



Node Name  Type Filespace  FSID Storage  Number of  
  Physical Logical

NamePool NameFiles  
 Space   Space


  OccupiedOccupied


  (MB)(MB)

--  --  -- --- 
--- ---

DBPROD-Bkup DBPROD-   17   BKPLTO6PO- 283 
9,771,429.0 9,771,429.0

_SQL\data\00-   OL  
0   0

 01







Thanks & Regards

Paul





Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au

61-3-8842-5603








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add ressees. Any unauthorised dissemination or use is strictly 
prohibited. If you received this e-mail in error, please immediately notify the 
sender by return e-mail from your s ystem. Please do not copy, use or make 
reference to it for any purpose, or disclose its  contents to any person.
--
Message  protected by MailGuard: e-mail anti-virus, anti-spam and content 
filtering.
http://www.mailguard.com.au

Click here to report this message as spam:
https://console.mailguard.com.au/ras/1OYBJ9Ghcx/5mAucmMa3OSDp5zeRiFgkA/1.222







ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add ressees. Any unauthorised dissemination or use is strictly 
prohibited. If you received this e-mail in error, please immediately notify the 
sender by return e-mail from your s ystem. Please do not copy, use or make 
reference to it for any purpose, or disclose its  contents to any person.


This email has been scanned by BullGuard antivirus protection.
For more info visit www.bullguard.com

Re: query occupancy command - file names

2016-08-07 Thread Paul_Dudley 
Hi,

Tried that but it failed after 18 hours with the following memory failure:

ANS8000I Server command: 'select file_name from contents where volume_name in 
(select volume_name from volumes where stgpool_name='B KPLTO6POOL' )'
ANR0163E tbnsql.c(789): Database insufficient memory detected on 47:1.
ANR0162W Supplemental database diagnostic information:  -1:57011:-1218 
([IBM][CLI Driver][DB2/NT64] SQL1218N  There are no pages currently available 
in bufferpool "1".  SQLSTATE=57011 ).
ANR0516E SQL processing for statement select file_name from contents where 
volume_name in ( select volume_name from volumes where st gpool_name = 
'BKPLTO6POOL' )  failed.


Thanks & Regards
Paul



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Ullrich Mänz
Sent: Thursday, 4 August 2016 6:29 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] AW: query occupancy command - file names

Hi Paul,

try out that:

select file_name from contents where volume_name in (select volume_name from 
volumes where stgpool_name='BKPLTO6POOL')

Because data is taken out of contents table, this query may run very long.

Regards
Ulli Maenz

-Ursprüngliche Nachricht-
Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von 
Paul_Dudley
Gesendet: Donnerstag, 4. August 2016 02:11
An: ADSM-L@VM.MARIST.EDU
Betreff: [ADSM-L] query occupancy command - file names

The query occupancy command below shows 283 files in the bkplto6pool storage 
pool for this filespace. Is it possible to get a list of the file names?



tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup



Node Name  Type Filespace  FSID Storage  Number of  
  Physical Logical

NamePool NameFiles  
 Space   Space


  OccupiedOccupied


  (MB)(MB)

--  --  -- --- 
--- ---

DBPROD-Bkup DBPROD-   17   BKPLTO6PO- 283 
9,771,429.0 9,771,429.0

_SQL\data\00-   OL  
0   0

 01







Thanks & Regards

Paul





Paul Dudley

IT Operations

ANL Container Line

pdud...@anl.com.au

61-3-8842-5603








ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add ressees. Any unauthorised dissemination or use is strictly 
prohibited. If you received this e-mail in error, please immediately notify the 
sender by return e-mail from your s ystem. Please do not copy, use or make 
reference to it for any purpose, or disclose its  contents to any person.
--
Message  protected by MailGuard: e-mail anti-virus, anti-spam and content 
filtering.
http://www.mailguard.com.au

Click here to report this message as spam:
https://console.mailguard.com.au/ras/1OYBJ9Ghcx/5mAucmMa3OSDp5zeRiFgkA/1.222







ANL DISCLAIMER

This e-mail and any file attached is confidential, and intended solely to the 
named add
ressees. Any unauthorised dissemination or use is strictly prohibited. If you 
received
this e-mail in error, please immediately notify the sender by return e-mail 
from your s
ystem. Please do not copy, use or make reference to it for any purpose, or 
disclose its
 contents to any person.

Re: Move Container question

2016-08-07 Thread Ron Delaware 
Robert,

This is a housekeeping type task that is performed, think of it like you 
if you ran a defrag disk.  This task takes place so that admin task of 
reclamation is not needed.  All of that is performed by the code without 
configuration, that same for your deduplication. Containers are dedup 
enabled out of the box and as data goes in, the code decides if the data 
should be deduped or not, and no configuration its all done in the 
background. 
_
Ronald C. Delaware
IBM IT Plus Certified Specialist - Expert
IBM Corporation | Tivoli Software
IBM Certified Solutions Advisor - Tivoli Storage
IBM Certified Deployment Professional
916-458-5726 (Office)
925-457-9221 (cell phone)
email: ron.delaw...@us.ibm.com
Storage Services Offerings








From:   Robert Ouzen 
To: ADSM-L@VM.MARIST.EDU
Date:   08/06/2016 07:07 PM
Subject:[ADSM-L] Move Container question
Sent by:"ADSM: Dist Stor Manager" 



Hi to all

Can anybody give me more information of the process for Storage of type 
DIRECTORY

ANR0986I Process 263 for Move Container (Automatic)   running in the 
BACKGROUND processed 73,945 items for a
  total of 10,705,469,440 bytes with a completion 
state of  SUCCESS at 03:23:06. (PROCESS: 263)

It’s run automatic , where is the configuration about it ?

There with a way to create a script to get report of this running. When I 
tried the regular  Q ACT begind=-3 s= ANR0986I

Got also Reclamation and Move Container and Identify Duplicates and ….

Thanks Tobert