Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2004-10-11
11
Medium Priority
?
1,066 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
8 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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…

584 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