How to block database connections

During a recent consultation there was a requirement to block DB2 LUW database connections. The purpose was to test monitoring alerts and assess the correct response when a database connection could not be established. The requirement was to maintain the DB2 instance active and all the other databases as online An easy way to block database connections is to use the MAXAPPLS database configurable. This parameter specifies the maximum number of concurrent applications that can be connected (both local and remote) to a database. The trick is to set the DB2 LUW database MAXAPPLS configurable to 1, and ensure that... Read more →

The case of the rapidly expanding TEMPSPACE1 tablespace

An application install was forcing the TEMPSPACE1 to fill very quickly and constantly getting to the system disk is full error. The query was crashing as disk full limits were stopping the query to finish successfully.The db2diag log entries were referencing ADM6017E The following table space is full. Table space name TEMPSPACE1. Disk is full A sql trace captured the query running during this activity. Within the query there was a scalar function.I used the query on How to list UDF in DB2 and returned the routine body. An examination of the routine revealed some useful details. The routine accepted... Read more →

Notes on DB2 LUW archive log and BACKUP command

Question: During a very high workload period on a DB2 LUW we are experiencing slower than expected archival logging . The archival logging method utilises a VENDOR library – which utilises deduplication. We are actively working with the vendor , but I’d like to explore the DB2 LUW configurations and maximise the resources on the host. Could you supply some notes and approaches to develop a plan? We’ve used different approaches to try and measure the throughput of copying the file from the active log path to the archival log path. One of those has been to use the archive... Read more →

10 most popular posts for dba-db2.com for 2015

I've just published 10 most popular sqlserver-dba posts for 2015 , so I thought I'd publish 10 most popular posts for dba-db2.com for 2015 I've been meaning to publish the 10 most popular posts for dba-db2.com for 2015 since the start of 2016. But I've had a lot of work and being writing about other topics. Mainly I write dba-db2.com posts to document problems and to help me understand what I'm working on. One of the observations about this list is that I also revisit these posts regularly. I use the posts as reference and also edit based on feedback.... Read more →

TSAMP maintenance and diagnostics

You’ve set your TSAMP environment on Linux and DB2. Tested a few failover scenarios and everything is looking positive. One of the key things about TSAMP and DB2 is maintaining the environment. Finding any small problems before they become big problems. For example, monitoring message logs and backing up copies of configuration and state files can save you lots of work when troubleshooting. These are some guidelines to follow, which will give you a firm basis. There are different ways of using the information, but I like to create reports , which are reviewed and apply any fixes 1. Before... Read more →