Re: getting the return code within a postschedcmd?

Bjorn, Yes, It is my opinion you are correct in your assumption. On 7/14/20, Bjørn Nachtwey wrote: > Hi all, > > is there any way to get the return code of the backup using a postschedcmd? > > I would think there might be a environment variable that holds the RC, > but i found no information

getting the return code within a postschedcmd?

Hi all, is there any way to get the return code of the backup using a postschedcmd? I would think there might be a environment variable that holds the RC, but i found no information on that. Maybe there's also a better way? if not i might take the fact the postschedcmd is run at all the RC

Tighten client authorization

Hi all, I read more and more about ransomware which is capable of encrypting data and at the same time deleting backup data. That's why I would like to set BACKDEL=NO on all nodes, wherever possible. I know the Data Protection for SQL client requires BACKDEL=YES to function properly, but are

Spectrum Protect Plus deduplication ratios

It's a new day, so it must be time for more SPP questions.  For the folks running SPP, what deduplication ratios are you seeing? So far I'm still in the testing phase, with approximately 10 VMs that I'm running backup testing on. Two of the VMs have similar database footprints (one is qa

Re: Spectrum Protect Plus Backup Performance

Thanks Steve, I've been digging into it a bit more with the help of IBM support and I forgot a very important setting. Currently I have a vsnap combined with vadp proxy, but I neglected to set the softcap for the vadp. Consequently, backups were running on all available cores and crowding

Re: Spectrum Protect Plus Backup Performance

Matthew, Not sure if this is your issue or not, but verify that you are using nbd transport. Hotadd performs better on initial full backups, but the overhead involved in setup/teardown makes it a poor choice once you start doing incrementals consistently. Steve Schaub Senior Platform Engineer

Spectrum Protect Plus Backup Performance

Hey folks, Starting a deployment of spectrum protect plus using virtual vsnap/vadp systems backed by v5030 RDM storage. The vsnap system has been sized based on the recommendation of the blueprints for a 100TB repo and all of our VMWare infrastructure is hosted on Cisco UCS with multiple 10G

SQL query for outstanding requests?

Hi, Does anyone know how to query the TSM DB2 for outstanding requests with a SELECT statement? I basically need to do much the same as QUERY REQUEST does, but I only need a Yes or No and would like to avoid parsing the output of QUERY REQUEST. - Bent COWI handles personal data as stated

Re: isp replication and automatic failover for backup to target server

Hi Jonas, Great, I didn't know. It has my vote now! Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Jansen, Jonas Sent: woensdag 1 juli 2020 09:58 To: ADSM-L@VM.MARIST.EDU Subject: Re: isp replication and

Re: isp replication and automatic failover for backup to target server

Hi, there is a rfe for this feature: https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe_ID=107699 best regards, -- Jonas Jansen IT Center Group: Systems and Storage Division: Systems and Services RWTH Aachen University Seffenter Weg 23 52074 Aachen Tel: +49 241 80-28784 Fax: +49

Re: isp replication and automatic failover for backup to target server

Hi Stefan, I have also talked about this feature with a server architect from IBM during the SP Symposium in Germany, last year. Backup is almost as vital as backup (at least for databases), so failover for backup would be a great enhancement. He told me it's on the roadmap, but definitely not

isp replication and automatic failover for backup to target server

Hello, automatic failover for backups to target replication server if source server is unavailable. is there a chance to get this feature in some of the next versions of spectrum protect? with best regards Stefan Savoric

Re: Ideal storage solution for SP and SP+ ???

The amount of TB's is important of course because the system must be able to provide the storage amount but its also about performance. We use IBM V5030E systems and under maximum load with 48 nearline drives these systems are at about 30% load so they are overkill for 48 drive systems, the

