Learn DB2


  • WatchGetting Started with DB2
  • WatchTablespace & bufferpool administration in db2 | db2 dba administration
  • WatchLUW DB2 Basic Commands for beginners.avi
  • WatchDB2 Instance : Create, Start, Add to Control Center, Stop, Drop
  • Watchdb2 backup
  • WatchCompiling & Running ODBC programs
  • WatchDB2 is Easy to Learn.FLV
  • WatchChapter 10(1) - DB2 backup and recovery overview
  • WatchStored Procedure Part1
  • WatchStored Procedure Part2
  • WatchDB2 Tutorial Introduction
  • WatchDeleted video
  • WatchDeleted video
  • WatchIBM DB2 for i and SQL Overview - IBM Training
  • WatchIBM DB2 for i SQL Performance Workshop - IBM Training
  • WatchNative SQL Stored Procedures on DB2 for z/OS
  • WatchCross Platform SQL Essentials by Themis Education
  • WatchSQL indexing in 9 minutes and a half
  • WatchDB2 9.7: CLP Plus
  • WatchDB2 Tips n Tricks Part 30 - How to Find Which DB2 Thread is consuming High CPU
  • WatchUnderstanding SQL JOINS, lesson 1ee65
  • WatchSQL Outer Joins and Cross Joins Tutorial

This tutorial provides you the fundamental understanding of principles of database, database installation and management. on the give up of the educational you need to be ready with properly expertise of database management principles.
Audience
this academic is designed for the readers pursuing schooling in database control area and all enthusiastic readers.
Prerequisites
this tutorial is designed and developed for absolute novices. even though, consciousness about software program systems, working structures and laptop basics could be beneficial.
this chapter describes records of db2, its versions, versions and their respective capabilities.
evaluation
db2 is a database product from ibm. it’s miles a relational database control gadget (rdbms). db2 is designed to store, analyze and retrieve the facts correctly. db2 product is extended with the guide of item-orientated capabilities and non-relational structures with xml.
history
to start with, ibm had advanced db2 product for their unique platform. considering 12 months 1990, it determined to increase a usual database (udb) db2 server, that can run on any authoritative operating systems along with linux, unix, and home windows.
versions
for ibm db2, the udb present day version is 10.five with the functions of blu acceleration and its code name as ‘kepler’. all the variations of db2 until nowadays are indexed under:
server installation
you can download the db2 server trial model or buy the product license from www.ibm.com. there are separate db2 servers to be had for downloading, depending upon the size of running system, on which it’s miles meant to execute. for instance, in case you want to down load a db2 server for 32bit linux or unix operating machine, you then need to download a 32 bit db2 server. the equal applies for 64bit db2 server.
hardware requirements
processor : minimal middle 2duo
ram : 1gb minimal
difficult disk : 30gb minimum
software program requirements
earlier than putting in the db2 server, your machine desires to get geared up with the specified software program on it. for linux, you need to put in “libstdc++6.zero”.
checking gadget compatibility
before installing db2 server, you want to affirm if your gadget is like minded with the db2 server. for confirming the compatibility, you need to name ‘db2prereqcheck’ command on command console.
installing db2 on Linux operating machine
open the terminal and set the db2 installation image folder course on console using “cd ” command. then kind “./db2prereqcheck” command, which confirms the compatibility of your machine with db2 server.
./db2prereqcheck
determine-1 shows the compatibility necessities of linux working system and hardware machine.
comply with the given steps for installing db2 in your linux gadget:
open the terminal.
login as root user.
open db2 set up folder.
type “./db2setup” and press input.
this manner will start execution of db2 server setup.


Tags Cloud