Category Archives: Databases

Debug tools for enterprise environments

There are various tools that I use to spot issues and investigate an enterprise environment. One of my favourite tools is IBM Performance Analysis Suite. Capabilities described by IBM: Import all kinds of performance data for analysis. Some examples: DB2 snapshot, Java verbose GC output, Java thread dumps. Import software/middle-ware configuration for compliance checking. Some… Read More »


Blog Links: Oracle Trace File Analyzer (TFA)

One of the best introduction tutorial I have seen about a useful tool set. I am sick of all the empty marketing “pitches” I see daily. Oracle Trace File Analyzer (TFA) – An Overview Guide A must read for anyone that has to work with Oracle DB and needs to do a deep investigation of… Read More »

Blog Links: SQL Server on Linux

Big news, MS finally realized that with the cloud migration of a lot of services if you do not embrace Linux you are dead. After anouncing that it joined Linux Fundation as a platinum member we got SQL Server on Linux Install SQL Server on Linux

Oracle: Reactivate a database user

I am always very annoyed when my Oracle user is automatically expired and locked. This is done automatically at 180 days in some installations. The following are some very easy steps for a question that everybody is asking again and again on forums. STEP 1: Connect to the DB sqlplus / as sysdba STEP 2:… Read More »

Blog Links: SQL Server Tricks and Tips

The following are some interesting SQL Server related links: A lot of times you have to relocate the data and log files of a SQL Server. It can be that the default installation was not OK or you change the storage. The following tutorial is very useful Move System Databases Using SQL Server with R… Read More »

DB2: Debug db2 SQL exceptions

Sometimes the db2 exceptions are cryptic or hidden by the application layer. In this case the only way to find the db2 SQL exception is to investigate in db2 logs. First check the log level setup in the Database Manager Configuration. Log in as the user under which db2 instance runs, in my case db2inst1.… Read More »

DB2: SQL Error: -803, SQLState: 23505, Unique Constraint Violation

Yet another thread of DB2 errors from an EJB application that connects to a DB2 instance. The reported thread of errors: [7/13/16 12:46:38:669 IST] 00000098 SqlExceptionH Z org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions SQL Error: -4229, SQLState: null [7/13/16 12:46:38:670 IST] 00000098 SqlExceptionH Z org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions [jcc][t4][102][10040][4.19.26] Batch failure. The batch was submitted, but at least one exception occurred… Read More »

DB2: SQL Error: -803, SQLState: 23505 due to NON-UTF8 character in parameter

Sometimes Java and databases do not use the same standards to represent data. This can lead to strange exceptions for which sometimes can be hard to pin point the cause. We have the following Exception reported in the enterprise application log. Let’s analyse the errors. [7/13/16 12:46:32:752 IST] 00001456 SqlExceptionH Z org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions SQL Error:… Read More »