Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2012-06-25T08:49:35Z by BuSchu
BuSchu
BuSchu
30 Posts
ACCEPTED ANSWER

Pinned topic File system crash

‏2012-06-25T08:11:43Z |
Let me first say, the database I'm talking about is in not in production now, we are only testing something!

On thursday the file system where the database is stored, crashed an I was absent. A college of mine then tried a db2 stop force which didn't finish until now. I killed this process and now the situation is as follows:
"db2 get dbm cfg" works
"db2 get db cfg for database <name>" does not finish
same for "db2 restart databse <name>"
same for "db2 list application show detail"
I looked at the files in the database directory: No file shows the current date.
And no db2 process consumes time.

What should I try? The current contents of the database are not important. I have a backup with the important data.

Regards
Burkhard
Updated on 2012-06-25T08:49:35Z at 2012-06-25T08:49:35Z by BuSchu
  • BuSchu
    BuSchu
    30 Posts
    ACCEPTED ANSWER

    Re: File system crash

    ‏2012-06-25T08:14:10Z  in response to BuSchu
    One additional information: There is only one entry in db2diag.log from today:

    2012-06-25-09.49.40.761417+120 I17218414E374 LEVEL: Warning
    PID : 14368 TID : 47763101897568 PROC : db2stop
    INSTANCE: <name> NODE : 000
    HOSTNAME: <hostname>
    FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:12463
    MESSAGE : Released lock on the file:
    DATA #1 : String, 36 bytes
    /home/<name>/sqllib/ctrl/db2strst.lck

    Regards
    Burkhard
  • BuSchu
    BuSchu
    30 Posts
    ACCEPTED ANSWER

    Re: File system crash

    ‏2012-06-25T08:49:35Z  in response to BuSchu
    The database is running again without data loss. I killed all processes, removed the file sqllib/.ftok, created it again and started db2.

    Regards
    Burkhard