Ibm Db2

In: Computers and Technology

Submitted By curky
Words 728
Pages 3
IBM DB2 Express – C
Introduction
The intent of this paper is to describe the installation process of the Microsoft Windows version of the IBM DB2 Express-C database. This is a light-weight version of the more fully featured configuration of IBM’s best-selling DB2 database and includes core DB2 capabilities, free administration, development, autonomic, XML support and access to the online communities and forums. The version downloaded and running is configured for dual core processors and supports up to 2GB of system memory. Insights gained from working with the database after installed are also shared.
Installation Process for DB2 Express-C
Downloading and installing DB2 Express-C is easily accomplished over an Internet connection. The version installed is 389MB and took approximately 10 minutes to download over a cable modem running at fractional T1 speeds. Installation screens from the steps completed to get DB2 Express-C up and running are shown in the Appendix of this document.
After installing the Control Center was invoked at the command line using the command db2cc which is specifically defined in the chapter assigned on DB2 Express-C. Using the command db2sampl -xml –sql to create the sample data worked, and there is the secondary option of using graphical interface commands to accomplish the same. The use of the DB2 Command Line tools show how quickly a multidimensional table can be viewed, edited and batch programming tasks completed using shell scripts in this interface. IBM has done an excellent job of making this free version of DB2 as fully featured and full of navigational and command options as possible.
What is most significant amount the design of DB2 relative to other databases worked with is the multiple approaches to getting commands invoked the flexibility on creating fully automated responses to queries, or the option of…...

Similar Documents

Ibm Case

...Ray Angel Mojica GBA 513 Professor Amrouche October 29, 2011 IBM Case Study Description: International Business Machines or IBM is an American multinational technology and consulting corporation. IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in various areas ranging from mainframe computers to nanotechnology. As of September 2011, IBM is the second largest publicly traded technology company in the world. IBM famous invented are the automated teller machine ATM, the floppy disk, the hard disk drive, the magnetic striped card ,and the SABRE airline reservation system. In 2011, Fortune ranked IBM the 18th largest firm in the US as well as the 7th most profitable. Today and recently IBM has created several new venues, they have been able to update their business analytics systems making themselves more profitable towards other businesses. IBM current competitors are considered to be Accenture, Hewlett Packard and Microsoft. Their primary competitors are primarily in the information technology service industry. IBM’s slogan is to THINK, stating that let them provide the necessary tools and/or services for you the consumer to think and reach the important decisions. SWOT Strength • IBM has very strong research and development departments • Created and establish unique products • Because of their many success they established strong customer loyalty Weakness • There can......

Words: 1075 - Pages: 5

Ibm Leadership

...IBM Leadership University of Phoenix COM/530 COMMUNICATIONS FOR ACCOUNTANTS August 27, 2012 Mark Durand   IBM’s operations consist of two major components, technological research and development, and consulting services. “Its core values are dedication to every client’s success, innovation that matters, for our company and for the world, and trust and personal responsibility in all relationships.” (Palamisano, 2003) Taking both major operations into account, the leadership style employed can greatly influence the alignment of these values with its practices. In every organization, the utilization of the concepts outlined in transformational leadership, where leaders, “inspire followers to transcend their self-interest for the good of the organization,” and the Socialized Charismatic Leadership Theory, “leadership that conveys other centered (not self-centered) values by leaders who model ethical conduct,” (Robbins and Judge, 2011) would provide significant benefits to the organization. These theories however require the sole conviction of the individual. They are not necessarily an actionable theory of leadership in that every member of an organization should at all times be demonstrating the characteristics stated above. Of the actionable leadership theories, much good can come from employing the Path Goal Theory which says that “it’s the leader’s job to provide followers with the information,......

Words: 1299 - Pages: 6

Journey of Ibm

...The Journey of (IBM) International Business Machines Executive summary: The current Proposal intended to describe what IBM has faced in its journey and how it overcame those problems, which it was unprepared in the first place. To discuss the Success Story of IBM (International Business Machines) and journey through some easy and some tough winters. The focus will be on the problems. Introduction: IBM is one of the world’s largest rapid growths IT Company in terms of revenue, which listed in fortune 100 IT companies.IBM has produced different products, which related to software and hardware and produced custom designed microchips. By producing low cost products, IBM has rapid growth with long-term success, which attracted the investors and competitors. The head quarters were located in New York. In 2012, it has ranked 2 largest US firm for having highest numbers of employees nearly 433,362 by fortune. They have developed a wide range of software development tools, which helps to manage business process etc. IBM has first started its invention in 1914 called Hollerith, which was a part of computing -tabulating- recording company later the company known as IBM. (Rouse, 2006) Background: ...

Words: 1222 - Pages: 5

Ibm Casestudy

