× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi,

I have an 9406-520 at V5R3 which I use for development and is not under maintenance. Disk unit 1 has failed but the system is still running as I have RAID5 setup. I have looked at eBay for a replacement disk but the only ones I can find are in the US and cost more in shipping than they do to buy and I would then have to add import duties and VAT.

The option I am looking at is backing up the system with GO SAVE option 21 , removing the failed disk and then restoring the system. I think I would also have to move one of the other disks to position 1 to replace the failed unit. Disk usage would still be at about 40% so I am not in desperate need to replace the failed disk. I would just like to get RAID5 active again on the remaining disks.

Does this sound reasonable? Is there anything else I should be doing apart from taking as many backups as I can?

Display Disk Configuration Status

Serial Resource
ASP Unit Number Type Model Name Status
1 Unprotected
1 21-440D0 4326 070 DD006 DPY/Failed
2 21-448A9 4326 074 DD003 DPY/Unprotected
3 21-44A87 4326 074 DD004 DPY/Unprotected
4 21-44B35 4326 070 DD007 DPY/Unprotected
5 21-44643 4326 074 DD005 DPY/Unprotected
6 21-3327B 4326 074 DD002 DPY/Unprotected
7 21-44E3A 4326 070 DD001 DPY/Unprotected





Regards,

Fred Mitchell

--

e: fred@xxxxxxxxxxxxxxxxxx
w: www.conciseconsult.com
w: www.fredmitchell.com

m: +44 (0) 7711 168395
t: +44 (0) 191 432 7875
f: +44 (0) 870 051 7273

Skype: Fred_Mitchell
MSN: fred@xxxxxxxxxxxxxxxxxx

Concise Consulting Ltd.
36 Williams Park
Benton
Newcastle upon Tyne
NE12 8BL

Registered in England, number 3473386

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: 02 April 2010 23:11
To: Midrange Systems Technical Discussion
Subject: Re: sql scan for special characters

To use the LIKE predicate and be able to find strings with the wildcard characters, you have to escape them. You do this using an ESCAPE expression. You want to use a character that won't otherwise be in any of the values tested.

LIKE 'AAAA+%BBB%' ESCAPE '+'

means that it will match values that start with AAAA%BBB - the final % sign is a wildcard, the first one is a true % sign.

Found this in the reference manual under predicates in the language elements chapter (2, that is).

HTH
Vern

Musselman, Paul wrote:
The scan for PercentSign isn't '%%%%' is it?

Paul E Musselman

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.