$ d b 2 l e v e l

D B 2   v e r s i o n

D B 2 1 0 8 5 I     I n s t a n c e   " d b 2 i n s t 1 "   u s e s   " 3 2 "   b i t s   a n d   D B 2  

c o d e   r e l e a s e   " S Q L 0 8 0 1 4 "   w i t h   l e v e l   i d e n t i f i e r  

" 0 2 0 5 0 1 0 6 " .

I n f o r m a t i o n a l   t o k e n s   a r e   " D B 2   v 8 . 1 . 0 . 3 2 " ,   " s 0 3 1 0 2 7 " ,  

" M I 0 0 0 6 0 " ,   a n d   F i x P a k   " 4 " .

P r o d u c t   i s   i n s t a l l e d   a t   " / o p t / I B M / d b 2 / V 8 . 1 " .

T h i s   c a n   b e   m a t c h e d   t o  

r e l a t e d   F i x P a k   d i r e c t o r y  

T h e   b u i l t   d a t e  

o n   f t p . s o f t w a r e . i b m . c o m

( Y Y M M D D )

Figure 9 4   Sample db2level output

db2support utility

The 

db2support

 utility is designed to automatically collect all DB2 and system 

diagnostic data. This program generates information about a DB2 server, 

including information about its configuration and system environment.

The output of this program is stored in one compressed file named 

db2support.zip

, located in the directory specified as part of the command invoked 

at the command line.

In one simple step, the tool can gather database manager snapshots, 

configuration files, and operating system parameters, which should make the 

problem determination quicker. Below is a sample call of the utility:

db2support .  d db2_emp  c

The dot represents the current directory where the output file is stored. The rest 

of the command is optional.

  d 

and 

 c

instructs the utility to connect to the 

db2_emp

 database, and to gather information about database objects such as 

table spaces, tables, or packages. 

DB2 Technical Support site

An invaluable place to look if experiencing a problem is the 

DB2 Technical 

Support 

site for Linux, Windows, and UNIX located on the Web at: 

http://www.ibm.com/software/data/db2/udb/winos2unix/support

 Chapter 9. Testing and tuning 

283