...meet and create demands International Business Machines (IBM) has proven to be able to withstand the ever changing technical world. Challenges come and go, in this case study we discuss a three-prong road that IBM faced. Should they continue to be a tech services company? Or should they explore the collaborative business model, running a risk to become exploited? Is it an option to keep the acquisition spree going for growth rather than organically grow by in-house or collaborative research and development? Facts of the case Structure, management and strategic directions IBM is a multinational corporation that started its activities in 1911. Its origins however, can be traced to 1890, during the height of the Industrial Revolution. It was first known as the Computing-Recording Company, and then in 1924, it took the name of International Business Machines. Nowadays, this multinational company is known as the ¡§Big Blue¡¨ It was first known as the Computing-Recording Company, and then in 1924, it took the name of International Business Machines. Nowadays, this multinational company is known as the ¡§Big Blue¡¨ IBM main activity is to find solutions to its wide range of clients using advanced information technology. Its clients are individual users, specialized businesses, and institutions such as government, science, defense, and spatial and educational organizations. To meet and respond to its customers needs, IBM creates, develops and manufactures many of the world’s......

Words: 2802 - Pages: 12

Db2 Concepts

...DB2 & SQL Concepts 1.2.1 What is SQL? Structured Query Language (SQL) is a standardized language for defining and manipulating data in a relational database. In accordance with the relational model of data, the database is perceived as a set of tables, relationships are represented by values in tables, and data is retrieved by specifying a result table that can be derived from one or more tables. DB2 transforms the specification of a result table into a sequence of internal operations that optimize data retrieval. This transformation occurs when the SQL statement is prepared. This transformation is also known as binding. 1.2.2 Static SQL The source form of a static SQL statement is embedded within an application program written in a host language such as COBOL. The statement is prepared before the program is executed and the operational form of the statement persists beyond the execution of the program. A source program containing static SQL statements must be processed by an SQL precompiler before it is compiled. The precompiler checks the syntax of the SQL statements, turns them into host language comments, and generates host language statements to invoke DB2. 1.2.3 Dynamic SQL A dynamic SQL statement is prepared during the execution of an SQL application, and the operational form of the statement is not persistent. The source form of the statement is a character......

Words: 30246 - Pages: 121

Ibm Analysis

...Case Analysis: The Evolving Strategy at IBM IBM’s  CEO,  Sam  Palmisano,  likes  to  talk  about  the  evolution  of  global  strategy  at  one  of  the  world’s   largest computer enterprises. According to Palmisano, when IBM first started to expand internationally, it  did  so  in  the  classic  “international”  pattern  of  many  enterprises,  undertaking  most  of  its  activities  at   home, and selling its products internationally through overseas offices. By the time Palmisano joined IBM in 1972, however, it had already moved away from this model, and was by then a classic “multinational”  enterprise,  with  mini  IBM’s  in  major  national  markets  around  the  world.  This  structure   made sense for IBM in the 1970s, given that many markets were still segmented from each other by high barriers to cross-border trade and national differences in business practices often required considerable localization. In recent decades, however, IBM has been moving away from this model and toward one that Palmisano characterizes  as  a  “globally  integrated  enterprise.”  In  his  words:    “We  are  locating  work  and  operations   anywhere in the world based on economics, expertise, and the right business environment. We are integrating those operations horizontally and globally. We used to have separate supply chains in different markets. Now we have one supply chain, a global one. Our R&D has been global for many years, with research and software development carried out......

Words: 944 - Pages: 4

Rise of Ibm

...THE RISE OF IBM 1900-1970 To meet the needs of measuring population the US Census Bureau sponsored a contest to find the most efficient means of tabulating census data. The contest was won by German immigrant and Census Bureau statistician, Herman Hollerith. Hollerith formed the Punch Card Tabulating Machine Co. in 1896. In 1911 Hollerith’s company merged with Computing Scale Co. of America and International Time Recording Co. to form Computing-Tabulating-Recording Co. During the period between 1910 and 1960, it developed products from punch-card tabulating machines to room-sized calculators to mainframe computing systems for large enterprises and changed the nature of accounting, calculation and basic back-office business processes. In the 1970s and 80s, IBM product lines expanded from its traditional mainframes to minicomputer and personal computers and applications moved from backend operations to departmental operation. In 1981, the company introduced the IBM Personal Computer or PC, allowing the use of computers in schools, homes and businesses. Components for the computer were sourced from outside the company. It developed products from punch-card tabulating machines to room sized calculators and main frame computers. The company manufactured and sold products ranging from commercial scales and industrial time recorder to meat and cheese slicers, tabulators and punch cards. In the beginning the company operated in New York City only. Within a short period...

Words: 2645 - Pages: 11

Ibm Essay

