By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

How to recover the db2diag.log file

P: n/a
KG
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.

Sep 18 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Sep 18, 6:25 am, KG <kapilgupta...@gmail.comwrote:
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.
on windows recycle bin ;-)

Sep 18 '07 #2

P: n/a
On Sep 18, 12:25 am, KG <kapilgupta...@gmail.comwrote:
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.
If you are wondering that this would cause you some problems since you
deleted the db2diag.log file, then relax. If you delete or move the
Diagnostic Log file, DB2 creates another one and starts writing to it.
Nothing disastrous or catastrophic will happen.

But, if your question was to recover the contents of your db2diag.log
file, I am afraid there is no DB2-way to recover it. You may contact
your Sysadmins or file system backup team to see if they can be of any
help.

Cheers,
Sanjuro

Sep 18 '07 #3

P: n/a
KG
On Sep 18, 3:32 am, rahul <rahul...@gmail.comwrote:
On Sep 18, 6:25 am, KG <kapilgupta...@gmail.comwrote:
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.

on windows recycle bin ;-)
No its on solaris.

Sep 18 '07 #4

P: n/a
KG
On Sep 18, 7:05 am, Sanjuro <ashru...@gmail.comwrote:
On Sep 18, 12:25 am, KG <kapilgupta...@gmail.comwrote:
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.

If you are wondering that this would cause you some problems since you
deleted the db2diag.log file, then relax. If you delete or move the
Diagnostic Log file, DB2 creates another one and starts writing to it.
Nothing disastrous or catastrophic will happen.

But, if your question was to recover the contents of your db2diag.log
file, I am afraid there is no DB2-way to recover it. You may contact
your Sysadmins or file system backup team to see if they can be of any
help.

Cheers,
Sanjuro
Thanks Sanjuro, Actually I need the contents of db2diag.log. Because I
am trying to migrate the db from V8.1 FP10 to V9.1FP2 on solaris OS.
And getting error messages

mc1dfa01-dsat:$cat migration.log
Version of DB2CKMIG being run: VERSION 9.

Accessing database directory failed. SQLCODE = -1091.

Even it wont allowing me to run any db2 command. Whenver I run db2
command it says "SQL1091C The Release number of the database is not
valid"

Do you have any idea what to do now?

Sep 18 '07 #5

P: n/a
On Sep 18, 2:06 pm, KG <kapilgupta...@gmail.comwrote:
On Sep 18, 7:05 am, Sanjuro <ashru...@gmail.comwrote:
On Sep 18, 12:25 am, KG <kapilgupta...@gmail.comwrote:
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.
If you are wondering that this would cause you some problems since you
deleted the db2diag.log file, then relax. If you delete or move the
Diagnostic Log file, DB2 creates another one and starts writing to it.
Nothing disastrous or catastrophic will happen.
But, if your question was to recover the contents of your db2diag.log
file, I am afraid there is no DB2-way to recover it. You may contact
your Sysadmins or file system backup team to see if they can be of any
help.
Cheers,
Sanjuro

Thanks Sanjuro, Actually I need the contents of db2diag.log. Because I
am trying to migrate the db from V8.1 FP10 to V9.1FP2 on solaris OS.
And getting error messages

mc1dfa01-dsat:$cat migration.log
Version of DB2CKMIG being run: VERSION 9.

Accessing database directory failed. SQLCODE = -1091.

Even it wont allowing me to run any db2 command. Whenver I run db2
command it says "SQL1091C The Release number of the database is not
valid"

Do you have any idea what to do now?
Run db2level and see what it reports. Have you already run db2imigr
once?

If you do not have your db2diag.log from when you tried migration
first, check the notification log. Also see if there are any Trap,
Core or Dump files. If you can't find anything, try running the
db2ckmig command by itself and then note the contents of db2diag.log.

Hope this helps.

Sep 18 '07 #6

P: n/a
KG
On Sep 18, 3:55 pm, Sanjuro <ashru...@gmail.comwrote:
On Sep 18, 2:06 pm, KG <kapilgupta...@gmail.comwrote:


On Sep 18, 7:05 am, Sanjuro <ashru...@gmail.comwrote:
On Sep 18, 12:25 am, KG <kapilgupta...@gmail.comwrote:
Hi,
Does anyone knows how to recover the test file db2diag.log. By mistake
I have delete the contents of db2diag.log, wondering if I could
restore the contents of my db2diag.log.
If you are wondering that this would cause you some problems since you
deleted the db2diag.log file, then relax. If you delete or move the
Diagnostic Log file, DB2 creates another one and starts writing to it.
Nothing disastrous or catastrophic will happen.
But, if your question was to recover the contents of your db2diag.log
file, I am afraid there is no DB2-way to recover it. You may contact
your Sysadmins or file system backup team to see if they can be of any
help.
Cheers,
Sanjuro
Thanks Sanjuro, Actually I need the contents of db2diag.log. Because I
am trying to migrate the db from V8.1 FP10 to V9.1FP2 on solaris OS.
And getting error messages
mc1dfa01-dsat:$cat migration.log
Version of DB2CKMIG being run: VERSION 9.
Accessing database directory failed. SQLCODE = -1091.
Even it wont allowing me to run any db2 command. Whenver I run db2
command it says "SQL1091C The Release number of the database is not
valid"
db2level is the only db2 command that I can run. The output saying
"db2 V8.1 FP10"

I have checked the notification log and it has information only about
database manager started and stop, and nothing else. Even it wont
allow me to restore the database through backup image. One of mine
friends told me to restore the three files in the sqldbdir (sqldbdir,
sqldbbak, sqldbins) from a file system backup.
Do you have any idea how and from to restore these files.

Thanks for your time and help.

Do you have any idea what to do now?

Run db2level and see what it reports. Have you already run db2imigr
once?

If you do not have your db2diag.log from when you tried migration
first, check the notification log. Also see if there are any Trap,
Core or Dump files. If you can't find anything, try running the
db2ckmig command by itself and then note the contents of db2diag.log.

Hope this helps.- Hide quoted text -

- Show quoted text -

Sep 19 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.