Is LUW DB2 dba is good or Z/Os DB2 DBA is good?

Computer Science
Tutor: None Selected Time limit: 3 Days

Is LUW DB2 dba is good or Z/Os DB2 DBA is good? Which one has good growth and in which salary will be more.
Sep 30th, 2013
You will find differences in the way DB2 server is referred to and accessed on these two platforms. DB2 server is called a subsystem in z/OS and an instance in LUW. DB2 runs its tasks under a set of address spaces in z/OS system (discussed in Memory structures), as a process in Linux and UNIX operating systems, and as a service (unless you started with /D option) in Windows. Each DB2 z/OS server is identified by a four character subsystem identifier (SSID), and each DB2 LUW server is identified by an instance name that takes effect through the DB2INSTANCE environment variable.
What does the term database mean in each platform? A database in DB2 LUW has its own memory region, processes, and recovery logs, while a database in DB2 z/OS is a logical collection of several table spaces and index spaces with very few parameters defined as default for all objects created under it. While each database in DB2 LUW holds its exclusive catalog tables, it is every DB2 subsystem that holds catalog tables.

A DSNDB06 database in DB2 z/OS subsystem, and a SYSCATSPACE table space in DB2 LUW will hold all the DB2 catalog tables.
In non-data sharing DB2 z/OS, DSNDB07 is the work-file database. Table spaces that you create in DSNDB07 will be used as storage for processing SQL joins and sorts as well as for temporary tables. In DB2 LUW, a default system temporary table space called TEMPSPACE1 will be available for such DB2 DBM requirements as sorts or joins. You should create one or more USER temporary table spaces for storing data of temporary tables.
When you do not specify the database name while creating a table space or table in DB2 z/OS, DSNDB04 is the default user database for the created object. If you create a table without specifying a table space, DB2 will create an implicit table space for you. In DB2 LUW, assuming you have not created any user table spaces yet, USERSPACE1 will hold the tables you create without specifying the table space explicitly.
DB2 z/OS uses several information required for normal operation in a special database, DSNDB01. Boot Strap Dataset (BSDS) is a z/OS VSAM dataset that will contain some critical information regarding DB2 recovery log dataset names, DB2 checkpoints and DB2 location details. On the other hand, DB2 LUW database stores several information required for normal operation across several operating system files under local database directory.
Sep 30th, 2013

Did you know? You can earn $20 for every friend you invite to Studypool!
Click here to
Refer a Friend
...
Sep 30th, 2013
...
Sep 30th, 2013
May 30th, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer