DB2 - SQL1035N The database is currently in use

Question : I’m trying to complete an OFFLINE FULL BACKUP and receive this error message when executing db2 backup DB mydb. SQL1035N The database is currently in use. SQLSTATE=57019 I’ve checked db2 list applications - which returns no applications . How can I fix? Answer: First , check if the database is activated. db2pd -db mydb -app or db2 list active databases Second, if it’s activated , then deactivate the database db2 deactivate database Third, try OFFLINE FULL BACKUP again Related Posts on DB2 restore DB2 – Restore database from a ONLINE backup DB2 – check backup command and contents... Read more →

DB2 – Redirect Restore

Question: How do I relocate an existing DB2 database? I have a database on a path such as “/db2inst/db/” and would like to move the database to “/db2inst/dbnew/”. Answer: One option is to backup and restore with a DB2 Redirect Restore Second option – use db2relocatedb I prefer the first option - DB2 Redirect Restore as it forces the DBA to take more precautionary steps. Although relocatedb should follow the same levels of caution such as backups. In this response, I’ll focus on Redirect Restore and leave relocate db for another post. One of things I like about the Redirect... Read more →

DB2 – How to manage backup failures

Taking a DB2 backup is straightforward, but in a large DB2 environment where hundreds of mission critical DB2 databases are backed up daily, what steps are in place to deal with failed backups? A well managed backup strategy is one of the DBA secrets to stress reduction Backups can fail for different reasons – software failure, corruption, hardware issues, tapes unavailable,connectivity issues are just some of the few reasons. From an Operational perspective , how do you deal with this issue? On a basic level – 1) Attempt a backup 2) If success , OK , if failure , what... Read more →

DB2 – DBA Scripts

There are powerful DBA scripts for DBA in this post that will help you build a strong foundation in managing DB2 Database Servers. For other topics use the search I’ll keep adding more DBA scripts to this post. Contact me for any other DBA scripts Last Updated 22nd January 2016 Troubleshooting Force connections of a database in DB2 Linux - find largest files Monitor DB2 instance status and database status Command to see connection on a DB2 database - list applications Linux server largest files DB2 deactivate database Linux Server OS information DB2 instance startup time DB2 – verify DB2... Read more →