Fixing “The transaction log for the database is full” problem in DB2
[IBM][CLI Driver][DB2/AIX64] SQL0964C The transaction log for the database is full. SQLSTATE=57011 The above mentioned error occured when database log file is not large enough for the application to create…
How to configure Oracle’s data source in Unica for User Tables?
To import Oracle’s table into Unica Marketing Platform, you have to create Oralce data source. Following steps are required to successfully establish connection with Oracle database. Step 1: Adding Data…
How to insert and update records in external tables from Unica?
While working with external systems there are requirements when you have to insert and update records in a database table. To do it you must know the relevant process to…
How to create strategic segment in Unica?
Strategic segments are those segments that can be shared within campaigns in Unica. You can create this type of segment by using Sessions. 1. Create a new Session 2. Add…
How to create tablespace in DB2 v9.7?
I was trying to create tablespace in DB2 on AIX. I wanted to have that tablespace in a directory at my operating system. I have also created a bufferpool having…
FUD: JDBC addiction and designing software for NoSQL
I am having a background of programming Java based web systems with RDBMS. Where I write a lot of JDBC code. Updates, select statements with a lot of joins, inserts…