Home > IT Answers > Business Intelligence > Tables in DB2 z/OS
KarishmaKapoor
20 pts.
 Tables in DB2 z/OS
DB2, DB2 Everyplace, Mainframe Datasets, Mobile development, z/OS
In which dataset will I be able to find the default tables of DB2 V9 in Z OS

Software/Hardware used:
ASKED: May 5, 2009  4:28 AM
UPDATED: April 26, 2011  4:25 AM
RELATED QUESTIONS
Answer Wiki:
Your question is not very specific, and I do not know what you mean by the "default tables". but let me try to address the topic. DB2 z/OS consists of many datasets. Each tablespace and each index space will be made up of one (or more) VSAM LINEAR datasets. The naming convention for these datasets is as follows: high level qualifier . DSNDBx . data base name . space name . I0001. A001 where high level qualifier depends on your installation and VCAT name, and DB2 STOGRP definitions DSNDBx is DSNDBC for cluster component and DSNDBD for the data component database name is the name of the database in question (DSNDB01 is the DB2 directory, DSNDB06 is the catalog, DSNDB04, DSNDB07, and so on) space name is the name of the tablespace or index space the last two nodes of the dataset name (starting with I & A) are used by in line REORG and for multiple datasets per page space (which is too involved to get into right now). Now, please do not try to access the datasets directly. DB2 only wants you to access the data via the table structures. Only your DBA should EVER consider accessing the datasets directly. I hope this helps.
Last Wiki Answer Submitted:  July 28, 2009  4:09 pm  by  Meandyou   5,205 pts.
All Answer Wiki Contributors:  Meandyou   5,205 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I would say that the default tables in a newly created DB2 subsystem ( z/OS ) is the set of catalog tables beginning with the CREATOR = ‘SYSIBM’. The z/OS subsystem concept of databases is a superset of the LUW concept of database. The z/OS DB2 subsystem contains many databases with one or more creators where views can join across databases either through the use of alias or hard coding of the table creator.

SELECT c1,c2,c3 from A.X;
or
SET CURRENT SCHEMA =’A';
SELECT c1,c2,c3 from X;

or ( more complex)

SELECT A.c1,A.c2,A.c3,B.c4,B.c5 from A.X, B.Y;
or ( with a schema or default bind owner )
SET CURRENT SCHEMA =’B';
SELECT A.c1,A.c2,A.c3,B.c4,B.c5 from A.X, Y;

LUW would either need to retrieve the data on a seperate thread ( call )
or use DDF’s three part name.

SELECT A.c1,A.c2,A.c3,db.B.c4,db.B.c5 from A.X, db.B.Y; — other variants exist

CHINWGUY
 20 pts.