Killexams.com C4040-250 Dumps and real Questions
100% real Questions - Exam Pass Guarantee with lofty Marks - Just Memorize the Answers
C4040-250 exam Dumps Source : Power Systems with POWER8 Sales Skills V1
Test Code : C4040-250
Test designation : Power Systems with POWER8 Sales Skills V1
Vendor designation : IBM
: 108 real Questions
Use authentic C4040-250 dumps with wonderful character and reputation.
despite having a complete-time stint along side family duties, I determined to sit down for the C4040-250 exam. And i was in search of easy, brief and strategic guideline to get utilize of 12 days time before exam. I were given every solitary these in killexams.com . It contained concise solutions that were light to recall. thank you loads.
am i capable of locate dumps Q & A brand novel C4040-250 examination?
i used to subsist now not equipped to recognize the points nicely. in any case resulting from my ally killexams.com Questions & solutions who bailed me to depart this trepidation by fitting questions and answers to allude; I efficaciously endeavored 87 questions in eighty minutes and passed it. killexams.com in fact turned out to subsist my actual associate. As and when the exam dates of C4040-250 maintain been forthcoming nearer, i used to subsist getting to subsist anxious and apprehensive. a Great deal appreciated killexams.com.
What carry out you imply by pass of C4040-250 examination dumps?
I passed the C4040-250 exam with this package deal from Killexams. I am no longer tremendous i would maintain finished it without it! The thing is, it covers a expansive nature of subjects, and if you set together for the exam for your private, without a installed technique, chances are that a few matters can topple through the cracks. The ones are only a few areas killexams.com has virtually helped me with there may subsist just an exorbitant amount of facts! killexams.com covers the entirety, and since they utilize actual exam questions passing the C4040-250 with an poor lot less pressure is a lot less difficult.
Is there C4040-250 exam novel sayllabus?
Before I stroll to the sorting out center, i was so assured approximately my education for the C4040-250 exam because of the verity I knew i used to subsist going to ace it and this self-confidence came to me after the utilize of this killexams.com for my assistance. It is brilliant at supporting college students much devotion it assisted me and i was capable of derive desirable markss in my C4040-250 test.
No source is greater proper than this C4040-250 source.
Passed C4040-250 exam some days in the past and got an exemplar score. However, I can not capture full credit score for this as I used killexams.com to prepare for the C4040-250 exam. Two weeks after kicking off my exercise with their exam simulator, I felt devotion I knew the solution to any query that might advance my way. And I certainly did. Every question I study on the C4040-250 exam, I had already seen it even as practicing. If now not each, then tremendous majority of them. Everything that was within the coaching percent became out to subsist very apropos and beneficial, so I cant thank enough to killexams.com for making it array up for me.
I got Awesome Questions bank for my C4040-250 exam.
Tremendous!, I proud to test in conjunction with your C4040-250 QA and software software. Your software helped me plenty in preparingmy IBM test.
Get the ones C4040-250 actual exam questions and answers! carry out now not derive ripplatestf
I handed C4040-250 certification with ninety one percentage marks. Your braindumps are very similar to actual exam. Thank you for your greatassist. I am capable of hold to utilize your dumps for my subsequent certifications. At the very time as i used to subsist hopeless that i cant emerge as an IT licensed; my pal advised me about you; I attempted your on line education apparatus for my C4040-250 examand emerge as capable of derive a 91 result in exam. I personal pass to killexams.
Is there a person who surpassed C4040-250 examination?
With the utilize of Great products of killexams.com, I had scored 92 percent marks in C4040-250 certification. I was searching for dependable study material to increase my understanding level. Technical concepts and difficult language of my certification was difficult to understand therefore I was in search of dependable and light study products. I had advance to know this website for the preparation of professional certification. It was not an light job but only killexams.com has made this job light for me. I am fervor wonderful for my success and this platform is best for me.
No questions was asked that was out of these bank.
It changed into very encourging revel in with killexams.com team. They informed me to attempt their C4040-250 exam questions as soon asand neglect failing the C4040-250 exam. First I hesitated to apply the material because I apprehensive of failing the C4040-250 exam. But once I informed by my buddies that they used the exam simulator for thier C4040-250 certification exam, i purchased the guidance percentage. It revolve out to subsist very reasonably-priced. That changed into the number one time that I satisfied to utilize killexams.com education material after I got 100% marks in my C4040-250 exam. I in fact understand you killexams.com team.
Do you necessity real test questions of C4040-250 examination to prepare?
Have genuinely passed my C4040-250 exam. Questions are valid and accurate, its the best news. I used to subsist ensured ninety nine% skip pervade and cash lower lower back guarantee, however obviously i maintain were given exceptional rankings. Which is the coolest facts.
IBM Power Systems with POWER8
today NCI in Australia introduced that it has adopted IBM’s Power8 architecture as a portion of Raijin, the gadget fastest supercomputer within the Southern Hemisphere. The hybrid x86/Power8 apparatus will present local researchers the possibility to determine the intersection of AI and HPC.
IBM’s vim techniques scale scientific simulation and modeling to novel heights in NCI’s Raijin supercomputer,” said Dave Turek, vice chairman of Exascale methods at IBM. “The wonderful bandwidth in power systems offers a significant performance potential, and they appear to subsist forward to scientists exploiting these capabilities now and into the longer term.”
NCI team of workers were working intently with Australia’s scientific community to qualify a number reminiscence-intensive purposes for utilize beneath IBM’s architecture. With further enter from NCI’s optimization group, these applications maintain produced spectacular efficiency benchmarks using vim methods.
as an instance, NCI is the first institution to port Q-Chem, a quantum chemistry equipment, over to vigour programs. prefatory benchmarks of this optimization maintain outpaced the equal application operating below Broadwell x86 architecture, opening novel and instant percentages for computational chemists.
moreover, NCI’s optimization of NAMD molecular dynamics code on energy programs noticed performance wonderful points when in comparison to existing Broadwell x86 structure. initial benchmark results of MILC in vim programs besides noticed modest to expansive improvements over current x86 methods.
in response to the benchmarks from the analysis testbed, it is anticipated that a expansive purview of scientific disciplines could ultimately improvement from optimized efficiency below vim structure, including (but no longer constrained to) the fields of physics, biology and chemistry.
This novel software exists alongside over 3,000 different purposes that maintain already been optimized by NCI’s HPC optimization group for the existing x86 and GPU systems that power Raijin. NCI will proceed a procedure of vim programs qualification and optimization for other scientific functions to fulfill researcher demand.
NCI is the first institution to merge both vim and x86 architectures into the very scheduling device, offering unparalleled diversity, accessibility and freedom of option for researchers gaining access to HPC via NCI. The IBM energy systems are purchasable through the current PBSPro scheduler, and maintain been built-in into NCI’s LDAP and accounting methods.
furthermore, the vim techniques will improvement from Mellanox EDR and FDR interconnect at speeds of up to 100Gbps, granting access to over 40PB of quickly Lustre storage it really is already accessible across different Raijin systems.
NCI’s dedication to investing in the latest computing components continues with the mixing of IBM’s vim techniques into the Raijin cluster. This integration builds on NCI’s consolidated fashion to superior computing, combining high-efficiency CPU and GPU clusters with the quickest filesystems within the southern hemisphere – a heterogenous ambiance to subsist able to most effective serve the analysis community’s needs.
register for their insideHPC e-newsletter
today’s enterprise leaders require servers designed for large statistics that are optimized, relaxed, and adjust to altering workload requirements. IBM power methods helps companies gain insight sooner from better and greater intricate data sets.
examine this e-book to unencumber the energy of POWER8 and find out how the excessive-performance infrastructure can edge your business.
no longer long after revealing more particulars about its subsequent-gen Power9 chip due in 2017, IBM these days rolled out three novel Power8-primarily based Linux servers and a novel version of its Power8 chip that includes Nvidia’s NVLink interconnect. one of the vital servers – vigour S822LC for top efficiency Computing (codenamed “Minsky”) – uses the novel chip (Power8 with NVLink) to communicate with P100 Pascal GPUs, NVIDIA’s most recent and maximum performing GPU.
The other servers – the vim S821LC and the vim S822LC for huge records – besides leverage GPU acceleration expertise (K80 or P100) by the utilize of PCIe interface and maintain IBM’s Coherent Accelerator Processor Interface (CAPI) for utilize with gleam storage and FPGAs. every solitary three servers are regular two-socket additions to IBM’s Linux line.
These introductions, talked about Sumit Gupta, vice president, exorbitant efficiency Computing and Analytics, IBM, may soundless subsist viewed as proof of IBM’s ongoing commitment to its vision of accelerated computing because the novel paradigm, and of cognitive computing (writ large) and expansive statistics analytics as the principal drivers (See HPCwire article, feel quick: IBM Talks Acceleration in HPC and the business).
also noteworthy is that the novel systems are manufactured by pass of companions. “All three of these OpenPOWER systems leverage the strengths and capabilities of OpenPOWER partners, from acceleration capabilities to strengths in design and manufacturing. in the spirit of open they hope that their trade companions who are manufacturing these techniques, Wistron, an OpenPOWER partner, and Supermicro, will bring power-based servers to their customers via their routes to market in an application to proliferate the OpenPOWER ecosystem,” referred to Gupta.
IBM says the S822LC server with NVLink embedded on the silicon smooth “permits records to glide 5x sooner” than on a similar x86-primarily based equipment. It besides considerably reduces the programming barrier to aggressive utilize of GPUs in keeping with Gupta who has written a more particular blog on the introductions. here's the primary Power8-based gadget delivered with NVLink in response to IBM.
“moving records from the CPU to the GPU [has been the] bottleneck because with most techniques most of it goes via this thin pipe, PCIe. With NVLink the GPU has access to as much as half a terabyte of reminiscence that sits on the CPU side of that interconnect,” Gupta instructed HPCWire. NVLink allows improved switch of records between each processors which essentially makes it less demanding to application.
“When an software starts, the entire facts is sitting in the system reminiscence, and besides you’ve bought to glide chunks of it over to the GPU,” Gupta persisted. “NVLink does three things. It improves the performance as a result of we’ve enabled a fatter pipe between the processors. It permits you to rush smaller functions. And it makes programming accelerators simpler since you ought to carry out less records management.”
the novel Power8 with NVLink processor features 10 cores working up to 3.26 GHz. POWER8 processors in this server maintain higher reminiscence bandwidth than x86 CPUs, at one hundred fifteen GB/s and might maintain as a Great deal as ½ a terabyte of system reminiscence per socket. There are bigger caches per core internal the POWER8 processor, and this coupled with the quicker cores and reminiscence bandwidth leads to bigger software performance and throughput.
the brand novel NVIDIA Tesla P100 GPU accelerator increases floating component performance, offering 21 teraflops of half-precision, 10.6 teraflops of single-precision, and 5.three teraflops of double-precision performance. The accelerator includes 16 gigabytes of the HBM2 stacked reminiscence with an on-GPU reminiscence bandwidth of 720 gigabytes per sec (GB/s). The NVIDIA Tesla P100 with NVLink GPU in the SXM2 figure component grants 14 percent extra uncooked compute performance than the PCIe variant.
the usage of NVLink, writes Gupta in his weblog, gives three essential benefits to software acceleration:
efficiency: the brand novel Power8 with NVLink processor and the novel Tesla P100 GPU maintain four NVLink interfaces that allow “5x sooner verbal exchange than a PCIe x16 Gen3 connection used in different programs.” This permits quicker records alternate and application efficiency, through overcoming the hassle of slim PCIe information pipe into the GPU.
Programmability: The CUDA eight utility and the page Migration Engine in Tesla P100 permit a unified reminiscence belt with automated statistics management between the system reminiscence connected to the CPU and the GPU reminiscence. Coupled with NVLink, unified reminiscence makes programming GPU accelerators a wonderful deal easier for developers. purposes may besides subsist with no inconvenience accelerated with GPUs by using incrementally relocating features from the CPU to the GPU, without needing to deal with records administration.
extra utility acceleration: since NVLink reduces the communique time between the CPU and GPU, it makes it possible for smaller items of labor to subsist moved to the GPU for acceleration. This faculty that extra parts of an software will besides subsist GPU accelerated.
In making the announcements, IBM persisted ratcheting up its ‘we’re-superior-than-Intel’ rhetoric. Its extensive software targets encompass every solitary issues huge facts and analytics, in addition to profound gaining knowledge of and cognitive computing.
“The expansive knowledge we're seeing for Power8 available in the market has been around statistics analytics, databases, and exorbitant efficiency computing for desktop researching and profound getting to know, and artificial intelligence,” observed Gupta. “as a result of we've quicker cores, they contemplate lots more advantageous efficiency, [for example], on databases compared to Intel-based mostly systems. purposes devotion kinetica, which is an accelerated (GPU optimized) database for profound researching and laptop learning, receives the charge of NVLink exorbitant velocity information connection between CPU and GPU.”
Recognizing the uphill combat in winning x86 market share, IBM during the past has emphasized efforts to penetrate hyperscalers as pivotal to its success (see HPCwire article, Handicapping IBM/OpenPOWER’s Odds for fulfillment).
according to the IBM unencumber: “Early trying out with one of the most world’s biggest information superhighway carrier providers (Tencent) based mostly in China has proven that a huge cluster of the brand novel energy S822LC for huge records servers changed into capable of flee an information-intensive workload 3 times sooner than its former x86-primarily based infrastructure. furthermore, this outcome became carried out while decreasing the entire variety of servers used by using two-thirds. Given the expansive pervade benefits of using fewer servers to bring sooner efficiency, the enterprise is now integrating the brand novel LC servers into its hyperscale statistics focus for massive records workloads.”
Sumit Gupta, IBM
Gupta maintains there’s a expansive appetite for brand novel Power8-primarily based servers despite the advancing Power9. “a number of organizations, research agencies and government bodies maintain pre-proven early programs and placed their orders. among those first in line to acquire shipments are a expansive multinational retail supplier and the U.S. branch of power’s every solitary rightRidge national Laboratory (ORNL),” according to the IBM free up.
ORNL will utilize the brand novel programs as a development platform for optimizing applications to capture capabilities of the developed-in NVLink interface know-how. The techniques will serve as an early-era test bed for developing annoying purposes for Summit, ORNL’s next technology supercomputer that IBM will bring in 2017 and so as to utilize the Power9 chip. Arthur S. (chum) Bland, OLCF challenge director, is quoted within the press free up announcing, “As an extended-time consumer of GPUs, they accept as wonderful with that this could help the efficiency of their functions and get it more straightforward for the users to bring exquisite science.”
building an ecosystem is complicated. For IBM and OpenPOWER, lots of the distinct items mandatory are reputedly falling into location. Time will inform.
hyperlink to Gupta’s weblog: www.ibm.com/blogs/programs/ibm-nvidia-latest-nvlink-server-youve-ready
photo source: IBM
While it is very difficult stint to elect dependable certification questions / answers resources with respect to review, reputation and validity because people derive ripoff due to choosing wrong service. Killexams.com get 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 advance to us for the brain dumps and pass their exams happily and easily. They never compromise on their review, reputation and character because killexams review, killexams reputation and killexams client self-confidence is significant to us. Specially they capture 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 contemplate any groundless report posted by their competitors with the designation killexams ripoff report complaint internet, killexams.com ripoff report, killexams.com scam, killexams.com complaint or something devotion this, just hold in mind that there are always snide people damaging reputation of wonderful services due to their benefits. There are thousands of satisfied customers that pass their exams using killexams.com brain dumps, killexams PDF questions, killexams exercise 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
HP2-H05 free pdf download | 000-856 test prep | 190-803 test prep | A01-250 test questions | RH302 exam questions | HP2-H18 real questions | HP2-B104 exercise test | CIA-III study guide | C2040-923 exercise questions | HP2-Z24 sample test | 010-111 study guide | 922-097 cheat sheets | HP0-J39 test prep | 646-230 study guide | E20-891 exercise Test | GB0-360 free pdf | 000-581 free pdf | C2010-595 exercise questions | HP2-E40 VCE | 000-534 braindumps |
Retain these C4040-250 dumps and enlist for the test
killexams.com provide latest and updated exercise Test with Actual Exam Questions and Answers for novel syllabus of IBM C4040-250 Exam. exercise their real Questions and Answers to help your knowledge and pass your exam with lofty Marks. They assure your success in the Test Center, covering every one of the references of exam and construct your knowledge of the C4040-250 exam. Pass past any doubt with their braindumps.
Just suffer their questions bank and sense assured just about the C4040-250 exam. you will pass your test at lofty marks or refund. they maintain got aggregative an information of C4040-250 Dumps from actual exam so you will subsist able to advance back up with an break to induce prepared and pass C4040-250 exam on the necessary enterprise. merely install their test engine and acquire prepared. you will pass the test.
killexams.com Discount Coupons and Promo Codes are as under;
WC2017 : 60% Discount Coupon for every solitary tests on website
PROF17 : 10% Discount Coupon for Orders larger than $69
DEAL17 : 15% Discount Coupon for Orders over $99
SEPSPECIAL : 10% Special Discount Coupon for every solitary Orders
Detail is at http://killexams.com/pass4sure/exam-detail/C4040-250
The best pass to derive achievement in the IBM C4040-250 exam is that you ought to acquire dependable prefatory materials. They guarantee that killexams.com is the most direct pathway toward Implementing IBM Power Systems with POWER8 Sales Skills V1 exam. You will subsist triumphant with full certainty. You can contemplate free questions at killexams.com before you purchase the C4040-250 exam items. Their reenacted tests are the very As the real exam design. The questions and answers made by the ensured experts. They give you the experience of stepping through the real exam. 100% guarantee to pass the C4040-250 actual test.
killexams.com IBM Certification study guides are setup by IT experts. Heaps of understudies maintain been griping that an exorbitant number of questions in such a large number of exercise exams and study aides, and they are simply worn out to suffer the cost of any more. Seeing killexams.com specialists travail out this thorough adaptation while soundless guarantee that every solitary the information is secured after profound research and investigation. Everything is to get comfort for applicants on their street to certification.
We maintain Tested and Approved C4040-250 Exams. killexams.com gives the most exact and latest IT exam materials which nearly contain every solitary information focuses. With the sheperd of their C4040-250 study materials, you don't necessity to squander your chance on perusing greater portion of reference books and simply necessity to scorch through 10-20 hours to ace their C4040-250 real questions and answers. What's more, they give you PDF Version and Software Version exam questions and answers. For Software Version materials, Its offered to give the hopefuls recreate the IBM C4040-250 exam in a real domain.
We give free update. Inside legitimacy period, if C4040-250 brain dumps that you maintain bought updated, they will illuminate you by email to download latest rendition of . On the off chance that you don't pass your IBM Power Systems with POWER8 Sales Skills V1 exam, They will give you full refund. You maintain to transmit the verified duplicate of your C4040-250 exam report card to us. after affirming, they will give you full REFUND.
killexams.com Huge Discount Coupons and Promo Codes are as under;
WC2017: 60% Discount Coupon for every solitary exams on website
PROF17: 10% Discount Coupon for Orders greater than $69
DEAL17: 15% Discount Coupon for Orders greater than $99
DECSPECIAL: 10% Special Discount Coupon for every solitary Orders
if you derive ready for the IBM C4040-250 exam utilizing their testing engine. It is anything but difficult to prevail for every solitary certifications in the first attempt. You don't necessity to manage every solitary dumps or any free deluge/rapidshare every solitary stuff. They tender free demo of every Certification Dumps. You can eye at the interface, question character and ease of utilize of their exercise exams before you elect to purchase.
C4040-250 Practice Test | C4040-250 examcollection | C4040-250 VCE | C4040-250 study guide | C4040-250 practice exam | C4040-250 cram
Killexams LOT-825 cheat sheets | Killexams HP0-234 brain dumps | Killexams 000-632 dumps | Killexams 350-026 test questions | Killexams ACSM-GEI study guide | Killexams 200-401 study guide | Killexams HP0-J38 exercise exam | Killexams 646-590 VCE | Killexams P2080-088 braindumps | Killexams 000-901 exercise questions | Killexams C2140-842 exam prep | Killexams ST0-248 real questions | Killexams ST0-148 real questions | Killexams A2010-574 pdf download | Killexams 1Z0-320 exercise test | Killexams 1Z0-419 exercise questions | Killexams TM12 dump | Killexams 000-973 braindumps | Killexams HP0-A02 braindumps | Killexams 250-365 study guide |
killexams.com huge List of Exam Study Guides
Killexams FN0-202 pdf download | Killexams A2090-422 braindumps | Killexams TB0-114 exercise Test | Killexams HP0-919 exercise test | Killexams 922-111 real questions | Killexams HP0-D04 dump | Killexams 000-652 real questions | Killexams A2010-571 exam prep | Killexams M2150-728 exam questions | Killexams 000-071 test prep | Killexams P2065-016 braindumps | Killexams ST0-100 exam prep | Killexams E05-001 dumps questions | Killexams A2090-312 cheat sheets | Killexams HP3-R95 exercise questions | Killexams COG-615 exercise exam | Killexams ST0-91W brain dumps | Killexams 000-859 test prep | Killexams TU0-001 study guide | Killexams MB2-186 bootcamp |
Power Systems with POWER8 Sales Skills V1
Pass 4 sure C4040-250 dumps | Killexams.com C4040-250 real questions | https://www.textbookw.com/
Total Questions: 62
Test Number: C9010–260
Vendor Name: IBM
Cert Name: IBM CERTIFIED SALES SPECIALIST
Test Name: IBM POWER SYSTEMS WITH POWER8 SALES SKILLS V2
Official Site: http://testsexpert.co.uk
For More Details: http://testsexpert.co.uk/C9010-260.html
A customer system environment is composed of multiple generations of older Power Systems servers and third party servers.
The customer wants to refresh the environment with current technology hardware, and implement private cloud technologies that will besides allow the customer to glide in the direction of hybrid cloud and off-premises cloud solutions.
Which of the following would enable a salesperson to engage to get a comprehensive TCO dispute for POWER8 based servers that is focused on the customer’s specific environment?
A. Eagle Study
B. System Planning Tool
C. Workload Estimator
D. Power Systems Performance Report
Which open source database company offers Postgres Advanced Server on POWERS systems and has Oracle compatibility?
C. MS SQL
A PowerHA solution is being proposed to a customer who wants installation assistance. What resource can subsist proposed to discharge the installation?
A. Strategic Initiatives (formerly Advanced Technical Support)
B. IBM development team
C. Lab Services
D. Local sphere Technical Sales
A customer’s POWER8 system has disk expansion drawers and needs to non-disruptively install a solution to help the disk performance at the lowest cost.
What should subsist proposed to meet the customer’s requirement?
A. IBM FlashSystems
C. SSD drives
Which POWER8 feature is available only on E870 and E880 models?
A. Concurrent firmware updates
B. burning Swap PCIe adapters
C. Dual HMCs
D. Enterprise Pools
Which of the following is an edge of POWER8 architecture over HP-x86 architecture?
A. Database integration
B. More threads per core
C. More cores per socket
D. Faster clock speeds
Total Questions: 62
Test Number: C9010–260
Vendor Name: IBM
Cert Name: IBM CERTIFIED SALES SPECIALIST
Test Name: IBM POWER SYSTEMS WITH POWER8 SALES SKILLS V2
Official Site: http://testsexpert.co.uk
For More Details: http://testsexpert.co.uk/C9010-260.html
Get20% Immediate Discount on full Training Material
Discount Coupon Code: “P922457422”
April 10, 2017 Bob Cozzi
Since the early 1990s, developers maintain been using SQL embedded in RPG as a pass to retrieve just the privilege data for the stint at hand. Certainly it was at least a decade before it became commonplace to contemplate SQL embedded in RPG, but now, 15 years later, it is in fact the go-to fashion for data access, or at least you can contemplate it from here.
I was an early adopter of SQL, but an off-again, on-again user of embedded SQL. Originally, I felt the first format RPG with quasi-free format SQL (and every solitary those plus signs to continue it) felt wrong. Besides, back then hardware favored native file I/O versus SQL. Today, both issues maintain become extinct and no longer are even viable debate points. With free-format RPG and free-format embedded SQL, you derive a wonderful appliance that allows developers to accomplish any stint they are skilled enough to perform.
About six years ago, they were asked by a client to assist recover from a total loss of their system. Everything had been destroyed in a major fire, from the shop floor to the Power5+ server they had been using to flee the business. every solitary backups were besides lost due to a failure in the on-site tape storage system. The fire-proof safe wasn’t shut at the time of the fire, so every solitary backup tapes were besides lost.
Fortunately, they had other locations besides running IBM i on Power, and while the then IT champion person didn’t hold the system current or even in sync, they at least were able to recover some of the core applications to derive them back up and running by the time their facility was rebuilt.
You might now subsist wondering “what does embedded SQL maintain to carry out with recovery?” wonderful question. To derive the client’s reporting systems and other major applications refreshed with current technology so they could hit the ground running, I made the conclusion to utilize the latest IBM i innovations in RPG, SQL, and the Web. I wanted to bring this company into the 21st century. It had been one of those post-System/36 “one person” shops that was running a combination of RPG II and RPG III on IBM i, but compiling it with the CRTBNDRPG command and thus thought they were using RPG IV. Obviously, they were not. Since I won’t touch RPG II anymore, and maintain a inevitable negative reaction when I soundless contemplate RPG III in user’s code, I decided the first step was to carry out a mass conversion to RPG IV using the CVTRPGSRC (Convert RPG Source) command that has been on the system for more than 20 years. It converts RPG II and RPG III to RPG IV syntax. It’s up to you to adjust any subtleties, but for the most part, it just works.
Once I had a wonderful RPG IV base, I could enhance each app as needed using embedded SQL to select the privilege data for the situation. I avoided their OPNQRYF commands whenever possible, opting to utilize embedded SQL instead.
But then I hit a mountain. This client has a long history, and during that history it accrued a lot of reports and inquiries. Most were what they once called “80-80 listings,” but some had a slight customization, sorting, and selecting. In fact, they establish the stale FMTDATA (Sort) being used every solitary over the place. Now, I haven’t used SORT since the 1970s, having moved to System/38 in 1981 and never looked back. There was no pass I was going to using SORT or glide the SORT specs to OPNQRYF. Since they were looking at hundreds of reports with SORT, they needed a better option.
Back in their offices, they had just started working on an SQL processing tool. They weren’t sure what it would become, but wanted to create a novel version of their very popular SQL Lite for AS/400 product they had written back in the early 1990s. This novel product was being written in C and C++ for performance and accessibility to low-level interfaces on the IBM i system. They wanted something novel and something fresh and that could travail with today’s constantly changing technology interfaces.
The results of that research and development produced SQL iQuery, and Version 1 became available about six months after they became alert of their client’s SORT catalog. It meant they could simple flee an SQL SELECT statement to derive a report that contained the fields in the sequence the client needed and with only the records they wanted. They moved the technology from this:
SORT Specs Source Member
Custom RPG Report program
RUNiQRY 'SELECT a,b,c, order by c' OUTPUT(*PRINT)
We reduced the IT assets that needed to subsist produced and maintained in order to generate a simple report, to a one-line CL command, or more accurately, a solitary SQL statement.
We besides did one more thing: They installed IBM Transform Services 5770-TS1 (*BASE and option 1) to allow users to automatically generate PDF files instead of just legacy printer SPOOLED files.
The IT developer time needed to bear reports (and there were literally hundreds of them) went from using the CL program, SORT/FMTDTA, and custom RPG fashion that took about a day per each report with cloning, to about 45 minutes with SQL iQuery. In one day the IT developer could create several reports for the client – six to 12 reports on average – and provide a consistent result.
Challenges Of Success
One of the challenges they faced in the wake of this successful development cycle was how to provide the future IT developer with the faculty to modify the reports (as needs change) and how to manage those CL statements.
In their legacy SQL Lite product, they had implemented a fashion to store SQL statements within a source file member, and flee those statements. It was an light conclusion to interject that feature into SQL iQuery, and using their novel C / C++ engine, it turned out to subsist light to implement as well.
Basically, the RUNiQRY command would flee SQL statements via its SQL parameter. By allowing source file members to subsist processed, they needed to add novel parameters and change the default for the existing SQL parameter.
SQL novel default is SQL(*SRCFILE)
SRCMBR – novel parameter to accept the designation of the source member contain SQL statements
SRCFILE – novel parameter to accept the SQL source file designation that holds the member name.
With this simple change, they enabled the RUNiQRY command so that it could flee SQL statements privilege out of a source file member. Yes, I said “statements” plural. Any number of SQL statements may subsist flee from within a source member. Similar to, but not the very as, the RUNSQLSTM (Run SQL Statements) CL command included on the system. That command, however, does not champion the utilize of the SQL SELECT statement, but most other SQL statements such as CREATE, UPDATE, INSERT, DROP may subsist specified.
SQL iQuery initially supported running any SQL statements as a batch process. It basically ran each statement, one after the other.
Having this capability provided utilize with the appliance they needed to catalog the growing number of SQL SELECT statements being used to create reports. They would create a member in QSQLSRC, give it a reasonable name, and assign a text description to it that described the report being produced. For example, the Daily Sales Register might subsist named DAILYSALE and its text description would maintain been “Daily Sales Register Report.”
To flee this report, the user simply enters:
RUNiQRY SRCMBR(DAILYSALE) OUTPUT(*PRINT)
It is much easier to set something devotion this on a Menu rather than embed the entire SQL SELECT statement on the command itself. Plus, you derive the added edge of being able to tweak the SELECT statement external to the RUNiQRY command itself. Any developer will inform you, this is better.
Better Is The Enemy Of Good
During my career, I had the delight and privilege of working with some of the best people that IBM Rochester and Toronto had to offer. During a short retirement period in the late 1990s, I did a few projects with NASA’s Jet Propulsion Lab in Pasadena, California. The one I most enjoyed was doing sphere test travail in Italy on the Mars Rover’s Alpha Gamma X-Ray Spectrometer, which was subsequently used on those first Mars rovers during that very period. As a lifelong “space freak,” it may maintain been the highlight of my career.
During that period, one of the managers told me something that stuck with me. Perhaps today it is a common phrase that people use, but back then it was novel to me. He said, “Better is the Enemy of Good.” You can always get things better, but to finish something, you maintain get it wonderful enough.
We applied this philosophy to the pass they designed and implemented SQL iQuery. First they made it wonderful enough to flee any SQL statement from within CL or the command line using the RUNiQRY command. Next, they improved it by adding champion to flee SQL out of source members.
In their third angle (Version 3, naturally) they added output champion components. That is, they added the faculty to direct the output of the SQL SELECT statement to a growing number of output media. Originally, they included the customary suspects: Display, Print, Outfile, CSV, PDF, and TEXT. But they maintain since added EXCEL, XML, HTML, and JSON among others.
Something Magical Happened
While creating the routine to process source members, they realized they could implement something wonderful: a scripting language. That is they establish they could create a real SQL programming language that could subsist both subtle and out of the programmer’s way, and powerful enough to wield anything needed, even web applications.
While there are always challenges with writing a programming language from standards to syntax, they elect to simply implement an SQL and RPG style syntax that existing RPG developers would understand “in 10 minutes” while SQL DBA/DBE’s would subsist able to easily comprehend as well.
When they shipped SQL iQuery Version 4 on March 1, the upgrade included the novel SilQ (pronounced Silk) programming language. It is besides called “iQuery Script,” but don’t worry about it being another language to learn. You already know it if you know RPG or SQL or both. In fact, you can avoid it entirely since it is merely an extension to running SQL from source members, and it doesn’t matter if you don’t utilize it. But it is powerful and allows IT developers to derive things done now without writing a customized RPG program just to process an SQL statement. And when you necessity to receive and transmit data between an IBM i system and the web, or your own web pages, it is ready and works well with that.
You can check out their client’s website here if you’re interested.
The edge they maintain now with SQL iQuery and their customer’s cataclysm recovery is that every solitary those SQL reports they created a few years back, they can now deliver to users as outdo or PDF files via email. No longer carry out you necessity to add on this conduit or that transfer app to transfer something. Just email it. In some cases they besides simply redirect the reports to the web. They maintain the capability to utilize SQL iQuery and thrust the results out as HTML (such as a scrolling table) or a set of JSON data nodes; whatever works for you.
Today, SQL iQuery is helping their cataclysm recovery client utilize their Power7+ running IBM i V7R2 and it really is taking edge of some of the coolest technology in the world. In fact, their client is so satisfied with the kindly of applications they can derive today versus the legacy SORTS and RPG II code, they’ve decided to upgrade their entire set of 7 IBM Power 7 servers to Power8 running V7R3 over the next 10 months. SQL iQuery helped get that happen.
No result found, try novel keyword!We are dealing with some challenges in their hardware commerce model specific to power, storage and X86 ... successful strategy they executed their System z platform will expand their Linux relevancy even fur...