var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Drop database left some settings befind, so create database can't be executed
on db2 enterprise v8.2 fp 11 on Linux I have drop the database and it looks like drop database was not correctly done.
When executing command:
error was returned: SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030
db2 restore database mydb from /backup/ to /workingdir/db into mynewdb
I tried to restore to different directory
and restore commpleted successfully.
db2 restore database mydb from /backup/ to /workingdir/dbnew into mynewdb
It looks like drop database was not correctly done. How can I "clean up" settings that have been left from drop? I would like to restore database to my original directory?
Do blastdb. It will drop the database and do all cleanup.
thanks a lot. I have solved the problem by removing all files/directories/subdirectories with Linux rm command from /workingdir/db directory and now restore database works fine.