text:
Courtyard by Marriott San Juan Isla Verde
Why We Love It
- Prime beachfront location "favored by beach lovers for its fine white sand and gentle blue water" (Frommer's)
- Multiple dining options, many of which offer ocean views, include tapas and casual Caribbean cuisine
- Hear the waves hit the shore and unwind in a beach hammock beneath the swaying palm trees
- All rooms have private balconies and ocean views
"Meets all the requirements for an easy Caribbean getaway" -- Travel + Leisure
Map & Directions
Rooms & Rates
A quick five-minute ride from the airport places guests at this perfectly located resort "on one of Isla Verde's famous wide, white-sand beaches." Guests have access to the same views, beach and amenities as the resort's fancier neighbors, but at much more affordable prices.
Hang in the pool while sipping cocktails from the swim-up bar, snorkel off the beach, take a bike a ride to a nearby attraction or learn to salsa dance at the lobby bar. Younger visitors can splash in the children's pool, or get a cone from the onsite ice cream parlor. After a walk on the Isla Verde, "probably the city's prettiest strand," take a nap in one of the beach hammocks, or soak in the whirlpool (Travel + Leisure). Old San Juan, known for its forts, history and restaurants, is about 15-minutes away.
All rooms have a view of the Atlantic Ocean and come with a microwave and free Wi-Fi; since it is close to the airport, it's possible to hear occasional take-off and landing noises. Guests can sample local dishes while taking in ocean views at Café Tropical, have a quick bite at the casual poolside Papaya Grill or have tapas at the romantic Sirena Restaurant. After dinner, head over to the Picante Lounge for live music, dancing and tropical drinks, or gamble in the on-site casino.
- "Directly on one of Isla Verde's famous wide, white-sand beaches, and blocks away from Isla Verde Avenue, the neighborhood's main thoroughfare" -- Oyster
- "With a wraparound veranda lined with massive hammocks and beach chairs, laid-back is the driving force at this property" -- Frommer's
- Infant cots / cribs
- Bar
- Casino
- Games room
- Gym / fitness center
- Hot Tub / Jacuzzi
- Outdoor pool
- Pool bar
- Restaurant
- 100% smoke-free
- 24-hour front desk
- Currency exchange / ATM
- Express check-in / checkout
- Laundry / dry cleaning
- Safe in reception (fees apply)
- Business center
Room amenities
- Air-conditioning
- Coffee / tea-making facilities
- Iron and ironing board
- Pay-per-view / movies on demand
- Safe
- Flatscreen TV
- iPod/iPhone docking station
- Complimentary Wi-Fi in guest rooms
- Complimentary Wi-Fi in public areas
- Hair-dryer
- Parking (fees apply)
- Valet service (fees apply)
Please note: Some amenities may not be available in all rooms and some amenities or services incur an additional charge and are subject to change. Please check with the hotel directly.
Check-in: Standard check-in time: 4pm
Checkout: Standard checkout time: 11am
Cancellation: Cancellation policy & booking conditions vary by 'rate plan'. These will be displayed on the payment page after you have searched for your dates and selected a rate.
Additional details:
Pets not allowed. The following fees and deposits are charged by the property at time of service, check-in or checkout. You'll be asked to pay the following charges at the hotel:
You must present a photo ID when checking in. Your credit card is charged at the time you book. Bed type and smoking preferences are not guaranteed. Your reservation is prepaid and is guaranteed for late arrival. The total charge includes all room charges and taxes, as well as fees for access and booking. Any incidental charges such as parking, phone calls, and room service will be handled directly between you and the property.
Mandatory Fees and Taxes
The hotel resort fee includes:
We have included all charges provided to us by the property. However, charges can vary, for example, based on length of stay or the room you book.
The following fees and deposits are charged by the property at time of service, check-in or checkout.
You'll be asked to pay the following charges at the hotel:
Have a Problem? Contact Travelzoo.
Customer Service available 24 hours
Rates may vary by date, are subject to availability and are not guaranteed until your purchase is complete.
The room rates listed are for double occupancy per room unless otherwise stated and exclude tax recovery charges and service fees.
*Unless otherwise stated, Travelzoo-exclusive extras are valid once per stay (based on two adults sharing). Value is an estimate based on double occupancy. Extras are only included with Member Rates and may not be available on all dates. Extras are non-transferable and have no cash value. Total value may vary depending on time of booking and availability. When included, breakfast may be limited to 2 guests per stay subject to hotel's discretion. Other restrictions may apply; see our T&Cs for details.
It is the responsibility of the hotel chain and/ or the individual property to ensure the accuracy of the photos displayed. Travelzoo is not responsible for any inaccuracies in the photos.


text:
$440.00Go to Amazon Marke...
Take to the sea, the slopes or the streets with complete confidence when you wield this ruggedized Sony Cyber-shot DSC-TX20 digital camera. Waterproof, dustproof, shockproof and slim enough to slip...More
Amazon Marketplac...
Unknown Tax
Shipping N/A
|New Item
Find, Compare, Read Reviews & Buy the Sony Cyber-shot DSC-TX20 16.2 Megapixel Compact Camera - Blue (3" Touchscreen LCD - 16:9 - 4x Optical Zoom - 16x - Optical IS - 4608 X 3456 Image - 1920 X 1080 Video - HDMI - HD Movie Mode) Online @ Yahoo Shopping Want to see your products in Yahoo Shopping? Advertise with us. Sitemap All Brands
Terms | Privacy | About Our Ads | Help

subset: commoncrawl


text:
Google gifts 'Upspin' file sharing tech to the open-source community
The experimental project aims to make file sharing easier.
The experimental project aims to make file sharing easier.
The technology might make VR demonstrations and sales pitches less of an awkward experience.
Microsoft is hooking up with India's national ID system to deliver services from Skype and LinkedIn.
Traditional IT organizations must step up to lead the implementation of new enterprise-wide digital platforms.
Vocus has recorded a half-year net profit of AU$47.2 million on revenue of AU$888.2 million thanks to its M2 and Nextgen acquisitions, and has signed a 15-year AU$20 million deal with Superloop for national and international capacity.
More than half of business leaders surveyed for the global Internet of Things Business Index 2017 said progress has not happened as quickly as expected.
Informatica bought U.K.-based Diaku for its Axon platform.
The capital raised by online lending company Prospa will be used for production expansion and distribution, as well as for recruitment.
New Zealand's High Court has ruled in favour of Spark, 2degrees, and InternetNZ, prohibiting Sky TV and Vodafone NZ from putting their merger into effect until more than three days after the regulator's decision.
The Victorian government has said it will attach a AU$2 levy to taxi and ridesharing fares in the state as part of deeming services such as Uber officially legal.
Australian-listed Data#3 has posted AU$5.8 million in net profit on revenue of AU$506 million for the first half of the 2017 financial year.
The bank has unveiled its plans to create an enterprise-wide, real-time data lake.
LG and Google teamed up to create the LG Watch Sport, one of the first devices to run Android Wear 2.0.
Test demonstrates potential efficiencies drones can provide on rural delivery routes
The deal aims to offer consumers custom clothing based on their habits and history.
Hands-on with Android 7 Nougat on the Samsung Galaxy S7: screenshot gallery
Classic Steve Jobs disses you can put on your next resignation letter
Enterprise Software
"Windows as a service" means big, painful changes for IT pros


text:
Sprache in Deutsch ändern |
Hooray! You've made it!
You found probably the funniest site of the internet! Share and discover hilarious, crazy and weird videos, images or what ever you want and find people who share your sense of humour.
We suggest English as your preferred language. You can change the language next to the bendecho logo.Let it rock! ;-)
Animal Humping
metacafe.com - Animal Humping lol
|Animal, Funny, Hase, Katze, Lol, Poppen, Rammler
|9 years, 3 months ago
Add a comment
Submit New
Rising Upcoming Votes
Related Stuff
Stuff of the Month
Action Feed
- New York City Harbor Boat Tour T...
- Underwater Galapagos
- Galápagos Sea Lions
- Dogs Playing In Slow Motion
- Sit - P.Carrera
- Tony Valor - "Up & Away" ft. Mar...
- The Christopher Brothers -"Let M...
- Tafari - Unforgettable
- Gold Standard Ltd - Party Don't ...
- Yalee - Friends With Benefits


text:
Gurgaon city progress very well many people are using car so more requirements ac repair in gurgaon. Our portal provides better facility Car AC repairs in gurgaon, noida, delhi and whole ncr. These car ac repairs provide better services for you. All service very fast and save your time and money. All Car AC repairs in gurgaon listed on our portal. You may search very easy by our portal www.fairsearches.com ad contact +918750299299.
Ad ID: 10725


text:
My Favorite Shops
Double-click on the map to search
Showing results for:
initial text
Shop locations generated by Google Maps
Hi! Welcome to Potbelly at the Shops at Legacy. I have been with Potbelly since 2004 and have worked at this location numerous times in the past so some of you might recognize me and I'm glad to be back!
Besides giving you a fun and friendly atmosphere for your lunch or dinner, we specialize in corporate catering, so keep us in mind when you've got a big meeting, month-end late nights, or just want to thank your team with a dozen or so freshly baked oatmeal chocolate chip cookies.
I know how important it is to have a go-to lunch option in the neighborhood when you're hungry but strapped for time, and I pledge to serve you quickly, courteously, and always with my signature bright smile.
So come on by, and be sure to say hello!
Hi! Welcome to Potbelly at the Shops at Legacy. I have been with Potbelly since 2004 and have worked at this location numerous times in the past so some of you might recognize me and I'm glad to be back!
Sun. - Thur. 11am to 9pmFri. & Sat. 11am to 9pm
Fee: 10% (Min. $3.50; Max. $10)
Minimum: $25.00
Perfect for Little Potbellians 6 and under
Served toasty warm
with cheddar cheese
red sauce & provolone cheese
just cheddar cheese
meatballs, provolone cheese & red sauce
little version of our classic
Chicken EnchiladaChiliGarden Vegetable
ChiliGarden Vegetable Loaded Baked Potato
ChiliLoaded Baked PotatoTomato
Broccoli CheddarChiliTomato
The MAC is BACK!
Craft Your Own Mac n Cheese is back!! To heat things up we've added a new option of BUFFALO CHICKEN MAC N CHEESE!
Our Delicious Mac N' Cheese topped off with chicken and Frank's Red Hot Sauce (plus whatever you like!) If Mac N' Cheese isn't your thing we still have the Buffalo Chicken Sandwich made with our grilled chicken, blue cheese crumbles, ranch dressing topped off with Frank's Red Hot Sauce.
Get into the Fall season and finish off your meal with our NEW Pumpkin Pie Cookie! It's delicious!
See you guys soon!
We have live music throughout the week.
Learn More


text:
Most Dolphins Season-Ticket Prices Will Not Change Riddick: 49ers Almost Hired Him, McDaniels Phillies Diss Christie With "Bridgegate" Reference Manfred Confident In Tigers Under Chris Ilitch Marlins Sale Ends Amid Loria Ambassador News Redskins Analyst: Is McCloughan Drinking Again? Predators Could Sell Out All Home Games Are Knicks Bad For Long-Term NBA Image? Fowler Disputes Depiction Of Role In Padres Sale Mets Bringing Back Exhibition Game Against Army
Upcoming Conferences and Events
Apr 19-20
Apr 20
May 24
May 31 - Jun 1
Jun 15-16
SBD/July 30, 2012/Franchises
Glen Taylor Says He Has Found A Successor To Eventually Take Over T'Wolves, Lynx
Published July 30, 2012


text:
- Hi there, welcome to Tribesmart. Log in to get started...
Softpress - The Ultimate Web Production Toolkit
Guide price: £180
Last updated on 11th May 2009
Tags: softpress
Softpress - The Ultimate Web Production Toolkit
''Softpress - The Ultimate Web Production Toolkit. The Apple Online Store has a fantastic range of EXCLUSIVE offers including: Free iPod engraving, Signature Gift wrap, exclusive iPod (PRODUCT) RED, Customize your Mac, Free Shipping on all orders over £78 and introducing cross border gifting!''
Login or Register to add this to your wish list or favourites.


text:
Local Victoria Vehicle Only, Accident Free, All New Set of Tires, Eco Mode, Bluetooth, Remote Keyless Entry, Steering Wheel Audio Controls, and more... The 2014 Hyundai Accent represents a strong choice for a small hatchback in the increasingly competitive subcompact car class. You'll love the Accent's handsome styling, above-average performance and solid build quality. SPECIAL COMMUNITY SUPER SALE on now in Courtenay only! Ends February 26th. No Frills. No Gimmicks. Just Low Prices. Call or drop by today. Galaxy Motors is the #1 used car dealership on Vancouver Island with 5 locations to serve you in Colwood, Duncan, Nanaimoand Courtenay. Hundreds of fully reconditioned vehicles to choose from with finance rates starting at 3.99% OAC. Need your vehicle serviced? No problem we service all makes and models as well. Apply online or visit us in person and let us get you into your new vehicle today! Documentation Fee $499 and taxes are extra.
For this vehicle based on mileage, region and options.
This graph compares the vehicle to the average market price for a 2014 Hyundai Accent in your area based on recent listings on autoTRADER.ca. It is intended only as a guide. Factors such as vehicle condition can affect prices.
This email address will be shared with the seller of the vehicle as seller has paid for the CarProof report. Privacy Policy


text:
1.Situation Analysis
Cadbury Beverages, Inc. is the beverage-manufacturing division of Cadbury Schweppes PLC. It was created in 1969 by a merger of Schweppes PLC (1783, London, the first world's soft drink maker) and Cadbury (1830, Birmingham, a major British confectionery manufacturer). In 1989, the Cadbury Schweppes PLC was one of the world's largest multinational companies and the world's third largest soft drink marketer (behind Coca-Cola and PepsiCo), with worldwide sales of $4.6 billion, sold in 110 countries. Beverages accounted for 60 percent of company sales and 53 percent of its operating income.
Additionally, at that time, Cadbury Beverages, Inc. was the fourth biggest soft drink marketer in the US (behind Coca-Cola, PepsiCo, Dr.Pepper-7Up), with a carbonated soft drink market share of 3.4 percent, and the market leader in some specific soft drinks categories (see exhibit 1).
2. Problem or Opportunity
In January 1990, the Cadbury marketing team decided to take up a challenge of re-launching the Crush, Hires and Sun-Drop soft drink brands, recently acquired from Procter&Gamble (October 1989). In the beginning, the marketing executives intended to focus on re-launching the Crush brand on the soft drinks market. As a result, three main issues need to be tackled:
•Rebuilding a cooperative relationship with bottlers,
•developing a base brand positioning consistent with the brand equity, •developing (objectives, strategies) and budgeting the advertising and promotion program.
The Carbonated Soft Drink Industry in the U.S.
Three main actors participate in manufacturing and distribution of carbonated soft drinks in the United States: concentrate producers, bottlers, and retailers. The concentrate producers' and bottlers' roles and margins of are different for regular and diet drinks.
There are approximately 40 concentrate manufacturers in the US, but only three of them (Coca-Cola, PepsiCo, and Dr. Pepper/7Up) account for 82 percent of industry sales. As far as bottlers are concerned, they are present in a number of 1,000 in the United States. They may be either owned by concentrate producers, or franchised. Franchised bottlers are usually given the exclusivity rights for a certain territory, but they cannot sell a directly competitive brand.
Concerning retailers, those are supermarkets (40 percent of carbonated soft drink industry sales), convenience stores and small retail outlets, vending machines, and fountain service (ex. McDonald's). Among the above mentioned, supermarkets are claimed to be crucial in the company's distribution net.
Industry Economics
Concentrate producers typically arrive at a gross profit of 86% (regular drinks), or 87% (diet drinks). When we take off selling and delivery, advertising and promotion costs and general and administrative expenses, the net profit may reach either 16% (regular drinks), or even 30% (diet drinks).
On the other hand, the gross profit for bottlers usually accounts for 43% (diet drinks), or 46% (regular drinks), whereas the net pretax profit gets at 12% (diet drinks), or 15% (regular drinks).
In view of the analysis of the above cost structure it seems obvious that concentrate producers should be more interested in manufacturing diet soft drinks, and bottlers should slightly prefer mixing and packing regular drinks.
Brand Positioning
The four main competitors in the orange carbonated soft drink category implemented different positioning strategies for their products. Minute Maid Orange stressed the orange flavor of their products, Sunkist attempted to associate drinking their product with a specific lifestyle (ex. teens lifestyle). Also, they targeted different age groups and household models: Mandarin Orange Slice and Minute Maid Orange focused their attention on young adults with no children (singles, couples) while putting stress on "better for you" idea...


text:
Wedding veil
Found: 146 products← Back to category "Wedding and evening hats"
The veil embroidered 1,35kh1,35m 0001
The veil embroidered 1,35kh1,35m 0001 We are dreamers. History of this brand began in the 2010th year in small studio, but with the excellent concept Read more
Verified partner
Premium Business
Delivery fromUkraine
This company received an enquiry 2 day ago
Display phones
Site: mistrelli.com
Svetlana Voroschuk veil
Veil from Svetlana Voroshchuk (Svetlana Voroschuk ™) the exclusive catalog of veils, sale Chernivtsi Kiev, Vinnytsia, Donetsk, Dnipropetrovsk, Luhansk Read more
Verified partner for over 5 years
Premium Standard
Delivery fromUkraine
Display phones
Site: voroschuk.com
The veil is wedding
Wedding veil for the bride a wide choice. From the producer - the most reasonable prices and the highest quality, export is possible. We take wholesal Read more
Verified partner
Premium Standard
Delivery fromUkraine
Display phones
Site: mary-grand-mariage.com
Wedding, final dresses - individual tailoring, the small wholesale is possible.
Wedding dress, veil, accessories to a wedding. Our masters will help to create to you a unique image for a celebration and to pick up all necessary f Read more
Delivery fromUkraine
The veil wedding 001 to buy in Chernivtsi
The veil wedding 001 to buy in Chernivtsi Each girl dreams to become bride. Each bride dreams of beautiful veil. Wedding veil - the main accessory Read more
Delivery fromUkraine
Delivery fromPoland
The veil is three-storied
Available three-storied veil, processed by a satin inlay. Color is white. Veil three-storied (Kryvyi Rih), veil long, veil, wedding veil, white ve Read more
Delivery fromUkraine
The veil is wedding
Wedding accessories of own production. Finishing materials: Laces. Beads, bugles - MATSUNO BEADS (Japan). Pastes, crystal - SWAROVSKI (Austria) Spec Read more
Delivery fromUkraine
Veil the wedding embroidered "Primrose
Price:22.62 EUR
The veil "Primrose" with a gentle and refined embroidery is decorated with beads and paillettes in tone of the main thread. The embroidery is executed Read more
Delivery fromUkraine
Delivery fromUkraine
Handwork veil
Material: English fatin oryginal Producer: Ksena Finishing: machine embroidery Read more
Delivery fromUkraine
Handwork veil
The wedding salon DOMINISS will offer you: - hire, sale of wedding and evening dresses; - dresses for a graduation party; - production and tailoring o Read more
Delivery fromUkraine
The bride's veil embroidered handwork
The bride's veil embroidered handwork The veil is produced three standard sizes: with a diameter of 135 cmwith a diameter of 185 cmoval 135 cm by Read more
Delivery fromUkraine
The veil is wedding, long, short, tailoring, sale, wholesale, retail, Ukraine, Russia
The veil is wedding The creative workshop APILAT is open for cooperation and actively works with wholesale buyers. We make the models small parties Read more
Delivery fromUkraine
Headdress of the bride
Let's make a veil depending on model of your wedding dress. Consultation of the professional designer. The selling assistant will help you with the Read more
Delivery fromBelarus
Wedding dresses wholesale. Model No. 143
If interest wholesale prices, write on e-mail, I will send the wholesale price list. Read more
Delivery fromUkraine
He veil is shor
computer embroidery - a veil Read more
Delivery fromUkraine
Bride's veil
Veil of the bride of f013-08 Read more
Delivery fromUkraine
Didn't find required product?
Suppliers will contact you
For last 30 days 107940 leads received the offers from the companies
Trading platform Allbiz offers to see the catalog Wedding veil which contains 146 products offers from 3 companies and enterprises. Don't know what Wedding veil to buy? You can clarify the specifications, see photos Wedding veil and choose the best seller and supplier. Buy Wedding veil trough online ! On Allbiz — You can just place your order right on the site.


text:
Greetings Guest!!Dismiss Notice
In order to combat SPAM on the forums, all users are required to have a minimum of 2 posts before they can submit links in any post or thread.
[EVE News] Extended downtime on Monday, July 16 and Tuesday, July 17
Discussion in 'EVE News' started by EVE News, Jul 13, 2012.


text:
Save the products you like here
This product is out of stock. Customers interested in it also viewed these products
Sold Out
Avira HomeMosaic Design Bath Towel
Rs 699
Get ready to enwrap yourself in this black coloured bath towel from Avira Home after a relaxing bath. Featuring an attractive design, this bath towel will be a classy addition to your bath linen collection. Made from 100% cotton, this towel is soft against the skin and highly absorbent. Any item shown in the image, apart from the product/package content is for display purpose only.
- Secondary ColorWhite
- SizeRegular
- Material100% Cotton
- Quality520 Gsm
- Wash Caree threads, trim with scissorsLow,Wash Similar Colors Together, Do not pull loosMachine Wash,Do Not Bleach,Do Not Iron,Tumble Dry
- Key Features540 GSM Jacquard woven design. Azo & Formaldehydefree dyes
- Product Dimensions (Length x Breadth)69.85 Cm x 139.7 Cm (27.5 Inches x 55 Inches)
- ColorBlack
- Package Contents1 Bath Towel
- REVIEWSREVIEWS FOR Mosaic Design Bath Towel
Be the first to write a review about this product


text:
Jeffrey Marston
Mr. Marston has been named a partner in the Washington law firm Lotstein Buckman LLP. Mr. Marston has a national practice representing clients in a variety of matters relating to mortgage banking, real estate finance and software licensing. His practice includes reviewing, drafting and negotiating servicing guides and servicing rights purchase and sale agreements, as well as servicing, subservicing and interim servicing agreements.
Copyright 2004 Thomson Media Inc. All Rights Reserved. http://www.thomsonmedia.com http://www.mortgageservicingnews.com
Next in News ►
Decisions, Default Rates, & Debt-To-Income The QM Rule's Impact


text:
The Cleveland International Film Festival promotes artistically and culturally significant film arts through education and exhibition to enrich the life of the community.
Year: 2012
Country: USA
Run Time: 83 minutes
To many, World War II is a distant memory. And to our youth, its importance can be lost in the modern world. Although there are still veterans of the war living among us, based on recent statistics we are losing them at the rate of approximately 900 per day. To this dwindling number of men and women the images of the war remain vivid. The impact of what they experienced continues to weigh heavy on their hearts and minds. It would be impossible to truly repay these brave veterans for their service. However, the Honor Flight Network – a non-profit organization started in Springfield, Ohio in 2005 – aims to try by giving the vets a final mission: fly them to Washington, D.C. to see the WWII memorial that was built in 2004. HONOR FLIGHT follows a Milwaukee affiliate as they rally to make these flights a reality for their heroes. As the community comes together to raise funds, their lives are transformed by the stories of the soldiers they meet. HONOR FLIGHT is a poignant, intensely emotional documentary that will warm your heart. – E.F.
CIFF37 Screenings
Friday, April 12, 2013 at 1:55 PM
Saturday, April 13, 2013 at 11:20 AM
Sunday, April 14, 2013 at 7:05 PM
Recommended for Middle School +
Related Daily Postings
On Board with the Greatest Generation
Dan Hayes
Clay Broga
Benjamin Gaskell, Dan Hayes
Hawk Jensen
Harvey Kurz, Joe Demler, Julian Plaster, Orville Lemke
Director Bio
Dan Hayes is a 29-year-old filmmaker from Wauwatosa, Wisconsin. He earned a B.A. in Mass Communications from Oxford, Ohio's Miami University. Along with producer Clay Broga, Hayes started Freethink Media in 2011. Their work has been featured on The Daily Show with Jon Stewart. Hayes is also a contributor for the Huffington Post.
Select Filmography
Freethink Media
In loving memory of WILLIAM C. WITTKOWSKY
In LOVE and ADMIRATION of our Hero, WWII Veteran KENNETH E. LOVE, American Ex-Prisoner of War & Purple Heart Recipient
Check out our FAQs for answers to common questions about entering the film festival.
Become A CIFF Member
We have seven different levels of membership to choose from, so find the one that best fits your film appetite!


text:
DETROIT — A woman whose body was removed from the wreckage of a car crash Monday was weeks away from donating her kidney to a man at her church, family members said.
Numerous family members and church friends, some of whom watched in mourning as crews cleared the crash scene, identified the victim as Diamond Scott, 23.
"She just was always uplifting," said Deshaunda Sullivan, 23, Scott's best friend. "I called her for anything, and she was always there."
Scott was killed at about 4 a.m. when her car was struck at an intersection on Detroit's west side. Police suspect the other driver ran a red light and crashed into Scott's car, police spokesman Adam Madera said. Her car was hit from the side.
The other driver, who hasn't been identified, was taken to a local hospital, where he was listed in critical condition. The police investigation continues.
Zachary Hicks, pastor of Faith Clinic Ministries, the Scott family's church, said Scott was a senior at Wayne State University and had just accepted a job in human services in Baton Rouge, La.
Hicks and Scott's aunt, Adrienne Mills, 48, both said Scott had volunteered to donate a kidney to a 21-year-old man at their church, and the surgery was to commence in a few weeks.
"She was a caregiver, a tremendous woman," Hicks said.
He said Scott was on her way to pick up her mother, Kathryn Scott Robinson, who had returned from a trip to Chicago. But Scott didn't arrive.
"She talked to her about five minutes before she got to the rendezvous spot, and when she got there, (Scott) was not there," Hicks said. "(The mother) could not reach her, so she continued down Greenfield, and there she discovered the car and her daughter."
Police closed the intersection and covered Scott's car with a tarp before her trapped body was removed from the vehicle about five hours after the crash. Numerous police officers and several emergency vehicles formed a makeshift barrier around the car to further shield the view.
Robinson and others watched, embraced and could be heard crying.
"She was pure, that needs to be said," Mills said. "She wasn't a runaround girl. She didn't drink, didn't smoke. She didn't have boyfriends. She was pure."
Sullivan described Scott as the "life of the party," who was never a pessimist.
"She was just my best friend," Sullivan said before breaking down with tears.
Hicks said a memorial fund will be set up in Scott's name through PNC Bank, intended to support costs for her burial as well as help young people who wish to further their education.


text:
Club Library
Afternoon Tournament
Next Buchanan Trophy event
Winter Pairs latest
SBU Master Points
Avoiding problems at the table
1st April, 10.00am
The Buchanan has been the home of bridge in Glasgow since 1932.
The club is in a 19th century listed building and yet has all the benefits of technology with Duplimate boards, computer scoring, Bridgemates on all tables, etc. Up to 32 tables in play can be accommodated over the three floors of the building.
The Buchanan Bridge Club is a fully licensed club with a bar.
The next Saturday tournament will be on Saturday 4th March 2017 at 7.00pm.
The Buchanan offers tuition at five levels -
The classes run on Thursday evenings at 7.00pm and last about three hours.
All courses started again on 1st September but you can still join. For further information see Classes in the menu.
See the News page for important information.
Visitors to the club are very welcome, and our stand-by system means that they are guaranteed a game even if they do not come with a partner. Visitors must be signed in by a member, but this does not have to be arranged in advance - just turn up on the night and a member will sign you in. Visitors may be signed in a total of six times in any club year before they are expected to join.
You may also apply for a ten week temporary membership that allows access to the cardrooms on the club nights. Use the Contact Us page to request information.


text:
May 23, 2011
Baudelaire by Byredo
I've found a new everyday scent: Baudelaire by Swedish perfumer Byredo. I'd describe it as oddly handsome, the first whiff evoking fresh leather giving way to an herbaceousness that reminds me so vividly of the smell of that malevolent forest in Punchdrunk's Sleep No More. My mother, sour-faced, dismissed it at first smelling, saying it reminds her of the scent of a new bag. (Believe me, she knows very well the experience of opening up the box to many a new handbag..) Confuzzled, I thought to myself, what could be a more festive morning pick-me-up than a fragrance that smells of new leather goods?
Opening the box, I was delighted to find a little envelope…
…that contains an excerpt of the poem Parfum Exotique by French poet Charles Baudelaire, who the scent was named after:
It's a beautiful, sensual piece. Allow me to share with you the full English version:
When, with both my eyes closed, on a hot autumn night,I inhale the fragrance of your welcoming breastI see happy shores spread out before me,Blazing in the flames or a monotonous sun;A lazy isle to which nature has givenSingular trees, savory fruits,Men whose bodies are vigorous and slender,And women in whose eyes shines a surprising candor.Guided by your fragrance to these charming climates,I see a port filled with sails and mastsStill exhausted by the waves of the sea,While the perfume of the green tamarinds,That fills up the air, and widens my nostrils,Mingles in my soul with the sailors' songs.
Here it sits as the star of my scent-shelf, flanked by L'Occitane's The Vert (for sweltering summer days) and Comme des Garcons Eau de Parfum (for weary whiskey winter nights), with my old everyday fragrance Bvlgari's Pour Homme Extreme sitting jealously behind.
photographs by Mikee Tuason
4 Comments
Nice post!
A scent of a new bag? Hmm, now I'm def intrigued by the smell of this, hehe. Love the packaging too, reminds me of Diptyque perfume. But lately I'm so in solid ones.
Hope you are having a great week, Izzy!
WOW I did not think anyone could effectively blog about perfume but you my friend just did in a fittingly poetic way. Glad you went for this, did you get the Tom Ford too?
b: Indeed I did


text:
Stock markets likely to witness volatility amid derivatives expiry in a holiday-shortened week ahead, and the ongoing UP assembly elections will also continue to dominate sentiments, say experts.
19 Feb 2017, 12.26 pm | Source: PTI
The move comes after Sebi received complaints stating that Angel Agritech was collecting money illegally and the firm was not refunding the money collected.
17 Feb 2017, 7.08 pm | Source: PTI
In an interview to CNBC-TV18's Manisha Gupta, Kamal Baheti, CFO at McLeod Russel and DP Maheshwari, MD & CEO at Jayshree Tea & Industries spoke about the rise in tea prices and the demand supply mismatch.
17 Feb 2017, 6.13 pm | Source: CNBC-TV18
In an interview to CNBC-TV18's Manisha Gupta, Narendra Murkumbi, Vice Chairman & MD at Shree Renuka Sugars spoke about the rise in sugar prices and whether there would be any stringent measures from the government to ramp up pro...
17 Feb 2017, 6.10 pm | Source: CNBC-TV18
Tyagi will now join as the Securities and Exchange Board of India (Sebi) Chairman for an initial period of three years, official sources said today, without citing reasons behind the curtailment of his term.
17 Feb 2017, 6.10 pm | Source: PTI
Led by strong buying by foreign institutions, HDFC Bank on Friday became India's second-most valuable company by market capitalization at Rs 352,314 crore. Banking analysts expect the stock price to normalize in the days to come...
17 Feb 2017, 4.43 pm | Source: Moneycontrol.com
The BSE Sensex shot up 425 points in opening led by private banking & financials - especially HDFC Bank - after RBI lifted the ban on FIIs investment; but erased more than half of gains due to some profit booking in banks and tech...
17 Feb 2017, 4.09 pm | Source: Moneycontrol.com
Sun Pharma, HDFC Bank, GAIL, ICICI Bank, Cipla and Tata Motors were top gainers while Infosys, Asian Paints, TCS, Hero Motocorp, Wipro, Bharti Infratel, Hindalco and Idea Cellular were under pressure.
17 Feb 2017, 2.00 pm | Source: Moneycontrol.com
The regulator is also in talks with the RBI to allow institutional investors like banks and Foreign Portfolio Investors to trade in the segment.
17 Feb 2017, 1.50 pm | Source: PTI
Watch the interview of Himanshu Gupta of Karvy Comtrade with Reema Tendulkar and Sumaira Abidi on CNBC-TV18. He spoke about the current trend in commodities market.
17 Feb 2017, 1.43 pm | Source: CNBC-TV18
Watch the interview of Prathamesh Mallya of Angel Commodities Broking with Ekta Batra on CNBC-TV18. He spoke about the current trend in commodities market.
17 Feb 2017, 1.30 pm | Source: CNBC-TV18
Sun Pharma gained for second consecutive session, up 2.75 percent on hopes of early USFDA clearance to its Halol facility, especially after Cadila did not get any observations for its Moriaya facility. Wockhardt also rose 3 percen...
17 Feb 2017, 1.00 pm | Source: Moneycontrol.com
Pharma stocks were in news today. Cadila Healthcare continued to gain after yesterday's strong run, up more than 5 percent as brokerages raised their target prices and earnings forecast on the stock.
17 Feb 2017, 12.00 pm | Source: Moneycontrol.com
Watch the interview of Kishore Narne of Motilal Oswal Commodity with Manisha Gupta on CNBC-TV18. He spoke about the current trend in commodities market.
17 Feb 2017, 11.19 am | Source: CNBC-TV18
Cadila Healthcare extended its rally, up 4 percent on top of 20 percent surge in previous session as its Moriaya facility did not receive any observations from USFDA post inspection.
17 Feb 2017, 11.00 am | Source: Moneycontrol.com
HDFC Bank jumped 6 percent after the Reserve Bank of India has withdrawn the limit for purchase of bank's shares. The rally also spilled over to HDFC that was up 1.3 percent.
17 Feb 2017, 10.00 am | Source: Moneycontrol.com
HDFC Bank surged 8.41 percent as RBI says restrictions placed on purchase of bank shares by foreign portfolio investors withdrawn immediately.
17 Feb 2017, 9.15 am | Source: Moneycontrol.com
We expect the USD-INR to trade in the 67-67.30/dollar range today with slight weakening bias, says Ashutosh Raina of HDFC Bank.
17 Feb 2017, 9.03 am | Source: Moneycontrol.com
The 10-year bond yields are consolidating around 6.85 percent level, after the massive sell-off following the RBI policy, says Ashutosh Raina, HDFC Bank.
17 Feb 2017, 9.00 am | Source: CNBC-TV18
Watch Manisha Gupta of CNBC-TV18 speaking about the current trend and updates from the commodity space.
17 Feb 2017, 8.32 am | Source: CNBC-TV18
Nifty Could Enter A Bullish Phase
17 Feb 2017, 5.00 am | Source: Mecklai Financial
Foreign investors can now buy more shares in HDFC Bank as the Reserve Bank has removed restrictions imposed on it with immediate effect.
16 Feb 2017, 9.32 pm | Source: PTI
Reserve Bank today permitted multilateral financial institutions to invest in rupee denominated bonds popularly known as 'masala bonds' issued by Indian entities.
16 Feb 2017, 9.32 pm | Source: PTI
State-run BHEL and telecom major Idea Cellular will move out of National Stock Exchange's Nifty 50 index from March 31.
16 Feb 2017, 7.40 pm | Source: PTI
The MoU is intended to facilitate cooperation between the two exchanges in areas such as knowledge sharing and research, standardisation of the product for Indian markets and enhancing transparency in pricing, as well as to explor...
16 Feb 2017, 5.34 pm | Source: PTI
The stocks would be transferred to the trade-for-trade segment or 'T' or 'XT' group with effect from February 22, BSE said in a notice.
16 Feb 2017, 4.52 pm | Source: PTI
Watch the interview of Adrian Ash of Bullion Vault with Manisha Gupta on CNBC-TV18. He speaks about the current trends in precious metals in the commodities market.
16 Feb 2017, 4.22 pm | Source: CNBC-TV18
The broader markets outperformed benchmarks, with the BSE Midcap and Smallcap indices climbed 1.3 percent each on strong breadth. About two shares gained for every share falling on bourses.
16 Feb 2017, 4.01 pm | Source: Moneycontrol.com
Watch the interview of Bart Melek, Director & Head - Global Commodity Strategy at TD Securities with Manisha Gupta on CNBC-TV18. He spoke about the current trend in commodities market.
16 Feb 2017, 3.10 pm | Source: CNBC-TV18
Sun Pharma, Infosys, Maruti Suzuki, Tata Steel, GAIL, Aurobindo Pharma and Tata Motors (DVR) gained 2-4 percent while ITC, L&T, ICICI Bank, Asian Paints, Coal India, Bharti Infratel, Bosch and BPCL were under pressure.
16 Feb 2017, 2.00 pm | Source: Moneycontrol.com
Contact No.*
Interested in
Confused? use our Compare Brokers feature.
Thank you for registering.
Respective broker representative will reach you shortly.


text:
Today I decided to write about nail polishes for a change. I got two new polishes from Speed Dry collection more than a month ago. As you know Avon often changes their products and it's better that I review their polishes while they're still available in catalogue.I do like Avon polishes, I think they have good quality, but I don't buy them that often, because I think they don't have that many original color (as a nail polish addict I own a lot of different shades and I bet I already have something similar to shades I like from Avon) and the other thing is that colors in catalogue are not very accurate and sometimes you don't get what you expect. But other than that their polishes have very nice formula, which goes smoothly on nails and the pigmentation is usually also very good.
Enchanted Siren is a mint nail polish with flakies and green shimmer. It's very lovely shade, but very sheer. I needed three coats to make it opaque.
Underworld is a dark blue shade with flakies and blue shimmer. This one is better pigmented, it's opaque after two coats. Although I like both a lot, I prefer this one, it's just a perfect blue polish.
Both apply very nicely and they did dry quickly while I swatched them, but when I wear them as a full manicure I use a top coat. As you know by now, none polish (or very little) last longer on me than two days and these were not exception (if you have strong nails and polishes usually last few days on your nails, these can last on your nails few days as well, I'm not saying that these will chip on your nails after one day as well. I guess you need to try them to test them. :P).
They are still available in current Avon catalogue and there are two more shades with flakies (one lime green and one dark green), others have mostly cream finish. One polish cost 5,90 €, but I got them both for around 7 €, because Avon had special offer back then and now one costs only 3 € in current catalogue, so if you like them you better get them now for a half of a regular price. But I have to warn you about removal. They don't go down very easy. I recommend foil technicque, because otherwise it'll take a lot of time and rubbing them from the nails and there will be still few flakies left on the nails.
Have you tried Avon Speed Dry nail polishes? What do you think of these two? Thank you for reading!


text:
57 Obed Moore Rd
Weston, VT 05161
Your advisor is here to answer questions and guide you through the buying process.
Owners.com Agent
57 Obed Moore Rd Weston, VT 05161
Lots of nice updates in this recently renovated 4BR/2BA Weston Ranch! Located in one of Westons prettiest neighborhoods, this house offers mostly one-level living, a brand-new kitchen, two spacious living rooms, pretty views, a big wood stove in the family room, private master bedroom suite, full basement, and a one-car garage. There is a large level front yard for playing and gardening and it is located just outside village with easy access to everything - schools, skiing, summer theater, shopping, all-season recreation and more.
My NotesiThis is a place for you to write your thoughts and notes about this home. Only you will be able to see the notes.
- Property type: Residential
- Year built: 1968
- Structure: Two Story
- County: VT-Windsor
- Cooling: Multi Zone
- Heating: Gas - LP/Bottle, Wood, Hot Air, Multi Zone, Stove - Wood
- Parking: Driveway - Gravel, Driveway, Parking Spaces 1
- Lot Size: 91912 sqft
# of Full Bathrooms: 1 # of Quarter Bathrooms: 0 # of Half Bathrooms: 0 # of Three Quarter Bathrooms: 1
Features: Not Applicable, Porch - Screened
Garage & Parking
Parking: Driveway - Gravel, Driveway, Parking Spaces 1 | Garage: true, Attached
Lot size: 2.11 acres | Lot size: 91912 sqft | Lot Features: Country Setting | Zoning: Res
County: VT-Windsor | Real Estate Area: Rural | Directions: From Weston village, Route 100 north to Burton Road. Right on Burton to right turn on Obed Moore Road. House is on right after sharp "S" turn. | MLS #: 4406752
Appliances: Dishwasher, Dryer, Range - Gas, Washing Machine, Water Heater - Gas - LP/Bottle
Heating & Cooling
Air Conditioning: Multi Zone | Heating: Gas - LP/Bottle, Wood, Hot Air, Multi Zone, Stove - Wood | Fireplaces: Hearth, Kitchen/Dining
Utilities & Security
Utilities: Internet - Cable | Sewer Service: Septic | Water Source: Drilled Well
Elementary School: Flood Brook Union School | Middle School: Flood Brook Union School | High School: Choice
School Information
Property History & Valuation
Local Insights
Listing provided by: Claudia Harris
Listing courtesy of: Mary Mitchell Miller Real Estate | (802) 824-3176
Copyright 2017 Northern New England Real Estate Network, Inc. (NNEREN). All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of NNEREN. The information being provided is for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All properties are subject to prior sale, change or withdrawal. This display of listings may or may not be the entire Compilation from the NNEREN database, and NNEREN does not guarantee the accuracy of such information.
For issues regarding this website and/or listing search engine, please contact Owners.com support at [email protected] or (800) 475-7738.
Tools for buyers
Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
All information provided is deemed reliable but is not guaranteed and should be independently verified.
Ready to sell? We've got you covered.
Enter Password
To access this content, please confirm your account password below.
Email sent
Check your inbox at and follow the instructions to reset your password.


text:
FDA Approves CONCERTA(R) (methylphenidate HCI) Extended-release Tablets for Treatment of ADHD (Attention Deficit Hyperactivity Disorder) in Adults
Today, there's a new treatment option for the millions of adults in theUnited States with ADHD: Johnson & Johnson Pharmaceutical Research &Development L.L.C. (J&JPRD) announced the U.S. Food and Drug Administration(FDA) approved J&JPRD's Supplemental New Drug Application (sNDA) forCONCERTA(R) treatment of ADHD in adults ages 18 to 65. The doses approved foradults range from 18 to 72 mg daily.
Today's approval expands the CONCERTA(R) indication from children andadolescents into adults with ADHD, and offers these patients a patented once-daily formulation. Using its unique OROS(R) delivery system, the CONCERTA(R)formulation delivers an initial dose of medication when the tablet isingested. Medication is then delivered into the bloodstream at a controlledrate throughout the day.
The CONCERTA(R) brand, which was the first 12-hour extended-releasemethylphenidate (MPH) treatment for ADHD, is the market leader for MPHtreatment of children and adolescents with ADHD. CONCERTA(R) is marketed inthe United States by McNeil Pediatrics(TM), Division of Ortho-McNeil-JanssenPharmaceuticals, Inc.
"What we've seen in the growing body of knowledge on adult ADHD suggests achallenging burden of impairment in everyday functioning," said Janet Vergis,President of McNeil Pediatrics(TM). "Recognizing this need -- and as themarket leader in extended-release MPH for children and adolescents -- we seetoday's approval as a treatment option milestone for adults with ADHD andtheir healthcare professionals. We are proud to offer patients ages 6 to 65with ADHD our CONCERTA(R) product knowledge based on more than seven years ofclinical experience."
Researchers examining ADHD across the lifespan have noted the condition isoften chronic, with prominent symptoms and impairment spanning into adulthood,and is often associated with co-occurring anxiety, mood and disruptivedisorders as well as substance abuse(3). According to the NIMH, ADHD isthought to be a biological condition, usually inherited, and tends to run insome families more than others. Often when a child is diagnosed with thedisorder, a parent will recognize that he or she had many of the samesymptoms, and for the first time, will begin to understand some of the traitsthat have troubled them for years(4). All aspects of an individual's life mustbe considered in the diagnosis and treatment of ADHD(3).
Today's FDA approval was based on clinical trial data in adults ages 18 to65. In these studies, use of CONCERTA(R) was shown to significantly improveADHD symptoms such as attention, impulsivity and hyperactivity compared toplacebo, and the medication was shown to be generally well tolerated.
About CONCERTA(R)
CONCERTA(R) is approved for the treatment of attention deficithyperactivity disorder (ADHD) as part of a total treatment program that mayinclude counseling or other therapies.
Talk to your healthcare professional for a proper diagnosis and treatmentof ADHD. Only a healthcare professional can decide whether medication is rightfor you or your child.
CONCERTA(R) should not be taken by patients who have: allergies tomethylphenidate or other ingredients in CONCERTA(R); significant anxi
You May Also Like


text:
James Bacik
- Scholar talks about politics, church viewsThe Toledo Blade
- Editorials From Around Ohioreviewtimes.com
- Editorials from around Ohiodothaneagle.com
- Out of alignmentThe Toledo Blade
- Poll: Poverty worries Christians lessThe Toledo BladeTroy , Cedarville , Vatican City , United States , Akron
- Sylvania religion offerings: 10-17The Toledo Blade
- Toledo gathering welcomes FrancisThe Toledo Blade
- Offerings: 7-18The Toledo BladeLexington , Thailand , Asia , Kentucky , Gethsémani
- Religious offerings: 3-14The Toledo BladeSylvania , Corpus Christi , Maumee , Perrysburg , Levis
- Hussain describes brush with terrorThe Toledo BladeCorpus Christi , Denmark , Cairo , United States , Paris
- Fr. Bacik's archives to be shownThe Toledo BladeCorpus Christi , Switzerland , Sylvania , Convent , Toledo
- Lourdes to archive Bacik's worksThe Toledo Blade
Frequent names
Newstral's extraction of names of people and organisations from the world's news is completely automated. If you do not want your name to appear here, please contact us. We will be happy to look at your request.


text:
Event: Neha Dhupia, Shrish Kunder, Sachin Tendulkar and others were present at the Celebrity lockers bash for Yuvraj Singh's World Cup success.
Guest List: Neha Dhupia, Arjan Bajwa, Sachin Tendulkar, Anjali Tendulkar, Yuvraj Singh, Mukesh Ambani, Nita Ambani, Anusha Dandekar, Timmy Narang, Isha Koppikar, Dino Morea, Shilpa Saklani Agnihotri, Apoorva Agnihotri, Shirish Kunder
Venue: Olive, Mumbai
Date: 07-Apr-2011
Bollywood celebs Alia Bhatt and Varun Dhawan sizzled the ramp at Fevicol Caring with style fashion show.
Bollywood celebs Amitabh Bachchan, Varun Dhawan, Disha Patani, Iulia Vantur, Tara Sharma, Manish Paul, Sonali Bendre, Suzzanne Khan, Priya Bapat, Terrence Lewis, Himesh Reshammiya among others sizzled...
Bollywood celebs Shah Rukh Khan, Nikhil Dwivedi, Shatrughan Sinha, Satish Kaushik, Premila Chopra, Simi Garewal, Rekha, Padmini Kolhapure, Udit Narayan among others were snapped at 4th Yash Chopra awa...
Bollywood megastar Amitabh Bachchan, Ustad Zakir Hussain, Pt. Birju Maharaj, Ustad Rashid Khan, Suresh Wadkar, Pankaj Udhas were snapped at Ajvasana's Vasantostav 2017
Bollywood celebs Diljit Dosanjh, Meiyang Chang among others were snapped at Shankar Mahadevan's birthday bash.


text:
Low-profile Anthony (58), Padraig (57), Thomas (56) and Liam (52) Smyth run the Smyths toy empire. The Galway brothers are the biggest toy sellers in these islands with 21 shops largely in big retail parks across Ireland and another 71 in the UK. Sales in the UK jumped 34pc last year to €336m as the operation expanded rapidly.
Please sign in or register with Independent.ie to access the Rich List articles.


text: Parent Sneak Preview - January 29 Posted on Mon, Jan 23, 2017 under Expression 2 We believe parents make the biggest difference in their child's faith. That's why we want your kids to hear the Big Picture Show Bible story first from you! Here's what we'll be teaching next Sunday in the Big Picture Show. Take time this week to read it as a family. Animation Station Bible Story: Priscilla and Aquila (Romans 16:1-5 NIrV) Big Idea: Jesus wants us to be friends Bible Verse: "Share with the Lord's people who are in need. Welcome others into your homes." - Romans 12:13 NIrV Worship: I'm Gonna Walk God Gives Us Friends Jesus Is My Friend The Drive-In Bible Story: Balaam's Words (Numbers 22-24 NIrV) Big Idea: My words can honor God Bible Verse: "Let my words and my thoughts be pleasing to you, Lord." - Psalm 19:14a (CEV) Worship: You Only Our God The Backlot Bible Story: Giving to those in need (Sermon on Mount Matthew 6:14 NIrV) Big Idea: Jesus came to serve others and wants us to serve others too. Bible Verse: "Do to others as you want them to do to you." - Luke 6:31 (NIRV) Worship: Imagine the Impossible You Only Not As Strong Jason Byerly Children's Pastor


text:
Download presentation
Presentation is loading. Please wait.
Published byMargaret Neal Modified over 2 years ago
DB2 9 for z/OS Overview Jeff Josten DB2 for z/OS Development
Key Messages: V7 end of service June 2008 V9 general availability March 2007 Requires migration to V8 NFM DM Tools V8 & V9 Ready at GA On V7? Migrate to V8 now Plan for DB2 9
DB2 for z/OS Version 8 News Cross loader with LOBs Built in functions ASCII, TIMESTAMPDIFF DSN1COPY with 1000 OBIDs QMF with multirow fetch Online Check Index z/OS 1.7 up to 7257 extents LOAD, UNLOAD with LOBs IBM System z9 Integrated Information Processor (zIIP) New and updated books: Library refresh Feb. 2007 Messages, Codes separate books Redbooks: SOA, Large Objects, Data Sharing in a Nutshell, Data Integrity, MIDAW performance, Disk & DB2, Design Guidelines for High Performance & Availability, Business Value, Performance Topics, WebSphere, Security & MLS, Disaster Recovery, others updated …
Worldwide V8 field experience totals Key MeasurementV8 / V7 Comparison PMR Volume V8 LOWER Field APAR Severity V8 Severity 1s LOWER APAR/PMR Ratio Comparable to V7 APAR Closure Time V8 QUICKER PE Rate V8 LOWER Multi-System Outages V8 LOWER V8 field experience is better than V7!
Improved IT Infrastructure for Compliance Efforts –Trusted security context –Database roles –Auditing, encryption improved Simplify development and porting –Many SQL improvements –Native SQL stored procedures –Default databases and table spaces Data Warehousing –Dynamic index ANDing for star schema –EXCEPT and INTERSECT Decrease Complexity and Cost –Partition by growth –Performance improvements –Volume-based COPY/RECOVER –Index compression –Optimization Service Center Evolve Your Environment & SOA –Integrated pureXML ® –WebSphere ® integration Continuous Availability –Schema evolution enhancements –Fast table replacement DB2 9 for z/OS – Addressing corporate data goals
Key implementations Network Trusted Contexts Roles Improved auditing Secure Socket Layer Instead of triggers Data Encryption Regulatory Compliance in DB2 V9 for z/OS
DB2 Server CREATE CONTEXT WAS1 SYSTEM USERID WASPROD ADDRESS MY.WAS.SERVER ALLOW USER JOE WITHOUT AUTHENTICATION, SAM WITHOUT AUTHENTICATION; Trusted Security Context Identifies trusted DDF, RRS Attach, or DSN application servers Allows selected DB2 authids on connections without passwords reduces complexity of password management reduces need for an all-inclusive system authid in app servers with ability to switch users more visibility/auditability of which user is current running enables mixed security capabilities from a single app server MY.WAS.SERVER SAM or JOE w/o password
Database ROLEs ROLE is a virtual authid – Assigned via TRUSTED CONTEXT – Provides additional privileges only when in a trusted environment using existing primary AUTHID. – Can optionally be the OWNER of DB2 objects CREATE ROLE PROD_DBA; GRANT DBADM … TO PROD_DBA; CREATE TRUSTED CONTEXT DBA1 … DEFAULT ROLE PROD_DBA OWNER(ROLE);
Auditing: DB2 Trace Filtering New filtering capabilities for –START TRACE that INCLUDE or EXCLUDE based on these keywords: – USERID -- client userid – WRKSTN -- client workstation name – APPNAME -- client application name – PKGLOC -- package LOCATION name – PKGCOL -- package COLLECTION name – PKGPROG -- PACKAGE name – CONNID -- connection ID – CORRID -- correlation ID – ROLE – end users database ROLE
DB2 Server CREATE CONTEXT SAP1 SYSTEM USERID SAPPROD ATTRIBUTES( ADDRESS 22.214.171.124) o DEFAULT ROLE SAP_ROLE Example 1: ROLEs and Trusted Context used to Secure App Servers Most existing application servers connect to DB2 using userid/password pairs: Significant exposure if someone steals the userid/password!!! Trusted Context and ROLEs can be used to limit exposure: GRANTs to SAP_ROLE can be restricted so that they are only valid when used by a valid SAP app server IP address No change required to the code in the application server SAP App Server IP Address=188.8.131.52 SAPPROD connections
DB2 Server CREATE CONTEXT WAS1 SYSTEM USERID WASPROD … ALLOW USER JOE DEFAULT ROLE JDBC_ROLE, SAM DEFAULT ROLE JDBC_ROLE Example 2: ROLEs and Trusted Context for Dynamic SQL Auditing Better auditing controls: GRANT dynamic SQL privileges to a ROLE End user identity can be delegated directly to DB2 without granting dynamic SQL privileges directly to the end user End user passwords can be optional. No added complexity for administration of GRANTs, while retaining the ability to audit the end users identity!!! WebSphere JOE SAM WASPROD connections SAM
Statement of Direction: To address customers' growing concern with data security, IBM is announcing a statement of direction for the development, enhancement and support of encryption capabilities within storage environments such that the capability does not require the use of host server resources. This includes the intent to offer, among other things, capabilities for products within the IBM TotalStorage ® portfolio to support outboard encryption and to leverage the centralized key management functions planned for z/OS ICSF. Data Encryption keys Data Encryption keys Disk Enterprise-wide Key Management Statements regarding IBM's future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only Future Directions – Extending Encryption to IBM TotalStorage MFE_140 Tape TS1120
DB2 9 for z/OS Innovation: SQL Numerous new SQL capabilities Easier application porting Simplified application development
DB2 SQL z z/OS V7 common luw Linux, Unix & Windows V8.2 Inner and Outer Joins, Table Expressions, Subqueries, GROUP BY, Complex Correlation, Global Temporary Tables, CASE, 100+ Built-in Functions, Limited Fetch, Insensitive Scroll Cursors, UNION Everywhere, MIN/MAX Single Index, Self Referencing Updates with Subqueries, Sort Avoidance for ORDER BY, and Row Expressions, Call from trigger, statement isolation Updateable UNION in Views, ORDER BY/FETCH FIRST in subselects & table expressions, GROUPING SETS, ROLLUP, CUBE, INSTEAD OF TRIGGER, EXCEPT, INTERSECT, 16 Built-in Functions, MERGE, Native SQL Procedure Language, SET CURRENT ISOLATION, BIGINT data type, file reference variables, SELECT FROM INSERT, UPDATE, or DELETE, multi-site join, 2M Statement Length, GROUP BY Expression, Sequences, Scalar Fullselect, Materialized Query Tables, Common Table Expressions, Recursive SQL, CURRENT PACKAGE PATH, VOLATILE Tables, Star Join Sparse Index, Qualified Column names, Multiple DISTINCT clauses, ON COMMIT DROP, Transparent ROWID Column, FOR READ ONLY KEEP UPDATE LOCKS, SET CURRENT SCHEMA, Client special registers, long SQL object names, SELECT from INSERT, MDC z luwluw commoncommon Range partitioning
DB2 SQL z z/OS V8 common luw Linux, Unix & Windows V8.2 Multi-row INSERT, FETCH & multi-row cursor UPDATE, Dynamic Scrollable Cursors, GET DIAGNOSTICS, Enhanced UNICODE for SQL, join across encoding schemes, IS NOT DISTINCT FROM, Session variables, range partitioning Inner and Outer Joins, Table Expressions, Subqueries, GROUP BY, Complex Correlation, Global Temporary Tables, CASE, 100+ Built-in Functions including SQL/XML, Limited Fetch, Insensitive Scroll Cursors, UNION Everywhere, MIN/MAX Single Index, Self Referencing Updates with Subqueries, Sort Avoidance for ORDER BY, and Row Expressions, 2M Statement Length, GROUP BY Expression, Sequences, Scalar Fullselect, Materialized Query Tables, Common Table Expressions, Recursive SQL, CURRENT PACKAGE PATH, VOLATILE Tables, Star Join Sparse Index, Qualified Column names, Multiple DISTINCT clauses, ON COMMIT DROP, Transparent ROWID Column, Call from trigger, statement isolation, FOR READ ONLY KEEP UPDATE LOCKS, SET CURRENT SCHEMA, Client special registers, long SQL object names, SELECT from INSERT Updateable UNION in Views, ORDER BY/FETCH FIRST in subselects & table expressions, GROUPING SETS, ROLLUP, CUBE, INSTEAD OF TRIGGER, EXCEPT, INTERSECT, 16 Built- in Functions, MERGE, Native SQL Procedure Language, SET CURRENT ISOLATION, BIGINT data type, file reference variables, SELECT FROM UPDATE or DELETE, multi-site join, MDC z luwluw commoncommon
DB2 SQL z z/OS V9 common luw Linux, Unix & Windows V9 Multi-row INSERT, FETCH & multi-row cursor UPDATE, Dynamic Scrollable Cursors, GET DIAGNOSTICS, Enhanced UNICODE for SQL, join across encoding schemes, IS NOT DISTINCT FROM, Session variables, TRUNCATE, DECIMAL FLOAT, VARBINARY, optimistic locking, FETCH CONTINUE, ROLE, MERGE, SELECT from MERGE Inner and Outer Joins, Table Expressions, Subqueries, GROUP BY, Complex Correlation, Global Temporary Tables, CASE, 100+ Built-in Functions including SQL/XML, Limited Fetch, Insensitive Scroll Cursors, UNION Everywhere, MIN/MAX Single Index, Self Referencing Updates with Subqueries, Sort Avoidance for ORDER BY, and Row Expressions, 2M Statement Length, GROUP BY Expression, Sequences, Scalar Fullselect, Materialized Query Tables, Common Table Expressions, Recursive SQL, CURRENT PACKAGE PATH, VOLATILE Tables, Star Join Sparse Index, Qualified Column names, Multiple DISTINCT clauses, ON COMMIT DROP, Transparent ROWID Column, Call from trigger, statement isolation, FOR READ ONLY KEEP UPDATE LOCKS, SET CURRENT SCHEMA, Client special registers, long SQL object names, SELECT from INSERT, UPDATE or DELETE, INSTEAD OF TRIGGER, Native SQL Procedure Language, BIGINT, file reference variables, XML, FETCH FIRST & ORDER BY in subselect and fullselect, caseless comparisons, INTERSECT, EXCEPT, not logged tables, range partitioning, compression Updateable UNION in Views, GROUPING SETS, ROLLUP, CUBE, 16 Built-in Functions, SET CURRENT ISOLATION, multi-site join, MERGE, MDC, XQuery z luwluw commoncommon
SQL: Productivity, DB2 family & porting XML MERGE & TRUNCATE SELECT FROM UPDATE, DELETE, MERGE INSTEAD OF TRIGGER BIGINT, VARBINARY, BINARY, DECIMAL FLOAT Native SQL Procedure Language Nested compound Optimistic locking LOB File reference variable & FETCH CONTINUE FETCH FIRST & ORDER BY in subselect and fullselect INTERSECT & EXCEPT ROLE & trusted context Many new built-in functions, caseless comparisons Index on expression Improved DDL consistency CURRENT SCHEMA
Native SQL Procedural Language Eliminates generated C code and compilation Fully integrated into the DB2 engine Extensive support for versioning: –VERSION keyword on CREATE PROCEDURE –CURRENT ROUTINE VERSION special register –ALTER ADD VERSION –ALTER REPLACE VERSION –ALTER ACTIVATE VERSION BIND PACKAGE with new DEPLOY keyword zIIP enabled
TRUNCATE Statement Allows fast delete of all rows in a given table ( segmented, partitioned or simple) Very useful for nightly refresh of summary tables, warehouses, etc. TRUNCATE TABLE TABLE-NAME < RESTRICT WHEN DELETE TRIGGERS | IGNORE DELETE TRIGGERS>
Decimal Floating Point New datatype DECFLOAT – Well suited to typical customer financial calculations – Similar to calculator mathematics Eliminates rounding errors by using base 10 math Has up to 34 digits of precision Floating point convenience with fixed point precision!!! – Hardware support will be provided in the next System z processor generation (new IEEE standard) Software emulation provided for other models
MERGE Multi-row MERGE operation, using arrays Targets OLTP applications like SAP MERGE INTO account AS T USING VALUES (:hv_id, :hv_amt) FOR 5 ROWS AS S(id,amt) ON T.id = S.id WHEN MATCHED THEN UPDATE SET balance = T.balance + S.amt WHEN NOT MATCHED THEN INSERT (id, balance) VALUES (S.id, S.amt) NOT ATOMIC CONTINUE ON SQLEXCEPTION
SQL Improvements – Family Compatibility INSTEAD OF triggers SELECT FROM UPDATE SELECT FROM DELETE SELECT FROM MERGE BIGINT, BINARY and VARBINARY data types ORDER BY and FETCH FIRST in subselect
Text improvements in DB2 9 30 new & improved character functions Index on expression: e.g. UPPER, COLLATION_KEY LOB improvements pureXML Text search server
Text function improvements in DB2 9 New built-in character functions: COLLATION_KEY, ASCII_CHR, ASCII_STR, COLLATION_KEY DIFFERENCE, EBCDIC_CHR, EBCDIC_STR IS_IDENTICAL_TO, LEFT, LOCATE_IN_STRING LPAD, NORMALIZE_STRING, OVERLAY RIGHT, RPAD, SOUNDEX, UNICODE UNICODE_STR, VARCHAR_FORMAT XMLATTRIBUTES, XMLCOMMENT, XMLDOCUMENT, XMLPARSE, XMLPI XMLQUERY, XMLSERIALIZE, XMLTEXT Index on expression: e.g. UPPER, LOWER
Text Search Server (not included at general availability) Text search for CHAR, VARCHAR, CLOB & XML columns Provide a text index server Efficient communication interaction with DB2 for z/OS Text indexes are persisted into DB2 tables for backup & recovery purposes DB2 Parallel Sysplex Text Server Text Server TCP/IP
DB2 9 Spatial Support Enabling Open Geospatial Consortium (OGC) compliant geospatial applications –Spatial data types –Spatial functions and predicates –Spatial indexes –Spatial search –OGC-compliant spatial catalog Map GPS Address Street State …
DDL Porting Improvements Automatic selection of DATABASE and TABLESPACE when DDL omits these keywords Automatic CREATE of UNIQUE index for PRIMARY KEY Deprecated simple table space, default to segmented structure, partition by growth
Leverage Application Development Skills Use new converged SQL Key Database Technologies –SQL, SQL Procedures –XML –SOA, Web Services Developer communities –COBOL, PL/I, REXX, C, C++, assembler, Fortran –Java (JDBC / SQLJ) –.NET (C#, VB.NET) –Open Source PHP Perl Python Ruby on Rails TOAD for DB2
DB2 9 for z/OS Innovation: Data Warehousing Dynamic index ANDing for star schema INTERSECT, EXCEPT Query optimization improvements Improved query performance Index compression Plan stability Optimization Service Center
Query Enhancements SQL enhancements: INTERSECT, EXCEPT, cultural sort, caseless comparisons, FETCH FIRST in fullselect, OLAP specifications: RANK, DENSE_RANK, ROW_NUMBER … pureXML integration and text improvements Index improvements: Index on expression, Index compression, … Improved Optimization statistics: Histogram Optimization techniques –Cross query block optimization and REOPT(AUTO) –Generalize sparse index & in-memory data cache method –Dynamic Index ANDing for Star Schema Analysis: instrumentation & Optimization Service Center
Modified SAP/BW Workload Data –Populated with SAP benchmark BW 3.5 toolkits –Fact table size: 58.4M rows, 8 indexes –Dimension tables: 8 (2 ~ 99326 rows) –Snowflakes: 6 (added to increase query complexity) Queries (100) –Developed by DB2 development and performance –Based on V8 BW workload –New queries added to better reflect the customer scenarios learned from the V8 service stream Represent customer workloads without adequate (multi- column) index support (this is the norm)
Performance Comparison DB2 V8DB2 9Improvement Total Elapse Time (seconds) 71660854488% Total CPU time (seconds) 74007514-1.5 % CPU time eligible for zIIP off- load 2924 (39.5%)6775 (90%)
Optimization Service Center Identify Problem Query Tune Problem Query Monitor & Capture Query Workload Tune Query Workload
Intersect/Except/Union semantics INTERSECTEXCEPT (Difference) UNION R1 R2 R1R2 * There are some variations and restrictions R1R2 UNION ALL
DB2 9 for z/OS Innovation: Cost Cost Savings through Optimization Security and Regulatory Compliance Performance improvements Synergy with System z Query enhancements Index Compression LOB improvements DDF improvements Reduced Complexity
Synergy with new hardware: zIIP, MIDAW, DS8000 Significant CPU time reduction in most utilities Performance/Scalability Enhancements – Especially Insert / Update / Delete Query/Access Path Performance Enhancements Other Performance Enhancements – Native SQL procedure, index compression, LOB, Varchar, … Improved virtual storage usage below bar DB2 9 for z/OS Performance Improvements
System z Synergy & DB2 9 System z9 Integrated Information Processor (zIIP) Enterprise Class & Business Class Enhanced Cryptography Channels (4 Gb & MIDAW) Faster Processors Up to 54 Processors EC More memory, better value; 64 bit virtual storage z/Architecture new instructions Parallel Sysplex IPv6 SSL Java Decimal float Backup & restore Security Unicode collation Compression System z Application Assist Processor (zAAP) WLM enhanced …
Synergy with new I/O hardware DS8000 with Ficon Express and MIDAW (Modified Indirect Data Address Word) –MIDAW requires z9 (2094) and z/OS 1.6 or later –Sequential read throughput 40MB/sec on ESS 800 69MB/sec with DS8000 109MB/sec with DS8000 and MIDAW 138MB/sec with 2 stripes –Bigger read, write, preformat quantity 183MB/sec in sequential read with 2 stripes –Similar for write –Performance gap between EF (Extended Format) and non EF datasets or 4K and bigger page practically gone
Utility CPU time reduction up to – * primarily from index processing 10% to 20% in Copy, Recover table space / index* 5% to 30% in Load*, Reorg*, Rebuild Index* 20% to 60% in Check Index* 35% in Load Partition* 30% to 40% in Runstats Index* 40% to 50% in Reorg Index* 70% in Load Replace Partition with dummy input*
Index Changes INDEX on expression Page sizes 8K, 16K, 32K Improved page split Index compression Online REBUILD INDEX REORG without BUILD2 – not just for DPSI Randomized index key Not logged index space XML index
Index Compression Compression of indexes for BI workloads –Indexes are often larger than tables in BI Solution provides page-level compression –Data is compressed to 4K pages on disk –8K, 16K or 32K pages results in 2x, 4X or 8x disk savings –No compression dictionaries – compression on the fly
Index Compression : Differences between data and index compression DataIndex LevelRowPage (1) Comp on diskYes Comp in Buffer PoolYesNo Comp in LogYesNo Comp DictionaryYesNo (2) Average Comp Ratio10% - 90%25% - 75% (3)
Relief for Sequential Key INSERT New page sizes: 8K, 16K, 32K for INDEX pages – Fewer page splits for long keys – More key values per page INSERT at the end of the key range used to result in 50% free space in each index page – Enhanced support dynamically adapts page split boundary to minimize wasted space in index pages Index key randomization
CREATE TABLE … APPEND(YES) New APPEND option: – Maximizes performance for INSERT at end – Avoids overhead of attempting to preserve clustering sequence – CREATE or ALTER table
Varchar Performance Improvement Old tuning recommendation for rows with many columns with any varchar present –V9 DB2 internally executes this recommendation and more 2 times or more improvement observed when many rows with many varchars are scanned and/or fetched using many predicates No difference if no varchar, Under 5% improvement for a typical online transaction Reorg with rebuild compression dictionary if varchar columns when migrating to V9 F1F2V3F4F5V6
LOB Function SQL File reference variables FETCH CONTINUE Automatic object creation Utilities – REORG reclaim fragmented space and improve access performance – REORG share level reference (read only) – Online CHECK LOB & CHECK DATA – Sample unload DSNTIAUL
LOB Performance/Scalability LOB lock avoidance – LRSN and page latching is used instead for consistency checks New network flows for delivering LOBs – JDBC, SQLJ, and CLI will let server determine whether to flow LOB values or LOCATORs based on size thresholds – Significant reduction in network traffic – Greatly reduces frequency of FREE LOCATOR statements
DDF Improvements 64-bit addressing by DDF –Special shared private with xxxDBM1 to eliminate many data moves on SQL operations Support for IPv6 and SSL VTAM definition is now optional Prepare for elimination of PRIVATE protocol requester –Includes tools for identifying which packages need to be bound at remote servers
Source: IDC IDC: Since 2000, Labor Costs Have Exceeded the Cost of All Servers … and are Still Growing
Converged TEMP Space Single source for all temporary space in DB2, replacing: DSNDB07, temp databases, workfile database Access is virtualized for small amounts of data, eliminating cost of work file creation (reduced CPU and I/O) Supports 4K and 32K page sizes, with automatic selection of the appropriate page size New Zparm for preventing workfile monopolization
Volume-based COPY/RECOVER FlashCopy technology used to capture entire content of disk volumes RECOVER modified to enable object-level recovery from volume FlashCopy –Restore assumes that the object has not moved volumes Eliminates labor associated with setting up COPY jobs for each database / table space Full integration of tape into BACKUP/RESTORE SYSTEM utilities
WLM assisted buffer pool management BP0 DBM1WLM Data Collection DB2 Periodic Report Buffer Pool Sizes Hit Ratio for Random Reads BP1 BP7 BP2 1 Plots size and hit ratio over time. 2 Projects effects of changing the size Bufferpool Adjustment + - 25% ALTER BUFFERPOOL AUTOSIZE option
V9 Modes – An Overview CM Compatibility Mode - This is the mode DB2 is in when V9 is started for the first time from V8. It will still be in CM when migration job DSNTIJTC has completed. No new function can be executed in CM. Data sharing systems can have V8 and V9 members in this mode. DB2 can only migrate to CM from V8 NFM. ENFM Enabling New Function Mode - This mode is entered when CATENFM START is executed (the first step of job DSNTIJEN). DB2 remains in this mode until all the enabling functions are completed. Data sharing systems can only have V9 members in this mode. NFM New Function Mode - This mode is entered when CATENFM COMPLETE is executed (the only step of job DSNTIJNF). This mode indicates that all catalog changes are complete and new function can be used. ENFM* This is the same as ENFM but the * indicates that at one time DB2 was at NFM. Objects that were created when the system was at NFM can still be accessed but no new objects can be created. When the system is in ENFM* it can not fallback to V8 or coexist with a V8 system. CM* This is the same as CM but the * indicates that at one time DB2 was at a higher level. Objects that were created at the higher level can still be accessed. When DB2 is in CM* it can not fallback to V8 or coexist with a V8 system.
DB2 9 Vstor Constraint Relief DDF address space runs in 64-bit addressing mode –Shared 64-bit memory object avoids xmem moves between DBM1 and DDF and improves performance –Constraint relief DBM1, the following are moved above the bar in V9 –Parse trees –EDM fixed pools -SKPTs / SKCTs (primarily static SQL). Also part of CTs/PTs -Pageset blocks, RTS blocks -Local SQL statement cache -Some thread-related storage For installations that are constrained on DBM1 vstor: –200 to 300MB or more of savings expected –Mainly from EDM related storage (static SQL) and dynamic statement cache (dynamic SQL)
Other cost of ownership improvements Resource Limit Facility enhanced to allow CPU cost to be controlled based on: Client workstation / app name Client userid, IP address SMS integration Utilities template switching RENAME SCHEMA, VCAT REOPT(AUTO) Command line processor Optimization Service Center
DB2 9 for z/OS Innovation: SOA and XML Integration with WebSphere Native XML data type, hybrid data base server
Optimistic Locking Support Built-in timestamp for each row or page –Automatically updated by DB2 –Allows simple timestamp predicate to validate that row has not changed since last access Eliminates need for complex predicates on WebSphere CMP updates, improves performance
B2B Web Services xml DB2 9 for z/OS … Powering SOA Solutions XML is the Key Link Life Insurance YTP Pensions ITP Pensions Investments Banking Mortgage Business Services Call Center Data Warehouse Process Mgmt. Customer Data Server Web Services Private Portal 3 rd Party portal Corporate Sales system Private Sales system Corporate Portal Clients Systems xml
Contrasting the Models XML and Relational Over $20B Annual Customer Technology Investment in RDB Alone… Relational –Strength: Static data Strict schema ensures data integrity High performance indexing on fixed data –Strength: Set-based data Multiple results returned Retrieving rows XML –Strength: Semi-structured, frequently changing data Self-describing, flexible schema Easily modified format –Strength: Retrieving sequences Documents, subdocuments, related documents XML database investments growing twice as fast as total database investment…
XML Data Needs Relational Maturity Complementing XML Processing XML Data Needs Protection –Backup and recovery features to ensure continuity –Data is protected using database security Simplified XML Data Access –Centrally store and access difficult to retrieve data –SQL or XPath can be used to retrieve data –Join XML data with its related relational data Search Speed –Search documents quickly and efficiently using proven search optimization engine of mature database Optimize Existing Investments –Use existing technology infrastructure and skills to store and manage both relational and XML
pureXML Support XML data type Store the XML document natively DDL -- –CREATE/ALTER Table with XML type column Implicitly create XML Auxiliary objects (tablespace/table/index) - one per XML column –Index support Created by users uses XPath to determine which nodes in the XML document to index. CREATE INDEX dependentName ON deptTable(deptDocs) GENERATE KEY USING XMLPATTERN '/department/empl/dependent/name' ATOMIC AS SQL VARCHAR(20); INSERT/UPDATE/DELETE –INSERT with VALUES and SUBSELECT –No Subdocument update
pureXML -- Query Enhanced V8 XML Constructors (XML Publishing Functions) SQL/XML Functions and Predicates –XMLParse - Convert a XML text to XML value –XMLSerialize - Converts XML to character type –XMLQuery - executes an XPath expression against an XML value. SELECT XMLQUERY ( '//item[USPrice = $price] ' PASSING PO.POrder, T.price AS price) FROM PurchaseOrders PO, T; –XMLCast - Cast XML to other types or other types to XML –XMLExists - a predicate, which returns TRUE if the XPath expression evaluates to a non-empty sequence SELECT PO.pid FROM PurchaseOrders PO, T WHERE XMLEXISTS( '//item[USPrice = $price] ' PASSING PO.POrder, T.price AS price)
pureXML XPATH supported features from XPath 2.0: Utility Support –LOAD/UNLOAD, CHECK DATA/INDEX, COPY, REBUILD, RECOVER, REORG, etc. XML Schema Support –XSR – XML Schema Repository –Tables to store XML schemas –Stored procedures to register XML schemas DSN_XMLVALIDATE() SQL/XML function –Test XML values for validity against XML schema –Obtain default values and schema normalized values from XML schema XML decomposition using annotated XML schema
API Support XML type is supported in –Java (JDBC, SQLJ), ODBC, –C/C++, COBOL, PL/I, Assembly –.NET Applications use: –XML as CLOB(n) –XML as DBCLOB(n) –XML as BLOB(n) –All character or binary string types are supported XMLParse and XMLSerialize apply (implicitly or explicitly)
When To Use XML? Sparsely populated data Frequent DDL changes Short term complex data Complex snapshot data Relatively static data that is not frequently updated Data which is not frequently referenced on WHERE predicates and not frequently updated Tedious normalization and frustrated changes of schema are an indicator for using native XML.
Example1: Auto Insurance Policy Variations Each vehicle has many different features, and insured may choose different policy variations New features may come up each model year, and new policy variations can come up too. Its hard to design a set of columns to cover all possible features and variations Some of the features and variations need to be searched upon Solution: use XML column
Example2: Customer Statements Customer statements get generated in XML format XML file is used to print/mail to customer XML documents are tagged with keywords XML document can be stored natively in DB2 Keywords are searched to respond to customer inquiries Able to easily recreate the original document sent to customers (no transformations needed) Instead of side table and CLOB, use XML and indexing on the tagged keywords Benefit: flexible, high performance
DB2 9 – Summary of pureXML Support XML as a native data type Pure XML storage and indexing SQL/XML and XPath support Integration with traditional relational data XML Schema Repository Schema validation Application Support (Java, C/C++,.NET, PHP, COBOL, PL/1 etc.) Visual Tooling, Control Center Enhancements DB2 Utilities: Load, Unload, Reorg, etc. …and more Secure and Resilient Infrastructure for a New Breed of Agile Applications DB2 9
DB2 9 for z/OS Innovation: Continuous Availability Online schema evolution More online utilities Data sharing enhancements
Schema Evolution – Database Definition On Demand Fast replacement of one table with another Rename column and index Rename SCHEMA and VCAT Table space that can add partitions, for growth Improve ability to rebuild an index online Online reorganization with no BUILD2 phase Modify early code without requiring an IPL Alter table space and index logging Create & alter STOGROUP SMS constructs
CLONE Tables Allows fast replacing production data without renames and rebinds –A capability to support online load replace ALTER TABLE to create a Clone Table –All indexes are also cloned –Table and Index data are not copied –Base and Clone tables share the same table space and index names –Underlying data sets are differentiated by a data set instance number
CLONE Tables… A clone table can only be created –On a single table in a table space (partitioned or non-partitioned) –No RI or Trigger on the base table Use insert or load to populate clone tables Utilities (except RUNSTATS) can operate on clone tables with a new CLONE keyword
Partition by Growth New partitioning scheme: – Single table tablespace, where each partition contains a segmented pageset (allows segmented to increase from 64GB to 16TB or 128 TB with 32K pages) – Eliminates need to define partitioning key and assign key ranges – A new partition is created when a given partition reaches DSSIZE (defaults to 64G) – Retains benefits of Utilities and SQL parallelism optimizations for partitioned tables
DB2 9 Utilities Support for all new functions in DB2 Version 9 for z/OS product (universal table spaces, XML, not logged, etc.) More online utilities –Rebuild Index SHRLEVEL CHANGE Great for building new non-unique indexes –Reorg enhancements Reorg LOB now supports SHRLEVEL REFERENCE LOB space reclamation Partition-level capabilities (not available with REBALANCE) –Partition parallelism (UNLOAD/RELOAD) in a single utility statement –Elimination of the BUILD2 phase outage Recover to consistent PIT without need for a quiesce
DB2 9 Utilities More online utilities –Check data, LOB and repair locate … SHRLEVEL CHANGE –Check index SHRLEVEL REFERENCE supports parallel for > 1 index –Load replace (shrlevel change) with CLONE TABLE function Always perform CHECKPAGE on the COPY utility –Prior to V9, CHECKPAGE was optional, with about ~5% CPU overhead, and if a broken page was encountered (DSNU441I for space maps or DSNU518I for others, both RC8), then copy-pending was set –Now, COPY always performs these checks (with reduced overall CPU!) and no longer sets copy-pending, so…. Check those RCs! –A new SYSCOPY record type is written if a broken page is detected to force a full image next since dirty bits may have already been flipped off in the space map pages
DB2 9 Data Sharing Enhancements Restart performance enhancements –Reduced impact of retained locks –Open datasets ahead of log apply –Avoid locks that have potential of hanging restart Auto-recover GRECP/LPL objects on group restart –Useful in Disaster Recovery or GDPS scenarios Index performance improvements –Option to randomize key –Sequential key insert performance improvement –Larger page size, index compression Use of DPSI to avoid data sharing overhead –DPSI can be unique within partition Detect use of unused indexes so they can be dropped –Reduces data sharing overhead
DB2 9 Data Sharing Enhancements… Command to remove GBP-dependency at object level –ACCESS DB MODE(NGBPDEP) –Typical usage would be before batch run –Issue on the member on which you plan to run batch Command to prime open dataset –START DB MODE(OPEN) [PART] Log latch contention relief (avoid LRSN spinning) Improved performance for GBP writes –Avoid copying pages for batched writes DB2 overall health taken into account for WLM routing Balance group attach connections across multiple members on same LPAR (V7, V8 usermod)
Beyond DB2 9 Total Cost of Ownership (improve performance and productivity) Availability improvements (fewer planned outages) Data warehousing improvements Application development and application portability (SQL, XML) Ease migration
Click to edit Master title style References
DB2 9 for z/OS References Main DB2 for z/OS web page: pointers to most of the following: http://www.ibm.com/software/data/db2/zos/index.html V9 beta announcement: http://www.ibm.com/common/ssi/rep_ca/8/897/ENUS206-098/ENUS206-098.PDF http://www.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS206-098 DB2 9 for z/OS main page: http://www.ibm.com/software/data/db2/zos/db2zosv91.html Overview presentation, webcast and foils with notes: http://www.ibm.com/software/os/zseries/webcast/18may/ ftp://ftp.software.ibm.com/software/data/db2zos/DB2V9zOS.pdf Redbooks including V9: SOA book - overview of V9 XML http://www.redbooks.ibm.com/abstracts/SG247259.html?Open LOBs book http://www.redbooks.ibm.com/abstracts/SG247270.html?Open Security book coming soon SG24-6480 V9 Technical Overview coming SG24-7330 V9 Performance Topics coming Detailed presentations: Start on the Events page http://www.ibm.com/software/data/db2/zos/events.html Click on Presentations from previous conferences. Sort results by date - newest first. Access the ftp site directly: ftp://ftp.software.ibm.com/software/data/db2zos/ About 15 of more than 200 presentations that address V9. Presentations from IOD conference, IDUG, Share, … See notes below for more detail.
IBM Information On Demand 2007 ibm.com/events/InformationOnDemand The premier information management event for business and IT executives, managers, professionals, DBA's and developers. Select from over 600 sessions: a 2-1/2 day business leadership track with 120 sessions and a 5 day technical track with 480 sessions. Latest strategy and product announcements Huge Expo Solution Center Hands on labs One-on-ones with executives and specialists Birds of a Feather roundtables IBM Information On Demand 2007 IBM Information On Demand 2007 October 14-19, 2007 Las Vegas, Nevada Participate in discussions on the future of Information Management Experience the entire Information Management portfolio – Software, Hardware and Services Learn how to unlock business value and drive competitive advantage Hear how your peers are realizing ROI Understand the roadmap to long term strategic advantage Learn best practices in your industry Receive the best in technical education and free certification testing Extensive opportunities for networking with both your peers and industry experts Why attend:
References DB2 for z/OS home page http://www.ibm.com/software/data/db2/zos/index.html DB2 for z/OS and OS/390 Version 7 Performance Topics, SG24-6129 DB2 for z/OS Version 8 Performance Topics, SG24-6465 DB2 for z/OS and OS/390 Version 7: Using the Utilities Suite, SG24-6289 DB2 Magazine Fall 1998 - DB2 OS/390 Online Reorganization http://www.db2mag.com/db_area/archives/1998/q3/98fextra.shtml DB2 Magazine Quarter 2, 2003 - Programmer's Only - Programs vs. Utilities http://www.db2mag.com/db_area/archives/2003/q2/programmers.shtml Implementing Online Reorg in a Production Environment http://www.ibm.com/software/data/db2/os390/pdf/oreorg.pdf Moving Data Across the DB2 Family, SG24-6905 Recommendations for Tuning Large DFSORT Tasks http://www.ibm.com/servers/storage/support/software/sort/mvs/tuning/index.html DFSMSrmm SMS ACS Support http://www.redbooks.ibm.com/abstracts/TIPS0530.html?Open
Take advantage of the following information resources available for DB2 for z/OS: Information center http://publib.boulder.ibm.com/infocenter/dzichelp/index.jsp Information roadmap http://ibm.com/software/db2zos/roadmap.html DB2 for z/OS library page http://ibm.com/software/db2zos/library.html Examples trading post http://ibm.com/software/db2zos/exHome.html DB2 for z/OS support http://ibm.com/software/db2zos/support.html Official Introduction to DB2 for z/OS http://ibm.com/software/data/education/bookstore DB2 for z/OS information resources
11 Information contained in this material has not been submitted to any formal IBM review and is distributed on "as is" basis without any warranty either expressed or implied. Measurements data have been obtained in laboratory environment. Information in this presentation about IBM's future plans reflect current thinking and is subject to change at IBM's business discretion. You should not rely on such information to make business plans. The use of this information is a customer responsibility. IBM MAY HAVE PATENTS OR PENDING PATENT APPLICATIONS COVERING SUBJECT MATTER IN THIS DOCUMENT. THE FURNISHING OF THIS DOCUMENT DOES NOT IMPLY GIVING LICENSE TO THESE PATENTS. TRADEMARKS: THE FOLLOWING TERMS ARE TRADEMARKS OR ® REGISTERED TRADEMARKS OF THE IBM CORPORATION IN THE UNITED STATES AND/OR OTHER COUNTRIES: AIX, AS/400, DATABASE 2, DB2, e-business logo, Enterprise Storage Server, ESCON, FICON, OS/390, OS/400, ES/9000, MVS/ESA, Netfinity, RISC, RISC SYSTEM/6000, iSeries, pSeries, xSeries, SYSTEM/390, IBM, Lotus, NOTES, WebSphere, z/Architecture, z/OS, zSeries, System z, pureXML The FOLLOWING TERMS ARE TRADEMARKS OR REGISTERED TRADEMARKS OF THE MICROSOFT CORPORATION IN THE UNITED STATES AND/OR OTHER COUNTRIES: MICROSOFT, WINDOWS, WINDOWS NT, ODBC, WINDOWS 95 For additional information see ibm.com/legal/copytrade.phtml Disclaimer and Trademarks
Similar presentations
© 2017 SlidePlayer.com Inc.
All rights reserved.


text:
My lover's skin is like a china cup So smooth, so tender, and like unto snow The feelings it procures they let not up A dandelion, do I decide to blow? She stands there naked, pale-lit by the moon That streams through heav'nly from the clearest sky Resisting urges that I have to swoon, Though in that moment I could bliss'ly die That perfect tableau
sehr heiß
Hey Leute, such im Moment ein bestimmtes Video auf Deutsch. Am Anfang ist dieser Theo zu sehen, er gibt ihr Geld, sie will mehr und sie bekommt mehr. Sie hat einen russischen Aktzent. Sie hat schwarze Stiefel an, ne Netzstrumpfhose und befriedigt sich selbst. Sie bekommt eine Überraschung, einen pinken Dildo, angeblich ihre Lieblingsfarbe. Dann macht sie es sich selbst. Am Ende will sie an seinen Prügel dran. Sie haben aber keinen Sex. Wenn einer eine Idee hat wie das heisst, einfach mal ne Message mailen. Danke.
I love the way she crosses her legs while fucking.
Nice video. Thanks for sharing!!!
i like only no finish !!!
hot blonde
a very nice throat fucking
echt heisse Party !
A sleepy suburb in upstate New York during the Summer of 1972. The following is a fond memory of a wonderful woman. **** 1. Coming home. It was good to be coming home, and even though I was exhausted from driving back halfway across the country I still felt a rush at seeing the old neighborhood a
My name is Tim Anderson. My wife Tina and I are very proud of our 18 year old daughter Ricki. Ricki has just completed her freshman year at Central State at the top of the dean's list. As a reward for her performance, we allowed Ricki to bring her roommate and best friend Jenny to spend the summer
As told by Jenn, a 64 year old Irish/American widow, 5 foot 7, 135 lb, brunette: I guess they knew I was a soft touch. Whenever they had candy to sell for church, or cookies for Girl Scouts, the Ryan family knew I was good for a few boxes, tickets or candy bars. So, when young George showed up at
Beth Atkins was a woman full of ambition. Though smart, she was of average looks. Her one marriage had lasted but a year before her husband ditched her. Several one night stands had followed that. Now her career had become the focal point of her life. Beth worked for a large corporation in data pro
Suzette was totally unaware of the seething hunk of man standing on his patio, the one above hers, she was sitting in a corner of hers, happily puffing away on a joint, enjoying the waves of relaxation that washed over her. It was a very warm June Friday evening and she was beginning the weekend th