Sales Tel: +63 945 7983492  |  Email Us    
SMDC Residences

Air Residences

Features and Amenities

Reflective Pool
Function Terrace
Seating Alcoves

Air Residences

Green 2 Residences

Features and Amenities:

Wifi ready study area
Swimming Pool
Gym and Function Room

Green 2 Residences

Bloom Residences

Features and Amenities:

Recreational Area
2 Lap Pools
Ground Floor Commercial Areas

Bloom Residences

Leaf Residences

Features and Amenities:

3 Swimming Pools
Gym and Fitness Center
Outdoor Basketball Court

Leaf Residences

Contact Us

Contact us today for a no obligation quotation:


+63 945 7983492
+63 908 8820391

Copyright © 2018 SMDC :: SM Residences, All Rights Reserved.


































































000-736 dumps with Real exam Questions and Practice Test - smresidences.com.ph

Great Place to download 100% free 000-736 braindumps, real exam questions and practice test with VCE exam simulator to ensure your 100% success in the 000-736 - smresidences.com.ph

Pass4sure 000-736 dumps | Killexams.com 000-736 real questions | http://smresidences.com.ph/

000-736 DB2 9 Database Administrator for Linux UNIX and Windows Upgrade

Study Guide Prepared by Killexams.com IBM Dumps Experts

Exam Questions Updated On :


Killexams.com 000-736 Dumps and Real Questions

100% Real Questions - Exam Pass Guarantee with High Marks - Just Memorize the Answers



000-736 exam Dumps Source : DB2 9 Database Administrator for Linux UNIX and Windows Upgrade

Test Code : 000-736
Test Name : DB2 9 Database Administrator for Linux UNIX and Windows Upgrade
Vendor Name : IBM
: 76 Real Questions

Prepare 000-736 Questions and Answers otherwise Be prepared to fail.
This killexams.com from helped me get my 000-736 companion confirmation. Their material are truly beneficial, and the exam simulator is clearly notable, it completely reproduces the exam. subjects are clean very without problems using the killexams.com observe dump. The exam itself changed into unpredictable, so Im happy I utilized killexams.com . Their packs spread all that I need, and that i wont get any unsavory shocks amid your exam. Thanx guys.


try these real test questions for 000-736 examination.
There is not a lot 000-736 exam material out there, so I went beforehand and purchased those 000-736 questions and solutions. virtually, it received my coronary heart with the manner the records is prepared. And yeah, thats right: maximum questions I saw on the exam had been precisely what became provided by killexams.com. I am relieved to have handed 000-736 exam.


Very comprehensive and proper of 000-736 examination.
When I was getting organized up for my 000-736 , It become very stressful to select the 000-736 study dump. I determined killexams.com while googling the quality certification sources. I subscribed and noticed the wealth of resources on it and used it to put together for my 000-736 test. I clear it and Im so thankful to this killexams.com.


Do you know the fastest manner to clear 000-736 examination? i have were given it.
It had been years and I was caught on the identical designation, it became like being glued to the chair with fevicol. Initially you observed, just wait right things are available time. But then your persistence wears off and you realize you gotta take a stand before its too past due. Since my work includes primarily managing a 000-736 shoppers base I determined to ace it and end up the he is aware of all approximately 000-736 dude within the office. Upon a buddies steerage I attempted your 000-736 demo from killexams.com, loved and it and moved onto a purchase. Your exam simulator is terrifi and nowadays your test package has made me the brand new 000-736 manager.


truly use these actual query bank and success is yours.
Recently I bought your certification bundle and studied it very well. Last week I passed the 000-736 and received my certification. killexams.com on line exam simulator changed into a extremely good device to prepare the exam. That more desirable my confidence and that i without difficulty handed the certification exam! Highly endorsed!!!


i've placed a terrific source contemporary 000-736 material.
Preparing for 000-736 books can be a tricky job and nine out of ten chances are that you will fail if you do it without any appropriate guidance. Thats where best 000-736 book comes in! It provides you with efficient and groovy information that not only enhances your preparation but also gives you a clear cut chance of passing your 000-736 download and getting into any university without any despair. I prepared through this terrific program and I scored 42 marks out of 50. I can assure you that it will never let you down!


Is there a shortcut to fast put together and pass 000-736 examination?
today i am very happy because i have were given a very excessive marks in my 000-736 exam. I couldnt suppose i would be capable of do it however this killexams.com made me assume in any other case. the web educators are doing their process very well and that i salute them for their determination and devotion.


Extract ultra-modern all 000-736 path contents in layout.
i am no longer a fan of on line braindumps, because theyre regularly posted by using irresponsible folks that misinform you into gaining knowledge of belongings you dont need and lacking things which you really need to realize. now not killexams. This organization affords certainly legitimate questions solutions that help you get thru your exam guidance. that is how I passed 000-736 exam. First time, First I relied on loose online stuff and i failed. I got killexams.com 000-736 exam simulator - and that i passed. that is the handiest evidence I need. thank you killexams.


attempt out those real 000-736 modern-day dumps.
With using excellent merchandise of killexams.com, I had scored 90 two percentage marks in 000-736 certification. I waslooking for dependable examine dump to boom my information degree. Technical requirements and difficult language of my certification modified into hard to apprehend therefore i was searching for reliable and easy testproducts. I had come to recognise this net site for the coaching of expert certification. It was no longer an smooth mission butonly killexams.com has made this undertaking easy for me. I am feeling terrific for my success and this platform is great for me.


Get those 000-736 , prepare and chillout!
it is my pride to thank you very lots for being right here for me. I handed my 000-736 certification with flying colors. Now im 000-736 certified.


IBM DB2 9 Database Administrator

Senior Database Administrator (DBA) with IBM DB2 competencies income | killexams.com Real Questions and Pass4sure dumps

The usual pay for a Senior Database Administrator (DBA) with IBM DB2 potential is $63.88 per hour.

The common pay for a Senior Database Administrator (DBA) with IBM DB2 abilities is $107,321 per year.

