DB2 - SQL2428N The BACKUP did not complete because one or more of the requested log files could not be retrieved.

Question: During an DB2 ONLINE BACKUP , a SQL2428N error appeared. The backup command was: db2 backup db MYDB online use TSM include logs #Error message: #SQL2428N The BACKUP did not complete because one or more of the requested log #files could not be retrieved. Answer : The DB2 ONLINE backup requires log files that were active at the start of the BACKUP to the log file containing the Online Backup End Record. If the ONLINE BACKUP is running for a long duration – the active log file at the start of the ONLINE BACUP may no longer be available... Read more →

DB2 – Audit Failed logons

Troubleshooting DB2 failed logon attempts is an important part of DB2 databases security management. Beyond establishing security threats , such as hacking or viruses , the purpose of troubleshooting can extend to discovering application issues. For example , there may be an application in the Development environment , that has JDBC connection pointing to a Production environment. This can have a disastrous impact on Production data. Ideally, an environment should have Development, Test,QA, Production servers split out into separate OUs , and there should be necessary blocks in place to exclude connection attempts across the different domains. Nevertheless, it does... Read more →

DB2 – 10 Top Skills for Architects

Consulting for different companies , I’ve noticed the Architect role definition role varies. The range of titles reflects the different domains of an IT department. In the last few months I’ve dealt with : Enterprise Architect, Solutions Architect, Data Architect , Project architect, Business Architect, Information architect, Application architect, Database Architect, Java Architect, Technology architect. The differences can be subtle – read Database Architect versus Data Architect The Architects interaction with the project team depends on the environment. In agile , rapid project turnover sites, the Architect may code . I’ve met Architects who claim it’s a prerequisite to be... Read more →

Faster DB2 on Twitter

Follow me on Twitter for DBA,SQL Server,DB2 and Performance Tuning very large databases infomation. @jackvamvas Email +Jack Vamvas at [email protected] for any other questions. I do try and respond as quickly as possible. These posts may help you with urgent issues, also use the Search feature for other posts. DB2 list schemas of a database - DBA DB2 Force connections of a database in DB2 DB2 Query Tuning – db2expln Read more →