Re: ADSM-L Digest - 5 Jun 2020 to 8 Jun 2020 (#2020-53)

Please remove me from this mailing list. -Original Message- From: ADSM: Dist Stor Manager On Behalf Of ADSM-L automatic digest system Sent: Monday, June 8, 2020 9:00 PM To: ADSM-L@VM.MARIST.EDU Subject: ADSM-L Digest - 5 Jun 2020 to 8 Jun 2020 (#2020-53) There is 1 message totaling 53

Re: Ideal storage solution for SP and SP+ ???

We use IBM Cloud Object Storage boxes for our backend Spectrum storage...have eliminated all requirements for physical tape devices... -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rick Adamson Sent: Thursday, June 4, 2020 5:31 PM To:

Re: Ideal storage solution for SP and SP+ ???

Eric, Really appreciate the response. I am very familiar with both blueprints and will definitely go back over them in detail. My recall was that they were understandably IBM-centric and didn't specify minimal/ideal IO and performance requirements. We are almost exclusively a Dell/EMC shop

Re: Ideal storage solution for SP and SP+ ???

Hi Rick and Eric I hope you are well. To help here are the links: Blueprints for Plus: https://www.ibm.com/support/pages/node/1119489 Blueprints for Spectrum Protect: https://www.ibm.com/support/pages/ibm-spectrum-protect-blueprints Thank you Ailbhe ** Hi Rick,

Re: Ideal storage solution for SP and SP+ ???

Hi Rick, Have a look at the latest IBM Spectrum Protect Blueprints and the IBM Spectrum Protect Plus Blueprints. They are based on (of course) IBM hardware (v5100 series) but the performance is good and you have the ability to benchmark your performance and compare it with the performance from

Ideal storage solution for SP and SP+ ???

What storage solution is at the top of your list for Spectrum Protect and Spectrum Protect Plus? I am a former a Data Domain abuser who (regretfully) moved to EMC Isilon and now looking for the best possible replacement. Usable storage requirement of somewhere in the neighborhood of 500+ tb.

Re: Spectrum Protect Plus IA restore

Hi Del, Ah, ok! So the name of this option is a bit confusing then. It's not power on AFTER recovery, but DURING recovery. We will test this option as soon as possible, thanks again for your help! Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From:

Re: Spectrum Protect Plus IA restore

Hi Eric, "Power On VM after Recovery" is the option to use. "Recovery" is complete once the VM is registered in vCenter and mounted from the (vSnap) backup repository. This is almost immediate. No bits need to move. This setting will power on the VM immediately after mounting and prior to

Re: Spectrum Protect Plus IA restore

Hi Del, It doesn't seem to work. During the restore the option to start the VM is grayed-out in vCenter. SPP shows another option in the restore job settings (Power on after recovery), but that is not what I want, I want the VM powered on during the restore. I will open a case for this. Thanks

Re: Spectrum Protect Plus IA restore

Hi Eric, By default, a "Production mode" restore does a streaming restore. If you change the job option and uncheck "Enable streaming (VADP) restore" it will be a vMotion based recovery instead. (First, toggle the option to view 'Advanced Setup' and change it) This means it will instantly

Re: Spectrum Protect Plus IA restore

Hi Del, Let me clarify what I'm looking for. We want to restore a full VM and we want access to the VM while it's being restored. Until now I discovered the following limitations: 1) A Production restore restores the whole VM but only allows the VM to be booted after the restore has finished.

Re: Spectrum Protect Plus IA restore

Hi Eric, OK, I misunderstood when you said "IA" ... when I saw Instant Access, I typically think of a "Test mode" restore operation. But, I think you are referring to "Production mode" restore ( https://www.ibm.com/support/knowledgecenter/SSNQFQ_10.1.5/spp/t_spp_creating_vmware_restore_job.html

Re: Spectrum Protect Plus IA restore

Hi Del, >From what I read in the manual this creates a new VM with unique names and >identifiers in a fenced network. What if I want the original VM restored in >production? Thanks again for your help! Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message-

Re: Spectrum Protect Plus IA restore

Hi Eric, Full VM mount/instant Access can be done by selecting 'Test' radio button in the Restore mode. Test mounts the entire VM directly from the vSnap. Del "ADSM: Dist Stor Manager" wrote on 05/20/2020 05:09:12 AM: > From: "Loon,

Spectrum Protect Plus IA restore

Hi guys, We are testing the SPP instant access restore. If I understand things well, you cannot restore a full VM with IA in SPP, you only have this option available when you perform a disk restore. However, when we select both disks and perform a IA restore, the disks are created in the wrong

Re: SPP Message board & developerWorks

Hi Steve I wanted to first acknowledge your feedback; I have passed it along to the relevant team who will investigate the feedback with a view to improving the experience. Secondly, for IBM Spectrum Protect Plus I want to send you these helpful links. I hope they help. Featured Documents page

AW: [ADSM-L] SPP Security hole

Hi Steven, I can absolutely second this opinion. As a workaround, and to minimize security issues, you could instead go and do an instant access of the disk, mounting it as an additional disk to the vm, import the Volume Group/File System and restore the files manually. Not nice, but

SPP Security hole

Hi list. I've been told that this list is also for Spectrum Protect Plus so here goes. I'm about to build an SPP environment to back up a small VMWare environment. SPP is to be 10.5.1 and the nodes are all RHEL 7. Getting down into the details I see that for file indexing to work we need to

Re: SPP Message board & Developerworks

Hi Steven, I recommend using this same forum for Spectrum Protect Plus questions/comments. Spectrum Protect Plus is a fairly new component in the Spectrum Protect portfolio and will become more and more integrated as time goes on. Check here for the old developerWorks content:

SPP Message board & Developerworks

Hi All I'm soon to build an SPP server to back up a small VMWare environment. I have been unable to find anything remotely similar to this list concerning Spectrum Protect Plus. Is anyone aware of one? And, if anyone is listening the replacement for Developerworks sucks. I have no idea how to

Re: ANR1942W

Hi Eric, well, it depends. If you have a replication target server and there exists a CLOPTEST named windows, this shouldn't be overwritten by a node replication also using a cloptset named windows, at least to my opinion because the settings bundled in this clopset might be different. One might

Re: ANR1942W

Hi Eric, This is great feedback. Your input is very important to us. Can you click on the link in the User's Guide and submit it here? https://www.ibm.com/support/knowledgecenter/SSEQVQ_8.1.9/srv.admin/t_adm_repl_mng.html This will ensure it gets back to our documentation team and we can make

Re: ANR1942W

Hi Michael, If this is normal behavior, it shouldn't issue a warning message, do you agree? For IBM: The whole process of configuring and using a server with node replication is very poorly documented to my opinion. For instance, the procedure to remove a node is drastically different for a

Re: ANR1942W

Hello Eric, the explanation to ANR1942W states that this is desired as normal behaviour, if the CLOPTSET was already existing on the replication target. There has been IT18951 stating the opposite for enterprise administration I also observe this on servers who started replication between each

ANR1942W

Hi everybody, We are implementing node replication on our new server and I noticed the following warning message in the log: ANR1942W Option set SPSERVERS already exists. Skipping for replication from source server AMSE3. All our servers are using standard naming, so option sets are all named

Re: server interim fix level 8.1.9.300

FYI, IBM updated document 1171654 https://www.ibm.com/support/pages/node/1171654 Kind regards, Christian Am 23.04.2020 um 11:19 schrieb Erwann SIMON: Hi, "Interim fix 8.1.9.300 did not include APAR updates." This fix is to remediate CVE-2020-4415. -- Dr. Christian Scheffczyk

os upgrade from rhel6 to rhel7 with Spectrum protect 8.1.8

Has anybody done OS upgrade from Red Hat Enterprise Linux Server release 6.10 (Santiago) to Red Hat Enterprise Linux Server release 7.7 (Maipo) with Spectrum Protect 8.1.8 ? If so did you encounter any problem ? How did you resolve it Thank you Genet Begashaw

Re: MS SQL for Linux

Thank You Del. I have voted for the request. Regards Sarav +65 9857 8665 > On 24 Apr 2020, at 6:19 AM, Del Hoobler wrote: > > Hi Sarav, > > We have not seen a lot of demand for this yet. If you are interested, > please vote for this RFE: > >

Re: MS SQL for Linux

Hi Sarav, We have not seen a lot of demand for this yet. If you are interested, please vote for this RFE: http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe_ID=108504 Del "ADSM: Dist Stor Manager" wrote on 04/23/2020 03:28:25 PM: > From: Saravanan Palanisamy > To:

MS SQL for Linux

Team Done anyone know whether IBM will support Linux MS SQL in near future ? Regards Sarav +65 9857 8665

Re: server interim fix level 8.1.9.300

Hi Erwann, thanks a lot for the info! I missed it somehow? This fix seems to be a real critical one, so I will schedule downtime. Kind regards, Christian Am 23.04.2020 um 11:19 schrieb Erwann SIMON: Hi, "Interim fix 8.1.9.300 did not include APAR updates." This fix is to remediate

Re: server interim fix level 8.1.9.300

Hi, "Interim fix 8.1.9.300 did not include APAR updates." This fix is to remediate CVE-2020-4415. -- Best regards / Cordialement / مع تحياتي Erwann SIMON - Mail original - De: "Christian Scheffczyk" À: ADSM-L@VM.MARIST.EDU Envoyé: Mardi 21 Avril 2020 11:54:05 Objet: [ADSM-L] server

Re: server interim fix level 8.1.9.300

Hi Bent, thanks for sharing the info, I missed it. I will update. Kind regards, Christian Am 21.04.2020 um 13:01 schrieb Bent Christensen (BVC): Due to: IT31576: CONTAINER COPY TAPES DO NOT RETURN FROM PENDING STATE PROPERLY IT32181: AFTER SERVER UPGRADE TO 8.1.9.100 "PROTECT STGPOOL" DOES

Re: server interim fix level 8.1.9.300

Hi Rick, thanks for the answer. Am 21.04.2020 um 14:09 schrieb Rick Adamson: My understanding is that it addresses the APAR in this article: https://www.ibm.com/support/pages/node/6150429?myns=swgtiv=OCSSEQVQ=E_sp=swgtiv-_-OCSSEQVQ-_-E I don't think so. APAR IT32181 should be fixed in

Re: server interim fix level 8.1.9.300

My understanding is that it addresses the APAR in this article: https://www.ibm.com/support/pages/node/6150429?myns=swgtiv=OCSSEQVQ=E_sp=swgtiv-_-OCSSEQVQ-_-E Thank you, -Rick Adamson -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Christian Scheffczyk Sent: Tuesday,

Re: server interim fix level 8.1.9.300

Due to: IT31576: CONTAINER COPY TAPES DO NOT RETURN FROM PENDING STATE PROPERLY IT32181: AFTER SERVER UPGRADE TO 8.1.9.100 "PROTECT STGPOOL" DOES NOT PROTECT ANY EXTENTS I guess the latter one is why 8.1.9.100 is withdrawn? - Bent -Original Message- From: ADSM: Dist Stor Manager On

Re: server interim fix level 8.1.9.300

If you are using PROTECT STGPOOL, either local or to another server, then: Update!!! - Bent -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Christian Scheffczyk Sent: Tuesday, April 21, 2020 11:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] server interim fix level

Re: server interim fix level 8.1.9.300

Hello Bent, thanks for the info! Do you have more details? I'm using PROTECT STGPOOL on some instances but I don't see any errors? O.k., I will schedule downtime. Thanks and kind regards, Christian Am 21.04.2020 um 12:27 schrieb Bent Christensen (BVC): If you are using PROTECT STGPOOL,

Re: server interim fix level 8.1.9.300

Hello Groet, the download links are not the problem. What's missing is the info what did IBM change in 8.1.9.300? Thanks and kind regards, Christian Am 21.04.2020 um 12:16 schrieb Elberse, R.H.L. (Richard): You can find it here:

Re: server interim fix level 8.1.9.300

You can find it here: ftp://public.dhe.ibm.com/storage/tivoli-storage-management/patches/server and https://www.ibm.com/support/pages/node/1275274 Regards, Groet, Richard Elberse - IT & Informatiemanagement – ROC Midden Nederland - Bezoekadres: Brandenburchdreef 20, 3562 CS Utrecht /

server interim fix level 8.1.9.300

Hello, yesterday I received emails from "IBM My Notifications" that server fix pack 8.1.9.300 appeared, but I cannot find anywhere what changed? Document https://www.ibm.com/support/pages/node/1275274 has the download links and document https://www.ibm.com/support/pages/node/1171654 says

Re: IBM Spectrum Protect wiki replaced with new hosting site

Hi Kelly. Please provide the links for use. Appreciate the update. Regards, Joerg Pohlmann -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Kelly Axup Sent: Monday, April 20, 2020 13:08 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] IBM Spectrum Protect wiki replaced with new

