Exam Questions Updated On :
it's far proper location to find C2090-737 dumps paper.
I looked for the dumps which answer my precise desires at the C2090-737 exam prep. The killexams.com dumps actually knocked out everybitof my doubts in a quick time. First time in my profession, I in reality attend the C2090-737 exam with best one training material and exist successful with a high-quality score. I am surely happy, but the reason imright here to congratulate you at the remarkable assist you supplied inside the contour of test dump.
it's miles remarkable to hold C2090-737 true exam questions.
killexams.com tackled everybitof my issues. Considering long question and answers was a test. Anyhow with concise, my planning for C2090-737 exam was truly an agreeable experience. I effectively passed this exam with 79% score. It helped me reckon without lifting a finger and solace. The Questions & Answers in killexams.com are fitting for fetch ready for this exam. Much obliged killexams.com for your backing. I could referee about for long just while I used killexams. Motivation and Positive Reinforcement of Learners is one topic which I found difficult but their abet manufacture it so easy.
Is there a shortcut to fleet prepare and pass C2090-737 exam?
Being a network professional, I thought appearing for C2090-737 exam would really abet me in my career. However, due to time restrains preparation for the exam became really tough for me. I was looking for a study lead which could manufacture things better for me. killexams.com examcollection dumps worked fancy wonders for me as this is a systematic solution for more particular study. Unexpectedly, with its help, I managed to complete the exam in just 70 minutes which is really a surprising. Thanks to killexams.com materials.
these C2090-737 actual test questions works within the actual choose a perceive at.
My brother saden me telling me that I wasnt going to undergo the C2090-737 exam. I word once I perceive out of doors the window, such a variety of unique humans requisite to exist visible and heard from and that they certainly want the eye folks however im able to declare you that they college students can fetch this hobby at the very time as they skip their C2090-737 check and i can assist you to understand how I cleared my C2090-737 checkit changed into exceptional once I hold been given my test questions from killexams.com which gave me the wish in my eyes collectively everybitof the time.
attempt out these actual C2090-737 dumps.
Me and my roommate hold been living together for a long time and they hold a lot of disagreements and arguments regarding various things but if there is one thing that both of us conform on it is the fact that this killexams.com is the best one on the internet to employ if you want to pass your C2090-737 . Both of us used it and were very satisfied with the outcome that they got. I was able to achieve well in my C2090-737 test and my marks were actually terrific. Thank you for the guidance.
in which am i able to find C2090-737 dumps brand new true test questions?
My brother saden me telling me that I wasnt going to undergo the C2090-737 exam. I exist cognizant after I appearance out of doors the window, such a lot of one of a benign human beings want to exist seen and heard from and that they sincerely want the eye human beings but im able to let you know that they students can fetch this interest whilst they pass their C2090-737 check and i will let you know how I cleared my C2090-737 test it become handiest when I hold been given my test questions from killexams.com which gave me the wish in my eyes together everybitof the time.
pleasant to hear that actual exam questions present day C2090-737 examination are to exist had.
The short answers made my preparation more convenient. I completed 75 questions out off 80 well under the stipulated time and managed 80%. My aspiration to exist a Certified choose the exam C2090-737. I got the killexams.com examcollection lead just 2 weeks before the exam. Thanks.
terrific source latest actual test questions, accurate solutions.
I prepared C2090-737 with the abet of killexams.com and found that they hold pretty trustworthy stuff. I will depart for other IBM exams as well.
located an accurate source for actual C2090-737 Questions.
Even as i used to exist getting organized up for my C2090-737 , It became very annoying to pick out the C2090-737 test material. I discovered killexams.com while googling the trait certification assets. I subscribed and noticed the wealth of sources on it and used it to prepare for my C2090-737 check. I spotless it and Im so thankful to this killexams.com.
Take those C2090-737 questions and answers earlier than you visit holidays for test prep.
I desired to drop you a line to thanks on your test materials. This is the number one time i hold used your cram. I just took the C2090-737 today and passed with an 80% marks. I ought to admit that i was skeptical at the start however me passing my certification exam virtually proves it. Thank you lots! Thomas from Calgary, Canada
The criterion pay for a Database Administrator (DBA) with IBM DB2 odds is $37.57 per hour.
The usual pay for a Database Administrator (DBA) with IBM DB2 expertise is $86,256 per year.income $fifty nine,336 - $one hundred twenty,172 Bonus $998 - $11,298 profit Sharing $four,000 complete Pay (? XTotal Pay combines groundwork annual salary or hourly wage, bonuses, profit sharing, counsel, commissions, overtime pay and different forms of money salary, as material for this job. It does not embrace equity (stock) compensation, money value of retirement advantages, or the price of other non-money advantages (e.g. healthcare). ) $fifty eight,504 - $one hundred twenty five,048 Hourly rate $15.77 - $65.89 overtime $fifty one.22 Bonus $998 - $eleven,298 income Sharing $four,000 total Pay (? XTotal Pay combines groundwork annual revenue or hourly wage, bonuses, income sharing, advice, commissions, overtime pay and other types of money salary, as applicable for this job. It doesn't consist of equity (inventory) compensation, cash price of retirement merits, or the value of different non-cash benefits (e.g. healthcare). ) $fifty eight,504 - $a hundred twenty five,048 Job Description for Database Administrator (DBA)
A database administrator (DBA) is an IT knowledgeable who ensures that the utility used to maneuver a database is correctly maintained to allow rapid entry when necessary. as a result of even entry, searches, site visitors are recumbent to hold a damaging repercussion on any company database, the DBA works to hold the efficiency of the servers. he or she likewise will usually work to exist positive information protection, coordinating with an IT security professional or crew in greater organizations to advocate preserve the integrity of sensitive trade statistics.study more...
one of the vital main jobs of a database administrator is to preserve a corporation's counsel available in an efficient method. Many agencies require that statistics exist purchasable by the employ of cloud servers in order that it can exist accessed at any time. in fact, a DBA homes best a diminutive percentage of statistics in a cloud atmosphere, due to the price and protection considerations created when doing so. although, the DBA ensures that cloud access to facts can likewise exist accomplished directly and successfully.
To work as a database administrator, someone typically will requisite a bachelor's degree in laptop science, an associate's diploma in database administration, or an identical degree. Many businesses will likewise require a DBA candidate to hold a historical past in IT work on database administration groups. typically, an administrator works usual company hours throughout the week, but many corporations require a DBA to exist accessible on title always, in case of a device emergency. (Copyright 2019 PayScale.com)
Database Administrator (DBA) tasks
Pay via adventure for a Database Administrator (DBA) has a positive vogue. An entry-stage Database Administrator (DBA) with under 5 years of journey can forecast to earn an medium complete compensation of $71,000 in line with 33 salaries provided through nameless clients. criterion complete compensation includes advice, bonus, and time beyond regulation pay. A Database Administrator (DBA) with mid-profession event which comprises employees with 5 to 10 years of adventure can expect to earn an medium total compensation of $78,000 in keeping with forty two salaries. An skilled Database Administrator (DBA) which comprises personnel with 10 to twenty years of experience can forecast to earn a typical total compensation of $ninety one,000 based on 23 salaries. A Database Administrator (DBA) with late-profession journey which includes employees with enhanced than two decades of event can forecast to earn a criterion complete compensation of $95,000 in line with 16 salaries.
It’s handy to flux tasks to diverse workstations or installations in case you ever deploy a unique replica of the IBM records Studio IDE to your computer or engage the features of different personnel to work with you in your initiatives. To export a chore from a computer, duty the following steps:
1. select the chore you requisite to export (for their instance, DatabaseJournalProject), right-click, and choose Export. for instance:
2. choose File system and click subsequent:
in case you don’t perceive the File gadget folder within the default accelerated tree view, you could ought to extend the different folder to discover this option.
3. choose the facts construction undertaking that you simply are looking to export from the left side of the File system page of the Export wizard, and within the revise pane optionally select the accessories of the assignment that you simply requisite to export. as an example, on here web page I’ve handiest chosen to export the FEMALEPERSONNEL SQL statement together with the mission’s metadata:
4. category a target listing for the challenge in the To directory container.
5. choose any options that you just want to solemnize to this export operation within the options container. For this instance, the defaults are quality; click on conclude.
To import your exported assignment into a brand new records evolution undertaking, operate here steps:
1. choose the destination challenge, correct-click, and choose the Import option. (you could perceive in here figure that I’ve created a brand new information edifice venture with the very title as the previous one.)
2. opt for File system and click on subsequent:
3. The Import wizard opens. choose the mission within the left pane of the File device web page and the components of this mission that you want to import into the new facts construction assignment. For this example, select every thing in the import file as proven beneath, after which click finish.
As you can see, the points had been imported into the statistics chore Explorer view within the records edifice undertaking that you just special:
note that in case you imported a kept system or a user-defined feature into your new facts evolution challenge, these objects aren’t created within the database that the brand new mission is linked to (assuming it’s a different database). You’d ought to set up these objects. in this example, everybitof my information construction projects hook up with the sample database, so I wouldn’t must rebuild any routines if I had them in this imported challenge.
» perceive everybitof Articles by using Columnist Paul C. Zikopouloslogos
IBM, DB2, and z/OS are trademarks or registered emblems of alien trade Machines company in the united states, other international locations, or each.
Linux is a registered trademark of Linus Torvalds in the u.s., different countries, or each.
different company, product, or provider names could exist emblems or provider marks of others.
Copyright overseas trade Machines trade enterprise, 2008.
The opinions, solutions, and tips listed here are from the writer’s experiences and aren't supposed to signify genuine communique from IBM or an endorsement of any products listed within. Neither the writer nor IBM is answerable for any of the contents in this article. The accuracy of the assistance listed here is in response to the author’s capabilities on the time of writing.
Whilst it is very arduous chore to choose reliable exam questions / answers resources regarding review, reputation and validity because people fetch ripoff due to choosing incorrect service. Killexams. com manufacture it inescapable to provide its clients far better to their resources with respect to exam dumps update and validity. Most of other peoples ripoff report complaint clients reach to us for the brain dumps and pass their exams enjoyably and easily. They never compromise on their review, reputation and trait because killexams review, killexams reputation and killexams client self confidence is requisite to everybitof of us. Specially they manage 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 perhaps you perceive any bogus report posted by their competitor with the title killexams ripoff report complaint internet, killexams.com ripoff report, killexams.com scam, killexams.com complaint or something fancy this, just preserve in irony that there are always contaminated people damaging reputation of trustworthy services due to their benefits. There are a big number of satisfied customers that pass their exams using killexams.com brain dumps, killexams PDF questions, killexams rehearse questions, killexams exam simulator. Visit Killexams.com, their test questions and sample brain dumps, their exam simulator and you will definitely know that killexams.com is the best brain dumps site.
000-014 test questions | JN0-533 free pdf download | 600-455 mock exam | M2050-243 test prep | 000-275 rehearse test | 1K0-001 rehearse test | DSST-HRM exam prep | HP0-144 test prep | HP0-621 rehearse test | HP0-S21 brain dumps | 1D0-435 true questions | 920-261 braindumps | 9A0-395 sample test | C2010-825 study guide | HP5-H08D free pdf | JN0-647 braindumps | 1Z0-451 questions answers | 1Z0-813 rehearse Test | 000-215 true questions | 000-M605 study guide |
Never miss these C2090-737 questions you depart for test.
Are you looking for IBM C2090-737 Dumps of true questions for the DB2 9 System Administrator for z/OS Exam prep? They provide most updated and trait C2090-737 Dumps. Detail is at http://killexams.com/pass4sure/exam-detail/C2090-737. They hold compiled a database of C2090-737 Dumps from actual exams in order to let you prepare and pass C2090-737 exam on the first attempt. Just memorize their examcollection and relax. You will pass the exam.
Is it staunch that you just are examining out IBM C2090-737 Dumps containing true exam Questions and Answers for the DB2 9 System Administrator for z/OS test prep? killexams.com is here to surrender you one most updated and trait database of C2090-737 Dumps that's http://killexams.com/pass4sure/exam-detail/C2090-737. they hold got aggregative an information of C2090-737 Dumps questions from true tests with a selected finish goal to surrender you an opening to induce prepared and pass C2090-737 exam on the first attempt. killexams.com Discount Coupons and Promo Codes are as under; WC2017 : 60% Discount Coupon for everybitof exams on website PROF17 : 10% Discount Coupon for Orders larger than $69 DEAL17 : 15% Discount Coupon for Orders larger than $99 SEPSPECIAL : 10% Special Discount Coupon for everybitof Orders
If you're searching out Pass4sure C2090-737 rehearse
Test containing true Test Questions, you are at privilege vicinity. They hold compiled database of questions from Actual Exams so as that will abet
together and pass your exam on the first attempt. everybitof schooling materials at the website are Up To Date and proven with the aid of their specialists.
We offer ultra-modern and up to date Pass4sure rehearse Test with Actual Exam Questions and Answers for brand new syllabus of IBM C2090-737 Exam. rehearse their true Questions and Answers to help your expertise and pass your exam with high Marks. They manufacture positive your pass inside the Test Center, protecting everybitof of the subjects of exam and construct your learning of the C2090-737 exam. Pass four positive with their accurate questions.
killexams.com C2090-737 Exam PDF includes Complete Pool of Questions and Answers and Dumps checked and confirmed inclusive of references and causes (where relevant). Their target to collect the Questions and Answers isn't always best to pass the exam at the start strive but Really help Your learning about the C2090-737 exam topics.
C2090-737 exam Questions and Answers are Printable in high trait Study lead that you may down load in your Computer or another device and start preparing your C2090-737 exam. Print Complete C2090-737 Study Guide, deliver with you while you are at Vacations or Traveling and relish your Exam Prep. You can fetch privilege of entry to up to date C2090-737 Exam examcollection out of your on line account anytime.
killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for everybitof assessments on website
PROF17 : 10% Discount Coupon for Orders extra than $69
DEAL17 : 15% Discount Coupon for Orders more than $ninety nine
DECSPECIAL : 10% Special Discount Coupon for everybitof Orders
Download your DB2 9 System Administrator for z/OS Study lead without leisurely after shopping for and Start Preparing Your Exam Prep privilege Now!
Killexams 700-702 true questions | Killexams 000-535 rehearse test | Killexams 300-135 questions answers | Killexams AngularJS cram | Killexams 400-051 rehearse questions | Killexams HP0-J11 braindumps | Killexams 70-122 questions and answers | Killexams C9550-412 study guide | Killexams 050-V37-ENVCSE01 rehearse test | Killexams COG-320 rehearse Test | Killexams 000-976 test prep | Killexams 00M-198 cheat sheets | Killexams ML0-220 true questions | Killexams 646-580 pdf download | Killexams 650-368 test questions | Killexams 000-532 VCE | Killexams 000-240 braindumps | Killexams A2180-178 braindumps | Killexams A4120-784 exam prep | Killexams 000-614 free pdf |
Exam Simulator : Pass4sure C2090-737 Exam Simulator
Killexams 000-R06 dump | Killexams E20-357 exam prep | Killexams 250-251 true questions | Killexams 300-209 sample test | Killexams CAU301 braindumps | Killexams 000-428 braindumps | Killexams HP2-B109 cheat sheets | Killexams 9L0-611 rehearse test | Killexams VCS-322 questions answers | Killexams 250-510 brain dumps | Killexams 000-560 cram | Killexams 1Z0-226 exam questions | Killexams M2150-810 study guide | Killexams 2V0-731 dumps | Killexams 000-M237 study guide | Killexams A2010-573 braindumps | Killexams P2090-075 free pdf download | Killexams 1Z0-050 mock exam | Killexams 000-N09 braindumps | Killexams CCD-470 true questions |
IBM Data Science experience provides an environment that brings together everybitof of a data scientist’s tools into one location. It includes the most Popular Open Source tools and IBM value-add functionality with integration of community and social features to manufacture data scientists more successful.
A wide variety of cloud data sources are easily connected to DSX, or a user could upload data from DB2 on z/OS (by creating a copy) into the environment. However, the talent to access to data in-place on the system of record, has distinguished appeal.
In this guide, I will profile the steps needed to configure DSX to access an on-prem DB2 for z/OS database using JDBC and provide the talent to utilize RStudio to achieve advanced analytics operations on this data.
Here is an profile of the steps they will depart through in the lead to set up the DSX environment for DB2 for z/OS connectivity:
(Note: The screenshots in this tutorial are from a Mac OSX environment running Firefox. If you are running from Windows or Linux, there may some differences in the appearance of the endemic dialogs and browser interfaces.)
Once setup with your account, click on the DSX Logo at the top of your screen, and this will choose you to the main Community page. Once there, if you click the far left drop-down menu, you will perceive your project options, including RStudio. Click on the the RStudio option, and this will open up your RStudio instance.
If you hold opened DSX RStudio before, the instance opened will hold retained any history or enviroment settings that you had saved/autosaved from before. If you are close with RStudio and hold used a endemic version of RStudio on Windows/Mac OSX, it will perceive exactly the same. The only dissimilarity is that the underlying infrastucture is running in a Bluemix virtual machine. There is limited access to the underlying operating system, but they can access the filesystem to upload the JDBC driver and license file and configure the connection for DB2 for z/OS.
The RStudio interface should perceive similar to what is shown below……
(For a complete lead to using RStudio, gladden perceive the documentation linked to in the ‘Help’ Section)
Next, they will confirm that the revise packages are installed/loaded that enable JDBC access to their on-prem database.
In the bottom privilege panel of the RStudio desktop you will perceive the ‘Packages’ tab, and within that is an ‘Install’ tab. If you click “Install”, you will fetch a dialog box that allows you to load the required packages from the CRAN repo. You will requisite to install ‘RJDBC’. If the ‘Install dependencies’ box is checked, you will likewise exist installing ‘rJava’ and ‘DBI’ (which load automatically). Once you install these packages, you should perceive them in the User Library. If they are unchecked, gladden check them, and they will exist enabled in the environment.
Next, they will requisite to upload the preempt DB2 for z/OS data server driver .jar files to the DSX environment. The files they will requisite are: db2jcc.jar and db2jcc_license_cisuz.jar
If you already hold a licensed version of DB2 Connect installed, these driver files are already available on one of your existing client environment setups. query your DB2 system administrator for the location of these files in your client environment.
This lead is based on DB2Connect Version 11.1 for Linux, Unix and Windows (client) and DB2 for z/OS Unlimited Edition (server). If you are not currently licensed for DB2Connect, perceive the Appendix at the recess of this lead for instructions on how to obtain the revise data server drivers and license files that are required.
From the RStudio desktop (shown above), depart to the lower privilege panel again, to the “Files” section. Then, click “Upload” and you will fetch a dialog box that allows you to browse your local file system to upload the driver files. For both db2jcc.jar and db2jcc_license_cisuz.jar, upload these to the current directory of your DSX/RStudio environment.Connecting to the z Server over TCPIP — Secure Gateway
With the JDBC driver files in place, they now requisite to configure access to the server which is running the DB2 for z/OS instance. The assumption for most IBM customers is that their target z server is running on a secure internal network, which is accessed externally through a VPN or from an internal private network access point. If this is the case, you will likewise requisite to set up a Bluemix Secure Gateway, that will allow the Bluemix/DSX cloud app to access your z server through a firewall, using the very VPN/internal network acces point that you employ for other client connections from a desktop.
For more general information on Bluemix Secure Gateways, gladden depart to: https://console.ng.bluemix.net/docs/services/SecureGateway/secure_gateway.html
If you finish not requisite to configure a Secure Gateway, you can skip to the “Connecting to DB2/zOS with JDBC” section.
To configure the secure gateway, gladden depart to https://console.ng.bluemix.net/dashboard/services/, log in to Bluemix with the very credentials you are using for DSX, and then employ the drop-down menu on the left to depart to the ‘Services’ and then ‘Dashboard’ menu.
Once within the Services dashboard, click the “Create Service +” button.
Next, they will depart to “Integrate” and then choose the “Secure Gateway” service from the menu.
Leave the service “Unbound” and click “Create”.
And, then “+ Add Gateway’
Choose a title for your gateway, uncheck both of the boxes listed, and then click “Add Gateway”.
Now, they can setup the destination details, and the client. Click on the gateway.
Then click on “+ Add Destination”.
Choose “On-Premises” and click Next.
On the next screen add your host name/IP , and the DB Port of your DB2z Subsystem. Click ‘Next’
Then, select TCP protocol on the next screen, and click “Next” again.
The next screen setting is related to server side authentication. If you typically connect with just a user and password, then choose “None”. If you are not positive whether or not your server requires additional authentication, query your System Administrator, and you can change this later. Click ‘Next’.
You can skip over the next setting, unless you want to privatize the IP address and port or your connection. Click ‘Next’.
To complete the destination settings for the back-end server, they just requisite to give a title for their connection. choose a title for your destination that describes the DB2 Subsystem you are connecting to, and then click “Finish”.
Now let’s install the client for their secure gateway. choose “+ Add Clients”
Choose your preferred method of hosting the gateway client. For this demonstration, they will exist using IBM Installer — Mac OSX version on a laptop that has a VPN connection to access an on-prem z server. The details for different OS installs and Using Docker or IBM DataPower are covered in detail in the online instructions. For specific install details, perceive the “Bluemix Documentation” link.
At this time, copy the Gateway ID, for input later into the gateway client command-line interface.
After Downloading the client, double-clicking the image, you might hold to depart to your ‘Finder’ to perceive the mount point for the image.
Click on the mount-point and then drag the ‘ibm’ folder into the Applications Folder.
Now, they can depart into the ‘IBM’ folder within Applicatons, and double-click to eschew the segw.command to open the CLI for the gateway.
Enter the gateway ID you copied earlier, and then enter ‘none’ for the security token.
Next, note the web address of the gateway interface — localhost:9003/dashboard Enter that web address in your web browser.
Below, they perceive the gateway web UI. You can perceive everybitof the details of your secure gateway from this interface. There is one more setting, for the access control list. gladden click “Access Control List”, and then enter your destination hostname/IP and port once again.
Below, once you hold added the host/IP and port, you can near the browser window, or minimize it.
We are almost done. The Secure Gateway config is complete.
Now they will revert to the main Secure Gateway dashboard to copy the cloud hostname/port for the gateway. It will exist used for the JDBC connection string in DSX/RStudio. From the Services Dashboard, click on the gateway you created.
On this screen, click on the ‘settings gear’ of the destination server connection details. A dialog box will open.
Copy the ‘Cloud Host : Port’ address to employ in your JDBC connection in DSX/RStudio.
Return to the RStudio desktop, and they can setup the JDBC driver and eschew a query.Connecting to DB2/zOS with JDBC
In the RStudio desktop, they are now ready to enter the JDBC commands at the console prompt to setup the connection to their DB2 for z/OS database. manufacture positive the RJDBC, DBI, and rJava packages hold loaded.
Also, at this time, manufacture positive you are running any VPN connection that is normally required to access your backend system from a desktop client.
Enter the following commands in the RStudio console, noting the results you fetch for the classpath display:
.jinit() .jclassPath() .jaddClassPath("/home/rstudio/db2jcc_license_cisuz.jar") .jclassPath() drv <- JDBC("com.ibm.db2.jcc.DB2Driver","/home <br> /rstudio/db2jcc.jar") .jclassPath()
(* note the addition of the license file….its position in the classpath is requisite *)
This chapter discussed the DB2 products for LUW. There are a number of offerings available, including:
These products provide the flexibility to execute database applications running on pervasive devices up to multi-node clusters. DB2 provides advocate for the commonly used communication protocols.
Each of the DB2 data server editions comes with a set of purchasable add-on feature packs that you can employ to extend the capabilities of the core data server. There are likewise number of add-on tools and products that you can likewise buy for DB2, including DB2 Query Patroller and a myriad of DBA-focused tools such as high Performance Unload, the DB2 Recovery Expert, and more.
SQL-based replication is integrated into everybitof DB2 for Linux, UNIX, and Windows servers. Replication can exist used to drag data between members of the DB2 family, or from and to members of the DB2 family and non-DB2 data servers (like Oracle, SQL Server, and more) if you're using WebSphere Replication Edition. DB2 Connect is used to access DB2 data that resides on DB2 for i5/OS, VM/VSE, and z/OS operating systems, and it comes with federated capabilities that can likewise exist added to a DB2 data server installation.
DB2 9 includes a number of application evolution enhancements, including the DB2 Developer Workbench and integration into the world's most Popular IDEs such as Rational Application Developer, Zend Core, and Microsoft Visual Studio 2005.
Significant new features hold been added to manufacture DB2 easier to manage. SMART technology (Self-managing and Resource Tuning) has been integrated into a number of DB2 components, including installation, configuration, utilities, problem determination and resolution, and availability. This is allotment of IBM's autonomic computing initiative and new features will continue to exist added to manufacture DBAs more productive.
This chapter likewise introduced some of the graphical and command line tools available in DB2. The Command Line Processor (CLP) is a text-based application that allows you to enter DB2 commands and SQL statements and is found in everybitof DB2 products. From the desktop, an administrator can configure remote and local systems, administer instances and databases, and create database objects graphically using the Control headquarters or the Configuration Assistant. Tools fancy the DB2 Health headquarters and DB2 Activity Monitor likewise abet manage DB2 environments while export advocate is provided in the contour of Wizards and Advisors. In the remaining chapters, additional DB2 functions and tools will exist examined for how they assist the recess user, application developer, and administrator.
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 allotment 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 advocate 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 everybitof of the DB2 mainstream editions that eschew 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 exist 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 abet you publish, place, cleanse, transform, enrich, and access data across heterogeneous data sources.
WebSphere Application Server — A allotment of this application server is shipped with DB2. It allows developers to employ Java as a platform in a transaction processing environment.
Once a DB2 application has been developed, you requisite 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 requisite 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 advocate connectivity to DB2 9 data servers (the exception to this is if you choose to advocate communication via specific API drivers, covered later in this section). When you install a DB2 Runtime Client, you install a driver to advocate everybitof the common programming methodologies, including ADO.NET, ADO, OLE DB, ODBC, JDBC, SQLJ, static SQL, and more.
Note - In this chapter, the employ 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 achieve 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 embrace tooling, documentation, and so on. The DB2 9 Runtime Client is analogous to the DB2 8 Runtime Client Lite, only is now available on everybitof 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 everybitof 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 aide 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 evolution and DB2 8 Administration clients.
A DB2 Client's footprint is directly correlated to the components you select to install and can choose 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 preference of which DB2 client to install should exist based on the requirements of the application on the client machine. For example, if you hold a database application developed for Linux, UNIX, or Windows and you finish not require the DB2 administration or application evolution tools from a Windows workstation, yet want to advocate applications written in multiple programming languages fancy .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 requisite to access the DB2 Runtime Client code remotely from a code server before accessing to DB2. This sort of configuration is known as a thin client. A thin-client configuration can provide many benefits, such as a central catalog directory of everybitof 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 exist eminent 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 requisite 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 very server, connectivity is considered to reach from a local client. If the application is installed on a system other than the DB2 data server, its connectivity is considered to reach from a remote client.
Figure 1–10Accessing a DB2 data server using the DB2 Runtime Client
DB2 client connectivity can exist 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 exist deployed for connectivity on their own, outside of a DB2 Runtime Client or DB2 Client installation.
The IBM Driver for JDBC and SQLJ can exist deployed to advocate Java-based connectivity to a DB2 data server. This driver is about 2 MB in size and can easily exist 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 requisite to additionally license this connectivity with DB2 Connect (covered in the next section) to ensure you are compliant with respect to licensing.
It's requisite 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 advocate data server connectivity using other APIs. For example, you can't advocate 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 very 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 requisite to hold DB2 RTCL or DB2 Client installed on the client machines
Same concept as the JDBC/SQLJ driver but for ODBC/CLI applications
DB2 Connect is a sever 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 employ the Distributed Relational Database Architecture (DRDA), you hold 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 requisite 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 compass 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 evolution environments for mainframe data access. For example, DB2 Connect makes data artifacts on the mainframe (including nonrelational-related services fancy CICS and VSAM) transparent to the world's most Popular IDEs; for example, a .NET developer can employ 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 tradition systems with new deployments on distributed platforms, modernize the application evolution experience for mainframe evolution (for example, pitiful from COBOL to Java), and off-loading evolution 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 perceive in figure 1–11 that there are many ways to implement a DB2 Connect product. In a multi-tier environment, you employ 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 hold DB2 Connect on its own or collocated with the application server. Depending on your configuration, you may or may not requisite to install a DB2 client.
DB2 Connect products can exist 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 manufacture the connection to a mainframe DB2 resource, but you quiet requisite to purchase a convincing 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, everybitof of the DB2 Connect editions offer the very duty and features; they are merely differentiated by capability. everybitof 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 employ 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 manufacture direct connections to DB2 running on the mainframe. In figure 1–11, the desktop users likely hold DB2 Connect PE installed in their workstations. DB2 Connect PE can likewise 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 manufacture direct connections using the DB2 Connect PE software for inescapable stages of the evolution cycle. But once the application is in production, they may employ the DB2 Connect PE software to connect to a DB2 Connect gateway to choose odds 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 exist licensed using two different user-based options: the number of Authorized Users or the number of Concurrent Users. DB2 Connect EE provides the talent 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 everybitof the applications servers that connect to the mainframe. The VUs that you purchase hold nothing to finish 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 hold to buy 1,000 VUs of DB2 Connect ASE. DB2 Connect ASE is well suited for environments where you expect to perceive 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 groundwork server license plus a per-unit imbue for the MSU rating of the System z server you are connecting to. DB2 Connect UE is well suited for environments that hold 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 drag mainframe data to occasionally connected devices, as well as DB2 Connect PE. Essentially, this edition of DB2 Connect, as its title would imply, allows for unlimited deployments.
There's so much more to the DB2 Connect product than what's particular in this section. In fact, the title DB2 Connect is misleading because connectivity is just a diminutive allotment of what this product can do; however, these details are outside the scope of this book.
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) ]
Dropmark : http://killexams.dropmark.com/367904/11794964
Wordpress : http://wp.me/p7SJ6L-1HD
Dropmark-Text : http://killexams.dropmark.com/367904/12566100
Blogspot : http://killexamsbraindump.blogspot.com/2017/12/people-used-these-ibm-dumps-to-get-100_6.html
RSS Feed : http://feeds.feedburner.com/RealC2090-737QuestionsThatAppearedInTestToday
Box.net : https://app.box.com/s/6gkuf1t35v2whf6qifl6c0wxqfcylff2