...INTERNATIONAL BUSINESS MACHINES (IBM) International Business Machines (IBM) is a leadingcompany in global technological products and services. It specializes in services, software, systems, fundamental research and related financing. This mix of businesses and capabilities together provide integrated solutions to the company’s clients (ibm.com). IBM Business Strategy In keeping with the business strategy perspective, an organization’s competitive advantage lies in its ability to produce or get resources and competences, "take a strategic position in a market and implement a competitive strategy that takes into consideration the opportunities and threats in the external environment” (Porter, 1980). Applying a business strategy that is coherent increases competitive advantage by influencing organizational outcomes and creates superior performance. IBM has successfully incorporated this perspective. The 2014 Annual report states that IBM’s strategy continues “to be one of innovation and a constant drive to deliver higher value for our clients”. This global strategy is positioned on three pillars: data, cloud, and engagement. Pillar 1 - the company will use data to transform industry and professions. It reads: “We are making markets by transforming industries and professions with data”. According to IBM data is increasing capability, rapidity and diversity in an exponential manner and is emerging to be a novel global natural resource. It has embraced data as......

Words: 741 - Pages: 3

Practice Questions for Ibm Db2 10 Certification

...correct? A. NUMTCB parameter must be set to 1 for Java stored procedures. B. NUMTCB parameter must be set to 1 for REXX stored procedures. C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures. D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2 utilities. Answer: B 2.If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite columns, what is indicated.? A. The next sort step will perform two sorts. B. There are multiple sorts in the plan step. C. One sort in the plan step will accomplish two tasks. D. Two sorts are performed on the new table of a star join. Answer: C 3.What IBM provided stored procedure will access DB2 real time statistics tables? A. DSNAEXP B. DSNAIMS C. DSNACCOX D. DSNLEUSR Answer: C 4.The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE? A. Filter factor information. B. Stage 1 and stage 2 information. C. Number of columns used in an index. D. Number of times an SQL statement is executed. Answer: D 5.Which two of the following DB2 performance features will ignore clustering in favor of faster insert performance? (Choose two.) A. Append B. Inline LOBs C. Member cluster D. Volatile table E. Include columns Answer: A,C 6.When is a merge scan join a well performing access path? A. When the number of qualifying......

Words: 8187 - Pages: 33

Ibm Case

...College of Business Administration Florida International University December 6, 2000 IBM Personal Systems Group: Implementing ERP1 There was an eerie quiet in the IBM Personal Systems Group (PSG) plant in Research Triangle Park (RTP), North Carolina. Hundreds of forklifts sat idle in the factory. The shipping docks, usually filled with incoming supplies, were empty. The 2,500 employees who normally worked in the plant each day were gone. The plant, which normally produced 20,000 PCs a week, was shut down. The date was April 6, 1999. On this date, the plant was to ‘go live’ with an implementation of the SAP R/3 system known as Production Release 2 (PR2). As John Corcoran, Director, SAP Production Project, waited for the first transaction to be processed by PR2 on April 6, he reflected on how PSG had come to this milestone event. Several years before, PSG had recognized the need for an integrated system that would allow better management of the supply chain across all of its plants and quicker response to changes in the business environment. Most recently, the success of Dell made clear to PSG the value of creating a CTO (Configure-to-Order) business model in addition to its standard MTM (Machine Type Model) business model. Having a set of autonomous plants, each with a multitude of independent legacy systems that supported different business processes was a significant obstacle to implementing this or any other new business model. On January 1, 1998, the first version......

Words: 7767 - Pages: 32

Ibm Corporation

...IBM Corporation In the seven years (since 1994), that Lou Gerstner reigned over IBM, the company’s earnings per share increased an average of 27% per year. This remarkable increase in earnings did not go unnoticed by the securities markets. Indeed, the company’s market value grew from less than $30 billion to over $200 billion during the period. Use the following financial statement data to: 1. Decompose IBM’s ROE (by quarter) and discuss the factors (and trends) that contribute to Big Blue’s profitability 2. Evaluate IBM’s Revenue growth, Receivables, and Gross margins and over the period. Be sure to control for seasonality (e.g., compute the same quarter to same quarter change in these items). 3. Evaluate IBM’s Earnings per Share (basic), and Identify the factors most responsible for the increase in IBM’s earnings Write your answers in Standard English. Be specific in your references, provide details of your computations, and be thorough in your explanations – I cannot read your mind. EXHIBIT 1 IBM Selected Earnings Per Share Data For the Quarters Ended: Earnings Per Share (from continuing operations) Analyst Expected Earnings Per Share Difference % Surprise Jun-00 1.06 1.00 0.06 6.00% Mar-00 0.83 0.77 0.06 7.79% Dec-99 1.12 1.06 0.06 5.66% Sep-99 0.90 0.90 0.00% Jun-99 0.91 0.88 0.03 3.41% All of the financial data in the tables that follow (except “per share figures”), are in millions. EXHIBIT......

Words: 1882 - Pages: 8

Ibm Erp Case Questions