Re: IBM Spectrum Protect wiki replaced with new hosting site

Oh I'm sorry, Mike and list... I had included a "pretty" link :), but forgot that the formatting would be removed. My bad! Here it is: https://www.ibm.com/support/pages/node/3608691 Kelly Axup +++ Information development Email: ka...@us.ibm.com

Re: IBM Spectrum Protect wiki replaced with new hosting site

This could have been the perfect time to share a link? Thanks for the update! Best regards, Mike , x7942 RMD IT Client Services On Mon, Apr 20, 2020 at

IBM Spectrum Protect wiki replaced with new hosting site

Just wanted to let everyone know in case you hadn't heard... The IBM Spectrum Protect wiki has been replaced with a new hosting site: Supplemental information and resources for the IBM Spectrum Protect product family The new site provide links to key documents for the IBM Spectrum Protect

Re: Baclient installer 8.1.9.0 no longer updates old registry password?

Tks Sven for you feed-back. Saluti Maurizio On 19.04.2020 12:01, Sven Seefeld wrote: Hey there, That would not work as I don't know the old password.  Passwords get automatically forced to update from the storage server end periodically and the only place they are "known" is in the

Re: Baclient installer 8.1.9.0 no longer updates old registry password?

Hey there, That would not work as I don't know the old password. Passwords get automatically forced to update from the storage server end periodically and the only place they are "known" is in the encrypted registry entry. I know, this is an old one, but I finally found the command to

