DB2 Tips

Question: How to get Current Date in DB2?
Ans: select current date from sysibm.sysdummy1
Same way we can get current time and timestamp using following command
"current time" and "current timestamp"

Alternatively we can use following commands
values(current date)
values(current time)
values(current timestamp)
to get current Date, Time and Timestamp

-> To see maximum active agent:
db2 get dbm cfg | grep "(MAXAGENTS)"

-> To see maximum application connected to a particular database:
db2 get dbm cfg for REPLACE_WITH_DB_NAME | grep "(MAXAPPLS)"