Re: counting files in directories for a node

That did it. Couldn't remember "group by". Thank you Thomas. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Thomas Denier Sent: Thursday, November 16, 2017 10:55 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] counting files in

Has any one seen this: client restore mounting copy storage pool tape volumes?

Folks: TSM Server 7.1.7.200 running on Linux x86_64 (Red Hat 6.8) TSM client 7.1.6.0 running on what appears to be Red Hat 5.7 (kernel 2.6.18-300.el5) Local system admin is performing a BMR on a system that has been backing for years to the same TSM node. So there are a lot of old files

Re: counting files in directories for a node

My previous response omitted the "type='FILE'", which is needed to get the result you want. Thomas Denier, Thomas Jefferson University -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Thursday, November 16, 2017 10:18 To:

Re: counting files in directories for a node

You will need something like: select hl_name,count(ll_name) from backups where node_name='JUPITER' and filespace_id=3 group by hl_name The "group by" clause triggers the desired counting by directory. You might be able to use something like "filespace_name='\\jupiter\e$'" as an alternative to

Re: Has any one seen this: client restore mounting copy storage pool tape volumes?

Hi Robert, Yes this can happen. It's explained here: http://www-01.ibm.com/support/docview.wss?uid=swg21380647 - Thanks, Marc... Marc Lanteigne Accelerated Value Specialist for Spectrum Protect 416.478.0233 | marclantei...@ca.ibm.com

counting files in directories for a node

Tsm server 7.1.7.100 I have a request to count the number of files in each directory on the e: drive for a node. For output, path name, and file count. Any pointers on where to start? I can do it given a specific path, Select count(*) from backups where node_name=bla and hl_name=bla and

Re: log not flushing

> On 9 Nov 2017, at 15:13, Marc Lanteigne wrote: > > > Are you using cloud containers? If so, check: > http://www-01.ibm.com/support/docview.wss?uid=swg1IT18137 > fortunately no ;-) > > Short term, I'd

Re: Has any one seen this: client restore mounting copy storage pool tape volumes?

Thanks, Marc! Need to improve my tech note search terms… Robert Talda EZ-Backup Systems Engineer Cornell University +1 607-255-8280 r...@cornell.edu > On Nov 16, 2017, at 12:08 PM, Marc Lanteigne wrote: > > > Hi Robert, > > Yes this can happen. It's explained

Re: Tape Drive Error

I am running TSM Server Version 6, Release 2, Level 3.0 on AIX 5.3 TL12 SP02 - Yes I know all are unsupported now... I am seeing an error when the library tries to mount a tape: ANR8943E Hardware or media error on library TAPELIB (OP=6C03, CC=-1, KEY=04,

Re: Tape Drive Error

Hi Vincent, I don't see a tape drive in the message (just the library), so I would suspect the library itself. You might find these documents useful: https://www.ibm.com/support/knowledgecenter/en/SSGSG7_7.1.1/com.ibm.itsm.msgs.server.doc/ioerrorcodes.html

Re: Monthly backups of VMs

Thanks for the reply Richard Backupsets apply only to BA client data. Theoretically exports are possible. I've had issues with backupsets in the past and even if it were not possible would be loath to go there again (e.g. backupset is essentially a restore so it would take a drive to start,

IBM Spectrum Protect Plus

IBM Spectrum Protect Plus unlocks your data for real business value and by the way it’s easy to use! https://ibm.co/2iKsCwu Mary Anne Filosa Systems Storage - Customer Interactions mfil...@us.ibm.com

Monthly backups of VMs

HI All Environment is TSM 7.1.1 server on AIX. 7.1.1 Storage agents on Linux, 7.1.1 BA clients, 7.1.1 VE clients, VMWare 5.5. The VMware backups are via the SAN to a Protectier VTL. My Client is an international financial organization so we have lots or regulatory requirements including

Re: Monthly backups of VMs

Can you use backupsets or export nodes to real tape (no client impact.) Or full restores to a dummy node and then archive those to real tape (once a month), again no direct client impact. Can the "monthlles" be spread over 30 days? Richard -Original Message- From: ADSM: Dist Stor