Re: SQL query

You're welcome! Glad that ended up working, despite not having a great way to test it here. :) On Tue, Apr 14, 2020 at 12:07:33PM +, Loon, Eric van (ITOP NS) - KLM wrote: > Hi Skylar, > > I had to change your suggestion a little bit, but this one is working: > > select a.node_name, case when

Re: SQL query

Hi Skylar, I had to change your suggestion a little bit, but this one is working: select a.node_name, case when b.count is null then 0 else b.count end as count from nodes a left join (select node_name,count(*) as count from backups where (days(current_date) - days(backup_date) >= 30) and

SP for Virtual Environments and Win2019 Support

Looking for anyone who can provide info on this subject, does Spectrum Protect for Virtual Environments v.8.1.8 or 8.1.9 support Windows Server 2019 ? The documentation (All requirements and passport advantage) appears to have conflicting information. On the product knowledge center it refers

SPP to replace VMware Replication backups

Folks, Our VMware Replication system failed, again, this weekend and will probably require us to rebuild it, again (this has happened 3-times in the past year). We are looking to fully implement SPP to replace it - is this is what SPP is designed to do? Has anyone implemented SPP as a VMware VR

Re: SQL query

I forgot that GROUP BY depended on having an entry in the result table. Unfortunately I don't have a TSM server with a reasonably-sized backups table to test on (production ones are 1+ billion entries), so I'm kind of in thought experiment territory right now, but what if you did an outer join

Re: SQL query

Hi Skylar, Sorry, but this one doesn't work either, it returns the same results as all others. I don't think the NULL result is the issue here, it seems to be the way the results are returned as soon as you select multiple columns. In the following example ,when I select just one, the result

Re: SQL query

Ah, I think the problem is that comparing anything with NULL will be NULL (except comparing NULL with NULL, which is true). Try this: select b.node_name, count(*) from backups a right join nodes b on a.node_name=b.node_name and b.node_name like '%-ORC' where (a.backup_date is null or

Re: Error in OC for device class

Hi everybody, I would like to share the results of the case I opened for the device class error condition when it's not used by storage pools. I will explain the way it works by using the following abbreviations: FS=Free space on the filesystem(s) used by the deviceclass ML=Mount limit of the

Re: SQL query

Hi Skylar, I tried your query, but it also returns just one node with a number > 0, all other nodes (which have 0 files) are not listed. Thanks for your help! Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of

Re: SQL query

I think what you're looking for is an outer join: select a.node_name, count(*) from backups a right join nodes b on a.node_name=b.node_name and a.node_name like '%-ORC' where ((days(current_date) - days(backup_date) >= 30)) and a.state='ACTIVE_VERSION' and b.contact like

Re: AW: [ADSM-L] anyone running SPv8.1.8 server on rhel7.8?

It was the semaphore settings: This got it back up: [root@barge ~]# sysctl -w kernel.sem="250 256000 32 16384" kernel.sem = 250 256000 32 16384 [root@barge ~]# ps -ef | grep db2 root 3494 1 0 Apr06 ?00:00:04 /opt/tivoli/tsm/db2/bin/db2fmcd root 21406 30720 0 08:56 pts/0

AW: [ADSM-L] anyone running SPv8.1.8 server on rhel7.8?

The cause could be a misconfiguration of the linux kernel SEMIPHORE settings? What is the output of "ipcs -l" The suggested settings by IBM are: kernel.sem (SEMMNI) 16384 kernel.sem (SEMMSL) 250 kernel.sem (SEMMNS) 256 000 kernel.sem (SEMOPM) 32 Regard, Uwe -Ursprüngliche Nachricht-

Re: anyone running SPv8.1.8 server on rhel7.8?

Hi Eric, Did you checkout https://www.ibm.com/support/pages/spectrum-protect-server-fails-start-anr0169e-sql12225n? Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of J. Eric Wonderley Sent: dinsdag 7 april 2020

Re: anyone running SPv8.1.8 server on rhel7.8?

Hi, check your /etc/security/limits.conf for DB2 instance owner. Mine is: ispuser softnofile 26400 ispuser hardnofile 66000 Working fine with RHEL 7.7 Rgds, -- Sasa Drnjevic www.srce.unizg.hr/en/ On 7.4.2020. 14:07, J. Eric Wonderley wrote: > I upgraded

anyone running SPv8.1.8 server on rhel7.8?

I upgraded our target server from rhel7.6 to rhel7.8 and now dsmserv doesn't come up. The server worked fine on 7.6. After moving to rhel7.8 I now see this fail on an interactive startup: ANR0990I Server restart-recovery in progress. ANR0152I Database manager successfully started. ANR0172I

SQL query

Hi guys, It must be something very easy, but I can't seem find the solution myself... This is the query I use to list the total amount of Oracle backup files older than 30 days: select count(*) as OBSOLETE_BACKUPS from backups a,nodes b where ((days(current_date) - days(backup_date) >= 30))

Re: Moving data in cloud storage pool

The "AllowTierTargetDir" is not supported for cloud container pools. It is only supported for directory container pools. If you can't do something within Cloudian directly (transparently to Spectrum Protect) one option is to create a pool with the correct user and point all new backups here

Re: Moving data in cloud storage pool

Hi, I have head a similar requirement and asked the Support about it. They advised to create another pool and use tiring to move the date. " Hi Jonas, thanks for your reply and patience on this case. I have checked your inquiry regarding moving/migrating data from an existing S3 provider to

Moving data in cloud storage pool

Hi, I have to move data from a bucket in a cloud container storage pool that unfortunately was created with the wrong owner. I understand that I can't change the owner of the bucket directly (on the S3 level), neither can I copy the data to a new bucket in S3 and change the bucket name of

SPOC date format

Hi everybody, The report builder in SPOC used a date format of "Month DD, ". Has anybody found a way to change this? I would rather have DD-MM-YY, but I haven't found a way. It doesn't seem to be related to the SQL output itself, because the SQL result is formatted properly. Thanks for

Re: Combining SQL queries

Eric: nope. The sub-select failed (rc=100) so it propagated as an empty set/column for the top select. Not sure how the SQL around that. As an aside, I suspect your SQL would fail if you had multiple StgPools with Containers since the sub-select would return multiple PCT_UTILIZED rows. (you

Re: Combining SQL queries

Hi all, Although Tom's SQL statement works very well, there seems to be something weird in the way the WHERE statement is handled. This is the output on a server with a directory container pool: select * from (select cast(sum(used_db_space_mb/tot_file_system_mb*100) as decimal(3,1)) as

Remove

Please remove me from the list. It's been a great ride! Respectfully, S. Scott Crowell B.S., MCSE: Cloud and Infrastructure, MCSA: Server 2016, VCP: DCV2019, Security+CE System Administrator Zolon Tech, Inc. USAMRDC Information Management Fort Detrick, MD 21702 Telework Phone: 240-252-5987

Re: AW: [ADSM-L] Still have issue with not able to use Scratch LV tapes

After try all things I just did checkout on the tapes that was worm and check in them again Now tsm see them as worm after I did checkin again and seems is fine. I managed to write at one of them LIBIBM3500 RDP000LV Scratch(Worm) 2,734 LTO LIBIBM3500 RDP003LV Private(Worm) ARDTSM1 Data 2,743

AW: [ADSM-L] Still have issue with not able to use Scratch LV tapes

Lucian, what was the command used for checkin that WORM Scratch tapes? Did you use "CHECKLABEL=YES"? Using LTO it is mandatory to use that parameter during checkin. https://www.ibm.com/support/knowledgecenter/SSEQVQ_8.1.9/srv.solutions/c_tapeops_worm_checkin_ulw.html Regards, Uwe

Re: Combining SQL queries

Hi Tom, This one does exactly what I was looking for: single line, multiple columns in SPOC, thanks! Everybody, thank you very much for your help! Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Tommaso Bollini

Re: Still have issue with not able to use Scratch LV tapes

I've seen this sort of issue if the addressablity of the drive is wrong, e.g. logical drive 1 has physical drive 2 address. So library mounts tape in drive 1 but instance tries to read label in drive 2 and fails, marks the tape as unavailable and then works its way through all the scratch tapes.

R: [ADSM-L] Combining SQL queries

I need to use different syntax from the one of Eric, like: select * from (select count(*) as "Number_Of_Failed" from events where scheduled_start>current_timestamp-24 hours and status='Failed') as failed, (select count(*) as "Number_Of_Missed" from events where

Re: Combining SQL queries

Hi Eric, You can combine these two queries by executing them as subqueries: select * from ( select count(*) as "Number_Of_Failed" from events where scheduled_start>current_timestamp-24 hours and status='Failed' ) failed, ( select count(*) as "Number_Of_Missed" from events where

Re: Combining SQL queries

Something like this (name columns as desired): select status, count(*) from events - where scheduled_start>current_timestamp-24 hours and - ( status='Failed' or status='Missed' ) - group by status On 3/26/20 10:51 AM, Loon, Eric van (ITOP NS) - KLM wrote: > Hi guys, > > I have two SQL

Combining SQL queries

Hi guys, I have two SQL queries: select count(*) as "Number_Of_Failed" from events where scheduled_start>current_timestamp-24 hours and status='Failed' select count(*) as "Number_Of_Missed" from events where scheduled_start>current_timestamp-24 hours and status='Missed' Is it somehow possible

Re: Error in OC for device class

Hi Erwann, Yes, that's indeed what I discovered too. When I issue the command q monitorstatus status=error, the error status trigger which SPOC uses is displayed. In my case: Server Name Activity DateActivity NameElement Name Element Element String Element State

Re: Still have issue with not able to use Scratch LV tapes

On 25.3.2020. 20:51, Lucian Vlaicu wrote: > Now i see only first one is scratch and the rest are private? >how did > they got in private since was not used? Check the actlog -- > Not sure if is relevant but yesterday all these were scratch > > > tsm: ARDTSM1>q libvol > > Library Name

Re: Still have issue with not able to use Scratch LV tapes

On 25.3.2020. 20:03, Lucian Vlaicu wrote: > -10 tapes in total in scratch > > -I think aroung 650Gb, but why is relevant? > > > > - only one file around 40Gb Because you could have files bigger than single tape capacity or disk storage pool capacity, and in your previous post you had only one

Re: Still have issue with not able to use Scratch LV tapes

Yes that is relevant. That probably means they were picked up by your other storage pool. You can check with "q vol RDP000LV" I believe in the past I have manually added volumes to a storagepool probably with "def volume" But, it has been a while ago. [image: OCIO-logo-Transparent.png]

Re: Still have issue with not able to use Scratch LV tapes

Not sure if is relevant but yesterday all these were scratch tsm: ARDTSM1>q libvol Library Name Volume Name Status Owner  Last Use  Home    Device Element Type --- -- - --- --

Re: Still have issue with not able to use Scratch LV tapes

-10 tapes in total in scratch -I think aroung 650Gb, but why is relevant? - only one file around 40Gb the tape drives are fine since the other mgmtclass which use normal lto5 (tapes) is working. The issue is only with the new one which is done for Worm tapes On 3/25/2020 3:22 PM, Sasa

Re: Still have issue with not able to use Scratch LV tapes

> Maximum Scratch Volumes Allowed: 999 > Number of Scratch Volumes Used: 0 Obviosuly not a problem Some other possibilities: -how many scratch tapes are available in total? -what is the size of data in STDHRDISKW pool? -do you have any idea of file sizes in STDHRDISKW pool? -ownership and

Re: Still have issue with not able to use Scratch LV tapes

tsm: ARDTSM1>q stgpool STDHRLTO5W f=d     Storage Pool Name: STDHRLTO5W     Storage Pool Type: Primary     Device Class Name: ULTRIUM5W    Estimated Capacity: 0.0 M    Space Trigger Util:

Re: Still have issue with not able to use Scratch LV tapes

Hi, try this where NEXTPOOL is your Tape pool where you migrate: q stgpool NEXTPOOL f=d and look for: Maximum Scratch Volumes Allowed: 100 Number of Scratch Volumes Used: 87 Update stgpool if that is your problem... Rgds, -- Sasa Drnjevic www.srce.unizg.hr/en/ On 25.3.2020. 13:16,

<    1   2   3   4   5   6   7   8   9   10   >