DATABASE 2 INTRODUCTION
DB2 Is a Relational DBMS developed by IBM for computers running under MVS, its most advanced operating system for large computers. DB2 supports SQL (structured query language), which has been standardized by ANSI (American National Standards Institutes) and ISO (International Standards Organization) and has become the standard for all relational DBMSs.
DB2 co-operates with attaches to is the technical term-any of three MVS subsystems environments : IMS, CICS, and TSO. These subsystems cooperate with DB2 facilities to provide such services as data communications and control of transactions, which are group of database operations that must be coordinated to avoid the introduction of errors. CICS is a teleprocessing monitor, a program for controlling online transactions those that execute as they are entered from a terminal allowing users to interact with the computer. IMS/DB/DC is a well established nonrelational DBMS, which includes a teleprocessing monitor. TSO also contains a teleprocessing monitor that can be used by DB2. DB2 applications running under TSO may be online or batch.
Relational Database Management System(RDBMS)
DB2 will be stored as separate sub system in mainframe. Any number of Sub Systems can be created in Mainframes as per the requirements. Sub systems can be used for deferent regions like development, Quality and Production regions. DB2 sub system consists database objects and they are organized as below..
NOTE: Click the Chapter Name for More information.
CHAPTER 1. BASIC CONCEPTS
CHAPTER 2. SQL
CHAPTER 3. DB2 SYSTEM ARCHITECTURECHAPTER 4. DATABASE OBJECTS.
CHAPTER 5. BINDING AND PROGRAM PREPARATION
CHAPTER 6. COMPONENTS OF DB2.
CHAPTER 7. ADDITIONAL COMPONENTS OF DB2.
CHAPTER 8. DB2 UTILITIES AND COMMANDS.
CHAPTER 9. PRECOMPILATION.
CHAPTER 10. STORAGE STRUCTURE.
CHAPTER 11. SPUFI AND QMF.
CHAPTER 12. DB2 PROGRAMMING.
CHAPTER 12. DB2 PROGRAMMING.
CHAPTER 13. ABBEND CODES.
CHAPTER 14. DB2 PROGRAMS.
CHAPTER 15. FAQ's ON DB2.
