How Get IP Address of connections to DB2 server

Question: How can I get the IP address of connections to a DB2 server? When connected to a DB2 server and execute db2 list applications, a list of connections are listed . The problem is the information in the Application Id column in the db2 list applications output is not easily readable. To get the ip address , string manipulation is required, using the SUBSTR function. Is their another way of getting the ip address, without having to use SUBSTR? Answer: Yes. It is possible get the ip address of connections via the SYSIBMADM.SNAPAPPL administrative view. The view allows you... Read more →

Check DB2 instance status

How to check for the DB2 Instance Status? There are multiple methods of checking the DB2 instance status. The method is usually dependant on the requirements. These are some examples of different situations where the DB2 instance status is required Server reboot – Has the DB2 instance started OK?Maybe auto start failed or an underlying disk issue. Connection troubleshooting – Is the DB2 instance available? Disaster Recovery – On a site failover , has the DB2 instance started OK? Typically a DBA may go beyond checking just the DB2 instance status. They may want to check database connections , tablespaces... Read more →

How To get the column definitions of the DB2 Monitor table functions

Question: How can I get the column definitions of the DB2 Monitor (MON) table function? Answer: You can describe the Monitor function tables output by prefixing describe output before the SELECT statement . It will return the column definition. For example, --return column details of MON_GET_BUFFERPOOL db2 "describe output SELECT * FROM TABLE(MON_GET_BUFFERPOOL('',-2))" ---return column details of waits and processing times for a connection db2 “describe output select r.metric_name, r.parent_metric_name, r.total_time_value as time, r.count, c.member from table(mon_get_connection_details(125,-2)) as c, table(mon_format_xml_times_by_row(c.details)) as r order by total_time_value desc Read More Reorg table DB2 DB2 table reorg and table truncate DB2 Used Space... Read more →

DB2 Total Sorts - overflows – improve performance

Sorts are part of processing queries , but excessive sorts , especially in an OLTP databases can kill performance. Sorts hit IO,CPU and lead to slow response time. A typical DB2 Sort occurs if a sql statement uses an ORDER BY but can’t find a relevant index. Sort Overflows represent the amount of sorts overflowing to disk . A high percentage could indicate performance issues. Increasing SORTHEAP is the quickest way of improving this situation , but is probably masking underlying problems. A more in depth approach will require an analysis of the sql code and supporting indexes. To obtain... Read more →

DB2 instance startup time

Q. How do I calculate the DB2 instance startup time ? I want to see the DB2 instance start time A. Use the dbm snapshot functionality. db2 get snapshot for dbm |grep Start Read More about the DB2 manager status DB2 manager status and get snapshot for dbm Read more →