Can  any one share a direct db2 SQL to list out the all  table names of a given schema into single file

Regards

kanak

select rtrim(tabschema),rtrim(tabname) from syscat.tables where tabschema=<SCHEMA_NAME> 

THanks,

Can you pls give me the SQL to get the tablespace names and bufferpool names in for a given database

Regards

kanak

TABLESPACES

db2 list tablespaces show detail
or
db2 "select TBSPACE from syscat.tablespaces"
or
db2pd -d <dbname> -tablespaces
or
db2look -d <dbname> -l

BUFFERPOOLS

db2 "select BPNAME from syscat.bufferpools"
or
db2pd -d <dbname> -bufferpools
or

db2look -d <dbname> -l