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. 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 ;-)
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
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.
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?
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.
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 -
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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. ...
|
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...
|
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....
|
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...
|
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...
|
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...
|
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...
|
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:
...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |