DB2 1 - Introduction to IBM Mainframe DB2

DB2 is a Relational Database management System(RDBMS)
DB2 is stored as a separate SUB-SYSTEM.
DB2 software will be store as a separate sub-system in a Mainframe system.
Multiple DB2 sub-systems can be created for the different environments like.

  1. Development Environment
  2. Testing /QA Environment
  3.  Production Environment

It is noted that every DB2 subsystem is recognized by a user-defined names
b/w 1-8 alphanumeric characters for more meaning full name.

Naming conventions are as follow.

For Development it would be DSD1, DSD2,….

For Tester it would be DST1,DST2,….

For Production it would be DSP1,DSP2,……

For More Information Click the video




Previous
Next Post »