what database configuration parameters can I use to calculate total amount of memory used by the database?

Thanks

db2mtrk is one tool. db2pd also has provides information on memory. Check with the Comand Reference manual to see which options to use with these tools to get the information that you need.

those 2 commands give me a snapshot of what is being currently used now. may be I should rephrase my question - how much max memory would the database use based on db cfg parameters? what db cfg params can I add up to calculate it?

Thanks

please check this article:
The DB2 UDB memory model


There is a formula you can use to estimate your db shared memory (ie. bufferpools, locklist, dbheap, etc...). This is what gets allocated when the db is started.

A lot of that depends on which version of DB2 you are using (whether you have Self Tunning Memory Manager in the version you are using), and whether you have each parameter set to automatic or not. With automatic memory you can actually specify a maximum value that will be used in total for all the various database shared memory components (controlled by the database_memory configuration parameter).

I assume you know that in addition to database memory, there is memory at the instance level, including memory required for each connection to a database.