Cannot drop database SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019

I cannot drop the database and getting the error message SQL1035N The operation failed because the specified database cannot be connected to in the mode requested. SQLSTATE=57019 What is the safest way to work around this problem? Answer: The DB2 error message appears because the current database is not a valid state for the DROP DATABASE command you’re attempting to commit. From the IBM DB2 LUW documentation “The database must not be in use; all users must be disconnected from the database before the database can be dropped”. Before you deactivate the database , speak with the application owner and... 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 →

ADM6017E The following table space is full. Table space name TEMPSPACE1. Disk is full

Question: During an application installation this error appeared on the db2diag log ADM6017E The following table space is full. Table space name: "TEMPSPACE1". The underlying file system is full There is very little flexibility about changing the application code and also very limited documentation – limiting my understanding of the amount of TEMPSPACE required. Is there a quick way to workaround this problem? Answer: There are workarounds to the disk is full error when requiring extra temp tablespace particular problem. Without knowing the details , I suspect it’s some sort of function hitting the data which is causing excessive requirement... Read more →

How TO troubleshoot ADM8010E Backup was unable to copy requested log file

During a recent review of backup failure exceptions this error message appeared: SQL2428N The backup operation did not complete because an error was encountered while the backup utility was retrieving the log files. The platform was DB2 LUW 10.1 on Red Hat Linux 6 integrated with the Avamar Plug in 7.1 . The db2diag log file reported this error message at the same time: ADM8010E Backup was unable to copy requested log file "0003456.LOG" for inclusion in the backup image. The backup has been aborted The backup method used is ONLINE with INCLUDE LOGS. For a successful ONLINE BACKUP with... Read more →

DB2 fix - SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.

Question: I attempted to complete a db2start on on a DB2 10.1.5 on Linux recently and this was the error returned.The DB2 instance did not start 03/10/2016 09:22:14 0 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing. SQL1032N No start database manager command was issued. SQLSTATE=57019 What does this error mean and how can I fix the error to allow the DB2 instance starts? Answer: By coincidence , I had a similar problem recently when migrating a server to a test laboratory. As part of the migration the server administrator changed the hostname. This was... Read more →