HOW DOES DB2 INTERNALLY (PHYSICALLY) STORE THE DATA
Consider the db2 table “MYTABLE” whose TABLESPACE is “TSNAME” and database is “DBNAME”, then where does exactly the data of the table “MYTABLE” gets stored physically and how to identify it.
DB2 physically stores the data in VSAM files (LDS).
The VSAM dataset-name has the format: –
VCAT.DSNDBC.DBNAME.TSNAME.* –> CLUSTER
VCAT.DSNDBD.DBNAME.TSNAME.* –> DATASET
The same can be found out by typing the command ‘DS’ in front of the table name in BMC.
In United States, If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog
You may also like to look at:
|Working on Mainframes – Is Change to a different technology necessary|