How to Troubleshoot - SQL1226N due to many db2agent processes attached to the instance

Question: On a DB2 LUW 9.7 instance , I’m getting these error messages. What commands can I use to investigate and troubleshoot SQL1226N due to many db2agent processes attached to the instance? I’ve read the post ADM7519W DB2 could not allocate an agent. The SQLCODE is "-1225" , but require some method to extract db2agent information and work with application owners. SQL1226N due to many db2agent processes attached to the instance ADM7009E An error was encountered in the "TCPIP" protocol support. A possible cause is that the maximum number of agents has been exceeded. Answer: It is sometimes difficult to... Read more →

Cron schedule for the first Sunday of every month

Question: How do I schedule a cron job (or crontab job) for for the first Sunday of every month? Answer: To schedule a job to run on the first Sunday of every month , use the crontab example as a template. This example executes a script at 2am on a Sunday where the day of the month is between 1 and 7. Adjust according to your needs Before we look at a solution - a couple of notes around potential gotchas when it comes to creating a cron job The relationship between day of month and day of week fields... Read more →

DB2 database hangs on db2 connect - use db2pd to troubleshoot

During a DB2 database Physical 2 Virtual (P2V) migration , the systems administrator did not request for the application be shut down. The usual practise for a P2V is to shut down the application and shut down DB2 – then start P2V. This didn’t occur and resulted in a potential corruption. When I restarted the DB2 server instance and attempted a db2 connect – the DB2 database wouldn’t progress with a successful connection. After some db2diag.log investigation and a DB2 instance restart – a message appeared: ADM1532E Crash recovery has failed with SQLCODE "-1042". Roll Forward to a point in... Read more →

Maximum connections allowed on a DB2 database - MAXAPPLS and MAX_COORDAGENTS

Question: How can I find out the maximum amount of connections allowed on a DB2 database? Answer: Work through this example to analyse the connections. The example indicates support for 68 (with room to grow) and the high watermark is 38. To check at a database level check MAXAPPLS . This parameter specifies the maximum number of concurrent applications that can be connected to a database. db2 get db cfg for DB_NAME | grep 'MAXAPPLS' --returns Max number of active applications (MAXAPPLS) = AUTOMATIC(68) To check at an instance level check : MAX_COORDAGENTS , which is used to limit the... Read more →

DB2 - Collecting data for database performance problems

In DB2 database performance troubleshooting , one of the challenges is to collect the right amount and type of data to assist the DBA to get clues. In How to report a DB2 performance problem there are questions to think about – guiding you towards a general approach to reporting a performance problem This post lists the information required when you’re sending me DB2 performance related queries. It gives me enough data to gain an overview of the database. It doesn’t guarantee a solution , but covers the main data sets. Run the following from a DB2 command window db2look... Read more →