How to generate db2support files

11 September,2014 by Jack Vamvas

Question: I’m troubleshooting a DB2 server performance issue. How can I gather  some general DB2 server and process  information and send to a DB2 professional for problem resolution.

Answer: One method is to use the db2support command. This example generates a files connecting to a database. I've added some extra options to consider

db2support . -d my_db_name -c -g -s –f

-c     connect to database
-g    run on global hosts
-s system detail
-h 10h 
-m dump output into html files

Read More on getting DB2 support

How to report a DB2 performance problem

Author: Jack Vamvas(


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to generate db2support files

Comments are moderated, and will not appear until the author has approved them. | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright