cotton0226
asked on
db2 create failing with SQL1762N
db2 Express-C V10.5, RedHat Linux RHEL7. Installed without error.
db2 create db AMW907 on /home/mis/amw907 fails with
SQL1762N Unable to connect to database because there is not enough space to allocate active log files. SQLSTATE=08004
My disk space is good
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rhel-root 50G 9.6G 41G 20% /
devtmpfs 32G 0 32G 0% /dev
tmpfs 32G 8.0K 32G 1% /dev/shm
tmpfs 32G 28M 32G 1% /run
tmpfs 32G 0 32G 0% /sys/fs/cgroup
/dev/sda2 1014M 163M 852M 17% /boot
/dev/sda1 200M 9.9M 191M 5% /boot/efi
/dev/mapper/rhel-home 1.8T 40G 1.7T 3% /home
I have checked permissions everywhere. Any thoughts would be appreciated.
db2 create db AMW907 on /home/mis/amw907 fails with
SQL1762N Unable to connect to database because there is not enough space to allocate active log files. SQLSTATE=08004
My disk space is good
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rhel-root 50G 9.6G 41G 20% /
devtmpfs 32G 0 32G 0% /dev
tmpfs 32G 8.0K 32G 1% /dev/shm
tmpfs 32G 28M 32G 1% /run
tmpfs 32G 0 32G 0% /sys/fs/cgroup
/dev/sda2 1014M 163M 852M 17% /boot
/dev/sda1 200M 9.9M 191M 5% /boot/efi
/dev/mapper/rhel-home 1.8T 40G 1.7T 3% /home
I have checked permissions everywhere. Any thoughts would be appreciated.
The reason is either / or /home is filling up when active log files are being created.
You can likely determine which by issuing something like this...
You'll see a massive amount of activity in your first window (inotifywait)... well... unless your active log files use O_DIRECT access... which is doubtful...
Try this first + report back if this provides you enough detail about what's occurring...
You can always run this in another window, looking for climbing disk usage too...
You can likely determine which by issuing something like this...
# In one window...
inotifywait -mrq / /home
# In another window issue your database creation commandYou'll see a massive amount of activity in your first window (inotifywait)... well... unless your active log files use O_DIRECT access... which is doubtful...
Try this first + report back if this provides you enough detail about what's occurring...
You can always run this in another window, looking for climbing disk usage too...
while : ; do df -hg && sleep 10 ; doneASKER
The system wide ulimit is unlimited for files
ASKER
How do I install inotifywait?
ASKER
[root@amwnew inotify-tools-3.14]# inotifywait -mrq / /home
Failed to watch /; upper limit on inotify watches reached!
Please increase the amount of inotify watches allowed per user via `/proc/sys/fs/inotify/max_
Failed to watch /; upper limit on inotify watches reached!
Please increase the amount of inotify watches allowed per user via `/proc/sys/fs/inotify/max_
ASKER
David,
I used this script from the inotify page and i'm attaching the log file. I did change the create directory for my own purpose.
#!/bin/bash
watchdir=/home/maves/amw90
logfile=/home/maves/watchl
while : ; do
inotifywait -mrq $watchdir|while read path action file; do
ts=$(date +"%C%y%m%d%H%M%S")
echo "$ts :: file: $file :: $action :: $path">>$logfile
done
done
exit 0
watchlog.txt
I used this script from the inotify page and i'm attaching the log file. I did change the create directory for my own purpose.
#!/bin/bash
watchdir=/home/maves/amw90
logfile=/home/maves/watchl
while : ; do
inotifywait -mrq $watchdir|while read path action file; do
ts=$(date +"%C%y%m%d%H%M%S")
echo "$ts :: file: $file :: $action :: $path">>$logfile
done
done
exit 0
watchlog.txt
ASKER
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Check the ulimit values for mis.