Here’s a succinct way of generating SELECT COUNT(*) against all tables in a DB2 database.

SELECT 'SELECT COUNT(*) AS COUNT_' || TABLE_NAME ||
' FROM ' || TABLE_SCHEMA || '.' || TABLE_NAME
FROM sysibm.TABLES
ORDER BY TABLE_NAME 

This returns output like the following:

SELECT COUNT(*) AS COUNT_ADVISE_INDEX FROM DB2INST.ADVISE_INDEX
SELECT COUNT(*) AS COUNT_ADVISE_WORKLOAD FROM DB2INST.ADVISE_WORKLOAD

These calls will retrieve DB2 system properties.

SELECT *
FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS Instance_Info
GO
SELECT *
FROM TABLE(SYSPROC.ENV_GET_PROD_INFO()) AS Product_Info
GO
SELECT *
FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS System_Info
GO