Hi All,

If there is an auto-resize tablespace, how to get MAXSIZE of it by using DB2 API? The MAXSIZE is displayed in "get snapshot for tablespaces on <db_name>". But I am not able to find equivalent information in DB2 API.

MAXSIZE element is exists in Extended table space description block (SQLETSDESCEXT) structure but it is used in extended database description block (SQLEDBDESCEXT) structure while calling sqlecrea API. But I want to get MAXSIZE of existing auto-resize tablespace.

The SQLB_TBSPQRY_DATA structure doesn't contain this information. Also Tablespace Query API (sqlbmtsq) or Tablespace Statistics API (sqlbgtss) also not giving MAXSIZE value.

Then how to get MAXSIZE of existing auto-resize tablespace using DB2 API?

Thanks.