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 5613
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. Some of the data are still
missing because the tables we want still has sone 'chain mis linkage' error
when we did a DBCC checkdb/checktable. DBCC couldn't fix those errors
either. We're pretty sure that there are some data still burry under the...
|
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 Node:000 Title: section stmt
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000
|
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.
Decrease softmax and/or increase num_iocleaners.
repeatedly . What is the problem? How can resolve it quickly? The
applicatipna dnLDAP is up and running though.
|
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 the errors
are. From studying the log, I noticed the codes on the first line after
the date/time are all the same for the same message. For example:
2005-11-17-09.55.31.988098-420 E5537C330 LEVEL: Error (OS)
PID : 21700 ...
|
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
*********************************************************************************************
2006-02-23-17.53.12.253000 Instance:DB2 Node:000
PID:1600(db2syscs.exe) TID:440 Appid:AC10E010.J70A.00E883122250
base sys utilities sqleagnt_sigsegvh Probe:1 Database:DEVM_DB
Error in agent...
| |
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 1.7
terabytes file!). I have tried setting the DIAGLEVEL parameter to low
values (even to zero), but that did not solve the problem.
The error that keeps being copied to db2diag.log is the following:
|
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 is
the DB2 tool that uses this dll, in order to analyze the db2diag.log?
thank you in advance for help (and please, excuse my bad english)
Jo
--
|
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:
2006-11-02-00.10.11.951000+060 I326548H465 LEVEL: Info
PID : 3008 TID : 4072 PROC : db2dasstm.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.061101231048
FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive,...
|
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 and
FP15 for V8.
Would changing the permissions on the db2dump directory so that only
instance owner has access be enough?
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |