Solved

How to generate a DB2 Trap (.TRP) file on Windows XP / Win2KSvr

Posted on 2004-10-11
11
971 Views
Last Modified: 2010-05-18
I am getting an exception followed by a crash in the DB2SYSCS.EXE process. I was looking for a trap (.trp) file to help me report the problem to IBM. However I haven't been able to generate a trap file.

I am using Enterprise Server on Win2K and WinXP. No trap files are generated on either platform.

I did use the DB2NSTCK utility to generate a trap file (as was descriped in the help files) - this gives me a Pxxx.000 file (where xxxx is the pid of db2syscs.exe).  If I try to generate a pxxxx.000 before the db2syscs.exe crashes the .000 file is generated, but dosen't help. If I run the utility after the crash occurs then no .000 file is generated.

Please HELP !! Thank you in advance.
0
Comment
Question by:adityakakrania
  • 3
  • 3
  • 2
11 Comments
 
LVL 4

Expert Comment

by:bondtrader
ID: 12288892
If you haven't reported the problem to IBM yet, go ahead and report it and they will tell you how to supply the information they need....
0
 

Author Comment

by:adityakakrania
ID: 12289393
They told me to give them a Trap file. Can anyone help?
0
 
LVL 4

Expert Comment

by:bondtrader
ID: 12290193
I'm not so sure you should be looking for a .trp file; did they actually say the file should have a .trp extension?   I believe trap files are automatically generated by DB2 and exist with a .000 extension in your sqllib\db2 directory along with the always important db2diag.log.  Recreate your problem and look at the contents of your sqllib\db2 directory for diagnostic files....I could be wrong though, I'm more of a Unix guy!
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 13

Expert Comment

by:ghp7000
ID: 12291794
yes, I beleive that support would ask you to run db2support or take a trace, are you sure you are not getting mixed up?
0
 

Author Comment

by:adityakakrania
ID: 12298980
Thanks for responding bondtrader and ghp7000 -- I did speak to my IBM-DB2 contact and they said that I should be generating a .TRP file in case of an exception.

I just thought of something though .. do you know which process is responsible for receiving the signal which compiles the data and generates the .TRP file? I hope its not db2syscs.exe, because that's the process which crashes after the exception !!

Any comments?
0
 
LVL 13

Accepted Solution

by:
ghp7000 earned 500 total points
ID: 12315797
0
 

Author Comment

by:adityakakrania
ID: 12335547
hi ghp7000,

this link ..

http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin/c0008938.htm?resultof=%22%74%72%61%70%22%20%22%66%69%6c%65%73%22%20%22%66%69%6c%65%22%20

.. takes me to an empty page.

About an hour back I redid all of my original steps to try and get the .TRP files; and this time it worked. DB2 is now generating .TRP files when the exception occurs.

Thank you both for trying to help. I appreciate it.
0
 
LVL 13

Expert Comment

by:ghp7000
ID: 12358450
well, i just tried the link I gave you and I don't get an empty page, perhaps you have your internet security settings set too high
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Find Value column 2 does not work 1 187
db2 how to connect to remote database from my 3 339
Access to SYSIBM tables 7 103
iSeries DB2 - Query with Sub Query? 7 108
November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

774 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question