• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1052
  • Last Modified:

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

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
adityakakrania
Asked:
adityakakrania
  • 3
  • 3
  • 2
1 Solution
 
bondtraderCommented:
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
 
adityakakraniaAuthor Commented:
They told me to give them a Trap file. Can anyone help?
0
 
bondtraderCommented:
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
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
ghp7000Commented:
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
 
adityakakraniaAuthor Commented:
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
 
adityakakraniaAuthor Commented:
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
 
ghp7000Commented:
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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now