[IBM][CLI Driver][DB2/NT64] SQL0964C The transaction log for the database is full.

By Kwok WhyeNo Comments

Another error found when working on DB2.

Error Message 

[IBM][CLI Driver][DB2/NT64] SQL0964C  The transaction log for the database is full.
Symptom 
When running on some big transactions, DB2 returned the above error message on DB2.
Resolution
To resolve the above issue, we will need to increase the transaction log file size for that particular DB.
First check on the current log file setting using the following command. Assumption is the Database name is ABC
db2 get db cfg for ABC
A long list will be returned. Look for the following portion.
Log file size (4KB) (LOGFILSIZ) = 1024
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 12
Database page size                                      = 32768
The formula to calculate the disk space required is as following.
disk_space_required = logfilsiz * (logprimary + logsecond) * page_size
Page_size is also is also returned in part of the list from the get db cfg command.
In this case, my current disk space required is as following.
disk_space_required = 1024 * ( 13 + 12 ) *  32768 =  800 MB.
My current setting is only can support up to 800MB transaction log file. I would like to increase it to support up to 2 GB
logfilsiz  =  2GB / 32768 / 25  =  2442
Run the following command to update logfilsiz to 2442
db2 update db cfg using logfilsiz 2442
The following response will be returned.
C:\Program Files\IBM\SQLLIB\BIN>db2 update db cfg using logfilsiz 2442
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
Restart Database using the following command to reflect the latest change. ( Assuming user is DB2ADMIN and Password is ****** )
db2 restart database QUICOINT user DB2ADMIN using ******
This should fix the error. Hope this is the resolution you are looking for . Happy DB2ing .
Database, IBM DB2

[IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031

By Kwok WhyeNo Comments

Recently, I have started to work on IBM DB2 database , which is another giant database creature that I haven’t touch in my life before.

However , it is a good experience and it extends my knowledge on another type of database. One of the issues that I spent quite a lot of time to research and fix is the error in the title of this article.

Error Message

[IBM][CLI Driver] SQL1031N  The database directory cannot be found on the indicated file system.  SQLSTATE=58031 Continue reading this entry »

Database, IBM DB2

Simple way to handle QUERY parameter for Oracle Export function

By Kwok WhyeNo Comments

Before Oracle 10g and 11g, Oracle already has a default import/export function come together. With data pump implemented on oracle 10g and 11g, definitely data pump will be able to export/import data faster than the default import/export function. However, the oracle legacy import/export function is still very useful for small database import/export or small subset of table import/export function. Continue reading this entry »

Oracle

Change date value in BMC Remedy table to actual date

By Kwok Whye2 Comments

BMC Remedy is a famous incident ticketing system in most of the multinational big company. It basically match with incident management in ITIL process and hence are commonly used by most people.

If you access the data of the BMC remedy database before, you will find that all the date in remedy is actually an integer value as following Continue reading this entry »

Remedy

Advanced Virtual Box Technique – Hotpluggable CPU

By Kwok WhyeNo Comments

With virtual machines running modern server operating systems, VirtualBox supports CPU hot-plugging.Whereas on a physical computer this would mean that a CPU can be added or removed while the machine is running, VirtualBox supports adding and removing virtual CPUs while a virtual machine is running. Continue reading this entry »

Virtual Box

Mysqlslap – Mysql Performance Measurement tool

By Kwok WhyeNo Comments

mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server. mysqlslap is available as of MySQL 5.1.4. Continue reading this entry »

Mysql

System Performance Measurement Tool – UnixBench

By Kwok Whye3 Comments

Always we hear that people said one server is better than another without much data to prove it. To have data-driven method to mesuare your servers, UnixBench is the right tool for you. Continue reading this entry »

Linux

Logrotate – Linux Log Files Management Tool

By Kwok Whye2 Comments

logrotate is designed to ease administration of systems that generate large numbers of log files. It allows automatic rotation, compression,removal, and mailing of log files. Each log file may be handled daily,weekly, monthly, or when it grows too large. Continue reading this entry »

Linux

Oracle JInitiator cannot run in Internet Explorer 8.

By Kwok WhyeNo Comments

When run Oracle JInitiator in Internet Explorer 8 ( IE 8 ), Internet Explorer 8 return error “It has encountered a problem and needs to be close.”  or you will keep seeing ” this tab is recovering” error. Continue reading this entry »

Oracle

Easy way to view the CPU load of all CPUs in Linux.

By Kwok WhyeNo Comments

Multi core CPU is already very popular in the IT world since couple of years ago. Hyper-threading make it even more popular. Last time, we just need to check CPU load of one CPU but now it won’t be the case anymore. Continue reading this entry »

Linux
Blue Taste Theme created by Jabox