473,320 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to recover the db2diag.log file

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
6 5538
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: WKC | last post by:
Recently, one of our database's mdf and ldf was corrupted. We were able to bring back the database with the capability of importing and querying the data. However, the data is not the full list. ...
3
by: xixi | last post by:
we are using db2 udb v8.1 on win 64 bit with fp3 with type 4 db2jcc.jar driver. i got some error extract from db2diag.log file, can someone explain me what this mean? ID:1788 TID:3492...
7
by: Shawn | last post by:
We are on IBM DB2 7.1 ON WINDOWS. The db2diag.log is not working and no new line written into it for few days. The last lines in db2diag.log shows: Warning: active log held by dirty pages....
2
by: soccertl | last post by:
I wrote code that parses the db2diag.log to look for errors that would require us to generate a message to a service center indicating something is wrong. My problem is trying to figure out what...
4
by: Praveen_db2 | last post by:
Hi All I am getting strange errors in my db2diag.log can any one tell me what these errors mean?? Following is the code from my db2diag.log...
3
by: ariel | last post by:
Hello, I am running DB2 version v8.1.3.88 on a Sun v40z server running RedHat Linux AS 4 kernel version 2.6.9. My problem is that the db2diag.log file is growing without bounds (I just deleted a...
14
by: Gio Galma | last post by:
how I can invoke the db2diag utility in a Windows environment? in my D:\Program Files\IBM\SQLLIB\BIN directory I can see only db2diag.dll, and it seems there isn't the command line version; which...
1
by: oddbande | last post by:
We have just upgraded a test enviroment to db2 9, and have set both the notifylevel and diaglevel to 3. But even so I get a lot of these messages in my db2diag.log: ...
5
by: Norm | last post by:
Does anyone have any suggestions for securing against this vulnerability: http://nvd.nist.gov/nvd.cfm?cvename=CVE-2007-1027 Fixes are not yet available from IBM. They will be in FP2 for V9...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.