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 connect Cognos 10.2 with DB2 v9.7 data source on AIX?
To access DB2 remote database data source in Cognos you have to do following things on Cognos machine. Install DB2 client Set DB2 envoirnment variables Catalog remote host and database…
How to access remote database from DB2 client?
If you want to access a remote DB2 (v9.7) database from another host that’s running DB2 client. You have to do following things on client machine: Adding remote host in…
How to run DB2 store procedure from a shell script via root user?
If you have used default settings while installing DB2 on AIX. You have created db2inst1 user to use and access DB2. This post is related to the scenario, when a…
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…