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.