Displaying 2 results from an estimated 2 matches for "db20000i".
2015 Mar 30
2
db2 is running out of shared memory
...ssing was successful.
Waiting for 1 minute...
SQL1063N DB2START processing was successful.
ATTACH TO db2inst9
Instance Attachment Information
Instance server = DB2/LINUXX8664 10.5.5
Authorization ID = DB2INST9
Local instance alias = DB2INST9
DEACTIVATE DATABASE ANIMALS
DB20000I The DEACTIVATE DATABASE command completed successfully.
RESTORE DATABASE ANIMALS USER db2inst9 using
FROM '/db2home/restore1' REPLACE EXISTING WITHOUT
ROLLING FORWARD WITHOUT PROMPTING
SQL2555I The database was restored and then successfully upgraded to the
current DB2 release where you...
2016 Apr 14
0
How to optimize for IBM db2?
Hi.
I have performance problems with IBM DB2 10.5 server on KVM guest:
[db2inst1@wc8ws-auth ~]$ time db2 create db test
DB20000I The CREATE DATABASE command completed successfully.
real 7m46.155s
user 0m0.022s
sys 0m0.027s
It takes 30 seconds to create a database on an image mounted with -oloop.
I think it's because db2 uses O_DIRECT to ensure consistency. I also think that O_DIRECT is not pr...