Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-10-11
11
Medium Priority
?
1,008 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Understanding Linux Permissions

Linux for beginners: How to view the permissions associated with files and directories and also how you can change them.

 
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

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…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

721 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