Using the ('dbspace', tblspace_num) Option

The 'dbspace' option returns a character string that contains the name of the dbspace that corresponds to a tblspace number. You must supply an additional parameter, either tblspace_num or an expression that evaluates to tblspace_num. The following example uses the 'dbspace' option. First, it queries the systables system catalog table to determine the tblspace_num for the table customer, then it executes the function to determine the dbspace name.

SELECT tabname, partnum FROM systables
   where tabname = 'customer';

If the query returns a partition number of 1048892, you insert that value into the second argument to find which dbspace contains the customer table, as the following example shows:

SELECT DBINFO ('dbspace', 1048892) FROM systables
   where tabname = 'customer';