For more information, check out http://www-03.ibm.com/systems/z/.
Here’s my attempt to explain DB2 to my grandma!
With the world heading towards yottabyte of data, I assume that we all understand any raw, unorganized facts that needs further processing is data. We obtain data from numerous sources such as websites, retail stores and social media (this is a big one) to name a few. There is so much of user generated content off late that companies are struggling to:
- Manage the amount of data
- Organize the data to gain intelligence
- Make use of the information to gain business value.
How do we manage & organize data?
With all the data stored in databases, we need a Database Management System in place to create, maintain and control the databases on a regular basis. DB2 is a Database Management System and more specifically a Relational Database Management System. (RDBMS)
For those of you who are new to databases, here’s a list of top 5 reasons to use a Database Management System (DBMS):
- It manages creating, accessing & managing data efficiently
- It provides a greater level of security by granting different levels of security access based on the user
- It allows multiple programs to access the data simultaneously while still keeping the data consistent (Data Integrity)
- It permits the hiding of confidential data in separate views to prevent unauthorized access
- It comes with a number of tools to perform activities like performance tuning, backup & recovery of data, implement tighter security controls and so on
Fun facts about DB2
- Top 59 banks in the world use DB2
- 23 out of top 25 retailers use DB2
- 9 out of top 10 insurance providers use DB2
- IBM has over 1600 core developers and researchers for DB2 across the world
- DB2 runs on many operating systems, such as z/OS, IBM i, Linux, UNIX, Windows, and Solaris
You might be wondering why some of these large organizations use DB2 for z/OS to run their business. The answer is simple. These companies need a reliable database server which provides superior availability & scalability. These companies process huge (and I mean HUGE) volumes of information that would require millions of concurrent updates on a daily basis. DB2 with the power & functionalities of z/OS has undoubtedly met/exceeded those needs.
11 Things you need to know about DB2
- DB2 Data Sharing – DB2 data sharing runs on an IBM mainframe cluster configuration called a parallel sysplex and enables applications that run on more than one DB2 for z/OS subsystem to read from and write to the same set of data concurrently. Data Sharing gives businesses the ability to add new DB2 subsystems into a data sharing group, or cluster, as the need arises and without disruption which makes it the most highly available, highly scalable data-serving platform in the market.
- IDAA – DB2 for z/OS offers IBM DB2 Analytics Accelerator (IDAA) which helps in excellent query performance solution for Data Warehousing and Analytics (Remember we talked about analyzing data to make sense out of it).
- Application Portability – You can develop applications with SQL that are common across DB2 data servers and port them from one DB2 operating system to another with minimal modification. (Porting means moving an application from one operating system to another.)
- Temporal Data – Many IT systems need to keep some form of historical information for their data and it is now possible with the latest version of DB2 which supports temporal data (Business time & System Time). With the use of a history table DB2 can now provide a value of data at a specific time in history.
- Built-in Compression – DB2 has inbuilt compression technology which converts your data that is used frequently into shorter strings for efficient storage & retrieval. The mapping information of short strings with the actual data is stored in a compression dictionary which is used for decompressing the data.
- Built-in Encryption – DB2 provides built-in data encryption and decryption functions that you can use to encrypt sensitive data, such as credit card numbers and medical record numbers. You can encrypt data at the column or value level.
- Clone Tables – you can clone tables in DB2 with the exact replica of your base table and you can switch between the clones easily. This is very critical for businesses who cannot tolerate any downtime since clone tables ensure superior availability.
- Large Objects – DB2 has a unique capability of storing Large Objects (LOB) which would mean storing a picture or a text document as a single object in the database.
- Storing XML – You can also store XML on your DB2 Database. It has in-built functions to convert the stored XML and return it as a DB2 table to your application.
- DB2 Express C is a community Edition which is a no charge edition from IBM
- DB2 Tools – DB2 comes with a set of tools that are broadly classified in the following six categories. You will be hearing more about some of the DB2 Tools in our future posts.
- Database Administration
- Utility Management
- Performance Management
- Recovery Management
- Replication Management
- Application Management
Phew!! That’s enough DB2 for today. I enjoyed writing about DB2 on Z as much as you did reading. So the feeling is mutual here. One last thought! We at Millennial Mainframers are fairly new to the Z world and we are learning Z just as you are. You call the shots if you would like to hear about something in specific and we would be more than happy to step up to the plate. Come back and see us for more cool information on how Z rules the world always & forever! ~ Riya ~
Sri (Riya) Shanmugam
MBA. Entrepreneurship, McCoy School of Business, Texas
B.Tech. I.T., Amrita School of Engineering, India
In an earlier post this summer, Anthony Critelli and Alex Belcher touched on their experiences with mainframe education at RIT, and more importantly, how as young technologists they’ve come to understand the mainframe and its continuing importance. In another previous article, we’ve referenced the IBM System z Academic Initiative and popular mainframe education offerings from partner schools like Marist College, which each work to make the mainframe accessible and attractive to a new generation. However, as a proud graduate of the University of Arkansas and native Arkansan, I think I’d be amiss if I didn’t talk a little about the role of mainframe educationat the University of Arkansas and what we do here in Fayetteville to promote the body of skills and technological understanding that today’s students need to be competitive in mainframe roles. Just as our football program (currently ranked #10 in the most recent poll) gets students yelling “Woo Pig Sooie!” with our skills on the field, it’s my opinion that the school is likewise a leader in the classroom for training students in the skills that modern businesses need.
At the University of Arkansas’ Sam M. Walton College of Business, the mainframe is a key component of not just the Information Systems program itself, but the greater college’s technology education offerings as well. The IBM-donated z10 system operated by the Enterprise Systems group at the college serves up a number of key business applications and datasets that benefit student learning interests across disciplines.
How does that work, exactly? In my opinion, this is made possible due to three key factors: innovative educators, the modern mainframe’s incredible workload flexibility, and the generous support of Fortune 500 companies in the University’s backyard: companies which understand and advocate the vital importance of all students gaining a practical technology background to be competitive in the 21st century.
Arkansas-grown members of the Fortune 500, such as Walmart Stores, Tyson Foods, and Dillard’s Department Stores have each donated obfuscated real-world datasets from their own daily operations and data warehouses to the college. These real-world warts and all’ datasets not only enable IT students to learn core technology topics and problem solving on data as it appears in the wild, but access to these datasets can also empower business students to study the technology component of their fields, too.
For example, students in marketing and management disciplines can learn marketing techniques
by using business intelligence tools on obfuscated department store transaction data from Dillard’s, served up by DB2 under z/OS. For another key example, many students in accounting, finance and logistics can learn a top-down view of their roles and business processes in general via competitive simulations and reporting in the world’s leading enterprise resource planning software, SAP.The SAP courses (which the college hosts on the mainframe in instances of SUSE Linux running under z/VM) have remained popular across all disciplines since their inception nearly eight years ago, as training in enterprise resource planning suites offer both valuable application skills and exposure to some of the practical aspects of executing modern business processes.
Again, at Arkansas, the mainframe helps empower all of these capabilities to drive serious educational benefits for students, in addition to the usual IT topics like programming & design. Did I mention that these educational opportunities have been provided to programs internationally which partner with the college—not just those local to the University of Arkansas? This is a bit of a testament to the scale, security, and reliability that the modern mainframe can provide.In this case, the mainframe is a significant driving component in the education of hundreds of students each year across a variety of the applications that truly run businesses today, and it does it all while sharing those learning opportunities to a wider audience at other schools in other locations. Today’s modern mainframe is immensely capable and powers many of the world’s best organizations, and the University of Arkansas business technology curriculum keeps that in mind.
This arrangement really demonstrates that the mainframe is a key platform in an ideal mix to give students the technology tools they need to be competitive across business disciplines today: it helps drive teaching in business process understanding and the technology aspects of traditional business disciplines. And for IT-centric students, the mainframe can help deliver education for more practical skills in more areas than you might expect: business analytics, ERP, Linux, web development, modern and legacy applications, and more!
Students who want an emphasis in enterprise Information Systems can progress to write programs in languages such as ABAP, COBOL, Java and .NET to integrate their mainframe-hosted projects with a variety of other enterprise technologies, such as Teradata-hosted warehouses or Microsoft SQL Server-hosted databases.
Two Enterprise Systems courses in particular are offered at Arkansas to specifically teach the mainframe in depth. With a bit of a call-back to Akram Wahab’s recent post on IBM’s Rational software offerings for the mainframe, these courses both use a mix of the very nice Rational Developer for z graphical tools and good ‘ol green screen to provide an easier route to understanding what the mainframe can do. With access to the Rational toolset, students new to the mainframe at Arkansas get a great balance of accessibility and familiarity through development tools they already know, while enabling them to gradually build comfort in getting down and dirty with a more traditional terminal for building deeper skills. Personally, I really liked the experience of having both means to develop my applications when I was in the program’s two mainframe courses.
The first Enterprise Systems course, an introductory one, focuses on some of the essential basics, like getting comfortable with TSO, ISPF & JCL in z/OS, and building a website with an associated web application in virtualized SUSE Linux.
Having been a graduate of both the Information Systems undergraduate and graduate programs, it’s my opinion that the University of Arkansas is an excellent champion of the ideals developed and supported by the IBM Academic Initiative for System z. For students, I’d say it’s a true win-win to say “Woo pig sooie!” and make the choice to learn real business computing as a Razorback at Arkansas!
To learn a little bit more about how the University of Arkansas uses the mainframe to educate students, check out the University’s Enterprise Systems site and have a listen to this great IBM developerWorks interview with Enterprise Systems head Dr. David Douglas and Dr. Paul Cronan, MD Matthews endowed chair and director of the school’s MIS program.