...Assessment Activity 1. In your opinion, what decision option does IBM have in the case situation? • The main decision option on the case was to create a new business model that integrate all plants together and manage the same information. This will allow better management of the supply chain across all of its plants and quicker response in changes in the business environment. 2. What criteria are important to making this decision? • The first criteria that they need to consider on getting stated with the SAP was to define the cooperate standards for data, technical platforms and SAP implementation and tools. Also in what process areas would be implemented. • Second, they need it to create a team to implement PR2, they needed to consider the complexity due to the size of the plant and divided the implementation within multiple phases. 3. What implications and consequences does each of the options present? • The go live approach for the RTP production ramp down had some unresolved issues like; problems with the data DB2 data based, R/3 still being tested and end to end system testing was not completed. • The team had a very sort period of time to completed the implementation, under the time pressure exist the possibility of something going wrong, no meeting the deadlines and as a consequences a disruption of the project. • On of the implication was that in order for the PR2 to ramp up they had......

Words: 535 - Pages: 3

Turnaround at Ibm

...Lou Gerstner was entrusted by IBM to take a faltering business and turn it into the multi-billion dollar corporation that it is today. In the early 1990’s, IBM sales were declining at a rate, which would undoubtedly force the company into bankruptcy. This trend was largely caused by IBM’s lack of diversification and primary focus on building and selling computer systems with an emphasis on mainframes. As new corporations began to flood the market with cheaper versions of IBM’s computers, the Board of Trustees recognized the need to alter their strategic plan to ensure IBM would remain in the forefront of the computer industry (Allen, Attner, & Plunkett, 2013, p. 124-125). Gerstner knew the value of service and returning customers, and with these ideals he created a new branch of IBM which would focus on specific problems for each of their customers. The new IBM would help customers with everyday tasks such as shipping, purchasing, networking, and marketing. Gerstner realized that IBM’s true potential was deeply imbedded in its strengths, which were research and integrated computers. Within about 1 year of Gerstner taking charge, IBM developed software which would allow computer systems to “talk” or network, and this change would cement IBM’s fate and allow the computer giant to remain at the top of the industry (Allen, Attner, & Plunkett, 2013, p. 124-125). Questions 1. Work with another student to answer the following questions. What strategy changes......

Words: 302 - Pages: 2

Ibm Websphere

...IBM Websphere The following link explains websphere application server communication process in layman’s term, a very good read – http://www.coderanch.com/t/446735/Websphere/IBM-HttpServer-websphere-Appserver [pic] The WebSphere Application Server consists of the following components: Administrative Server - responsible for maintaining the configuration of a WebSphere domain, providing security services, Work Load Management, and monitoring the run-time state. The Adminserver process runs in its own JVM on each node in a WebSphere domain (“cluster”). Application Server - An Application Server in WebSphere is the process that is used to run your servlet and/or EJB-based applications, providing both the servlet run-time components (Servlet Engine, Web applications) and EJB run-time (EJB container). Like the Adminserver, each WebSphere Application Server runs in it’s own JVM. Administrative Repository - stores the configuration for all WebSphere Application Server components inside a WebSphere domain. Each Adminserver communicates changes in configuration and run-time state to all other Adminservers through the Administrative Repository. Administrative Console - Administrative Console provides an easy to use, graphical “window” to a WebSphere domain (“cluster”). The Administrative Console connects to one of the Adminservers running in a cluster and can be used change to the configuration or run-time state on any machine in a domain. HTTP Server and......

Words: 3936 - Pages: 16

Article on Ibm

...IBM, i-flex bag Canara core banking project Article by Business standard * Computer maker and IT services firm IBM has won the bid to implement a core banking solution for Canara Bank. In a deal, which market sources estimate at some Rs 250 crore, IBM will implement Flexcube, supplied by i-flex solutions in some 1,000 branches of the bank. * The hardware part alone will cost Rs 100 crore, M B N Rao, Canara Bank's chairman and managing director told reporters here on Friday. The IBM - i-flex combination beat competition from multinational rival Hewlett Packard and a desi system integrator, Wipro, both of whom had offered to implement Finacle, supplied by Infosys Technologies, a senior bank official said. * IBM's services business, IBM Global Services, will do the system integration work, said Shankar Annaswamy, managing director of IBM's Indian subsidiary, IBM India Limited. * IBM will also supply all the hardware required for the project. It will build a data centre at Bangalore, where the bank is headquartered, and a disaster recovery centre at Mangalore, the official said. * It will take some eight months for i-flex to customiseFlexcube to Canara Bank's requirements. By that time one branch, at the headquarters will go live with the core banking solutions. In the next five months, 1,052 branches will be hooked up. * These branches have been chosen to account for the bulk of the bank's business. They will cover "about 83-84 per cent of our business",...

Words: 356 - Pages: 2