473,396 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > db2 database > questions > extract from db2diag.log

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

extract from db2diag.log

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

PID:1788 TID:3492 Node:000 Title: sibling_ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sibling_ptr->common->section_len
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sibling_ptr->cache_cb
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sibling_ptr->cache_cb.cached_sectptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sectLen
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: the_section
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: Unrelocation Needed
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: Section relocated; reltables dumped
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: section ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: section size
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic size
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: shared dynamic ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: shared dynamic size
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic section header
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: offset in section
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: opcode
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: agg_mode
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: section1
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic buffer
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

2004-01-12-14.07.19.640000 Instance:DB2 Node:000
PID:1788(db2syscs.exe) TID:3492 Appid:AC100419.GE15.00FA0B741336
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:NJIPD

Private workspace info dumped! Check
D:\PROGRA~1\IBM\SQLLIB\DB2\a17883492.000 for additional data.

2004-01-12-14.07.20.460000 Instance:DB2 Node:000
PID:1788(db2syscs.exe) TID:3492 Appid:AC100419.GE15.00FA0B741336
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:NJIPD

Shared workspace info dumped! Check
D:\PROGRA~1\IBM\SQLLIB\DB2\a17883492.000 for additional data.
Nov 12 '05 #1
3 3020

"xixi" <da****@yahoo.com> wrote in message
news:c0**************************@posting.google.c om...
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

PID:1788 TID:3492 Node:000 Title: sibling_ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sibling_ptr->common->section_len
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sibling_ptr->cache_cb
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sibling_ptr->cache_cb.cached_sectptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: sectLen
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: the_section
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: Unrelocation Needed
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: Section relocated; reltables dumped
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: section ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: section size
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic size
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: shared dynamic ptr
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: shared dynamic size
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic section header
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: offset in section
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: opcode
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: agg_mode
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: section1
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

PID:1788 TID:3492 Node:000 Title: dynamic buffer
Dump File:D:\PROGRA~1\IBM\SQLLIB\DB2\17883492.000

2004-01-12-14.07.19.640000 Instance:DB2 Node:000
PID:1788(db2syscs.exe) TID:3492 Appid:AC100419.GE15.00FA0B741336
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:NJIPD

Private workspace info dumped! Check
D:\PROGRA~1\IBM\SQLLIB\DB2\a17883492.000 for additional data.

2004-01-12-14.07.20.460000 Instance:DB2 Node:000
PID:1788(db2syscs.exe) TID:3492 Appid:AC100419.GE15.00FA0B741336
access plan manager sqlra_sqlW_raw_dump Probe:25 Database:NJIPD

Shared workspace info dumped! Check
D:\PROGRA~1\IBM\SQLLIB\DB2\a17883492.000 for additional data.


This means that a DB2 agent crashed. You should call IBM support and open a
PMR -- this shouldn't happen.
You should have a file called t17883492.000 and a directory called
c17883492.000 in ~/sqllib/db2dump -- the support people will ask for this.

--
Matt Emmerton
Nov 12 '05 #2
sorry, we are using trial version and no support possible. any idea?
Nov 12 '05 #3
Even I am facing the same issue of the logs being created in the dump folder. Could you do away with that error? It will be really very helpful if you can provide with some input on this in case you have any tips.

Thanks in advance,
Sayali
May 3 '06 #4
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
db2diag.log not writing
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....
DB2 Database
3
Any tool to monitor db2diag.log?
by: richardshen | last post by:
Instead of watching it manually.
DB2 Database
2
Parsing errors in db2diag log
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...
DB2 Database
4
Strange Errors in db2diag.log
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...
DB2 Database
14
invoking db2diag tool on win32 (UDB 8.1 version)
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...
DB2 Database
1
Info-messages i db2diag.log even if diaglevel set to 3
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: ...
DB2 Database
5
Work around for db2diag.log vulnerability?
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...
DB2 Database
6
How to recover the db2diag.log file
by: KG | last post by:
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.
DB2 Database
0
DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130 in db2diag.log
by: eddy82 | last post by:
Hi All, I have this db2start in my db2diag.log everyday around the same time. But no db2stop in the db2diag.log or in the db2.nfy. I already check and no corruption or cronjob running during...
DB2 Database
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
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...
Online Marketing
0
The easy way to turn off automatic updates for Windows 10/11
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...
Windows Server

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!