How to view the file path of a tablespace in db2?

2 years ago
Liam
1 minute

To view the file path of a tablespace, you can use the following command:

  1. Connect to the db2 database.
  2. connect to the specified database in DB2
  3. Run the following command to obtain the path of the tablespace file:
  4. Select the tablespace name and file name from the TBSP_UTILIZATION table in the SYSIBMADM schema in DB2.
  5. This command will return the name and file path of the table space.
bannerAds