How to get the DB2 server instance owner

Getting the DB2 server instance owner is a common requirement for auditing and inventory management. As a DBA, application owners request my team start managing a DB2 server. The first step is to document the DB2 server instance details, such as instance owner, port, data and log file paths,backup schedules,monitoring and a whole host of other details. To get the DB2 server instance owner is different for Windows and Linux systems. On Linux the instance owner is the user ID supplied when the db2icrt command was executed.Read more on DB2 database objects. On Windows systems the DB2 instance owner is... Read more →

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 →

DB2 Security Policy

This DB2 Security Policy sample is a basis for applying DB2 security good practise and regular audits. A DB2 environment is characterised by various developers(internal), administrators (internal) and third party access (external). The DB2 security policy should reflect these different requirements. A DB2 Security Policy is the foundation for implementing security. Regular audits should be carried out , comparing the environment with the security policy. Any discrepancies can be fixed. Read more on DB2 security audit The DB2 security is broken into separate categories. Not all policies are relevant for every organisation. As a DBA , it may not be... 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 DB2 database connection count

How do I get DB2 connection count ?I need this information to supply a application restart workflow. Rather than just issuing a db2stop force, I want to send a response to the workflow program , which issues the message to the Operator. The Operator can decide on the a course of action. For example, there may be a backup in progress or an application may not have been shut down successfully. Answer: There are a number of methods provided by DB2 to supply the connection details. The decision on approach depends on specific requirements and tolerance for precision. In your... Read more →