C:\Program Files\IBM\SQLLIB\BIN>db2diag -A
db2diag: Moving "C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2diag.l og"
to "C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2diag.log_2 013-06-18-06.3
C:\Program Files\IBM\SQLLIB\BIN>db2 connect to jts97
SQL1032N No start database manager command was issued. SQLSTATE=57019
There was no db restore before I renamed db2diag.log to db2diag.20130617.log
However there was a SQLCODE= -1036, SQLSTATE=58030 for starting one of my databases DW2012, the original db2diag.log was too big I cannot open it to read, hence I renamed it then ran into this -4499 -08001 problem.
I restart db2 and activate my databases in following sequence:
3. db2 list active databases (nothing was listed)
4. db2 activate database JTS97
5. db2 activate database QM
6. db2 activate database CCM
7. db2 list active databases ( it showed the above 3 databases)
8. restart my application & run it
9. ran into problem of connection reset
CCM is one of my db2 database in that DB2 instance.
I was trying to do a backup of this database with following command, and got error of "SQL0901N The SQL statement or command failed because of a database system
error. (Reason "1117".) SQLSTATE=58004".
db2diag.log is attached.
CONNECT TO CCM;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
DEACTIVATE DATABASE CCM;
BACKUP DATABASE CCM user xxxxxx using xxxxxx TO "F:\DB2 backups" EXCLUDE LOGS WITHOUT PROMPTING;
However "db2dart CCM" returned "Error: Failed sqledosd API on open local database directory E:\TAFDev\DB2.
SQL1031N The database directory cannot be found on the indicated file system."
CCM's table spaces are located in E:\TAFDev Data\DB2, and it had been working fine for me for almost a year, why all of the sudden it looked E:\TAFDev\DB2 ? How can I instructed it to look at the right folder ? I am using window 2008 64 bit machine.
The DB2DART Tool is a utility for the analysis of databases,
tablespaces, and tables. DART's primary function is to
examine databases for their architectural correctness, and to
report any encountered errors.
Error: Failed sqledosd API on open local database directory E:\TAFDev\DB2.
SQL1031N The database directory cannot be found on the indicated file system.
Error: This phase encountered an error and did not complete.
DB2DART Processing completed with error!
The inspection phase did not complete!
Complete DB2DART report found in: CCM.RPT
_______ D A R T P R O C E S S I N G C O M P L E T E _______