Solved

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

Posted on 2004-10-11
11
978 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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

792 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