DB2 Query to check table counts,start end time

Applications Programming
1

Dear team

I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .

Currently i am using below query but this displays table name and counts for latest run.

select name ,CARD from sysibm.systables
where creator ='Scheam name'
GROUP BY name,CARD
ORDER BY name

I need to have below details

  1. If i have staging table as "STG_Customer" and Target table as "Customer", i would need to get the counts of each side by side , or immediate below the row .
    Ex: STG_Customer -20 Customer -20 OR
    STG_Customer -20
    Customer -20
    2.Additional columns along with table name and Counts. "Start Time", "End Time", "Load status --Success or Failure "
    3.We keep on adding staging and target tables and hence cant hardcode in queries. Any feasible way to explore this requirement . Please do let me know.

I want to call this query in perl/python to send automated mails on daily basis.