SQL30082N – ROOT CAPABILITY REQUIRED

An application owner reported an error DB2 SQL error SQLCODE -30082, SQLSTATE 08001, SQLERRMC 42;ROOT CAPABILITY REQUIRED;DSRA0010E SQL State = 08001, Error Code = -30,082. I checked in the db2diag.log Password validation for user xxxxx failed with rc = -2146499506 The main reason this sequence of errors appear is due to the DB2 password daemon not started. Therefore the db2sysc process attempts the password check. If the db2sysc process doesn’t have root authority the error code . SQL30082N 42 appears. How to fix the ROOT CAPABILITY REQUIRED error SQL30082N 1) Check to see db2ckpwd is running as Root 2) If... Read more →

How to read db2detaileventlock event monitor trace file

Question: When I try to view the *.evt file in $DBHOME/db2event/db2detaildeadlock it looks like binary. I’d like to be able to read the details in human readable format. Is there a DB2 utility to format the event monitor trace file data? Answer: Yes, there is a DB2 utility called db2evmon. This utility formats the even monitor file. Here is a an example of how to configure and execute the db2evmon event monitor utility.In this example I'm viewing the file using the vi utility. I normally use vi to read text files on Linux. If reading the output file on Windows... Read more →

Best of DBA-DB2 com

If you are new to DBA-DB2.com, you can read our most popular posts. Also search our archives by using the search box . Most Popular posts on DBA-DB2.com in the last year DB2 list schemas of a database - DBA DB2 DB2 – DBA Scripts Reorg table DB2 - DBA DB2 Database size in DB2 - DBA DB2 DBA Interview Question and Answers for DB2 - DBA DB2 DB2 SET CURRENT SCHEMA - DBA DB2 How to grant select privileges on all tables for DB2 - DBA DB2 DB2 SQL2413N - Online backup is not allowed - DBA DB2 How... Read more →

How to display DB2 db2diag.log appended records using follow parameter

Question: How can I view db2diag.log entries as they are written? While I’m troubleshooting , I open the db2diag.log file and then press refresh to see the latest entries. Answer: Use the db2diag –follow parameter to continuously display appended records as they appear in db2diag.log. The records continue to appear until you execute Ctrl + C. Db2diag –f Db2diag –follow More information on db2diag.log db2diag.log file delete on Linux and DB2 db2diag.log file filling - DBA DB2 Analyzing a DB2 trap file - DBA DB2 Read more →

How to terminate a DB2 backup

Question: How can I terminate a DB2 backup ? Using db2 list utilities I can see a BACKUP in progress , but how can I terminate the BACKUP from within DB2? Answer: To identify the process managing the BACKUP use this command db2 list applications show detail | grep -i perform From this result identify the process id related to the BACKUP. Force the application ID with this command. Check db2 list utilities to confirm if the backup is still running Db2 force application (application_id) Read More on DB2 backups DB2 – Backup history DB2 – check backup command and... Read more →