Tables in DB2 z/OS

20 pts.
DB2 Everyplace
Mainframe Datasets
Mobile development
In which dataset will I be able to find the default tables of DB2 V9 in Z OS

Answer Wiki

Thanks. We'll let you know when a new response is added.

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
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.

Discuss This Question: 1  Reply

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to 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
    20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: