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 log files. The solution for this problem is to increase LOGFILSIZ, LOGPRIMARY and LOGSECOND parameters. When you will be going to increase the values for […]

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 Source to User Settings > Users > Edit Data Sources > Add New Data Source: <Select the name of your data source> Data Source Login: […]

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 the same pagesize of tablespace (that is necessary). But was getting SQLCODE=-104. I also tried with `FILE` tokens giving the sizes too. But was unable […]