salary $82,129 - $133,887 Bonus $2,500 - $17,237 income Sharing $three,020 - $sixteen,886 complete Pay (? XTotal Pay combines base annual revenue or hourly wage, bonuses, profit sharing, counsel, commissions, additional time pay and different kinds of cash earnings, as relevant for this job. It doesn't encompass equity (inventory) compensation, cash value of retirement advantages, or the price of different non-cash benefits (e.g. healthcare). ) $eighty four,452 - $141,136 Hourly expense $sixty three.88 additional time $forty four.49 Bonus $2,500 - $17,237 earnings Sharing $3,020 - $sixteen,886 complete Pay (? XTotal Pay combines base annual profits or hourly wage, bonuses, earnings sharing, counsel, commissions, overtime pay and other sorts of money earnings, as applicable for this job. It does not encompass fairness (stock) compensation, money cost of retirement benefits, or the price of alternative non-money benefits (e.g. healthcare). ) $eighty four,452 - $141,136 Job Description for Senior Database Administrator (DBA)

Senior database directors work as team leaders with desktop engineering teams in an effort to create database structure to accomplish the imperative desires of specialised computer utility. Senior database administrators have very clear tutorial dreams: they need a bachelor's degree in desktop science or in equivalent fields. they will also want certification for database administration from an authorized board, equivalent to Oracle. it's feasible to forgo acquiring a bachelor's diploma, but senior database administrators would require a few years of labor in an identical areas as well as huge self-schooling on database administration.

examine greater...

Senior database directors deserve to comprehend a few programming languages with the intention to accomplish their dreams. they're going to additionally want mighty communique competencies with the intention to delegate work goals and facilitate the advent and implementation of databases.

Senior database administrators oversee the maintenance, configuration, and implementation of every little thing that has to do with databases. This contains the replication, backup, storage, access and partitioning of databases. easy and effective installations, configurations, troubleshooting, and maintenance of database programs additionally fall onto the senior database administrator. when they don't seem to be installation or conserving new database techniques, senior database administrators have to computer screen and optimize their current programs to be sure excellent equipment efficiency. They do this by means of using index tuning, disk optimization, and numerous different strategies that are applicable. in the confines of the database, senior database administrators have to additionally check who should have what permissions and privileges in the equipment to outline who can entry and manage what tips. (Copyright 2019 PayScale.com)

Senior Database Administrator (DBA) initiatives

  • Design, architect, and build databases from picking business requirements.
  • Write and troubleshoot complex saved procedures.
  • increase innovation, ideas, tactics, and surest practices.
  • control and mentor small team of DBAs.
  • Work intently with programming team of workers on database design adjustments to meet company requirements.
  • Pay by journey stage for Senior Database Administrator (DBA)

    Pay via adventure for a Senior Database Administrator (DBA) has a favorable trend. An entry-stage Senior Database Administrator (DBA) with below 5 years of adventure can predict to earn a regular total compensation of $89,000 according to eleven salaries supplied with the aid of nameless clients. common total compensation comprises suggestions, bonus, and additional time pay. A Senior Database Administrator (DBA) with mid-profession journey which comprises employees with 5 to 10 years of adventure can expect to earn a standard total compensation of $112,000 in keeping with 30 salaries. An skilled Senior Database Administrator (DBA) which contains employees with 10 to 20 years of experience can are expecting to earn a regular complete compensation of $one hundred fifteen,000 in keeping with 67 salaries. A Senior Database Administrator (DBA) with late-profession experience which comprises employees with better than twenty years of adventure can are expecting to earn a normal complete compensation of $117,000 in response to 29 salaries.


    DB2 9.5 and IBM information Studio - issues I couldn't let you know before DB2 9.5 became announced | killexams.com Real Questions and Pass4sure dumps

    at the IBM tips management tips on Demand (IOD) convention in Las Vegas in October 2007, IBM made a number of fundamental bulletins, which blanketed the christening of the DB2 Viper 2 beta as DB2 version 9.5 (DB2 9.5), and the introduction of a brand new toolset for IBM information servers (DB2 for Linux, UNIX, and home windows, DB2 for i5/OS, DB2 for z/OS, and Informix IDS) referred to as IBM data Studio.

    I’ve been writing a series on one of the most aspects that had been a part of the DB2 Viper 2 beta software. Now that DB2 9.5 is commonly accessible, i can share with you the imaginative and prescient and the ideology in the back of the new IBM Studio statistics toolset.

    What the DB2 toolset appeared like before DB2 9.5

    earlier than the legit announcement of the IBM records Studio, IBM concentrated most of its attention (and coordination) on client-facet deliverables across the run time. for instance, IBM delivered pass-DB2-household APIs for name level Interface (CLI), Java Database Connectivity (JDBC), SQL Java (SQLJ), .internet, Perl, Ruby on Rails (RoR), Hypertext Preprocessor, Python, and greater.

    From a development viewpoint, there wasn’t a coordinated focal point on the graphical user interface (GUI). In DB2 normal Database (DB2 UDB) version eight, IBM delivered the DB2 Developer center, which advanced into the DB2 Developer’s Workbench in DB2 9, but the viewers for this device became focused somewhere between builders and software-concentrated database directors (DBAs). From a building standpoint, one problem turned into that developers don’t simply build kept strategies and consumer-described functions (commonly called routines); they had to build web websites using JavaServer Pages (JSP) and functions the use of a framework similar to Java EE (previously referred to as J2EE), and so forth. For Java developers, their toolset may additionally have helped with 10% of their job, however they couldn’t do everything they wanted to do the usage of a single IDE. dissimilar tools suggest a bigger customer-side footprint, now not to point out the learning curve, all to manipulate the conclusion-to-end lifestyles cycle of an application.

    Our outdated toolsets additionally appealed to software DBAs and supplied them with a framework to construct routines (if this wasn’t the Java developer’s accountability), however there become no tooling to do schema evolution. For schema work, the application DBA had to turn to the handle center; despite the fact, the control center changed into built on a wholly distinctive set of applied sciences from the DB2 9 Developer Workbench. depending on your job responsibilities, you may also have needed to use both tools.

    one other community of users, operational DBAs, could use the manage center or the command line processor (CLP). besides the fact that children, they seemingly desired a light-weight infrastructure to control the health of their statistics servers. For this project, these individuals likely leveraged yet an extra set of tools, the internet-based Command core and the internet-based health middle.

    in the conclusion, your IT personnel’s DB2 statistics server toolkit appeared extra like a bunch of separate tools than a tool suite:

    The IBM information server toolset with the announcement of IBM records Studio and past

    The IBM statistics Studio announcement is a tremendous first step in opposition t a realignment of the disparate DB2 equipment into a single customizable toolset. And these tools prolong beyond the DB2 mandate; they are equipment for all IBM relational statistics servers. but it’s even more than that.

    IBM data Studio provides perspectives that appeal to any tasks inside the entire software life cycle, which IBM defines as:

    different providers doubtless define this technique with diverse labels, however for probably the most half, every software rolled out by means of your IT branch experiences these actions.

    when you believe the breadth of the IBM application community (IBM SWG) portfolio, that you could respect the type of expertise IBM has to offer. From this broad-based viewpoint, IBM strategists identified the following roles (with a data server center of attention) that the IBM information Studio toolset essential to serve. The IBM statistics Studio addresses these roles without delay with add-ins and views.

    These roles are proven below:

    which you could see that i tried to map the utility existence cycle outlined previous listed here with the roles that IBM strategists identified. as an instance, the Design part encompasses work across job responsibilities (in this case, the business analyst and the database architect). As you appear more intently at this determine, that you could see that the excessive-degree combination position of DBA gets broken down into granular DBA-connected roles.

    To simplify issues, I’ve shown you some roles, and a few of what folks in these roles do in their daily jobs beneath. The toolset is in response to Eclipse – the structure of the IDE where personnel work. observe, youngsters, that there's an internet component. The deployment and management of those solutions are relocating toward web-based interfaces (such as the records Studio Administration handle), and thus the information Studio toolset set has Eclipse-based and internet 2.0-primarily based aspects.

    note in the previous figure that I’ve grouped utility builders and database developers in the same quadrant. Of direction, there's administration work to be carried out comparable to alternate management, schema evolution, etc, which a DBA must do. there's also a whole class dedicated to governance. as an example, if you’re a retailer, are you compliant with the payment credit score trade records safety typical (PCI DSS – or PCI, for short)?

    rather without difficulty, no other supplier that I’m privy to has an integrated suite that addresses all of the roles illustrated within the outdated determine. one of the most primary merits of this type of toolset could be its skill to help the complete company acquire assistance on the design section and use that assistance to make the development stages less demanding. It follows that all the way through the construction phase, the corporation would acquire even more suggestions about the undertaking, and then infuse that information (which builds on the suggestions gathered at the design part) to facilitate the deployment section. With stronger counsel, the deployment section would naturally run extra easily. The momentum builds, of course, and by the point you get to governance, many of the manual requirements to adhere to a typical are already fulfilled because they’ve been recognized and constructed right through the whole system with a toolset it really is ubiquitous to all of its stakeholders.

    with the aid of the governance section, the framework could be in a position to cope with many of the belongings you need to be aware of in regards to the application existence cycle; the toolset would comprehend what it's you are attempting to do and could even be able to automate some of it for you.


    IBM Unveils Dynamic statistics Warehouse Powered by using DB2 9 | killexams.com Real Questions and Pass4sure dumps

    supply: IBM

    October 27, 2006 14:15 ET

    "Viper" records Server profitable New clients and riding IBM application business Momentum

    ARMONK, new york -- (MARKET WIRE) -- October 27, 2006 -- IBM (NYSE: IBM) today introduced a brand new dynamic data warehousing platform, built upon the industry-main DB2 9 "Viper" statistics server, it is designed to support shoppers at once and easily benefit improved insight into their company suggestions.

    the new DB2 records Warehouse 9 makes use of IBM's patented pureXML know-how that allows for customers to successfully shop and use information in an XML format. XML is increasingly used because the typical facts interchange layout between disparate applications, agencies and domains. It additionally contains DB2 9 "venom" technology that compresses row records to reduce storage requirements, enhance I/O efficiency, and provide sooner facts entry from the disk.

    DB2 9 is IBM's new information server and comprises essentially the most large database know-how enhancements introduced to the industry in additional than two decades. today's announcement comes simply two months after the launch of DB2 9 and continues the momentum of IBM's facts server which has brought listing numbers of recent purchasers and compiled lots of aggressive wins over different vendors reminiscent of Oracle and Microsoft.

    valued clientele have embraced DB2 9 and many are moving their databases from Oracle to IBM's new information server, together with: Cardinal health, American electric power, important Michigan university, Farmers coverage and Teleglobe. These new DB2 9 consumers have stated the product's combination of business-first features, and superior reliability and performance, as the causes for his or her migration.

    "because of the groundbreaking points in DB2 9, they are seeing a fine deal of client hobby," talked about Arvind Krishna, vice president IBM records servers. "Our purchasers are telling us that DB2 9 has ushered in a brand new era of records server technology that helps them to develop their groups. by means of extending these points into DB2 records Warehouse 9 we've once more raised the bar and delivered the business's most superior dynamic warehousing platform."

    DB2 facts Warehouse 9 outperforms the restrained offerings of rivals by means of excelling at enabling blended workloads that span the greatest multi-consumer transactional methods (buying and selling flooring and reservations methods) to the biggest pure analytical workloads involving big multi-billion row tables and the extremely advanced and deeply nested transactions regularly created with the aid of leading OLAP equipment. DB2 facts Warehouse 9 contains construction and management equipment for quick and effective delivery and administration of warehouses that provide top of the line entry and efficiency. DB2 9 provides the trade's most effective 3-way partitioning -- including main multidimensional clustering; dice definitions; transformation modules; and facts circulate diagrams.

    The DB2 9 data server marks a milestone within the five-year IBM construction undertaking that has transformed ordinary, static database expertise into an interactive, vibrant statistics server that allows for consumers to improve their capability to manipulate assorted kinds of information, similar to files, web pages, and digitally signed XML transactions. IBM's new facts server provides an industry-first seamless and simultaneous tips flow of both XML and relational facts, regardless of format, platform or place. The DB2 data Warehouse 9 extends this means into additional markets.

    DB2 records Warehouse 9 will additionally power IBM's industry-main data warehouse appliance choices in response to the 'Balanced Configuration Unit' or BCU. The BCU is a totally integrated and scalable facts warehouse answer that mixes software, server, and storage components to maximise company intelligence and tips management efficiency for businesses.

    For more counsel about IBM dynamic records warehousing, consult with www.utility.ibm.com/bi.

    IBM, DB2, pureXML and the IBM e-enterprise brand are trademarks or registered logos of international enterprise Machines corporation. For a list of further IBM logos, please see www.ibm.com/criminal/copytrade.shtml

    All different company, product or carrier names may well be logos or registered logos of others. Statements concerning IBM's future development plans and schedules are made for planning functions only, and are subject to change or withdrawal without word. Reseller expenditures may additionally range.


    While it is very hard task to choose reliable certification questions / answers resources with respect to review, reputation and validity because people get ripoff due to choosing wrong service. Killexams.com make it sure to serve its clients best to its resources with respect to exam dumps update and validity. Most of other's ripoff report complaint clients come to us for the brain dumps and pass their exams happily and easily. They never compromise on their review, reputation and quality because killexams review, killexams reputation and killexams client confidence is important to us. Specially they take care of killexams.com review, killexams.com reputation, killexams.com ripoff report complaint, killexams.com trust, killexams.com validity, killexams.com report and killexams.com scam. If you see any false report posted by their competitors with the name killexams ripoff report complaint internet, killexams.com ripoff report, killexams.com scam, killexams.com complaint or something like this, just keep in mind that there are always bad people damaging reputation of good services due to their benefits. There are thousands of satisfied customers that pass their exams using killexams.com brain dumps, killexams PDF questions, killexams practice questions, killexams exam simulator. Visit Killexams.com, their sample questions and sample brain dumps, their exam simulator and you will definitely know that killexams.com is the best brain dumps site.

    Back to Braindumps Menu


    CTAL-TTA-001 exam prep | HP2-F01 pdf download | 1Z0-447 free pdf download | HP2-H28 bootcamp | 000-N21 exam prep | HP0-651 brain dumps | CBEST real questions | C2150-609 study guide | A2010-597 sample test | 000-593 real questions | C5050-280 study guide | 000-514 study guide | C9560-574 practice questions | 3X0-202 braindumps | HPE0-S37 free pdf | 700-301 practice questions | HP0-D23 questions answers | 000-387 brain dumps | 000-M602 practice exam | OAT real questions |


    Get high marks in 000-736 exam with these dumps
    killexams.com is a reliable and trustworthy platform who provides 000-736 exam questions with 100% success guarantee. You need to practice questions for one day at least to score well in the exam. Your real journey to success in 000-736 exam, actually starts with killexams.com exam practice questions that is the excellent and verified source of your targeted position.

    Just go through their Questions bank and sense assured approximately the 000-736 test. You will pass your exam at high marks or your money back. They have aggregated a database of 000-736 Dumps from actual test so that you can come up with a chance to get ready and pass 000-736 exam on the important enterprise. Simply install their Exam Simulator and get ready. You will pass the exam. killexams.com Huge Discount Coupons and Promo Codes are as beneath;
    WC2017 : 60% Discount Coupon for all tests on website
    PROF17 : 10% Discount Coupon for Orders greater than $69
    DEAL17 : 15% Discount Coupon for Orders more than $99
    DECSPECIAL : 10% Special Discount Coupon for All Orders
    Detail is at http://killexams.com/pass4sure/exam-detail/000-736

    Quality and Value for the 000-736 Exam : killexams.com Practice Exams for IBM 000-736 are written to the very best requirements of technical accuracy, using only certified problem count specialists and published authors for development.

    100% Guarantee to Pass Your 000-736 Exam : If you do not pass the IBM 000-736 exam the usage of their killexams.com trying out engine, they will give you a FULL REFUND of your buying fee.

    Downloadable, Interactive 000-736 Testing engines : Their IBM 000-736 Preparation Material presents you everything you will want to take IBM 000-736 exam. Details are researched and produced by using IBM Certification Experts who're constantly the usage of industry revel in to provide unique, and logical.

    - Comprehensive questions and answers of 000-736 exam - 000-736 exam questions followed with the aid of exhibits - Verified Answers by means of Experts and nearly a hundred% correct - 000-736 exam questions up to date on normal basis - 000-736 exam education is in multiple-preference questions (MCQs). - Tested by means of more than one times earlier than publishing - Try loose 000-736 exam demo before you decide to shop for it in killexams.com

    killexams.com Huge Discount Coupons and Promo Codes are as beneath;
    WC2017 : 60% Discount Coupon for all tests on internet site
    PROF17 : 10% Discount Coupon for Orders more than $69
    DEAL17 : 15% Discount Coupon for Orders greater than $ninety nine
    DECSPECIAL : 10% Special Discount Coupon for All Orders


    Click http://killexams.com/pass4sure/exam-detail/000-736

    000-736 | 000-736 | 000-736 | 000-736 | 000-736 | 000-736


    Killexams TB0-115 dumps questions | Killexams 000-272 cheat sheets | Killexams 9A0-154 study guide | Killexams 190-840 test prep | Killexams ECP-103 study guide | Killexams 000-N03 practice test | Killexams HP3-C33 examcollection | Killexams JN0-420 free pdf download | Killexams HP2-B25 braindumps | Killexams BI0-210 brain dumps | Killexams C2210-422 Practice test | Killexams 920-323 cram | Killexams 1Y0-731 dump | Killexams 190-849 braindumps | Killexams RH302 free pdf | Killexams P2090-046 questions and answers | Killexams C9530-001 practice exam | Killexams A2180-270 bootcamp | Killexams 00M-232 exam prep | Killexams 1Z0-590 brain dumps |


    killexams.com huge List of Exam Braindumps

    View Complete list of Killexams.com Brain dumps


    Killexams HP0-A22 study guide | Killexams 200-355 test questions | Killexams 132-S-708-1 sample test | Killexams HP5-B04D test prep | Killexams C2010-507 braindumps | Killexams 000-753 examcollection | Killexams P9530-039 Practice test | Killexams 132-S-900.6 dumps | Killexams 000-Z05 study guide | Killexams M2060-730 cram | Killexams HP2-K03 practice questions | Killexams P2065-013 free pdf download | Killexams 7004-1 test prep | Killexams 700-038 braindumps | Killexams 1Z0-507 questions and answers | Killexams HP0-E01 bootcamp | Killexams HP0-S30 mock exam | Killexams 000-718 practice questions | Killexams 920-157 brain dumps | Killexams 920-131 brain dumps |


    DB2 9 Database Administrator for Linux UNIX and Windows Upgrade

    Pass 4 sure 000-736 dumps | Killexams.com 000-736 real questions | http://smresidences.com.ph/

    DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) - Page 4 | killexams.com real questions and Pass4sure dumps

    DB2 Connectivity

    DB2 provides a variety of options for connecting to other DB2 and non-DB2 data servers:

  • DB2 Clients — DB2 client code is required on workstations for remote users to access a DB2 database.

  • DB2 Drivers — Some APIs that are part of a DB2 client are packaged on their own, outside of a client installation. DB2 drivers offer a more lightweight deployment option for specific API connectivity.

  • DB2 Connect™ — This add-on product provides support for applications executing on Linux, UNIX, and Windows to transparently access DB2 data servers on i5/OS, VM/VSE, and z/OS environments. DB2 Connect provides much more than just connectivity; more details of its capabilities are provided later in this chapter.

  • Note - DB2 Connect is not required to access DB2 for any of the LUW platforms.

  • DB2 Replication — This feature provides replication capabilities for DB2 data servers. There are two kinds of replication, SQL-based replication and Queue-based replication (also know as Q-replication). Both are sometimes referred to as Data Propagator (DPROPR).

  • SQL-based replication is included in all of the DB2 mainstream editions that run on Linux, UNIX, and Windows. It's made up of two components, CAPTURE and APPLY. It uses SQL to replay data on target servers.

    Q-Replication is built on the IBM WebSphere MQSeries™ technology and is generally thought to be a more available and powerful replication technology. You can add this capability to a DB2 environment through one of the WebSphere Information Integrator products.

  • WebSphere Information Server or WebSphere Federation Server — The WebSphere brand has a suite of products that help you publish, place, cleanse, transform, enrich, and access data across heterogeneous data sources.

  • WebSphere Application Server — A part of this application server is shipped with DB2. It allows developers to use Java as a platform in a transaction processing environment.

  • DB2 Clients

    Once a DB2 application has been developed, you need to install connectivity software on each client workstation in a two-tier environment. If you are deploying a Web-based application in a three-tier environment, you need to, at a minimum, install the DB2 client connectivity software on the application server. In DB2 9 there are basically two types of clients, the DB2 Runtime Client and the DB2 Client.

    A DB2 Runtime Client provides the minimum client footprint (about 20–30 MB) to support connectivity to DB2 9 data servers (the exception to this is if you choose to support communication via specific API drivers, covered later in this section). When you install a DB2 Runtime Client, you install a driver to support all the common programming methodologies, including ADO.NET, ADO, OLE DB, ODBC, JDBC, SQLJ, static SQL, and more.

    Note - In this chapter, the use of the term client with a lowercase c refers the DB2 client software in general, while an uppercase C refers to a specific DB2 client package.

    Using a DB2 Runtime Client you can perform basic functions, such as running any DB2 commands or SQL statements from a DB2 CLP or CLP session; however, for the most part, this client comes with no other capabilities than supporting data connectivity. For example, there are no graphical-based management tools, documentation, and so on. You can download a DB2 Runtime Client at http://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-dm-db2rtcl.

    Note - The DB2 8 Runtime Client is very different from the DB2 9 Runtime Client. In DB2 8, there was a special client only available on Windows called the DB2 Runtime Client Lite. This client had a reduced footprint compared to the DB2 9 Runtime Client and didn't include tooling, documentation, and so on. The DB2 9 Runtime Client is analogous to the DB2 8 Runtime Client Lite, only is now available on all supported platforms.

    A special DB2 Runtime Client is made available as Windows Merge Modules (.msi files), which makes the installation of this software within Windows applications more natural. You can download these files at http://www-304.ibm.com/jct03002c/software/data/db2/runtime.html.

    In contrast, the DB2 Client includes all the functions found in the DB2 Runtime Client plus functions for client-server configuration, tools for database administration and application development, samples, and more. For example, this client includes the Configuration Assistant that provides graphically administration and connectivity tools, as well as a host of programming samples, and so on. The DB2 9 Client replaces the functions found in both the DB2 8 Application Development and DB2 8 Administration clients.

    A DB2 Client's footprint is directly correlated to the components you select to install and can take between 200 MB and 800 MB depending on the options you select. The process to install a DB2 Client is very similar to a DB2 data server. You can download a DB2 Client at http://www-304.ibm.com/jct03002c/software/data/db2/runtime.html.

    The choice of which DB2 client to install should be based on the requirements of the application on the client machine. For example, if you have a database application developed for Linux, UNIX, or Windows and you do not require the DB2 administration or application development tools from a Windows workstation, yet want to support applications written in multiple programming languages like .NET and Java, you should install the DB2 Runtime Client on that workstation.

    Some enterprises prefer to deploy the DB2 Runtime Client code remotely on a dedicated server. In these environments, remote workstations need to access the DB2 Runtime Client code remotely from a code server before accessing to DB2. This type of configuration is known as a thin client. A thin-client configuration can provide many benefits, such as a central catalog directory of all database connections and a single footprint of code to manage. The trade-off is that clients must load the client .dlls from the code server before accessing the remote data server. It should be noted however that this performance hit is only "noticed" on the initial connection. Once the client code is loaded on the client workstation, subsequent calls to the code server are not needed.

    When you want to deploy your DB2 application, you only need to ensure that a DB2 Runtime Client is installed on each workstation executing the application. Figure 1-10 shows the relationship between an application, a DB2 Runtime Client, and the DB2 data server. If the application and database are installed on the same server, connectivity is considered to come from a local client. If the application is installed on a system other than the DB2 data server, its connectivity is considered to come from a remote client.

    Figure 1–10Accessing a DB2 data server using the DB2 Runtime Client

    DB2 client connectivity can be configured using various supported communication protocols. The supported protocols vary according to operating system:

    DB2 Drivers

    Some larger enterprises and independent software vendors (ISVs) want to deploy their applications written in single language without the overheard of installing and maintaining a DB2 client on each client workstation. Despite the much smaller footprint of the DB2 Runtime Client in DB2 9, IBM makes available two drivers that can be deployed for connectivity on their own, outside of a DB2 Runtime Client or DB2 Client installation.

    The IBM Driver for JDBC and SQLJ can be deployed to support Java-based connectivity to a DB2 data server. This driver is about 2 MB in size and can easily be embedded within your application. In fact, it comes with a royalty-free distribution license for this very purpose.

    You should note however that although this driver can connect to the entire DB2 family, if you're connecting to a DB2 for i5/OS, DB2 for VM/VSE, or DB2 for z/OS data server, you need to additionally license this connectivity with DB2 Connect (covered in the next section) to ensure you are compliant with respect to licensing.

    It's important to note that the IBM Driver for JDBC and SQLJ solely supports Java applications. Aside from not including tooling and documentation, this driver doesn't support data server connectivity using other APIs. For example, you can't support a .NET application using this driver. You can download this driver at http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-09-20+10%3A09%3A21.003415R&cat=database&fam=&s=c&S_TACT=105AGX11&S_CMP=DB2.

    DB2 9 includes a new standalone driver for CLI and ODBC applications called the IBM DB2 Driver for ODBC and CLI. This driver delivers the same benefits and restrictions as the IBM Driver for JDBC and SQLJ to your DB2 environment, except it solely supports CLI/ODBC connections. You can download this driver at http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-09-20+13%3A44%3A48.813589R&cat=database&fam=&s=c&S_TACT=105AGX11&S_CMP=SPLT.

    The main benefits of the IBM DB2 Driver for ODBC and CLI are:

  • Light-weight deployment solution for ODBC/CLI applications

  • Much smaller footprint (25M installed) than DB2 RTCL and DB2 Client

  • No need to have DB2 RTCL or DB2 Client installed on the client machines

  • Same concept as the JDBC/SQLJ driver but for ODBC/CLI applications

  • DB2 Connect

    DB2 Connect is a separate product family that licenses client connectivity from distributed platforms to the DB2 family running on i5/OS, VM/VSE, and z/OS operating systems (hereafter referred to as mainframe). Although communications between any members of the DB2 family use the Distributed Relational Database Architecture (DRDA), you have to explicitly license access from DB2 for Linux, UNIX, and Windows clients to these data servers.

    A client accessing DB2 running on the mainframe is generally referred to as a DRDA Application Requester (DRDA AR) and the DB2 server that manages the client connection as a DRDA Application Server (DRDA AS). DB2 Connect only uses TCP/IP as the transport protocol between a DRDA AR and DRDA AS.

    Note - If you are connecting to DB2 for Linux, UNIX, and Windows from a client running on a mainframe, you don't need DB2 Connect. DRDA AS functionality is built into DB2 data servers running on distributed platforms.

    Some of the major capabilities provided by DB2 Connect include:

  • Support for programming APIs such as ADO, ODBC, OLE DB, CLI, JDBC, SQLJ, ADO.NET (and more) to DB2 running on the mainframe.

  • Federation across the DB2 and Informix data servers. You can extend the reach of this federation capability to heterogeneous sources by adding either WebSphere Federation Server or WebSphere Information Server.

  • Connection pooling and the more powerful connection concentration services that provide minimal resource consumption on the mainframe.

  • System z Sysplex exploitation for failover and load balancing. For example, DB2 Connect includes high-availability features such as z/OS Workload Manager Integration (WLM) and automatic re-direct to a data-sharing group.

  • Integration into mainstream development environments for mainframe data access. For example, DB2 Connect makes data artifacts on the mainframe (including nonrelational-related services like CICS and VSAM) transparent to the world's most popular IDEs; for example, a .NET developer can use Microsoft Visual Studio 2005 and build stored procedures without knowing where the data actually resides.

  • DB2 Connect is often used to enable mainframe resources for Web access, better integrate legacy and heritage systems with new deployments on distributed platforms, modernize the application development experience for mainframe development (for example, moving from COBOL to Java), and off-loading development cycles to lower-cost operational environments.

    Depending on the DB2 Connect edition you purchase, you can create a connectivity architecture for single- or multi-tier environments.

    Figure 1–11Using DB2 Connect is a single-tier or multi-tier environment

    You can see in Figure 1–11 that there are many ways to implement a DB2 Connect product. In a multi-tier environment, you use DB2 client software to connect to the DB2 Connect gateway (in a client/server model) passing the connection context to to the mainframe resource. In a Web-based deployment, you may have DB2 Connect on its own or collocated with the application server. Depending on your configuration, you may or may not need to install a DB2 client.

    DB2 Connect products can be added on to an existing DB2 data server installation, or act as a standalone gateway. Either way, it's purchased separately from DB2. If you are using one of drivers discussed earlier in this chapter, technically you can make the connection to a mainframe DB2 resource, but you still need to purchase a valid DB2 Connect license. There are a number of DB2 Connect editions available and each is suited for a particular implementation of the DB2 Connect software. With the exception of DB2 Connect PE, all of the DB2 Connect editions offer the same function and features; they are merely differentiated by capability. All editions of DB2 Connect PE are considered gateways since they provide client/server access to workstations. To connect to a DB2 Connect gateway, you simply use a DB2 client.

    DB2 Connect Personal Edition (DB2 Connect PE) is similar to DB2 Personal Edition in that it is used for single workstations and doesn't provide its users with any server capabilities. Using DB2 Connect PE, you can make direct connections to DB2 running on the mainframe. In Figure 1–11, the desktop users likely have DB2 Connect PE installed in their workstations. DB2 Connect PE can also act as a regular DB2 client and connect to distributed versions of the data server as well. Some environments deploy DB2 Connect with both direct and gateway connectivity. For example, a developer may make direct connections using the DB2 Connect PE software for certain stages of the development cycle. But once the application is in production, they may use the DB2 Connect PE software to connect to a DB2 Connect gateway to take advantage of the features it provides, such as load balancing, connection optimization, high-availability, and more. DB2 Connect PE is licensed on a per-workstation basis.

    DB2 Connect Enterprise Edition (DB2 Connect EE) can be licensed using two different user-based options: the number of Authorized Users or the number of Concurrent Users. DB2 Connect EE provides the ability to implement a three-tier connectivity architecture that allows you to isolate connectivity to mainframe resources to a specific tier in your architecture. Again, DB2 clients (or drivers) are used to connect to the gateways, and then the DB2 Connect software manages the connection context to the mainframe.

    DB2 Connect Application Server Edition (DB2 Connect ASE) is licensed by the total VU rating of all the applications servers that connect to the mainframe. The VUs that you purchase have nothing to do with how many DB2 Connect servers you set up, or what their rating is. For example, if your Web server farm was rated at 1,000 VUs and you set up a DB2 Connect gateway farm rated at 5,000 VUs, you would have to buy 1,000 VUs of DB2 Connect ASE. DB2 Connect ASE is well suited for environments where you expect to see more growth of mainframe resource than your Web tier because its costs are directly linked to the VU rating of the Web serving tier.

    DB2 Connect Unlimited Edition (DB2 Connect UE) is available for i5/OS and z/OS. DB2 Connect UE for i5/OS is licensed by the number of managed processors attached to the i5/OS partition while DB2 Connect UE for z/OS is licensed with a base server license plus a per-unit charge for the MSU rating of the System z server you are connecting to. DB2 Connect UE is well suited for environments that have flat mainframe cycle growth and heavy Web tier growth as the costs of DB2 Connect UE are directly correlated with the capacity of the mainframe resource. DB2 Connect UE comes with a free copy of Mobility on Demand to move mainframe data to occasionally connected devices, as well as DB2 Connect PE. Essentially, this edition of DB2 Connect, as its name would imply, allows for unlimited deployments.

    There's so much more to the DB2 Connect product than what's detailed in this section. In fact, the name DB2 Connect is misleading because connectivity is just a small part of what this product can do; however, these details are outside the scope of this book.


    A Product Overview of DB2 9 for Linux, UNIX, and Windows | killexams.com real questions and Pass4sure dumps

    This chapter is from the book 

    DB2 provides a variety of options for connecting to other DB2 and non-DB2 data servers:

  • DB2 Clients—DB2 client code is required on workstations for remote users to access a DB2 database.
  • DB2 Drivers—Some APIs that are part of a DB2 client are packaged on their own, outside of a client installation. DB2 drivers offer a more lightweight deployment option for specific API connectivity.
  • DB2 Connect™—This add-on product provides support for applications executing on Linux, UNIX, and Windows to transparently access DB2 data servers on i5/OS, VM/VSE, and z/OS environments. DB2 Connect provides much more than just connectivity; more details of its capabilities are provided later in this chapter.

  • DB2 Replication—This feature provides replication capabilities for DB2 data servers. There are two kinds of replication, SQL-based replication and Queue-based replication (also know as Q-replication). Both are sometimes referred to as Data Propagator (DPROPR).

    SQL-based replication is included in all of the DB2 mainstream editions that run on Linux, UNIX, and Windows. It's made up of two components, CAPTURE and APPLY. It uses SQL to replay data on target servers.

    Q-Replication is built on the IBM WebSphere MQSeries® technology and is generally thought to be a more available and powerful replication technology. You can add this capability to a DB2 environment through one of the WebSphere Information Integrator products.

  • WebSphere Information Server or WebSphere Federation Server—The WebSphere brand has a suite of products that help you publish, place, cleanse, transform, enrich, and access data across heterogeneous data sources.
  • WebSphere Application Server—A part of this application server is shipped with DB2. It allows developers to use Java as a platform in a transaction processing environment.
  • DB2 Clients

    Once a DB2 application has been developed, you need to install connectivity software on each client workstation in a two-tier environment. If you are deploying a Web-based application in a three-tier environment, you need to, at a minimum, install the DB2 client connectivity software on the application server. In DB2 9 there are basically two types of clients, the DB2 Runtime Client and the DB2 Client.

    A DB2 Runtime Client provides the minimum client footprint (about 20–30 MB) to support connectivity to DB2 9 data servers (the exception to this is if you choose to support communication via specific API drivers, covered later in this section). When you install a DB2 Runtime Client, you install a driver to support all the common programming methodologies, including ADO.NET, ADO, OLE DB, ODBC, JDBC, SQLJ, static SQL, and more.

    Using a DB2 Runtime Client you can perform basic functions, such as running any DB2 commands or SQL statements from a DB2 CLP or CLP session; however, for the most part, this client comes with no other capabilities than supporting data connectivity. For example, there are no graphical-based management tools, documentation, and so on. You can download a DB2 Runtime Client at www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-dm-db2rtcl.

    A special DB2 Runtime Client is made available as Windows Merge Modules (.msi files), which makes the installation of this software within Windows applications more natural. You can download these files at http://www-304.ibm.com/jct03002c/software/data/db2/runtime.html.

    In contrast, the DB2 Client includes all the functions found in the DB2 Runtime Client plus functions for client-server configuration, tools for database administration and application development, samples, and more. For example, this client includes the Configuration Assistant that provides graphically administration and connectivity tools, as well as a host of programming samples, and so on. The DB2 9 Client replaces the functions found in both the DB2 8 Application Development and DB2 8 Administration clients.

    A DB2 Client's footprint is directly correlated to the components you select to install and can take between 200 MB and 800 MB depending on the options you select. The process to install a DB2 Client is very similar to a DB2 data server. You can download a DB2 Client at http://www-304.ibm.com/jct03002c/software/data/db2/runtime.html.

    The choice of which DB2 client to install should be based on the requirements of the application on the client machine. For example, if you have a database application developed for Linux, UNIX, or Windows and you do not require the DB2 administration or application development tools from a Windows workstation, yet want to support applications written in multiple programming languages like .NET and Java, you should install the DB2 Runtime Client on that workstation.

    Some enterprises prefer to deploy the DB2 Runtime Client code remotely on a dedicated server. In these environments, remote workstations need to access the DB2 Runtime Client code remotely from a code server before accessing to DB2. This type of configuration is known as a thin client. A thin-client configuration can provide many benefits, such as a central catalog directory of all database connections and a single footprint of code to manage. The trade-off is that clients must load the client .dlls from the code server before accessing the remote data server. It should be noted however that this performance hit is only "noticed" on the initial connection. Once the client code is loaded on the client workstation, subsequent calls to the code server are not needed.

    When you want to deploy your DB2 application, you only need to ensure that a DB2 Runtime Client is installed on each workstation executing the application. Figure 1-10 shows the relationship between an application, a DB2 Runtime Client, and the DB2 data server. If the application and database are installed on the same server, connectivity is considered to come from a local client. If the application is installed on a system other than the DB2 data server, its connectivity is considered to come from a remote client.

    Figure 1-10

    Figure 1-10 Accessing a DB2 data server using the DB2 Runtime Client

    DB2 client connectivity can be configured using various supported communication protocols. The supported protocols vary according to operating system:

  • TCP/IP—used in all environments
  • Named Pipe—used in Windows environments
  • DB2 Drivers

    Some larger enterprises and independent software vendors (ISVs) want to deploy their applications written in single language without the overheard of installing and maintaining a DB2 client on each client workstation. Despite the much smaller footprint of the DB2 Runtime Client in DB2 9, IBM makes available two drivers that can be deployed for connectivity on their own, outside of a DB2 Runtime Client or DB2 Client installation.

    The IBM Driver for JDBC and SQLJ can be deployed to support Java-based connectivity to a DB2 data server. This driver is about 2 MB in size and can easily be embedded within your application. In fact, it comes with a royalty-free distribution license for this very purpose.

    You should note however that although this driver can connect to the entire DB2 family, if you're connecting to a DB2 for i5/OS, DB2 for VM/VSE, or DB2 for z/OS data server, you need to additionally license this connectivity with DB2 Connect (covered in the next section) to ensure you are compliant with respect to licensing.

    It's important to note that the IBM Driver for JDBC and SQLJ solely supports Java applications. Aside from not including tooling and documentation, this driver doesn't support data server connectivity using other APIs. For example, you can't support a .NET application using this driver. You can download this driver at www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-09-20+10%3A09%3A21.003415R&cat=database&fam=&s=c&S_TACT=105AGX11&S_CMP=DB2.

    DB2 9 includes a new standalone driver for CLI and ODBC applications called the IBM DB2 Driver for ODBC and CLI. This driver delivers the same benefits and restrictions as the IBM Driver for JDBC and SQLJ to your DB2 environment, except it solely supports CLI/ODBC connections. You can download this driver at www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-09-20+13%3A44%3A48.813589R&cat=database&fam=&s=c&S_TACT=105AGX11&S_CMP=SPLT.

    The main benefits of the IBM DB2 Driver for ODBC and CLI are:

  • Light-weight deployment solution for ODBC/CLI applications
  • Much smaller footprint (25M installed) than DB2 RTCL and DB2 Client
  • No need to have DB2 RTCL or DB2 Client installed on the client machines
  • Same concept as the JDBC/SQLJ driver but for ODBC/CLI applications
  • DB2 Connect

    DB2 Connect is a separate product family that licenses client connectivity from distributed platforms to the DB2 family running on i5/OS, VM/VSE, and z/OS operating systems (hereafter referred to as mainframe). Although communications between any members of the DB2 family use the Distributed Relational Database Architecture (DRDA), you have to explicitly license access from DB2 for Linux, UNIX, and Windows clients to these data servers.

    A client accessing DB2 running on the mainframe is generally referred to as a DRDA Application Requester (DRDA AR) and the DB2 server that manages the client connection as a DRDA Application Server (DRDA AS). DB2 Connect only uses TCP/IP as the transport protocol between a DRDA AR and DRDA AS.

    Some of the major capabilities provided by DB2 Connect include:

  • Support for programming APIs such as ADO, ODBC, OLE DB, CLI, JDBC, SQLJ, ADO.NET (and more) to DB2 running on the mainframe.
  • Federation across the DB2 and Informix data servers. You can extend the reach of this federation capability to heterogeneous sources by adding either WebSphere Federation Server or WebSphere Information Server.
  • Connection pooling and the more powerful connection concentration services that provide minimal resource consumption on the mainframe.
  • System z Sysplex exploitation for failover and load balancing. For example, DB2 Connect includes high-availability features such as z/OS Workload Manager Integration (WLM) and automatic re-direct to a data-sharing group.
  • Integration into mainstream development environments for mainframe data access. For example, DB2 Connect makes data artifacts on the mainframe (including nonrelational-related services like CICS and VSAM) transparent to the world's most popular IDEs; for example, a .NET developer can use Microsoft Visual Studio 2005 and build stored procedures without knowing where the data actually resides.
  • DB2 Connect is often used to enable mainframe resources for Web access, better integrate legacy and heritage systems with new deployments on distributed platforms, modernize the application development experience for mainframe development (for example, moving from COBOL to Java), and off-loading development cycles to lower-cost operational environments.

    Depending on the DB2 Connect edition you purchase, you can create a connectivity architecture for single- or multi-tier environments.

    You can see in Figure 1-11 that there are many ways to implement a DB2 Connect product. In a multi-tier environment, you use DB2 client software to connect to the DB2 Connect gateway (in a client/server model) passing the connection context to to the mainframe resource. In a Web-based deployment, you may have DB2 Connect on its own or collocated with the application server. Depending on your configuration, you may or may not need to install a DB2 client.

    Figure 1-11

    Figure 1-11 Using DB2 Connect is a single-tier or multi-tier environment

    DB2 Connect products can be added on to an existing DB2 data server installation, or act as a standalone gateway. Either way, it's purchased separately from DB2. If you are using one of drivers discussed earlier in this chapter, technically you can make the connection to a mainframe DB2 resource, but you still need to purchase a valid DB2 Connect license. There are a number of DB2 Connect editions available and each is suited for a particular implementation of the DB2 Connect software. With the exception of DB2 Connect PE, all of the DB2 Connect editions offer the same function and features; they are merely differentiated by capability. All editions of DB2 Connect PE are considered gateways since they provide client/server access to workstations. To connect to a DB2 Connect gateway, you simply use a DB2 client.

    DB2 Connect Personal Edition (DB2 Connect PE) is similar to DB2 Personal Edition in that it is used for single workstations and doesn't provide its users with any server capabilities. Using DB2 Connect PE, you can make direct connections to DB2 running on the mainframe. In Figure 1-11, the desktop users likely have DB2 Connect PE installed in their workstations. DB2 Connect PE can also act as a regular DB2 client and connect to distributed versions of the data server as well. Some environments deploy DB2 Connect with both direct and gateway connectivity. For example, a developer may make direct connections using the DB2 Connect PE software for certain stages of the development cycle. But once the application is in production, they may use the DB2 Connect PE software to connect to a DB2 Connect gateway to take advantage of the features it provides, such as load balancing, connection optimization, high-availability, and more. DB2 Connect PE is licensed on a per-workstation basis.

    DB2 Connect Enterprise Edition (DB2 Connect EE) can be licensed using two different user-based options: the number of Authorized Users or the number of Concurrent Users. DB2 Connect EE provides the ability to implement a three-tier connectivity architecture that allows you to isolate connectivity to mainframe resources to a specific tier in your architecture. Again, DB2 clients (or drivers) are used to connect to the gateways, and then the DB2 Connect software manages the connection context to the mainframe.

    DB2 Connect Application Server Edition (DB2 Connect ASE) is licensed by the total VU rating of all the applications servers that connect to the mainframe. The VUs that you purchase have nothing to do with how many DB2 Connect servers you set up, or what their rating is. For example, if your Web server farm was rated at 1,000 VUs and you set up a DB2 Connect gateway farm rated at 5,000 VUs, you would have to buy 1,000 VUs of DB2 Connect ASE. DB2 Connect ASE is well suited for environments where you expect to see more growth of mainframe resource than your Web tier because its costs are directly linked to the VU rating of the Web serving tier.

    DB2 Connect Unlimited Edition (DB2 Connect UE) is available for i5/OS and z/OS. DB2 Connect UE for i5/OS is licensed by the number of managed processors attached to the i5/OS partition while DB2 Connect UE for z/OS is licensed with a base server license plus a per-unit charge for the MSU rating of the System z server you are connecting to. DB2 Connect UE is well suited for environments that have flat mainframe cycle growth and heavy Web tier growth as the costs of DB2 Connect UE are directly correlated with the capacity of the mainframe resource. DB2 Connect UE comes with a free copy of Mobility on Demand to move mainframe data to occasionally connected devices, as well as DB2 Connect PE. Essentially, this edition of DB2 Connect, as its name would imply, allows for unlimited deployments.

    There's so much more to the DB2 Connect product than what's detailed in this section. In fact, the name DB2 Connect is misleading because connectivity is just a small part of what this product can do; however, these details are outside the scope of this book.

    DB2 Replication

    DB2 Replication allows for data to be propagated from one location to another. SQL-based replication, also know as Data Propagator (DPROPR) replication, is a free component of the DB2 for Linux, UNIX, and Windows data servers (it's a paid feature on the mainframe). You can also extend this replication capability to support a wide variety of data servers, including DB2, Oracle, Microsoft, Sybase, Informix, IMS, Lotus Notes, and flat files with WebSphere Replication Server.

    An example of SQL-based replication is shown in Figure 1-12. SQL-based replication has been around for over a decade and has proven itself to be extremely flexible, resilient, easy to set up, and scalable.

    Figure 1-12

    Figure 1-12 SQL-based replication extended with WebSphere Replication Server

    In Figure 1-12 you can see the broad reach of the SQL-based replication technology when it is extended with the WebSphere Replication Server product. As you may recall, distributed versions of DB2 come with the DPROPR technology built in and can support replication subscriptions across the DB2 family. The core capabilities of a distributed data server with respect to replication are shown in the top-left and top-right portions of Figure 1-12.

    When you buy WebSphere Replication Server, you also get Q-based replication (Figure 1-13). In Q-based replication, each message represents a transaction that is placed on a WebSphere MQ Series message queue. This replication is known for its highly parallel apply process and rich conflict detection and resolution services.

    WebSphere Federation Server and WebSphere Information Server

    WebSphere Information Server provides features and functions to place, publish, integrate, find, cleanse, and access data. The federation capabilities are worth mentioning as they relate to data access. WebSphere Federation Server contains a subset of the functionality found in WebSphere Information Server, namely the federation capabilities (and hence will be the focus of this section). You can learn more about WebSphere Federation Server and WebSphere Information Server at www.ibm.com/software/data/integration/.

    A federated system is a distributed database environment that appears as a single virtual database to end users and applications. The WebSphere Federation Server technology (some of which is built into DB2) allows SQL statements to transparently access, join, or update data located across heterogeneous data sources. Federated support enables the DB2 data server to evaluate global statistics on all data sources in order to optimize requests for the remote data. For example, the global optimizer can use knowledge of source statistics, source indexes, source functions, server and network speeds, and so on.

    The SQL support in a DB2 federated environment supports the same SQL as a non-federated environment, including advanced object-relational SQL operations across the federated data sources, such as recursive SQL, common table expressions (CTEs), and more. If the remote data source doesn't have this capability, DB2 will compensate for the missing functions.

    Perhaps the greatest benefit to a federated system is that developers only have to learn a single dialect of SQL; namely, the DB2 ANSI-compliant SQL API. If an external data source has different data types or non-standard SQL, DB2 will transparently compensate for missing functions and convert data types. For example, SQL Server 2005 has a MONEY data type whereas DB2 uses a DECIMAL data type to support currency. Without the WebSphere Federation Server technology, a developer would have to know the differences between these data servers, or cast them to like data types using OLE DB. With WebSphere Federation Server, developers just code as if they were always accessing DB2 data, and the rest is taken care of.

    An example of federated access is shown in Figure 1-14.

    Figure 1-14

    Figure 1-14 The power of federation—any data, one API

    In Figure 1-15 you can see the technology components that make up a federated database. Nicknames are used to implement a low form of granularity with respect to the data sources you want to make available. Nicknames essentially are local aliases on remote tables, although they can be mapped to specific rows and columns. A collection of nicknames is located within a server that represents that actual data source. For example, in Figure 1-15 Oracle is one such data source, so the server component would represent a specific Oracle database. All the SQL eventually flows through a wrapper, which is a library of code that allows access to a particular class of data servers. Connections made to these servers use their native protocol; for example, the Oracle connection will use the Net8 client.

    You can see in Figure 1-14 that with WebSphere Federation Server you can pretty much extend the reach of DB2 to any data source in your environment. For example, in the life sciences industry, scientists need access to specialized data to support their research related to drug discovery. IBM offers a set of Life Sciences wrappers that can be used to build a federated system that can access data useful to scientists, including Excel spreadsheets, image data, flat files, and BLAST (Basic Local Alignment Search Tool).

    If a wrapper is not available for purchase, there is a software developer's kit (SDK) that you can use to build your own.

    Database Enterprise Developer's Edition

    IBM offers a special discounted suite of Information Management products that you can purchase at a discount for development, evaluation, demonstration, and testing of your application programs; this edition is called Data Enterprise Developer Edition (DEDE).

    Some of the products included in this comprehensive developer offering are:

  • DB2 Express 9
  • DB2 Workgroup 9
  • DB2 Enterprise 9
  • DB2 Runtime Client (including .msi merge modules on Windows)
  • DB2 Client
  • IBM Driver for ODBC and CLI
  • IBM Driver for JDBC and SQLJ
  • DB2 Developer Workbench
  • DB2 Embedded Application Server (components of WebSphere Application Server)
  • DB2 Information Center
  • DB2 Documentation CD
  • DB2e Enterprise Edition
  • WebSphere MQ (this is a restricted copy that can only be used in conjunction with the DB2 software)
  • Rational Web Developer (this is a restricted copy that can only be used in conjunction with the DB2 software)
  • Tivoli System Automation (TSA) for Linux and AIX
  • Informix IDS Enterprise Edition
  • IBM Cloudscape/Apache Derby
  • DB2 Connect Unlimited Edition for i5/OS and z/OS
  • All the DB2 Extenders™, namely DB2 Spatial Extender, DB2 Geodetic Extender, DB2 Net Search Extender, and the DB2 XML Extender
  • All of the DB2 add-on feature packs outlined earlier in this chapter
  • Most of the products within DEDE are available for all the platforms that DB2 Enterprise supports (unless of course a product doesn't exist on a specific platform). The data server where you install DEDE can be on a platform that is different from the one on which the application will eventually be deployed or tested because of the common code base used in the distributed DB2 environment. In fact, almost any applications developed using DEDE can be executed on any system that has DB2 client software (or specific drivers for which the application is written) installed.

    The application development environment provided with DEDE allows application developers to write programs using today's most popular methodologies, including:

  • Embedded SQL
  • Call Level Interface (CLI)/Open Database Connectivity (ODBC)
  • .NET Framework 2.0
  • DB2 Application Programming Interfaces (APIs)
  • Web Services
  • Java Database Connectivity (JDBC) and SQLJ
  • Python™
  • PHP
  • Perl™
  • Ruby on Rails™
  • DEDE also includes the necessary programming libraries, header files, code samples, and pre-compilers for all of the supported programming languages.

    DB2 Developer Workbench

    The DB2 9 Developer Workbench (DB2 DWB) replaces the DB2 8 Development Center. The DB2 DWB is an Eclipse-based graphical environment that supports the rapid development of DB2 SQL and Java stored procedures, SQL scalar and table user defined functions (UDFs), SQL statements, XQuery statements, and Web Services. However, there's so much more to this list. For example, the DB2 DWB includes an SQL editor that's enriched with syntax colorization and code assistants, as well as teaming support, compare utilities, and more.

    The DB2 DWB is a separate tool and is maintained separate from a DB2 data server. You can download it from www-304.ibm.com/jct03001c/software/data/db2/ad/dwb.html.

    The DB2 DWB is really meant for power DBAs that aren't coding experts but require rapid development assistance for building business logic for their data servers. Depending on your environment, you may elect to use another tool like Toad for DB2 or Visual Studio. Pure developers will likely choose to use the plug-ins provided with DB2 9 into their respective IDEs, although they are free to use the DB2 DWB. For the most part, you can perform the same tasks in any of the tools that IBM ships or the integration points in specific IDEs.

    A snapshot of the Developer Workbench screen is shown in Figure 1-16.

    DB2 Extenders

    DB2 Extenders offer the ability to manipulate data outside of conventional rows and columns to include the manipulation of special data types (for example, spatial types that have associated LAT/LONG coordinates and SQL-based functions to operate on them), searching services, and more. The purpose of the DB2 Extenders is to provide for the management of this data through the familiar DB2 SQL API.

    The DB2 Extenders encapsulate the attributes, structure, and behavior of these unstructured data types and stores this information in DB2. From the developer's perspective, the DB2 Extenders appear as seamless extensions to the database and enable the development of multimedia-based applications. In other words, a spatial data type is no different than a built-in data type that they may be accustomed to. This section briefly details the DB2 Extenders that are provided by IBM.

    DB2 Spatial Extender

    The DB2 Spatial Extender (DB2 SE) provides the ability to create spatially aware data objects and store them within your DB2 database, along with other spatially related objects like (LAT/LONG) coordinates and more. Almost all industries could benefit from this free technology in DB2. For example, the banking and finance industry could visually envelope customer segments for brand location identification. Municipal governments could use this technology for flood plain identification, the retail industry for billboard locations, and more. This seems apparent when you consider that almost all data has some sort of spatial component to it: they all have an address, merchandise in a warehouse has a stock location, and so on.

    The business benefit of the DB2 SE lies in the notion that it's a lot easier to spot visually represented information than data reported in rows and columns.

    When you enable your DB2 database for the DB2 SE, you can interact with your data using SQL or specialized spatial tools from other vendors. The point is that with the DB2 SE, DB2 understands the spatial "dialect" and the operations that you want to perform with it.

    For example, a telematics application on a PDA may provide its users with a list of nearby Chinese restaurants that serve Peking Duck based on the dynamic request of this user. In this case, after the client's PDA creates a location box using Global Positioning System (GPS) coordinates, it could generate SQL statements similar to the following:

    SELECT NAME, DESCRIPTION, ADDRESS FROM RESTAURANTS WHERE OVERLAPS (LOCATION, BOX(GETGPS(),2000,2000)) AND CATEGORY = 'CHINESE' AND DOC CONTAINS(MENU,'PEKING DUCK');

    OVERLAPS is a spatial function that shows interested data in a binding box defined by the OVERLAPS boundary specification; there are many other spatial functions, including INTERSECTS, WITHIN, BUFFERS, and so on.

    DB2 Geodetic Extender

    The DB2 Geodetic Extender builds upon capabilities available in the DB2 Spatial Extender and adds compensation for real-world objects like the curvature of the earth's surface. The algorithms in this extender seek to remove the inaccuracies introduced by projections and so on. This extender is available only for DB2 Enterprise as part of the Data Geodetic Management feature.

    DB2 Net Search Extender

    The DB2 Net Search Extender (DB2 NSE) combines in-memory database technology with text search semantics for high-speed text search in DB2 databases. Searching with it can be particularly advantageous in Internet applications where performance is an important factor. The DB2 NSE can add the power of fast full-text retrieval to your DB2 applications. Its features let you store unstructured text documents of up to 2 GB in databases. It offers application developers a fast, versatile, and intelligent method of searching through such documents.

    Additionally, the DB2 NSE provides a rich set of XML searching capabilities with advanced search features like sounds-like, stemming, and so on. It is shipped free in DB2 9 (it was a chargeable extender in DB2 8) to facilitate non-XML index searching of XML data stored in pureXML columns.

    DB2 XML Extender

    The DB2 XML Extender is provided with DB2 and allows you to store XML documents in DB2; it also gives you the ability to shred and store XML in its component parts as columns in multiple tables. In either case, indexes can be defined over the elements or attributes of an XML document for fast retrieval. Furthermore, text and fragment search can be enabled on the XML column or its decomposed parts via the DB2 Net Search Extender. The DB2 XML Extender can also help you formulate an XML document from existing DB2 tables for data interchange in business-to-business environments.

    You may recall that the pureXML add-on feature pack is available for all DB2 9 data servers. Indeed, this can cause confusion since the DB2 XML Extender is shipped for free in DB2 9. You should consider the DB2 XML Extender as stabilized technology. In other words, it is no longer being enhanced and shouldn't be considered for most XML applications. The DB2 XML Extender's approach to storing XML is to shred the XML to relational tables or stuff it into a large object. When you use this technology to persist XML data, you have to make serious trade-offs with respect to performance, flexibility, and so on. In addition, you have to use specialized functions to implement Spathe searches, and data types are abstracted from base DB2 data types. Quite simply, the way you interact with the DB2 XML Extender isn't natural for XML programmers and DBAs alike.

    In contrast, the pureXML feature in DB2 9 provides services such that no compromises between flexibility (what XML was designed for) and performance (one of the reasons why you want the data server to store your XML) need to be made when storing your XML data. For example, to generate XML documents from relational tables, you simple use the SQL/XML API instead of the cumbersome DB2 XML Extender functions. You can validate XML documents against Sods instead of only document type definitions (Ds) as is the case with the DB2 XML Extender, and more. They strongly recommend this feature for most of your XML-based applications.


    Top 8 DB2 Certification Books for Database Administrators | killexams.com real questions and Pass4sure dumps

    Despite the seeming complexity of DB2 in these times, there are books out there that are very easy to read and that serve as great guide books for on-the-job references or study guides for exam preparation that will get you certified on your first try.

    Whether you are a professional intending to brush up on newer versions of the database, or you are studying for a certification exam, make the best investment by purchasing any of the following books in this list of the top 8 DB2 certification books for database administrators.

    Top 8 DB2 Certification Books for Database Administrators

    DB2 9 Fundamentals Certification Study Guide1. DB2 9 Fundamentals: Certification Study Guide by Roger E. Sanders

    This DB2 certification book follows the author’s winning history of writing solid DB2 books. This particular book is easy to read and extremely informative. You learn plenty of information, and you will soon find yourself reading the whole book from cover to cover, several times. There are also tests included, which are a great resource.

    DB2 9 for Linux, UNIX, and Windows2. DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) by George Baklarz and Paul C. Zikopoulos

    This book features all the information required to complete the certification exam. It contains information that are especially useful for beginners. An excellent resource, this comprehensive DB2 certification book is written in an easy language, with plenty of examples and pictures to ensure you are all set to go.

    DB2 9 for Linux, UNIX, and Windows Database Administration3. DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide by Roger E. Sanders

    This is the best DB2 certification book for Exam 731 preparation. There are sample questions at the end of every chapter, including a 150-question set at the end of the textbook for practice, going through all the main concepts, with answers too! It covers all the topics you will need to face in the exam

    DB2 9 for zOS Database Administration4. DB2 9 for z/OS Database Administration: Certification Study Guide by Susan Lawson and Daniel Luksetich

    Even as you start to go through this DB2 certification book, you are able to tell that it’ s a great resource. Authored by Susan Lawson and Daniel Luksetich, of course it’s brilliant! Very well-structured, it covers all the major topics, providing the most significant key information. Despite the complexity of DB2 these days, this one is very easy to read.

    DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification5. DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide by Roger E. Sanders and Dwaine R Snow

    It’s not surprising that this particular DB2 certification book is extremely informative and well-written, considering its two admirable authors, Roger Sanders and Dwaine Snow, considered “the DB2 author” and “expert to the experts”.  It is also a great guide book for on-the-job references.

    DB2 Fundamentals Certification for Dummies6. DB2 Fundamentals Certification for Dummies by Paul C. Zikopoulos, Jennifer Gibbs and Roman B. Melnyk

    the author has extracted all the goodies from the exam and put it into this brief book.

    This DB2 certification book is an excellent study guide to DB2 on the windows platform. The first half of the book’s content is geared towards the beginner, and it tries to introduce the reader to DB2 gently. Excellent for exams 512 and 513, this book also comes with a CD that contains hundreds of practice questions helpful for passing your exam 700 easily.

    DB2 9.7 for Linux, UNIX, and Windows Database Administration7. DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes by Roger E. Sanders

    If you plan on pursuing the 541 exam and require precise study material try this DB2 certification book. At a reasonable price, this book offers a precise guide in helping you prepare for the 541 certification exam. It is the only 541-specific material in the market, and Mr. Sanders does an excellent job of preparing you for the exam.

    DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade8. DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade: Certification Study Guide by Roger E. Sanders

    Very well-written, this DB2 certification book covers material for the new version of the database. After reading this study guide, you will conclude that it is a win in preparing for the test! The questions at the end of each chapter are also excellent and very helpful.

    These DB2 books serve as valuable gems for database administrators who need an on-the-job reference or who are doing precious study time and need precise study materials that will do the job. Which particular DB2 certification book have you found helpful? Leave me a comment below and let me know.



    Direct Download of over 5500 Certification Exams

    3COM [8 Certification Exam(s) ]
    AccessData [1 Certification Exam(s) ]
    ACFE [1 Certification Exam(s) ]
    ACI [3 Certification Exam(s) ]
    Acme-Packet [1 Certification Exam(s) ]
    ACSM [4 Certification Exam(s) ]
    ACT [1 Certification Exam(s) ]
    Admission-Tests [13 Certification Exam(s) ]
    ADOBE [93 Certification Exam(s) ]
    AFP [1 Certification Exam(s) ]
    AICPA [2 Certification Exam(s) ]
    AIIM [1 Certification Exam(s) ]
    Alcatel-Lucent [13 Certification Exam(s) ]
    Alfresco [1 Certification Exam(s) ]
    Altiris [3 Certification Exam(s) ]
    Amazon [2 Certification Exam(s) ]
    American-College [2 Certification Exam(s) ]
    Android [4 Certification Exam(s) ]
    APA [1 Certification Exam(s) ]
    APC [2 Certification Exam(s) ]
    APICS [2 Certification Exam(s) ]
    Apple [69 Certification Exam(s) ]
    AppSense [1 Certification Exam(s) ]
    APTUSC [1 Certification Exam(s) ]
    Arizona-Education [1 Certification Exam(s) ]
    ARM [1 Certification Exam(s) ]
    Aruba [8 Certification Exam(s) ]
    ASIS [2 Certification Exam(s) ]
    ASQ [3 Certification Exam(s) ]
    ASTQB [8 Certification Exam(s) ]
    Autodesk [2 Certification Exam(s) ]
    Avaya [101 Certification Exam(s) ]
    AXELOS [1 Certification Exam(s) ]
    Axis [1 Certification Exam(s) ]
    Banking [1 Certification Exam(s) ]
    BEA [5 Certification Exam(s) ]
    BICSI [2 Certification Exam(s) ]
    BlackBerry [17 Certification Exam(s) ]
    BlueCoat [2 Certification Exam(s) ]
    Brocade [4 Certification Exam(s) ]
    Business-Objects [11 Certification Exam(s) ]
    Business-Tests [4 Certification Exam(s) ]
    CA-Technologies [20 Certification Exam(s) ]
    Certification-Board [10 Certification Exam(s) ]
    Certiport [3 Certification Exam(s) ]
    CheckPoint [43 Certification Exam(s) ]
    CIDQ [1 Certification Exam(s) ]
    CIPS [4 Certification Exam(s) ]
    Cisco [318 Certification Exam(s) ]
    Citrix [48 Certification Exam(s) ]
    CIW [18 Certification Exam(s) ]
    Cloudera [10 Certification Exam(s) ]
    Cognos [19 Certification Exam(s) ]
    College-Board [2 Certification Exam(s) ]
    CompTIA [76 Certification Exam(s) ]
    ComputerAssociates [6 Certification Exam(s) ]
    Consultant [2 Certification Exam(s) ]
    Counselor [4 Certification Exam(s) ]
    CPP-Institute [4 Certification Exam(s) ]
    CSP [1 Certification Exam(s) ]
    CWNA [1 Certification Exam(s) ]
    CWNP [13 Certification Exam(s) ]
    CyberArk [1 Certification Exam(s) ]
    Dassault [2 Certification Exam(s) ]
    DELL [11 Certification Exam(s) ]
    DMI [1 Certification Exam(s) ]
    DRI [1 Certification Exam(s) ]
    ECCouncil [22 Certification Exam(s) ]
    ECDL [1 Certification Exam(s) ]
    EMC [128 Certification Exam(s) ]
    Enterasys [13 Certification Exam(s) ]
    Ericsson [5 Certification Exam(s) ]
    ESPA [1 Certification Exam(s) ]
    Esri [2 Certification Exam(s) ]
    ExamExpress [15 Certification Exam(s) ]
    Exin [40 Certification Exam(s) ]
    ExtremeNetworks [3 Certification Exam(s) ]
    F5-Networks [20 Certification Exam(s) ]
    FCTC [2 Certification Exam(s) ]
    Filemaker [9 Certification Exam(s) ]
    Financial [36 Certification Exam(s) ]
    Food [4 Certification Exam(s) ]
    Fortinet [14 Certification Exam(s) ]
    Foundry [6 Certification Exam(s) ]
    FSMTB [1 Certification Exam(s) ]
    Fujitsu [2 Certification Exam(s) ]
    GAQM [9 Certification Exam(s) ]
    Genesys [4 Certification Exam(s) ]
    GIAC [15 Certification Exam(s) ]
    Google [4 Certification Exam(s) ]
    GuidanceSoftware [2 Certification Exam(s) ]
    H3C [1 Certification Exam(s) ]
    HDI [9 Certification Exam(s) ]
    Healthcare [3 Certification Exam(s) ]
    HIPAA [2 Certification Exam(s) ]
    Hitachi [30 Certification Exam(s) ]
    Hortonworks [4 Certification Exam(s) ]
    Hospitality [2 Certification Exam(s) ]
    HP [752 Certification Exam(s) ]
    HR [4 Certification Exam(s) ]
    HRCI [1 Certification Exam(s) ]
    Huawei [21 Certification Exam(s) ]
    Hyperion [10 Certification Exam(s) ]
    IAAP [1 Certification Exam(s) ]
    IAHCSMM [1 Certification Exam(s) ]
    IBM [1533 Certification Exam(s) ]
    IBQH [1 Certification Exam(s) ]
    ICAI [1 Certification Exam(s) ]
    ICDL [6 Certification Exam(s) ]
    IEEE [1 Certification Exam(s) ]
    IELTS [1 Certification Exam(s) ]
    IFPUG [1 Certification Exam(s) ]
    IIA [3 Certification Exam(s) ]
    IIBA [2 Certification Exam(s) ]
    IISFA [1 Certification Exam(s) ]
    Intel [2 Certification Exam(s) ]
    IQN [1 Certification Exam(s) ]
    IRS [1 Certification Exam(s) ]
    ISA [1 Certification Exam(s) ]
    ISACA [4 Certification Exam(s) ]
    ISC2 [6 Certification Exam(s) ]
    ISEB [24 Certification Exam(s) ]
    Isilon [4 Certification Exam(s) ]
    ISM [6 Certification Exam(s) ]
    iSQI [7 Certification Exam(s) ]
    ITEC [1 Certification Exam(s) ]
    Juniper [65 Certification Exam(s) ]
    LEED [1 Certification Exam(s) ]
    Legato [5 Certification Exam(s) ]
    Liferay [1 Certification Exam(s) ]
    Logical-Operations [1 Certification Exam(s) ]
    Lotus [66 Certification Exam(s) ]
    LPI [24 Certification Exam(s) ]
    LSI [3 Certification Exam(s) ]
    Magento [3 Certification Exam(s) ]
    Maintenance [2 Certification Exam(s) ]
    McAfee [8 Certification Exam(s) ]
    McData [3 Certification Exam(s) ]
    Medical [68 Certification Exam(s) ]
    Microsoft [375 Certification Exam(s) ]
    Mile2 [3 Certification Exam(s) ]
    Military [1 Certification Exam(s) ]
    Misc [1 Certification Exam(s) ]
    Motorola [7 Certification Exam(s) ]
    mySQL [4 Certification Exam(s) ]
    NBSTSA [1 Certification Exam(s) ]
    NCEES [2 Certification Exam(s) ]
    NCIDQ [1 Certification Exam(s) ]
    NCLEX [3 Certification Exam(s) ]
    Network-General [12 Certification Exam(s) ]
    NetworkAppliance [39 Certification Exam(s) ]
    NI [1 Certification Exam(s) ]
    NIELIT [1 Certification Exam(s) ]
    Nokia [6 Certification Exam(s) ]
    Nortel [130 Certification Exam(s) ]
    Novell [37 Certification Exam(s) ]
    OMG [10 Certification Exam(s) ]
    Oracle [282 Certification Exam(s) ]
    P&C [2 Certification Exam(s) ]
    Palo-Alto [4 Certification Exam(s) ]
    PARCC [1 Certification Exam(s) ]
    PayPal [1 Certification Exam(s) ]
    Pegasystems [12 Certification Exam(s) ]
    PEOPLECERT [4 Certification Exam(s) ]
    PMI [15 Certification Exam(s) ]
    Polycom [2 Certification Exam(s) ]
    PostgreSQL-CE [1 Certification Exam(s) ]
    Prince2 [6 Certification Exam(s) ]
    PRMIA [1 Certification Exam(s) ]
    PsychCorp [1 Certification Exam(s) ]
    PTCB [2 Certification Exam(s) ]
    QAI [1 Certification Exam(s) ]
    QlikView [1 Certification Exam(s) ]
    Quality-Assurance [7 Certification Exam(s) ]
    RACC [1 Certification Exam(s) ]
    Real Estate [1 Certification Exam(s) ]
    Real-Estate [1 Certification Exam(s) ]
    RedHat [8 Certification Exam(s) ]
    RES [5 Certification Exam(s) ]
    Riverbed [8 Certification Exam(s) ]
    RSA [15 Certification Exam(s) ]
    Sair [8 Certification Exam(s) ]
    Salesforce [5 Certification Exam(s) ]
    SANS [1 Certification Exam(s) ]
    SAP [98 Certification Exam(s) ]
    SASInstitute [15 Certification Exam(s) ]
    SAT [1 Certification Exam(s) ]
    SCO [10 Certification Exam(s) ]
    SCP [6 Certification Exam(s) ]
    SDI [3 Certification Exam(s) ]
    See-Beyond [1 Certification Exam(s) ]
    Siemens [1 Certification Exam(s) ]
    Snia [7 Certification Exam(s) ]
    SOA [15 Certification Exam(s) ]
    Social-Work-Board [4 Certification Exam(s) ]
    SpringSource [1 Certification Exam(s) ]
    SUN [63 Certification Exam(s) ]
    SUSE [1 Certification Exam(s) ]
    Sybase [17 Certification Exam(s) ]
    Symantec [135 Certification Exam(s) ]
    Teacher-Certification [4 Certification Exam(s) ]
    The-Open-Group [8 Certification Exam(s) ]
    TIA [3 Certification Exam(s) ]
    Tibco [18 Certification Exam(s) ]
    Trainers [3 Certification Exam(s) ]
    Trend [1 Certification Exam(s) ]
    TruSecure [1 Certification Exam(s) ]
    USMLE [1 Certification Exam(s) ]
    VCE [6 Certification Exam(s) ]
    Veeam [2 Certification Exam(s) ]
    Veritas [33 Certification Exam(s) ]
    Vmware [58 Certification Exam(s) ]
    Wonderlic [2 Certification Exam(s) ]
    Worldatwork [2 Certification Exam(s) ]
    XML-Master [3 Certification Exam(s) ]
    Zend [6 Certification Exam(s) ]





    References :


    Issu : https://issuu.com/trutrainers/docs/000-736
    Dropmark : http://killexams.dropmark.com/367904/11734355
    Wordpress : http://wp.me/p7SJ6L-1k9
    Dropmark-Text : http://killexams.dropmark.com/367904/12296005
    Blogspot : http://killexamsbraindump.blogspot.com/2017/11/get-high-marks-in-000-736-exam-with.html
    RSS Feed : http://feeds.feedburner.com/Pass4sure000-736DumpsAndPracticeTestsWithRealQuestions
    Box.net : https://app.box.com/s/jua53zm6d7lc8kfz9dk4mpnlsdjhctl8
    publitas.com : https://view.publitas.com/trutrainers-inc/ensure-your-success-with-this-000-736-question-bank
    zoho.com : https://docs.zoho.com/file/5yo4g22ab9bf35e614abaa897dae00cd7d5da






    Back to Main Page





    Killexams exams | Killexams certification | Pass4Sure questions and answers | Pass4sure | pass-guaratee | best test preparation | best training guides | examcollection | killexams | killexams review | killexams legit | kill example | kill example journalism | kill exams reviews | kill exam ripoff report | review | review quizlet | review login | review archives | review sheet | legitimate | legit | legitimacy | legitimation | legit check | legitimate program | legitimize | legitimate business | legitimate definition | legit site | legit online banking | legit website | legitimacy definition | pass 4 sure | pass for sure | p4s | pass4sure certification | pass4sure exam | IT certification | IT Exam | certification material provider | pass4sure login | pass4sure exams | pass4sure reviews | pass4sure aws | pass4sure security | pass4sure cisco | pass4sure coupon | pass4sure dumps | pass4sure cissp | pass4sure braindumps | pass4sure test | pass4sure torrent | pass4sure download | pass4surekey | pass4sure cap | pass4sure free | examsoft | examsoft login | exams | exams free | examsolutions | exams4pilots | examsoft download | exams questions | examslocal | exams practice |

    www.pass4surez.com | www.killcerts.com | www.search4exams.com | http://smresidences.com.ph/