This is a "it depends on your infrastructure" we do duplex the SCA and LOCK only , we have ICF's active on all our footprints and an Active member of the DB2 Data Sharing group on each CEC , in discussion with IBM we where informed that DB2 would not be able to rebuild the SCA and LOCK data in we had a CEC failure and one of the Active sharing members went down as well. I have no specific performance data as the config was not optional.
Regards Gerard Ceruti may the 'z' be with you -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Skip Robinson Sent: 12 December 2007 12:25 AM To: [email protected] Subject: Re: db2 lock structures duplexing (I'm not dismissing other responses, just focusing on the original question.) Pawel, If you have only ICF LPARs contained in the same CECs that run the MVS images in question, you MUST duplex the structures. Overhead may be a pain point but it is not a variable in your decision.. Failure to duplex exposes you to recovery hell if you lose an entire CEC. Having said that, I cannot recall losing an entire CEC in this millennium. Still, it's a situation Dr. Murphy would rub his hands and chortle over. In the case of DB2, he will do his own duplexing because (I believe) the critical need for duplexing was recognized and addressed by them before system managed duplexing went GA. The books will tell you which structures to duplex, which by system and which by 'user', as well as structures like ISGLOCK (GRS) that do not need duplexing. You should follow the recommendations religiously. . . JO.Skip Robinson Southern California Edison Company Electric Dragon Team Paddler SHARE MVS Program Co-Manager 626-302-7535 Office 323-715-0595 Mobile [EMAIL PROTECTED] Pawel Leszczynski <pawel.leszczynsk [EMAIL PROTECTED]> To Sent by: IBM [email protected] Mainframe cc Discussion List <[EMAIL PROTECTED] Subject .EDU> db2 lock structures duplexing 12/11/2007 08:20 AM Please respond to IBM Mainframe Discussion List <[EMAIL PROTECTED] .EDU> Hello everybody, I've got a question to guys running DB2 in parallel sysplex environment. Do you duplex DB2 lock structures i.e. _LOCK and _SCA structure? What is the overhead connected with it? In our 2-node PS environment we don't have stand-alnone CF, only internal CF in two different footprints. We want to avoid situation when damage of one of the boxes will bring the whole DB2 sharing group down. Regards, Pawel Leszczynski PKO BP SA ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html __________________________________________________________________________________________________________________________________ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries ("the Group"). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za ___________________________________________________________________________________________________________________________________ ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
