Important db2 utilities?

[solanki123]

Can anybody tell me what are the important db2 utilities
those are used frequently.

 

[MarcLodge]

I think you need to define your question a little better. At the moment I could name: Image copies, runstats, load, unload etc. but these might be regarded as functions. You could be talking Spufi or other mainframe related utilities (DSNTEP2 etc.).

Please give us more info in order to answer your question better. At the moment it sounds like something off an exam paper!

 

[gregsimpson]

Solanki123

I agree with Mark. Developers may use different utils to DBA's etc.

Starter for 10 below anyway.

LOAD
UNLOAD
IMPORT
EXPORT
CHECK
COPY
RUNSTATS
RECOVER
REORG
QUIESCE
REPORT
MODIFY

Is there a specific task your trying to accomplish?

Cheers
Greg

 

[solanki123]

Hi Greg you have written me exactly what I wanted.
Actually I am exploring my db2 knowledge.
I have great interest in db2 and I want to be db2 DBA.
Thanks to you and Mark.
Can you tell me where can I find the details of these
utilities.

 

[MarcLodge]

Laudable aspirations Solanki!

The utility guide and reference can be found at:

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnugh14/CCONTENTS

Good luck

Marc